Managing your business finances becomes challenging when your accounting records don’t match your bank or credit card statements. That’s where QuickBooks reconciliation plays a vital role. Reconciling your accounts helps you compare your QuickBooks records with your financial institution’s statements to ensure every transaction is accurate and accounted for. Furthermore, regular reconciliation helps you detect errors early, prevent fraud, maintain reliable financial records, and prepare accurate reports for budgeting, tax compliance, and audits. Whether you use QuickBooks Online or QuickBooks Desktop, making reconciliation a routine part of your accounting process keeps your books and financial data organized.

In this guide, we’ll discuss what QuickBooks reconciliation is, why it’s important, its benefits, the prerequisites for reconciliation, how to reconcile in QuickBooks Online and QuickBooks Desktop, and more.

What is Reconciliation in QuickBooks?

Reconciliation in QuickBooks is the process of comparing the transactions recorded in your QuickBooks account with your bank or credit card statement for the same period. During reconciliation, you verify that deposits, withdrawals, payments, fees, and other transactions match in both records. If you find any differences, such as missing, duplicated, or incorrectly entered transactions, you can investigate and correct them before finalizing your books.

QuickBooks provides built-in reconciliation tools in both QuickBooks Online and QuickBooks Desktop to simplify this process. After you enter the statement’s ending balance and ending date, QuickBooks helps you match transactions and calculates any remaining difference. A successful reconciliation confirms that your QuickBooks balance matches your financial institution’s records, giving you accurate financial data for reporting, budgeting, tax preparation, and decision-making.

Benefits of Regular Reconciliation in QuickBooks

Reconciling your accounts regularly helps you keep your financial records accurate and ensures your books reflect your actual account balances. Here are the key reasons to reconcile in QuickBooks.

  • Maintains accurate financial records
    Reconciliation verifies that the transactions recorded in QuickBooks match your bank and credit card statements.
  • Identifies errors before they affect your books
    Regular reconciliation helps you detect missing transactions, duplicate entries, incorrect amounts, bank fees, and data entry errors.
  • Detects unauthorized or fraudulent transactions
    Comparing your QuickBooks records with bank statements allows you to identify unauthorized withdrawals, duplicate charges, or other suspicious transactions.
  • Improves cash flow visibility and management
    Reconciliation confirms which payments and deposits have cleared your bank account, giving you an accurate picture of your available funds.
  • Simplifies tax preparation and financial audits
    Keeping your accounts reconciled throughout the year reduces the need for extensive corrections during tax season.
  • Supports better business decisions
    Reliable financial data allows you to evaluate business performance, prepare realistic budgets, forecast future expenses, and make strategic decisions.

Prerequisites Before You Reconcile in QuickBooks

Before you start the reconciliation process, make sure your financial records are complete and accurate. Listed below are the prerequisites to know before QuickBooks reconciliation.

ParameterDetails
Latest Bank or Credit Card StatementKeep the latest statement for the account you want to reconcile. You’ll need the statement ending date and statement ending balance to begin the reconciliation process.
Opening Balance VerificationVerify that the opening balance in QuickBooks matches the ending balance from your previous reconciliation. If the opening balance is incorrect, review previously reconciled transactions for edits, deletions, or other changes before proceeding.
Missing TransactionsRecord all transactions that occurred during the statement period, including deposits, payments, transfers, bank service charges, interest earned, and automatic transactions that haven’t been imported or entered manually.
Downloaded Bank TransactionsIf you use bank feeds, review, match, and categorize all downloaded transactions before reconciling.
Previously Reconciled TransactionsCheck that no reconciled transactions have been edited, deleted, or voided. Changes to reconciled entries can create balance discrepancies and interrupt the reconciliation process.
Company File Backup (QuickBooks Desktop)Create a backup of your company file before reconciling if you use QuickBooks Desktop. A backup allows you to restore your data if you need to troubleshoot or undo the reconciliation later.

What are the Steps to Reconcile in QuickBooks Online?

Your first reconciliation establishes the opening balance that QuickBooks uses for all future reconciliations. Follow these steps to reconcile in QuickBooks Online for the first time.

  • Go to Accounting > Reconcile.
  • Select the bank account you want to reconcile.
  • Verify that the Opening Balance matches your bank records.
  • Enter the Statement Ending Date and Ending Balance from your bank statement.
  • Click Start Reconciling.
  • Compare each transaction with your bank statement and mark matching transactions as Cleared.
  • Continue matching transactions until the Difference shows $0.00.
  • Click Finish Now to complete your first reconciliation.

