Sudden Bank Reconciliation Failure and Opening Balance Pos/Neg Flip

1

This is really weird and hard for me to understand/explain. While it’s possible I’m the problem, I can’t help but feel I encountered a bug or glitch.

The other day (honestly couldn’t say exactly when) I noticed bank reconciliations for a specific bank account (credit card) were off. Didn’t look at it at the time, made mental note for later.

I looked at the bank reconciliations, figuring I screwed up something very recently. Apparently not, every single bank reconciliation for this account going back to my creation of the manager file was wrong all the way back to late 2022.

Important to note is that I have the lock date set to 2024-12-31, so changes like this shouldn’t be possible.

I updated to the latest version of Manager, no change.

The history feature in Manager is a bit lacking, so I reached into my backups (I take once a day) and hunted for older versions of my Manager file until I found the date the issue apparently happened. I found two back-to-back versions where the problem began and started comparing.

Going to the bank account in each version, they both had the same number of total transactions (247). However, what was very obviously wrong was the opening balance. The good manager file correctly had a negative opening balance and the bad manager file incorrectly had a positive opening balance.

Good File Version

image
image1547×325 8.74 KB

Bad File Version

image
image1557×331 8.74 KB

And for good measure/to document it - no, I can’t edit the bank account’s opening balance. It’s locked as it should be.

image
image648×532 13.8 KB

The only theory/correlation I can draw is that I update Manager about once a week. My good file is dated 2025-11-01 and my (first) bad file is dated 2025-11-02. I apparently downloaded Manager version 25.11.2.3092 on 2025-11-02. Maybe it caused the issue.

I have yet to go back to my working/real/latest Manager file, remove the lock date, and correct the opening balance. Naturally I’m now very hesitant to change the lock date if there’s a bug in Manager.

Any words of wisdom or caution or reassurance? I can’t imagine how I did this myself based on the (minimal) history/changes between the good file and bad file. The only change is an inter account transfer between two completely different bank accounts.

Bank reconcilliation showing discrepancy from before first use..?
Feature Requests: Communicate "scripted" actions to end users
2

It’s probably poor netiquette to directly tag a developer but @lubos I am certain there’s a bug but it’s also specific to my manager file in some way which is troubling.

Problem repro steps:

  1. Setup brand new Windows 11 25H2 VM with all the latest updates
  2. Install Manager Desktop 25.10.26.3043
  3. Import manager file (the version from before there were any issues) - no issues with the bank account or reconciliations, opening balance is negative/correct
  4. Close and re-open Manager a few times, re-open the file, it’s still OK. Reboot the VM too, all the same - still good and stable.
  5. In-place update to 25.11.2.3092
    1. I separately tested a fresh installation, no difference to end result
  6. Open Manager/business - issue presents, the bank reconciliations are all wrong and the opening balance flipped to positive/incorrect.

I tried testing a few other things like:

  • Creating a fresh business file on the 25.10.26.3043 version with a negative opening balance on a bank account and then upgrading it to 25.11.2.3092 and the issue did not occur.
    • I also tested a separate database/file with the “can have pending transactions” setting set to true on the bank account. Issue still did not occur.
  • Running my business file/database through sqlite using the guidance here and it made no difference after re-testing the “open on 25.10.26.3043, update to 25.11.02.3092, re-open” - the issue still occurred.
  • I grabbed an archived/backup version of my Manager database from 2025-01-10. The issue still occurs after upgrading to 25.11.2.3092.
3

There was a recent script to change opening journal entries to open balances and it reversed some of the bank opening balances. You’ll need to just change the sign. See the thread linked below

1 Like