I can see that you have taken the initiative to manually re-reconcile the bank transactions, which is a great step forward, church. Your dedication to resolving this issue is commendable.
Before reconciling an account, it is important to review the beginning balance in QuickBooks. This is the amount in the account at the start of the period you are reviewing. It is essentially a checkpoint that ensures you are starting with accurate numbers. If you are unable to zero out the balance upon reconciling, it is possible that there is a discrepancy in the beginning balance. Therefore, you should check the beginning balance first before undoing all the reconciled transactions.
Remember that even small changes can unbalance your accounts, so it's crucial to unreconcile one transaction at a time to minimize the impact. If you need to start over completely, it's best to reach out to your accountant since only accountants can undo entire reconciliations.
When you know what you need to change, here's how to edit and unreconcile the transaction:
- Go to Transactions and select Chart of accounts.
- Find the account holding the transaction. Then select Account history.
- Select the transaction you want to unreconcile to expand the view.
- Review the check column. If the transaction is reconciled, you’ll see an R.
- Select the checkbox. This changes the letter in the box. Keep selecting it until the box is blank. This removes the transaction from the reconciliation.
- Select Save and close the account history.
Moreover, I suggest reaching out to your accountant to have you get help. This can get tricky and they know how to handle the next steps. Don't have an accountant? We can help you find one.
Moreover, I'll add this link to help you fix past reconciliation problems: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
Don't hesitate to reach out to us anytime if you have further questions about reconciliation in QuickBooks. The Community is always here to help. Take care!
.png){kind=link}