wish: equity report (net balance on all 'credit card' accounts)

Bug #1594684 reported by Chris on 2016-06-21
This bug affects 2 people
Affects Status Importance Assigned to Milestone

Bug Description

After migrating from GNUCash, I expected I might be able to cajole HomeBank's Balance or Statistics reports into producing the data that I need, but it seems not to be the case.

If the Balance report would allow the selection of multiple accounts to show data from, this would be doable already; it doesn't need to be a new report per se.

Essentially the math to work out your equity is ((Income - Expenses) - (Assets - Credit)); but since HomeBank is a little 'lighter' on that accounting stuff, the net balance of a sum of all Credit Card accounts would suffice.

For instance, in my accounts:

> Checking acct 300.00 | 350.00 | 500.00
> Savings acct 100.00 | 200.00 | 300.00

Credit Card
> Auto loan 2,000.00 | 1,900.00 | 100.00
> Credit card 1,000.00 | 1,000.00 | 50.00

Then, the sum of my equity can be worked out like this:
Bank is assets, so I have 400.00 reconciled in the bank.
Credit card is liability, so I have 3,000.00 reconciled.

3,000.00 - 400.00 = 2,600.00. Which means, I have a negative equity right now of -2,600.00. Once I've begun paying off my loans (Future amount), keeping in mind my Future bank balances of a combined 800.00, I have a Future equity of ((500.00 + 300.00) - (100.00 + 50.00)) which is 650.00.

However, if I could just see my net credit balance, with a line graph, and be able to see when I owe a negative combined credit balance it would be a feature I would appreciate. :)

Chris (chris-neary) wrote :

After posting this request, I'm reminded that the Grand Total on the main screen basically functions as an equity balance, so it would be nice to be able to plot that balance on a line graph along Time (with datapoints for each month, or even day, etc).

Aroop Roelofs (q-me-c) wrote :

I agree, I t would be really nice to have this feature.

Maxime DOYEN (mdoyen) on 2016-10-15
Changed in homebank:
importance: Undecided → Wishlist
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers