You open your business banking app and see:

Bank balance: $84,250

Then you open your accounting software.

It says:

Bank balance: $97,680

That is a difference of:

$13,430

Which number is correct?

Can you spend the $97,680?

Did the business forget to record expenses?

Did a customer payment get duplicated?

Did someone delete a transaction?

Or are there simply cheques that have not cleared yet?

This is exactly why businesses perform bank reconciliations.

Bank reconciliation means comparing your accounting records with the actual transactions reported by your bank and investigating anything that does not match. When performed properly, reconciliation can uncover timing differences, missing transactions, duplicate entries, data-entry errors and even unauthorized transactions.

A difference between your bank balance and bookkeeping balance does not always mean something is wrong.

Some differences are completely normal.

The problem begins when nobody knows why the balances are different.

If unreconciled accounts continue for months, errors can flow into:

• Cash flow reports
• Profit and loss statements
• Balance sheets
• GST/HST balances
• Accounts receivable
• Accounts payable
• Tax returns
• Financing applications
• Management decisions

Here are seven common reconciliation problems Canadian businesses should identify and fix.

Important: This article provides general bookkeeping and accounting information only. The correct accounting treatment depends on the transaction and your financial reporting requirements.

What Is a Bank Reconciliation?

A bank reconciliation compares:

The transactions recorded by your bank

with:

The transactions recorded in your bookkeeping system

The goal is not necessarily for the two balances displayed on the screen to match immediately.

Instead, you identify legitimate differences and make sure the adjusted balances reconcile.

For example, a cheque may already have been recorded in your books but not yet processed by the bank.

Or a deposit may have been recorded in your accounting system on Friday but not appear at the bank until Monday.

These are normal timing differences.

Other differences may require correcting entries.

QuickBooks Canada’s reconciliation guidance notes that regular reconciliation helps identify errors, omissions, timing issues and unauthorized transactions before they become larger financial problems.

Problem 1: Outstanding Cheques Have Not Cleared the Bank

Suppose your company pays a supplier:

$12,000

on June 28.

Your bookkeeper records the payment immediately.

Your books now show cash reduced by:

$12,000

But the supplier does not deposit the cheque until July 5.

At June 30:

Your bookkeeping system has already deducted $12,000.

Your bank has not.

Therefore, the bank balance appears:

$12,000 higher

than the book balance.

That difference does not necessarily mean an accounting mistake exists.

It is an outstanding cheque.

Outstanding cheques are a common and legitimate reason bank and book balances differ.

The Problem

Trouble begins when an outstanding cheque remains uncleared for months.

Maybe:

• The supplier lost it
• The cheque was never mailed
• Payment was cancelled
• A replacement cheque was issued
• The invoice was paid another way
• The accounting entry was duplicated

A cheque that remains outstanding indefinitely should not simply sit on the reconciliation report forever.

The Fix

Review your outstanding cheque list every month.

For older items, ask:

1. Was the payment actually delivered?
2. Has the supplier been paid another way?
3. Should the original cheque be cancelled?
4. Was a replacement cheque issued?
5. Does the accounting entry need correction?

Old outstanding payments should be investigated rather than carried forward automatically.

Problem 2: Deposits Are Recorded in the Books but Have Not Reached the Bank

The opposite issue can also happen.

Suppose a customer pays:

$20,000

on December 31.

Your accounting system records the payment.

The deposit does not actually clear the bank until January 2.

At December 31:

Books show:

+$20,000

Bank does not yet show it.

This is commonly called a:

Deposit in transit

or:

Outstanding deposit

QuickBooks identifies deposits in transit as normal reconciliation items created by the timing difference between recording a deposit and the bank processing it.

When It Becomes a Problem

A deposit recorded as “in transit” should usually clear relatively soon.

If the same $20,000 deposit remains outstanding two months later, something may be wrong.

Possible problems include:

• Payment was never received
• Deposit was entered twice
• Deposit was posted to the wrong bank account
• Customer payment was reversed
• Cheque bounced
• Deposit date was incorrect
• Someone recorded revenue before payment occurred

The Fix

Match each deposit in transit to:

