Bank reconciliation is an essential accounting task for businesses that use QuickBooks Desktop or QuickBooks Online. It helps confirm that the transactions recorded in your accounting records match the activity shown on your bank or credit card statement. When the balances do not match, you may be dealing with missing transactions, duplicate entries, incorrect dates, bank fees, or changes to previously reconciled records.
A successful QuickBooks bank reconciliation should end with a difference of $0.00 for the statement period. If your reconciliation does not balance, avoid entering an adjustment immediately. First, identify why the figures differ so that you do not hide an accounting error or create inaccurate financial reports.
This guide explains how bank reconciliation works in QuickBooks, how to reconcile an account step by step, and how to troubleshoot common problems safely.
What Is Bank Reconciliation in QuickBooks?
Bank reconciliation is the process of comparing transactions recorded in QuickBooks with the transactions and balances shown on an official bank statement. It helps verify that deposits, withdrawals, payments, transfers, and other account activity have been recorded correctly.
For example, your QuickBooks register might show a payment of $450, but your bank statement may show $405. That $45 difference could indicate a data-entry mistake, an incorrect transaction, or another issue that needs investigation.
Regular reconciliation helps businesses:
- Identify missing or duplicate transactions.
- Detect incorrect payment and deposit amounts.
- Find bank fees and interest that have not been recorded.
- Investigate discrepancies in account balances.
- Maintain more reliable financial statements.
- Prepare for tax reporting and financial reviews.
It is generally good practice to reconcile checking, savings, and credit card accounts every month after the corresponding statements become available.
What You Need Before Reconciling a Bank Account
Before you begin, collect the information required for the statement period you want to reconcile.
1. Your bank or credit card statement: Use the official statement, including its beginning balance, ending balance, and statement-ending date.
2. Your QuickBooks company file: Confirm that you have opened the correct company and selected the correct bank or credit card account.
3. Recorded transactions: Enter the applicable checks, deposits, payments, transfers, and other transactions into QuickBooks before comparing them with the statement.
4. A company file backup: For QuickBooks Desktop, create a backup before performing significant account corrections or data repairs.
5. Your previous reconciliation information: If this is not your first reconciliation, review the previous statement period and confirm that the beginning balance is correct.
If you are reconciling several months at once, begin with the oldest unreconciled statement. Completing each period in chronological order makes it easier to identify where a discrepancy first appeared.
How to Reconcile a Bank Account in QuickBooks Desktop
The following steps apply to the standard QuickBooks Desktop reconciliation workflow. Menu labels can vary by product version.
Step 1: Open the Reconciliation Window
Open QuickBooks Desktop and sign in to the correct company file.
- Select Banking from the menu.
- Choose Reconcile.
- Select the bank or credit card account you want to reconcile.
Double-check the account name before proceeding. Selecting the wrong account can make an otherwise accurate statement appear incorrect.
Step 2: Enter the Statement Information
Enter the details from your official bank statement:
- Statement date: Use the statement's ending date.
- Beginning balance: Compare it with the beginning balance shown on the statement.
- Ending balance: Enter the ending balance from the statement.
- Service charge: Enter any bank fee that has not already been recorded.
- Interest earned: Enter interest that has not already been recorded, when applicable.
Avoid entering bank fees or interest twice. If a transaction already appears in QuickBooks, verify its amount and date rather than creating another entry.
If the beginning balance is incorrect, investigate that issue before continuing.
Step 3: Match Transactions Against the Statement
QuickBooks displays transactions that may include checks, payments, deposits, and transfers.
Start at the top of your bank statement and locate each corresponding transaction in the reconciliation window.
For every transaction:
- Compare the date and amount.
- Confirm that the transaction belongs to the selected account.
- Mark it as cleared only when it matches the bank statement.
- Investigate any missing, duplicate, or incorrectly recorded entry.
Do not mark transactions as reconciled merely to make the balance match. Every cleared item should have a valid explanation and a corresponding statement entry, subject to normal timing differences.
Step 4: Check the Difference
As you match transactions, monitor the reconciliation difference.
The goal is $0.00. A zero difference indicates that the statement balance and the cleared transactions reconcile based on the information entered.
If the difference remains, return to the transactions and review the amounts, dates, and cleared status. Do not force the reconciliation to finish by creating an adjustment before you understand the discrepancy.
Step 5: Complete and Save the Reconciliation
When the difference reaches zero and you have reviewed the transactions, select Reconcile Now or the equivalent option shown in your version.
Save or display the reconciliation report when prompted. Keep this report with your accounting records so you can review the cleared transactions later if a question arises.
How to Reconcile an Account in QuickBooks Online
QuickBooks Online uses a different interface from QuickBooks Desktop, but the accounting principle is the same: compare the account activity with the official statement.
Step 1: Open Reconcile
Sign in to QuickBooks Online and open the correct company. Go to the accounting area and select Reconcile. Depending on the interface, you may find it through the gear menu or the account-management options.
Select the bank or credit card account you want to reconcile.
Step 2: Enter the Statement Ending Balance
Enter the statement-ending date and ending balance from your bank statement. Review the beginning balance shown by QuickBooks.
If the beginning balance is wrong, do not simply change it to match the statement. First determine whether a previously reconciled transaction was deleted, edited, duplicated, or otherwise changed.
Step 3: Review and Match Transactions
Compare the transactions in QuickBooks with those listed on the statement. For transactions imported through bank feeds, verify that the downloaded entry has been matched to the correct transaction rather than added as a duplicate.
Mark transactions as cleared only when they agree with the statement.
Step 4: Resolve the Difference
Review unmatched deposits, payments, bank fees, interest, and transactions recorded with incorrect dates or amounts. Continue until the difference is zero.
Step 5: Finish and Save
Once the account balances and the transactions have been reviewed, complete the reconciliation and save the report for your records.
For additional product-specific instructions, refer to the official QuickBooks Desktop account reconciliation guide.
How to Fix QuickBooks Bank Reconciliation Discrepancies
A reconciliation discrepancy does not automatically mean that your company file is damaged. Often, the problem is caused by an ordinary transaction or data-entry issue.
1. The Beginning Balance Does Not Match
The beginning balance for a new reconciliation usually comes from the ending balance of the previous completed reconciliation.
If the figures differ, check whether:
- A previously reconciled transaction was edited or deleted.
- A payment or deposit was entered twice.
- A transaction's amount or account was changed.
- The wrong account or statement period was selected.
- An earlier reconciliation was completed incorrectly.
Review the reconciliation history and identify the earliest period where the figures stopped matching. Correct the underlying transaction only after confirming what the bank statement and accounting records show.
2. The Reconciliation Difference Is Not Zero
If the difference is not zero, compare the ending balance and cleared transactions again.
Check for transposed numbers, missing decimal places, incorrect dates, and transactions that were accidentally marked as cleared. A small discrepancy may come from one incorrect amount, while a larger discrepancy may involve a missing deposit, duplicate payment, or several unmatched transactions.
Do not enter a reconciliation adjustment just to eliminate the difference. An adjustment can make the screen balance without correcting the underlying accounting records.
3. A Bank Transaction Is Missing in QuickBooks
Compare the bank statement with the QuickBooks register to find transactions that appear on the statement but not in the accounting records.
Common examples include:
- Bank service charges.
- Interest earned.
- Automatic loan payments.
- Electronic withdrawals.
- Customer deposits.
- Credit card payments.
If a valid transaction is missing, record it using the correct transaction type, date, amount, and account. Before adding it, check whether it already exists under a different date or description.
4. Duplicate Transactions Appear
Duplicate entries can happen when a bank-feed transaction is added even though a corresponding payment or deposit was already recorded manually.
Review the transaction details before deleting anything. If one entry is an imported duplicate, correct the duplicate according to the applicable QuickBooks workflow while preserving the legitimate transaction.
For a previously reconciled transaction, use additional care. Removing or changing it can affect the beginning balance of a later reconciliation.
5. A Transaction Has the Wrong Amount or Date
A transaction may have been entered with an incorrect amount or posted to the wrong statement period.
Compare the entry with the original bank record, invoice, receipt, or payment confirmation. Make the correction only after confirming the correct information.
If the transaction has already been reconciled, check the effect of editing it on the reconciliation history before saving your changes.
6. A Bank Feed Transaction Is Not Matched Correctly
In QuickBooks Online, downloaded bank activity may not always match the correct existing transaction automatically.
Review the payee, amount, date, and account before accepting a suggested match. If the transaction was already entered manually, matching it is generally preferable to creating another entry for the same activity.
If the downloaded amount differs from the existing transaction, investigate the reason for the difference instead of accepting the match without review.
7. You Reconciled the Wrong Statement Period
Check that the statement-ending date and account are correct. If you accidentally started with the wrong period, stop and review the available options before making further changes.
For multiple unreconciled months, work from the oldest statement to the newest. This helps you trace the source of a beginning-balance problem and avoids carrying unresolved differences forward.
Should You Undo a Previous Reconciliation?
Sometimes you need to revisit a completed reconciliation, but undoing one should not be your first troubleshooting step.
In QuickBooks Desktop, the available process can depend on your product version and user permissions. In QuickBooks Online, the ability to undo a reconciliation may depend on your access level and the workflow available in your subscription.
Before undoing a reconciliation:
- Save or print the relevant reconciliation report.
- Identify the transaction or period that appears incorrect.
- Create a backup if you use QuickBooks Desktop.
- Understand that undoing a reconciliation can change the cleared status of transactions.
- Consult your accountant or a qualified QuickBooks professional if you are unsure how the change will affect your records.
If a transaction was changed after reconciliation, correcting that specific transaction may be more appropriate than undoing an entire period.
Best Practices for Accurate Bank Reconciliation
Use these practices to make monthly reconciliation more reliable:
- Reconcile every bank and credit card account regularly.
- Use the official statement rather than an estimated balance.
- Enter bank fees and interest only when they are missing from QuickBooks.
- Match downloaded transactions to existing entries whenever appropriate.
- Investigate beginning-balance changes promptly.
- Save reconciliation reports for future reference.
- Keep secure backups of QuickBooks Desktop company files.
- Avoid unexplained journal entries or forced adjustments.
- Review unusual transactions with the person responsible for the account.
Consistent reconciliation helps improve the reliability of cash balances, expense reporting, and other financial information. It also makes it easier to investigate discrepancies while the relevant statement and transaction details are readily available.
Frequently Asked Questions
How often should I reconcile my QuickBooks bank account?
Monthly reconciliation is a common practice. Reconcile after the bank statement becomes available and review each account separately.
Why does QuickBooks show a beginning balance that does not match my bank statement?
The previous reconciliation may contain a transaction that was edited, deleted, duplicated, or changed. Confirm that you selected the correct account and statement period, then review the reconciliation history.
What does a $0.00 difference mean?
It means the entered statement information and the transactions marked as cleared balance for that reconciliation. You should still review the transactions to ensure that the correct items were matched.
Can I reconcile QuickBooks without connecting my bank account?
Yes. You can generally reconcile using your official bank statement and the transactions recorded in QuickBooks. Automatic bank feeds are not required to compare your accounting records with a statement.
Should I enter an adjustment if QuickBooks will not balance?
Not as a first response. Investigate missing transactions, duplicates, incorrect amounts, and changes to previously reconciled entries. An adjustment should be considered only when its cause and accounting treatment are understood and properly documented.
Can I reconcile multiple months at once?
You should reconcile each statement period separately, starting with the oldest unreconciled statement. This makes it easier to identify when a discrepancy began and prevents an unresolved balance from carrying forward unnoticed.
Conclusion
QuickBooks bank reconciliation helps verify that your accounting records agree with your bank and credit card statements. Start with the correct account and statement details, match each transaction carefully, and investigate any difference before completing the reconciliation.
If the beginning balance is incorrect or the difference will not reach zero, review previous reconciliations, duplicate entries, missing transactions, and bank-feed matches. Avoid unexplained adjustments, and preserve your accounting records before making significant corrections.
For more QuickBooks troubleshooting information, visit Data Service Team. For assistance with QuickBooks Desktop or related accounting software issues, contact Data Service Team at +1-(888)-718-7888.