How to Do Bank Reconciliation in QuickBooks? Step-by-Step Guide
Compare the transactions in QuickBooks with your bank statement. Mark the matching deposits, checks, and payments as cleared.
Leesa Wing 
Bank reconciliation in QuickBooks helps businesses compare their accounting records with bank statements to ensure that transactions, deposits, withdrawals, and account balances are accurate. Regular reconciliation helps identify missing transactions, duplicate entries, bank fees, and other discrepancies that may affect financial reports.
Whether you use QuickBooks Online or QuickBooks Desktop, understanding how to reconcile a bank account can improve bookkeeping accuracy and help maintain reliable financial records.
What Is Bank Reconciliation in QuickBooks?
QuickBooks bank reconciliation is the process of matching transactions recorded in your QuickBooks account with the transactions listed on your bank statement. The goal is to ensure that both balances agree after accounting for outstanding checks, deposits in transit, bank fees, and other timing differences.
Businesses should reconcile their bank accounts regularly, usually every month after receiving their bank statements.
How to Do Bank Reconciliation in QuickBooks Online
Follow these steps to reconcile your bank account in QuickBooks Online.
Step 1: Gather Your Bank Statement
Before starting the reconciliation process, download or obtain your latest bank statement. Make sure you have the statement's ending date and ending balance available.
You should also review your previous reconciliation to identify any outstanding transactions.
Step 2: Open the Reconciliation Tool
-
Sign in to QuickBooks Online.
-
Open Accounting or Transactions, depending on your interface.
-
Select Reconcile or locate the reconciliation option.
-
Choose the bank or credit card account you want to reconcile.
If the menu looks different, use the search or navigation options available in your QuickBooks version.
Step 3: Enter Your Statement Details
Enter the ending balance and ending date shown on your bank statement. If QuickBooks displays a beginning balance, compare it with the beginning balance on your statement.
Make sure you select the correct account and statement period before continuing.
Step 4: Match Transactions
Review the transactions listed in QuickBooks and compare them with your bank statement. Mark each transaction that appears on both records.
Check the following items carefully:
-
Deposits and customer payments
-
Checks and vendor payments
-
Bank withdrawals and transfers
-
Service charges and interest
-
Credit card payments, where applicable
Do not select transactions simply because the amounts look similar. Verify the dates, descriptions, and amounts before marking them as cleared.
Step 5: Investigate Any Difference
QuickBooks displays a difference between the bank statement and the transactions you have selected. Ideally, the difference should be $0.00 before you finish.
If the difference is not zero, check for missing transactions, duplicate entries, incorrect amounts, or transactions recorded in the wrong account. Also verify the statement's ending balance and date.
Step 6: Finish the Reconciliation
When the difference reaches zero, review the selected transactions one final time. Select Finish now or the equivalent option displayed in your QuickBooks interface.
Save or download the reconciliation report for your accounting records.
How to Reconcile a Bank Account in QuickBooks Desktop
If you use QuickBooks Desktop, follow these steps:
-
Open your company file and select the Banking menu.
-
Choose Reconcile.
-
Select the bank account you want to reconcile.
-
Enter the statement date and ending balance.
-
Compare the transactions in QuickBooks with your bank statement.
-
Mark the matching deposits, checks, and payments as cleared.
-
Investigate any remaining difference until the reconciliation balances.
-
Complete the reconciliation and save or print the reconciliation report.
Menu labels may vary slightly depending on your QuickBooks Desktop version.
Common QuickBooks Bank Reconciliation Problems
Sometimes, QuickBooks bank reconciliation does not balance even when the bank statement appears correct. Several issues can cause this problem.
1. Beginning Balance Is Incorrect
A beginning balance discrepancy may occur when a previously reconciled transaction is edited, deleted, or unreconciled. Review the beginning balance and reconciliation discrepancy information before making changes.
2. Transactions Are Missing
A deposit, payment, or check may not have been entered into QuickBooks. Compare the bank statement with your transaction register and enter legitimate missing transactions after verifying their details.
3. Duplicate Transactions Appear
Duplicate bank-feed entries or manually entered transactions can cause discrepancies. Review the register and bank feed carefully before deleting anything.
4. Bank Fees or Interest Are Not Recorded
Monthly service charges and interest payments may appear on your bank statement but not in QuickBooks. Record these transactions in the appropriate accounts before completing reconciliation.
5. Incorrect Transaction Amounts
A transaction entered with the wrong amount can prevent reconciliation from balancing. Compare the transaction with the bank statement and correct the entry only after confirming the accurate amount.
Tips for Accurate QuickBooks Bank Reconciliation
-
Reconcile accounts every month.
-
Use the correct bank statement ending date and balance.
-
Review unmatched and duplicate transactions before making changes.
-
Avoid deleting previously reconciled transactions without understanding the impact.
-
Save reconciliation reports for future reference.
-
Keep a backup of your QuickBooks Desktop company file before making significant corrections.
Frequently Asked Questions
How often should I reconcile my bank account in QuickBooks?
Most businesses reconcile their bank accounts monthly after receiving their statements. Businesses with frequent transactions may benefit from more frequent reviews.
Why is my QuickBooks bank reconciliation not balancing?
Common causes include missing transactions, duplicate entries, incorrect amounts, bank fees that have not been recorded, and changes to previously reconciled transactions. Check the statement ending balance and date first.
Can I undo a bank reconciliation in QuickBooks?
The available options depend on your QuickBooks product, permissions, and account setup. In QuickBooks Online, an accountant may be able to undo a reconciliation, while QuickBooks Desktop has different procedures. Review the implications before changing a completed reconciliation.
What does a $0.00 difference mean in QuickBooks reconciliation?
A zero difference means the transactions selected for reconciliation match the statement's ending balance. You should still verify the selected transactions and statement details before finishing.
Conclusion
Learning how to do bank reconciliation in QuickBooks helps businesses maintain accurate financial records, identify transaction errors, and prepare dependable financial reports. By entering the correct statement details, matching transactions, and investigating discrepancies, you can complete reconciliation more confidently in QuickBooks Online or Desktop.
If you encounter persistent QuickBooks bank reconciliation errors or need help identifying discrepancies, visit BooksMerge at for additional QuickBooks guides and troubleshooting resources.
