Statement2Sheet

Bank statement PDF to CSV

Convert a text-based statement PDF into transaction rows, review the result, then choose separate Debit/Credit columns or one signed Amount column. CSV is a plain-text export; it does not include the Excel workbook's Summary sheet or review formatting.

By Statement2Sheet · Updated

Upload a statementLimits and pricing

Choose a layout for your destination

The default split layout keeps outgoing amounts in Debit and incoming amounts in Credit. For a chequing or savings statement, a deposit of 50.00 and a purchase of 20.00 appear on separate sides. This is useful when you want to compare the exported columns with the original PDF.

Synthetic example — invented transactions, no customer or account information.

Date,Description,Debit,Credit,Balance
2026-09-02,SYNTHETIC DEPOSIT,,50.00,150.00
2026-09-03,SYNTHETIC PURCHASE,20.00,,130.00
Download this synthetic CSV

The signed layout uses Amount = Credit − Debit: money in is positive and money out is negative. It contains the same two transactions, with no separate opening-balance row that might be mistaken for a transaction.

Synthetic example — invented transactions, no customer or account information.

Date,Description,Amount,Balance
2026-09-02,SYNTHETIC DEPOSIT,50.00,150.00
2026-09-03,SYNTHETIC PURCHASE,-20.00,130.00
Download this synthetic CSV

These downloadable CSV examples use invented transactions. They show the layouts you can choose; they do not measure accuracy on real bank statements. Credit-card purchases and payments use the same signed Amount convention; balances owed need a separate sign check.

Upload, review and download

  1. Download the original text PDF from online banking for one account. The current input limits are 50 pages and 20 MiB; scans, photos and encrypted PDFs are unsupported.
  2. Use Upload a statement, choose a file or drop it on the upload page. You can upload and review without an account.
  3. Compare dates, descriptions, amounts and balances with the PDF. Resolve flagged rows and check the account type and statement period.
  4. Sign in to download. In the download screen, choose CSV and use the layout toggle for Debit/Credit or signed Amount. Free allowances and credit requirements still apply.

CSV has no per-row Status column or colour highlighting. If you export a result that still needs review, keep the warnings and original PDF available; do not treat the CSV alone as evidence that every row passed.

Open the CSV without changing its meaning

Use the import preview to check that names, accented characters and amounts display correctly. Some descriptions start with an apostrophe so your spreadsheet treats them as text; keep it when importing.

In Excel versions that provide it, use Data → Get Data → From File → From Text/CSV and inspect the preview before loading. Check the date and decimal interpretation against the PDF. Microsoft documents CSV opening and import options; menus differ across versions.

A matching closing balance helps catch missing amounts, but cannot prove that every description or date is correct. Follow the row-by-row verification guide before using the result elsewhere.

Questions about this workflow

What columns are in the CSV?

Split layout: Date, Description, Debit, Credit, Balance. Signed layout: Date, Description, Amount, Balance. Dates use YYYY-MM-DD; numbers have two decimal places and no currency symbol or thousands separator.

Does a blank cell mean zero?

No. Missing values remain blank. A blank on the unused debit or credit side is normal; both sides blank means there is no proven transaction amount. The signed export refuses that case rather than inventing a zero.

Can I import the CSV directly into accounting software?

Check the software's required columns, date format and sign convention first. A CSV export is not a verified integration with QuickBooks, Xero or another importer.