Education Business

Speak With a QuickBooks Reconciliation Support Expert

mehvish poll 0

QuickBooks Reconciliation: Complete Guide to Reconciling Bank and Credit Card Accounts

QuickBooks reconciliation is an important accounting process that helps ensure the transactions recorded in QuickBooks match the activity shown on your actual bank or credit card statement. When your accounts are reconciled correctly, you can have greater confidence that your financial records reflect your real cash position and that missing, duplicate, or incorrectly entered transactions are identified.

Whether you use QuickBooks Online or QuickBooks Desktop, reconciliation involves comparing transactions for a specific statement period, reviewing beginning and ending balances, marking matching transactions as cleared, and resolving any remaining difference. Ideally, the reconciliation difference should reach $0.00 before the reconciliation is completed. Intuit recommends reconciling bank and credit card accounts regularly, generally each month.

What Is QuickBooks Reconciliation?

QuickBooks reconciliation is the process of comparing the transactions recorded in your QuickBooks account with transactions appearing on your bank or credit card statement.

For example, suppose your bank statement shows:

  • Beginning balance: $8,000
  • Deposits: $5,500
  • Payments and withdrawals: $3,200
  • Ending balance: $10,300

You would compare those transactions with the corresponding records in QuickBooks. Each transaction that appears correctly on both records can be marked as cleared.

The goal is not simply to make the numbers look correct. Reconciliation helps identify accounting discrepancies, missing transactions, duplicate entries, incorrect amounts, and transactions that were recorded but have not cleared the bank.

Why QuickBooks Reconciliation Is Important

Keeping your QuickBooks accounts reconciled provides a clearer picture of your business finances.

Regular reconciliation can help you:

  • Identify missing transactions
  • Find duplicate entries
  • Detect incorrect transaction amounts
  • Review bank fees and interest
  • Identify transactions that have not cleared
  • Catch bookkeeping mistakes
  • Verify account balances
  • Prepare more reliable financial reports
  • Make tax preparation easier
  • Provide your accountant with cleaner records

Reconciliation can also help identify suspicious or unexpected activity. By comparing your books against the statement issued by your financial institution, you have another opportunity to review transactions that may otherwise be overlooked.

QuickBooks Reconciliation vs Bank Feed Matching

Bank feeds and reconciliation are related, but they are not exactly the same thing.

When a bank account is connected to QuickBooks Online, QuickBooks can download transactions from the financial institution. You can then review, categorize, and match those transactions.

Reconciliation is a separate verification step. Instead of simply accepting downloaded transactions, you compare your QuickBooks records against the official bank statement for a defined period.

A transaction being downloaded or matched does not automatically mean that the account has been reconciled.

What You Need Before Starting a Reconciliation

Before starting, gather the information for the statement period.

You should have:

  • Your bank or credit card statement
  • Statement beginning balance
  • Statement ending balance
  • Statement ending date
  • All transactions for the period
  • Any applicable bank service charges
  • Interest earned, when applicable
  • A backup of your QuickBooks Desktop company file when using Desktop

For a first-time reconciliation, review the opening balance carefully. QuickBooks Desktop uses the ending balance from the previous reconciliation as the beginning balance for the next one.

How to Reconcile an Account in QuickBooks Online

QuickBooks Online provides a dedicated reconciliation workflow.

Step 1: Open the Reconcile Page

Go to All apps, select Accounting, and then choose Reconcile.

If you are reconciling for the first time, QuickBooks may display an option to get started.

Step 2: Select the Account

Choose the bank or credit card account that you want to reconcile.

Make sure you select the correct account. Reconciling the wrong account can create confusion and make it difficult to identify the actual source of a discrepancy.

Step 3: Review the Previous Statement Date

Review the last statement ending date shown by QuickBooks.

Your current statement should generally begin on the day after the previous statement’s ending date.

Step 4: Enter the Statement Information

Enter:

  • Ending date
  • Ending balance

Use the figures directly from your bank or credit card statement rather than estimating them.

QuickBooks Online then uses this information to calculate the reconciliation difference.

