How to Investigate Transactions Found in the Bank but Missing from Your Books
Use the bank movement as the start of an investigation, then identify its real accounting counterpart.
Read guide · 5 minTHE SETUPBILINGS JOURNALPractical guides for
Practical guides for
Indian businesses.
Understand your accounts, build reliable bookkeeping routines and work through GST questions with clear examples and source-linked explanations.
400 guides · 12 categories · India
Find a useful starting point
Browse all categoriesHow to Investigate Transactions in Your Books but Missing from the Bank
Determine whether an unmatched ledger entry is valid timing, a posting error or a payment that never happened.
Read guide · 5 minHow to Trace an Opening Bank Reconciliation Difference
Reconstruct the previous closing reconciliation before changing this period’s opening bank figure.
Read guide · 5 minHow to Clear Old Outstanding Items in a Bank Reconciliation
Resolve each old item according to its actual cause instead of writing off the list to make it disappear.
Read guide · 5 minHow to Map Bank Statement Columns Before Importing Transactions
Preview the import using known transactions and a balance check before allowing statement data into the working records.
Read guide · 5 minHow to Avoid Duplicate Entries When Reimporting a Bank Statement
Check overlap and evidence before reimporting, and verify both transaction counts and money totals afterward.
Read guide · 5 minHow to Match Bank Transactions Using UTR and Payment References
Treat references as evidence with a defined scope, then confirm amount, direction and the underlying party.
Read guide · 5 minHow to Reconcile One Bank Payment Against Several Bills
Keep one bank movement linked to a supported bill-by-bill allocation, with fees and other differences explained separately.
Read guide · 5 minHow to Reconcile One Bank Receipt Against Several Customer Invoices
Use remittance evidence to split one receipt across invoices and keep any unallocated balance visible.
Read guide · 5 minHow to Reconcile a Part Payment Without Closing the Whole Invoice
Apply only the supported amount received and keep the unpaid portion visible until it is genuinely settled or adjusted.
Read guide · 5 minMoney Received from an Unknown Payer: How to Investigate It
Record the bank movement appropriately while keeping its source and purpose under active investigation.
Read guide · 5 minHow to Investigate an Unidentified Debit in a Business Bank Account
Check the debit’s authority and substance promptly, then reflect the movement without inventing an expense or guaranteed recovery.
Read guide · 5 minHow to Reconcile Daily UPI Collections with Sales Records
Use three connected checks: expected sales collections, confirmed payments and the money credited or still awaiting settlement.
Read guide · 5 minUPI Shows Pending: How to Record the Sale While Payment Is Unconfirmed
A pending attempt needs status tracking. It should not automatically mark a sale paid or create money in the bank ledger.
Read guide · 5 minHow to Reconcile a UPI Payment That Was Later Reversed
A reversal needs its own evidence and commercial explanation; a net zero bank movement does not necessarily cancel the sale.
Read guide · 5 minHow to Reconcile Collections from Multiple Business QR Codes
Map each QR to its actual receiving route and reconcile transactions before combining channel totals.
Read guide · 5 min