Priya runs a ten-person design studio in Manchester, and for the first nine months of her business she did her books the hard way: opening her Barclays business account in one browser tab, opening Xero in another, and typing every transaction by hand. When her accountant flagged a three-month backlog right before the VAT return deadline, she decided to finally learn how to import Barclays bank statement into Xero properly. If you bank with Barclays and keep your books in Xero, this guide walks you through the same process she now completes in under fifteen minutes a month — downloading the statement from Barclays, converting it to Xero-friendly CSV, and uploading it without errors.
Why the CSV route beats manual entry for Barclays customers
Xero actually offers two ways to get Barclays transactions into your books: a direct bank feed and a manual file import. The direct bank feed is convenient for day-to-day transactions, and Barclays does support it for both personal and business accounts. But the feed has limits that every Barclays customer eventually hits. It cannot pull statements older than about a year, it misses transactions if the feed drops (which happens after password changes or security prompts), and it is useless for accounts you have already closed.
That is where the manual CSV import comes in. You download the monthly statement PDF from Barclays online banking or the Barclays mobile app, convert it to CSV, and import that file into Xero. The manual route gives you complete coverage of any date range, a clean paper trail for your accountant, and full control over how the data is formatted before it lands in your books. For Priya, it also became her monthly reconciliation ritual: download the PDF, convert, import, match, done.
Step 1: Download your statement from Barclays as PDF
Barclays only exports statements as PDF or CSV from its online channels, and the PDF version is the most reliable source because it always contains the complete, official record. Here is exactly how Priya pulls hers each month:
- Sign in to Barclays online banking or open the Barclays mobile app on your phone.
- Select the account you want — business current account, business savings, or a personal account feeding Xero.
- Open the statements section and choose the month you need. For Xero imports, download full monthly statements rather than custom date ranges; it keeps opening and closing balances aligned with your accounting periods.
- Download the statement as PDF and save it somewhere you can find it, such as a folder named by month (for example, 2026-09-Barclays-business).
Tip: if you need several months at once — for instance, catching up a backlog or closing out a prior tax year — download each month as a separate PDF. Converting and importing one month at a time makes errors far easier to spot than importing one giant multi-month file.
Step 2: Convert the Barclays PDF to Xero-ready CSV
Xero does not accept PDF statements for manual import; it needs CSV (or OFX/QIF). So the next step is converting that Barclays PDF into a clean spreadsheet file. A dedicated converter matters here because copy-pasting from a PDF scrambles columns, drops negative signs, and splits transaction descriptions across lines — all of which break the Xero import later.
Upload your Barclays statement PDF to convert your bank statement to CSV using ConvertStatement: the tool extracts every transaction with its date, description, and amount, and outputs a CSV with exactly the column layout Xero expects. Before you import, open the CSV and confirm three things: dates are in a consistent format (DD/MM/YYYY works fine for UK statements), amounts use a minus sign for money out (no parentheses), and there are no header or footer rows from the PDF (no page numbers, no "carried forward" lines) mixed in with the transactions.
One Barclays-specific quirk to watch: Barclays sometimes labels running balances and reference text inside the transaction column. A good converter separates these, but always eyeball the first few rows of your CSV before uploading — Priya caught a stray balance row in her second month that would have imported as a phantom transaction.
Step 3: Format the CSV the way Xero expects
Xero's manual bank statement import is flexible, but it has a required structure. Your CSV should have these columns:
- Date — the transaction date. Xero accepts several formats, but DD/MM/YYYY is the safest choice for statements downloaded from a UK bank.
- Description — the payee or transaction narrative as it appears on the Barclays statement.
- Amount — positive for money in, negative (with a minus sign) for money out. One amount column only; do not split into separate debit and credit columns.
An optional Reference column can help you match transactions later. Make sure the file is UTF-8 encoded and that the very first row is the header row (Date, Description, Amount) — Xero lets you map columns on the import screen, but starting with clean headers removes a whole category of mistakes.
Step 4: Import the CSV into Xero
With the CSV ready, the actual import takes about two minutes:
- In Xero, go to Accounting → Bank accounts and click Manage account → Import a statement on your Barclays account.
- Click Browse, select your CSV file, and click Import.
- Xero shows a column-mapping screen. Confirm that Date maps to Date, Description maps to Description, and Amount maps to Amount, then click Save.
- Xero imports the statement lines and shows a confirmation with the number of transactions imported.
If Xero flags any rows — usually unrecognized date formats or blank amount fields — fix them in the CSV and re-import. Do not delete the partial import until you are sure you have a clean replacement; duplicate imports are the number one cause of doubled transactions in small-business books.
Step 5: Reconcile and verify the opening and closing balances
Importing is only half the job. The part that keeps your books trustworthy is the balance check. After import, Xero shows the statement balance; compare it against the closing balance printed on your Barclays PDF. They must match to the penny.
Priya's routine: after every import she opens the Barclays PDF, reads the closing balance, and checks it against Xero's statement balance. If they differ, the culprit is almost always one of three things — a duplicated import, a transaction row with a flipped sign, or a header/footer row that slipped into the CSV. Once the balances agree, she works through the imported lines using Xero's Find & Match to pair them with invoices and bills, and uses bank rules to auto-code recurring items like her studio rent and software subscriptions.
For a deeper walkthrough of the matching process, see how to reconcile a bank statement — the steps apply to any bank, Barclays included. Getting this monthly rhythm right is what turns Xero from a shoebox replacement into a genuine financial control for the business.
Common mistakes Barclays customers make (and how to avoid them)
Importing over an active bank feed. If your direct Barclays feed is connected and working, importing the same period manually will double every transaction. Pause or disconnect the feed for the period you are importing manually, and check Xero's statement lines for existing entries first.
Wrong date format. Barclays PDFs show dates as DD/MM/YYYY. If your spreadsheet software flips these to MM/DD/YYYY when you open the CSV, dates like 04/07 become ambiguous. Open the CSV in a text editor first to confirm the raw format before uploading.
Parenthesized negatives. Some PDF converters render withdrawals as (125.00) instead of -125.00. Xero expects the minus sign. A quick find-and-replace in your spreadsheet before import saves a painful cleanup afterward.
Importing the whole PDF, balances included. Barclays statements include running balance columns and summary boxes. If these end up as rows in your CSV, Xero will try to import them as transactions. Strip everything except Date, Description, and Amount before uploading.
Frequently asked questions
Can I import a Barclays statement into Xero without a direct bank feed?
Yes. Download the statement as PDF from Barclays online banking or the mobile app, convert it to CSV, then use Xero's Import a statement feature under Accounting → Bank accounts. No bank feed connection is required.
What CSV format does Xero need for a Barclays import?
Three columns: Date, Description, and Amount. Use DD/MM/YYYY dates, positive numbers for deposits, and minus-signed numbers for withdrawals. The first row should be the header row.
Should I use the bank feed or manual CSV import for Barclays?
Use the feed for current transactions when it is stable. Use manual CSV import for older statements, closed accounts, periods the feed missed, or when you want a verified month-by-month paper trail for your accountant.
How do I avoid duplicate transactions when importing?
Check the date range already in Xero before importing, disconnect or pause the bank feed for the period you are importing manually, and always verify the closing balance against your Barclays PDF immediately after import.
Can I import several months of Barclays statements at once?
You can, but it is safer to convert and import one month at a time. Monthly imports keep opening and closing balances aligned with your accounting periods and make errors much easier to find.
Priya's backlog is gone, her VAT returns now take an afternoon instead of a weekend, and her accountant actually complimented her books last quarter — a first. The whole workflow rests on one unglamorous step most people skip: turning the Barclays PDF into a clean, Xero-ready CSV before anything touches the accounting software. Start your free conversion at ConvertStatement and import this month's Barclays statement into Xero today — or see pricing if you process statements every month and want unlimited conversions.