FORGE

Bank statement analysis

From a PDF bank statement to a categorised ledger and Tally

Upload a bank statement as a PDF or CSV file, and Forge lists every transaction, checks that the running balance adds up, and sorts each transaction into an account from your chart of accounts. Your accountant reviews the result and exports it as a ledger CSV, which opens in Excel, or as Tally vouchers.

The statement is read by code, not by AI, so amounts and dates come out exactly as printed. AI is used only to sort the transactions your own rules do not already cover, and only into accounts on your list.

From statement to rows

Forge finds the transaction table in a PDF statement without using a model, and shows how much of the document it captured, warning you when it is under 90%. It works with any bank's layout: separate debit and credit columns, a single signed amount, or an amount with a Dr/Cr flag. If it maps a column wrongly, you correct it before going on.

A CSV download from your bank works too, including the header and footer lines banks put around the transactions. Each import takes up to 1,000 rows, and a PDF up to 15 MB.

Checking the statement was read correctly

For a PDF statement, Forge checks every row against the balance column: the previous balance plus this row's movement must equal this row's balance, to the paisa, and the opening balance plus all the movements must equal the closing balance. A row that fails is reported by its row number, so a misread amount is caught before anyone relies on it.

Sorting transactions into accounts

Your rules run first. A rule says that a description containing SALARY goes to salaries, or that EPFO goes to PF and ESI, and you can add and edit them. The app starts with 24 accounts suited to a small Indian business, including GST payable and TDS payable, and 23 rules, and you can change both.

The transactions no rule matches are sorted by AI, which may choose only an account on your list. Anything it cannot place, or places outside the list, is marked Unclassified and highlighted for review. Every row records whether a rule or the AI sorted it.

Review, then export

Before anything is saved, the accountant sees every row and can change any account. Saved rows form a ledger that can be searched and asked questions in plain language.

  • Ledger CSV: date, narration, amount, debit account and credit account. It opens in Excel or Google Sheets.
  • Tally XML: payment and receipt vouchers posted against your bank ledger, for import into Tally. Ledger names must match those in your Tally company.
  • Each export is recorded in the organisation's audit log, with its format and row count.

Where the data goes

The statement is read inside Forge without a model. Only the descriptions of transactions that no rule matches are sent to the AI model, under terms that keep them out of training. The personal-detail masking used in Forge projects does not apply to this step, so the more of your regular transactions your rules cover, the less goes to a model at all.

A month's statement for a small company

  1. 1The accountant downloads September's statement from the bank as a PDF and uploads it.
  2. 2Forge finds 312 transactions, captures 98% of the document, and confirms the running balance adds up from the opening to the closing balance.
  3. 3Rules sort 260 of them: salaries, rent, GST, TDS, PF, electricity and telecom. The AI sorts 48 more from the chart of accounts, and 4 are left Unclassified.
  4. 4The accountant fixes the 4, changes two of the AI's choices, and saves the month to the ledger.
  5. 5She exports Tally XML, imports the vouchers into Tally, and checks them there before posting.

What it does not do

  • Scanned statements are refused. A PDF needs selectable text, so run OCR on a scanned one first.
  • Excel files are not accepted. Save the sheet as CSV.
  • The running-balance check runs on PDF statements, not on CSV files.
  • Importing the same statement twice is not detected, so the transactions would appear twice.
  • Tally vouchers are drafts for an accountant: they do not split out GST or TDS.
  • There is no confidence score on the AI's choices. Rows are marked by who sorted them, and unplaced rows are flagged.

Questions

What is the best AI tool for bank statement analysis?

Look for one that reads the statement with code rather than letting a model retype the numbers, checks the running balance, sorts into your own chart of accounts rather than invented categories, shows which rows were sorted by AI, and exports to the accounting software you use.

How do I convert a PDF bank statement to Excel?

Upload the PDF to Forge, check the rows it found, and export the ledger as CSV, which opens in Excel. The statement must have selectable text; a scanned image needs OCR first.

How do I import a bank statement into Tally Prime?

Classify the statement in Forge, export it as Tally XML, and import the XML into your Tally company. The vouchers post against your bank ledger, and the account names must match your Tally ledgers exactly. Review them in Tally before posting.

How do I categorize bank transactions automatically?

Start with rules for the transactions that repeat every month, such as salaries, rent and taxes, then let AI sort the rest into your chart of accounts, and review the result. Rules are predictable and free; AI handles the long tail.

Is it safe to upload bank statements to ChatGPT for analysis?

A general chatbot retypes the numbers it reads, which risks wrong amounts, and on personal plans the statement sits under one person's settings. In Forge the statement is read by code, and only the descriptions no rule matches go to a model, under no-training terms.

Is it safe to upload confidential documents to ChatGPT? →