If your business spends on an American Express card issued in Canada, learning to import AMEX Card Canada statement PDF to Xero turns a monthly PDF into clean, reconciled books without an evening of typing. Canadian Amex statements mix charges in Canadian dollars with US dollar purchases, cross-border fees, and credits, and entering them by hand invites the exact errors that surface at tax time. A careful CSV import once a month gives you categorized expenses, a card balance you can trust, and a source document for every row.
This guide covers the Canadian route end to end: downloading the right statement from your Amex Canada account, converting it to a Xero-ready CSV, mapping the fields correctly, handling GST and HST by province, and reconciling the card account so nothing is double-counted. It also flags the Canada-specific traps, from US dollar charges that appear twice on the statement to employee cards that blur personal and business spending.
Download the right AMEX Card Canada statement
Start in your American Express Canada online account and open the specific card you want to import. Download the official monthly statement as a PDF for the billing period you need. The statement is the document of record: it shows the opening balance, the closing balance, every charge and payment, interest, and fees. An activity view or a mobile summary may look similar, but it can omit adjustments that appear only on the statement, and it does not give you the closing balance you need for reconciliation.
Download each card separately if you hold more than one Canadian Amex card, and keep one Xero credit card account per card. Employee supplementary cards usually appear on the same statement, so keep the full statement intact for conversion and sort out cardholder spending during the cleanup pass. Our AMEX Card Canada conversion guide explains the statement layout, including where converted foreign amounts appear.
Convert the PDF to a Xero-ready CSV
Upload the PDF to a statement converter and choose CSV output. Check the preview before downloading: every charge should be one row, payments should carry the opposite sign to charges, and the row count should roughly match the transactions printed on the statement. Repair any row split across a page break now, because a half-row in Xero becomes a mystery expense later.
For Canadian cards, the currency column needs attention. Amex Canada statements show US dollar and other foreign charges with both the original amount and the converted CAD amount, and Xero needs the CAD figure that affects your balance. Keep one date format for the whole file, strip currency symbols so amounts import as numbers, and drop the foreign amount column rather than importing both figures. Our AmBank conversion guide walks through the same preview checks for a bank account, and the discipline transfers directly.
Map the fields for a clean Xero import
In Xero, open the credit card account for this Amex card, choose to import a bank statement, and upload the CSV. Map Date to the transaction date, Description to the payee or description, and Amount to the amount, then study the preview. The first preview row should be a real charge, not a header, and the last row should be a real transaction, not a statement footer. Getting the mapping right on the first import saves you from fixing the same mistake on every row.
Confirm the account is set as a credit card account in CAD and that the statement period matches the file. Import one billing period at a time, oldest to newest, so the Xero running balance moves in the same order as the statement. When the import finishes, Xero places the rows in the reconciliation screen, ready for matching, coding, and bank rules. Recurring vendors such as fuel, software, and telecom are worth a bank rule on the first pass, because they turn next month into a short job.
Handle GST, HST, and cross-border charges
Canadian sales tax is the step that needs province awareness. Purchases in Ontario and the Atlantic provinces generally carry HST, while Alberta, British Columbia, and other provinces use GST plus provincial tax where it applies. In Xero, assign the tax rate that matches where the purchase was made and whether tax was actually charged, not a single default rate for the whole statement. Card fees, interest, and many financial charges carry no GST or HST, and coding them with a tax rate inflates your input tax credits.
Cross-border charges need a second look. A US dollar purchase appears on the statement with its converted CAD amount, and that CAD amount is the figure Xero should carry. If you already entered the same purchase as a bill in US dollars, post any small conversion difference to a currency gain or loss account instead of forcing the amounts to agree. Separate personal spending on supplementary cards from business spending during this same pass, and keep the statement filed with the month as the source document for every row.
Reconcile in Xero and avoid double-counted spending
Reconciliation proves the import worked. In Xero, reconcile the credit card account against the statement, and the Xero balance after coding must equal the statement closing balance. Work through the imported rows methodically, matching charges to bills and receipts, coding the rest, and checking the payment from your bank account carefully. That payment is a transfer from your bank account to the card account, not a new expense: the purchases were the expenses, and recording the payment as spending double-counts the entire month.
The other classic error is importing the same period twice, once from a bank feed and once from a file. Pick one import path per card account and stick to it, and if you switch paths, start the new path from a clean period boundary with no overlap. Our Amazon Synchrony conversion guide explains the same gap-hunting routine when a balance will not reconcile. A reconciled card account means your expense reports and tax filings rest on numbers you can defend.
Frequently asked questions
Can I import an AMEX Card Canada statement PDF directly into Xero?
Xero imports CSV files, not PDFs, so convert the statement PDF to a CSV first, then import that file into the credit card account for the card. The conversion preserves every transaction row and takes only a few minutes.
How do I handle GST and HST on Amex charges?
Use the tax rate for the province where the purchase was made, and only where tax was actually charged. Fees, interest, and many financial charges carry no GST or HST and should be coded with a no-tax rate.
What about US dollar charges on a Canadian card?
Import the CAD converted amount shown on the statement. The US dollar amount is useful context, but Xero needs the CAD figure that affects your card balance.
Should the card payment from my bank account be an expense?
No. Record it as a transfer to the card account. The purchases themselves were the expenses, and recording the payment as spending counts everything twice.
Canadian card statements should reconcile themselves. Convert your AMEX Card Canada statement to a Xero-ready CSV and import the billing period in minutes, with GST and HST coded by province from the start.