Bank Reconciliation for Small Businesses: A Practical Guide with a Worked Example

Your bookkeeping app shows money in the bank. Your bank statement shows a different number. Before changing either record, stop and ask what each balance represents. One may include a customer payment that has not cleared. Another may include a fee you have not entered. A difference is a question to investigate, not an invitation to insert a balancing expense.

Bank reconciliation is the process of connecting those two records at a defined date. It helps you distinguish transactions that are missing, transactions recorded incorrectly, and transactions that are simply moving through the banking system. A useful reconciliation leaves another person able to understand every remaining difference without repeating the entire investigation.

This guide develops an original example for a fictional retail business called Cedar Shop. All amounts are fictional currency units. The procedures are a practical working method, not a substitute for the accounting policies or reporting requirements that apply to your business. You can use a spreadsheet alongside your existing business management software; automatic bank feeds are not a prerequisite.

What bank reconciliation actually checks

The Australian government's financial terminology guide describes bank reconciliation as a comparison between cash records and bank statements. That basic idea is simple, but the quality of the evidence matters more than a green check mark beside the final balance.

Choose one bank account, one currency and one closing date. Compare the transactions and closing balance in your books with the actual statement for that account. List legitimate timing differences, correct supported bookkeeping mistakes and investigate unexplained items. The resulting adjusted balances should agree, while the underlying transaction trail remains understandable.

A reconciliation does not prove that every business transaction has been classified correctly. A payment could be present in both records but posted to the wrong expense category. A fraudulent payment could also appear in both. Matching establishes agreement between records; reviewing authorization, business purpose and classification provides additional controls.

That distinction is especially important when several people use the same business manager app. The person entering a transaction may know its purpose, while the person reviewing the bank statement sees only an abbreviated description. A reference to an invoice, bill, receipt or approval makes that knowledge available to the reviewer.

Gather the evidence before comparing numbers

Create a reconciliation folder for the account and month. Keep the original bank statement, the relevant bookkeeping transaction list, the previous completed reconciliation and any documents supporting unusual items. Save an unedited statement as your source. If you work with an exported CSV, keep it alongside the source rather than treating it as the only evidence.

Check that the statement covers the whole period. An online banking screen filtered to recent transactions may omit the first few days or show pending transactions separately. Confirm the closing date, account identity and currency before trying to match anything. A correct reconciliation of the wrong account is still unusable.

Next, compare the opening balances with the previous period's closing records. If the opening book balance changed after last month's review, identify the edited or backdated transaction. Otherwise, you may spend hours investigating this month's payments when the real problem is an older change. Keep the explanation with the current work and, when necessary, reopen the earlier review transparently.

Prepare a short control sheet with the following fields:

• Account name and a masked account identifier.
• Statement start date, end date and closing balance.
• Bookkeeping report date and closing balance.
• Prior outstanding items carried forward.
• New differences, evidence references and proposed corrections.
• Preparer, reviewer, review date and unresolved follow-up dates.

This sheet is not a second accounting ledger. It is an explanation of how the actual ledger relates to the statement. Avoid building a permanent shadow system in which corrected spreadsheet numbers never reach the books.

Match transactions without creating duplicates

Start with clear matches: the same amount, compatible dates and a recognizable reference. Mark both sides of the match so a single bank receipt cannot accidentally explain two customer payments. Matching by amount alone is weak evidence when many transactions have common values, such as repeated payments of 100.

Where references are unclear, use additional evidence. A customer remittance advice may identify several invoices paid together. A payment processor's settlement report may explain why a group of card sales appears as one bank deposit. A supplier statement can help identify which bills a payment covers, but the actual payment evidence should still support the bank entry.

Do not add a new receipt merely because a bank line appears unmatched at first glance. Search the books for the amount, reference, customer and surrounding dates. If a receipt already exists against the invoice, connect the records rather than entering income again. Duplicate recognition is a common way for apparently tidy books to overstate sales.

Use simple statuses such as matched, timing difference, correction required and investigation open. A blank cell is ambiguous: it could mean not checked or checked but unresolved. Clear statuses make it easier to stop and resume the review without losing your place.

For a busy account, work in manageable date ranges, but complete the full period before approving the result. A weekly review can make the month-end process shorter because the investigator still remembers recent events. It does not remove the need to reconcile the actual month-end balance.

Understand the two sides of a reconciliation

Some differences explain why the bank balance has not yet caught up with valid entries already in the books. Others reveal transactions that belong in the books but have not been entered, or have been entered incorrectly. Keeping these categories separate prevents double counting.

AccountingCoach's bank reconciliation explanation distinguishes deposits in transit and outstanding checks from items requiring book adjustments. A deposit in transit is already recorded by the business but not yet reflected in the bank's closing balance. An outstanding check is likewise already recorded in the books but has not cleared the bank. The exact treatment of other payment methods depends on the evidence and accounting policy.

