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
- Drop the PDF in the box on this page, and we show you its first page converted.
- 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.
- 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.
Read next
- Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
- Why a Converted Bank Statement Does Not Balance
Other banks
- Convert ANZ Bank Statements to Excel
- Convert Commonwealth Bank (CommBank) Statements to Excel
- Convert ICICI Bank Statements to Excel
- Convert Monzo Bank Statements to Excel
- Convert Nationwide Bank Statements to Excel
- Convert HSBC Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
- Convert TSB Bank Statements to Excel
- Convert Virgin Money Bank Statements to Excel
We convert other banks' statements too. See every bank page.