Three-Way Triangulation: Reconciling GST, ITR and Bank Statement Turnover for MSME Files
GST returns, the income tax return and the bank statement each report a different number for the same year, and all three can be correct. GST measures taxable supplies, the ITR measures revenue as booked, the bank measures gross credits. Triangulation means bridging the definitions first and treating only the residual as a finding.
Key facts
- The three definitions are set out in law and they genuinely differ. GST "aggregate turnover" is "the aggregate value of all taxable supplies… exempt supplies, exports of goods or services or both and inter-State supplies of persons having the same Permanent Account Number, to be computed on all India basis but excludes central tax, State tax, Union territory tax, integrated tax and cess" (CGST Act, section 2(6)). Revenue in the ITR is what the accounting standards say was earned. Bank credits are whatever landed.
- YuSight carries 100% of figures with a citation, one click from the CAM back to the page of the GST return, ITR or bank statement it came from — which is what makes a 30-line bridge auditable rather than assertable.
- The borrower population is enormous and mostly informal in its record-keeping. "Over 7.83 crore enterprises have registered on URP and UAP as of 28.02.2026" (PIB, *Udyam Registration Portal*, 30 March 2026).
- Audited accounts may not exist at all. Section 44AB requires a tax audit only above ₹1 crore of turnover, rising to ₹10 crore where cash receipts and cash payments are each within 5% of their totals (Income Tax Department, *Section 44AB*). Below that, the ITR figure carries no auditor's opinion behind it.
- The MSME turnover ceilings that define your borrower segment moved. The Union Budget 2025-26 raised the turnover limits to ₹10 crore for micro, ₹100 crore for small and ₹500 crore for medium, with investment limits raised to ₹2.5 crore, ₹25 crore and ₹125 crore (PIB, *Investment and turnover limits for classification of all MSMEs*).
Why do three true numbers never agree?
Because each source was built for a different purpose by a different party under a different rule.
| GST returns | Income tax return | Bank statement |
|---|---|---|---|
What is measured | Value of supplies made | Revenue earned | Money received |
Recognition trigger | Time of supply — invoice or payment, whichever is earlier | Accrual, per the accounting standards | Value date of the credit |
Includes things that are not revenue | Branch and stock transfers between distinct persons, asset sales on which GST was charged, scrap | Nothing — it is the revenue line | Loan drawdowns, refunds, transfers between own accounts, capital introduced, failed-payment reversals |
Excludes things that are revenue | Unbilled revenue, revenue outside GST | Other income, sat below the revenue line | Credit sales not yet collected, receipts into accounts you were not given, cash |
Contains tax | No — the value is net of GST | No | Yes — the customer paid you the GST too |
Filed or produced by | The borrower, monthly, in public | The borrower, annually, under penalty | A third party, continuously |
Editable after the fact | No | Only by revised or updated return | No |
Two structural consequences follow, and they explain most of the spread before you look at a single transaction. Bank credits are systematically the highest of the three, because they carry GST on top of revenue and include financing inflows. GST turnover is systematically higher than ITR revenue for any borrower with more than one GSTIN, because inter-state stock transfers between branches of the same legal person are taxable supplies under GST and are not revenue in anyone's books.
Which number is your anchor?
Anchor on ITR revenue and bridge outward to the other two.
The reasoning is not that the ITR is the most reliable — it is often the least contemporaneous. It is that the ITR revenue figure is the one your ratios are built on. DSCR, interest cover, the current ratio and every leverage test in your credit policy are computed off the audited or ITR-filed financials. GST corroborates whether that top line is real; bank credits corroborate whether it converts to cash. Neither replaces it.
The exception is the small-ticket, short-tenor, GST-surrogate product where you do not have financials at all. There the anchor is GST turnover and the bank statement is the only corroboration you have — and the tenor and ticket must respect that.
How do you build the bridge, step by step?
- Fix the period. All three sources on the same financial year, April to March. GST monthly returns must be summed by tax period, not by filing date.
- Collect every GSTIN under the PAN, not just the one on the application. Aggregate turnover under section 2(6) is computed on an all-India PAN basis; if you sum one state's returns you have a fragment.
- Collect every bank account. Ask for a list of all operative accounts and a bank certificate confirming it. The account you were not given is the one that matters.
- Bridge GST to ITR revenue. Remove what GST counts and accounting does not; add what accounting counts and GST does not.
- Bridge gross bank credits down to customer collections. Remove every non-revenue inflow, line by line.
- Bridge ITR revenue up to expected collections. Add GST charged to customers, adjust for opening and closing receivables, then remove collections that legitimately never reach the accounts you hold.
- Compare the two collection figures. That residual — not the raw spread — is the finding.
- Read the residual against the tolerance table, and document the whole bridge in the CAM whether it closes or not.
Worked triangulation: Meenakshi Engineering Works
All figures below are illustrative and constructed to demonstrate the method. They are not client data.
A partnership firm in Coimbatore making precision machined components, filing ITR-5, with two GSTINs — Tamil Nadu and Karnataka — and three bank accounts. FY 2025-26.
The three headline numbers
Source | Basis | ₹ |
|---|---|---|
GSTR-1, both GSTINs, 12 months, net of credit notes | Aggregate outward supplies | 47,86,00,000 |
ITR-5, Part A-P&L | Revenue from operations | 44,20,00,000 |
Three bank statements, 12 months | Gross credits | 52,64,00,000 |
Spread, highest to lowest | 52,64,00,000 − 44,20,00,000 | 8,44,00,000 |
Spread as % of ITR revenue | 8,44,00,000 ÷ 44,20,00,000 | 19.1% |
A 19% spread across three sources, none of which is wrong. This is why the raw comparison that many credit policies still require is worse than useless — it generates an exception on every honest file.
Step 1 — bridge GST turnover to ITR revenue
Line | ₹ |
|---|---|
Aggregate outward supplies per GSTR-1, both GSTINs | 47,86,00,000 |
Less: stock transfers between the Tamil Nadu and Karnataka GSTINs — taxable supplies between distinct persons, not revenue in the firm's books | (2,74,00,000) |
Less: sale of a used vertical machining centre — GST charged, credited to the asset block, not to revenue | (46,00,000) |
Less: scrap sales credited to other income, below the revenue line | (58,00,000) |
Less: March 2025 despatches invoiced in April 2025 — FY 2025-26 for GST, FY 2024-25 revenue | (1,02,00,000) |
Add: March 2026 despatches invoiced in April 2026 — FY 2025-26 revenue on accrual, FY 2026-27 for GST | 88,00,000 |
Add: revenue recognised on a part-completed contract at 31 March 2026, invoiced May 2026, no time of supply yet | 22,00,000 |
GST turnover restated on an accounting basis | 44,16,00,000 |
Revenue from operations per ITR-5 | 44,20,00,000 |
Residual | 4,00,000 (0.09% of revenue) |
The GST-to-ITR leg closes. Note that the two largest reconciling items — branch transfers and the machine sale — are both entirely innocent, and both would have shown up as a ₹3.2 crore "turnover mismatch" on a policy that compares headline numbers. For the return-level detail behind the GST column, see GSTR-1 vs GSTR-3B for credit assessment and the wider GST return analysis framework.
Step 2 — bridge gross bank credits down to customer collections
Line | ₹ |
|---|---|
Total credits across all three accounts, 12 months | 52,64,00,000 |
Less: transfers between the firm's own accounts | (4,18,00,000) |
Less: drawdowns on the cash credit and channel-finance limits credited to the current account | (9,42,00,000) |
Less: term loan disbursement for the new machining line | (1,20,00,000) |
Less: partners' capital introduced during the year | (60,00,000) |
Less: GST refund on exports received from the department | (74,00,000) |
Less: income tax refund | (18,00,000) |
Less: interest credited on fixed deposits — other income, not revenue | (11,00,000) |
Less: insurance claim settled on a fire at the Hosur godown | (34,00,000) |
Less: outward NEFT and cheque payments returned and re-credited | (46,00,000) |
Less: sale proceeds of the used machining centre, including GST | (54,28,000) |
Credits attributable to customer collections | 34,86,72,000 |
Two-thirds of the ₹52.64 crore that looked like turnover is turnover. The other third is financing, refunds, reversals and the firm moving its own money around — which is exactly why gross credits should never be compared against declared turnover directly. The classification discipline behind this table is the subject of bank statement analysis for lenders.
Step 3 — bridge ITR revenue up to expected collections
Line | ₹ |
|---|---|
Revenue from operations per ITR-5 | 44,20,00,000 |
Add: GST charged to customers — 18% on ₹41,00,00,000 of domestic taxable revenue; ₹3,20,00,000 of exports under LUT carry none | 7,38,00,000 |
Gross amount billed to customers | 51,58,00,000 |
Add: trade receivables at 1 April 2025 | 9,84,00,000 |
Less: trade receivables at 31 March 2026 | (11,26,00,000) |
Less: revenue recognised but not yet invoiced at 31 March 2026 | (22,00,000) |
Total collectible during the year | 49,94,00,000 |
Less: invoices discounted under the channel-finance facility, where the customer remits to the discounting bank and only the net proceeds reached the account | (7,92,00,000) |
Less: export proceeds received into an EEFC account — statement not supplied | (3,20,00,000) |
Less: collections taken in cash and not deposited | (1,86,00,000) |
Less: settled by book adjustment against the group's Chennai entity | (1,64,00,000) |
Less: TDS deducted by customers under section 194Q at 0.1% | (3,40,000) |
Expected credits into the three accounts supplied | 35,28,60,000 |
Step 4 — the residual
Line | Arithmetic | ₹ |
|---|---|---|
Expected customer collections (Step 3) |
| 35,28,60,000 |
Customer collections actually identified (Step 2) |
| 34,86,72,000 |
Unexplained residual | 35,28,60,000 − 34,86,72,000 | 41,88,000 |
Residual as % of ITR revenue | 41,88,000 ÷ 44,20,00,000 | 0.95% |
Under 1%. Record it, cite the bridge, move on.
But the bridge produced three findings that the residual itself does not show, and these are the point of the exercise:
- ₹3.20 crore of export proceeds sit in an account you were never given. That is 7.2% of turnover outside the security package and outside your cash-flow view. Get the EEFC statement and bring the account under the hypothecation.
- ₹1.86 crore was collected in cash and not banked. At 4.2% of revenue that is tolerable for this segment, but it means any DSCR computed from bank credits alone understates the business, and any drawing power computed from banked collections needs the same adjustment. Cross-check it against Form 26AS section 194N entries for cash withdrawals — the method is in Form 26AS analysis for lenders.
- ₹7.92 crore of receivables were discounted. That is off-balance-sheet funding of 17.9% of turnover, recourse almost certainly with the firm, and it belongs in the leverage calculation and in the drawing power workings whether or not the accounts show it as debt.
What does each residual gap actually mean?
Pattern after bridging | Most likely cause | What to pull next |
|---|---|---|
GST > ITR, persistent, unexplained | Branch transfers or asset sales you missed; or revenue billed under GST and suppressed in the books | GSTR-9 Table 5, the fixed asset schedule, Part A-OI of the ITR |
ITR > GST, persistent, unexplained | Exempt or non-GST revenue; unbilled revenue; or a turnover figure inflated to support a limit | GSTR-1 Table 8, GSTR-9C reconciliation, the receivables ageing |
Collections far below expected, receivables flat | Sales are being booked and not collected, or invoices are not real | Top 20 debtors, ageing, e-way bills against the largest invoices |
Collections far below expected, receivables rising | Genuine working-capital stretch | DSO trend, the buyer's own credit standing, limit resizing |
Collections far above expected | Third-party money in the account, undisclosed business, or round-tripping within the group | Trace the top 20 credits to invoices; match remitter names against the GSTR-1 customer list |
GST filed on time, ITR filed late or not at all | Audit case still open, or a genuine non-filer | Form 26AS, AIS, the filing acknowledgement |
GST turnover falling while bank credits hold up | Sales moving to a second entity or off the books | Search Taxpayer for every GSTIN under the PAN; check for a new registration |
All three agree to within 1% on a cash-heavy business | Suspiciously tidy | Verify independently — a perfectly reconciling small trader is unusual |
How much variance is acceptable?
Judge the residual after bridging, never the raw spread. As a working scale for MSME files:
Residual as % of ITR revenue | Read | Action |
|---|---|---|
Under 1% | Rounding, cut-off and small cash | Record the bridge, proceed |
1% to 3% | One reconciling item you have not found | Explain it in the CAM; usually a missing account or a cut-off |
3% to 8% | The turnover is partially unproven | Do not sanction on the current file. Ask for the missing statement, GSTR-9/9C and the receivables ageing |
Over 8% | Treat the declared turnover as unproven | Escalate; resize to what you can evidence, or decline |
These bands are a starting position for a credit policy, not a regulatory standard. Tighten them for a trading business with clean documentation; widen them for a project-based manufacturer where cut-off genuinely swings.
Which source wins when the three disagree?
There is an order, and it is not the order most credit policies assume.
- The bank statement wins on cash, always. It is the only one of the three produced by a third party in real time, and the only one that says whether the money arrived. It says nothing about profitability.
- GST returns win on the top line, because they are monthly, invoice-level, filed in public, cannot be revised, and are corroborated by every customer claiming input tax credit against them. A borrower who inflates GSTR-1 pays tax on the inflation.
- The ITR wins on structure — the balance sheet, the expense heads, the add-backs and the asset base. It is the only source that tells you anything about cost. What each schedule carries is set out in ITR analysis for loan underwriting.
So: if GST and the bank agree and the ITR does not, the ITR is stale or wrong and you should ask for the audited accounts. If the ITR and GST agree and the bank does not, you are missing an account or the business is not converting sales to cash. If the ITR and the bank agree and GST does not, look for branch transfers and exempt supplies before you look for anything worse.
Where does triangulation quietly fail?
- Composition dealers. They file GSTR-4 annually with no invoice detail, so the GST leg carries almost no information.
- Exempt sectors. Education, healthcare and unprocessed agricultural produce generate revenue with little or no GST footprint. The absence of GST turnover is not the absence of turnover.
- E-commerce sellers. Supplies through an operator appear with TCS under section 52 and settlement is net of commission and returns, so gross bank credits understate gross sales substantially.
- Multi-entity groups. Turnover circulating between related parties can inflate GST and ITR figures in both entities while producing no external cash. Bridge at group level, and map every document to the right entity first — see multi-entity document mapping.
- Cash-heavy retail. Where a large share of collections never enters the banking system, the bank leg cannot corroborate anything and you are back to two sources.
- Recently restructured businesses. A slump sale, a proprietorship converting to an LLP, or a new GSTIN mid-year will break the period comparison in ways no bridge can fix. Reconstruct the periods manually before you start.
How does YuSight handle triangulation?
The obstacle is rarely the arithmetic. It is that a real MSME file arrives as 24 GSTR-1 PDFs across two GSTINs, three years of ITRs in three different formats, and 36 months of bank statements from three banks in three layouts — and nothing is named consistently.
YuSight's Document Intelligence classifies each file, reads the GSTIN, PAN, account number and period off the face of it, and assigns it to the right entity and the right period. Financial Spreading builds the three series, applies the bridge, classifies every bank credit as revenue or non-revenue with the transaction narration attached, and produces the residual. Every figure that reaches the CAM carries a citation back to the source page, so a credit committee member can click the ₹7.92 crore discounting line and land on the statement entry that produced it — which is the difference between a reconciliation someone can check and one they have to believe.
FAQ
What do lenders check across GST, bank statement and ITR data?
Whether the same business appears in all three. GST tells you what was invoiced, the ITR tells you what was booked, and the bank tells you what was collected — and the interesting part is always what one source knows and the other two do not.
How much turnover variance is acceptable?
Judge the residual after you have bridged the definitions, not the raw spread. Under about 1% of revenue is normal; anything above roughly 8% means the declared turnover is not proven and you should size the limit to what you can evidence.
Which source wins when the three disagree?
The bank statement on cash, GST on the top line, and the ITR on everything below the top line. No single source wins outright, which is the whole reason for doing this in three directions rather than two.
Why is GST turnover higher than the turnover in the accounts?
Usually branch transfers. A stock movement between two GSTINs of the same firm is a taxable supply under GST and is not revenue in anybody's books. Asset sales and scrap do the same thing on a smaller scale.
Why are bank credits so much higher than turnover?
Because the customer paid you the GST as well as the price, and because loan drawdowns, refunds, transfers between your own accounts and returned payments all look like credits. On a typical MSME file a third of gross credits is not revenue at all.
Do I need every bank account, or is the main current account enough?
Every account. In the worked example ₹3.2 crore of export proceeds sat in an EEFC account nobody had asked for. Ask for a written list of all operative accounts and a bank certificate confirming it is complete.
What if the borrower has more than one GSTIN?
Pull them all. Aggregate turnover under the CGST Act is computed across every registration under the same PAN on an all-India basis, so summing one state's returns gives you a fragment of the business.
Can I do this if the borrower is a composition dealer?
Only partially. A composition dealer files an annual GSTR-4 with no invoice detail, so the GST leg gives you almost nothing and you are effectively reconciling two sources rather than three. Tighten the tenor and the ticket accordingly.
How far back should the reconciliation go?
Two full financial years for GST and bank statements, three assessment years for the ITR. One year cannot separate a cut-off difference from a pattern, and a pattern is what you are looking for.
Key takeaways
- Three sources, three legal definitions of turnover. A spread between them is the normal state of a clean file, not an exception.
- Anchor on ITR revenue, because that is what every ratio in your credit policy is built on. Bridge outward from there.
- Bridge before you compare. In the worked example a 19.1% raw spread reduced to a 0.95% residual with no wrongdoing anywhere in the file.
- Gross bank credits are not turnover. Strip own-account transfers, drawdowns, refunds, capital, claims and reversals before anything else.
- The bridge is more valuable than the residual. It surfaced an undisclosed EEFC account, ₹1.86 crore of unbanked cash and ₹7.92 crore of off-balance-sheet discounting — none of which the residual itself would have revealed.
- Pull every GSTIN under the PAN and every operative bank account. Missing sources, not dishonest ones, cause most failed reconciliations.
- Document the whole bridge in the CAM with a citation on every line. A reconciliation nobody can check is an assertion.
Watch YuSight spread a real balance sheet — two GSTINs, three banks, three years, one reconciled turnover figure. Book a live demo.