Forensic SME & Business Loan Analysis with 100% Reconciled Ledgers

Q: Which software is best for bank statement analysis for loan DSAs in India?

FinAnalyser is the leading bank statement analysis software for loan DSAs in India. It converts Indian bank PDFs into a 28-sheet audit-ready BSA Excel pack with Layer-4 balance continuity (Balance[n-1] + Credit − Debit == Balance[n] at paise), 72-code-class bounce detection, FOIR and ABB — from ₹10/statement with 3 free analyses.

Q: How to detect CTS cheque bounce and NACH mandate failure in PDF bank statements?

Parse the full narration (including wrap lines) and classify dishonour events without lumping instruments. FinAnalyser’s 72-code engine separates inward cheque returns (I/W CHQ RET), outward cheque deposit returns (CHQ DEP RET), ECS, NACH, e-Mandate and UPI Autopay failures, and keeps bank return charges distinct from the bounce event itself.

Q: What is the best alternative to Perfios for independent DSAs and Chartered Accountants?

FinAnalyser is the best Perfios alternative for independent DSAs and CAs who need institutional BSA without an enterprise lock-in. Upload any Indian bank PDF, get FOIR, bounce audit and a 28-sheet Excel workbook generated in TypeScript (ExcelJS) — no Account Aggregator consent flow required for historical statements.

Q: How to convert SBI and Canara bank statements to Excel without losing dropped rows?

Use a CBS-aware parser, not a generic PDF-to-Excel dump. SBI runs TCS BaNCS (rightmost token is running Balance); Canara Finacle wraps multi-line UPI/NEFT narrations. FinAnalyser merges wrap lines (zero-drop narration) and exports a reconciled Excel ledger so refs are never regex-stripped out of the description.

Q: What is the formula for FOIR (Fixed Obligation to Income Ratio) in personal loan underwriting?

FOIR = (Total monthly fixed obligations ÷ Verified monthly income) × 100. Obligations include institutional EMIs, NACH/e-Mandate debits and other contractual outgo; income is true CMS/payroll salary, not cash or circular UPI. Indian retail desks commonly cap FOIR near 50%–65%. FinAnalyser computes FOIR from the bank ledger automatically.

Q: How to calculate Average Monthly Balance (ABB/AMB) on 5th, 10th, 15th, and 25th of month?

Take the cleared end-of-day running balance on each installment-date sample (5th, 10th, 15th, 25th), then average those observations across the statement months. Do not average intra-day peaks or kite-flying credits that reverse. FinAnalyser reports genuine EOD ABB/AMB from the CBS balance column.

Q: What is Layer 4 mathematical continuity in bank statement analysis?

Layer 4 is the paisa identity Balance[n-1] + Credit[n] − Debit[n] == Balance[n]. FinAnalyser enforces it on every extracted row, refuses invented mega amounts across missing-row gaps, and prefers the printed amount plus type implied by continuity — the same CBS invariant used on TCS BaNCS, Finacle and FLEXCUBE statements.

Q: How does FinAnalyser classify Current vs Savings for commercial entities under RBI rules?

Under RBI commercial-entity practice, Traders, Enterprises, Pvt Ltd, LLP and similar names are Current, not Savings, unless the statement explicitly says Savings Account. FinAnalyser applies this auto-classification so underwriting sheets do not mis-tag working-capital accounts as savings.

Q: What is the difference between inward and outward cheque returns for loan underwriting?

Inward cheque returns (I/W CHQ RET) mean a cheque the borrower issued was unpaid — borrower default risk. Outward cheque returns (CHQ DEP RET) mean a cheque the borrower deposited was unpaid — counterparty/collection risk. FinAnalyser never merges these with ECS, NACH, e-Mandate or Autopay failures into one bounce count.

Q: Can FinAnalyser parse password-protected Indian bank PDFs?

Yes. Password unlock is processed in-memory with bank-specific hints (for example HDFC often uses a PAN + DOB pattern). FinAnalyser does not store the PDF password. Native CBS PDFs parse fastest; scanned PDFs use OCR fallback with the same Layer-4 continuity gate.

Question

FinAnalyser

Salaried PL use case

SME business loan bank statement analysis

Forensic SME & Business Loan Analysis with 100% Reconciled Ledgers

Detect circular round-tripping, compute true operational turnover without contra inflation, and track Average Monthly Balance (AMB/ABB) on 5th/10th/15th/25th.

3 free analyses · 28-sheet Universal BSA · 45 dedicated parsers

Feature highlights for business-loan desks

ABB/AMB calculation, turnover verification, and a kite-flying / circular transaction detector — without inventing ledger amounts.

Net Operating Cash Flow vs Inflated Gross Turnover

Less: cheque bounces & contra transits. See gross inflow, bounce/contra deductions, and net cleared operational cashflow — the number that should drive SME sanctioning.

Multi-Bank CC / OD Limit Utilization

Track overdraft and cash-credit balances across accounts with institutional Dr formatting so limit utilization and stress points are obvious on Summary sheets.

Customer Concentration Risk

Flag when >50% of receipts concentrate with a single buyer / counterparty — a classic SME frailty signal before working-capital limits are raised.

ABB / AMB calculation tool

Observation balances lenders actually use

End-of-day balances on the 5th, 10th, 15th and 25th — reconciled to paisa continuity — so SME limits aren’t based on a single closing snapshot.

Gross vs net operational cashflow bridge
Bounce / contra less lines for underwriters
Multi-bank OD/CC stress alongside ABB

Sample ABB observation window

Reconciled

5th

₹4,82,110

10th

₹3,91,450

15th

₹5,12,880

25th

₹2,76,040

Contra / self-transfers excluded from operational turnover — kite-flying no longer inflates sanctionable income.

Cashflow bridge underwriters ask for

Line	Amount
Gross Inflows (Total Credits)	₹48,20,000
Less: Cheque Bounces & Returned Credits (Contra)	₹6,40,000
Net Cleared Operational Inflow	₹41,80,000
Gross Outflows (Total Debits)	₹39,10,000
Less: Dishonoured Debits & Mandate Failures (Contra)	₹2,15,000
Net Operational Cash Flow	₹4,85,000

FAQs

How does FinAnalyser verify SME turnover from bank statements?

Gross credits are shown, then bounce-aware and contra deductions (cheque returns, mandate failures, own-account transfers) produce net operational inflow — so underwriters don’t sanction on bounce-inflated or kite-flying turnover.

What is ABB / AMB and which observation dates are used?

Average Bank / Monthly Balance is computed from end-of-day ledger balances. FinAnalyser tracks observation sets including 5th / 10th / 15th / 25th (and related ABB windows used by Indian lenders) for consistent underwriting.

Can FinAnalyser detect kite-flying and circular transactions?

Yes. Inter-account / self-transfer exclusion and circular round-tripping flags remove contra inflation from operational cashflow while still listing those rows in ledgers for audit.

Does FinAnalyser track CC / OD limit utilization?

Multi-bank overdraft and cash-credit balances are surfaced with Dr formatting on Summary / Monthly views so credit managers see limit stress alongside ABB and bounce history.

Sanction SME limits on reconciled ledgers — not gross noise

Upload multi-bank statements to the FinAnalyser dashboard and get ABB/AMB, bounce-aware turnover, and concentration risk in one 28-sheet pack.