Bank Reconciliation for a Small Garment Business: Trace Every Difference

A small balance difference can hide large errors

At month-end, a small garment business sees CU 148,260 on its bank statement and CU 147,910 in its cashbook. The difference is only CU 350. It would be tempting to enter a small adjustment and move on.

That would miss the real problem. In the fictional case below, a deposit is still clearing and two cheques remain unpaid. The gap also contains a bank error and missing or incorrect book entries. Once each item is explained, both sides support CU 151,810. No CU 350 balancing entry is needed.

Bank reconciliation is the process of explaining those differences for one account at one date. OpenStax's bank-reconciliation guide makes a useful distinction. Some items are already in the books; others still need an entry. That distinction prevents timing differences from being posted twice.

All amounts here are invented currency units, or CU. The main example uses one positive-balance bank account and excludes tax complications. It is a worked control procedure, not a real company's bank record.

Start with the same account, date and evidence

Use the statement for the exact business account being reconciled. Check its account identity, currency, opening date and closing date against the ledger. A payroll account and an operating account can have similar names. Check which is which, since arithmetic cannot fix a match between the wrong accounts.

Save the original statement and a dated ledger export. A live banking screen may have moved on since month-end, while a spreadsheet may include entries added later. Both records need a clear cutoff before any comparison starts.

The case closes on 30 September. Its opening bank and book balances are both CU 102,000, with no unresolved items brought forward. That is a simplifying assumption. In a real business, last month's approved reconciliation is part of the evidence, including every item still waiting to clear.

If the opening book balance differs from the previous approved close, investigate the change first. It may reflect a backdated entry, deleted payment or altered opening balance. Adding this month's differences to an unexplained starting point will not repair the history.

Prove the cashbook total before matching the bank

The business initially recorded September receipts of CU 220,400 and payments of CU 174,490. Its unadjusted balance is:

CU 102,000 + CU 220,400 − CU 174,490 = CU 147,910.

The statement separately reports credits of CU 208,890 and debits of CU 162,630. Its closing balance is:

CU 102,000 + CU 208,890 − CU 162,630 = CU 148,260.

Here, a statement credit increases the account balance and a statement debit reduces it. In the business's own bank-asset ledger, an increase is a debit and a decrease is a credit. Work from the cash effect rather than assuming both records use the words in the same way.

The IRS recordkeeping guidance in Publication 583 recommends checking the business's own totals first. Then correct missing or wrong entries. This is US guidance, so its tax rules do not apply to every apparel business elsewhere. The arithmetic and evidence checks are useful regardless of the bookkeeping tool.

In a spreadsheet, verify that the closing formula covers every row, including transactions imported at the bottom. Check whether amounts stored as text are excluded from totals. Preserve debit and credit signs during import. A visually complete list can still produce the wrong balance if its formulas omit part of the data.

Match transactions using more than the amount

Compare each statement line with the cashbook and its source record. Look for the payment reference or cheque number. Compare the customer or supplier, amount and posting date too. Dates may differ because the bank and business recorded the event at different stages.

Two trim suppliers may both receive CU 5,000. The amount alone does not show which payment cleared. A good match links the bank reference to the authorised payment and then to the supplier account. The same care applies to buyers who send several receipts of equal value.

Mark a matched pair once. Preserve the unmatched items from both sides for investigation. Do not remove an unmatched line merely because it appears old, small or inconvenient.

For imported data, check for gaps and overlaps between files. Reimporting the same date range may duplicate transactions; starting a new file one day late may omit them. Compare the imported totals with the source statement before relying on the match results.

In this case, the unmatched items fall into two groups. The cashbook already contains the deposit and outstanding cheques. Other items appear on the statement but need corrections in the books. A confirmed bank error forms a separate bank-side item.

Explain the items that adjust the bank side

On 30 September, the business lodged CU 18,400 and recorded it in the cashbook. The bank recorded it on 1 October. The deposit record and subsequent credit support its status as a deposit in transit at the September cutoff.

Cheques for CU 9,750 and CU 6,300 were properly issued and recorded before month-end. They had not cleared by 30 September. For this case, both the debts and payments were booked correctly under the business's accounting policy. These are outstanding cheques, not missing expenses.

The statement also contains an incorrect CU 1,200 debit belonging to another bank customer. The bank has acknowledged the error and will reverse it. The garment business did not record that debit as its own payment. This explicit evidence matters: an unfamiliar debit is not automatically a bank error.

The two outstanding cheques total CU 16,050. Net bank-side adjustments are CU 3,550: CU 18,400 − CU 16,050 + CU 1,200.

These adjustments explain the statement balance; they do not alter the bank's original statement. The deposit and cheques are already in the cashbook. Posting them again would duplicate the transactions. The acknowledged bank error remains tracked until the bank corrects it.

Correct the cashbook for real omissions and errors

The statement reveals a routine bank fee of CU 180 and interest of CU 90 that were not recorded. It also shows a CU 6,800 buyer transfer settling an invoice already in trade receivables. That receipt reduces the buyer's debt; it is not a second sale.

A CU 2,400 customer cheque had previously been credited by the bank and entered in the books. It was then returned unpaid before month-end. The bank reversal appears on the statement, but the business had not restored the customer's receivable or reduced its bank ledger.

A supplier payment of CU 6,840 was correctly processed by the bank. The business entered it as CU 6,480 on both sides of its payment journal. The supplier invoice was originally booked correctly at CU 6,840. The correction reduces the remaining payable by CU 360. It reduces the bank ledger by the same amount.

Finally, an automatic CU 50 communications payment was omitted. It relates entirely to September service, and no invoice or accrual was previously entered. It therefore needs an expense entry in this example. A payment for future service or an already recorded payable would need a different counterpart.

The cashbook increases by CU 3,900 overall. That does not mean every correction increases cash: additions total CU 6,890 and reductions total CU 2,990.

The CU 350 starting gap is now explained. The statement needed a net CU 3,550 adjustment, while the cashbook needed CU 3,900. Their difference is CU 350. Looking only at that net gap would have concealed much larger items.

Post balanced corrections and preserve their support

The following entries use the facts established above. “Bank” means the business's ledger account for this specific bank account. Actual account names should follow the chart of accounts.

Total debits and total credits are each CU 9,880. The bank-account debits are CU 6,890, and its credits are CU 2,990. The resulting net increase of CU 3,900 agrees with the reconciliation.

After posting, rerun the bank ledger. Its corrected receipt-side total is CU 227,290 and its payment-side total is CU 177,480. The roll-forward becomes CU 102,000 + CU 227,290 − CU 177,480 = CU 151,810.

Do not stop at changing a worksheet. Give each correction a journal reference and attach its supporting record. Explain the entry and obtain the required approval. Without posting, next month's ledger may still contain the old balance despite a complete worksheet.

The returned cheque does not automatically mean a bad-debt write-off. It restores the unpaid customer amount in this case. Collection action and any assessment of recoverability are separate tasks. Likewise, the supplier correction settles the remaining payable; it does not charge the same purchase to expense twice.

Follow timing items into the next statement

The September file remains open for follow-up on the bank-side items even after the arithmetic agrees. In this example, the deposit clears on 1 October, the cheques on 3 and 5 October, and the bank's CU 1,200 correction on 4 October.

Record those clearing dates and references beside the original reconciling items. They are evidence that the September explanation was correct. They are not new September receipts or payments to enter again.

Ignoring all other October activity, those movements take the bank from CU 148,260 to CU 151,810: add CU 18,400, deduct CU 16,050 and add CU 1,200. The ledger already reflected the deposit and cheques, so clearing them creates no second cashbook entry.

If an item fails to clear as expected, investigate its status. A cheque may be lost, stopped or no longer valid. A deposit may have been rejected or recorded in the wrong account. Do not keep rolling the same description forward without new evidence.

Use an authorised process to cancel or replace a payment, and check the debt it covers. Removing an old cheque from the list does not erase what the supplier is owed. Nor does that action alone create income.

Give each open item a test for closure

The evidence required depends on the explanation. For the CU 18,400 deposit, a buyer's remittance advice alone would not prove that the business lodged the funds with the bank. The case uses the actual deposit record and the later bank credit. Both should point to the same amount and transaction.

For an outstanding cheque, distinguish a payment genuinely issued from one merely printed and held in the office. The accounting treatment must follow the facts and the applicable policy. An old cheque number in a spreadsheet is not enough to establish a valid payment or its clearing status.

The CU 6,800 buyer transfer needs a different check. The bank credit proves receipt into this account. Use the buyer reference and remittance detail to find which invoice it settles. The bank can balance even when staff allocate the money to the wrong customer and chase the wrong debt.

The CU 1,200 error needs the bank's acknowledgement and later correction reference. Until the correction appears, retain the open item and follow-up responsibility. A promise of action is not the correction itself. Keep the link between the September explanation and the October result until that action is complete.

Use these closure tests in the working list. A status such as “checked” is less useful than a specific record showing that the expected event occurred.

Investigate unknown amounts without forcing a match

A statement debit with no recognised business purpose needs prompt investigation. Check the bank reference, payment authorisation and source documents. If necessary, raise the issue through the bank's approved channel and retain its response.

The CU 1,200 bank-error treatment above depends on confirmation. If responsibility is uncertain, the reviewer must assess the actual cash movement and any claim. The applicable accounting policy determines how to record them. The item should not simply be labelled “timing” to keep the books unchanged.

ACCA's guidance on suspense accounts and error correction explains why suspense is temporary. To correct an error, first establish what was posted. A controlled suspense entry may help record a known transaction while staff investigate its proper account. It does not make an unexplained balance a resolved item.

An investigation record should identify the amount, date, owner, missing evidence and next action. If a deadline passes, the item needs review. A list labelled “to investigate” can become permanent unless someone is responsible for closing it.

Small differences deserve the same logic. An approved rounding policy may handle genuine rounding, but it cannot explain a missing payment. Look for the cause before using an expense account to absorb the residual.

