budgeting shortfalls
Chris Shoemaker
c.shoemaker at cox.net
Fri Dec 28 08:45:24 EST 2007
On Thu, Dec 27, 2007 at 04:52:49PM -0800, Thomas Bushnell BSG wrote:
> So with the impending new year, it's time for me to deal again with
> budgeting the next year.
>
> I currently use a spreadsheet to do this. There are some things I have
> with my spreadsheet that gnucash does not seem to make simple for me. I
> would much like to use the gnucash budgeting widget! But yet...
>
> I start by making an income/expense budget.
>
> I have a column for the year's total, and a column for each month.
>
> Historically my income has been irregular, but predictable, so I enter a
> separate income budget entry for each month/source combination, and then
> the source's yearly amount is a summation.
>
> Expenses I simply budget an annual amount.
>
> Then I have a nice idea of the relationship of income to expenses.
>
> But I also want a cash-flow budget. This is made my tracking cash
> debits (wages and interest, plus cashable liabilities like a new student
> loan). And, then, cash credits, where I take my total expenses and then
> make adjustments; there are a few expenses which are not paid from cash
> (like depreciation), and then there are cash credits which are not
> expenses (like loan repayments).
>
> And then the net cash flow is easily computed to be the excess of cash
> debits over credits.
>
> And, since my income is irregular, I think make a monthly chart. Each
> month I start with the cash balance, and add in the cash debits and
> credits for that month; the debits are easy b/c they just come from the
> month-by-month income (see above!) and the cash credits by dividing
> total cash credits in twelve.
>
> Assuming then that my expenses are really evenly spread (which they are,
> but for a few special ones) the month-to-month expected cash balances
> help me track my cash flow.
>
> And, the real nice beastie: each month I enter the current account
> expenses into the spreadsheet to see "how are my expenses doing". I
> compute a percentage of the amount expended against the month number
> divided by the annual amount. (So that if it's the end of May, and I've
> spent $500 of an annual $1200 amount, the percentage listed is 100%.)
>
> So to do this with gnucash, it seems to me that I want to set up an
> income/expense budget. But the rest of the nice things I do, I can't
> easily do. For example, if I were to make a separate cash budget (which
> seems sensible), then I want that cash budget to get most of its entries
> automatically copied from the expense budget: such that a change to the
> expense budget would be automagically reflected in the cash budget.
>
> And the budget report feature seems very sparse indeed, essentially
> incapable of doing more than just listing numbers.
>
> Am I missing some big thing, or should this be reduced to a sensibly
> organized feature request?
I don't think you're missing anything. The budgeting feature is
simple. It does little more than let you record the budgeted amounts
for various acounts and then generate a report comparing the recorded
amounts to the actual amounts.
-chris
>
> Thomas
>
>
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
More information about the gnucash-devel
mailing list