Bookkeeper Group

Keeping it Real

Reconciliation Guide: The Key Checks That Keep Your Books Accurate

Banking

If bookkeeping had a "truth serum," it would be reconciliation. Reconciliations are the quality control system of accounting. They ensure that the numbers in your software match the reality in your bank accounts, credit cards, and loan statements. Without them, your financial reports are just unverified estimates.

Overview

This guide explains what reconciliations are, why they are the most critical step in the monthly close process, and how to troubleshoot errors when things don't add up.

This guide explains:

  • What reconciliations actually do (it's more than just matching transactions)
  • The hidden risks of skipping reconciliations
  • A step-by-step breakdown of the most important monthly checks
  • Troubleshooting tips: How to find the error when the numbers won't balance

What Is a Reconciliation?

A reconciliation is the process of comparing two independent sources of information to prove that they agree.

In bookkeeping, the most common example is comparing:

  1. Your Records: What you think you have (your accounting software balance).
  2. External Truth: What you actually have (the bank statement balance).

The goal isn't just to "make the numbers match" by forcing an adjustment. The goal is to explain every difference.

Differences usually fall into two categories:

  • Timing Differences: You wrote a check on Monday, but the bank won't clear it until Thursday. This is normal.
  • Errors: You recorded a deposit as $100, but the bank received $10. This must be fixed.

Why Reconciliations Matter

If you don't reconcile, you are flying blind. Here is why:

  • Catch Errors Early: Did you accidentally enter a $500 expense as $5,000? A reconciliation will find this immediately.
  • Prevent Fraud: Is there a check clearing your bank that you didn't write? Or a duplicate payment to a vendor?
  • Ensure Accurate Tax Filings: If your cash balance is wrong, your income or expenses are likely wrong too.
  • Build Confidence: Lenders and investors trust reconciled books. They treat unreconciled books with extreme suspicion.

The Golden Rule: If you haven't reconciled your bank accounts, you haven't finished your bookkeeping.

Reconciliations in the Accounting Cycle

Reconciliations sit at the end of each accounting period (usually monthly), just before you print your financial reports.

A typical workflow looks like this:

  1. Record: Enter all invoices, bills, and daily transactions.
  2. Reconcile: Compare your accounts to bank statements and other external documents.
  3. Review: Look at the resulting financial statements for odd trends.
  4. Close: Lock the period so no one can accidentally change the past.

Skipping step 2 undermines everything that follows.

Key Reconciliations You Should Perform

Bank Reconciliations (The "Must-Do")

What it is: Comparing the cash balance in your accounting system (General Ledger) to the ending balance on your monthly bank statement.

Why it matters: Cash is the lifeblood of your business. It is also the account most prone to theft and error.

The Process:

  1. Start with the Statement: Enter the ending balance and date from your physical (or PDF) bank statement.
  2. Clear Transactions: Check off every deposit and withdrawal in your software that appears on the statement.
  3. Identify Differences: Anything left unchecked in your software is an "outstanding item" (e.g., a check you mailed that hasn't been cashed yet).
  4. Add Missing Items: Did the bank charge a fee? Did you earn interest? Add these now.

Why Balances Might Differ:

  • Deposits in Transit: You deposited cash on the 31st, but the bank posted it on the 1st.
  • Outstanding Checks: You mailed a check to a vendor, but they haven't deposited it yet.

Best Practice:

  • Reconcile every bank account every single month.
  • Never reconcile to the "online banking balance"—it changes daily. Use the static monthly statement.
  • Zero Difference: Do not finish until the difference is $0.00.

Credit Card Reconciliations

What it is: Matching your credit card statement line-by-line to your recorded expenses.

Why it matters: Credit cards are often messy. It's easy to miss a recurring subscription charge, double-count a transaction, or accidentally pay for a personal item on the business card.

Key Checks:

  • Pending vs. Posted: Only reconcile transactions that have posted on the statement. Ignore pending charges until next month.
  • Interest and Fees: Don't forget to record finance charges.
  • Personal Expenses: If you spot a personal charge, reclassify it to "Owner Draws" immediately.
  • Payments: Ensure the payment from your checking account matches the payment received on the credit card statement.

Accounts Receivable (A/R) Reconciliation

What it is: Verifying that the list of people who owe you money (A/R Aging) matches your total A/R balance and reflects reality.

Why it matters: You can't pay your bills if you don't collect your cash. "Phantom Revenue" occurs when you think you have sales, but the invoices are uncollectible.

What to Review:

  • The A/R Aging Report: Look at the "90+ days" column. Why haven't these customers paid?
  • Ghost Invoices: Are there old invoices for work that was never done or was cancelled?
  • Unapplied Payments: Did a customer pay you, but the payment is sitting as a "credit" instead of being applied to the invoice?

Best Practice: Review the A/R Aging detail monthly. If you know you'll never collect an invoice, write it off to Bad Debt—don't let it clutter your books forever.

Accounts Payable (A/P) Reconciliation

What it is: Ensuring the list of bills you owe (A/P Aging) matches what you actually plan to pay.

Why it matters: "Hidden Liabilities" can wreck your cash flow forecast. You think you have cash, but you forgot about a big bill due next week.

What to Review:

  • Old Bills: Why is there a bill from last year? Was it already paid with a credit card or check that wasn't linked to the bill?
  • Duplicate Vendors: Do you have "Comcast" and "Comcast Business" with balances in both?
  • Negative Balances: A negative number in A/P usually means you paid more than the bill amount, or you paid a bill that wasn't entered.

Payroll Reconciliation

What it is: Verifying that your recorded payroll expenses match your payroll provider's reports and the tax forms (like Form 941) filed with the IRS.

Why it matters: Payroll liabilities (taxes owed) are serious. The IRS does not forgive payroll tax errors easily.

What to Check:

  • Gross Wages: Does the total salary expense in your P&L match the "Total Gross Pay" on your payroll summary?
  • Employer Taxes: Are the Social Security, Medicare, and Unemployment taxes recorded correctly?
  • Net Pay: Did the cash leaving your bank account match the "Net Pay" on the report?

Inventory Reconciliation (If Applicable)

What it is: Comparing the value of inventory in your computer system to the physical items sitting on your shelf.

Why it matters: If your system says you have 100 units but you only have 80, your asset value is overstated and your profit is wrong.

Best Practice:

  • Perform a physical count (stocktake) at least annually, preferably quarterly or monthly for high-value items.
  • Adjust the inventory balance in your books to match the physical count. The difference is usually "Cost of Goods Sold" (shrinkage).

Loan and Debt Reconciliations

What it is: Confirming that your loan balance on the Balance Sheet matches the statement from the lender.

Why it matters: Loan payments are split between Principal (reduces the loan) and Interest (expense). If you just book the whole payment to the loan, your loan balance will drop too fast, and you'll miss out on the interest tax deduction.

Best Practice:

  • Check the ending principal balance against the lender's statement every month.
  • Adjust the interest expense so the loan balance matches exactly.

Pro-Forma Financial Statements and Analytical Reviews

What it is: Reviewing draft (pro-forma) financial statements before finalizing them. This is the "gut check" phase.

Why it matters: This is where errors surface that individual reconciliations miss. You might have reconciled every account perfectly, but misclassified a huge expense.

What to Review:

  • Month-over-Month Changes: Did "Office Supplies" jump from $200 to $2,000? Why?
  • Gross Margin Trends: Did your margin drop from 40% to 20%? Did you forget to bill a client?
  • Expense Ratios: Are wages 80% of revenue this month when they are usually 50%?

Best Practice:

  • Compare current period to prior period (Variance Analysis).
  • Ask "does this make sense?" If the story feels wrong, something probably is.

Troubleshooting Reconciliation Errors: What to Do When It Doesn't Match

So, you entered the ending balance, checked off the transactions, and the difference is not zero. Don't panic. Here is how to find the problem.

1. Check the Basics First

  • Starting Balance: Does the beginning balance on your screen match the beginning balance on the statement? If not, someone changed a transaction after it was reconciled last month.
  • Ending Balance: Did you type the ending balance correctly? Did you use the correct date?

2. Count the Transactions

  • Does the statement say "Total Deposits: 5, Total Amount: $5,000"? Count the deposits you checked off. Do you have 5? Do they total $5,000? Isolate whether the error is in deposits or withdrawals.

3. Look for "Transposition Errors"

  • If the difference is divisible by 9 (e.g., $0.27, $54, $81), you likely transposed a number.
    • Example: You entered $59 instead of $95. The difference is $36 (divisible by 9).
    • Search for transactions with those digits.

4. Check for Inverted Signs

  • Is the difference exactly 2x the amount of a transaction?
    • Example: You entered a $100 payment as a $100 deposit. You are now off by $200.
    • Look for a transaction that is half the amount of your discrepancy.

5. Check Dates

  • Did you enter a transaction with next month's date by mistake? It won't show up in the reconciliation window if the date is outside the period.

6. The "Force Adjustment" Trap

  • Never just click "Add Adjustment" to force the difference to zero unless the amount is tiny (like pennies) and you have given up finding it. A large adjustment hides errors that will come back to haunt you.

Common Reconciliation Mistakes

  • Skipping reconciliations when "things look fine": Errors hide in plain sight.
  • Forcing balances to match: Using "plugs" or adjustments instead of finding the error.
  • Reconciling to online balances: The online balance includes pending items; the statement does not.
  • Ignoring old A/R or A/P: Letting uncollectible invoices sit on the books distorts your asset value.
  • Letting clearing accounts linger: "Undeposited Funds" or "Payroll Clearing" should zero out regularly.

Reconciliations are not a cleanup step. They're a control.

How Often Should Reconciliations Be Done?

Reconciliation Frequency
Bank & credit cards Monthly
A/R & A/P aging Monthly
Payroll Each payroll / monthly
Inventory Monthly or quarterly
Loans Monthly
Financial statement review Monthly

Final Thoughts

Reconciliations are what turn bookkeeping into reliable accounting.

They:

  • Validate your work.
  • Catch errors before they become disasters.
  • Protect cash from theft and waste.
  • Build trust in your financial reports.

If you skip reconciliations, your numbers are just guesses. When you reconcile, you move from guessing to knowing.

Next steps