Guides · Mettle

Mettle names its amount column after the currency.

Amount in GBP, not Amount. It is a small thing that tells you the format was designed by people who had met a multi-currency file, and it’s how a Mettle export is recognised.

mettle-statement.csv
6 columns
Recognised · Mettle
Date Description Reference Amount in GBP Transaction Type Balance
PDF statements too. Mettle PDFs import when every row agrees with the printed balances. Convert a Mettle PDF free →

The file

Date, Description, Reference, Amount in GBP, Transaction Type, Balance.

Amount in GBP is the signed amount

Negative for money out. The column name states the currency rather than leaving it implied.

Reference is dropped when it repeats the description

If both fields say the same thing, the reference is not stored twice, so the review screen shows one piece of information rather than the same string beside itself.

Description falls back to Reference

When the description is empty, the reference is used, so a row is never imported with nothing to identify it.

Balance is read when present

A running balance for confirming the closing figure.

A small decision worth naming

Why the duplicated reference is thrown away.

Mettle frequently populates Description and Reference with the same string. Storing both would mean every transaction on the review screen carried its own text twice, which sounds harmless and is not: reviewing a year is a reading task, and doubling the words on every row halves how fast it can be read. So the reference is kept only when it says something the description does not. It is the sort of decision that never gets mentioned in a feature list and is felt on every screen afterwards.

FAQ

Mettle exports, in practice.

Why is the column called Amount in GBP?

That is Mettle’s own naming. Together with Transaction Type it is how the format is identified.

What happens when Description and Reference match?

Only one is kept. Storing the same string twice makes a year of transactions slower to read for no added information.

Is Mettle a full business account for accounts prep?

It exports the fields needed to prepare from: dated rows, a signed amount, a description and a balance. What you do with them is the accountant’s call.

Does the export carry a transaction type?

Yes, and it is part of how the file is recognised.

Are the dates UK order?

Yes. 05/01/2025 reads as 5 January.

More formats

What the other exports look like.

Barclays Date, Description, Amount, Memo.

One signed amount column, so the sign is the only thing separating a payment from a receipt. Plus what the Memo column is worth keeping for.

Read the format Starling Counter Party, and why it matters for rules.

One of the cleaner UK exports: a signed amount, a running balance on every row, and a counterparty name that is actually the counterparty.

Read the format All formats Every UK export, and the three things that go wrong.

Signs, date order and currency: the three mistakes that give you books that balance but describe the wrong business.

Back to the guides

Founding firms · 22 of 25 places left

Import a Mettle export and see the trial balance it makes.

Fourteen days free and no card. A sample client is set up when you sign up, so you can see the whole thing before any real data goes in.

Start free trial Compare plans
  • Solo £49 £33 /month Up to 50 clients
  • Practice £129 £86 /month Up to 250 clients
  • Firm £299 £199 /month Up to 1,500 clients