PDF bank statement to Excel, without uploading the statement
Greenote reads bank statement PDFs from 100+ Indian banks on your own Windows PC and exports a formatted Excel workbook. Not one flat table: categories, party names, daily balances and summaries, already worked out.
Free trial: 7 days or 5 statements, no card. PDF, Excel and CSV statements.
What the Excel file actually contains
A generic PDF to Excel tool gives you the table that was on the page, and then the work starts. Greenote is built for the work that comes after, so the workbook arrives with the classification already done.
| Sheet | What is on it |
|---|---|
| Statement Info | Client, bank and period, so the file is self-describing months later. |
| Category Summary | Every transaction totalled by what it was. |
| Party Ledger | Totals by who the transaction was with, read out of the narration. |
| All Entries | The full ledger: date, narration, debit, credit, balance, category, party. |
| Daily Balance | End-of-day balance for every day in the period. |
| Monthly Summary | Inflow, outflow and closing position per month. |
| Receipts & Inflows | Money in, separated out. |
| Key Payments | The outflows that matter, split from the noise. |
| Other Payments | The remaining outflows. |
| Own Transfers In / Out | Self-transfers isolated, so they stop inflating turnover. |
| Loan EMIs | Instalments identified as a group. |
| Cash Withdrawals / Deposits | Cash movement on its own sheets. |
| Investment | Investment-related movement. |
| Dividend & Interest Income | Income credits separated for the return. |
| Refund & Reversals | Reversals, which otherwise double-count. |
| Unclassified Credits / Debits | What Greenote would not guess at. Shown, never hidden. |
| Payment & Receipt Voucher | The rows shaped ready for posting. |
Every row on the party ledger carries how the name was arrived at, so a figure you doubt can be traced back rather than taken on trust. The unclassified buckets stay on the sheet on purpose: hiding them would make the totals look tidier and stop them reconciling.
The party sheet is the one most people open first. What a party-wise ledger shows, and why an audit starts there.
Why most converters get Indian statements wrong
Converting a PDF table to a spreadsheet is easy when the PDF is a clean ruled grid. Indian bank statements frequently are not, and these are the specific things that break a generic tool.
- 1
One transaction printed across several lines, with the narration continuing onto rows that carry no date. Read line by line, one transaction becomes four fragments.
- 2
A single amount column with the direction carried as a Cr or Dr suffix, sometimes with no separating space, instead of separate debit and credit columns. Split it wrongly and every credit becomes a debit.
- 3
No ruled lines at all, so columns have to be reconstructed from where the text sits on the page rather than detected.
- 4
Date formats that defeat a single pattern: spelled-out months, two-digit years, no separators, and in one co-operative bank a Unicode minus sign that looks exactly like a hyphen and matches nothing.
- 5
Header blocks reprinted on every page, which end up inside the data as rows that are not transactions.
Greenote handles these per bank rather than generically. Each bank page sets out that bank's real column layout, date format and quirks.
The reason not to use a free online converter
A bank statement carries the account number, the balance, every counterparty, the salary and the loan repayments. It is close to the most sensitive document a client will hand you, and uploading it to a free website means agreeing to that site's retention and training terms on your client's behalf, usually without reading them and certainly without asking the client.
Greenote converts on your machine. There is no upload, no retention period and no third-party copy, so the answer to “where did my statement go” stays inside your office.
Which files work, and which do not
Works
- Text PDFs downloaded from net banking
- Password-protected PDFs, once you have the password
- Excel and CSV statements
- Multi-page statements of any length
Does not work
- Scanned printouts
- Photographs of a statement
- Anything where you cannot select the text
Greenote reads a scan on your own PC, in beta, and marks every row whose running balance does not add up, rather than handing back numbers that look confident but were guessed. How to tell a text PDF from a scan in three seconds.
And when you want it in Tally
Plenty of people only ever want the spreadsheet, and that is a complete use of Greenote. If the destination is Tally, the same data posts as vouchers without a second conversion: all 8 voucher types, GST handled, Tally Prime and ERP 9, with the counterparty bound to a ledger that already exists in the company rather than a new one invented for it.
Convert a statement from your bank
Bank statement to Excel: common questions
- Can Greenote convert a bank statement PDF to Excel?
- Yes. Greenote reads bank statement PDFs, and also Excel and CSV statements, and exports a formatted .xlsx workbook. The conversion runs on your own Windows PC, so the statement is not uploaded.
- Is it just a PDF to Excel converter?
- The Excel export is the part most people ask for, so it is worth being clear about what comes out. It is not one flat table. The workbook contains the full transaction ledger plus a category summary, a party ledger built from the narration, daily and monthly balances, and separated sheets for cash, transfers, EMIs and income. Greenote can also post the same data into Tally as vouchers, which is a separate step you do not have to use.
- Do I have to upload the statement anywhere?
- No. Greenote is Windows desktop software and the conversion happens on your machine. Converting it does not send the file to Greenote or to anyone else. That is the whole point of it being desktop software rather than a website: the statement stays with your firm, so your firm can tell a client exactly who holds it.
- Which file types work?
- Text PDFs, Excel and CSV all work, exactly. A scanned PDF works too, in beta: it is read on your own PC, takes a few minutes, and rows whose running balance does not add up are marked for you to check. A scan holds only a picture of the text, so the statement downloaded from net banking is still the quicker and surer file.
- Which banks are supported?
- Greenote supports 100+ Indian banks: public sector, private, foreign and co-operative. It reads the statement structure rather than looking for a logo, so a text PDF, Excel or CSV statement from a bank not named anywhere on this site works too.
- Does the Excel keep the running balance and the full narration?
- Yes. Multi-line narrations are reassembled into a single cell, the debit and credit split is preserved even where the bank prints one amount column with a Cr or Dr marker, and the running balance is carried through so the file can be checked against the statement.
And the rest of the year
Greenote does more than making an Excel workbook
It is one piece of software for a practice, in 57 features: bank statements into Tally, month-end and year-end, GST returns, TDS, tax audit, income tax, company law and your practice. Bills and e-invoices into Tally, the bank reconciliation, GSTR-1, 2B, 3B and 9, missed TDS and 26AS, the cash and MSME checks and the tax audit papers, capital gains, the computation sheet, advance tax and the Return (ITR), the final accounts, and the clients, tasks, fees, documents and notices of the office. Plans carry different parts of it.