Guide · Bank statements

Convert a bank statement to Excel or CSV

Upload the PDF statement and the MicroCity engine reads it into a spreadsheet: one row per transaction, with the date, the description, money out, money in and the running balance in their own columns. Download it as Excel or CSV and check it against your statement.

What the spreadsheet looks like

How it works

  1. Upload the statement — the PDF you download from online banking.
  2. The engine reads every page into date, description, paid out, paid in and balance columns, and shows you the first two pages free.
  3. Check the preview, then download the whole statement as an Excel workbook or a CSV file.

A real result, from an invented sample statement

The first rows the engine returned for a made-up two-page statement from “Example Bank” (invented data, no real account). All 38 transactions came back with the right date, description, amounts and balance; the salary line was printed on two lines in the PDF.

DateDescriptionPaid outPaid inBalance
01 Sep 2026BALANCE BROUGHT FORWARD1,523.40
01 Sep 2026DIRECT DEBIT EXAMPLE ENERGY CO84.201,439.20
01 Sep 2026STANDING ORDER RENT REF FLAT 2 SEPTEMBER950.00489.20
02 Sep 2026CARD PAYMENT SAMPLE SUPERMARKET46.37442.83
03 Sep 2026FASTER PAYMENT RECEIVED FROM EXAMPLE EMPLOYER LTD SALARY2,480.002,922.83
03 Sep 2026CARD PAYMENT CITY COFFEE HOUSE3.602,919.23
04 Sep 2026DIRECT DEBIT DEMO MOBILE LTD22.002,897.23

Questions people ask

Can I convert a scanned bank statement to Excel?

Statements downloaded from online banking as PDF are what this page was tested on. Scans and phone photos go through the same engine; try two pages free first and check the amounts against the statement before you pay for the whole file.

Does it handle a statement with several pages?

Yes. Each page is read in turn and the transactions come back in statement order in one table, the balance on page two carrying on from page one. The account details repeated at the top of every page come back in their own columns, not as transactions.

Which banks does the bank statement converter work with?

The engine reads the statement's layout, not a list of banks: any statement laid out as a table of dates, descriptions and amounts. There is no list of supported banks to check.

Is my bank statement kept?

Uploaded files are kept only as long as needed to deliver and support your result, and you can ask for yours to be deleted at any time. The privacy policy has the details.

Do I get Excel or CSV?

Either. Download the result as an Excel workbook or as a CSV file, ready for a spreadsheet or for an import.

Honest limit: the engine returns the spreadsheet. It does not connect to your bank or your accounting software, does not sort transactions into categories and gives no accounting advice. Check the totals against your statement before you use the file. How files are handled: the privacy policy.

Try it on your own statement, two pages free

Upload the statement, look at the two-page preview, and pay once for the whole file only if it is right. No account, no subscription. Regular statements every month fit the monthly plans; bookkeepers with several clients, email contact@microcitylabs.com.