How to Convert a Mettle PDF Bank Statement to CSV or Excel

Mettle is NatWest Group's app-only business account built for sole traders and freelancers. Formal statements come as PDF files, which are difficult to work with if you need structured data for bookkeeping, tax returns, or accounting software imports. Here's how to convert them into clean CSV or Excel — for free, in under a minute.

By Jack Whitehead 1 March 2026 5 min read

Watercolour illustration of a Mettle bank statement with molten data flowing into spreadsheet cells

The Problem With Mettle PDF Statements

Mettle is a mobile-first bank account. Everything runs through the app — there are no branches, no desktop banking portal with advanced export options. When you need a formal record of your transactions, Mettle provides PDF statements. For many sole traders, that PDF is the only comprehensive document covering a full statement period.

The trouble starts when you try to use that data. Copy-pasting from a Mettle PDF into a spreadsheet produces jumbled columns, broken descriptions, and amounts that end up in the wrong cells. If you're trying to import transactions into Xero, QuickBooks, Sage, or any other accounting platform that doesn't integrate directly with Mettle, you need a proper CSV — and the PDF won't give you one without help.

Quick answer: Use ReconcileIQ's free PDF converter. Select Mettle, upload your PDF, and download clean CSV or Excel output. No signup, no email, no cost.

How to Convert Your Mettle Statement (4 Steps)

Open the converter tool
Go to bankreconciler.app/tool and click the PDF to CSV converter section.
Select Mettle from the bank dropdown
This tells the parser which statement layout to expect. Mettle's business account format is fully supported.
Upload your PDF
Drag and drop or click to browse. The tool processes the file instantly in your browser. Your statement data never leaves your computer.
Download your CSV or Excel file
Review the extracted transactions on screen, then download as CSV (for accounting software import) or Excel (for spreadsheet analysis).

Privacy note: The converter runs entirely in your browser. Your Mettle statement is never uploaded to any server. The data stays on your machine throughout the process.

What the Converter Extracts

The Mettle parser extracts these fields from your PDF statement:

Date — transaction date in a clean, sortable format
Description — payee name, merchant details, or transfer reference
Amount — transaction value (positive for money in, negative for money out)
Balance — running balance after each transaction

Mettle statements typically use a single amount column with positive and negative values rather than separate "money in" and "money out" columns. The converter preserves this format in the CSV, or can split amounts into separate debit and credit columns if needed for your accounting software.

Can I Export Mettle Transactions Directly?

Mettle's app does allow you to view and share transaction data, but the export options are limited compared to traditional banks with full online banking portals. For a formal, complete record of a statement period, the PDF statement is the primary document Mettle provides.

If you're a sole trader filing a Self Assessment tax return or a freelancer preparing quarterly accounts, you likely need structured data covering specific periods. Converting the PDF statement gives you exactly that — clean rows with dates, descriptions, and amounts ready for import.

Mettle and FreeAgent Integration

Mettle has a built-in integration with FreeAgent, which can pull transactions directly via a bank feed. If you already use FreeAgent, this is the most convenient route and you may not need to convert PDFs at all.

However, if you use any other accounting platform — Xero, QuickBooks, Sage, Pandle, or others — there is no direct Mettle integration. In that case, converting your Mettle PDF statement to CSV is the fastest way to get your transactions into your software.

Understanding Mettle Statement Format

Mettle is a business-only account, so the statement format is straightforward compared to banks that have multiple personal and business layouts:

Single account type — Mettle offers one business current account, so the statement layout is consistent
Date and description — each transaction row includes the date and a description of the payment or receipt
Single amount column — credits shown as positive values, debits as negative (rather than separate columns)
Running balance — the balance after each transaction is listed alongside
Transaction references — faster payments, direct debits, and card payments each include relevant reference details

Because Mettle only has one account type, the parser is highly reliable. There are no layout variations between personal, business, or premium tiers to worry about.

What to Do With Your CSV Data

As a sole trader or freelancer, once you have clean CSV data from your Mettle statement, you can:

Import into accounting software — Xero, QuickBooks, Sage, and Pandle all accept CSV bank imports. This is the main route if you don't use FreeAgent
Reconcile in ReconcileIQ — upload alongside your accounting data to automatically match and reconcile transactions
Prepare your Self Assessment — structured transaction data makes it straightforward to categorise income and expenses for your tax return
Code in CodeIQ — if you're a bookkeeper managing clients who use Mettle, CodeIQ can automatically code transactions to the chart of accounts, classify VAT, and post back to your platform
Track cash flow in Excel — pivot tables, monthly summaries, and spending breakdowns for your business
Submit for MTD — Making Tax Digital for Income Tax (MTD ITSA) requires digital record-keeping. Clean CSV data is the first step

Convert Your Mettle Statement Now

Free, instant, and private. Built for sole traders and freelancers. No signup required.

Open PDF Converter

Frequently Asked Questions

Can I export my Mettle transactions as CSV directly?

Mettle's app provides limited export options. For a complete, formal statement covering a full period, the PDF statement is the primary document. You can convert it to CSV for free using the converter at bankreconciler.app/tool — it takes seconds and requires no signup.

Does Mettle integrate with accounting software?

Mettle integrates directly with FreeAgent via a bank feed. If you use any other platform (Xero, QuickBooks, Sage, Pandle), there is no direct integration. Converting your Mettle PDF statement to CSV is the fastest way to import transactions into those tools.

Is the Mettle PDF converter free?

Yes. The PDF to CSV converter is completely free with no signup required. It runs entirely in your browser so your data stays private and never leaves your device.

What format are Mettle PDF statements in?

Mettle statements use a consistent business account layout with date, description, amount (positive for credits, negative for debits), and running balance. Since Mettle only offers one account type, the format is predictable and the converter parses it reliably every time.