• Bank deposit receipt
• Customer payment record
• Electronic transfer
• Merchant processor settlement
• Customer invoice

Do not keep rolling forward old deposits simply because they appeared on last month’s reconciliation.

Problem 3: Bank Fees, Interest and Automatic Withdrawals Were Never Entered in the Books

Many transactions happen directly at the bank.

Your bookkeeper may never see an invoice.

Examples include:

• Monthly bank fees
• Credit card fees
• Wire fees
• Loan payments
• Merchant fees
• Interest charges
• Interest income
• Automatic insurance payments
• Software subscriptions
• Pre-authorized payments

Suppose your books show:

$60,000 cash

Your bank shows:

$58,750

During reconciliation, you discover:

Bank service fees: $250

Loan withdrawal: $1,000

Neither was recorded.

Difference:

$1,250

Once those transactions are entered properly, the balance may reconcile.

Bank reconciliation guidance specifically identifies bank service charges, NSF charges and interest as common transactions that need to be added to the accounting records during reconciliation.

The Bigger Problem

If these transactions are missed for several months, your reports may understate expenses.

That can make profit look stronger than it really is.

It can also distort:

• Loan balances
• Interest expense
• Subscription expenses
• Bank charges
• Cash forecasts

The Fix

Reconcile every business bank and credit card account monthly.

High-volume businesses may need to reconcile more frequently. Regular monthly reconciliation is generally considered a practical minimum, while businesses processing large numbers of transactions may benefit from weekly or even more frequent reviews.

Problem 4: Transactions Were Duplicated

Bank feeds make bookkeeping faster.

They can also make duplicate entries easier to create.

Imagine your company pays rent:

$8,000

The bookkeeper manually records the rent payment.

Then the bank feed imports the same transaction.

Instead of matching the bank feed transaction to the existing entry, someone clicks:

Add

Now the books contain:

Rent payment 1: $8,000

Rent payment 2: $8,000

Total rent expense:

$16,000

But only $8,000 actually left the bank.

Now:

• Cash is understated by $8,000
• Rent expense is overstated by $8,000
• Profit is understated by $8,000

The books can be perfectly “organized” and still be wrong.

Duplicate transactions are one of the common causes of reconciliation differences identified in accounting software troubleshooting guidance.

The Fix

When using bank feeds:

Do not automatically add every imported transaction.

Instead:

1. Look for an existing transaction.
2. Match when appropriate.
3. Investigate duplicate amounts and dates.
4. Review unusual vendor activity.
5. Reconcile after bank-feed coding is complete.

Automation should reduce data entry.

It should not replace review.

Problem 5: Transactions Were Entered With the Wrong Amount, Date or Bank Account

Sometimes the transaction exists in both places but still does not match.

For example:

Actual bank payment:

$5,430

Bookkeeping entry:

$5,340

Difference:

$90

That is a classic transposition error.

Other examples include:

Actual transaction:

$1,275

Books:

$1,725

or:

Transaction paid from:

Operating account

but recorded in:

Savings account

or:

Payment made:

August 31

but entered:

September 30

These mistakes can be surprisingly difficult to find when transaction volumes are high.

Data-entry errors, incorrect dates and transposed numbers are common reconciliation problems.

Quick Tip

If your reconciliation difference is divisible by 9, check for a possible transposition error.

For example:

$1,254 entered as $1,524.

Difference:

$270

270 ÷ 9 = 30.

That does not prove a transposition occurred, but it can provide a useful clue.

The Fix

Compare:

• Amount
• Transaction date
• Bank account
• Payee
• Reference number

Do not correct a reconciliation difference by posting a random journal entry just to make the numbers match.

Find the underlying transaction.

Problem 6: Someone Changed or Deleted a Previously Reconciled Transaction

This can create one of the most frustrating bookkeeping problems.

Last month, your bank account reconciled perfectly.

Difference:

$0

This month, the accounting software says your beginning balance is wrong.

What happened?

Someone may have:

• Deleted an old cheque
• Changed an invoice payment
• Changed a transaction amount
• Changed the bank account
• Changed the transaction date
• Deleted a deposit
• Posted a journal entry against cash

