How to Import Corporate Card Transactions into QuickBooks

Corporate card programs like Brex, Ramp, American Express, and Capital One Spark are everywhere now, and most of them promise a one-click QuickBooks sync. When that sync stalls, the symptoms look the same across cards, whether it is a Chase business card that stops updating or an Amex that will not connect. For ongoing,single-entity books that sync is fine. The trouble starts the moment you need an older period, a second legal entity, or QuickBooks Desktop. This guide walks through every reliable way to get card spend into QuickBooks, and when each one is the right call.

Why the live card sync is not always enough

A direct connection between a card platform and QuickBooks Online pulls new transactions automatically, which is genuinely convenient. But these connections share a few hard limits that catch finance teams off guard:

• One account, one company. A single Brex or Ramp account links to only one QuickBooks Online company at a time. Run several entities and the rest cannot use the sync.
• History does not backfill. Transactions that posted before you connected, or under a previous accounting firm's setup, usually never flow in on their own.
• Desktop is left out. QuickBooks Desktop accepts bank data only as a QBO, QFX, or OFX file. The CSV export most card platforms give you will not import as a bank feed.

When you hit any of these, the export-and-convert route is the dependable fallback. It works from the statement itself, so it is not bound by what the sync chose to send.

How do I import corporate card transactions into QuickBooks?

Export the card activity as a PDF statement or CSV, convert it to a QBO file, then upload that file to the right credit card account in QuickBooks. The conversion step matters because QuickBooks treats a QBO file as a clean bank feed import, with no field mapping, while a raw CSV has to be mapped column by column and often fails on date formats or split debit and credit columns. You can convert a statement to QBO with a Brex and Ramp statement to QuickBooks converter or, for any issuer, the general credit card statement to QuickBooks tool.

Should card spend go in a bank account or a credit card account?

Use a Credit Card type account, not a Bank account. A corporate card is a liability: you owe the balance until it is paid. Setting it up as a Credit Card account in your chart of accounts keeps the sign of each charge and payment correct, and it lets you reconcile to the statement closing balance the same way you would a checking account. If you import card transactions into a bank account by mistake, the charges and payments land on the wrong side and reconciliation will not tie out.

How do I bring older card transactions into QuickBooks?

Download the archived statement or export the older date range from the card platform, then convert each period to a QBO file and import it. The live sync backfills only a short recent window, if anything, so catch-up bookkeeping and audit prep almost always mean working from saved statements. Converting them to QBO gives QuickBooks the dates and amounts already formatted, so a year of backlog imports in a single sitting instead of being keyed in by hand. A batch converter handles a stack of months in one pass.

How do I import card spend into a second QuickBooks company?

Export that entity's transactions to a file and import them, because the live sync can only feed one company. This is the documented workaround from the card platforms themselves for multi-entity setups. Export each entity's activity, convert it to a QBO file, and upload it under Bank transactions in that entity's QuickBooks company. The exact steps to import a QBO file into QuickBooks are the same for each company. Every set of books then reflects its own spend, with no transactions bleeding across entities.

Can I import card transactions into QuickBooks Desktop?

Yes, but not from a CSV. QuickBooks Desktop imports bank and card data only as a QBO, QFX, or OFX file, so the CSV export from a card platform will not work as a feed. Convert the statement to a QBO or IIF file first, then import the QBO through Web Connect or the IIF under File, Utilities, Import, IIF Files. If you are weighing the two platforms, our comparison of QuickBooks Online vs Desktop bank imports spells out what each version accepts, and our PDF statement to QuickBooks Desktop guide covers the full Desktop import in detail.

What about the receipts attached to each charge?

Card platforms collect receipts and memos alongside transactions, and those can sync to QuickBooks separately. When you import card activity from a converted statement, match each transaction in the For Review tab to the receipt that belongs with it before you reconcile. If your receipts are sitting in email or a folder rather than in the card app, you can digitize them first: a receipt OCR tool that pushes data to a spreadsheet, like receiptocr.ai, turns a pile of receipts into a clean list you can reconcile against the card register. For teams running heavy vendor spend, pairing card imports with accounts payable automation keeps bills and card charges from being double counted.

What if I only have a CSV, not a PDF?

A CSV works fine as a source. Both Brex and Ramp export CSV, and so do most card platforms. You can map a CSV into QuickBooks Online directly, but the three-column date, description, and amount mapping is fussy and a failed import has to be undone row by row. Converting the CSV to a QBO file first avoids the mapping entirely. If your books live in a different format and you just need the CSV reshaped for QuickBooks, a dedicated CSV to QBO converter handles that step.

A simple workflow that always ties out

Whichever card you run, the same five steps keep the books clean:

1. Export the period from the card platform as a PDF statement or CSV.
2. Convert it to a QBO file (or IIF for QuickBooks Desktop) and review the transactions before export.
3. Import the file into the Credit Card account that matches the card.
4. In the For Review tab, categorize each charge and match it to any synced receipt.
5. Reconcile the card to the statement closing balance so the period ties out to the penny.

Done this way, it does not matter whether the live sync covered the period, the entity, or the platform. The statement is the complete record, and a converted QBO file gets every line of it into QuickBooks.