Banks

Convert Metro Bank Statements to Excel

Convert Metro Bank statement PDFs to Excel and CSV, with each card purchase and payment in a row of its own and every balance checked. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

We turn your Metro Bank statement PDF into a spreadsheet with the columns the statement prints, and we check every balance on the way.

What a Metro Bank statement looks like

  • A Metro Bank statement has five columns: Date, Transaction, Money out, Money in and Balance.
  • The Transaction column starts with the kind of payment, spelt out: Inward Payments, Outward Fast Payments, Card Purchase or DD Payments for a direct debit. We keep it at the start of the description cell, so you can sort or filter on it.
  • A card purchase also carries the date and time it was made, such as 02/06/19 09:15:48, before the shop's name. We keep that in the description too.
  • Every transaction has its own date, written like 01 JUN 2019, and its own balance.
  • The Balance brought forward line at the top and the Closing Balance line at the end come through as rows of their own, so your sheet starts and ends where the statement does.

What your spreadsheet looks like

Date Transaction Money out Money in Balance Ledger
Balance brought forward 2,410.00 ok
03 JUN 2019 Inward Payments A CUSTOMER LTD 850.00 3,260.00 ok
04 JUN 2019 Card Purchase 04/06/19 12:31:07 STATIONERY SHOP 23.49 3,236.51 ok
05 JUN 2019 Outward Fast Payments A SUPPLIER 400.00 2,836.51 ok
07 JUN 2019 DD Payments WATER COMPANY 41.20 2,795.31 ok

The rows above are an example, not a real statement.

How we test it

We test against one five-page Metro Bank business account statement: 36 transactions, and every one of them balances against the row before. The opening and closing balances check out too.

One statement is a small sample. If yours comes out with a row marked break, email us the statement and we will look at it.

Convert a Metro Bank statement

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
  3. To convert every page, choose a plan on the pricing page.

To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.

Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.