Convert Barclaycard card statement PDFs to Excel, Xero and CSV.
Xero, QuickBooks Online, Sage files from the PDF.
Barclaycard does not lock the statements you download from Barclays Online Banking or the app. 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.
Drop your Barclaycard card 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 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 of Barclaycard statements at once come back as one workbook.
Is the Barclaycard 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.
Why not 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.
Where Barclaycard statements trip up 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.
Which software Barclaycard customers import into
Barclaycard 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
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 it from Barclaycard 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 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.