Converting a statement
Set the year and date format
Statements often print dates like 03 Oct without a year, so enter the statement year. Choose dd/mm/yyyy for UK spreadsheets or yyyy-mm-dd for most accounting imports.
Choose the PDF
Use the PDF downloaded from online banking, not a scan. The pages are read one by one and progress is shown.
Read the totals
The summary gives the number of transactions, how many were checked against the balance, and the totals paid in and paid out.
Look at unchecked rows
Rows that could not be checked against a running balance are marked No. Their direction comes from CR or DR, a minus sign, or nothing at all, so look at them, especially any with an empty amount.
Download the CSV
The columns are Date, Description, Amount (negative for money out), Paid out, Paid in and Balance.
Example: a fortnight on a small business account
The lines below are typical of a text-based statement (all names are fictional). Four transactions sit between printed balances, so the tool can tell from the change in balance whether each was money in or out, and marks them checked.
The fuel payment has an amount but no balance after it, so its direction cannot be proved and the Amount is left empty. That break also means the transfer that follows cannot be checked. Both are flagged for you to fill in by hand rather than guessed.
Balance brought forward 2,450.00 03 Oct Card payment TRADE COUNTER LEEDS 86.40 2,363.60 03 Oct Faster payment HARBOUR BAKERY INV 1042 480.00 2,843.60 07 Oct Direct debit EXAMPLE TELECOM 42.99 2,800.61 10 Oct Standing order RENT UNIT 4 650.00 2,150.61 14 Oct Card payment FUEL STATION 55.00 15 Oct Transfer from savings 300.00 2,395.61
Transactions 6 Checked against the balance 4 of 6 Date,Description,Amount,Paid out,Paid in,Balance 03/10/2026,Card payment TRADE COUNTER LEEDS,-86.40,86.40,,2363.60 03/10/2026,Faster payment HARBOUR BAKERY INV 1042,480.00,,480.00,2843.60 07/10/2026,Direct debit EXAMPLE TELECOM,-42.99,42.99,,2800.61 10/10/2026,Standing order RENT UNIT 4,-650.00,650.00,,2150.61 14/10/2026,Card payment FUEL STATION,,,, 15/10/2026,Transfer from savings,,,,2395.61
Before you import the CSV
- The paid in and paid out totals match the statement's own summary.
- Every row marked No has been checked and its amount filled in.
- The first and last balances match the opening and closing balances on the PDF.
- Descriptions that wrapped onto two lines have been joined correctly.
- If your software expects a single signed amount, use the Amount column; if it wants separate columns, use Paid in and Paid out.
Questions people ask
Is it safe to convert a bank statement online?
It depends on where the file goes. Many converters upload the PDF to their server. This one reads it in your browser and creates the CSV on your device, so the statement is never sent to Map Extract or anyone else. Your browser's network panel will show that no request carries the file.
Why does it say no text was found?
The statement is probably a scan or a photo, which is a picture of text rather than text the tool can read. Download the statement as a PDF from your online banking instead. If you only have a scan, run it through an image to text tool first, though checking every figure afterwards is essential.
Does it work with every bank?
It works with text-based PDF statements that put a date at the start of each transaction line and amounts at the end, which covers most UK banks' downloadable statements. Unusual layouts may produce rows that cannot be checked against a balance; they are flagged so you can correct them rather than import mistakes.
Why are some amounts left empty?
When a line has one amount and no running balance next to it, the tool cannot prove whether money went in or out unless the statement marks it with CR, DR or a minus sign. Rather than guess, it leaves the amount empty and marks the row unchecked, so you fill it in from the statement.
Where your data goes
The statement PDF is read in your browser by the bundled pdf.js library and the CSV is created on your device. Nothing is uploaded to Map Extract or any other server, and nothing is stored after you leave the page.
Checked against the tool on