Convert a Barclays Statement PDF to Excel or CSV

Barclays statement structure, the Money out and Money in columns, dates printed once a day, and how to verify a converted file against the statement.

In the Barclays statement we checked, the transaction table has five columns — Date, Description, Money out, Money in, Balance — which converts more reliably than most. The complications are smaller but still worth knowing.

One date per day, one balance per day

Barclays prints the date once, on the first transaction of each day, and leaves it off the transactions that follow on the same day. The balance is printed only on some rows rather than on every one. A converter that treats a row without a date as a continuation line will glue a whole day's transactions into one; a converter that fills blanks with zero produces a balance column that looks catastrophic.

The spreadsheet keeps both as printed: a blank date stays blank and a blank balance stays blank. If you want a date on every row, select the Date column in Excel, choose Go To Special, Blanks, type = and the cell above, and press Ctrl+Enter.

Descriptions carry the transaction type as a prefix

Barclays prefixes descriptions with a type code: `Direct Debit`, `Card Payment`, `Bill Payment`, `Faster Payment`. This is genuinely useful information. The converted file keeps it at the start of the description, as printed, so a text filter on `Direct Debit` finds every direct debit, and a formula can split it into a column of its own if you want one.

Start and end balance rows

Barclays prints "Start balance" and "End balance" as rows inside the transaction table itself, rather than in a separate summary box. They sit in the same columns as transactions and carry an amount in the balance column.

These are boundary markers, not transactions. Include them as rows and your transaction count is off by two and your totals are wrong. Exclude them and you have exactly what you need to verify the rest.

Which Barclays export you have matters

Barclays gives you three routes to a statement and they are not equally good as conversion input. The PDF from online banking carries a proper text layer and converts cleanly. The export from the mobile app is usually the same document. A scan or photograph of a posted paper statement has no text layer at all and has to go through OCR, which is materially less accurate.

If you have the choice, always take the online banking PDF. It costs nothing and removes an entire category of error before you start.

What the converted file contains

Barclays column	What the spreadsheet holds
Date	As printed: day and month, with the month as a word, which cannot be misread. The year comes from the statement period, not the row
Description	The full text, type prefix included, with wrapped lines joined into one cell
Money out	Each debit as printed
Money in	Each credit as printed
Balance	As printed, blank where Barclays left it blank, and what the Completeness sheet checks the rows against

Nothing is renamed, reordered or rounded. For Xero, the Xero CSV download turns Money out and Money in into the single signed Amount column Xero's import asks for.

An example in Barclays' layout

A made-up example. Every row below is invented — SAMPLE names, round amounts — and set out the way the Barclays statement we checked sets out its table: the same five headings, in the same order, the date only on a day's first row and the balance only at the end of a day.

Date	Description	Money out	Money in	Balance
3 Mar	Card Payment to SAMPLE CAFE	4.50
	Direct Debit to SAMPLE GYM	30.00		965.50
5 Mar	Payment from SAMPLE EMPLOYER		1,500.00	2,465.50
7 Mar	Card Payment to SAMPLE	45.00		2,420.50
	BOOKSHOP

What the Excel or CSV gives back. The same five headings in the same order, every figure exactly as printed, the second line of the last description joined back into its row, and the blank dates and balances still blank — four transactions, four rows. The 3 March balance follows from the start balance of 1,000.00 less both of that day's payments, which is how the check reads a balance printed once a day.

Date	Description	Money out	Money in	Balance
3 Mar	Card Payment to SAMPLE CAFE	4.50
	Direct Debit to SAMPLE GYM	30.00		965.50
5 Mar	Payment from SAMPLE EMPLOYER		1,500.00	2,465.50
7 Mar	Card Payment to SAMPLE BOOKSHOP	45.00		2,420.50

Verifying a Barclays conversion

Because Barclays prints start and end balance rows inside the table itself, you have both ends of the chain without hunting for a summary box. Take the start balance, apply every debit and credit in order, and you should land exactly on the end balance.

If you land somewhere else, the difference is often a single row, and its size usually tells you which one. A discrepancy that exactly matches a transaction you can see on the PDF means that row was dropped.

Frequently asked questions

Are Barclays business account statements supported?

Yes, including the additional charges sections.

How do I convert several months of Barclays statements?

Convert each PDF separately and stack the exports. The column layout is identical between months, so they append without remapping.

Does it handle Barclays credit card statements?

Yes, though credit card statements carry no running balance, so verification compares against the printed new balance and payment totals instead.

Can I get the transaction type as a separate column?

Not automatically. The description comes through as Barclays printed it, prefix included, so filtering on the prefix works straight away, and a LEFT or TEXTBEFORE formula can move it into a column of its own.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.