# Import Credit Card Statement into Xero

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Xero imports
- Canonical: https://simplebankconvert.com/blog/import-credit-card-statement-into-xero

> How to import a credit card statement into Xero: set up the card as a bank account, keep charges negative and payments positive, then upload it.
To import a credit card statement into Xero, add the card as a bank account of the credit card type, then upload a CSV or OFX file of its transactions through that account's Import a statement option. Purchases must be negative and payments to the card positive. Finish by checking Xero's card balance against the statement's new balance.

## Setting up the credit card as a Xero bank account

Xero keeps a credit card in the same list as your checking and savings accounts, as a bank account whose type is credit card. Every card you use for the business needs its own account there before any statement can be imported, because the import option lives on the account itself.

### Adding the card

From Bank accounts in Xero, choose to add a bank account. Xero will usually offer to connect to your bank; if you plan to import files instead, look for the option to add the account without a feed. Pick credit card as the account type. Give it a name that says which card it is, such as "Visa business card 2290", using the last four digits printed on the statement.

### One account per card, not per cardholder

If two people carry cards on the same account, most issuers send one statement and one balance for both. In that case one Xero account matches the statement. If each card has its own statement and its own balance, give each its own Xero account. The test is simple: one Xero account per statement balance.

### The starting balance

Your first imported statement starts from whatever balance the card had on its opening date. If the card carried a balance before you started using Xero, that opening figure belongs in your conversion balances, not in a fake transaction. Note the previous balance printed on the first statement so you can check it later.

## Which signs should credit card charges and payments carry in Xero?

In a Xero credit card import, a purchase is negative and a payment to the card is positive, the same way round as a bank account. Money you spend reduces what you have; money you pay in reduces what you owe. Refunds from merchants are positive too, because they lower the balance.

### The rule from the file standard

