Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A finance executive finds that billed sales, booked sales, GST-declared sales and bank collections are four different numbers for the same month and cannot tell which differences are normal.
Sales reconciliation compares the four numbers in pairs. Invoice register vs ledger finds unposted invoices; ledger vs GST return finds credit note and classification gaps; invoices vs bank finds credit periods, TDS, discounts and fees.
A monthly sheet with the four totals, a list of reconciling items for each pair, and an owner named for each type of gap (billing, accounts, tax, collections).
Each month's sales figure is backed by invoices, matches the GST return after listed adjustments, and every rupee not yet collected is visible in the debtors ageing.
Sales reconciliation proves that four numbers agree for the same period: the sales you invoiced, the sales booked in your ledger, the sales you declared in your GST returns and the money that actually reached your bank. They will rarely be identical, but every difference should have a known cause and an owner.
What are the four numbers, and why do they differ?
Think of it as three pairs, each with its own typical gaps.
| Comparison | Typical cause of a gap | Who usually fixes it |
|---|---|---|
| Invoice register vs sales ledger | Invoices raised in the billing tool but not posted; cancelled invoices still in the ledger | Accounts |
| Sales ledger vs GST return (GSTR-1 and GSTR-3B) | Credit notes booked in a different month; exempt or export sales classified differently; amendments | Tax or accounts |
| Invoices vs bank receipts | Credit period; TDS deducted by customers; discounts; gateway or marketplace fees; part payments | Collections and accounts |
An invoice register is the list of every invoice issued, usually exported from your billing software, Tally or Zoho Books. The sales ledger is the sales account in your books. They should be the same list, but when billing happens in one tool and accounting in another, they drift.
A worked example: October sales
A distributor’s billing software shows October sales of ₹48,60,000. The sales ledger in the accounting system shows ₹48,25,000. The difference is ₹35,000.
Going through the invoice list number by number, the accountant finds that invoice 1147 for ₹35,000, raised on 31 October, was never posted because the export to accounts ran at 6 pm and the invoice was raised at 7 pm.
| Step | Amount |
|---|---|
| Sales per invoice register | ₹48,60,000 |
| Sales per ledger | ₹48,25,000 |
| Difference | ₹35,000 |
| Invoice 1147 not posted | ₹35,000 |
| Unexplained | ₹0 |
Posting invoice 1147 in October brings the ledger to ₹48,60,000. Only then should the October GSTR-1 be prepared, because the GST return should be built from complete books.
Why will collections never equal sales in the same month?
Because most business sales are on credit and some money never arrives as cash at all. In the same month:
- Customers on 30 or 45 day terms pay next month or the month after.
- Corporate customers deduct TDS on services, so you receive less than the invoice and claim the TDS as a tax credit.
- Customers paying through a payment gateway receive the full invoice amount from you, but the gateway deducts its fee before settling.
- Some customers short-pay for discounts, damages or disputes.
For example, of the ₹48,60,000 billed in October, the distributor might collect ₹31,20,000 within the month, see ₹1,10,000 held back as TDS by corporate customers, lose ₹42,000 to gateway fees, and carry ₹15,88,000 as debtors within their 30 day terms. Those four parts add back to ₹48,60,000.
A healthy gap is one you can explain line by line, not a particular percentage. The useful measure is your debtors ageing: how much of the unpaid amount is within terms, and how much is overdue by more than 60 or 90 days. If collections fall behind sales month after month and the overdue bucket keeps growing, that is a collections problem, not a reconciliation one.
Which of the four checks should a small business do first?
Do them in this order, every month:
- Invoice register to ledger. Every other check depends on this being complete.
- Ledger to GST return. Agree before you file GSTR-1, so you do not have to amend later.
- Invoices to bank receipts. Mark each invoice as paid, part paid or open, and record TDS and fees separately.
- Review the debtors ageing. Chase anything overdue.
For a business with around 100 invoices a month, steps 1 and 2 typically take an hour or two if done before filing. Left for a quarter, the same work can take days.
Where do invoices meet the bank?
The hardest pair is usually invoices against bank receipts, because customers pay several invoices in one transfer, leave out the invoice number, or pay a round figure. The next article walks through the ways that match breaks, and the GSTR-1 versus GSTR-3B guide explains the GST side.
What to read next
- Next in this series: Invoice-to-bank reconciliation: the common failure modes
- GSTR-1 vs GSTR-3B reconciliation
- For the full set of reconciliations, see reconciliation software for Indian finance teams
Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →