How to import a credit-card statement into Xero

Xero has a clean, lenient CSV import for bank and credit-card statements — which is great, except that “lenient” means it'll happily accept a file with the wrong date format or wrong sign convention and silently mis-import every row. This guide walks through the actual end-to-end workflow: PDF in, Xero-ready CSV out, transactions matched and reconciled.

The short version

1. Download your credit-card statement from online banking as a PDF.
2. Convert it to a Xero-formatted CSV using our converter (or a paid alternative).
3. In Xero: Accounting → Bank accounts → your card → Manage account → Import a statement.
4. Map the columns, confirm the date format, hit Import.
5. Reconcile the transactions against your records.

Step 1: Get the PDF

Sign in to online banking, find your credit-card statements, and download the period you want as a PDF. Most banks let you download statements going back several years through the PDF download; if you only see a 90-day CSV export option, the PDFs typically go back much further.

Step 2: Convert PDF → Xero CSV

Xero accepts a specific bank-statement CSV format with five required columns:

• Date — preferably YYYY-MM-DD to avoid date-format confusion
• Amount — money out (purchases) negative, money in (payments) positive
• Payee — the merchant or person
• Description — usually the same as Payee
• Reference — optional, often the transaction ID

Either upload the PDF to our converter and click the Xero tab on the results (Download → ready-made Xero CSV with dates already as YYYY-MM-DD and signs flipped), or use a paid alternative.

The sign convention is the opposite of your statement

Xero, like every accounting tool, treats credit-card transactions from the liability account's perspective. So in the CSV: a $32.69 lunch on your card is −32.69, and a $500 payment you make toward the card balance is +500. That's the opposite of how most people read their statement, but it's correct.

If you're manually exporting CSV from somewhere and the signs are backwards, swap them before importing. Our converter does this for you automatically when you pick the Xero tab — there's a one-line note right above the preview explaining what changed.

Step 3: Import in Xero

From the main menu: Accounting → Bank accounts → click the credit-card account → Manage account → Import a statement.

Then the column-mapping screen:

• Date format:set this to match what's in your CSV. If you used YYYY-MM-DD (the safe default), pick that. The single most common Xero import mistake is leaving the date format on UK/US default and importing a CSV that's the opposite — Xero will happily import 1/2/2026 as January 2nd in one country and February 1st in another.
• Column mapping:Xero looks at the header row for these column names and auto-maps. If a column isn't auto-recognised, pick the right one from the dropdown.
• Amount: for a single signed Amount column (the simple case), pick that. If your CSV has separate Debit/Credit columns, point Xero at both.

Click Save, and Xero parses the rows into Awaiting Match transactions on the bank-account reconciliation page.

Step 4: Match and reconcile

From the bank-account dashboard, click Reconcile X items. Xero shows each imported transaction next to anything it found a match for (existing bills, expense claims, transfers).

For transactions without a match, you can:

• Match against an existing transaction in Xero,
• Create a new spend-money transaction with a category, or
• Transfer — for the statement payment, where the money came from a bank account already in Xero.

Once everything's green, you're reconciled. The credit-card balance in Xero should match the statement's ending balance.

One more pitfall: duplicate imports

Xero is good at flagging duplicates but not infallible. If you re-import an overlapping period, you can end up with two of every transaction in the overlap. The safest workflow is to import statement periods strictly once, in order, with no overlap. Our converter shows the statement period's start and end at the top of the preview so you can keep track.

That's the whole flow

Once you've done it once, a year of monthly statements is roughly 20 minutes of work: 12 downloads, 12 conversions, 12 imports. Make a habit of doing it the first week of every month and you'll never face a year-end pile-up again.