How to convert a Capital One CSV to QBO
Read a Capital One checking or card CSV, with debit and credit columns, into QuickBooks.
- 1
Download the transaction CSV
Capital One uses one layout for checking and for cards: Transaction Date, Posted Date, Card No., Description, Category, Debit, and Credit. The number sits in Debit or in Credit, not in both.
- 2
Upload it
The header selects the Capital One preset. The date in the download is the posted date. A debit is money out and a credit is money in.
- 3
Set the account type
The shared layout is read as a card. If the file is a checking account, switch Account to Checking before you download so QuickBooks offers a bank register.
- 4
Download QBO
Import the QBO file into QuickBooks Desktop with Web Connect. For QuickBooks Online, download the 4-column CSV, which keeps the credit and debit pair.
- The card number column is not written into the QBO payee. It is only used to recognize the file.
Questions
Why is a debit negative?
QuickBooks treats money out as a negative amount. A debit in this file is money leaving the account, so it is stored as a negative.