# How to Investigate Transactions in Your Books but Missing from the Bank

When a transaction is in your books but missing from the bank, trace it to its source and execution evidence. It may be a genuine outstanding cheque or deposit, but it can also be an unexecuted transfer, duplicate entry, wrong account or incorrect date. Classify the cause before deciding whether to retain a timing item or correct the ledger.

A payment voucher proves what the business recorded. It does not by itself prove that the bank processed a payment. Likewise, a receipt entry does not establish that funds reached the intended bank account. Reconciliation needs both the accounting record and the external transaction trail.

## Check the record boundary first

Consider an illustrative Rajkot tooling supplier reviewing month-end book-only entries. Accounts confirms that the statement covers the full account and period, including any separate pages or exported rows. It then searches adjacent dates and other company bank accounts.

A transaction may appear on the next statement, but a missing current-period entry should not automatically be classified as timing. Obtain the reference or instrument evidence showing why the movement is expected there. A vague note that it “usually clears later” is insufficient for an old or unusual item.

ICAI's reconciliation material separates timing differences from errors and omissions. The practical task is to determine which category fits each unmatched book entry, rather than treating the entire book-only list as one problem.

## Verify whether the payment was executed

For a bank transfer, inspect the authorised instruction, transaction status and bank reference. A prepared payment file or an approval email can precede actual execution. A rejected or cancelled instruction needs different accounting attention from a successful debit that appears under an unfamiliar narration.

For cheques, check whether the instrument was released, presented, stopped, returned or replaced. For deposits, inspect acceptance evidence and later credit. Keep distinct statuses instead of using “pending” for every stage.

Search by reference and counterparty as well as amount. A combined settlement or a bank charge deducted separately can mean the expected one-to-one amount is not present even though the underlying payment occurred.

## Work through an illustrative exception list

The tooling supplier's unadjusted bank ledger is ₹1,50,000. It identifies these items:

| Book-only entry | Amount | Finding | Required response |
|---|---:|---|---|
| Recorded online payment | ₹40,000 | Instruction rejected; no debit | Correct premature payment posting |
| Issued cheque | ₹12,000 | Validly issued, not presented | Retain supported timing item |
| Second payment posting | ₹8,000 | Duplicate ledger entry | Reverse the duplicate appropriately |
| Documented deposit | ₹20,000 | Accepted, credit occurs later | Retain supported timing item |

Correcting the premature ₹40,000 payment and duplicate ₹8,000 posting increases the bank ledger by ₹48,000 to ₹1,98,000. Their counterpart accounts must also be corrected; restoring the bank balance alone would leave the supplier records wrong.

The statement balance is ₹1,90,000. Adding the ₹20,000 deposit awaiting credit and deducting the ₹12,000 unpresented cheque reaches ₹1,98,000. The remaining bridge consists of evidenced timing items, while the two posting errors have been corrected.

## Keep the liability or receivable correct

If a supplier payment was recorded but never executed, the supplier may still be owed the amount. Reverse or correct the original entry on its actual basis, restoring the relevant obligation where required. Do not credit miscellaneous income because the bank did not pay.

For a duplicated customer receipt, remove the duplicate through the correct customer or clearing account. Otherwise, the customer statement can show an artificial credit even after the bank balance is repaired.

Where the payment settled a different invoice from the one originally allocated, the bank movement may be correct while the allocation is wrong. That requires an allocation correction rather than another bank entry.

## Resolve wrong-account and date errors

A transfer may have been entered against Bank A while Bank B funded it. Confirm both statements and correct the bank allocation without duplicating the business expense or supplier settlement. Internal transfers need matching treatment at both account ends.

Retain the original transaction date and explain corrections through the business's controlled process. Do not move an entry into a later month simply because that removes it from the current reconciliation. Period treatment should follow the actual facts and applicable reporting requirements.

If a prior period is closed, obtain the appropriate review before changing it. Keep a visible link between the original entry and correction so later reconciliations can follow the movement.

## Test later evidence before closing timing items

When the ₹12,000 cheque and ₹20,000 deposit later appear, match them to the existing entries. The bank event clears the timing difference; it does not create a new expense or sale.

If they do not appear as expected, update the action and owner. A failed deposit, lost cheque or returned payment has changed status and should not remain indefinitely in the same timing category.

Compare the outstanding schedule with the next reconciliation to ensure an item was not copied twice or dropped without evidence. The schedule should explain both additions and removals.

## Fix the process that created the exception

The rejected transfer suggests the payment-posting routine needs a clearer execution checkpoint. The duplicate entry suggests imports or manual posting responsibilities overlap. Record one corrective action for each recurring cause instead of merely clearing the month's list.

The goal is a ledger reflecting real transactions and a short, supported list of genuine timing items. Investigating book-only entries carefully prevents the business from paying twice, closing an unpaid supplier balance or treating unavailable money as collected cash.

## Sources and references

- [ICAI: Bank Reconciliation Statement](https://resource.cdn.icai.org/74612bos60479-fnd-cp3.pdf)
- [ICAI: Rectification of Errors](https://resource.cdn.icai.org/74611bos60479-fnd-cp2-u6.pdf)
- [RBI: National Electronic Funds Transfer System—FAQs](https://www.rbi.org.in/commonman/english/scripts/FAQs.aspx?Id=274)