Bank Reconciliation Balances
Posted: Wed Oct 14, 2020 9:27 am
My account 1110 account is not reconciling. I ran trial balance for January 01 2019 to September 30 2019 and everything balances correctly. I checked account activity and everything balances correctly. Yet when I run reconciliation, it shows that my 1110 account balance is -2647.59 whereas it should be 21.91. Difference of 2669.50. When I run reconciliation and tell it to include all data, I also get the same discrepancies. I also checked and made sure that there are no transactions later than 30 September 2019 that were marked as C or Y.
On the activity report, the difference between debits and credits is 21.91 (perfect!!).
Yet in reconciliation, the Cheques/Subtractions is 86000 lower than account activity. The Deposits/Additions is 85000 lower than account activity.
Since the trial balance, account activity, and balance sheet reports are showing correctly, I am thinking that there is something off in the reconciliation module.
Is there a "reset" or something to recalculate the balance for the reconciliation module? If not, how can I fix the error?
Thanks, James
On the activity report, the difference between debits and credits is 21.91 (perfect!!).
Yet in reconciliation, the Cheques/Subtractions is 86000 lower than account activity. The Deposits/Additions is 85000 lower than account activity.
Since the trial balance, account activity, and balance sheet reports are showing correctly, I am thinking that there is something off in the reconciliation module.
Is there a "reset" or something to recalculate the balance for the reconciliation module? If not, how can I fix the error?
Thanks, James