I inadvertently deleted some reconciled transactions, and now I'm getting the message saying I can't reconcile until I fix those transactions. I've followed the directions I've been able to find online, but so far nothing has worked. Recreating the transactions and manually marking them as reconciled just adds more lines that it says need to be fixed.
Let's fix the error you have with your reconciliation, @mikeyontsfilm.
You can fix those deleted reconciled transactions by manually adding them back and making sure to add an R in the checkmark column.
I also suggest running a past reconciliation report, then review your bank statements. For transactions that were on the previous bank statement but weren't on the reconciliation for those dates, you can add it manually.
Here's how to run the report:
After manually adding those transaction, you can now mark them as reconciled:
You can read through this article for more details in troubleshooting reconciliations:
Reach out to me if you have other questions in reconciling your accounts. I'm always here to help. Have a great rest of the day!
I've followed these directions and it still doesn't seem to be working. For example, there's a $120 deposit in checking, in March of this year. I enter the transaction, click until there's an R, and go back to the reconciliation report to see the deposit still listed as deleted.
When I look in the register, the deposit is there, and it matches my bank statement.
Let me clear things out for you, mikeyontsfilm.
You don't have to worry about the deleted entry on your reconciliation report.
QuickBooks Online will record all deleted entries you've made from the previous reconciliation. Hence, they'll remain on the report even if you re-enter them.
I'm adding this link for your reference on your next reconciliation process: Reconcile an account in QuickBooks Online.
Stay in touch with me if you need assistance when reconciling your bank accounts. I'm always glad to help you.
I had to rerun ADP entries and deleted the previously reconciled ones. My balance matches the bank but when I try to reconcile, it says my beginning balance is off and will not let me. The detail shows the deleted items as the problem. How do I fix this so that I can reconcile?
Welcome and thanks for joining in this thread, @KBurlingame. When previously cleared and reconciled transactions are voided or deleted, that will cause the beginning balance issue.
Let's run the Reconcile Discrepancy report to find the transactions causing the issue. Here's how:
You now have a list of transactions that were changed since the last reconciliation. Use this report to identify the transaction/s causing the issue. Once you found a discrepancy, note the transaction date and the Entered/Last Modified.
Then, re-enter the transaction by creating a journal entry using the info you've found in the report. Here's how:
Once done, do a mini-reconciliation. I'd recommend consulting your accountant to guide you with this.
Here's the link that contains additional insights in fixing the beginning balance issue in QBDT.
You can also watch a quick video tutorial as your visual guide in correcting your beginning balance in QuickBooks.
Get back to this thread if you have additional concerns. We're always around to answer your next posts.