Tuesday, February 2, 2010

, , ,

Cash Book Reconstruction for Incomplete Records

Last reviewed: July 2026.

Cash Book Reconstruction for Incomplete Records is a practical guide designed to connect current accounting requirements with clear preparation steps, calculations and review controls.

Purpose of a reconstructed cash book

A reconstructed cash book converts incomplete bank and cash evidence into a chronological accounting record. It helps identify cash sales, customer receipts, supplier payments, expenses, drawings, capital introduced and financing transactions. The objective is not merely to copy a bank statement; it is to explain every cash movement and separate business transactions from transfers, timing differences and owner activity.

Collect the source evidence

Gather bank statements for the full period, paying-in slips, cheque records, card-settlement reports, cash-register summaries, supplier statements, loan schedules and receipts. Confirm opening and closing bank balances and identify missing statement pages. For physical cash, obtain till reports, petty-cash vouchers and cash counts. Record the reliability and coverage of every source.

Create the bank-column reconstruction

Enter opening balance, then record receipts and payments in date order. Describe the counterparty and probable accounting category. Bank fees, direct debits and interest may appear only on the statement and should be added to the cash book. Transfers between the entity’s own bank accounts are recorded as contra movements, not income or expense.

Separate trading and non-trading receipts

Customer receipts and cash sales are trading inflows. Loan proceeds, sale of assets, tax refunds and capital introduced are non-trading inflows and require separate accounting. A deposit that includes several sources should be split using sales records, remittance advice and owner explanations. Treating every deposit as sales will overstate revenue and distort gross profit.

Separate business payments and drawings

Supplier payments, wages, rent and operating expenses belong to the business. Personal payments made from the business account are drawings or amounts due from the owner, not business expenses. Loan repayments must be divided between principal and interest. Payments for equipment are capital expenditure rather than purchases for resale.

Reconstruct cash takings

When cash takings are partly banked and partly used for expenses or drawings, use a cash account. Opening cash plus cash sales and other receipts must equal bankings, cash expenses, drawings and closing cash. This equation can reveal unrecorded cash sales. Evidence such as till rolls and pricing records should support the result.

Link to receivables and payables

Customer receipts in the cash book feed the receivables control account, which can be used to derive credit sales. Supplier payments feed the payables control account, which can derive credit purchases. Maintaining the connection between cash records and control accounts prevents the same missing figure from being independently estimated in inconsistent ways.

Prepare the bank reconciliation

After updating the cash book, reconcile it to the bank statement. Add deposits recorded in the cash book but not yet credited by the bank and deduct unpresented payments. Investigate old reconciling items, unidentified deposits and duplicated entries. The adjusted cash-book balance, not the raw statement balance, should enter the ledger.

Worked reconstruction example

Suppose statement deposits total 180,000. They include a loan of 25,000 and owner capital of 10,000. Cash expenses of 8,000 and drawings of 7,000 were paid before the remaining takings were banked. Cash sales are therefore 160,000: bank deposits 180,000 less loan 25,000 less capital 10,000 plus cash expenses 8,000 plus drawings 7,000.

Control and documentation checklist

  • Number every reconstructed entry and link it to source evidence.
  • Keep unidentified items in a temporary suspense list, not forced into revenue.
  • Confirm owner transactions separately from business income and expense.
  • Reconcile every bank account and physical-cash balance.
  • Record assumptions, reviewer approval and unresolved exceptions.

Handling unidentified bank items

Unidentified receipts and payments should be listed in an exceptions schedule with date, amount, bank reference and investigation status. Do not automatically classify receipts as sales or payments as expenses. Contact banks, customers, suppliers and the owner where necessary. Items unresolved at reporting date may require a suspense balance, but the suspense account should have a clear owner and deadline.

Cut-off and timing issues

Transactions near year-end need special attention. A receipt shown on the bank statement after year-end may belong to the current period if recorded and deposited before year-end. An unpresented cheque may already be recorded in the cash book. The reconstruction must distinguish missing entries from normal reconciling items so revenue and expenses are recognised in the correct period.

Fraud indicators

Warning signs include missing statement pages, frequent cash withdrawals, deposits that do not match till reports, supplier payments to unfamiliar accounts and repeated round-sum transfers. Reconstruction work should preserve evidence and maintain an audit trail. Suspected fraud requires escalation under the entity’s governance, legal and professional obligations.

Completing the ledger

Once the cash book is reconstructed and reconciled, post the entries to receivables, payables, expense, asset, loan, capital and drawings accounts. Reconcile those ledgers to independent balances and prepare a list of remaining uncertainties. The reconstructed cash book becomes the foundation for the trial balance, not an isolated spreadsheet.

Related Accounting Support guides

Connect this guide with the incomplete-records reconstruction steps, the mark-up and missing-figures guide and the bank reconciliation guide.

Authoritative references

Use ACCA’s Incomplete records article and the official Business records if you are self-employed guidance on business records.

Advertisement