Handle grouped receipts and fees as a linked set

One bank line may represent several customer receipts. A payment file may also produce several bank entries. Match the group while keeping each customer or supplier record visible. A single bank line does not remove the need for those details.

Consider a separate example. Three customer receipts of CU 3,300, CU 2,400 and CU 1,800 form a CU 7,500 settlement. The processor retains a documented CU 100 fee and deposits CU 7,400 into the bank.

Suppose none of that settlement has yet been recorded. Debit Bank CU 7,400 and the relevant fee expense CU 100. Credit the identified customer receivables for CU 7,500. If the receipts were already posted to a clearing account, clear that account instead. The bank deposit must not create a second sale or a second receipt.

Keep the settlement report with the match. A CU 100 difference should not be assumed to be a fee merely because the totals nearly agree. The report must show the deduction and the receipts included.

Intuit's reconciliation documentation allows several book transactions to match one statement line. It also advises checking statement dates and balances. Investigate differences before using an adjustment. Those control points apply even when another system or a spreadsheet is used.

Use signs consistently when the account is overdrawn

The main case has a positive balance. A separate overdraft example shows why memorising “add” or “deduct” without a sign convention is risky.

Treat an overdraft as negative for the worksheet. A statement balance of −CU 12,000, a CU 3,000 deposit in transit and CU 4,500 of outstanding cheques give:

−CU 12,000 + CU 3,000 − CU 4,500 = −CU 13,500.

If the book balance is −CU 13,320 and an omitted CU 180 bank fee is due, the corrected book balance is also −CU 13,500. The fee makes the overdraft larger. It does not reduce the amount owed merely because the worksheet uses the word “deduct”.

Use a separate reconciliation for each account. A surplus in one account should not silently offset a gap in another. For a transfer between business accounts, trace both bank legs and the corresponding ledger entries. The receipt is a transfer of funds, not sales income.

A zero difference does not prove every entry is sound

Two errors can cancel in the net balance. For example, a duplicated CU 600 customer receipt and a duplicated CU 600 supplier payment have opposite effects on the bank ledger. Together they leave the closing cash total unchanged, but both entries remain wrong.

Matching each transaction should expose these errors. The bank contains only one genuine receipt and one genuine payment. A check limited to opening and closing balances would miss them.

Classification errors can also survive a bank match. A machinery payment recorded as rent may still match the bank perfectly. Reconciliation proves the cash link; invoice coding and asset recognition need their own review.

The same distinction matters in garment costing. A supplier payment may settle an invoice recorded in an earlier period. It should not be treated as this month's fabric consumption merely because cash left the bank. ApparelDiary's garment-costing breakdown explains the related costs. This reconciliation focuses on the bank account.

Make review independent enough to challenge the result

The reviewer needs the statement and ledger evidence to check the work. Recalculate the totals and inspect unresolved items. Signing the preparer's cover page without checking the support adds little protection.

ICAEW's financial-controls helpsheet for insolvency practices calls for independent review of the reconciliation. It also stresses prompt investigation and checks on both sides of transfers. Its insolvency rules are specific to that setting. A garment business can still adapt these review principles to its own control process.

A small team may need its owner or another authorised manager to review the work. That person should check the statement, supporting journals and outstanding list separately from the preparer. The arrangement should allow the reviewer to question payments and obtain evidence directly. It should not depend entirely on a summary supplied by the person whose work is being checked.

The account's activity and risk should guide how often it is reviewed. Keep month-end balances properly reconciled too. A busy payment account may need more frequent matching. Repeating small checks during the month can make the close easier, but it does not replace a complete cutoff reconciliation.

Track completion and ageing, with a named owner for unresolved items. ApparelDiary's factory KPI dashboard guide can help assign measures and follow-up. Mark the work “completed” when the agreed checks and approvals are present. A spreadsheet on its own is not enough.

Keep reconciled cash separate from money available to spend

The adjusted CU 151,810 is a supported accounting balance at 30 September. It is not a guarantee that the same amount can be withdrawn immediately or remains available today.

Chase's explanation of account balances sets out the difference between its present balance and funds that can be used at once. It also notes that unpresented cheques may not appear in the present balance. Other banks use their own definitions, so read the terms for the actual account.

Payment planning needs more detail. Check holds, later transactions, amounts still owed and the dates when deposits become usable. Do not spend the statement balance while ignoring cheques already issued. Equally, do not deduct those cheques again from an adjusted book balance that already includes them.

The finished file should show a clear trail. Retain the original statement and the ledger before and after correction. Include the matched transactions, approved journals and remaining timing items. Each difference has a reason, evidence and an owner. That is what turns the bank balance into a reliable starting point for the next financial decision.

References

• OpenStax: Purpose of a Bank Reconciliation and Associated Journal Entries.

• IRS: Publication 583, Starting a Business and Keeping Records.

• ACCA: Suspense accounts and error correction.

• Intuit: Reconcile an account in QuickBooks Online.

• ICAEW: Financial Controls for Insolvency Cases.

• Chase: Present and Available Account Balances.