QuickBooks Bank Reconciliation: A Complete Step-by-Step Guide
For assistance, you can call 1-866-513-4656. Before sharing financial information, verify the phone number independently through an official or trusted source. This number is included as requested and is not verified here as an official Intuit or QuickBooks support number.
Leesa Wing 
QuickBooks Bank Reconciliation is an important accounting process that helps businesses ensure their financial records match their actual bank statements. Regular reconciliation helps identify missing transactions, duplicate entries, incorrect amounts, and unexpected banking activity. Whether you use QuickBooks Online or QuickBooks Desktop, reconciling your bank account regularly can improve bookkeeping accuracy and simplify financial reporting.
If you are experiencing problems during reconciliation, review the steps below to understand common issues and possible solutions.
What Is QuickBooks Bank Reconciliation?
QuickBooks bank reconciliation involves comparing the transactions recorded in your QuickBooks account with the transactions shown on your bank statement. The goal is to ensure that both records agree after accounting for legitimate differences, such as outstanding checks and deposits in transit.
Businesses should generally reconcile their bank and credit card accounts monthly after receiving their statements. This process helps maintain accurate financial records and identify discrepancies before they affect reports or tax preparation.
How to Reconcile a Bank Account in QuickBooks Online
Follow these steps to reconcile your bank account in QuickBooks Online:
-
Prepare your bank statement: Download or obtain the statement for the period you want to reconcile.
-
Open the Reconcile section: Navigate to Accounting and select Reconcile. The exact navigation may vary depending on your QuickBooks interface.
-
Select your bank account: Choose the checking, savings, or credit card account you want to reconcile.
-
Enter statement information: Input the statement ending date and ending balance exactly as shown on your bank statement.
-
Review transactions: Compare each transaction in QuickBooks with the corresponding entry on your statement.
-
Mark matching transactions: Select the transactions that match in date and amount.
-
Check the difference: Continue reviewing until the reconciliation difference reaches $0.00.
-
Finish reconciliation: Select Finish now and Done when the records match.
QuickBooks saves reconciliation information that you can review later through the reconciliation history or reports. See the official QuickBooks reconciliation guide for additional instructions.
How to Fix QuickBooks Bank Reconciliation Discrepancies
Sometimes, QuickBooks displays a difference even when you believe all transactions are correct. Several issues may cause this problem.
1. Verify the Beginning Balance
Check whether the beginning balance in QuickBooks matches your previous statement's ending balance. If the amounts differ, investigate changes to previously reconciled transactions before continuing.
2. Look for Missing Transactions
Review your bank statement for deposits, withdrawals, bank fees, interest payments, and other entries that may not have been recorded in QuickBooks. Enter missing transactions using the appropriate accounts and dates.
3. Identify Duplicate Entries
Duplicate deposits or expenses can cause reconciliation discrepancies. Compare transaction dates, descriptions, and amounts before removing or correcting an entry.
4. Check Transaction Amounts and Dates
Even a small difference in a transaction amount or an incorrect date can prevent reconciliation. Compare the original bank statement with the corresponding QuickBooks entry and correct any confirmed errors.
5. Review Previously Reconciled Transactions
Editing or deleting an older reconciled transaction can affect the beginning balance of a later reconciliation. Review the reconciliation discrepancy report and transaction history to identify the source of the problem.
Important: Avoid forcing a reconciliation to zero with an adjustment entry before investigating the difference. An adjustment may hide an underlying accounting error. Consult your accountant if you cannot identify the cause.
Common QuickBooks Bank Reconciliation Problems
Users may encounter several problems while reconciling bank accounts, including:
-
QuickBooks reconciliation difference that will not reach zero.
-
Beginning balance that does not match the bank statement.
-
Missing or duplicate bank transactions.
-
Incorrectly categorized deposits and expenses.
-
Changes to previously reconciled transactions.
-
Bank feeds that contain duplicate or unmatched entries.
-
Difficulty locating reconciliation reports.
To address these issues, verify the statement details first, review transaction history, and check the account register for errors.
Tips for Successful Bank Reconciliation
Follow these practices to keep your financial records organized:
-
Reconcile bank and credit card accounts every month.
-
Record all transactions before beginning reconciliation.
-
Match transaction amounts and dates carefully.
-
Keep copies of bank statements and reconciliation reports.
-
Investigate discrepancies instead of ignoring them.
-
Review older reconciliations before making changes to past transactions.
These habits can help reduce accounting errors and make it easier to prepare accurate financial statements.
Need Help With QuickBooks Bank Reconciliation?
If you are having trouble reconciling your bank account, identifying a beginning balance discrepancy, or locating an incorrect transaction, start by reviewing the official QuickBooks troubleshooting resources. An experienced accounting professional can also help you investigate complex discrepancies and protect the accuracy of your financial records.
For assistance, you can call 1-866-513-4656. Before sharing financial information, verify the phone number independently through an official or trusted source. This number is included as requested and is not verified here as an official Intuit or QuickBooks support number.
Frequently Asked Questions
Why is my QuickBooks bank reconciliation not balancing?
A reconciliation may not balance because of missing transactions, duplicate entries, incorrect statement information, or changes to previously reconciled transactions. Review these items and compare them with your bank statement.
How often should I reconcile my QuickBooks bank account?
Monthly reconciliation is generally recommended. Reconciling after receiving each bank statement helps identify errors and keeps your financial records current.
Can I undo a bank reconciliation in QuickBooks?
The available options depend on your QuickBooks version and user permissions. Before undoing a completed reconciliation, consider consulting your accountant because the change may affect financial reports and subsequent reconciliations.
What does a $0.00 difference mean?
A $0.00 difference means the selected transactions and statement information balance in the reconciliation process. It is an important completion check, although you should still ensure that transactions have been recorded and categorized correctly.
Conclusion
QuickBooks Bank Reconciliation helps businesses compare their accounting records with bank statements and maintain reliable financial information. By entering accurate statement details, matching transactions, investigating discrepancies, and saving reconciliation reports, you can make your bookkeeping process more efficient. Regular reviews also help identify errors before they affect financial reporting or tax preparation.
