Bug 450653

Summary: Credit card balances are wrong in net worth report
Product: [Applications] kmymoney Reporter: lp.allard.1
Component: reportsAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: RESOLVED FIXED    
Severity: major    
Priority: NOR    
Version: 5.0.8   
Target Milestone: ---   
Platform: Mint (Ubuntu based)   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: Ledger

Description lp.allard.1 2022-02-21 14:10:42 UTC
Initially posted to the maillist but I realize KDE bugtracker is the right place to document this and get resolution.  This is a 2 part bug ticket as I think they are closely inter-related (hence why I created a single bug ticket).


*************Part 1/2 of this ticket*************

I have noticed that using a yearly report of net worth, the balance of my credit card under the Liability section is negative (and in red), and therefore gets ***substracted*** from the total of the liability.

I do not understand this.  All other liabilities are positive (and black) and by doing so, its like if the total of the liability was artificially decreased by the balance of the credit card....  Should be the opposite.

Example:
      Assets
            Chequing account: 10,000
            Car: 8,000
            Investments: 350,000
      TOTAL ASSETS: 368,000
      Liabilities
            Mortgage: 250,000
            Line of credit: 50,000
            Credit card: -5,000
      TOTAL LIABILITY: 295,000  (while it should be 305,000) !!!
      NET WORTH: 73,000   (while it should be 63,000) !!!

Is this normal?

Thomas Beaumgart said in bug https://bugs.kde.org/show_bug.cgi?id=369608:
"Liability accounts are shown with reverse sign to better match the statements sent out by financial institutions. You could also take a look at reports which will show your funds on the credit card account as negative liabilities (which are in fact assets)."

However, in my case the other liabilities (mortgage, line of credit, etc) are all positive numbers and are counting towards the total of liabilities in the intended way (see my example above).

*************Part 2/2 of this ticket*************

Additionally, the balances displayed seem way too high (they are all over 5000$ CAD) which is impossible, the credit card has a limit of 3000$ CAD.  How is this amount calculated?  Is it calculated by summing up all transactions during the year, or is it the balance of the card on Dec 31 of each year?  If balance on Dec31 then there is a major issue...

I thought the amount presented in the report was the sum of all payments done on the card during the year, but I confirm this is NOT the case as for example, in 2021, I paid 15,022$ on the card.  The report says 4,763$.....

LEDGER transactions are all OK.  This ticket only relates to reports and not the ledgers or other functions of KMM (at least I could not see this bug impact other areas of KMM).

KMM  5.0.8
KDE Frameworks 5.68.0
Qt 5.12.8 (built against 5.12.8)
The xcb windowing system
MySQL database backend
Comment 1 Thomas Baumgart 2022-02-21 18:16:07 UTC
I suppose you have reversed some/most transactions in the credit card account. The payment column should contain deposits on the credit card account. The charge column should contain the purchases you made. Could that be? The balance is calculated by adding the amount of all (not only the current year but all of them) splits referencing an account, so the Dec 31st problem cannot occur. A credit card with a negative balance means an available asset. 

Are you dealing with multiple currencies in the affected accounts or are they all denominated in CAD?
Comment 2 lp.allard.1 2022-02-21 23:28:46 UTC
Hello Thomas,

No I have not reversd the transactions on the card.  Each time I use the card to buy something, I create a CHARGE on the account, and when I pay I create a PAYMENT to the card.

Charges increase the balance of the card (which is shown in RED in the ledger), and payments decrease the balance.  Works as intended AFAIK...

See screenshot.

All transactions are in CAD on this credit card (since opening the account), and I have only one card.




(In reply to Thomas Baumgart from comment #1)
> I suppose you have reversed some/most transactions in the credit card
> account. The payment column should contain deposits on the credit card
> account. The charge column should contain the purchases you made. Could that
> be? The balance is calculated by adding the amount of all (not only the
> current year but all of them) splits referencing an account, so the Dec 31st
> problem cannot occur. A credit card with a negative balance means an
> available asset. 
> 
> Are you dealing with multiple currencies in the affected accounts or are
> they all denominated in CAD?
Comment 3 lp.allard.1 2022-02-21 23:29:31 UTC
Created attachment 147026 [details]
Ledger
Comment 4 Bug Janitor Service 2022-03-08 04:35:44 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 5 Bug Janitor Service 2022-03-23 04:35:23 UTC
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!
Comment 6 Thomas Baumgart 2022-03-23 06:48:09 UTC
Reopening as it is not (yet) resolved.
Comment 7 lp.allard.1 2023-01-18 03:13:09 UTC
Documenting that this issue is still relevant in kmymoney-5.1-360-linux-gcc-x86_64.AppImage.  As a matter of fact, I am performing a yearly update of my personal finances, and the Net Worth report I just generated makes absolutely NO sense...

The report is set to yearly data.

1.  The balance of Cash assets is WAY off (about 5-6 times the actual total value of all of my cash assets)...  Not sure how KMM generates that number.

2.  The yearly amounts of my credit card are all negative (in RED with minus sign) and the numbers are all at least 2x too high

Generally speaking, I think KMM is miscalculating the numbers of the "rolling" accounts (i.e. accounts with a lot of credits sand debits such as chequing accounts or credit cards).  If I look at "steadily changing" accounts (example mortgage or line of credit with a known balance and recurring  equal or unequal payments) KMM seems to be calculating the right balance...
Comment 8 lp.allard.1 2024-02-05 02:17:14 UTC
I am happy to report that with AppImage 5.1-606 all of these reporting issues seem to be fixed.

The Net Worth report totally aligns with the Accounts window for ALL accounts, and the balances are all aligned with the ledgers.

The credit card balance is no longer negative (in red) and is computer properly (Assets-liabilites = net worth).