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

For a transaction appearing in the bank but missing from your books, first confirm the account, amount, direction and reference. Obtain the bank advice and identify the underlying event before posting it. The entry may be a customer receipt, bank charge, interest, standing instruction, internal transfer or an error. A credit is not automatically sales, and a debit is not automatically an expense.

Keep unresolved items in a controlled exception process with an owner and review date. The bank ledger must reflect actual movements appropriately, but the final counterpart should be supported by evidence rather than selected solely to remove the reconciliation difference.

## Confirm that the book entry is genuinely absent

Consider an illustrative Vadodara engineering supplier reviewing its monthly statement. Before creating anything, accounts searches the bank ledger, customer allocations, journals and other bank accounts. A transfer may have been posted to the wrong bank, or a receipt may be included in a combined entry.

Check the date range and filters. A transaction recorded on the previous day or under a shortened narration is not necessarily missing. Search references and amounts across a sensible period, while preserving the distinction between a late posting and a true omission.

ICAI's bank-reconciliation material includes bank charges, interest and direct receipts among items that can require cash-book adjustment. Its error-correction material reinforces the need to identify the actual error before choosing the correcting entry.

## Build an investigation list

Record each unmatched bank movement with statement date, amount, debit or credit, full narration, reference, proposed type and supporting document needed. Retain the original bank description even after adding a clearer internal explanation.

Ask the team most likely to hold the evidence. Sales may know a customer remittance, purchasing a supplier refund, and administration a standing insurance instruction. A bank narration alone may not reveal which invoice or expense period is involved.

If a movement is potentially unauthorised, escalate through the bank's official reporting process promptly rather than waiting for the routine monthly review. Keep that issue separate from an ordinary missing invoice investigation.

## Work through four illustrative movements

The supplier's books show ₹2,10,000 before recording these confirmed bank-only items:

| Bank-only movement | Effect on bank ledger | Appropriate evidence |
|---|---:|---|
| Customer settlement | +₹24,000 | Remittance matched to an existing invoice |
| Interest credit | +₹500 | Bank interest advice |
| Service charge | -₹1,180 | Bank charge detail and invoice where relevant |
| Insurance standing payment | -₹25,000 | Authorisation and policy documentation |
| Net adjustment | -₹1,680 | Total of supported entries |

Adjusted bank ledger is ₹2,08,320, agreeing with the statement if no other differences remain. The ₹24,000 customer settlement reduces the relevant receivable; it does not create another sale when the invoice was already recorded.

The insurance debit requires the correct expense or prepaid treatment based on the coverage and accounting facts. The bank movement confirms payment, but does not alone determine which period should bear the cost. The ₹1,180 charge also needs its actual tax and fee breakdown rather than an assumed standard split.

## Trace references to underlying documents

For a transfer, ask for the sender or recipient detail and remittance advice. RBI's NEFT guidance identifies reference, date, amount and participating-party information as useful for tracking. Use those fields together rather than relying on a familiar-looking name.

A supplier refund should connect to the original payment, return or credit arrangement. An owner contribution or borrowing should be classified according to its substance and documentation. Posting every unexplained credit as revenue can materially distort the business result.

For recurring debits, inspect the mandate or agreement and compare amount and frequency. A legitimate recurring payment can still be incorrectly coded or omitted from the cash plan. A narration resembling a known service is not proof that the debit was authorised.

## Distinguish bank error from book omission

If the bank confirms an erroneous debit or credit, retain the complaint and response and track the correction. A valid ledger should not be rewritten as though the business incurred an expense or earned income merely because the bank made an error.

Where facts remain unresolved at a reporting date, use an appropriate controlled temporary account or other treatment established for the circumstances. Record what is known, what remains uncertain and who must resolve it. A suspense label is a temporary tracking method, not permission to stop investigating.

Avoid offsetting unrelated unknown credits and debits. A ₹10,000 credit and ₹10,000 debit can leave no net balance while both require explanation.

## Post once and preserve the trail

After approval, link each entry to its bank movement and supporting evidence. Check whether imports or another colleague have already created an entry during the investigation. Duplicate posting is a common risk when several people work on the same exception.

Rerun the reconciliation and confirm that the supported adjustment is no longer also included as an outstanding timing item. The same effect should not be counted in both places.

## Review who supplies recurring evidence

Assign a person to obtain the bank’s regular charge and interest advices. A repeated omission may result from documents going to an unattended email address rather than difficult accounting. Fixing that handover can reduce the next reconciliation’s exception list.

## Reduce recurring omissions

Review repeated missing charges, interest and standing payments. Establish a regular source-document and coding routine for them, with a check against the statement. Keep one person responsible for closing each exception.

The useful outcome is a bank ledger that reflects real movements and counterpart accounts that explain their substance. Investigating bank-only transactions carefully prevents both hidden omissions and easy but incorrect postings that make the bank balance agree while leaving customer, supplier or profit records wrong.

## 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)