Metro Bank statement to Excel or CSV

How this statement is structured

The tested header is DATE · TRANSACTION · MONEY OUT · MONEY IN · BALANCE. Visual extraction order is not treated as reliable; movement direction is resolved against the preceding running balance.

Statement controls recognized

• Opening Balance
• Total Money Out
• Total Money In
• Closing Balance

What the spreadsheet can contain

• Normalized dates
• Transaction and merchant description
• Money-out and money-in values
• GBP running balances

Validation performed before confidence

• Opening plus Total Money In minus Total Money Out is compared with Closing Balance
• Movement and balance pairs are checked against the preceding balance
• The last ledger balance is compared with the reported closing figure

Opening balance + credits − debits = ending balance

What you must review

• Dates such as JUN2019 may be extracted without a space
• Regulatory text after Closing Balance is excluded
• Other Metro Bank products may not match this tested business layout

Convert the statement

1. Download the original PDF directly from your bank or provider.
2. Open the converter and select the PDF. Statement contents are processed locally in your browser.
3. Confirm the detected currency, transaction count, balances and warnings.
4. Compare every row with the source before downloading Excel or CSV.