Why are my Capital One dates showing the wrong month?

Capital One writes dates as YYYY-MM-DD, which some tools read as MM-DD-YYYY and mangle. The preset expects the ISO order, and if the file ever changes the converter falls back to the format it can actually detect in your rows.

Which date should I import by, transaction or posted?

The converter uses the transaction date, which is when you spent the money. If your bookkeeping follows the posted date, open the column mapper and point the date column at Posted Date.

Do I have to strip the Category column?

No. It is ignored. Capital One’s categories do not line up with your chart of accounts, and QuickBooks categorises in the review queue anyway.

Can I import several Capital One cards at once?

Convert one file per card and import each into its own QuickBooks account. Cards on the same login export separately, and mixing them in one register makes reconciliation harder later.

Is the file uploaded anywhere?

No. The CSV is read locally and the .qbo is generated in this tab; nothing about the statement is transmitted.

Capital One CSV to QBO

Capital One exports ISO dates and keeps charges and payments in separate columns; the converter below normalises both and produces a QuickBooks .qbo file without your statement leaving the browser.

Drop a CSV or Excel statement here

.csv, .txt, .xlsx and .xls — or choose a file

Choose file

Your file never leaves your browser.

The Capital One Credit Card preset is selected for you. Switch the Format dropdown to Auto-detect if you are converting a file from somewhere else.

How to export a CSV from Capital One

Sign in at capitalone.com and open the card account. The transaction list has a download control above it, usually labelled with a download icon.
Screenshot: capital-one-export-1
The Capital One account page with the download control above recent transactions.
Pick the period. Capital One lets you download a specific statement or a custom date range; statements are cleaner for reconciliation.
Choose CSV as the format — the other option is a Quicken or Microsoft Money file that QuickBooks Online will not take directly.
Screenshot: capital-one-export-2
The download dialog with CSV selected.
Save the file. It usually arrives as transaction_download.csv, so rename it if you handle several cards.
Drop it into the converter on this page. The Capital One preset is preselected, so the Debit and Credit columns and the ISO dates are handled.
Review the preview and download the .qbo file for QuickBooks Online.

Online banking screens change; if a label has moved, look for a download or export control above the transaction list.

Known quirks of the Capital One export

Capital One card exports have seven columns: Transaction Date, Posted Date, Card No., Description, Category, Debit and Credit. The converter reads the transaction date, the description and the two amount columns, and files Category as the memo.
Dates are written the ISO way, 2026-09-03, not the US way. The preset reads them as year-month-day; if a future export switches format, the converter notices that most rows failed to parse and re-reads the file with the format it detects, so a changed export degrades into a warning rather than an error.
The card number column is written as Card No. with a trailing period. It is not imported — only the last four digits appear there and QuickBooks has no field for it — but the exact spelling is one of the things worth re-checking after a Capital One redesign.
The file uses Intuit bank id 07028, the Capital One Credit Cards Web Connect entry in Intuit's financial institution directory. If the upload is refused, check that you picked a credit card account before re-exporting.

Import the .qbo file into QuickBooks

Open the upload screen. In QuickBooks Online, go to Transactions, then Bank transactions, and choose Upload from file (on older layouts: Banking, then the arrow next to Update, then File upload).
Pick the .qbo file. Drag the .qbo file the converter produced into the drop area and select Continue.
Choose the QuickBooks account. Select the bank or credit card account the transactions belong to, or add it first. The account type has to match the one used when converting: a card statement belongs to a credit card account.
Let QuickBooks read the file. Web Connect files carry their own column layout, so there is no column-mapping screen — QuickBooks reads the dates, amounts, payees and memos straight from the file.
Review and accept. The transactions land in the For review tab. Categorise or match them there; nothing hits the books until you accept them.

QuickBooks Online accepts up to 1,000 transactions per upload. Larger statements are split automatically into numbered files by the converter. Import errors are covered in the import error guide.

ISO dates are the thing to watch

Most US bank exports use month-first dates. Capital One does not: it writes 2026-09-03, which is unambiguous to a machine and invisible to a human skimming a preview. That is good news — there is nothing for the converter to guess — but it means a tool configured for US dates can silently produce a year of transactions dated in September.

The safeguard here is simple. The preset says ISO, and if most rows fail to parse that way the converter re-reads the file with the format it detects and tells you it did so in a warning. So a changed export shows up as a note above the preview rather than as a quiet corruption of your ledger.

Two amount columns, one ledger

Like Citi, Capital One keeps spending in a Debit column and payments and refunds in a Credit column, both as positive numbers. A Web Connect file has one signed amount per transaction, so the converter subtracts one from the other. Purchases end up negative, payments positive. Confirm that in the preview before downloading: it is the fastest check that the file will behave once imported.

Statements beat date ranges

If the goal is a clean reconciliation, export by statement rather than by custom range. Capital One cycles do not follow calendar months, and an off-by-one day at either end of the period is the difference between a balance that matches and an afternoon of hunting.

Frequently asked questions

Why are my Capital One dates showing the wrong month?: Capital One writes dates as YYYY-MM-DD, which some tools read as MM-DD-YYYY and mangle. The preset expects the ISO order, and if the file ever changes the converter falls back to the format it can actually detect in your rows.
Which date should I import by, transaction or posted?: The converter uses the transaction date, which is when you spent the money. If your bookkeeping follows the posted date, open the column mapper and point the date column at Posted Date.
Do I have to strip the Category column?: No. It is ignored. Capital One’s categories do not line up with your chart of accounts, and QuickBooks categorises in the review queue anyway.
Can I import several Capital One cards at once?: Convert one file per card and import each into its own QuickBooks account. Cards on the same login export separately, and mixing them in one register makes reconciliation harder later.
Is the file uploaded anywhere?: No. The CSV is read locally and the .qbo is generated in this tab; nothing about the statement is transmitted.

Other formats: QFX to QBO · QBO to Excel

Last updated September 22, 2026.