Skip to the converter
StatementZap

Guides

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. 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. 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. 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. 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.

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.