Bank reconcilliation showing discrepancy from before first use..?

We started using Manager from Sep 1st 2020 and all reconcilliations since then have matched as per bank statements. We have three staff that have access to the system; Me (Administrator), Director (creates quotes mainly), Admin staff (deals with everything day to day).

We were about to reconcile October’s transactions but found a large discrepancy had appeared affecting all the previous reconcilliations. I assumed that a transaction had been inputted with the wrong date causing the issue however, the oldest payment on the system is Sep 1st 2020 and there are no receipts before Sep 8th 2020. The discrepancy appears on the reconcilliation I’ve created for Sep 1st 2020 trying to find the problem. There is also nothing obvious having gone through the history tab either!

We’re using the cloud version and we’re on 25.11.3.3093

I don’t know if I’m missing something or if there’s an issue somewhere..?

If someone can suggest some pointers for me to try that would be appreciated…

What does the reconciliation screen show? How much movement is expected by Manager vs how much movement Payments and Receipts add up to?

Thanks for your inout

This is a screenshot of the reconcilliation from Sep 1st 2020, the business was created in Manager on this date so I can’t see how there’s such a large discrepancy as no transactions came before this date. Also, there are only three entries which match the bank statement

image

Apologies, I don’t quite understand your second question..

After the last update I found that nearly all accounts entered as a credit card suddenly showed a constant discrepancy across all reconciliations. In my case, the value present as a beginning (opening) balance needed to be negated, which returned all to reconciled status. Not sure what changed to make a difference, but it was easy to correct.

Thanks for your reply, I’ll take a look…but surely that shouldn’t be the work around if there’s a problem somewhere?

Click the blue number under discrepancy

It will bring you to the reconciliation details, like this:

This shows:

  • Last reconciliation on 9/30/2025 for bank balance of 200 DR
  • Current reconciliation on 11/4/2025 is for bank balance of 555 DR
  • The net movement is 355 DR (calculated from 555 minus 200), Manager.io expects all transactions for this bank account from 9/30/2025 to 11/4/2025 to add up to 355 DR
  • However, the transactions record in Manager.io shows a net movement of $1642.88, which doesn’t match.
  • You must now add Rececipts, Payments, Transfers, Journal Entries, or adjust existing transactions to ensure the net movement is 355 DR
  • If your reconciliation is spot on, this screen will show blank

If your initial reconciliation on the starting date doesn’t reconcile, check your Starting Balances in Settings. Are you sure that when you migrated to Manager.io, all your numbers matched your last financial statement in your previous accounting software?

1 Like

Thanks for the explanation however, whilst I understand all that, we have been using Manager since 2020 with no issue when it comes to accounts reconcilling. There are only 3 transactions on Sep 1st 2020 (and nothing before) and everything matches but Manager is showing a discrepancy…

There was no migration of software so that’s not the issue, only a starting balance which matches what the bank statement says.

Like I said, it’s been fine for the last 5 years, this has only occurred within the last 3 weeks or so and I can’t find any transactions that may have been inputted incorrectly.

I apologize for assuming user error.

What I can suggest is that you either update or roll back do another version, to see if the error remains. If needed, you can use Docker to isolate the new install.

I’ve encountered calculation issues being resolved with version update.

I have same problem, I have been reconciling every month. I use cloud version. but I can see that from 31/10/2023, a figure is showing as discrepancy and it has affected all my reconciliations aftyerwards. @lubos this needs attention.

1 Like

In the past I used Quickbooks, which treated credit cards as a special type of liability account, able to be referenced as a means of payment. Manager treats it like an asset with a negative balance - the bank account/contra account combo. I found that the discrepancy was double the amount entered as the starting balance, which had been entered as a positive value (out of habit at the time no doubt).

:thinking: Uff that must be hard.. as for me I don’t use the system Bank Reconciliation yet cos how many times I tried still most are not reconciled, by your statement I hope that it is not the date format at fault here cos I also raised the date format is very important especially in reporting.

I hope our programmers have a concrete solution in your issue or modification before I will start mine.

I just discovered the same thing on one of the business. What had happened was the starting balance for 2 of the bank accounts had changed sign. Both accounts were meant to start overdrawn but the new starting balances had lost the minus sign. Very weird. All correct when those were changed.

Edit: also had to go back to 2020 or so.

1 Like

Mystery solved… the starting balance had lost it’s minus…thank you so much :ok_hand::ok_hand:

Assume a recent update caused the issue..?

It’s not that starting balance have lost its minus. In previous versions, many users had starting balances established as one big journal entry. In some cases, this journal entry would have so many lines that it was impossible to edit.

To address this problem, a few days ago I wrote a migration script to convert this big journal entry (if detected) into a series of starting balances. Credit balance within that starting balance journal entry should have been converted to negative starting balance for bank account unless that bank account has been in foreign currency. I think this is what’s happening, for foreign currency bank accounts, there was a bug which would result in loss of negative sign.

Can you please confirm these bank accounts which got unreconciled due to starting balance losing negative sign were all foreign currency bank accounts?

All in US$ for me, only credit card accounts affected.

Not foreign as such, both affected accounts were in South African currency with the business in South Africa as well. Unless you mean non-Australian…

Mine was GBP