Credit card statement PDF to Excel or CSV
Drop a UK credit card statement PDF below. Brought Forward reads it on your computer, checks the transactions against the statement’s previous and new balance, and downloads a CSV for Excel or a file for Xero, QuickBooks, FreeAgent, OFX or QIF. Nothing is uploaded.
Beta: built from the published layout, not yet tested on a real statement. Generated statements in each issuer’s layout read perfectly. A card statement has no running balance, so the check is the statement’s own sum: previous balance, plus new spending, less payments and refunds, must equal the new balance to the penny. If yours doesn’t, you’ll see it straight away, and the one-click report (issuer name only) tells us to look.
Why convert a card statement?
Card issuers usually let you download only the last few months of transactions as a spreadsheet. Anything older, and the statement itself, comes as a PDF. Bookkeepers catching up a client’s card, or anyone moving into new accounting software, end up retyping it. Brought Forward reads the PDF instead.
Issuers
- American Express
- Barclaycard
- Capital One
- MBNA
- HSBC credit cards
- Lloyds credit cards
- Halifax credit cards
- NatWest credit cards
- RBS credit cards
- Tesco Bank credit cards
All of these are built from the issuers’ published statement layouts and tested on generated statements, not yet on real ones. Other cards often read too: the reader finds the date, description and amount columns from the table’s header row.
How it’s checked
A card statement has no running balance beside each row, so rows can’t be ticked one by one. Instead the statement is checked against itself: the previous balance, plus purchases, interest and fees, less payments and refunds, must come to the new balance exactly. A misread figure or a missing page shows up as a difference.
Foreign-currency spending keeps its original amount and exchange rate in the description, and the non-sterling fee stays its own row. Lines such as the minimum payment and credit limit are left out.
Into your accounts
- Excel: the CSV opens directly, with money in and money out in their own columns.
- Xero, QuickBooks and FreeAgent: import into a credit-card account. Purchases come in as spending and payments as money in.
- OFX and QIF: written as a credit-card statement, for Moneydance, GnuCash, Quicken and other money apps.
Questions
- Is my card statement uploaded anywhere?
- No. It’s read by your browser on your computer. The page is allowed to talk only to the licence server and a cookie-free page counter, and neither receives anything from your statement.
- Which way round are the amounts?
- As your accounts see a card: purchases, interest and fees are money out (negative), and payments and refunds are money in (positive). Xero, QuickBooks and FreeAgent all expect a credit-card account that way round. The OFX file uses the credit-card statement type, and the QIF file the credit-card account type.
- How much does it cost?
- Three statements a day are free. Pro is £8 a month or £69 a year for as many as you like, bank or card.
Last checked 28 October 2026.