Darn, hit 'send' too fast! Added another paragraph below... On Wed, Jan 25, 2017 at 4:05 AM, Oon-Ee Ng <[email protected]> wrote: > I'm looking to estimate an annual/monthly budget, and the simplest way > I thought of to do that was to look at my annual expense reports (I > have data for almost a decade) to see trends (spending on books and > education related stuff is way up due to having young children, as are > spendings on food and insurance, while spending on eating out is down > slightly). > > There's some pretty big holes in the data I'm looking at though, and > it's primarily because of debt. I'm paying off a housing loan monthly > (to the tune of a quarter of take-home pay, to get it done quickly), > and that does not show up in expense reports (the only thing that > shows there is interest accrued, which isn't much compared to the > amount I'm actually paying). > > Obviously, the reason is because paying off a housing loan is (as I > model it) a transaction between my cash-in-hand/banking assets and the > large liability account called "HousingLoan". I *think* this is > standard accounting. > > However that means that my annual/monthly budget, if only based on > expenses data, will miss this amount, and really I'm primarily > interested in balancing my cashflow rather than expenses. That is to > say, if I take home X amount, my cash outflow should be less than X. > If my monthly housing loan payments are Y, that means I need to budget > against X-Y rather than X itself. > > Is there a way to generate reports on cashflow? Probably just > 'everything that flows out of assets' would suffice at this point?
Although now that I think about it, that would not model my self-enforced savings (which are modeled as a transfer from Assets:Banking:MyBank:Account to Assets:Investments:MyBroker:AccountName or even Assets:Banking:MyBank:FixedDeposit). Not just the local equivalent of 401k, but things like fixed deposits and scholarship funds. Ideally I'd like to be able to see a number (monthly/annually) showing how much money flowed from my cash-in-hand and equivalent accounts (credit cards, savings/current accounts) to expenses+loans+long-term-savings. I think that'd give me the base of a budget. -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAGQ70esFrNABHHfe3OaCZcnUoAYpD507kfXG-3t4RCRGLqdZCw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
