Skip to main content
Technical · 4 min read

Synthetic Balance Sheet for MSME Lending: What Bank Statements Can Approximate

A synthetic balance sheet for MSME lending does not replicate the full structure of an audited set of accounts. It approximates the items that bank transaction data can reliably support — working capital position, cash and bank balances, receivables and payables proxies — and it explicitly excludes the items it cannot touch, such as fixed assets and depreciation. Knowing what is in and what is out is what separates credible use of this method from overreach.

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

MSME credit assessments require a balance sheet view to determine net worth and working capital position, but most MSMEs do not maintain formal accounts — leaving lenders without the asset-liability picture needed for loan sizing.

How It's Resolved

Bank statement data supports approximation of current assets (cash balances, receivables proxy from payment lag analysis) and current liabilities (NACH mandates, recurring payables). Fixed assets, depreciation, and equity are excluded from the output because they cannot be reliably inferred from transaction data alone.

Configuration

Working capital window is configurable (3, 6, or 12 months). Receivables proxy lag thresholds are set per industry segment. Known NACH mandate amounts are used as the hard floor for current liability estimation. Owner withdrawal amounts can be treated as drawings (excluded from liabilities) or flagged for review.

Output

Approximate current asset position, approximate current liability position, net working capital estimate, and cash and bank balance as at the analysis date. Output is labelled as bank-data-derived, not auditor-certified.

A working capital loan for an MSME is sized on two inputs: the borrower’s cash flow generation capacity and their existing short-term obligation burden. The first comes from the synthetic P&L. The second requires a snapshot of the balance sheet — specifically, what the borrower currently owes and what they have available to meet those obligations. Bank statement data can provide a partial but useful view of that snapshot.

What a Synthetic Balance Sheet Is

A synthetic balance sheet for MSME lending is a structured approximation of current assets and current liabilities derived from bank transaction data. It does not cover fixed assets, long-term investments, or equity components. It covers the items that directly affect short-term credit capacity: cash position, approximate receivables, approximate payables, and known debt service obligations.

The term “synthetic” signals explicitly that this is a data-derived approximation, not a certified accounting statement. It is used in conjunction with the synthetic P&L to produce a more complete decisioning picture — one that a lender can act on without waiting for formal accounts that most MSMEs have never prepared.

What Bank Statement Data Can Approximate

Cash and Bank Balances

This is the most reliable item. The closing balance on the bank statement is exact and current. The statement also reveals average daily balance over the analysis period — a more useful credit signal than the point-in-time closing balance, because it filters out large end-of-day credits that reverse the next morning.

Receivables Proxy

Outstanding trade receivables can be approximated from payment timing patterns. If a business consistently receives payments from a set of counterparties with a 30-to-45-day lag after the standard payment cycle, the amount receivable at any given date can be estimated as the amount expected but not yet received. For manufacturing and trading MSMEs with regular B2B customer relationships, this proxy tends to be directionally reliable.

Payables Proxy

Outflow timing to vendors and suppliers provides a payables estimate. Recurring NEFT outflows to the same counterparties — especially those that appear consistently 30 to 60 days after inflows from related customers — suggest a standard credit period. The aggregate of expected but not yet disbursed outflows forms the payables approximation.

Known Debt Obligations

NACH debits to financial institutions provide an exact view of scheduled EMI commitments. Unlike most balance sheet items, this component is not an approximation — NACH mandates are fixed-amount, fixed-frequency instructions that appear precisely in the bank statement. Outstanding loan principal cannot be read from the statement directly, but the EMI amount and remaining tenure (derived from the commencement date of the NACH debit) allow an estimate of the residual principal under each loan.

What the Synthetic Balance Sheet Cannot Cover

Balance Sheet ItemWhy Bank Data Cannot Approximate ItAlternative Documentation
Fixed assets (gross block)Capital expenditures are indistinguishable from large vendor payments or advances without invoicesCA certificate, GST invoice copies, asset registration
Depreciation and net blockNon-cash item; no bank entryTax computation schedule (ITR)
InventoryInventory holding creates no bank entry until purchased or soldPhysical stock statement, GST returns for goods
Equity / owner’s capitalRequires complete asset minus liability pictureAudited accounts or CA-prepared statement
Contingent liabilitiesOff-balance-sheet commitments leave no bank recordLegal agreements, bank guarantees
Long-term investmentsInvestment transactions resemble any other outflowInvestment account statements