Step 5: Start Matching Transactions

Compare the transactions displayed by QuickBooks with the transactions on your statement.

When you find a transaction that matches, select it.

Continue reviewing:

  • Deposits
  • Checks
  • Payments
  • Transfers
  • Fees
  • Credits
  • Other withdrawals

Step 6: Check the Difference

As transactions are selected, QuickBooks updates the cleared balance and reconciliation difference.

Continue matching transactions until the difference reaches $0.00.

A zero difference indicates that the transactions you’ve cleared reconcile with the statement information you’ve entered.

Step 7: Finish the Reconciliation

Once the difference is zero, select Finish now and then Done.

QuickBooks Online saves the reconciliation, and reconciliation history can be reviewed from the Reconcile page.

How to Reconcile an Account in QuickBooks Desktop

The workflow in QuickBooks Desktop is slightly different.

Step 1: Open Reconcile

Open QuickBooks Desktop and go to:

Banking → Reconcile

Select the bank or credit card account you want to reconcile.

Step 2: Verify the Statement Date

Check the statement date against your actual bank statement.

Do not assume the automatically displayed date is correct. Compare it with the statement you are currently working on.

Step 3: Check the Beginning Balance

QuickBooks Desktop normally carries forward the ending balance from your previous reconciliation.

Compare this amount with the beginning balance shown on your current statement.

If the beginning balance does not match, investigate the problem before continuing.

Step 4: Enter the Ending Balance

Enter the ending balance exactly as it appears on the bank or credit card statement.

If applicable, enter:

  • Service charges
  • Interest earned
  • Other required statement information

Then select Continue.

Step 5: Compare Transactions

Use your statement as the primary reference.

Find each transaction in QuickBooks and compare:

  • Date
  • Amount
  • Transaction type
  • Payee or description
  • Deposit or withdrawal

Place a checkmark beside transactions that appear on the statement.

Step 6: Reach a Zero Difference

The cleared balance changes as transactions are selected.

The objective is to bring the reconciliation difference to $0.00.

If the difference is not zero, do not immediately create an adjustment. First investigate the underlying cause. Intuit identifies incorrect ending balances, edited or deleted reconciled transactions, missing or duplicate transactions, and uncleared transactions as common causes of reconciliation problems.

Common QuickBooks Reconciliation Problems

Sometimes the reconciliation does not balance on the first attempt. This does not necessarily mean there is a major accounting problem.

Several issues can cause a difference.

Incorrect Beginning Balance

An incorrect beginning balance can affect the entire reconciliation.

This can happen when:

  • A previous reconciliation was changed
  • A reconciled transaction was deleted
  • A transaction was edited after reconciliation
  • An opening balance was entered incorrectly

If the beginning balance does not agree with the statement, investigate previous reconciliations before moving forward.

Incorrect Ending Balance

One of the simplest problems is entering the wrong ending balance.

Check the number on your statement and compare every digit with the amount entered in QuickBooks.

A small typing error can prevent the reconciliation from reaching zero.

Missing Transactions

A transaction may appear on the bank statement but not exist in QuickBooks.

Examples include:

  • Bank fees
  • Interest
  • Checks
  • Electronic payments
  • Deposits
  • Transfers
  • Debit card purchases

If the transaction genuinely belongs in your books, enter it correctly before continuing the reconciliation.

Duplicate Transactions

A transaction may have been entered manually and later downloaded through a bank connection.

This can create duplicates.

Before adding another transaction, review the existing entries carefully.

Transactions With Different Amounts

Even when the same transaction exists in both places, the amount may be different.

For example, the bank may show a payment of $475 while QuickBooks contains $457.

Do not mark the transaction as cleared until the discrepancy has been investigated and corrected.

Transaction Date Differences

A transaction recorded in QuickBooks may have a different date from the date appearing on the bank statement.

This can happen with:

  • Credit card transactions
  • Deposits
  • Electronic payments
  • Transfers
  • Pending transactions

Review the transaction details rather than assuming that two similar entries are the same.

