I appreciate your effort in troubleshooting this issue by yourself, @drainham.
To begin with, it's great to hear that you've compared your actual bank balance to what's shown in QuickBooks. There are several reasons why your actual balance might not match the balance in QuickBooks:
- Outstanding Transactions: These are transactions that haven't cleared in QuickBooks yet, so they won't appear on your bank statement.
- Duplicate Transactions: A transaction may have been manually entered and then downloaded again from the bank feed, causing it to appear twice. To resolve this, simply delete the duplicate entry.
- Incorrect Account Assignment: A transaction might have been entered into the wrong account.
- Edited or deleted transactions: If a previously reconciled transaction has been edited or deleted, that might lead to discrepancies. You can check the audit log to see if any changes have been made.
- Incorrect opening balance: If the starting balance for your bank account in QuickBooks is incorrect, it will throw off your reconciliation. To fix this, ensure that your opening balance matches your bank records. You can refer to this article for guidance: Fix issues with your beginning balance for accounts you've reconciled before.
You can also ask your accountant to assist you with this matter.
If you have follow-up questions about why your bank balance doesn't match in QuickBooks, please don't hesitate to click the Reply button.
