How to reconcile bank statements on QuickBooks
Reconciling bank statements in QuickBooks involves comparing your bank statement with QuickBooks records to ensure accuracy. Access the reconciliation tool from the Banking menu, enter statement details, and match transactions until the difference is zero.
Prerequisites
- Active QuickBooks subscription
- Bank account connected to QuickBooks
- Latest bank statement available
- Basic understanding of accounting transactions
Step-by-Step Instructions
Access the Reconcile Feature
Enter Statement Information
- Statement ending date - Enter the date from your bank statement
- Beginning balance - This should auto-populate from your previous reconciliation
- Ending balance - Enter the final balance shown on your bank statement
Review and Match Deposits
- Customer payments
- Bank interest
- Other income deposits
Match Checks and Payments
- Written checks
- Electronic payments
- Bank fees
- Automatic withdrawals
Resolve Discrepancies
$0.00 when complete. If there's a difference:- Look for missing transactions
- Check for amount discrepancies
- Verify dates are correct
- Look for duplicate entries
Complete the Reconciliation
$0.00, review your work and click Finish now. QuickBooks will ask if you want to print or save a reconciliation report. Select your preference and click OK. The reconciled transactions will be marked with a checkmark in your register.Common Issues & Troubleshooting
Beginning balance doesn't match bank statement
Check if the previous reconciliation was completed correctly. Go to the Chart of Accounts, open your bank register, and verify the last reconciled balance matches your statement.
Transactions appear in QuickBooks but not on bank statement
These may be outstanding transactions that haven't cleared yet. Leave them unchecked during reconciliation. If they're old, contact your bank to verify the status.
Bank statement shows transactions not in QuickBooks
Add missing transactions by clicking Add Transaction during reconciliation, or go to Banking > Banking to download and categorize missing transactions.
Reconciliation won't balance despite multiple attempts
Look for Previous Reconciliation Reports under Reports > Banking to identify when the discrepancy started. Consider undoing the last reconciliation if errors were made.