Convert credit card CSV to QBO

Turn the CSV you download from your card company into a .qbo file that imports into a QuickBooks credit card account, with charges and payments the right way round.

Free, no sign-up
Your file never leaves your computer
Fixes reversed charge signs

Drop your credit card CSV here or click to choose a file. Excel files work too.

Converted in your browser. Nothing is uploaded. No file handy?

File:

Check that we read your columns correctly

One amount column Separate debit and credit columns

Date Description Amount Memo optional

Tell us about the account

Account type Account number last 4 digits is enough Date format in your file

Reverse signs (use if charges show up as deposits)

Advanced settings

QuickBooks bank ID change only if QuickBooks rejects the file Routing number optional

Preview
Date	Description	Amount

How to import the QBO file into QuickBooks

QuickBooks Online

Go to Transactions, then Bank transactions.
Open the Link account menu and choose Upload from file.
Select the .qbo file you downloaded here.
Pick the credit card account in QuickBooks, not a bank account.
Review the transactions in the For review tab and add or match them.

QuickBooks Desktop

Back up your company file first.
Go to File, then Utilities, Import, Web Connect Files.
Select the .qbo file you downloaded here.
Choose an existing account or create a new one.
Review the transactions in the Bank Feeds Center.

If the account is already connected to online banking, QuickBooks Desktop may ask you to disconnect it before importing.

How to download a CSV from your card company

American ExpressGo to Statements & Activity, choose the period, select Download, and pick CSV.
ChaseOpen the card account, select the download icon above your transactions, choose the spreadsheet (CSV) file type and a date range.
Capital OneOpen the card, choose Download Transactions, then pick CSV and the date range.
Other cardsLook for Download, Export or Statements on the card's activity page, and choose CSV or Spreadsheet.

Card websites change their menus from time to time. If a step looks different, look for a Download or Export button near your transactions.

Why credit card CSVs need special handling

Card companies don't agree on signs. American Express and some others list charges as positive numbers and payments as negatives, while others do the opposite or split them into separate debit and credit columns. QuickBooks expects charges to reduce what you have and payments to increase it, so a file with the wrong convention imports every purchase as a refund.

This converter looks at your file, and when most amounts are positive it reverses the signs for you. The preview shows charges in red before you download, so you can check the result at a glance.

Questions

Which credit cards does it work with?

Any card that lets you download transactions as CSV, including American Express, Chase, Capital One, Citi, Discover, Bank of America, Wells Fargo, US Bank and store or business cards.

My charges came in as payments. How do I fix it?

Check "Reverse signs" before downloading, and the preview will show charges in red. Then download the file again and import the new one.

Should I import into a bank account or a credit card account?

Always a credit card account. QuickBooks won't let you import a credit card QBO file into a checking account, and the balances would be wrong if it did.

Is my data safe?

Your file is read and converted inside your own browser. It is never uploaded to a server, so nobody else can see your transactions.

Is it free?

Yes. Convert as many card statements as you need, with no sign-up.