This is not a Xero quirk. The [OFX 2.2 specification](https://financialdataexchange.org/wp-content/uploads/2025/12/OFX-2.2.pdf) says transaction amounts are signed from the customer's point of view, and gives the example that a credit card payment is positive while a credit card purchase is negative. A card OFX download from your issuer should already follow that rule. A CSV may not.

### Why statements look the other way round

A card statement is written from the issuer's point of view. It lists your purchases as positive numbers, because each one adds to what you owe them, and shows payments with a minus or a "CR" mark. Many card CSV downloads copy that layout. If you upload it as it is, every purchase lands in Xero as money coming in.

### A worked example

The rows below are made-up lines from an example card statement, with the amount as printed and the amount the Xero CSV needs.

| Date | Statement line | Amount as printed | Amount for the Xero CSV |
| --- | --- | --- | --- |
| 2026-09-03 | Tidewater Fuel | 64.10 | -64.10 |
| 2026-09-07 | Northgate Software subscription | 29.00 | -29.00 |
| 2026-09-11 | Payment received, thank you | -1,200.00 | 1200.00 |
| 2026-09-15 | Tidewater Fuel refund | 18.00 CR | 18.00 |
| 2026-09-30 | Interest charge | 11.42 | -11.42 |

Every line flips except where the printed mark already meant what Xero needs. Check two or three rows of your own file against this pattern before you upload.

## Turning a credit card statement into a Xero CSV

A Xero CSV for a card is the same as one for a bank account: a header row, then one transaction per row with a date, one signed amount, and optional payee, description and reference columns. Start from the issuer's CSV download if there is one, fix the signs, and save it again as CSV.

### Columns to keep

Keep the posting date, the merchant name as payee, any extra text as description and a reference number if the issuer prints one. Delete running totals, rewards points columns and summary rows at the bottom, which are not transactions. Use one amount column. If the download has separate charge and credit columns, combine them into one signed column using the rule above.

### Flipping the signs in a spreadsheet

If every amount is backwards, add a new column next to it and fill it with the old amount multiplied by minus one. Copy the new column and paste it as values over the old one, then delete the helper. Check the payment row afterward: it should now be positive.

### When the statement is only a PDF

Many card issuers give older statements as PDFs only. The rows then have to be pulled out of the PDF first. [Converting a PDF statement to OFX](/blog/pdf-to-ofx) covers what that involves, and explains when a CSV is the simpler result. SimpleBankConvert is being built to read PDF statements from US banks and credit cards and hand back a CSV shaped for Xero, with money going out shown as a minus; you can sign up on the [get started page](/get-started) to hear when it opens.

## Uploading the card file and checking the Xero card balance

Upload the file from the card's own account in Xero, using the account's menu and then Import a Statement, the same as for any bank account. Then prove it is complete by comparing balances: the balance Xero shows for the card should equal the new balance on the statement, written as a negative number.

### The balance check, worked

Using the example table, say the previous statement balance was 1,450.00 owed. The new balance is the old balance plus purchases and interest, minus payments and refunds: 1,450.00 + 64.10 + 29.00 + 11.42 − 1,200.00 − 18.00 = 336.52 owed. In Xero, money owed on a card shows as a negative balance, so the figure to look for is -336.52. These numbers are examples.

### If the balance is off

- **Off by twice a single amount.** One line has the wrong sign. A 64.10 purchase entered as positive moves the balance by 128.20.
- **Off by one exact amount.** A line is missing or doubled. Look at the first and last days of the file.
- **Off by the opening balance.** The card's starting balance was never set up in Xero.

### Cards with a feed as well

If the card also has a live feed in Xero, import only dates the feed does not cover. The same boundary rule applies as for bank accounts: start the file the day after the last line Xero already has.

## Why does a credit card payment appear twice in Xero?

A card payment shows twice because it really touches two accounts: it leaves your checking account and arrives in the card account. That is correct. It only becomes a double count if you code each side as an expense or income. Both lines should be reconciled as one transfer between the two accounts.

### What it looks like

After importing both statements for September, the checking account shows "Payment to Visa 2290, -1,200.00" and the card account shows "Payment received, 1200.00". Both are genuine statement lines. Neither is a duplicate.

### How to record it

When you reconcile the checking account line, record it as a transfer to the card account rather than as spending. Xero then has a transfer that can match the card's statement line too. Code it once as a transfer and both sides are explained, with no expense and no income.

### The mistake to avoid

Coding the checking-account side as "credit card expense" and then also coding every purchase on the card counts the same spending twice. Your expenses go up by the payment amount for no reason. If your profit looks too low after importing card statements, search your expense accounts for card payments.

### Other payment accounts behave the same way

PayPal and Stripe balances follow the same pattern: money moves between a payment account and your bank, and each move is a transfer. [Importing PayPal transactions into Xero](/blog/import-paypal-transactions-into-xero) and [importing Stripe transactions into Xero](/blog/import-stripe-transactions-into-xero) apply that idea to those services.

## Interest, annual fees and rewards credits on a Xero card import

Card statements carry lines that are not purchases from a merchant: interest, annual or late fees, cash advance fees and rewards credits. Import them like any other line, with the same sign rule. The difference is in how you code them when reconciling, so they land in the right expense or income account.

### How each one usually lands

- **Interest charges.** Negative in the file. Usually coded to an interest expense account.
- **Annual and late fees.** Negative. Usually coded to bank or card fees.
- **Cash advances.** Negative on the card, and positive in whatever account received the cash. Treat it as a transfer if the cash went to your business bank.
- **Rewards or cashback credits.** Positive. How to code them is a question for your accountant, since practice varies.

Ask your accountant which accounts to use for these. The import only needs the signs right.

### Lines that are not transactions

Statements also print the minimum payment due, the credit limit and the payment due date. None of these are transactions, and none belong in the CSV. If a converted file includes them as rows, delete those rows before uploading.

### A note on what imports carry

A statement import brings in money that moved. It does not create documents such as quotes or sales invoices. Those are imported a different way in every accounting program; in QuickBooks Online, for example, [importing estimates](/blog/import-estimates-into-quickbooks-online) is a separate tool from the bank upload.