How to Import Credit Card Statements Into Xero (2026)

Xero is excellent at tracking credit card transactions once they're in the system. The problem is getting them there. Credit card statements arrive as PDFs — and Xero cannot read PDFs. You need to convert the statement to CSV format first, then import that CSV into Xero's bank feed.

The good news: the full pipeline from PDF statement to reconciled Xero transactions takes about 2 minutes per statement.

This guide walks through the complete process. If you're new to statement conversion, start with our credit card statement to Excel guide for an overview, then come back here for the Xero-specific steps.

Can Xero Import Credit Card Statements Directly?

Xero cannot import credit card statement PDFs directly. Xero accepts bank statement imports in CSV or OFX format only. Since credit card companies provide statements as PDF files, you need a conversion step in between: PDF statement → CSV file → Xero import. This two-step process takes about 2 minutes and works with any credit card issuer.

Xero does offer bank feed connections for many financial institutions, which automatically imports new transactions going forward. But bank feeds don't solve the problem of importing historical PDF statements — for those, the PDF-to-CSV conversion route is the only option.

Xero accepts these formats for statement import:

• CSV (comma-separated values) — most common
• OFX (Open Financial Exchange)
• QIF (Quicken Interchange Format)

Xero cannot import:

• PDF files
• Excel (.xlsx or .xls) files
• Images or scans

What Format Does Xero Need for Credit Card Imports?

Xero's CSV import requires three columns at minimum: Date, Description (or Payee), and Amount. The Amount column should use negative numbers for credit card charges (money going out) and positive numbers for payments and credits (money coming in). CreditCardToExcel's CSV export is already formatted to match Xero's expected structure.

Here is the exact format Xero expects:

Key formatting rules:

• Dates must be consistent — don't mix formats in the same file
• Amounts must be numbers (no currency symbols like $ in the amount column)
• Charges should be negative; payments and credits should be positive
• No blank rows between transactions
• The header row (Date, Description, Amount) must be the first row

How Do I Import Credit Card Statements Into Xero Step by Step?

Importing credit card statements into Xero takes three steps: download the PDF from your card issuer, convert it to CSV using CreditCardToExcel, then import the CSV into Xero via Account Transactions. The entire process takes about 2 minutes per statement, and the first 3 conversions are free.

Mapping columns in Xero's import wizard

When Xero shows you the column mapping screen, you'll see your CSV columns on the left and Xero's fields on the right. Set them as follows:

If Xero auto-detects the columns correctly (which it usually does), you can skip straight to confirming the import.

What If My Credit Card Transactions Are Already in Xero via Bank Feed?

If your credit card account is connected to Xero via a live bank feed, new transactions import automatically. You would only need to use the PDF-to-CSV method for historical periods not covered by the bank feed, or when the bank feed connection has gaps.

When to use PDF conversion even with a bank feed:

• Catching up on months before you set up the bank feed
• Filling in gaps during bank feed outages
• Importing transactions from a card you recently cancelled
• Verifying bank feed accuracy against official statements
• Taking over bookkeeping for a new client with no prior Xero history

Which Credit Card PDFs Work for Xero Import?

Any credit card statement PDF that CreditCardToExcel can convert will work for Xero import — which includes statements from all major US and international issuers. Chase, Amex, Capital One, Citi, Discover, Bank of America, Wells Fargo, Barclays, HSBC, Lloyds, and most other issuers are all supported.

Since Xero is widely used in the UK, Australia, and New Zealand, it's worth noting that international credit card statements work equally well. The AI converter handles pound sterling (£), Australian dollars (AUD), New Zealand dollars (NZD), and Euro (€) amounts correctly.

Reconciling After Import

Once the CSV is imported, the transactions appear in Xero's "Imported" tab within the credit card account. From here, the standard Xero reconciliation process applies:

1. For each transaction, Xero will suggest a match to an existing bill, invoice, or expense claim — or you can create a new transaction
2. Assign the correct account (expense category) from your chart of accounts
3. Add notes or attach receipts as needed
4. Click "OK" to reconcile

If you've imported a large number of transactions and want to reconcile them efficiently, use Xero's batch reconciliation rules. You can set rules like "all transactions from Slack go to Software Subscriptions" — which handles recurring charges automatically on future imports.

Importing Multiple Months into Xero

If you're catching up on a year's worth of credit card statements — common when taking over a new client's bookkeeping or preparing for year-end close — batch conversion saves significant time.

Efficient multi-month workflow:

1. Download all statement PDFs from your credit card issuer at once (most issuers let you download multiple months from the Statements page)
2. Upload them together using CreditCardToExcel's batch processing (available on Pro and Business plans)
3. Download the resulting CSV files as a ZIP
4. Import into Xero one CSV at a time, starting with the oldest statement

This workflow pairs well with the guidance in our stop manual credit card data entry guide, which covers how bookkeepers can use batch processing to handle multiple clients efficiently.

Troubleshooting Common Xero Import Errors

"Date format not recognized"

Xero is strict about date formats. If your CSV uses MM/DD/YYYY but Xero expects DD/MM/YYYY, the import will fail. CreditCardToExcel's CSV export uses YYYY-MM-DD (ISO format), which Xero accepts. If you've modified the file in Excel before importing, Excel may have reformatted the dates — redownload the CSV directly without opening it in Excel.

"Amount column contains non-numeric values"

This happens if the Amount column contains currency symbols (like "$42.50" instead of "42.50") or commas used as thousands separators (like "1,500.00"). CreditCardToExcel's CSV export uses clean numeric amounts without symbols or commas, so this error typically only occurs if you've edited the file manually.

"Transactions already exist"

Xero detected that some transactions in your CSV match transactions already in the account (either from a bank feed or a previous import). Review the duplicates Xero flagged and choose whether to import or skip each one.

Import succeeded but transactions are in the wrong account

During import, Xero asks which bank account to associate the transactions with. If transactions ended up in a checking account instead of the credit card account, delete the import from that account and repeat the import, selecting the correct credit card account.

Related Guides

• Credit Card Statement to Excel: The Complete Guide
• How to Import Credit Card Statements into QuickBooks
• How to Import Credit Card Statements Into Wave
• How to Categorize Credit Card Expenses for Taxes
• PDF to CSV: Convert Financial Documents
• Why Bookkeepers Should Stop Manual Data Entry
• Best Credit Card Statement Converters (2026)