In the original example below, timing items adjust the bank side of the reconciliation schedule. Missing fees, interest and an identified entry error adjust the book side. The schedule is not permission to change the bank's actual statement. Nor should an already recorded outstanding payment be entered in the books a second time.

If you believe the bank made an error, preserve the statement and contact the bank through a verified channel. Record the issue and its follow-up status. Do not quietly transform an unexplained bank debit into an expense merely to finish the reconciliation.

Worked example: reconcile Cedar Shop's account

Cedar Shop is reviewing its month-end account. The bank statement closes at 12,480. The bookkeeping balance is 12,130. The owner initially sees a difference of 350, but that single difference does not reveal the underlying causes. Several independent items are involved.

The review identifies a customer deposit of 900 recorded in the books before the closing date but credited by the bank afterward. It also identifies a payment of 1,200 already recorded in the books that has not cleared. The schedule therefore calculates an adjusted bank balance of 12,180.

The bank statement also shows a fee of 30 and interest received of 20 that are missing from the books. Finally, a supplier payment that actually cost 540 was entered as 600. Correcting that 60 overstatement increases the book balance. These adjustments explain the book side independently.

Both adjusted balances now equal 12,180. Notice that the original 350 difference was not solved by posting one expense of 350. It was explained by five documented items with different meanings. A single balancing entry would have concealed the real errors and timing differences.

Cedar Shop retains the subsequent bank evidence for the 900 deposit, the payment reference for the outstanding 1,200, the statement lines for the fee and interest, and the supplier payment evidence supporting the 60 correction. Its reviewer can follow each number back to a source.

Record corrections with a clear audit trail

Review each proposed book correction before posting it. The supporting document should establish what happened, which account was involved, the correct amount and the relevant date. If the accounting period is locked or already reported, use your established correction process rather than bypassing the lock.

In Cedar Shop's example, the fee and interest need appropriate ledger treatment. The payment error needs a correction that also preserves the relationship with the supplier bill. The correct method depends on the software and accounting setup. An accountant can help choose the entries when the effect extends beyond cash.

Avoid deleting and recreating records merely to make the screen look cleaner. That can break references, alter historical reports or obscure who changed what. Where the software allows edits, retain an explanation of the original mistake and the reason for the correction. Where it uses reversals, follow that workflow consistently.

After posting, rerun the bookkeeping report for the same closing date. Confirm that the revised balance agrees with the reconciliation schedule. This second check catches a correction accidentally entered into the wrong account, currency or month. Save the final report with the completed work so the reviewed state is clear.

Handle card settlements and grouped receipts

Card processing creates a frequent source of confusion because the bank deposit may be lower than the total customer sales. A settlement can combine multiple transactions, subtract fees, include refunds and exclude amounts still waiting to settle. The bank line alone usually cannot explain all of that activity.

Consider an original illustrative settlement: gross customer receipts of 2,000, refunds of 100 and processor fees of 40 produce a bank deposit of 1,860. The arithmetic is 2,000 minus 100 minus 40. That does not mean the business made only 1,860 of sales, and it does not mean the 140 difference is entirely a processing fee.

Use the processor's actual settlement report to separate the components. Check whether sales and refunds were already recorded. Depending on your accounting setup, a clearing account may help connect customer activity with later bank settlements. Do not introduce that account casually without understanding how it should clear and how outstanding balances will be reviewed.

Record settlement identifiers and date ranges. If one deposit covers two trading days, write that down. If a reserve is withheld, keep it distinct from a fee and establish how it will be tracked. The purpose is to make the next review repeatable, not to memorize an unusual transaction once.

Transfers, cash deposits and owner transactions

A transfer between two business bank accounts is not automatically revenue in the receiving account or an expense in the sending account. Trace both sides and check that the amounts, currencies and timing make sense. Fees and foreign exchange may require separate treatment, but the transfer itself should not inflate trading performance.

Cash deposits need a connection to the underlying cash records. If the shop has already recorded cash sales, depositing that cash into the bank does not create another sale. Compare the deposit evidence with the cash count and cashbook transfer. Investigate shortfalls through the cash handling process rather than hiding them inside bank reconciliation.

Owner contributions and withdrawals also require appropriate classification. A personal payment into the business bank account may be financing rather than sales income. A withdrawal may be an owner transaction rather than a deductible business expense. The appropriate account depends on the business structure and local rules, so seek accounting guidance when the classification is uncertain.

Write descriptions that make the event understandable later. A label such as adjustment tells the reviewer almost nothing. A reference such as owner contribution, supporting transfer dated the fifteenth is much more useful, provided it accurately describes the evidence and uses your approved accounting treatment.

Investigate old and unexplained differences

