GST and banking should reconcile continuously, not quarterly.

Quarterly reconciliation is a polite fiction. By the time a variance shows up in the audit pack, the borrower has already taken three more loans. Three-way reconciliation belongs in your EWS layer, running every twenty-four hours.

The standard rhythm in Indian lending is to reconcile a borrower's GST returns, banking statements, and audited financials once a quarter, sometimes twice a year. The audit team takes the latest GSTR-3B, the latest bank statement, and the latest signed financials, and checks that the numbers tell roughly the same story. Variance under five percent is fine. Variance under ten percent gets a footnote. Variance above ten percent gets escalated, and by the time it does, the borrower has been on the books for nine months.

This is the wrong rhythm for the data we now have access to.

What changed

GST returns are filed monthly. Bank statements are available daily. Audited financials are annual, but their components, sales registers, purchase registers, expense ledgers, are produced continuously. There is no longer any operational reason to reconcile these three sources once a quarter. The data has been continuous for six years. The reconciliation rhythm has not caught up.

The reason it has not caught up is that manual three-way reconciliation is hard. Doing it requires sitting across GST returns, parsed bank statements, and the audited P&L for twelve months, normalising the formats, lining up periods, and computing variances. A credit ops analyst can do one borrower a day. A risk team with eight analysts can cover roughly forty borrowers a month. For a portfolio of two thousand, that is once every four years.

What the variance actually tells you

The variance between GST turnover and banking inflows over a rolling twelve-month window is one of the most predictive signals available in Indian SME credit. A small persistent gap (say one to three percent) usually reflects cash transactions that fall outside GST. A growing gap reflects either cash leakage, undisclosed sales, or revenue that is being reported but not received, all bad. A gap that suddenly closes during the second half of a financial year is a sign of last-minute window-dressing.

The variance between audited financials and the sum of monthly GST returns is even more telling. Audited revenue should match GST-reported turnover plus exempt sales plus exports plus zero-rated supplies. If it does not, either the auditor missed something or the GST returns are understated. Either way, you have a variance that warrants a conversation.

The variance between banking inflows and audited revenue should be the smallest of the three. Big differences here surface receivable aging problems, customer concentration risk, or, in the worst case, falsified bookkeeping.

Why continuous matters

A quarterly reconciliation is structurally a lagging indicator. By the time the variance shows up, the borrower has typically taken on additional liabilities, the operating environment has shifted, and the original signal is buried under newer noise. A continuous reconciliation, run every twenty-four hours, lets you see the variance emerge. A two-percent gap that appears in March, grows to four percent in April, and stabilises at five percent through May is a different story than a single five-percent gap discovered at the September audit.

The emergence is the signal. The end-state is just bookkeeping.

This is what AICA does

AICA's monitoring layer reconciles GST, banking, and audited financials continuously across every borrower in your portfolio. When a variance crosses your policy threshold, five percent, ten percent, whatever you set, an alert fires within twenty-four hours, scored against severity and routed to the right team. The reconciliation history is auditable: every period, every variance, every threshold crossing, with sources timestamped.

Quarterly reconciliation made sense when the data arrived quarterly. The data arrives daily now. The reconciliation should too.

SEE IT IN ACTION

Reconciliation that runs while you sleep.

Book a demo and we'll show you AICA's continuous monitoring on a sample portfolio.

A Recur Club product