Migration - Calculated Closing Balance for previous month incorrect

Hi Gerald_M, 

Thanks for reaching out and welcome to the Community Forum. 

 

I'm sorry to hear about your reconciliation difficulties after migration. I understand how important it is that the data from the previous software is the same as the current one. Generally, there are two things that affect the calculated closing balance, these are the Opening balance of the ledger account and all the transactions on that ledger account until the date of our reconciliation that are either already reconciled or marked check in the reconcile window. 

 

Reconciling on a future date like 31/12/9998 and undoing it, ensures that there are no hidden transactions in the reconcile accounts window. If all transactions in the reconcile accounts window are either reconciled or marked with a check, and the calculated closing balance is still incorrect, it's likely that the issue is with the opening balance. I would suggest checking the opening balance of that ledger account from the window Accounting > Chart of Accounts > Edit Accounts. If this does not solve the issue, we would need to undo the reconciliation and compare the transactions from the reconcile accounts window with the bank statement to see if there are missing transactions or duplicated transactions that need to be corrected. 

 

Let us know if you require any further assistance with this. We're happy to help. 

 

Cheers, 

Genreve