Accounting systems may show reconciliation discrepancy reports or audit trails that identify changed or deleted transactions. QuickBooks specifically identifies edited or deleted previously reconciled transactions as a common cause of ending-balance problems.

Example

March reconciliation completed:

$0 difference

In June, someone opens a March supplier payment and changes:

$6,500

to:

$5,500

Now historical cash changes by:

$1,000

The March reconciliation no longer reflects the current ledger.

The Fix

Restrict who can:

• Delete transactions
• Edit closed periods
• Create journal entries
• Change reconciliation history

Use your accounting software’s audit log where available.

And establish a closing process.

Once a month or year is finalized, changes to historical periods should require review.

This is exactly the kind of control that becomes necessary when a company grows beyond basic bookkeeping. Aterna’s Signs Your Business Has Outgrown Basic Bookkeeping explains how higher transaction volume and complexity create a need for stronger financial controls and reporting.

Problem 7: Personal and Business Transactions Are Being Mixed Together

This problem is especially common in owner-managed businesses.

The owner pays a personal expense from the corporate bank account.

Examples:

• Personal restaurant bill
• Family vacation
• Home furniture
• Personal insurance
• Grocery purchase

The bank shows the payment.

But nobody knows how to classify it.

So the bookkeeper might:

• Leave it uncategorized
• Post it to office expense
• Post it to meals
• Put it into suspense
• Ignore it

Now the bank reconciliation might technically match after the transaction is recorded, but the accounting is still wrong.

This is an important distinction:

A reconciled bank account does not automatically mean accurate bookkeeping.

Every bank transaction can be entered and the account can reconcile to $0 while expenses, shareholder balances, GST/HST and profit are still incorrect.

Example

Owner purchases:

$4,000 personal furniture

using corporate Visa.

Bookkeeper records:

Office furniture: $4,000

The credit card now reconciles.

But the company may have improperly recorded a personal transaction as a business asset.

That can create:

• Incorrect expenses
• Incorrect GST/HST claims
• Shareholder benefit concerns
• Incorrect shareholder loan balances

The Fix

Keep personal and business spending separate.

If a shareholder uses corporate funds personally, identify and record the transaction correctly rather than forcing it into a business expense category.

Good reconciliation answers:

Did we record everything?

Good bookkeeping also asks:

Did we record everything correctly?

Your Bank Balance Is Not the Same as Your Available Business Cash

This is one of the biggest mistakes owners make.

They check online banking and see:

$150,000

Then they think:

“We have $150,000 available.”

Maybe not.

The bank balance does not automatically tell you about:

• Outstanding cheques
• Payroll due next week
• GST/HST payable
• Corporate tax
• Supplier payments
• Loan payments
• Customer deposits
• Future project obligations

That is why Aterna’s article How Poor Cash Flow Management Kills Growing Businesses warns against using the bank account as the only measure of financial health. A company may have strong revenue and a healthy-looking bank balance while major obligations are approaching.

For short-term planning, Aterna’s 13-Week Cash Flow Forecast takes the analysis further by comparing expected weekly cash receipts and payments rather than relying on today’s bank balance.

Example: Why Your Bank Shows $125,000 but Your Books Show $101,500

Consider Maple Construction Inc.

Bank statement balance:

$125,000

Accounting balance:

$101,500

Difference:

$23,500

The owner is worried.

During reconciliation, the accountant discovers:

Outstanding supplier cheque: $20,000

Bank fees not recorded: $300

Interest earned not recorded: $200

Duplicate expense entry: $3,000

Let’s analyze it.

The $20,000 outstanding cheque is a legitimate timing difference.

The $300 bank fee needs to be recorded.

The $200 interest income needs to be recorded.

The duplicate $3,000 expense needs to be removed.

After all entries and timing adjustments are properly treated, the account can reconcile.

The original $23,500 difference looked alarming.

The real issue was a combination of:

• Normal timing differences
• Missing transactions
• Duplicate bookkeeping

That is exactly what reconciliation is designed to identify.

Why Bank Reconciliation Matters Beyond Bookkeeping

Bank reconciliation may seem like an administrative task.

It affects much more.

1. Cash Flow Decisions

If your cash balance is wrong, management can overspend.

