Convert Barclays statement PDFs to Excel, Xero and CSV.
Xero, QuickBooks Online, Sage files from the PDF.
Barclays statement PDFs open without a password. Online Banking has an 'Export All' link at the foot of the transaction list, offering CSV, OFX or QIF for whatever date range you have searched.
Drop your Barclays statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in GBP.
Last updated
How to download a Barclays statement as a PDF
- Log in to Barclays Online Banking and choose 'Manage accounts', then 'Statements and documents' (older layouts show this as 'My Barclays documents' under your profile).
- Pick the account. Statements are listed newest first, one per statement date.
- Click the PDF icon next to the month you want. It opens in the browser viewer; use the download arrow or 'File > Save as' to keep a copy.
- In the app: tap 'Help/More' on the home screen, then 'Statements', pick the account and month, and use Share or Save to get the PDF onto your device. Business customers see a 'Statements' tile directly on the home screen.
Then drop the file above; several months of Barclays statements at once come back as one workbook.
Is the Barclays PDF password-protected?
Barclays statement PDFs open without a password. If one asks for a password it came from somewhere else, most likely a broker or letting agent who protected it before forwarding.
What Barclays statements look like
Date, Description, Money out, Money in, Balance table with the balance printed on every row; day/month dates.
Barclays prints a 'Your transactions' table headed Date, Description, Money out, Money in, Balance, with the balance shown on every line and a 'Start balance' and 'End balance' bracketing the period. Dates are day and abbreviated month with no year on the row, so the year is taken from the statement period at the top. Card purchases carry the merchant plus a date the purchase was made, which is often a day or two before the row date. Personal accounts usually run to two or three pages a month; business accounts with card terminals can hit ten. Overdrawn balances are printed with a D suffix rather than a minus sign.
Why not use Barclays's own export?
Online Banking has an 'Export All' link at the foot of the transaction list, offering CSV, OFX or QIF for whatever date range you have searched. The range only reaches back a few months, so a full year means several passes, and the CSV has no running balance and no opening figure to check against. Barclays also lists 'Statements and documents' back to July 2013 for accounts that were paperless from then. For anything older than the export window, or when you want the balance column to prove the rows add up, the PDF statement is the file to work from.
Where Barclays statements trip up converters
- UK date order (day first) is detected from the statement period so 03/04 is not read as March 4th.
- Long references like "FASTER PAYMENT REF …" are kept whole in the description.
Which software Barclays customers import into
Barclays customers most often import into Xero, QuickBooks Online, Sage, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
Barclays questions
Why does the balance column on my Barclays statement have a D after some figures?
D means the account was overdrawn on that line. Barclays does not use a minus sign in the balance column. stmtai reads the D and writes the balance as a negative number in Excel, so running totals and any bank rules that check for overdrafts work as expected.
My Barclays card payments show two dates. Which one goes into the spreadsheet?
The date in the Date column is the posting date and is what the balance moves on, so that is the transaction date in the export. The date inside the description (for example a purchase made on a Saturday that posted on the Monday) is left in the description text. If you need the purchase date separately you can split it out with a formula, but for reconciliation the posting date is the right one.
I have a Barclays Business statement and a personal one. Are they laid out the same?
Close enough that both convert the same way. The business version adds an account summary panel and, for some accounts, a separate page listing cheques presented. Those extra pages are recognised as summaries and not turned into transaction rows.
How do I convert a Barclays statement PDF to Excel?
Download it from Barclays using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many Barclays statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.