Ratio of savings to expenses
Mike or Penny Novack
stepbystepfarm at mtdata.com
Sat Nov 22 09:02:09 EST 2014
Rob Cussons wrote:
>Hi,
>
>I'm interested in outputting on a monthly basis the ratio of money I'm
>saving in certain asset accounts to my income from certain income accounts.
>Is there an easy way to output this using the reports feature in Gnucash?
>
>
>
Insufficient (you need to take more into account).
Of course it is possible you don't have any liability accounts to to be
considered, but in the general case there would be. So it would be the
NET changes you would need to be taking into account. Nor would it be
just certain income accounts ignoring all other possible ones and
ignoring expenses.
Suppose you ran the usual reports for an accounting period, Balance
Reports for the beginning and end of the period and an Income Statement
for the interval. The data from those would allow you to prepare a
report showing the deltas and let you compute that ratio.
Michael
PS: In theory, as long as your chart of accounts remained fixed, by
exporting all the way to spreadsheets you could automate the
calculations as you first describe as what you want. But I would
strongly recommend against that since:
1) The chart of accounts could change (accounts added, removed, merged,
etc.)
2) It takes a human eye to spot unusual events. For example, if you had
a large windfall income amount (in some OTHER income category) you might
have had a huge change in the specified asset account(a) but not related
to the specific income account(s). To be honest, I don't completely
understand the "specific" account thing as money is fungible << you
can't say which dollar of income represents which dollar in a savings
account, etc.>>
More information about the gnucash-user
mailing list