Convert a Capital One statement to QBO
Capital One card downloads put charges and payments in separate Debit and Credit columns, and bank downloads use a different layout again. We handle both and write the right kind of account into the QBO file.
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
- Step 1
Upload
The CSV or Excel download from online banking, or a PDF statement.
- Step 2
Check
Free preview of every transaction as QuickBooks will read it: date, payee, signed amount.
- Step 3
Import
QuickBooks Online: Banking > Upload transactions. Desktop: File > Utilities > Import > Web Connect Files.
What you get
Transaction Date,Posted Date,Card No.,Description,Category,Debit,Credit 2026-03-04,2026-03-05,1234,STAPLES 00123,Merchandise,45.10, 2026-03-06,2026-03-06,1234,CAPITAL ONE AUTOPAY PYMT,Payment/Credit,,500.00
| Date | Payee | Amount |
| 2026-03-04 | STAPLES 00123 | -45.10 |
| 2026-03-06 | CAPITAL ONE AUTOPAY PYMT | 500.00 |
Getting your transactions out of Capital One
- Credit cards: on capitalone.com open the card, choose Download Transactions, pick the dates and the CSV format.
- 360 checking and savings: open the account and use the download option in the transaction list.
- Older history: monthly PDF statements are under Statements.
What Capital One CSVs look like
- Credit cards:
Transaction Date, Posted Date, Card No., Description, Category, Debit, Credit. Choose Credit card as the account type so charges increase what you owe. - Bank accounts:
Account Number, Transaction Description, Transaction Date, Transaction Type, Transaction Amount, Balance, with the type (Debit or Credit) in its own column and the amount unsigned. We apply the sign from the type.
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.
Questions
Which date is used
Does it work for Capital One Spark business cards?
Yes. Spark downloads use the same card layout.
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.