Workspace
Bank statement converter
Turn bank statements into Excel workbooks you can check - one file, or every client's files at once, sorted into client and account sections. Every row is proved against the statement's own running balance and printed totals, and anything that cannot be proved is shown to you at the row, not hidden.
Your statements are read inside this browser tab. They are never uploaded: this page's security policy blocks it from sending data to any server.
Your own label, used to keep each client's statements in a section of their own. Leave it blank and name them afterwards. The label is yours - never taken from a statement - and stays in this tab.
Reading. Drop other files here to read them instead, or cancel below.
Or paste a table to check it
Paste a statement table copied from anywhere - Excel, another converter, an AI chat - with its heading row. Every row is checked against the running balance here, the same as a file, and anything that does not add up is shown at its row. Nothing is uploaded.
Reading…
- where the text sits and the column headings, with every other letter and digit replaced - to email to support@caprotoolkit.in if you want this bank's layout supported. Nothing is sent from this page, and the file's own name is not in it.
Long digit runs in the file name are hidden on screen, keeping only the last four, in case they are an account number; the downloads use the same masked name.
- the name, address, PAN, mobile and full account number printed on the statement. Left out unless you tick this.
Files in this account
Summary
Printed on the statement
Problems found
Could not be proved
How it was read
Checks
| ID | Check | Result | Detail |
|---|
Transactions
| # | Date | Narration | Reference | Debit | Credit | Balance |
|---|
Problem found at this row Could not be provedSelect a marked row number to see why.
Insights
Every figure here is a traced calculation over the rows the tool proved. Balance figures say Not available when the statement did not prove its balances.
Month by month
Credits and debits per calendar month. Opening, closing, minimum, maximum and the average balance are shown only when the statement proved its balances; the average counts every day of the month, carried from the month's opening balance.
| Month | Credits | Count | Debits | Count | Opening | Closing | Minimum | Maximum | Average (daily, calendar month) |
|---|
Points to check
Raised from the rows only, with the rule, the Act and section in force on the transaction date, the threshold and its source. Statutory wording needs your firm's review before it reaches a client.
Channels and counterparties
Lender pack
Prepared for review - not signed off. It supports a loan file; it is not a certificate.
| # | Narration | Channel | Counterparty | Ledger (type one, or tick the suggestion) |
|---|
Tally import file
Nothing is posted to Tally. This writes an XML file you review and import yourself (Gateway of Tally → Import). Only rows with an accepted ledger are included.
Client rules
Rules belong to the client this account is filed under, and live only in this tab until you save them as a JSON file. Nothing is stored on this machine or anywhere else.
Bank reconciliation statement Prepared for review - not signed off
| Line | Amount | Entries |
|---|
Video guide
How to use the converter, step by step
A fictional bank's PDF statement dropped in, checked and downloaded as Excel - then two clients at once. Press a step to play the video from there. 1:47, narrated, with captions.
The steps
Before you trust it
What it does, and what it does not
-
Reads
- Statements from any bank, laid out any way, as long as the file contains real text: the PDF you download from net banking, or an Excel (.xlsx or the older .xls), CSV or web-page export.
- Password-protected PDFs, once you type the password.
- Separate Debit and Credit columns, a single Amount column with Dr/Cr, or signed amounts; oldest-first or newest-first; narration that wraps over several lines; statements running to hundreds of pages.
- Everything else the statement prints: extra columns such as cheque number, value date or branch, and the details above the table. They are kept in the download.
- Many files at once: months of one account joined into one period, several accounts, several clients - each sorted into its own section.
-
Proves
- Each row against the previous balance: previous balance, minus the debit, plus the credit, must equal the printed balance, to the paisa.
- The rows against the statement's own printed totals, counts and closing balance, where it prints them.
- That monthly statements join: each one opens where the last one closed, and every gap, overlap or break is shown.
- Amounts as exact paise; dates as day-first. Nothing is rounded, re-signed, merged or sorted inside a statement.
-
Does not
- Read scanned or photographed statements. A picture of a page has no text to read, and guessing digits is how wrong figures reach a client.
- Guess. A value it cannot read, a sign it cannot prove, or a balance that does not agree is reported at the row, and the result is Failed - not reconciled.
- Send your statements anywhere, or write the holder's name, address or PAN into a download unless you tick "Include holder details".