In case the opening balance doesn’t match:

  • Review previously entered transactions.
  • Check for missing, duplicate, edited, or deleted entries.
  • Correct the underlying issue instead of creating an adjustment.

Note: After completing a reconciliation, you can review previous reconciliation reports in QuickBooks to verify the beginning balance, cleared transactions, and ending balance.

How to Reconcile a Bank Account in QuickBooks Online?

Reconciling your bank account each month ensures that every deposit, withdrawal, transfer, and payment recorded in QuickBooks matches your bank statement. Follow these steps to reconcile a bank account in QuickBooks Online:

  • Go to Accounting > Reconcile or Gear > Tools > Reconcile.
  • Select the checking or savings account you want to reconcile.
  • If you’ve already started, click Resume Reconciling.
  • Verify the Beginning Balance.
  • Enter the Ending Balance and Statement Ending Date from your bank statement.
  • Click Start Reconciling.
  • Compare each transaction with your bank statement.
  • Mark matching deposits, withdrawals, checks, and transfers as Cleared.
  • Use filters such as Date, Amount, or Transaction Type to locate transactions quickly.
  • Review any unmatched transactions.
  • Correct incorrect dates, amounts, duplicate entries, or missing transactions.
  • Continue until the Difference equals $0.00.
  • Click Finish Now.
  • Save or print the reconciliation report for future reference.
  • Repeat the reconciliation process every month for all bank accounts.

Note: If you continue finding duplicate, uncategorized, or incorrectly recorded transactions, a QuickBooks cleanup service can help organize your records before completing the reconciliation.

How to Reconcile a Credit Card in QuickBooks Online?

Reconciling your credit card account helps you verify purchases, refunds, fees, and payments while ensuring your QuickBooks records match your credit card statement. Follow these steps to reconcile a credit card in QuickBooks Online:

  • Go to Accounting > Reconcile.
  • Select your credit card account.
  • Verify the Beginning Balance.
  • Enter the Ending Balance and Statement Ending Date exactly as shown on your credit card statement.
  • Record any Interest Charges, Annual Fees, Late Fees, or other charges that haven’t been entered into QuickBooks.
  • Click Start Reconciling.
  • Match purchases, refunds, credits, and payments with your credit card statement.
  • Ensure credit card payments from your bank account are matched correctly.
  • Reconcile transactions based on the credit card billing cycle, not the calendar month.
  • Review any missing, duplicate, or incorrect transactions.
  • Continue until the Difference equals $0.00.
  • Click Finish Now to complete the reconciliation.
  • Save or print the reconciliation report for your records.

Note: Businesses working with large historical files can also reduce QuickBooks company file size to improve performance when accessing reports and reconciliation data.

What are the Steps to Reconcile in QuickBooks Desktop?

QuickBooks Desktop allows you to reconcile your bank and credit card accounts by comparing the transactions recorded in your company file with your financial institution’s statement. Follow these steps to reconcile in QuickBooks Desktop:

  • Open QuickBooks Desktop and sign in to your company file.
  • Go to Banking > Reconcile.
  • Select the bank or credit card account you want to reconcile.
  • Verify that the Beginning Balance matches the ending balance from your previous reconciliation.
  • Enter the Statement Date and Ending Balance exactly as they appear on your bank or credit card statement.
  • If applicable, enter any Service Charges, Interest Earned, or Finance Charges that haven’t already been recorded in QuickBooks.
  • Click Continue to open the reconciliation window.
  • Compare the transactions in QuickBooks with those on your statement.
  • Mark each matching check, payment, deposit, transfer, or credit card transaction as cleared.
  • Review and correct any missing, duplicate, or incorrectly recorded transactions if the balances don’t match.
  • Continue clearing transactions until the Difference displayed at the bottom of the window equals $0.00.
  • Click Reconcile Now to finalize the reconciliation.
  • Choose to display, print, or save the reconciliation report for your records.

Common QuickBooks Reconciliation Errors and How to Fix Them

