About this tool

Private Bank Statement Analyzer

Map and analyse CSV bank-statement transactions locally with deterministic categories, aggregate summaries, and cautious review signals.

The Private Bank Statement Analyzer reads a CSV, TSV or delimited bank-statement export in your browser, maps its columns to date, description and debit/credit (or a single signed amount), then classifies every transaction with a fixed keyword rulebook and totals inflow, outflow and net movement by category and by month. The rulebook is deterministic — 15 spending categories from Housing and Groceries through Transport, Utilities, Subscriptions, Bank fees, Transfers and Insurance & tax, plus an Income bucket for salary, pension, dividend, refund, cashback and reimbursement credits — so the same file always produces the same figures. It is built for anyone who wants a spend breakdown without handing their statement to a budgeting service.

How to use Private Bank Statement Analyzer

1. 1

   Open Private Bank Statement Analyzer on AltFTool — it loads instantly in your browser.

2. 2

   Paste the rows or press Choose text file for a CSV, TSV or .txt export up to 10 MB and 25,000 rows, then press Parse locally.

3. 3

   Confirm the Date, Description, Debit / money out and Credit / money in mappings, pick DD/MM/YYYY or MM/DD/YYYY, then press Analyze in memory.

4. 4

   Money in, money out and net movement appear with outflow by category and month; Download summary saves private-statement-aggregate-summary.csv.

Why use Private Bank Statement Analyzer

• Maps any bank's column names

  Header hints recognise narration, particulars, withdrawal, paid out, money in and a dozen other variants, and you can override every mapping by hand.

• Understands messy money columns

  Parentheses, trailing Dr/Cr suffixes, currency symbols and thousands separators all parse to the right sign instead of being dropped.

• Flags rows for review, not verdicts

  Duplicate groups, oversized outflows and higher-spend months are surfaced with the threshold that triggered them so you can check the original statement.

Common use cases

• You are applying for a loan and want to see, before the lender does, how your last six months split between rent, EMIs, transfers and discretionary spend.
• You suspect a subscription was billed twice and need the rows that share the same date, description and amount pulled out of a thousand-line export.
• A freelancer reconciling the year totals income credits against outflow categories to hand a clean summary to their accountant.

Frequently asked questions