Convert Barclaycard card statements to Excel.
Checked to the cent.
Drop a Barclaycard PDF and get a clean spreadsheet, QuickBooks or Xero file in seconds. Every row is checked against the balances printed on the statement, so a misread is flagged, not hidden.
Drop your bank statements here
One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in GBP.
How to download a Barclaycard card statement as a PDF
- Log in to Barclays Online Banking; personal Barclaycards are serviced there now rather than on a separate Barclaycard site.
- Click the Profile icon, choose "Manage documents and messages", then "Statements and documents".
- Select the Barclaycard account and the statement month; up to seven years of statements are listed for personal cards.
- Open the statement and save it as a PDF from the viewer.
- In the Barclaycard app (or the Barclays app if your card has moved across), go to "Statements and documents", pick the card and month and tap the download icon; on Android the file lands in the My files folder.
- Business cardholders use Barclaycard business online servicing, where "Statements" holds up to thirteen months and a separate transaction report download covers longer periods.
Then drop the file above. Several months at once is fine; a year comes back as one workbook with a sheet per month.
Before you upload: is the PDF password-protected?
Barclaycard does not lock the statements you download from Barclays Online Banking or the app. We have not met a protected Barclaycard PDF; if one turns up, the upload box asks for the password and unlocks it in your browser before anything is sent.
What Barclaycard statements look like
UK card statement with a summary of previous balance, payments, purchases, interest and new balance on page one, then a transactions list of Date, Description and Amount with credits marked CR rather than with a minus sign.
A Barclaycard statement arrives monthly on a fixed statement date and runs two to four pages. Page one summarises the month: previous balance, payments and refunds received, new purchases, cash withdrawals, interest, charges and the new balance, with the minimum payment and payment due date beside it, and the arithmetic is previous balance minus payments minus refunds plus purchases plus cash plus interest plus charges equals new balance. The transactions list is Date, Description and Amount with day-first dates and no separate post date column on the statements we see. Credits are shown with a CR after the amount instead of a minus sign, which is the single most common cause of a reversed column in a conversion. Where a card carries a promotional balance transfer, the statement itemises the purchase balance and the transfer balance separately, each with its own rate, expiry and interest line. Foreign purchases show the original currency amount and rate under the merchant, with the non-sterling transaction fee as its own line. Once a year an annual statement summarises twelve months of interest and charges; it is a summary, not a transaction list.
Where Barclaycard statements trip up other converters
- Credits are marked with a CR suffix, not a minus, so a plain number extraction reads a payment as a purchase; the previous-to-new balance check fails at once and the swap fixes the sign.
- Personal Barclaycards are now serviced inside Barclays Online Banking, so the statement list sits under the Barclays profile menu rather than on a separate Barclaycard site.
- Purchase and balance transfer balances are itemised separately, each with its own interest line; every interest line is a debit in the check like any other fee.
None of this is bank-specific configuration. The balance check catches these cases for every bank; this list just explains what you will see on a Barclaycard file.
Why not just use Barclaycard's own export?
Barclaycard's help page says statements and transactions can be downloaded "in a range of formats" from Statements and documents, and in practice the transaction export on a card account mirrors the Barclays current account one: CSV, OFX or QIF for a date range you have searched. The online transaction view for a personal card reaches back about twelve months, so a longer history means the statement PDFs regardless. Business servicing is more fragmented: online servicing lists thirteen months of statements, the CentreSuite portal used for some commercial programmes shows six months of statements and twelve of transactions, and the reporting platform for larger programmes holds thirty-six months of data. None of these exports carries the previous balance, the interest split by balance type or the new balance, so a month cannot be proved from them. The monthly statement PDF has all three, back to seven years on personal cards.
What you get back
- A green Balanced badge when the printed opening balance plus money in minus money out equals the printed closing balance, row by row. Or a red one pointing at the first row that does not add up, with a one-click swap if debit and credit look reversed.
- Click any misread cell, correct it, and the check re-runs before you download.
- Download Excel, CSV, QuickBooks (.qbo), Xero CSV or Tally XML, whichever Xero imports best, with a suggested category on every row.
Importing into Xero, QuickBooks Online, Sage, Excel
Barclaycard questions
What does CR after an amount on my Barclaycard statement mean?
CR marks a credit: a payment you made, a refund from a retailer or a reward credited to the card. Barclaycard uses the suffix instead of a minus sign, so on paper a £300 payment and a £300 purchase look identical apart from those two letters. stmtai reads the CR and books the row as a credit; if a file has come through with every row treated as a purchase the New Balance check fails straight away and the one-click debit/credit swap corrects the whole column.
My Barclaycard statement shows a purchase balance and a balance transfer balance separately. Is that two accounts?
One account, one New Balance. Barclaycard breaks the balance down by rate so you can see how much sits at the promotional rate and when it ends, and each part gets its own interest line. For bookkeeping all of it is a single card liability: the purchases are expense lines, the balance transfer arrival is a transfer between liabilities, and each interest line is an interest expense. The tie-out uses the single new balance at the top of the statement.
Barclaycard sends an annual statement as well as the monthly ones. Should I convert it?
Usually not. The annual statement is a twelve-month summary of interest, fees and payments with no transaction rows, produced under the Consumer Credit rules so you can see the cost of the card in a year. It has nothing for a ledger that the twelve monthly statements do not already contain. Keep it as a check figure: the interest total on it should equal the sum of the interest lines across the converted monthly sheets.
How do I convert a Barclaycard card statement PDF to Excel?
Download the statement PDF from Barclaycard online banking or the app, drop it on this page, and wait about 10 to 40 seconds. You get every transaction in a table, a balance check against the printed opening and closing balance, and Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
Do I need a Barclaycard template?
No. The statement is read the way a person reads it, so Barclaycard layout changes do not break anything. What protects you is the balance check: opening balance plus money in minus money out must equal the printed closing balance, row by row.
Does it work with scanned Barclaycard statements?
Yes. Scanned PDFs and phone photos are read visually. Blurry pages may produce a flagged row; the check tells you exactly which one to look at.
Can I import Barclaycard transactions into Xero?
Yes. Download the .qbo file and use Upload from file in QuickBooks Online, or Web Connect import in QuickBooks Desktop. For Xero, download the Xero CSV and use Import a Statement on the bank account. Excel and CSV work everywhere else, including Sage.
How many Barclaycard 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.
What happens to my statement?
It is processed once and deletion is attempted as soon as processing finishes; an AWS lifecycle rule removes anything left behind. The extracted table becomes eligible for deletion after 7 days (1 day without an account). Nothing is used for training.