What Does a Nonzero Reconciliation Difference Mean?

A nonzero difference means that the information entered or selected during the reconciliation does not currently agree with the statement.

For example, if QuickBooks shows a difference of $125, there may be one or more transactions responsible for that amount.

The difference could be caused by:

  • Missing transaction
  • Duplicate transaction
  • Incorrect amount
  • Incorrect ending balance
  • Incorrect beginning balance
  • Edited reconciled transaction
  • Deleted transaction
  • Bank fee not recorded
  • Interest not recorded
  • Transaction that has not cleared

The best approach is to investigate the difference instead of forcing the reconciliation to balance.

Should You Enter a Reconciliation Adjustment?

QuickBooks Desktop provides an option to enter an adjustment when the reconciliation does not balance.

However, an adjustment should not be used simply because you cannot find the problem.

An adjustment can make the reconciliation reach zero while leaving the underlying accounting error unresolved.

Before considering an adjustment, review the statement and QuickBooks transactions carefully.

Check:

  1. Beginning balance
  2. Ending balance
  3. Statement date
  4. Deposits
  5. Withdrawals
  6. Checks
  7. Transfers
  8. Fees
  9. Interest
  10. Duplicate transactions
  11. Missing transactions
  12. Previously reconciled transactions

Intuit notes that reconciliation adjustments create a journal entry and should be used only when the underlying transactions are known to be correct and the adjustment itself is appropriate.

How to Find a QuickBooks Reconciliation Discrepancy

If your account does not balance, work systematically rather than randomly changing transactions.

Compare the Beginning Balance

Start with the beginning balance.

If it does not match the statement, investigate previous reconciliations before reviewing every current-period transaction.

Compare the Ending Balance

Verify that the ending balance entered in QuickBooks is exactly the same as the bank statement.

Compare Transaction Amounts

Look for transactions where the amount differs.

For example:

  • Statement: $1,250
  • QuickBooks: $1,520

That $270 difference may explain part of the reconciliation discrepancy.

Search for Missing Transactions

Compare the statement line by line against QuickBooks.

Do not assume that every transaction downloaded from your bank has been entered correctly.

Search for Duplicates

Check for transactions entered twice.

This is especially important when transactions have been both manually recorded and imported from a bank feed.

How to Handle Outstanding Transactions

An outstanding transaction is generally one that has been recorded in QuickBooks but has not yet appeared on the bank statement.

Examples include:

  • Outstanding checks
  • Recent deposits
  • Pending electronic payments
  • Recent transfers

Do not automatically delete an outstanding transaction just because it is not on the current statement.

The transaction may legitimately clear during a later statement period.

Reconciliation of Credit Card Accounts

Credit card reconciliation follows the same basic principle as bank reconciliation.

You compare the transactions in QuickBooks with your credit card statement.

However, credit card statements can include:

  • Purchases
  • Payments
  • Credits
  • Refunds
  • Finance charges
  • Interest
  • Fees

Review charges and payments separately so that transactions are not accidentally marked incorrectly.

QuickBooks Reconciliation for Multiple Months

If several months are unreconciled, avoid trying to reconcile everything at once.

Start with the oldest unreconciled statement and work forward one statement at a time.

This makes it easier to identify when a discrepancy first appeared.

For example:

  • January — reconcile first
  • February — reconcile second
  • March — reconcile third
  • April — reconcile fourth

If January contains an incorrect beginning balance, moving directly to April can make the problem much harder to identify.

Intuit specifically recommends reconciling multiple months separately, beginning with the oldest statement.

How to Review Previous Reconciliation Reports

After completing a reconciliation, review the reconciliation report when necessary.

In QuickBooks Desktop, you can access previous reconciliation reports through the Reports Center and review details such as cleared transactions and changes made after reconciliation.

These reports can be useful when:

  • A previous reconciliation changed
  • An account balance suddenly looks incorrect
  • A transaction was edited
  • You need to investigate an old discrepancy
  • You want documentation of the reconciliation

QuickBooks Online also maintains reconciliation history from the Reconcile page.

