How do you convert a credit card statement PDF to Xero?

By Kayabyte · Last updated 11 November 2026

Short answer: Xero cannot import a PDF, so turn the statement into a CSV or OFX file first, then import it into the card account in Xero. The one trap that is specific to credit cards is the sign: many card statements print purchases as positive numbers, which is the opposite of a bank account, and Xero will show them as money received. Check one purchase in the preview before you import, and check that the statement’s own totals add up.

1. Try a download from the card issuer first

Look in your card’s online account for a download option on the transaction list (CSV, OFX or QFX). A file from the issuer is the most reliable source. Many issuers limit how far back you can go, which is why people are left with PDFs. If the file covers your period, skip to step 4.

2. The sign trap on card statements

On a bank statement money out is negative. A card statement often does it the other way round: purchases positive, payments and refunds negative. If you import that unchanged, your spending shows up as money in.

Xero’s own product ideas forum (checked 11 November 2026) has a request for a setting to reverse credits and debits when importing. It calls reversed debits and credits on import a common problem, says it is especially common with credit cards, and gives Xero’s workaround as editing the file in a spreadsheet, which the post says works only with CSV files and is error prone. The request had the status “submitted” on 3 April 2023, so do not expect a tick box in Xero: fix the sign in the file.

3. Check the totals before you import

Use the statement’s own numbers: previous balance + purchases - payments = new balance. If your converted rows do not give the new balance, something was dropped or flipped. A difference of exactly twice a single amount usually means one flipped sign. See why converted statements don’t add up.

4. Import into Xero

Xero’s CSV template uses a date column, an amount column and optional payee, description and reference columns. Download the current template from the import screen to see the exact headers. In Xero open the account, choose Import a Statement and select the file. Check the preview before you confirm, then compare the statement balance in Xero with the closing balance on the PDF. The details are in how to import a PDF bank statement into Xero.

5. Where Balanced helps

Balanced is a Mac app we make. It reads the card statement PDF on your Mac (a text PDF, or a scanned PDF or photo, read with Apple’s on-device text recognition), shows the table it found and checks the totals. For card statements it decides the sign from the balances, Debit and Credit columns, printed totals and CR marks; a statement that is already correct is never flipped. When those do not settle it, the status says Needs your answer and a box asks which way the statement works. You can also set it yourself with “Card statement (flip signs)” in the Columns bar. It remembers your answer for that account.

When the preview and the totals check are right, choose the Xero bank statement CSV (or OFX) from Export. No AI, no account, and the statement never leaves your Mac.

Limits: results depend on the statement’s layout, so check the preview. There is no direct sync into Xero, only the import file. A password-protected PDF must be unlocked first. The free version reads and checks everything and exports the first 5 transactions per file; Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs. macOS 15 or later. Download Balanced

Steps with Balanced

Open the card statement PDF in Balanced with Add Files or by dragging it in.
Check that purchases are negative in the preview. If the status says Needs your answer, answer the question in the box.
Read the totals check: previous balance plus purchases minus payments equals the new balance.
Export the Xero bank statement CSV (or OFX).
In Xero open the card account, choose Import a Statement, select the file, and compare the balances.

Questions

Can Xero import a credit card statement PDF? No. Convert it to CSV or OFX first.

Why do my card purchases show as money received in Xero? The statement printed purchases as positive numbers and the file was imported unchanged. Reverse the sign in the file.

Does Balanced connect to Xero? No. It writes the import file.

Xero is a trademark of its owner. Balanced is made by Kayabyte and is not affiliated with or endorsed by Xero.