Aller au contenu

Bank reconciliation: 5 mistakes that cost small businesses dearly

Bank reconciliation means comparing the balance of your bank account in your books with the balance on the bank statement, then explaining every difference. It is the simplest control in accounting, and yet the one most often postponed. When it is done badly, errors spread everywhere: sales taxes, financial statements, receivables, income tax.

Here are the five mistakes found most often in small business files, and how to avoid them.

Mistake 1: forcing the difference with an adjusting entry

The statement shows $18,240.15, the books show $18,312.40. The difference is $72.25. Rather than investigate, someone posts a « bank adjustment » entry of $72.25 and the reconciliation balances.

The problem: the difference had a cause. A cheque recorded twice, a deposit entered for the wrong amount, forgotten bank fees. By forcing it, you hide the error instead of correcting it. And the difference often comes back the following month, in another form.

How to avoid it. An unexplained difference stays an unexplained difference. Note it, look for it, and only close it with an entry that describes its real cause. A few classic leads:

  • an amount with two digits swapped (the difference is then divisible by 9);
  • a transaction entered with the wrong sign (the difference is then twice the amount);
  • a transaction on the statement and missing from the books, or the reverse.

Mistake 2: ignoring outstanding items

A cheque issued on the 29th but cashed by the supplier on the 5th of the following month does not appear on the month-end statement. A deposit made on the last business day may only appear on the next statement. These outstanding items are normal.

The mistake is to treat them as errors, or to delete the cheque entry to « make it balance » and enter it again the following month. Expense dates become wrong, and so does the month-end balance.

How to avoid it. Reconciliation is done at a precise cut-off date: the statement end date. Outstanding cheques and deposits in transit are listed as reconciling items, not modified. Watch them the following month: a cheque outstanding for several months deserves a call to the supplier.

Mistake 3: duplicate entries

This has become the most frequent mistake since bank transactions can be imported. A supplier bill is entered and paid in the software. Then the bank transaction for the same payment is imported and categorized as a new expense. The expense is counted twice, and the supplier account never clears.

The same problem affects sales: a customer invoice is marked paid in the software, then the imported deposit is recorded as new revenue. Revenue is inflated, and so is the sales tax collected.

How to avoid it. Every imported transaction must be matched to what already exists before it is categorized: an invoice payment, a receipt, a transfer between accounts. A new expense or revenue is only created if nothing exists. Good software suggests matches first, and creation only after.

Mistake 4: forgetting what only the bank knows

Some transactions have no supporting document in the business. The bank is the only one that knows about them:

  • monthly bank fees and transaction fees;
  • interest earned and interest charged;
  • pre-authorized debits (insurance, equipment leases, subscriptions);
  • card payment processing fees;
  • loan payments, to be split between principal and interest.

If nobody enters them from the statement, they are missing from the books. Expenses are understated, and the bank balance in the books is wrong.

How to avoid it. The bank statement is a supporting document in its own right. Go through it line by line. For recurring transactions, create a categorization rule: same supplier, same account, every month. For loan payments, use the lender’s amortization schedule to separate principal from interest correctly.

Mistake 5: reconciling once a year

Many small businesses only reconcile at year-end, often at the accountant’s request. The workload is then at its peak: twelve statements, hundreds of transactions, vague memories and missing documents.

Worse, the errors have already had consequences. The year’s GST and QST returns were filed with unreconciled figures. Unpaid customer invoices went unnoticed for months. A fraudulent debit may have gone through unnoticed.

How to avoid it. Reconcile every month, when the statement arrives, and at the very least before every sales tax return. A monthly reconciliation often takes less than an hour for a small business. The same reconciliation done twelve months later can take days.

Do not forget the other accounts: business credit cards, lines of credit, US dollar accounts, clearing accounts such as payment platforms. Each one has a statement, and each one must be reconciled.

A six-step monthly routine

  1. Import the month’s statement (OFX file or PDF statement).
  2. Match each transaction to an existing invoice, payment or transfer.
  3. Categorize the remaining transactions, starting with bank fees and pre-authorized debits.
  4. List outstanding cheques and deposits in transit at the statement date.
  5. Check that the reconciled balance equals the statement balance, to the cent.
  6. Keep the reconciliation report with the statement, for your accountant.

In BooksMatic

BooksMatic imports OFX files and PDF statements, and offers full manual reconciliation from the Essential plan. With the Growth plan, smart bank reconciliation adds automatic suggestions based on your history, and categorization learns from your suppliers. Imported transactions are first matched to existing invoices and payments, which limits duplicate entries.

This article is for information only. For a difference you cannot explain, call your accountant before closing the period.

Essayez avec votre vraie comptabilité

Créez votre compte, importez votre balance et voyez vos états financiers se construire.

30 jours d'essai gratuit · Annulation en tout temps