Skip to main content
Technical · 4 min read

Constructing a Synthetic P&L for MSMEs from Bank Transaction Data

An MSME synthetic P&L is not a replacement for an audited income statement — it is a structured inference from bank transaction data that produces a decisioning-grade view of revenue and operating costs for borrowers who have never engaged a CA. Understanding how it is constructed, and where it falls short, is essential for any lender relying on it.

Terra Insight
Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 25 April 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops
Knowledge Card
Problem

Most MSME borrowers do not maintain P&L accounts, making income assessment for credit underwriting dependent on either costly CA estimates or inaccurate surrogate income proxies.

How It's Resolved

Business inflows from the bank statement (after personal transaction exclusion) are classified by channel and counterparty type to approximate revenue. Recurring and identifiable outflows are mapped to operating cost categories — cost of goods, staff, overheads, tax obligations, debt service — to produce a structured income and expenditure view.

Configuration

Revenue classification rules vary by industry segment (trading: high-frequency moderate-value inflows; services: lower-frequency higher-value inflows; manufacturing: bulk NEFT/RTGS from distributors). Cost classification can be configured to exclude or include owner withdrawals from the operating cost total.

Output

Synthetic P&L showing estimated gross revenue, estimated operating costs by category, estimated EBITDA proxy, and debt service coverage ratio (DSCR) derived from actual EMI outflows vs business inflow.

Approximately 90% of India’s registered MSMEs file no audited financial statements. For the lender trying to assess whether a trader in Surat or a fabricator in Ludhiana can service a ₹15 lakh working capital loan, the bank statement is the only structured financial record available. The question is not whether to use it — it is how to extract a credible income picture from it.

What a Synthetic P&L Is

A synthetic P&L is a structured approximation of a business’s revenue and operating cost position, constructed from categorised bank transaction data. It does not carry the assurance of an audit, and it does not produce balance sheet items or depreciation schedules. What it produces is a decisioning-grade view of cash-based income and expenditure — sufficient for loan sizing, DSCR calculation, and risk classification, but not for tax filing or investor disclosure.

The ICAI’s auditing standards draw a clear line around assurance engagements. A synthetic P&L sits entirely outside that boundary. Its value lies in its speed (minutes, not days), its cost (zero to the borrower), and its reproducibility (same inputs produce the same output, creating an auditable underwriting trail).

How Revenue Is Inferred

Business Inflow Classification

After personal transactions are excluded from the account, the remaining inflows are classified by channel. NEFT and RTGS credits from business-registered counterparties (identified through narration patterns, CIN references, and GST payer identifiers) are treated as B2B revenue. UPI credits from merchant-registered VPAs or known business counterparties are classified as business receipts. IMPS credits with trade-related narration markers follow the same logic.

The classification produces a business inflow ledger that approximates gross revenue. For a GST-registered MSME, GSTR-1 declarations serve as an independent cross-check on the revenue figure.

Recurring vs One-Time Inflows

Revenue inference distinguishes between recurring inflows (monthly patterns from the same counterparties — consistent with regular customers) and one-time large credits (advance payments, project receipts, asset disposal). Recurring inflows form the base for annualised revenue estimates. One-time credits are noted separately and excluded from trend-based forward projections unless the borrower provides context.

How Operating Costs Are Mapped

Cost CategoryBank Statement SignalReliability
Cost of goods soldOutflows to identified supplier/vendor accounts (NEFT, IMPS)High — frequency and amount patterns consistent with procurement cycles
Staff costsRecurring salary credits (NEFT to multiple individuals on consistent dates)High — salary NEFT patterns are highly distinctive
Rent and fixed overheadsRecurring NACH debits or periodic NEFT to property-related accountsMedium — hard to distinguish rent from equipment lease or insurance
GST / tax paymentsOutflows to government accounts (GSTIN-linked banks, TDS challan payments)High — tax payment narrations are structured
Loan repayments (existing)NACH EMI debits, scheduled NEFT to NBFCs/banksHigh — NACH mandate amounts are fixed and recurring
Owner withdrawalsCash withdrawals, self-transfers to linked savings accountsHigh volume but must be excluded from operating cost total

What the Synthetic P&L Cannot Capture

Non-cash items are entirely absent: depreciation, amortisation, and provisions do not appear in bank statements because they involve no cash movement. Barter transactions, contra entries between related parties, and inventory adjustment entries are similarly invisible. Accrued income (invoiced but not yet collected) is excluded because it has not yet hit the bank account.

