Statement2Ledger · Free beta

Convert a bank statement PDF to Excel

Turn your bank’s PDF statement into a spreadsheet with real dates, amounts you can add up and a summary of the balances. Free, no sign-up, and the PDF never leaves your device.

Beta: works with most text-based bank PDFs; always check the badge — amber or red means compare with your statement.

Converter

Drop your bank statement PDFs hereDrop more PDFs here

or

Text-based PDFs from most banks. You can add several statements at once.

Your statement never leaves your device. Conversion happens in your browser; you can even disconnect from the internet after the page loads. (Only a PDF with Chinese, Japanese or Korean text may need a font table from newellabs.com; that request carries nothing from your file.)

Excel workbook or CSV?

The Excel workbook compared with the CSV file
Excel (.xlsx)CSV
DatesReal dates: sort and filter work, the format is only how they lookText that the spreadsheet reads with your computer’s regional settings
AmountsNumbers with thousands separatorsPlain numbers, no separators
ExtrasBold header row that stays in view, filter buttons, and a Summary sheetNone: one plain table
Opens inExcel, Google Sheets, Numbers, LibreOfficeEvery spreadsheet, plus databases and scripts

What’s in the file

Columns

  • One signed Amount column: Date, Description, Amount, Balance, Reference. Money out is negative.
  • Separate Debit and Credit columns: Date, Description, Debit, Credit, Balance, Reference. Both are positive numbers.
  • A Value date column is added at the end when the statement prints a second date on each row.

Currencies with three decimals (Bahraini or Kuwaiti dinars, for example) keep all three.

The Summary sheet (Excel only)

Bank, account, currency and period; the opening balance, money in, money out and net change; the closing balance printed on the statement next to the one the rows add up to, and the difference; the result of the balance check and the number of transactions.

It is the same check as the badge above the table, saved with the file for whoever opens it next.

Date formats

Choose 2025-03-31, 31/03/2025 or 03/31/2025 under Export. In the Excel file the dates are real dates, so this only sets how they look. In a CSV they are text, and Excel reads them with your computer’s regional settings: 03/04/2025 can become 3 April or March 4. For a CSV, YYYY-MM-DD is the safe choice.

Safe to open: no formulas from a PDF

A spreadsheet treats text that starts with =, +, - or @ as a formula. A description on a statement could start that way, by accident or on purpose (“CSV injection”). So the converter puts an apostrophe in front of such descriptions and references in the CSV, as OWASP recommends, and stores them as text in the Excel file. Nothing taken from a PDF can run as a formula. Amounts and balances are plain numbers and are never changed.

Everything in one column?

The CSV separates columns with commas. In countries that write decimals with a comma, Excel may expect semicolons and put each line in a single cell. Open the Excel file instead, or in Excel use Data › From Text/CSV and choose Comma as the delimiter.

The CSV is UTF-8 with a byte-order mark, so Excel reads accents and other scripts (Urdu, Arabic, Chinese) correctly. Both files keep such text exactly as the PDF stores it. Right-to-left text such as Urdu can come out of some PDFs in the wrong order, so check it in the preview first.

Frequently asked questions

Excel puts everything in one column. What do I do?

Your Excel probably expects semicolons, which is common where decimals are written with a comma. Open the Excel (.xlsx) file instead, or use Data, From Text/CSV in Excel and choose Comma as the delimiter.

Why does a description start with an apostrophe?

A description that starts with =, +, - or @ could run as a formula when the CSV is opened. The converter puts an apostrophe in front so it stays plain text. You can delete the apostrophe if you need the exact original text.

Excel swapped the day and month in my dates. Why?

A CSV stores dates as text, and Excel reads them with your computer’s regional settings. Export the CSV with the YYYY-MM-DD date format, or use the Excel file, where dates are real dates.

Does it work with Google Sheets and Numbers?

Yes. Both open the Excel workbook and the CSV. In Google Sheets, use File, Import and upload the file.

Can I get debits and credits in separate columns?

Yes. Under Export, choose Separate Debit and Credit columns before you download. Both are then positive numbers, and the Balance column stays as printed.