Convert a Capital One statement to Excel, CSV or QuickBooks
Capital One runs two products that share a brand and almost nothing else. A 360 bank statement and a Capital One card statement are laid out differently, export differently, and break differently.
Covers 360 Checking and 360 Savings, Venture, Quicksilver and Savor cards, Spark business cards.
Drop a PDF bank statement here
Only pages with transactions count against this.
Review
Example statementHabib Bank Limited · 0441-79002251-03 · 2026-04-01 to 2026-04-30
- Row-by-row running balance
- Page subtotals
- Opening + movement = closing
- Printed credit / debit totals
- Printed credit / debit totals
- Transaction count
Arithmetic only. Verifies that amounts, balances and totals agree. Does not verify descriptions or dates, and cannot detect two errors that cancel out.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Apr 02, 2026 | IBFT TRANSFER FROM ZAINAB TRADERS / INV-4471 | PKR 185,000.00 | PKR 1,247,350.00 | |
| Apr 03, 2026 | POS PURCHASE 4157 IMTIAZ SUPER MARKET KARACHI | PKR 12,480.00 | PKR 1,234,870.00 | |
| Apr 05, 2026 | UTILITY PAYMENT K-ELECTRIC ACCOUNT 04412297 | PKR 38,640.00 | PKR 1,196,230.00 | |
| Apr 08, 2026 | CHEQUE 000241 CLEARED — AL-NOOR PACKAGING | PKR 220,000.00 | PKR 976,230.00 | |
| Apr 11, 2026 | IBFT TRANSFER FROM MEHRAN ENTERPRISES / PO-8890 | PKR 342,500.00 | PKR 1,318,730.00 | |
| Apr 14, 2026 | SALARY DISBURSEMENT APRIL 2026 — 11 EMPLOYEES | PKR 685,000.00 | PKR 633,730.00 | |
| Apr 17, 2026 | BANK CHARGES — ONLINE TRANSFER FEE | PKR 1,150.00 | PKR 632,580.00 | |
| Apr 21, 2026 | IBFT TRANSFER FROM SIDDIQUI BROTHERS / INV-4488 | PKR 128,750.00 | PKR 761,330.00 | |
| Apr 24, 2026 | POS PURCHASE 9921 TOTAL PARCO FUEL STATION | PKR 18,900.00 | PKR 742,430.00 | |
| Apr 28, 2026 | PROFIT CREDITED — SAVINGS ACCOUNT | PKR 4,318.00 | PKR 746,748.00 | |
| Closing balance10 transactions | PKR 746,748.00 | |||
Export
Preview is free. Create a free account to download.
Guest plan · preview only, no downloads
Two date columns, and the wrong one lands transactions in the wrong month
Capital One card statements print a transaction date and a posting date, and across a month boundary they disagree — a purchase on 31 January posts on 2 February. Which one belongs in your books depends on the basis you keep them on, and a converter that silently takes the first column it finds makes that decision for you. On a December statement that decision moves revenue or expenditure across a year end. Check which column was used before the first import of the year, not after. Separately, the Debit and Credit columns in card exports are both positive numbers with the sign implied by the heading; read as one column they invert every payment.
How a Capital One statement is laid out
Worth checking against the statement in front of you — Capital One issues more than one layout, and which you have changes what to look for after converting.
| Date format | MM/DD/YYYY |
|---|---|
| Running balance | Present on 360 bank statements, absent on card statements |
| Amount columns | Card exports commonly use separate Debit and Credit columns; bank statements use one signed column |
| Card sections | Card statements separate transactions from fees and interest charged |
| Posting vs transaction date | Card statements print both; they differ across month ends |
Downloaded activity and statements are not the same thing
Every large US bank offers two different exports, and people reach for the wrong one constantly. Downloadable account activity — CSV, and often QFX or OFX — covers a recent window, typically a few months, and stops. Statements are PDFs, are issued per period, and go back years. If you need last March, the activity export will not have it and the statement will; converting the PDF is how that gap is closed.
CSV for Capital One
CSV lets you see which date column and which sign convention came through before the rows reach your ledger — worth it on the first statement, at least.
Convert to CSVQuestions
- Which date should I use, transaction or posting?
- Whichever matches how you keep the books. The important thing is consistency: mixing the two across months produces a reconciliation that never quite agrees and no obvious culprit.
- My payments came through as charges. Why?
- Separate Debit and Credit columns of positive numbers, read as a single amount column. The sign is in the heading, not the number, so it is lost unless the columns are read as a pair.
- Is a 360 statement different from a card statement?
- Materially, yes. Different layout, different columns, and a running balance on one but not the other. Do not assume a conversion that worked for one will behave the same on the other.