How to Clean Up Messy Books: A Step-by-Step Guide for Indian Businesses

Books go wrong in predictable ways: transactions entered twice or not at all, amounts parked in a suspense account, bank balances that don't match, and GST returns that say something different from the ledger. Cleaning them up is methodical work. This guide sets out the steps.

Step 1: Establish a Reliable Starting Point

Find the last period where the books were right — usually the last audited balance sheet. If even that is doubtful, rebuild opening balances from bank statements, loan statements and confirmations.

Step 2: Reconcile Every Bank Account

Bank statements are the most reliable record you have. Match every transaction in every account to an entry in the books. Unmatched items show you what's missing or duplicated.

Step 3: Clear the Suspense Account

Suspense accounts collect amounts nobody could explain at the time. Go through each item, trace it to its source, and move it to the correct ledger. A clean set of books has no suspense balance at the end.

Step 4: Match Sales With GST Returns

Compare invoices in the books with sales reported in GSTR-1 and tax paid in GSTR-3B. Differences might be missing entries, wrong tax rates, or invoices reported in the wrong period.

Step 5: Match Purchases With GSTR-2B

Compare purchases in the books with supplier invoices appearing in GSTR-2B. This shows credit you're entitled to but haven't claimed, and credit claimed where the supplier hasn't reported the invoice.

Step 6: Reconcile TDS

Match TDS deducted from payments with TDS returns and challans, and TDS deducted by your customers with Form 26AS.

Step 7: Confirm Balances

Get confirmations from major customers, suppliers and lenders for their balances, and investigate differences.

Step 8: Make Year-End Entries

Record depreciation, accruals, provisions and closing stock for each period that's missing them.

Step 9: Record the Exposures

List anything the clean-up reveals with tax consequences — unreported sales, unclaimed or wrongly claimed credit, missed TDS — and decide how to deal with each.

Staying Clean

Once the books are right, move to monthly bookkeeping with regular reconciliations, so the same problems don't build up again.

Getting Help

Think Filing cleans up books for businesses across India, from a few months of catch-up to multi-year backlogs.