| Summary: | Running Balance and Reconciliation balance do not match | ||
|---|---|---|---|
| Product: | [Applications] kmymoney | Reporter: | Jesse <JesGeiger> |
| Component: | general | Assignee: | KMyMoney Devel Mailing List <kmymoney-devel> |
| Status: | RESOLVED NOT A BUG | ||
| Severity: | normal | ||
| Priority: | NOR | ||
| Version: | 5.1.2 | ||
| Target Milestone: | --- | ||
| Platform: | Microsoft Windows | ||
| OS: | Microsoft Windows | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | Reconciliation Balance Screenshots | ||
My apologies for the long comments. I did some troubleshooting over the past few days. My only workaround to the original issue was to create an additional checking account in the same file and move transactions 1 statement at a time and then reconcile in the new account. This worked for a while and I got past the time period shown in my first attachment, but then it appeared again later but for a different amount ($323.52). At a loss, I scrolled through the transactions and noticed that a few were "bold" and realized that they were not marked as cleared. (Yes, you can start laughing/mocking this guy for something simple). Once marked as cleared the balances matched up and I could continue the reconciliation. Though I am quite sure that I marked them as cleared before reconciling. I'm getting old. However, back to the original problem, how can this be addressed for other users that won't recreate and reprocess and entire bank account (hey, I am doing this for my primary account from 2008 until today)? Somewhere I missed a $3 transaction but processed the reconciliation. - I couldn't add a fake transaction as it would throw off the real running balance - I couldn't adjust the reconciliation balance as it wouldn't match - If the $3 transaction was later reconciled, it wasn't affecting/correcting the balance - I saw another user Wish for the ability to change the starting balance in the wizard, but agree with you that that is not a good idea as it means that something is wrong. I was also considering improvements to the reconciliation wizard input box, like the preloaded ending balance that only sums transactions that are already marked as Cleared instead of the entire statement period, but in thinking about it, it makes complete sense. If they don't match up, something is wrong. Thanks for listening, and unless you want/need to address the issue above, we can mark this as closed. One bit of advice is that whenever my reconciliation totals don't match or are not what I expect, I filter the ledger. First I look at "not marked" transactions, then at "not reconciled." For me, at least, one of these has always led me to something I had forgotten, such as a check I wrote months ago which has still not been cleared. If you can think of any other advice, I can include it in the handbook, which is currently undergoing a complete review in preparation for the eventual release of 5.2, from master branch, although there is not yet any timeline. Improved text for within the reconciliation wizard itself will also be considered. |
Created attachment 162326 [details] Reconciliation Balance Screenshots SUMMARY *** Running same file on both Win 10 x64 and Debian 12 x64. Only 1 account out of many (like 50) has this problem. I have searched for an extra $3 transaction somewhere, but that would then throw off the correct balance. The account settings do not have any values for balance or limits. There are numerous transfers to and from other accounts, but they all add up correctly and all other accounts reconcile perfectly. The running balance for this account is correct, but when I start the reconciliation wizard it is off by $3.00, and the cleared balance does not match the running balance for the end of the statement period. Screenshots in attached Word doc. I have also moved ALL transactions for this account to a new account, but the problem still exists. I will continue to try other things (I've been playing around for months) but thought it was time to see if you ran into this before. *** STEPS TO REPRODUCE 1. No idea except to send my file. OBSERVED RESULT 1. In screenshots, wizard starting balance does not match previous reconciled balance for this one account. 2. Reconciliation wizard cleared balance does not match running balance for statement period. EXPECTED RESULT balances should match in the appropriate areas. SOFTWARE/OS VERSIONS Edition Windows 10 Pro Version 22H2 OS build 19045.3570 Experience Windows Feature Experience Pack 1000.19052.1000.0 KMM: Version 5.1.2-99be6bdb1 ADDITIONAL INFORMATION