Skip to content
TThe Consulting Crew

Blogs · Finance

Case study: nine months of backlog books to a clean MIS in 30 days

By Ashish Kumar Sharma · Published 5 Aug 2026

The exact sequence we run when a founder arrives with a shoebox of statements and a deadline.

An honest note first: this is a composite, not one client. The business below is stitched together from several real backlog engagements we have run, with identifying details changed. The trigger, the sequence and the decisions are exactly what happens every time.

The trigger

Nobody wakes up wanting clean books. Something forces it. In this composite it was the usual pair: the bank asked for a current P&L and balance sheet before renewing a working-capital limit, and around the same week a GST notice landed asking about mismatches in old returns. The founder — a trading business doing roughly ₹4–5 crore a year — had a part-time accountant who left in November. Since then: GST returns filed from sales registers, nothing posted to the ledger, nine months of bank statements untouched.

This is more common than founders think. The GST portal now locks the auto-populated GSTR-3B liability and bars returns pending more than three years, so “we will fix it later” keeps getting more expensive. The books, though, are fixable — in about 30 days if you work in the right order.

Days 1–7: triage, in a fixed order

We always start with bank statements, not invoices. The bank is the one record that is complete, dated and third-party verified. We pull statements for every current account (this business had three, one of which the founder had forgotten about), import them, and let the money define the perimeter: every rupee in and out must end up explained.

Sales come second. The sales register mostly exists because GST returns were filed from it, so we import it and tie it to GSTR-1. Purchases come last — they are the messiest, but GSTR-2B gives us a supplier-side list of every invoice reported against the GSTIN, which is a far better starting point than a carton of paper bills.

Days 8–20: reconciliation, in order

  • Bank to books. Every receipt matched to a sales invoice or classified (advance, loan, transfer between own accounts). Every payment matched to a purchase, expense, salary, EMI or drawing.
  • Sales to GSTR-1. What was billed versus what was reported. Gaps here become the notice-reply file, not a surprise later.
  • Purchases to GSTR-2B. Supplier invoices in 2B but missing from the books get chased and recorded; invoices in the books but absent from 2B get flagged before any credit is claimed.
  • Parties and payroll. Debtor and creditor balances confirmed with the five largest of each; salary and TDS entries tied to challans.

The decisions that surface

A backlog job is not data entry — it is a queue of decisions that were silently deferred. Three show up in almost every engagement:

Unclaimed ITC. Months of purchases never reconciled against GSTR-2B means eligible credit sitting unclaimed — and some ineligible credit claimed on invoices suppliers never reported. Each line needs a call: claim, chase the supplier, or let it go. With the Invoice Management System live on the portal, this is now a monthly accept/reject discipline, not a year-end scramble.

Unbilled revenue. Goods delivered or work completed with no invoice raised. It has to be billed and reported — which also changes the GST liability the founder thought was settled. Better to find it yourself than in an audit.

Director and family money. Personal funds moved in when cash was tight, personal expenses paid from the business account. These get formalised as loan accounts or drawings with proper paperwork, because an unexplained credit in the bank statement is exactly what an assessing officer asks about.

Day 30: the first MIS

The deliverable is not “Tally is updated.” It is a three-page monthly MIS: P&L by month, debtors and creditors with ageing, and a cash summary against GST and TDS obligations. The first one is usually uncomfortable. In this composite, the founder saw for the first time that one product line ran at a much thinner margin than assumed, and that two large customers were paying 90+ days late while the business borrowed to cover the gap. That is the point: the bank got its financials, but the founder got an instrument panel.

Keeping it clean: the monthly cadence

Backlogs recur unless the cadence changes. On a retainer the rhythm is: books posted weekly from bank feeds and registers, GSTR-2B and IMS actions before the 3B is filed, payroll and TDS checked against challans, and the MIS on the founder's phone in the first week of the following month. A compliance calendar keeps due dates from becoming emergencies. Thirty minutes a month reviewing the MIS is what prevents the next nine-month hole.

How we can help

Backlog clean-ups are standard work for us — we run this sequence for businesses across Jaipur and beyond, as a one-time backlog accounting project followed by an ongoing bookkeeping and MIS retainer. Retainers run ₹2,999–₹29,999 per month plus GST with no lock-in — see pricing. If a bank or a notice has just forced the issue, send us the bank statements first; that is genuinely all we need to start.

This article is general information, not tax advice. The engagement described is a composite of multiple client situations with details altered. Rules and rates can change; confirm specifics for your business before acting.

Let's get your compliance off your plate.

Tell us what you are dealing with. A short reply from someone who does this every day — no pitch, no obligation.

  • Reply within one working hour on WhatsApp
  • Fixed monthly fee, agreed before any work starts
  • No lock-in — month to month, 15 days notice

Request a callback

Two fields and you are done. We reply on WhatsApp within one working hour, Mon–Fri 10:00–19:00 and Sat 10:00–14:00 IST.

or message us on WhatsApp instead →
The Consulting Crew

A Strategy That Drives Results