#078 My bank reconciliation is at zero... so why is my balance sheet incorrect?
Christiane ConstantineauWhy does this discrepancy happen?
-
Future or post-dated transactions: Checks or transfers recorded in the software with a date later than the balance sheet date.
-
Outstanding items: Checks issued or deposits recorded in QuickBooks that have not yet been processed by the bank.
-
Direct journal entries: Manual adjustments made directly to the bank account without going through the reconciliation module.
-
Incorrect report date: The balance sheet is pulled for a date different from the end date of your reconciliation period.
How to fix everything?
-
Verify the exact date the balance sheet was pulled:
Ensure that the end date of your balance sheet report matches exactly the end date of the reconciled period (e.g., the 31st of the month).
-
Pull the "Reconciliation Detail" report:
Consult the Uncleared Transactions section to identify post-dated items or duplicates that are distorting the overall balance.
-
Identify isolated journal entries:
Filter your general ledger to locate manual adjustments made directly to the bank account without passing through the reconciliation module.
-
Make the necessary adjusting entries:
Adjust or delete duplicates, reclassify amounts to the correct accounts, or make an adjusting entry to permanently eliminate orphaned discrepancies.
💡 Useful resource: To understand the impact of adjusted accounting and avoid end-of-month errors, consult our detailed article on the importance of bank reconciliation.