lamp.
ResourcesPricingAbout
5 min readBy

How to handle unreconciled banks and late postings

This guide helps a small business close its books each month with confidence. It explains how to clear unreconciled bank balances, catch bills that were never posted and handle changes that arrive after the month has been closed. The example is a trading firm in Surat with three bank accounts, a bookkeeper and an outside accountant.

Why this matters

If the bank balance in the books does not match the statement, you cannot trust the cash figure, the supplier dues or the profit. Late bills make things worse: an expense booked in the wrong month changes that month's result and may be noticed only when the owner asks why margins look so good.

A fixed month-end routine means you find these gaps in days, not at year end. It also gives your accountant clean books to work from, which lowers the time and fee spent fixing old entries.

Before you start

  • Bank statements for every account, downloaded for the full month, and the cash book or ledger covering the same dates.
  • A list of bills and expenses received but not yet entered, including courier receipts, rent and utility bills.
  • The previous month's closing balances and the list of items left unreconciled then.
  • A month-end calendar showing when bank reconciliation, accrual entries and the review are due.
  • Names of who may post journal entries and who approves them.

Step by step

  1. Reconcile each bank account. The bookkeeper matches every line on the bank statement with an entry in the books, ticking each pair. Items in the books but not on the statement, such as cheques not yet cleared, and items on the statement but not in the books, such as bank charges, are listed separately with dates.
  2. Clear or explain every difference. For each unmatched bank line, the bookkeeper finds the source: a missing receipt, a payment recorded in the wrong account, a duplicate entry. Items that cannot be explained within the week go on a written exception list with an owner.
  3. Find unposted bills. The accountant compares supplier statements, the pile of received bills and open purchase orders with the ledger. Any bill dated in the month but not yet recorded is entered or listed for an accrual.
  4. Approve accruals and closing stock. The accountant prepares journal entries for expenses incurred but not billed, such as electricity or freight, and for the value of closing stock from the stock count. The owner approves these entries with a note on how each figure was reached, and the approval is saved.
  5. Review the trial balance and reports. The bookkeeper produces the trial balance and the profit and loss, then checks for odd balances: a negative cash figure, a supplier with a debit balance, expenses far above the usual. Each query is answered in writing.
  6. Soft close the month. The accountant records the month as closed for routine entry, notes the date and who approved it and shares the reports with the owner. Entries after this point are not blocked, but each needs a reason.
  7. Record later changes. If a bill arrives after close, the accountant posts it with the reason, the original month it belongs to and the effect on that month's result. The owner sees a short list of all late adjustments at the next review.

Check the current rule on the official portal or with your CA before acting.

Who does what

RoleWhat they doRecord they own
BookkeeperReconciles banks, produces the trial balance, answers queriesBank statement reconciliation, trial balance
AccountantFinds unposted bills, prepares accruals, soft closes the monthLedger, month-close status
OwnerApproves accruals, closing stock and late changesJournal approval

Common mistakes

  • Reconciling only the main current account and ignoring a small account or a card settlement account.
  • Carrying forward the same unexplained difference for months and calling it "small".
  • Entering a bill on the day it is paid instead of the month it was incurred.
  • Posting closing stock from an estimate rather than a count, then finding a gap at year end.
  • Changing a closed month quietly, with no record of what changed and why.

How to tell it is working

  • Unreconciled balances. At month end, take the difference between the bank statement balance and the book balance for each account after listing known timing items. Whatever remains unexplained is the figure to bring down to zero.
  • Missing bills. Count the bills found after the month closed that belonged to that month, and compare with the number of bills posted. A falling share means your collection of paperwork is improving.
  • Late adjustments. Count and total the journal entries posted after the soft close, in rupees. Large or frequent entries show the close was done too early or the inputs were incomplete.

Questions people ask

Who owns record to report?

The accountant owns the close, and the bookkeeper owns the daily and monthly entries beneath it. The owner owns the approvals, so that no accrual or stock figure goes in without a second pair of eyes.

What is the minimum record for record to report?

Keep the bank statements and reconciliations, the ledger, the journal approvals, the trial balance and a note showing when the month was closed and what was changed afterwards.

When should a case stop?

A reconciliation item stops when it is matched or written off with approval. A month stops when the review is complete and the close status is recorded; later items are logged as adjustments, not hidden.

Can a spreadsheet support this stream?

Yes, a reconciliation sheet per bank account works if you keep the same layout every month and save a dated copy. Lock closed months so nothing changes without a note.

What should the owner review?

Look at the exception list, accruals and stock values you approved, the trial balance for odd balances and the list of entries made after close.

Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →