[kmymoney] [Bug 450653] New: Credit card balances are wrong in net worth report

[bugzilla_noreply at kde.org]

https://bugs.kde.org/show_bug.cgi?id=450653

            Bug ID: 450653
           Summary: Credit card balances are wrong in net worth report
           Product: kmymoney
           Version: 5.0.8
          Platform: Mint (Ubuntu based)
                OS: Linux
            Status: REPORTED
          Severity: major
          Priority: NOR
         Component: reports
          Assignee: kmymoney-devel at kde.org
          Reporter: lp.allard.1 at gmail.com
  Target Milestone: ---

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

-- 
You are receiving this mail because:
You are the assignee for the bug.