A plain-English walkthrough for business owners who hear the term but don’t really know what it means.
If you use QuickBooks, you have probably heard the word reconcile. For many business owners, it sounds more complicated than it really is. Reconciling simply means comparing the transactions in QuickBooks with the transactions shown on your bank or credit-card statement to make sure they match. The goal is to confirm that your bookkeeping records reflect what actually happened in the account.
Why Reconciliation Matters
QuickBooks can import transactions from your bank, but that does not automatically mean your books are correct. Transactions can still be:
- Missing
- Duplicated
- Entered with the wrong amount
- Recorded on the wrong date
- Categorized incorrectly
- Accidentally deleted
- Added manually and imported again through the bank feed
Reconciliation is the process that helps you catch these kinds of issues.
What Are You Comparing?
When you reconcile an account, you are comparing two sets of records:
1. Your QuickBooks records
These are the transactions recorded in your books.
2. Your bank or credit-card statement
This is the official activity reported by your financial institution.
You want the ending balance in QuickBooks to agree with the ending balance on the statement after accounting for the same transactions.
A Simple Example
Imagine your bank statement shows an ending balance of:
$12,500
You open QuickBooks and begin reconciling the same month. You review the deposits, payments, transfers, fees, and other transactions one by one. If everything has been recorded properly, QuickBooks should eventually show that the difference between its records and the bank statement is:
$0.00
That means the account has been successfully reconciled for that period.
What If the Difference Is Not Zero?
If QuickBooks shows a difference, something may need to be reviewed. Common causes include:
- A missing transaction
- A duplicate transaction
- An incorrect amount
- A transaction recorded in the wrong month
- A bank fee that was not entered
- A deleted transaction
- A payment applied incorrectly
- An incorrect beginning balance
The goal is not simply to force the difference to zero. The goal is to understand why the difference exists and correct the underlying problem.
What Is the Beginning Balance?
When you start a reconciliation, QuickBooks usually shows a beginning balance. This should match the ending balance from the previous reconciliation. If it does not, something may have changed in a previously reconciled period.
For example, someone may have:
- Deleted an old transaction
- Changed the amount of a reconciled transaction
- Changed the date
- Modified the account used
A beginning-balance difference is a sign that earlier records may need to be reviewed.
What Does “Cleared” Mean?
During reconciliation, you may also see the term cleared. A cleared transaction is one that has appeared on your bank or credit-card statement. For example, if you wrote a check and your bank has processed it, that transaction has cleared.
QuickBooks uses cleared transactions during the reconciliation process to compare its records with the statement.
What Does “Reconciled” Mean?
A transaction marked as reconciled has already been included in a completed reconciliation. In QuickBooks, you may see different transaction statuses such as:
- Blank
- Cleared
- Reconciled
Once a transaction has been reconciled, it generally should not be changed without a clear reason. Changing old reconciled transactions can create problems with future reconciliations.
Is the Bank Feed the Same as Reconciliation?
No. This is an important distinction. The bank feed brings transactions into QuickBooks and helps you review, match, or categorize them.
Reconciliation confirms that the completed bookkeeping matches the actual bank or credit-card statement. You can have every bank-feed transaction categorized and still have an account that does not reconcile. The two processes work together, but they are not the same thing.
What Happens During a Typical Reconciliation?
A basic reconciliation usually looks something like this:
- Open the bank or credit-card statement.
- Enter the statement ending date.
- Enter the statement ending balance.
- Review the beginning balance.
- Compare the transactions in QuickBooks with the statement.
- Confirm deposits and payments that cleared.
- Investigate any differences.
- Finish once the difference reaches $0.00.
The exact process can vary depending on the account and how the books are maintained.
How Often Should You Reconcile?
For most small businesses, monthly reconciliation is a good standard. Each month, the business should generally reconcile important financial accounts such as:
- Checking accounts
- Savings accounts
- Business credit cards
Other accounts may also need reconciliation depending on the business. The more regularly reconciliation is performed, the easier it usually is to identify problems.
Why Waiting Makes It Harder
Imagine trying to remember what a transaction was for from last week. You may remember immediately. Now imagine trying to identify that same transaction nine months later.
That can be much more difficult. When reconciliations are completed monthly, errors are usually found closer to when they happened. If reconciliation is ignored for long periods, small bookkeeping issues can turn into a larger cleanup project.
Does a Reconciled Account Mean Everything Is Perfect?
Not necessarily. An account can reconcile even if some transactions were categorized incorrectly. For example, an advertising expense might have been mistakenly categorized as office supplies.
The amount could still match the bank statement, which means the account could technically reconcile. That is why reconciliation is an important part of bookkeeping, but it is not the only part. Good bookkeeping also requires reviewing how transactions are categorized and making sure the financial reports make sense.
Why Reconciliation Helps Your Financial Reports
Your Profit & Loss statement and Balance Sheet are based on the transactions recorded in QuickBooks. If transactions are missing or duplicated, those reports can become inaccurate. Reconciliation helps confirm that the underlying transactions match the activity reported by your financial institution.
That makes your financial reports more reliable and easier to use.
The Simplest Way to Think About It
If the word reconciliation sounds intimidating, remember this:
QuickBooks says one thing.
Your bank statement says another.
Reconciliation is simply checking that they agree. When they do, you have greater confidence that the account has been recorded properly. At Palmer Ledger, we help U.S. small businesses maintain accurate QuickBooks Online records, reconcile bank and credit-card accounts, and keep their bookkeeping organized month after month.