wish: balance report to select several accounts

Bug #1594684 reported by Chris
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
HomeBank
Fix Released
Wishlist
Maxime DOYEN

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:

Bank
> 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. :)

Tags: report account
Revision history for this message
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).

Revision history for this message
Aroop Roelofs (q-me-c) wrote :

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

Maxime DOYEN (mdoyen)
Changed in homebank:
importance: Undecided → Wishlist
Maxime DOYEN (mdoyen)
tags: removed: equity
Maxime DOYEN (mdoyen)
tags: added: account
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

If the Balance report would allow the selection of multiple accounts to show data from, this would be doable already;
=> in progress

Changed in homebank:
assignee: nobody → Maxime DOYEN (mdoyen)
status: New → Confirmed
milestone: none → 5.5.1
Maxime DOYEN (mdoyen)
Changed in homebank:
status: Confirmed → In Progress
Maxime DOYEN (mdoyen)
summary: - wish: equity report (net balance on all 'credit card' accounts)
+ wish: balance report to select several accounts
Maxime DOYEN (mdoyen)
Changed in homebank:
status: In Progress → Fix Committed
Maxime DOYEN (mdoyen)
Changed in homebank:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.