Skip to content

Convert a credit card statement to QBO

Credit cards are where most QuickBooks imports go wrong. Card statements print charges as positive numbers, and the file needs a credit card section, not a bank one. We fix both.

Columns (only if we guess wrong)

Column numbers in your CSV or Excel file, counting the first column as 1.

No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.

How it works

  1. Step 1

    Upload

    The CSV or Excel download from online banking, or a PDF statement.

  2. Step 2

    Check

    Free preview of every transaction as QuickBooks will read it: date, payee, signed amount.

  3. Step 3

    Import

    QuickBooks Online: Banking > Upload transactions. Desktop: File > Utilities > Import > Web Connect Files.

What you get

Card statement (PDF)
03/04  STAPLES 00123                 45.10
03/06  PAYMENT - THANK YOU         -500.00
As QuickBooks will read it (credit card)
DatePayeeAmount
2026-03-04STAPLES 00123-45.10
2026-03-06PAYMENT - THANK YOU500.00

Getting the signs right

  • In a QuickBooks credit card account, a charge increases what you owe and a payment or refund reduces it. We write charges as negative and payments as positive in the QBO file, which is how QuickBooks reads card files.
  • If your card's CSV already uses that convention, nothing is flipped. The preview shows every amount before you pay.

Cards that work

American Express, Chase, Citi, Capital One, Discover, Bank of America, Wells Fargo, U.S. Bank and store or business cards. Any card that gives you a CSV, an Excel file or a PDF statement.

Pricing

Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.

  • 1 file

    $9 per file

    $9

  • 10 filesBest value

    $2.90 per file

    $29

  • Unlimited files every month

    $0.08 per file, billed monthly, cancel any time, fair use 500 files a month

    $39/mo

Deleted after 24 hours

Your upload and the result are removed automatically.

Never used for training

Files are processed only to make your result.

Refund if it is wrong

If a result is unusable, we fix it or refund you.

Privacy policy · Refund policy

Questions

Do I need a credit card account in QuickBooks?

Yes. Import the file into a credit card account, not a bank account. Choose Credit card as the account type here.

Can I convert an American Express statement?

Yes. Upload the Amex CSV or PDF statement and choose Credit card.

Is my statement kept?

No. Files are deleted automatically 24 hours after upload and never used to train AI.

How much does it cost?

The preview is free. $9 per file, $29 for 10 files, or $39 a month for unlimited files.

Does it work with QuickBooks Online and QuickBooks Desktop?

Yes. The same QBO (Web Connect) file imports in both. QFX for Quicken and OFX for Xero download from the same conversion.

Is this made by Intuit or my bank?

No. This is an independent tool. QuickBooks and Quicken are trademarks of Intuit Inc.; bank names are used only to describe their files.