LedgerPortConvert a Capital One CSV to QBO
Download your Capital One transactions as CSV, drop the file below, and get a QBO file QuickBooks can import. The file is converted in your browser and never uploaded.
Confirming your payment…
Your licence key. Keep it: it unlocks your other computers, and it is printed on your invoice.
Your file is read on this device. It is never uploaded.
| File | Transactions | Status |
|---|
More than one account? Give each its own number, and reuse it every time, so your software files each statement under the right account.
More file details (optional)
These only label the file. The default bank ID 3000 is one QuickBooks recognises; you still choose your real account during import.
Columns (change these if the preview looks wrong)
| Date | Description | Amount |
|---|
Not reading your file correctly? Send us the column names
Your pass has ended. Lifetime keeps you going for good, and the pass you bought is deducted from its price.
Your 10 free documents have been used. Unlock this file, and every file after it:
Pay with CardApple PayGoogle PayLink
14-day refund if it does not work with your file. Secure checkout by Stripe: card, Apple Pay or Google Pay, with an invoice by email. Your file stays open here while you pay.
Buying for a team? Firm plans start at 3 users, at $69 per user a year.
Your licence
- Never uploaded. The file is converted on your device; it works with the internet off.
- See it before you pay. Every transaction is previewed for free.
- 10 documents free. No card, no account, no key.
- 14-day refund if it does not work with your file.
Getting the CSV from Capital One
Sign in on the Capital One website, open the account, and look for the option to download or export activity. Choose the date range you need and pick CSV (sometimes labelled "Spreadsheet" or "Excel CSV") as the file type. Mobile apps often lack this option, so use a desktop browser.
How the Capital One file is read
Capital One card exports have the columns Transaction Date, Posted Date, Card No., Description, Category, Debit and Credit.
- Purchases sit in the Debit column and payments in the Credit column. The converter reads the pair and signs the amounts for you.
- Set Account type to Credit card.
- The posted date is used.
Importing the QBO file
QuickBooks Desktop: choose File → Utilities → Import → Web Connect Files, select the file, and pick the account. QuickBooks Online: go to Transactions → Bank transactions, open the menu next to Link account, and choose Upload from file. The import guide has the full steps, and there is a page on fixing import errors.
Need a different output? The same file converts to QFX for Quicken, OFX or QIF.
Questions and answers
Does Capital One see or approve this?
No. LedgerPort is an independent tool and is not affiliated with Capital One. It only reads the file you downloaded, on your own device.
What if my export looks different from the one described?
Banks change their exports from time to time. The converter works from the column names and the data rather than a fixed template, and you can reassign any column in the Columns panel.
Is it free?
Your first 10 documents are free, whatever their size, with no card and no licence key. After that, plans start at $9. See pricing.