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

Import it straight into Xero, QuickBooks, Sage or Odoo

The same read comes out as the file each system’s bank-statement import screen takes: one download per system, with the balance lines and account details left out. Before you download, the studio checks that the opening balance plus the transactions equals the closing balance on the statement. Two ways to get them: the Bank statement file button of the pay-once converter, or in the studio: sign in, read the statement, then Send to store / ERP / accounting → Bank statement.

The studio's bank statement dialog on the invented sample: 38 transactions, the balance check 1,523.40 + 480.20 = 2,003.60 matching the statement, and one download each for Xero, QuickBooks, Sage, Odoo and OFX

Xero

Where: Accounting → Bank accounts → the account's menu → Import a Statement.

File: CSV (Date, Amount, Payee, Description, Reference; Xero assigns the columns by itself) or OFX.

Read back 38 of 38 transactions in Xero on 2026-09-26, from the CSV and from the OFX.

A statement over 1,000 lines comes as numbered files; upload them one by one.

QuickBooks Online

Where: Bank transactions → Link account → Upload from file → pick the account.

File: CSV (Date, Description, Amount; QuickBooks matches the columns and the day-first dates by itself) or OFX, which also carries the closing balance.

Read back 38 of 38 transactions in QuickBooks Online on 2026-09-26, from the CSV and from the OFX.

QuickBooks may shorten some descriptions after the import (it drops words such as "DIRECT DEBIT"); the file carries the full text. Up to 1,000 lines and 350 KB per file; a bigger statement comes as numbered files.

Sage Accounting (South Africa edition)

Where: Banking → pick the bank account → Import Bank Statements → file type CSV → Import File.

File: CSV (Date, Description, Amount), the layout Sage's own help asks for.

Read back 38 of 38 transactions with their full descriptions on 2026-09-26.

Use the CSV: Sage's OFX import keeps only the first 32 characters of each description. The UK edition has not been tested yet.

Odoo Online / Enterprise

Where: Accounting dashboard → the bank journal's ⋮ menu → Import File.

File: CSV (Date, Label, Amount; Odoo matches the columns by itself) or OFX, which also brings the statement's closing balance.

Read back 38 of 38 transactions in Odoo Online on 2026-09-26, from the CSV and from the OFX.

Odoo Community

Where: Install the two free OCA modules account_statement_import_file and account_statement_import_ofx, switch on Show Full Accounting Features on your user, then use Import Statement (OCA) on the bank journal.

File: OFX. Community has no bank-statement import of its own without these modules.

Read back 38 of 38 transactions on Odoo 18 Community on 2026-09-26; importing the same file again was refused as a duplicate.

For an OFX file, type the bank account’s currency and account number in the studio before you download: the file must match the account it goes into, and Odoo refuses a file whose account number is not on the journal. The proofs used the invented two-page sample statement shown above.

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.

Can I import the statement into Xero, QuickBooks, Sage or Odoo?

Yes: the Bank statement file button of the pay-once converter, or the studio's Send menu, gives a CSV or OFX file in each system's own bank-statement import layout. On 26 September 2026 each file was imported and all 38 transactions of the sample statement were read back in Xero, QuickBooks Online, Sage Accounting (South Africa edition), Odoo Online and Odoo Community with the free OCA importer.

Honest limit: the engine returns the file. It does not connect to your bank, does not push anything into your accounting software (you import the file yourself), 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.