The synthetic P&L is, by nature, a cash-basis approximation. For working capital loan assessment — where the question is whether the borrower generates enough monthly cash flow to service an EMI — the cash basis is actually more directly useful than an accrual P&L. For term loan assessment requiring net worth and asset coverage, the synthetic balance sheet (a separate layer) is required in addition.

India-Specific Patterns That Affect P&L Construction

GST-filing-driven cash flow is a consistent feature of Indian MSME bank statements. GST liability payments (typically in the first week of the following month) create predictable outflow spikes that are operating costs, not revenue variances. Advance Tax payment dates (15 June, 15 September, 15 December, 15 March) create similar spikes. Systems that misread these large periodic outflows as operating cost increases will distort the month-over-month cost picture.

MSME Samadhaan (MCA’s MSME payment delay portal) data shows that payment delays of 45–90 days are common in B2B MSME transactions. This means revenue recognition in a bank-statement-based P&L lags actual invoicing by the same period — a point lenders need to account for when comparing the synthetic P&L against GST return data.

The bank statement analytics layer within TransactIQ constructs the synthetic P&L as part of the four-layer MSME synthetic financials output. The full methodology is described on the bank statement analysis platform page. The Institute of Chartered Accountants of India (ICAI) has published guidance on surrogate income documentation that provides useful context for where bank-based estimates sit relative to assurance standards.

Common questions about synthetic P&L construction and its use in lending decisions are covered below.

Primary reference: Institute of Chartered Accountants of India (ICAI) — India's accounting standards body, whose auditing and financial reporting standards define the auditor-grade threshold that synthetic P&Ls are explicitly not intended to replace.

Frequently Asked Questions

What line items can a synthetic MSME P&L reliably estimate from bank data?
Revenue (gross inflows from business counterparties), cost of goods sold (outflows to identifiable vendor/supplier accounts), staff costs (recurring salary credits or NEFT transfers to employees), loan repayment obligations (NACH debits or scheduled EMI outflows), and tax payments (GST/TDS outflows to government accounts). Items that cannot be reliably estimated include depreciation, non-cash provisions, inventory holding costs, and accrued but unpaid liabilities.
How is revenue inferred from a bank statement if there are no invoice references?
Revenue inference relies on inflow characterisation: business-type UPI credits (merchant-registered counterparties), NEFT/RTGS receipts from corporate payers (identified by counterparty name patterns and CIN references in narration), and IMPS receipts with B2B transaction markers. Credits from financial institutions (loan disbursals), government accounts (GST refunds, subsidy credits), and identified personal senders are excluded. The residual business inflow total is treated as gross revenue for the period.
Is a synthetic P&L acceptable to lenders under RBI Digital Lending Guidelines?
RBI's Digital Lending Guidelines (2022, updated 2023) require lenders to maintain documented underwriting criteria and to use verified data sources. Bank statement analysis is an explicitly recognised alternative income documentation method for MSMEs and thin-file borrowers. The guidelines require lenders to disclose their credit assessment methodology to borrowers but do not prescribe that audited financials are mandatory — synthetic P&Ls based on bank data satisfy the documented, verifiable data source requirement when the methodology is reproducible.
What is the difference between a synthetic P&L and a CA-prepared income estimate?
A CA-prepared income estimate (used in some MSME lending programs) is based on a site visit, business records review, and professional judgment — it may be more accurate for businesses with complex inventory or barter arrangements. A synthetic P&L is fully automated from bank data, covers only the transactions visible in the statement, and can be produced in minutes. The CA estimate takes days and costs the borrower professional fees. For ticket sizes below ₹25 lakh and turnaround requirements under 48 hours, the synthetic P&L is the operationally viable option.
How does GST return data complement a bank-statement-derived synthetic P&L?
For GST-registered MSMEs (turnover above ₹40 lakh for goods, ₹20 lakh for services), GSTR-1 contains the taxable supply ledger — a near-complete revenue record. Cross-referencing GSTR-1 against the bank statement's business inflow total provides a consistency check: if GSTR-1 revenue significantly exceeds bank inflows, the borrower may be collecting through non-banking channels; if bank inflows significantly exceed GSTR-1 revenue, some inflows may be personal or non-taxable. The gap analysis flags divergence for manual review rather than automated override.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.