A company may hire employees or buy equipment based on cash that is already committed to outstanding payments.

2. Profit

Missing expenses can overstate profit.

Duplicate expenses can understate it.

3. GST/HST

Incorrect transactions can affect:

• GST/HST collected
• Input tax credits
• GST/HST payable

4. Accounts Receivable

Customer payments may be incorrectly matched, leaving invoices appearing unpaid even after the cash has arrived.

5. Accounts Payable

Supplier bills may appear unpaid even when they have already been settled.

6. Financing

Banks and investors expect accurate financial records.

Aterna’s guide How to Prepare Your Business for Investors or Bank Financing specifically recommends reconciling bank accounts and cleaning up financial records before approaching lenders.

A lender comparing your financial statements with bank records does not want to hear:

“We’re not sure why those numbers are different.”

7. Fraud Detection

Reconciliation can help identify:

• Unknown withdrawals
• Duplicate payments
• Unauthorized transfers
• Altered cheques
• Unexpected electronic transactions

Regular reconciliation is an important internal control partly because unusual or unauthorized transactions become easier to identify.

Should Your Bank Balance and Book Balance Match Every Day?

Not necessarily.

Timing differences are normal.

Imagine you issue a cheque today.

Books recognize it today.

The bank may not process it for several days.

Or a customer sends an electronic payment late Friday.

You record it Friday.

The bank may process it Monday.

The goal is not to force both screens to show the same number every minute.

The goal is to be able to explain every difference.

A reconciled account means:

Bank balance

plus or minus legitimate timing differences

equals:

Adjusted book balance

after required accounting entries.

How Often Should a Canadian Business Reconcile Its Accounts?

For many small businesses:

Monthly

is a reasonable minimum.

Businesses with:

• High transaction volumes
• Multiple bank accounts
• Large cash movements
• Ecommerce sales
• Multiple credit cards
• Significant payroll
• High fraud risk

may benefit from weekly or even more frequent reconciliation. QuickBooks Canada similarly notes that monthly reconciliation is common while businesses with heavy transaction volumes may need more frequent reviews.

Do not wait until year-end.

Trying to reconcile 12 months of activity at once can turn a simple bookkeeping task into a major cleanup project.

Your Credit Cards Need Reconciliation Too

Businesses often reconcile the bank account but ignore corporate credit cards.

That is a mistake.

Credit cards should also be reconciled against their statements.

Otherwise, the books may contain:

• Missing purchases
• Duplicate transactions
• Personal expenses
• Missing interest
• Missing annual fees
• Refunds not recorded
• Incorrect opening balances

If your bank is reconciled but your $70,000 corporate credit-card liability is wrong, your financial statements are still unreliable.

What About Stripe, PayPal, Shopify and Payment Processors?

This is another major source of confusion.

Suppose a customer pays:

$10,000

through a payment processor.

The processor deducts:

$300 fee

and deposits:

$9,700

into your bank.

If the bookkeeper records only:

Revenue: $9,700

the bank may appear to reconcile.

But the accounting is wrong.

The correct economic activity was:

Gross customer payment: $10,000

Processing fee: $300

Net deposit: $9,700

Recording only net deposits can understate both revenue and expenses.

Businesses using payment processors should reconcile:

1. Customer sales
2. Processor clearing account
3. Processor fees
4. Refunds
5. Actual bank deposits

This is especially important for ecommerce and high-volume service businesses.

What If the Bank Reconciliation Is Off by a Few Dollars?

Do not automatically create a:

“Reconciliation adjustment”

to force the difference to zero.

A difference of:

$7.42

may seem irrelevant.

But it could represent:

• Bank fee
• Incorrect GST/HST
• Data entry mistake
• Duplicate transaction
• Partial customer payment

Small unexplained differences repeated every month eventually become large problems.

Find the reason.

A Better Monthly Bank Reconciliation Process

Use this workflow.

Step 1: Obtain the Bank Statement

Use the actual statement ending date and ending balance.

Step 2: Match Deposits

Confirm each bank deposit exists in the accounting records.

Step 3: Match Withdrawals

Confirm:

• Cheques
• EFT payments
• Transfers
• Automatic withdrawals