Outstanding items should not remain on a schedule forever without review. At each reconciliation, check whether last period's items cleared. Remove resolved items from the outstanding list while preserving the earlier schedule. For items that remain, update the explanation and assign a follow-up date.

An old payment may have been canceled, duplicated, lost or entered against the wrong account. An old deposit may point to a failed transfer or a receipt that was recorded before it was actually received. Those possibilities require different responses. Do not assume age alone tells you which correction to make.

Keep an exception log with an owner and next action. For example, a missing payment reference might be assigned to the staff member who approved the purchase, while a disputed bank charge requires contact with the bank. State what evidence would resolve the question, so the task is more useful than simply investigate difference.

If an amount appears suspicious, handle it through the business's incident and authorization procedures. Reconciliation should reveal uncertainty, not erase it. For formal reporting, discuss material unresolved items with the responsible accountant and document the decision about how they affect the accounts.

Build a review routine that fits a small team

Choose a schedule based on transaction volume and risk. A quiet account might be reviewed monthly, while a busy operating account benefits from more frequent matching and a formal month-end review. These are operating choices, not universal compliance deadlines. Set a schedule the business can actually maintain.

Where practical, have someone other than the preparer review the reconciliation. The reviewer should inspect the original statement, the adjusted balances, unusual corrections and older outstanding items. Simply signing a spreadsheet without looking at its evidence adds little value.

A sole owner can still improve control by separating preparation and review in time, using a consistent checklist and arranging periodic accountant review. The objective is to challenge assumptions. Ask why each difference exists, whether it cleared afterward and whether any correction changes a customer or supplier balance.

Connect the completed reconciliation with the wider month-end close checklist. Bank agreement is one part of closing the books. Customer balances, supplier bills, inventory and other accounts need their own checks before the financial reports are reliable enough for decisions.

Use Yesri records as part of the evidence

Yesri's banking guide explains how to create bank or wallet records, set an opening balance and review transaction history. Those records reflect bookkeeping activity entered in the app. Creating a banking entry does not connect to your bank or move actual money.

For reconciliation, review the account's date, description, amount and running balance against the real statement. Trace differences to the related invoice payment, supplier bill, expense or withdrawal. Keep the reconciliation schedule and supporting evidence separately where the app does not provide the workflow you need.

This guide does not claim that Yesri automatically imports bank feeds or performs automatic reconciliation. It describes a manual review method that uses the available records. Before changing historical transactions, preserve the relevant reports and follow the backup guidance appropriate to your installation.

Clean entries make the review easier: use recognizable account names, accurate dates and descriptions that connect payments to their purpose. Better software organization helps, but it cannot replace the source statement or the judgment needed to explain an unusual transfer.

Questions owners ask during their first reconciliation

Should I reconcile to the available bank balance?

Use the statement balance for the defined closing date and understand what it includes. Available balances can reflect pending items, holds or credit facilities differently. Comparing two balances with different definitions creates confusion before the review even starts. Ask the bank to clarify the statement if its presentation is unclear.

What if I can make the totals match by changing an opening balance?

Do not change an opening balance without evidence that it was wrong. It represents the starting position, not a flexible correction bucket. Identify the original source, compare it with the prior reconciliation and document any justified correction. Otherwise, the apparent solution can move an unexplained error into every later period.

Does a small difference matter?

A small difference can reveal a repeatable problem, such as fees omitted every week or a decimal entry mistake. Use proportionate investigation and an approved policy for immaterial items, but do not invent evidence. Repeated unexplained differences deserve attention even when any one of them seems minor.

Can I finish if a timing item has not cleared yet?

A supported timing item can remain on a reconciliation, with an owner and follow-up plan. The issue is whether the difference is valid and documented, not whether the two unadjusted screens display the same amount. Subsequent clearance provides useful evidence, while overdue items require renewed investigation.

Your next reconciliation session

Keep a short handover note if someone else may complete the work. State the last transaction checked, the documents still missing and the corrections already posted. This avoids a second person repeating entries or interpreting an unfinished worksheet as an approved reconciliation. The note should make the current status clear without requiring access to the preparer's private messages.

Start with one account and a short, complete period. Collect the source statement, confirm the opening balance and match clear transactions first. Separate timing differences from missing or incorrect entries. Use the Cedar Shop example as a model for the explanation, replacing every fictional number with your own supported records.

Before signing off, verify that corrections reached the books, that the adjusted balances agree and that unresolved items have specific follow-up actions. Save the final evidence together. At the next review, begin with those outstanding items so that the process builds on previous work instead of starting from memory again.

Use the resulting cash figure alongside your cash-flow forecast. Reconciliation explains the recorded position at a date; forecasting explores what could happen afterward. Together they provide a clearer foundation for deciding when to pay suppliers, collect invoices and commit to new purchases.