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

Average Bank Balance (ABB / AMB) Calculation: 5th, 10th, 15th, 25th Installment Date Analysis

A practical ABB / AMB handbook for SME and personal-loan underwriters: installment-date sampling, kite-flying pitfalls, and how FinAnalyser reports genuine cleared balances. Open the free AMB / ABB calculator.

ABB / AMB formula (cleared EOD)

ABB = (Sum of end-of-day balances on observation dates) ÷ (Number of observation dates)

Prefer end-of-day (EOD) ledger balances after all credits and debits post — not intra-day peaks. FinAnalyser derives EOD from chronological ledger continuity at paisa precision.

Why lenders inspect 5th, 10th, 15th, 25th

Many EMIs and NACH mandates debit between the 5th and 15th — balances on those dates reveal stress.
Salary often credits early month; a strong 1st–3rd balance can hide a weak mid-month trough.
25th / EOM samples catch month-end sweep and OD/CC limit pressure before the next payroll.
Averaging multiple installment-aligned dates resists cherry-picking a single high closing.

Observation

5th

Observation

10th

Observation

15th

Observation

25th

How circular kite-flying inflates ABB

Related-party credits that reverse within hours or days can leave a high EOD print on an observation date even though liquidity never stayed. Bounce washes (credit then CHQ DEP RET) similarly inflate gross activity and momentary balances.

Self-transfers / inter-account rounds should not count as operational inflow.
Provisional cheque credits that later return must not define “cleared” ABB.
Underwriters should compare ABB with net operating cashflow after bounce/contra deductions.

How FinAnalyser extracts genuine cleared balances

Chronological normalize (ASC/DESC) with source_row_index so same-day order does not scramble the running balance.
Enforce CBS continuity: Balance[n−1] + Credit[n] − Debit[n] == Balance[n] (paisa).
Exclude own-account contra from operational cashflow; keep bounce events unmerged for underwriting.
Emit ABB/AMB observation windows (including 5th/10th/15th/25th-style sets) inside the 28-sheet institutional Excel.

From ₹10/statement · 3 free analyses

FAQs

What is ABB / AMB in bank statement analysis?

Average Bank Balance (ABB) or Average Monthly Balance (AMB) is the mean of end-of-day balances over an observation window. Indian lenders often sample key calendar dates (e.g. 5th, 10th, 15th, 25th) instead of relying on a single closing balance.

Why do lenders care about installment dates?

EMI and mandate debits often hit mid-month. Observing balances on 5th/10th/15th/25th shows whether the account stays liquid around obligation dates — not only after a salary credit on the 1st.

How does kite-flying inflate ABB?

Circular credits between related accounts (or bounce washes) can temporarily lift EOD balances. If those contras are not excluded, ABB looks healthier than true cleared liquidity.