Even after following the correct reconciliation process, you can encounter issues that prevent your account from balancing. Here are the most common QuickBooks reconciliation errors and the steps to resolve them.

ErrorHow to Fix
Difference doesn’t equal $0.00Review all transactions against your bank or credit card statement. Check for incorrect amounts, missing entries, duplicate transactions, or transactions recorded on the wrong date until the remaining difference reaches zero.
Duplicate transactionsCompare manually entered transactions with those imported through bank feeds. Exclude duplicate downloaded transactions or delete duplicate records after confirming which entry is accurate.
Edited or deleted reconciled transactionsRun the Reconciliation Discrepancy Report to identify transactions that were modified, deleted, or voided after a previous reconciliation. Restore the original transaction details before reconciling again.
Transactions recorded in the wrong accountVerify that each transaction is assigned to the correct bank or credit card account. Move incorrectly categorized transactions to the appropriate account before reconciling.
Outstanding transactions from previous periodsReview uncleared transactions carried forward from earlier reconciliation periods. Clear only the transactions that appear on the current statement and investigate any items that remain outstanding unexpectedly.
Transactions recorded in the wrong accountVerify that each transaction is assigned to the correct bank or credit card account. Move incorrectly categorized transactions to the appropriate account before reconciling.
Outstanding transactions from previous periodsReview uncleared transactions carried forward from earlier reconciliation periods. Clear only the transactions that appear on the current statement and investigate any items that remain outstanding unexpectedly.

Note: If reconciliation produces an unexpected error message, check our guide to common QuickBooks errors for additional troubleshooting steps.

Best Practices for Accurate QuickBooks Reconciliation

Following a consistent reconciliation process helps you maintain accurate financial records and reduce reconciliation errors. Here are the best practices to complete QuickBooks reconciliations efficiently.

  • Reconcile your bank and credit card accounts every month instead of waiting until the end of the year.
  • Verify that the opening balance matches your previous reconciliation before you begin.
  • Compare each transaction with your bank statement and clear only the transactions that have posted.
  • Investigate discrepancies by reviewing missing, duplicate, or incorrect transactions instead of forcing reconciliation adjustments.
  • Keep supporting documents, such as bank statements and receipts, organized for easy verification.
  • Complete the reconciliation only when the remaining difference equals $0.00.
  • Save or print the reconciliation reports after each reconciliation to maintain an audit trail and support future reviews.

Conclusion

You can reconcile in QuickBooks by verifying your statement details, matching recorded transactions with your bank or credit card statement, resolving discrepancies, and completing the reconciliation only after the difference reaches $0.00. Whether you use QuickBooks Online or QuickBooks Desktop, following the correct reconciliation workflow helps you maintain accurate financial records and reliable account balances. By applying these methods consistently and reconciling your accounts regularly, you can minimize accounting errors, improve financial reporting, and keep your business records accurate throughout the year.

Frequently Asked Questions

QuickBooks Services

Our team of qualified QuickBooks services specialists has hundreds of clients across many industries, so our experts cover you. Get more from your accounting software, QuickBooks, by requesting a free consultation right now.

Service Type: Accounting

How often should I reconcile my accounts in QuickBooks?

You should reconcile your bank and credit card accounts at least once a month, preferably after receiving your statement. Businesses with a high volume of transactions can benefit from reconciling weekly.

Can I reconcile an account if I don’t use bank feeds?

Yes. You can manually reconcile your accounts by entering transactions in QuickBooks and comparing them with your bank or credit card statement.

What happens if I skip a monthly reconciliation?

Skipping reconciliations can lead to undetected errors, inaccurate financial reports, duplicate or missing transactions, and more time spent correcting records later.

Can I undo a completed reconciliation in QuickBooks?

Yes, but the process depends on your QuickBooks version. QuickBooks Online typically requires an accountant user to undo a reconciliation, while QuickBooks Desktop allows you to manually undo unreconciled transactions or use specific tools, depending on the edition.

Can I reconcile multiple bank accounts at the same time?

No. QuickBooks allows you to reconcile one bank or credit card account at a time. You must complete the reconciliation for one account before starting another.

Easily manage data tasks or get expert help with: QuickBooks Errors, Integration, Conversion & Migration, & Download Setup
Chat with an Expert

Get in Touch with Certified ProAdvisors