Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I've got some transactions that were entered by the last person. It appears they reconciled the transactions, then changed the amount, then voided the transactions prior to deleting them. Next, they re-entered the original transactions, correctly allocating them to each invoice.
Needless to say, I have an error showing that is preventing me from reconciling the bank.
Any suggestions how to fix this?
I've already figured out how to correct each separate stage, I'm just not convinced doing this won't cause further problems as this all relates to the last financial year.
Hi C-G, thanks for joining the Community
If the amounts of the re-entered transactions match the deleted amounts, you can fix the reconciliation discrepancy by entering the same ending date and ending balance of the last completed reconciliation on the reconcile screen.
This will then show the re-entered transactions, where you can tick each to mark as reconciled (the DIFFERENCE amount should show as zero once all have been selected).
If the ending date and ending balance of the last completed reconciliation is incorrect, it would be recommended to undo the reconciliation(s), back until the point that they match the bank statements.
What if the amounts are different?
Hi C-G, if the amounts are different and correct (i.e., the transactions match the bank statement) this will mean that the beginning balance (the ending balance from the last completed reconciliation) is incorrect.
In this case, you can try following the steps in our reconciliation guide to fix issues for accounts that you've reconciled in the past in QuickBooks. If you need any further support, we'd recommend connecting with your accountant to help get you back on track. They can undo the reconciliation so that this can be corrected. Please note that this is only available for accountants who use QuickBooks Online Accountant.
The edited transactions span the last year. If possible I want to avoid re-reconciling an entire year. How do I manually reconcile each transaction? We're talking Bill Partial payments, Expenses, Payments Received, and Deposits.
I've already tried going via the Chart of Accounts but don't have the option to View Register.
Hello C-G, we would strongly advise you to speak to your accountant on this. If you want to try and fix it yourself you can do this transaction>chart of accounts>account history> you can remove the r from any that were reconciled incorrectly and change it to r for any that should be reconciled>save however if anything is to go wrong you will need to speak to your accountant to sort out.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.