# Convert Capital One CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/capital-one.html_

Capital One makes CSV export straightforward, on a credit card you click Download Transactions and pick CSV, while Capital One 360 checking and savings offer a similar export. What it doesn't offer is a direct QuickBooks Web Connect (.QBO) download, so to get Capital One activity into QuickBooks you'll be working from the CSV.Capital One's credit-card CSV uses the columns Transaction Date, Posted Date, Card No., Description, Category, Debit, and Credit, note the separate Debit and Credit columns and the two date columns. The 360 bank-account CSV is simpler (date, description, amount, balance). Either way, QuickBooks Online's importer wants a single date and a single signed amount, so a raw Capital One CSV needs reshaping before it'll import without errors.QBO Maker handles both layouts: it picks the right date column, merges Debit/Credit into one signed amount, and writes a clean, valid .QBO (OFX) file QuickBooks accepts. The whole conversion runs in your browser, nothing is uploaded. Convert your Capital One CSV now.

## Steps

1. Export your transactions from Capital One online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**Can I download a QBO file from Capital One?**
No, Capital One doesn't offer a QuickBooks Web Connect (.QBO) download. You export CSV from the Download Transactions option, then convert it. QBO Maker turns that Capital One CSV into a valid .QBO QuickBooks imports directly.

**How does QBO Maker handle Capital One's Debit and Credit columns?**
It merges them into one signed amount: values in the Debit column become negative (money out) and Credit values become positive (money in), matching what QuickBooks expects. No manual column math required.

**Capital One gives two date columns, which one is used?**
Card exports include both Transaction Date and Posted Date. QBO Maker uses a single, consistent date for each transaction so QuickBooks won't create duplicate or mismatched entries during reconciliation.

**Does my Capital One data leave my computer?**
No. The conversion is 100% client-side in your browser. Your Capital One transactions are never uploaded to or stored by QBO Maker. See importing the result into QuickBooks Online.

---
Convert free at https://qbomaker.com/#tool, runs entirely in your browser.