Step 4: Identify Outstanding Transactions

Separate legitimate timing differences such as:

• Outstanding cheques
• Deposits in transit

Step 5: Enter Bank-Only Transactions

Record:

• Fees
• Interest
• Automatic payments
• NSF transactions

Step 6: Search for Duplicates

Look for identical:

• Dates
• Amounts
• Suppliers
• Customer receipts

Step 7: Investigate Old Outstanding Items

Do not simply carry them forward.

Step 8: Review Changes to Prior Reconciliations

Use audit or discrepancy reports where available.

Step 9: Confirm the Difference Is Zero

Only after every difference has been explained.

Step 10: Review the Reconciliation

Where possible, have someone other than the person entering day-to-day payments review the reconciliation.

Separating transaction processing from reconciliation can strengthen internal controls.

Red Flags Your Reconciliation Process Is Not Working

Your bookkeeping deserves immediate attention if:

• Bank reconciliations have not been completed for months
• Opening balance keeps changing
• Large unreconciled differences remain
• Old cheques never clear
• Deposits remain outstanding for months
• Personal spending is mixed with company activity
• Large amounts sit in “Ask My Accountant” or suspense accounts
• Historical transactions are frequently edited
• Customer payments do not match accounts receivable
• Financial reports change dramatically after year-end cleanup

These are often signs that the company has moved beyond basic transaction entry and needs a stronger bookkeeping system.

Aterna’s Signs Your Business Has Outgrown Basic Bookkeeping describes this transition as businesses gain more customers, employees, locations and transactions and require deeper reporting and stronger controls.

Frequently Asked Questions

Why does my bank balance not match QuickBooks?

Common reasons include outstanding cheques, deposits in transit, bank fees, missing transactions, duplicate transactions, editing of previously reconciled transactions and data-entry errors.

Is it normal for the bank balance and book balance to be different?

Yes.

Timing differences can create legitimate differences.

For example, a cheque recorded in your books may not yet have cleared the bank, or a deposit may still be processing.

The important issue is whether the difference can be explained and reconciled.

What is an outstanding cheque?

An outstanding cheque is a payment already recorded in your accounting records that has not yet cleared the bank.

What is a deposit in transit?

A deposit in transit is a deposit recorded in the books that has not yet been processed by the bank at the reconciliation date.

Should I make a journal entry to force my bank reconciliation to balance?

Not simply to remove the difference.

First identify the reason.

A correcting journal entry may be appropriate if an accounting entry is genuinely missing or incorrect, but unexplained adjustments can hide underlying bookkeeping problems.

How often should I reconcile my business bank account?

Monthly is a common minimum. Businesses with high transaction volumes may benefit from weekly or more frequent reconciliations.

Should business credit cards also be reconciled?

Yes.

Corporate credit cards should be reconciled to their statements just like bank accounts to identify missing, duplicate or incorrectly classified transactions.

Can my bank account reconcile even when my bookkeeping is wrong?

Yes.

Every bank transaction could be recorded while some transactions are categorized incorrectly.

For example, a personal shareholder purchase could be incorrectly recorded as a business expense while the bank still reconciles perfectly.

Bank reconciliation confirms completeness and matching.

It does not replace accounting review.

A $0 Reconciliation Difference Is the Beginning, Not the End

A business owner should be able to ask:

“How much cash do we actually have?”

and receive a reliable answer.

That becomes difficult when the bank says one number and the accounting system says another.

Some differences are normal.

Outstanding cheques and deposits in transit happen every day.

But unexplained differences are different.

They can signal:

• Missing expenses
• Duplicate transactions
• Incorrect customer payments
• Old entries
• Personal spending
• Deleted transactions
• Fraud
• Weak bookkeeping controls

The goal of reconciliation is not merely to make software display:

Difference: $0.00

The real objective is to know that the financial records reflect what actually happened.

Aterna Advisors provides bookkeeping, accounting, financial reporting and advisory support for Canadian businesses. If your business routinely has unexplained reconciliation differences, the problem may not be one missing transaction. It may be a sign that your bookkeeping process needs stronger controls, more frequent review and better financial oversight.