Convert Barclays statements to Excel and CSV
To convert a Barclays statement to Excel or CSV, upload the PDF, scan or photo to statement.work and export each transaction with date, description, a single signed amount and running balance. UK "paid out" and "paid in" columns are combined into one amount column.
Not affiliated with Barclays. statement.work is an independent tool. Barclays is a trademark of its owner and is named here only to describe the statements this page is about.
About Barclays statements
Barclays is one of the UK’s largest banks, headquartered in London, with personal, premier and business customers. Its card business, Barclaycard, issues separate credit card statements. For UK bookkeepers, Barclays current account and business account statements are some of the most common documents they handle.
What UK statements like Barclays’ typically contain
- Your name, address, sort code and account number, and the statement period.
- A balance at the start of the period, sometimes shown as a brought-forward line.
- A transaction table with date, description, money out (“paid out”), money in (“paid in”) and balance columns.
- Dates written day-first, often as day and month name.
- Totals for money in and out across the period, and the closing balance.
Exact layouts vary between personal and business accounts and change over time.
Common conversion problems
- Two amount columns. With paid out and paid in in separate columns, every row has a blank cell. Pasted text loses track of which column a number came from. statement.work outputs one signed amount per row.
- Several transactions on one date. UK statements often print the date once, on the first transaction of the day. The rows below need that date filled in.
- Brought-forward lines. “Balance brought forward” isn’t a transaction and must not be counted as one.
- Card statements. Barclaycard statements are a different document type. Don’t expect the same columns as a current account.
How to convert it
- Download the statement PDF from online banking, or use a scan or photo.
- Upload it to statement.work.
- Review the transactions: one date per row, one signed amount, a running balance and a category.
- Export to CSV or Excel.
- Check: opening balance plus money in minus money out equals the closing balance.
Other UK banks
UK statements share these conventions, though every bank’s layout is its own. See HSBC UK and NatWest, or read bank statement formats explained.
Questions
Are Barclaycard statements the same as Barclays bank statements?
No. Barclaycard is Barclays' credit card business, and card statements list purchases, payments, interest and fees rather than a current account's paid out, paid in and balance columns. Both convert with statement.work.
Will UK dates be read correctly?
Yes. UK statements write dates day-first, and statement.work outputs one consistent date format, so 03/04 stays the 3rd of April.
Is statement.work affiliated with Barclays?
No. statement.work is independent and is not affiliated with or endorsed by Barclays.