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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

How many sheets are in a FinAnalyser Universal BSA Excel workbook?

The institutional Universal BSA pack is 28 sheets generated with ExcelJS in TypeScript — Overview, Summary, All Txns, Cashflow, bounce ledgers, EMI/loan, salary, monthly summary, daily balance and related underwriting tabs. It is not a flat CSV dump of merged PDF text.

Does FinAnalyser invent amounts when bank statement rows are missing?

No. FinAnalyser does not invent mega amounts from page-break or missing-row gaps. When continuity is ambiguous it prefers the printed amount and type; running Balance is always the rightmost monetary token on the CBS row, never picked by distance to the header.

FinAnalyser

Underwriter handbook · Canonical guide

How to Calculate FOIR (Fixed Obligation to Income Ratio) for Salaried Loans: Underwriter Handbook

This page is the practical FOIR reference for Indian salaried personal-loan desks — formula, caps, what to deduct, and how FinAnalyser automates the ratio from bank statements. Open the free FOIR calculator.

Complete FOIR formula

FOIR % = (Total monthly fixed obligations ÷ Net monthly income) × 100

Net monthly income — prefer verified salary (CMS/NEFT payroll), not informal UPI/cash credits.
Fixed obligations — EMIs and contractual loan outgoes visible on the statement (and bureau, when merged in policy).
Proposed EMI — many desks compute FOIR including the new loan EMI: (Existing EMIs + Proposed EMI) ÷ Income.

Standard bank / NBFC FOIR caps

Segment	Typical FOIR band
Prime salaried (MNC / PSU)	Up to ~60%–65%
Standard salaried	Up to ~55%–60%
Near-prime / thin bureau	Often capped ~50%
FinAnalyser desk alert	>50% flagged high-risk

Caps vary by lender policy — treat 50%–65% as the common Indian retail band, not a regulatory hard limit.

Institutional EMI deduction table

What underwriters typically include when scanning the bank statement for fixed obligations:

Obligation type	Treatment
Bajaj Finance / Tata Capital / Piramal	Count full EMI as fixed obligation
Home loan / LAP (HDFC, SBI, ICICI, etc.)	Count EMI; verify continuity across months
Credit card EMI / loan on card	Count converted EMI; ignore revolving minimum if policy excludes it
Gold loan interest-only	Count contractual monthly outgo per policy
Payday / BNPL (CASHe, mPokket, Ring, Kissht)	Count + raise distress flag (not just FOIR maths)
Insurance / SIP / mutual fund SI	Usually exclude from FOIR unless policy treats as fixed obligation

How FinAnalyser automates FOIR

Detects true corporate salary (CMS/NEFT payroll) and filters fake UPI/cash inflation.
Sums recurring institutional EMI / loan debits (25+ NBFC and bank patterns).
Computes FOIR% and raises a high-risk flag when FOIR exceeds ~50%.
Surfaces payday-app distress (CASHe, mPokket, Ring, Kissht) alongside the ratio.

From ₹10/statement · 3 free analyses

FAQs

What is FOIR in personal loan underwriting?

FOIR (Fixed Obligation to Income Ratio) measures how much of a borrower’s verified monthly income is already committed to EMIs and fixed obligations. Lenders use it to size affordable personal loan instalments.

What FOIR cap do Indian banks and NBFCs typically use?

Many retail desks use ~50% as a high-risk alert; product policies often allow 50%–65% depending on segment, bureau score, and employer quality. Always follow your credit policy.

How does FinAnalyser automate FOIR from bank statements?

FinAnalyser detects corporate CMS/NEFT salary credits, sums institutional EMI / loan obligations from the ledger, computes FOIR%, and flags files above ~50% — across 45+ Indian bank parsers.