How to Undo a Reconciliation in QuickBooks Desktop

Sometimes you may need to start a reconciliation again because a previous reconciliation contained an error.

QuickBooks Desktop provides an Undo Last Reconciliation option.

When a previous reconciliation is undone, the beginning balance returns to the previous reconciliation’s beginning balance and transactions cleared during the undone reconciliation become uncleared.

Before undoing a reconciliation, consider creating a backup and documenting the reason for the change.

QuickBooks Reconciliation Best Practices

A consistent reconciliation routine can prevent many accounting problems.

Reconcile Every Month

Monthly reconciliation makes discrepancies easier to identify because you are reviewing a smaller number of transactions.

Use the Bank Statement as Your Reference

The official statement should be your reference when verifying the account.

Do Not Force the Difference to Zero

A zero balance is the objective, but it should be achieved by correcting legitimate discrepancies rather than hiding them.

Review Before Marking Transactions Cleared

Check the date and amount before selecting a transaction.

Keep Supporting Documents

Save relevant statements and accounting documentation according to your business’s recordkeeping requirements.

Review Previous Reconciliations

If the beginning balance suddenly changes, investigate what happened rather than simply modifying the current reconciliation.

Reconcile Credit Cards Too

Bank accounts are not the only accounts that should be reconciled. Credit card accounts should also be reviewed against their statements.

QuickBooks Reconciliation Checklist

Use this checklist each time you reconcile an account:

  • Select the correct account
  • Confirm the statement period
  • Verify the beginning balance
  • Enter the correct ending balance
  • Confirm the statement ending date
  • Record applicable fees
  • Record applicable interest
  • Compare every transaction
  • Look for missing transactions
  • Check for duplicate transactions
  • Review outstanding transactions
  • Investigate discrepancies
  • Avoid unnecessary adjustments
  • Confirm the difference is $0.00
  • Complete the reconciliation
  • Review the reconciliation report

QuickBooks Reconciliation Errors After Completing a Reconciliation

A reconciliation can be completed successfully and still develop problems later.

For example, someone may edit or delete a transaction that was previously reconciled.

This can cause the account balance to change and create a discrepancy during a later reconciliation.

If a previously reconciled account suddenly stops matching, review changes to reconciled transactions and compare the current account history with the previous reconciliation report.

Intuit specifically lists edited or deleted reconciled transactions among the causes of ending-balance issues.

When QuickBooks Reconciliation Does Not Match the Bank

If your QuickBooks balance does not match your bank statement, avoid changing multiple transactions at once.

Instead, use a structured approach.

First, verify the statement date and ending balance.

Next, check the beginning balance.

Then compare deposits and withdrawals individually.

After that, look for missing or duplicate transactions.

Finally, investigate transactions that were changed after a previous reconciliation.

This approach helps preserve the integrity of your accounting records while making it easier to identify the actual cause.

QuickBooks Reconciliation and Accurate Financial Reports

Reconciliation contributes to more reliable financial reporting.

If your bank account contains transactions that are missing from QuickBooks, your financial statements may not accurately reflect business activity.

Similarly, duplicate or incorrectly recorded transactions can distort account balances and affect reports.

By reconciling regularly, you create an additional layer of verification between your bookkeeping records and the activity reported by your financial institution.

Final Thoughts on QuickBooks Reconciliation

QuickBooks reconciliation is more than a routine bookkeeping task. It is a method for verifying that your QuickBooks records agree with your real-world bank and credit card activity.

The basic process is straightforward: select the correct account, enter the statement information, compare transactions, investigate discrepancies, and complete the reconciliation when the difference reaches $0.00.

When a reconciliation does not balance, avoid immediately creating an adjustment. Review beginning and ending balances, missing transactions, duplicate entries, transaction amounts, bank fees, interest, and changes to previously reconciled transactions.

Whether you use QuickBooks Online or QuickBooks Desktop, performing regular reconciliations can help maintain cleaner accounting records and make financial information easier to review and trust.

mehvish poll

Website:

Related Story