| Summary: | Credit card balances are wrong in net worth report | ||
|---|---|---|---|
| Product: | [Applications] kmymoney | Reporter: | lp.allard.1 |
| Component: | reports | Assignee: | 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 | ||
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? 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? Created attachment 147026 [details]
Ledger
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! 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! Reopening as it is not (yet) resolved. 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... 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). |
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