LedgerMatch
Capital One CSV Export: Column Layout & Reconciliation Guide
Capital One uses ISO 8601 date format (YYYY-MM-DD) while QuickBooks expects MM/DD/YYYY, so every date either parses incorrectly or throws an import error outright. Capital One also splits amounts into separate Debit and Credit columns rather than a single signed Amount. This tool auto-converts dates to MM/DD/YYYY and merges the split columns in one step — no spreadsheet manipulation required before importing.
CSV format at a glance
- Date format: YYYY-MM-DD
- Amount layout: separate debit and credit columns
- Separate Debit and Credit columns. Debit = money out; Credit = money in.
Where to export the CSV
Sign in → Accounts → select account → View Statements → Download → CSV
Common import issues
- Capital One has TWO format problems that independently break QuickBooks: YYYY-MM-DD dates (QuickBooks rejects them) and split Debit/Credit columns (QuickBooks needs a single Amount). Both must be fixed before importing.
- Capital One uses ISO 8601 date format (YYYY-MM-DD), not the MM/DD/YYYY format most other US banks use. LedgerMatch auto-detects this, but double-check the date column after mapping.
- Capital One exports are credit card only — there is no checking account CSV in the same format. Business checking exports use a different column layout with a single Amount column.
- The Category column contains Capital One's own categorization, not your accounting categories. Do not map this to your chart of accounts automatically.
- Capital One's "Posted Date" lags "Transaction Date" by 1–2 business days. Always use Transaction Date for reconciliation to match when purchases actually occurred.
Useful setup tips
- LedgerMatch auto-detects YYYY-MM-DD format. Verify dates look correct in the preview before finalizing your column mapping.
- Use the split-column mode in LedgerMatch: Debit → Debit Amount, Credit → Credit Amount.
- Ignore Posted Date, Card No., and Category columns during mapping.