Bug 364487 - I wish I could hide accounts / categories in reports AND roll up there amount in parent
Summary: I wish I could hide accounts / categories in reports AND roll up there amount...
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.7.2
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-19 09:32 UTC by Hugo
Modified: 2016-06-20 21:25 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Hugo 2016-06-19 09:32:52 UTC
When I configure reports, I can easily hide sub-accounts or sub-categories BUT I loose there amount in the report : the report is not balanced any more since hidding means cancelling it from the report.

A great feature would be the ability to check / uncheck an option to keep (or not) the amount in the parent account / categorie, like it does naturally on the "account" view.

Reproducible: Always

Steps to Reproduce:
1. Make sub-categories with money in them
2. Hide them in a custom report
3. The money has vanished from the report

Actual Results:  
3. The money has vanished from the report

Expected Results:  
I would like the money to show up in the parent account

Very usefull for taxe declaration preparation.
Comment 1 Jack 2016-06-19 16:07:11 UTC
By "hiding" do you actually mean not including them by unchecking them on the configuration page?  As you realize, that is not hiding them, it is not including them at all.  I think one way to describe what you want is to have separate "include" and "display" checks for each account/category/...

Have you tried exporting the report to excel?  It would still be work, but not require manually redoing the sums.
Comment 2 Hugo 2016-06-20 04:08:50 UTC
Yes, I do actually mean not including them by unchecking them on the configuration page.

I do realize that for now it is not only hiding them, but not including them at all : this is my concern since I believe I'm not supposed to suppress an account in a balanced double entry book.

Choosing betwin "include" and "display" checks for each account/category/... would be perfect.

I will definitely consider exporting my reports to open office : I believe this will be the best workaround for me now.
Comment 3 Hugo 2016-06-20 06:43:24 UTC
As I'm working on a calc sheet as a workaround, I'm also considering this : there could be 2 types of amounts in each account / categorie : the amount of the account / categorie itself AND the cumulative amount of all sub accounts / categories of each of them.

This sounds great to me :

Example :

Account : amount / cumulative ammount

Assets : 0 / 101,000

Buildings : 0 / 100,000
Building 1 : 10,000 / 10,000
Building 2 : 90,000 / 90,000

Money : 0 / 1,000
Check account : 500 / 500
All saving accounts : 0 /1,000
saving account 1 : 500/ 500
saving account 2 : 500 / 500
Credit card : - 500 / -500

(assuming that credit card has been set as a sub-asset with a negative value, and not as a liability)
Comment 4 Jack 2016-06-20 15:10:15 UTC
(In reply to Hugo from comment #2)
While I am not formally trained in accounting, I don't think there is any problem suppressing accounts in a report.  In fact, I don't see this as suppressing anything, you are just reporting summary information, not full details.
Comment 5 Hugo 2016-06-20 21:25:57 UTC
KMM is a double entry accounting software : if you use it accordingly, all entries and outs should balance. If an account is suppressed, you're then off balance.