Bank Statement Converter

From PDF to Transaction Columns

This bank statement converter reads selectable PDF text on your device and turns mapped columns into an editable transaction table. Choose a client-authorised statement or paste its text into the source field. The fictional example shows the column layout before you select a file.

Open Column mapping to match the source columns with date, description, debit, credit and balance. For a single signed amount column, set debit and credit to Not used, then choose which sign means money leaving the account. Apply columns to rebuild the table from the source text.

Correct each row directly in the transaction table. Add a missing row, join a wrapped description by editing its transaction, then remove the extra continuation row. Source edits and mapping changes replace table edits when you apply them, so make those changes first.

The converter keeps unrecognised lines for review instead of silently discarding them. Remove page headings and totals only after checking that they are not transactions. Nothing is uploaded or saved between visits.

Checking Dates, Amounts and Balances

Choose day-first or month-first dates before checking the rows. A date whose day and month could be swapped stays flagged until you mark its row Checked. Every date needs a full year.

Debit and credit columns use positive amounts. A debit reduces the balance and a credit increases it. Enter transactions oldest first, or use Reverse row order when the statement lists the newest transaction first.

The fictional example starts at $1,000. A $2,500 credit and debits of $54.90 and $100 produce a closing balance of $3,345.10. The difference is zero when you enter $3,345.10 as the statement's closing balance.

Each mapped balance is compared with the running total when you provide an opening balance. The closing check compares opening balance plus credits minus debits with your stated closing balance. Missing or reversed transactions can offset each other, so a zero difference still needs a row-by-row review.

Invalid dates or amounts disable downloads and replace totals with Unavailable. Resolve those errors, check any remaining warnings, then confirm that you reviewed the rows and differences against the original statement.

CSV and Excel Exports

Download the comma-separated values (CSV) file to open the table in Excel or another spreadsheet. The file contains ISO dates, descriptions and separate debit, credit and balance columns. Amounts retain two decimal places and descriptions are quoted so commas remain inside their cells.

In Excel, use Data, then From Text/CSV to choose column types before loading the file. Import descriptions and identifiers as text to preserve leading zeros. Keep the monetary columns numeric and choose a date type that recognises year-month-day dates.

Descriptions beginning with a spreadsheet formula character receive an apostrophe to stop them executing as formulas. This protection changes the exported text. Keep the original statement when you need an exact source record.

The optional Quicken Interchange Format (QIF) file contains a date, signed amount and description for each valid row. It uses month/day/year dates and the bank transaction format. Import support depends on the receiving software and account type. QIF does not include the table's running balances or create a native Excel workbook.

Scans and Unsupported Layouts

A scanned statement contains pictures of transactions and needs optical character recognition before this converter can read it. Pages with too little selectable text stop the conversion and show an error. A scan with a text layer can still contain recognition mistakes, so compare the extracted rows with the image.

Irregular spacing, repeated headings and wrapped descriptions can disrupt column extraction. Use the source editor to paste tab-separated columns and map them manually. The tool keeps up to 5,000 rows and accepts PDFs up to 20 MB with no more than 100 pages.

If a page has no usable transaction text, obtain a digital statement or an account-history export from the bank. Rebuild incomplete rows from the source before downloading. The free converter runs in your browser, so you can use it wherever you have the authorised statement.