[kmymoney] [Bug 431373] Incorrect Balance Values in Reconcile View of Ledger

[bugzilla_noreply at kde.org]

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

--- Comment #2 from alrtzgkse7o9 at opayq.com ---
Thank you for the quick response.

>First, reconciling it not really supported for Investment accounts.
Right. I was told the same thing when I asked in chat. I am primarily
reconciling to move the Last Reconciled bar with no concern for the cash value;
I also manually verify the security balances affected during the period, which
is where I noticed that they were not adding up correctly.


>Also note (I don't know if it affects your case) the balance in an investment ledger is the currently owned number of shares of the security reference in that transaction, not any sort of account grand total or value.
I am aware of the distinction that the balances (or number of shares) are
specific to each security. The number of total shares for the affected security
are inaccurate when reconciling, yet accurate in the non-reconcile ledger view.


>I assume your line "--investment account reconciled--" indicates the divider bar in the ledger from a previous reconciliation.
Correct. 


>Also, your numbers do not make any sense.
Whoops. Corrected (and expanded) values here and in my original attachment.

OBSERVED RESULT

[Ledger View, not reconcile]
1. Buy 32.74 shares -> Balance: 32.74
--investment account reconciled--
2. Buy 2.904 shares -> Balance: 35.644
3. Buy 0.203 shares -> Balance: 35.847
4. Buy 2.622 shares -> Balance: 38.469
5. Buy 2.590 shares -> Balance: 41.059


[Reconcile (ledger)]
--Last reconciliation--
1. Buy 2.904 shares -> Balance: 37.730
2. Buy 0.203 shares -> Balance: 37.933
3. Buy 2.622 shares -> Balance: 40.555
4. Buy 2.590 shares -> Balance: 43.145

EXPECTED RESULT

[Ledger View, not reconcile view]
1. Buy 32.74 shares -> Balance: 32.74
--investment account reconciled--
2. Buy 2.904 shares -> Balance: 35.644
3. Buy 0.203 shares -> Balance: 35.847
4. Buy 2.622 shares -> Balance: 38.469
5. Buy 2.590 shares -> Balance: 41.059

[Reconcile (ledger)]
--Last reconciliation--
1. Buy 2.904 shares -> Balance: 35.644
2. Buy 0.203 shares -> Balance: 35.847
3. Buy 2.622 shares -> Balance: 38.469
4. Buy 2.590 shares -> Balance: 41.059


>Also, after reconciliation, you should still have the two buy transactions.  Are there any other transactions displayed?
Yes, I have dozens of transactions afterwards for the affected security
throughout the year, among some other securities. I did not have an easy way to
redact the remaining transactions from my original screenshot. I have added
further entries to the OBSERVED RESULT section.

In the reconciliation ledger view, the balance for the first transaction is
incorrect. The subsequent math is valid for transactions and their change in
the balance (number of total shares for the security), but the balance is
incorrect due to the first transaction share count being incorrect.

>Separately, if you can provide a sample .kmy  or .xml file which demonstrates the problem with a credit card account, that would help.
If it happens, again, I'll find a way to share the data. The affected data was
in a SQLite3 database that I wrote off as a one-off quirk of SQLite3 and
deleted. After restoring from a .kmy (XML) backup and re-entering the credit
card transactions, the values were correct. 


FURTHER THOUGHTS

(this is a stretch and I don't think it should be related, but adding just in
case) 
I've also recently been using the CSV importer. I can't say for certain at this
point (it was several weeks ago), but I may have imported the credit card
transactions in the original situation. For certain, I can say that I have
imported the last few months of transactions related to the affected investment
security. However, all of the transactions and splits for the affected account
retrieved by getsplitpart.pl appear valid and add up correctly. 

Is there somewhere else in the XML file that is touched by the CSV importer
that could be referenced by the reconcile wizard when it is calculating its
version of the ledger?

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