Thanks for reaching out to the Community, faf07.
When yo reconcile an account, you compare transactions in your books with the ones on the bank statement. In the end, the difference between your two records should be $0.00. If it's not, or in the event you reconciled an account before and your ending balance changed, you can find and fix issues so you can finish reconciling.
Here's what can cause ending balance issues:
- There are missing or duplicate transactions in QuickBooks.
- Someone edited or deleted transactions that were already reconciled.
- Someone made an adjustment to your last reconciliation with a journal entry.
- Someone entered an incorrect ending balance at the start of the reconciliation.
- Someone entered transactions into QuickBooks that hasn't cleared your bank yet.
Initially you'll need to review its opening and beginning balances. If you haven't already, make sure your opening and beginning balances are correct. Once you know they're accurate, you can start looking for other issues.
Next, look for changed, deleted, or added transactions. You can use your Reconciliation Discrepancy, Transaction Detail, and Missing Checks reports to identify if anything has been changed, deleted, or added.
If you're unable to find any issues in your accounts, you may need to undo the previous reconciliation until your opening balance is correct. In the event someone edited or deleted a transaction from years ago, you may need to undo your reconciliations for the past few years to get to where your opening balance is accurate.
You can refer to our Fix issues when you're reconciling article for detailed information on the process.
You can also check with an accounting professional if you're unsure of how to approach this. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.
I've also included a detailed resource about reconciling which may come in handy moving forward: Reconcile an account
Please feel welcome to send a reply if there's any additional questions. Have an awesome Monday!