India-Specific Context: Priority Sector Lending and Working Capital Assessment

RBI’s Priority Sector Lending guidelines require banks to report MSME loan portfolios, and PSB (public sector bank) lending to MSMEs is evaluated against targets under the MSME Act. For this segment, the RBI has explicitly recognised bank statement analysis as a viable underwriting method in its Digital Lending Guidelines, which require lenders to use documented, verifiable data sources — a standard that bank-statement-derived synthetic balance sheets can meet when the methodology is recorded.

The GST return archive (GSTR-1, GSTR-3B) provides a complementary current liability check for GST-registered MSMEs. The net GST liability payable on the last filing date, if not yet settled to the bank, represents a current liability not visible in the bank statement. For businesses that file GST quarterly (the composition scheme), the accrued GST can be a significant current liability item that the synthetic balance sheet would otherwise miss.

The bank statement analytics module constructs the synthetic balance sheet as the third layer of TransactIQ’s four-layer MSME synthetic financials output. The bank statement analysis platform overview describes how the four layers integrate to produce a complete decisioning package for NBFC credit teams.

The most common questions about synthetic balance sheet limitations and credit application are answered in the FAQ section below.

Primary reference: RBI Digital Lending Guidelines — RBI's 2022 guidelines on digital lending that define permissible income documentation methods and data use requirements for regulated lenders.

Frequently Asked Questions

Which balance sheet items can be reliably approximated from a bank statement?
Cash and bank balances are directly observable — the closing balance on the analysis date is exact. Working capital can be approximated as the net of average business inflows (receivables proxy) minus average business outflows (payables proxy) over a 3-to-6-month window. Trade receivables outstanding can be proxied by the gap between when invoiced counterparties typically pay versus the standard credit period for the industry. Current liabilities can be estimated from known NACH mandate amounts and recurring vendor payment obligations visible in the statement.
Why can fixed assets not be approximated from a bank statement?
Fixed asset values require valuation at cost or fair value, plus accumulated depreciation — none of which appear in cash transaction data. A large one-time outflow may represent a machinery purchase, a security deposit, a property advance, or a large vendor payment for inventory. Without supporting documentation (invoice, registration certificate, asset schedule), the transaction cannot be confirmed as a capital expenditure, let alone valued. As a result, gross block, net block, and capital work-in-progress are excluded from synthetic balance sheets.
How does RBI Digital Lending Guidance affect the use of synthetic balance sheets in credit decisions?
RBI's Digital Lending Guidelines require lenders to use verifiable, documented data sources and to maintain a clear audit trail of the underwriting decision. A synthetic balance sheet derived from bank statement data satisfies the verifiable source requirement — the underlying data is a bank-issued document. However, lenders must document their methodology, disclose its use in the credit assessment to the borrower, and ensure the synthetic data is not misrepresented as auditor-certified. Regulated entities (NBFCs, banks) may also face internal policy requirements on minimum documentation that go beyond the RBI minimum.
What is the receivables proxy in a synthetic balance sheet and how accurate is it?
The receivables proxy estimates trade receivables outstanding by analysing the payment lag pattern for recurring business counterparties. If a counterparty consistently pays 30–45 days after the expected payment date (based on payment frequency analysis), the month-end receivable from that counterparty can be approximated as one month's average receipt. For trading MSMEs with 10–30 regular customers, this proxy tends to be directionally correct within 15–25% of the actual outstanding. It degrades in accuracy for businesses with irregular payment terms or where customers pay via multiple instruments.
Can a synthetic balance sheet be used to calculate net worth for MSME lending?
Net worth (equity) cannot be directly computed from a bank statement because it requires the total asset base minus total liabilities — and the bank statement covers neither fixed assets nor all external liabilities (undisclosed borrowings, guarantees, contingent liabilities). What can be approximated is a liquidity-adjusted working capital net position: current assets (cash + receivables proxy) minus current liabilities (NACH obligations + identified payables). Some lenders use this as a proxy for working capital net worth, clearly labelling it as a bank-data-derived estimate rather than a certified balance sheet figure.

See how TransactIG handles reconciliation for your industry

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