Capital One credit card, Spark and 360 statements
Convert Capital One statements to Excel, CSV and QuickBooks
Capital One shows two years of 360 activity and keeps seven years of statements. Converting the PDFs gets the rest into Excel or QuickBooks — card cycles checked against their totals, 360 statements against the balance.
- Venture, Quicksilver, Savor and Spark card cycles
- Transaction date or posting date, chosen on purpose
- Card statements checked against the printed totals
- 360 Checking and Savings checked against the running balance
7 years
of card statements online
For active accounts
2 years
of 360 activity on the website
Older 360 activity is in the statements
Quicken · QuickBooks · Excel
download formats Capital One names
On its business card pages
Trans · Post
two dates on each card row
They split across month ends
The short answer
Can you export a Capital One statement to Excel yourself?
You can export recent Capital One activity to Excel yourself, but a Capital One statement to Excel for older cycles means converting the PDF. For 360 Checking and Savings, Capital One’s help pages say the website shows the past two years of account activity, and that statements cover up to seven years of history; for credit cards, Capital One keeps up to seven years of statements online for active accounts, and its business card pages describe downloading records into Quicken, QuickBooks and Excel.
The statement is where the history lives. Capital One’s own advice for 360 activity older than two years is to use the statements, and viewing 360 statements online requires being enrolled in paperless statements.
Most people searching this have a card statement in mind — a year of Venture or Spark spending for a tax return, an expense review or a loan file. Card statements have no running balance, so each converted cycle is checked against the totals Capital One prints: previous balance, payments and credits, transactions, fees, interest and new balance.
Two date columns, and the wrong one lands transactions in the wrong month
Sample statement
What a Capital One statement looks like
Hover or tap a number to see what each part means for a conversion.
Capital One
Quicksilver · Account ending 6624
May 18, 2026 - Jun 17, 2026 | 31 days in Billing Cycle
Payment Due Date Jul 14, 2026
Account Summary
- Previous Balance
- $2,104.77
- Payments
- - $2,104.77
- Other Credits
- - $48.00
- Transactions
- + $1,163.58
- Cash Advances
- + $0.00
- Fees Charged
- + $0.00
- Interest Charged
- + $0.00
- New Balance
- = $1,115.58
JANE DOE #6624: Payments, Credits and Adjustments
| Trans Date | Post Date | Description | Amount |
|---|---|---|---|
| Jun 2 | Jun 2 | CAPITAL ONE MOBILE PYMT Authdate 02-Jun | - $2,104.77 |
| Jun 9 | Jun 10 | BEST BUY 00004321 AUSTIN TX | - $48.00 |
JANE DOE #6624: Transactions
| Trans Date | Post Date | Description | Amount |
|---|---|---|---|
| May 18 | May 19 | CENTRAL MARKET 0511 AUSTIN TX | $132.64 |
| May 31 | Jun 2 | AIRBNB * HMQ2R8 SAN FRANCISCO CA | $612.40 |
| Jun 12 | Jun 13 | UBER *TRIP HELP.UBER.COM CA | $27.85 |
SAM RIVERA #9180: Transactions
| Trans Date | Post Date | Description | Amount |
|---|---|---|---|
| May 22 | May 23 | SHELL OIL 57444 AUSTIN TX | $58.20 |
| Jun 6 | Jun 8 | COSTCO WHSE #1042 AUSTIN TX | $332.49 |
Total Transactions for This Period$1,163.58
Native export
What Capital One lets you export from a credit card
The download and the QuickBooks link handle recent activity. Cycles before that, and any closed card, come from the statement PDFs.
Card download on capitalone.com
Shown when you download
Capital One describes downloading purchase records into formats including Quicken, QuickBooks and Excel. Spark and other business cards can also link to QuickBooks and pull history back to a date you pick from a drop-down.
Where it stops: The range is not published, a closed card cannot be downloaded, and the dates you pick will not match a billing cycle.
Statements
Up to 7 years
One PDF per billing cycle with the account summary, payments and credits, transactions by cardholder, fees, interest and year-to-date totals.
Where it stops: The seven years apply to active accounts. Close a card and the statements you did not save may be gone.
Converting the statement with VouchRow
Any statement you have
Each cycle becomes signed rows with both dates kept, checked against the account summary, with every row linked to its line on the PDF.
Where it stops: Needs the statement PDF. Save the statements before closing a card.
How far back
How far back each Capital One option reaches
Capital One publishes its statement archive and its 360 activity window. It does not publish a range for card downloads, so that bar is drawn as unknown.
Card transaction download or QuickBooks link
Not published
Capital One describes downloading card records into Quicken, QuickBooks and Excel, and choosing how far back QuickBooks pulls history when you link a card. The range is shown when you do it.
360 Checking and Savings activity on the website
2 years
The past transactions list shows two years of activity. For anything earlier, Capital One points you to the statements.
Statements (PDF), cards and 360
Up to 7 years
For active accounts. 360 statements online need paperless enrollment, and Capital One’s card paperless terms advise saving statements when you first see them.
A dashed bar means the bank does not publish a figure; check your own online banking.
Step by step
How to convert Capital One statements
- 1Download the statement PDFsSign in to capitalone.com or the Capital One Mobile app, open the card or 360 account and go to its statements. Save each cycle you need as a PDF. For 360 accounts, online statements require paperless enrolment.
- 2Keep card and 360 statements apartA card statement and a 360 statement are different documents with different checks. Upload them as separate batches, one account per batch.
- 3Upload and convertSign in to VouchRow and add the PDFs. Digital statements convert in batches; scanned paper statements are read with OCR one at a time.
- 4Choose the date and check the totalsDecide whether your books use the transaction date or the posting date, then read the reconciliation: card cycles against the printed totals, 360 statements against the running balance. Click any row to see its line on the PDF.
- 5ExportCSV to review signs and dates first, then QBO for QuickBooks (with Capital One’s bank ID), QFX for Quicken, or the Xero CSV preset.
Formats
Where is your Capital One data going?
Pick the destination. Card statements and 360 statements convert differently, so keep them in separate batches.
Capital One statement to Excel
An .xlsx with one row per transaction and both dates kept: purchases, fees and interest negative, payments and credits positive, from your side of the card. Capital One prints them the other way round. The rows net to the change from the previous balance to the new balance.
A 360 Checking statement gives the usual bank view instead: deposits positive, withdrawals negative, checked against the running balance on every row. Upload card and 360 statements as separate batches.
PDF to ExcelCapital One statement to CSV
CSV lets you see which date and which sign came through before the rows reach a ledger. The converted file has one signed amount column, not the separate Debit and Credit columns of positive numbers that invert payments when an importer reads them as one.
Choose the date format at export. Capital One prints a short month and day; the file writes full dates the way your importer expects.
PDF to CSVCapital One statement to QuickBooks
Export QBO with Capital One’s bank ID and import it into the credit card account in QuickBooks. If a Spark card is already linked for recent months, converted QBO files fill in the cycles before the link.
Each row carries a transaction ID, so a cycle that overlaps the linked history is recognised rather than doubled. Take the bank ID from a QBO Capital One issued for the same kind of account, since card and 360 products are not guaranteed to share one.
PDF to QBOCapital One statement to Quicken
Convert to QFX and import it into the existing Capital One card or 360 account in Quicken, so older cycles join the history you already have instead of opening a second account.
QIF also works but has no transaction IDs, so a cycle imported twice duplicates. Prefer QFX.
PDF to QFXCapital One statement to Xero
Use the Xero CSV preset: one signed amount column and the date format Xero expects. Import card cycles into the credit card account in Xero and 360 statements into their bank accounts.
Transfers between 360 Checking and 360 Savings appear on both statements. Importing each into its own account lets Xero match them as transfers instead of counting them twice.
Statements into XeroStatement layout
How a Capital One statement is laid out
The facts to check against the statement in front of you. Accounts covered: 360 Checking and 360 Savings, Venture, Quicksilver and Savor cards, Spark business cards.
| Date format | Month and day (Jan 6) in the Trans Date and Post Date columns; the year comes from the billing period |
|---|---|
| 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 |
Why it works
Built for Capital One’s two statement families
Payments signed as payments
Purchases come out negative and payments and credits positive, from your side of the card, in one signed column — never inverted by a separate Debit and Credit pair.
A deliberate date column
Card statements print a transaction date and a posting date. The conversion keeps them distinct so a month-end or year-end purchase lands where your accounting basis puts it.
Totals as the proof
With no running balance on a card, the rows must reproduce the previous balance, payments, transactions, fees, interest and new balance.
Fees and interest kept separate
Fees and interest charged sit in their own block on a Capital One card statement and come out as their own rows, ready to label as finance charges.
360 balance proved row by row
360 Checking and Savings statements carry a running balance, so every row is checked against it.
Checked before export
A misread digit is caught on its own row
Every conversion is tested against the statement: the running balance on every row, page subtotals, opening plus movement against closing, the printed credit and debit totals, and the transaction count. When a number does not add up, VouchRow names the row and highlights the line it came from on the PDF.
Arithmetic only: it verifies amounts, balances and totals, not descriptions or dates, and two errors that cancel out would pass. The source-line link covers the rest.
How the checks workRunning balance check
- POS AMAZON MKTPLACE−86.4316,604.12
- CHECK #1042−1,250.0015,354.12
- ZELLE FROM J MORALES+640.0015,994.12
Every row agrees with the balance printed beside it.
Native export
What Capital One lets you download, and where it stops
For 360 Checking and Savings, Capital One’s transaction history shows the past two years of activity on the website; anything earlier is in the statements, which cover up to seven years. Viewing those statements online requires paperless enrolment, so if you have been receiving paper, the older months may only exist on paper — scan them and they convert too.
For credit cards, Capital One keeps up to seven years of statements online for active accounts. Its business card pages describe downloading account records into Quicken, QuickBooks and Excel, and Capital One’s QuickBooks guide describes two routes for Spark cards: link the card to QuickBooks and choose how far back to pull history from a drop-down, or download transactions manually and upload them. The range available for a manual card download is shown when you choose it; Capital One does not publish a fixed figure on its public pages, so check before relying on a full year.
Neither route covers a closed card, and neither produces rows that start and end on the statement dates. Capital One’s seven-year card figure applies to active accounts, which is a reason to save statements before closing a card.
- 360 activity on the website: past two years.
- 360 and card statements online: up to seven years for active accounts.
- Spark cards: link to QuickBooks, or download manually and upload.
Statement layout
How a Capital One credit card statement is laid out
The first page summarises the cycle: previous balance, payments, other credits, transactions, cash advances, fees charged, interest charged and new balance, with the billing period, the minimum payment and the due date. Those are the totals the extracted rows must add back up to — they are not transactions themselves.
Transactions follow, grouped as payments, credits and adjustments, then transactions, with a transaction date and a posting date for each row. On accounts with authorised users, transactions are listed under each cardholder’s name. Fees and interest charged come in separate blocks after the transactions, followed by year-to-date totals of fees and interest — another summary box that looks like a transaction list and is not extracted.
Dates print as month and day. The year comes from the billing period, so on a statement that opens in December and closes in January each row is placed in the right year.
360 accounts
Capital One 360 Checking and Savings statements
360 statements are bank statements in the ordinary sense: an opening balance, a list of transactions in date order with a running balance, and a closing balance. Interest paid appears as its own line on savings statements. Each row is checked against the running balance, and opening plus movement must equal closing.
Transfers between a 360 Checking account and a 360 Savings account appear on both statements. Convert and import each into its own bank account in your books so the transfers match rather than counting twice. Do not expect a conversion set up around card statements to behave the same on a 360 statement — or the reverse.
Software
Importing Capital One statements into QuickBooks, Quicken and Xero
QuickBooks: export QBO and enter Capital One’s bank ID; take it from a QBO Capital One issued for the same kind of account where you can, since card and banking products are not guaranteed to share one. If you link a Spark card to QuickBooks for recent history, a converted QBO for older cycles fills in behind it, and deterministic transaction IDs stop re-imports from duplicating.
Quicken: QFX with the bank ID, or QIF. Xero: the Xero CSV preset, with one signed amount column. Whichever you use, settle the date question before the first import of the year — switching between transaction and posting date mid-year leaves a purchase in two months or in none.
Troubleshooting
Common Capital One problems and fixes
Capital One errors are mostly about signs and dates.
- Payments came through as charges: separate Debit and Credit columns of positive numbers were read as one column. Converted output uses one signed column.
- A purchase is in the wrong month: transaction date versus posting date across a month end. Pick one basis and keep it.
- Cannot see old 360 statements online: online statements require paperless enrolment. Scan any paper statements and convert them.
- Closed card, no statements online: the seven-year figure applies to active accounts. Convert the PDFs you saved before closing.
- Card totals do not reconcile: compare the transactions total with the summary; fees and interest are separate rows and must be included.
Side by side
Capital One’s own download vs converting the PDF statement
| Capital One download or link | Converting the PDF statement | |
|---|---|---|
| How far back | 360: two years of activity on the website; cards: the range offered when you download or link | Up to seven years of statements for active accounts, plus saved or scanned copies |
| Closed accounts | Not available once access ends | Any statement PDF you kept |
| Ties to the statement | Only if the range matches the billing cycle | Checked against the summary totals of each cycle |
| Date column | As the export provides | Transaction and posting dates kept distinct |
| Proof for a reviewer | A file of rows | Every row linked to its line on the PDF |
Before you import
After converting a Capital One statement, check these
- The cycle balancesPrevious balance plus the rows equals the new balance on the Account Summary. If not, the dollar difference is shown.
- One date basisEvery row uses the transaction date or every row uses the posting date. Check the month-end rows first.
- Payments are creditsYour payment and any returns are positive in the export and purchases negative.
- Every cardholder includedEach authorized user’s block is in the file, and together they equal Transactions on the Account Summary.
- No total or year-to-date rowsTotal Transactions for This Period and the year-to-date fee and interest totals do not appear as transactions.
- Card and 360 kept apartCard cycles went into the card account and 360 statements into their own bank accounts, each checked its own way.
Downloaded activity and statements are not the same thing
CSV for Capital One
Who uses it
Who converts Capital One statements
Tax preparation from a Venture or Savor card
A year of personal or mixed-use card spending, converted cycle by cycle and labelled in bulk for the deductible items.
Spark card catch-up for a small business
Cycles from before the card was linked to QuickBooks, converted to QBO and checked before they land behind the live feed.
Loan applications
360 Checking statements converted to a deposits list that ties to the closing balances the lender sees.
Divorce and forensic review
Card statements produced for past years become a ledger with each row linked to its line, and with authorised-user spending kept under the right name.
FAQ
Capital One statements: questions
How do I export a Capital One credit card statement to Excel?
Save the statement PDF from your Capital One account and convert it to Excel here. Each cycle is checked against the printed totals, and the export has one signed column: purchases negative, payments and credits positive.
Can I download Capital One statements to Excel directly?
Statements are PDFs. Capital One describes downloading card records into Quicken, QuickBooks and Excel for business cards, and 360 activity is shown for two years online; for statement periods, convert the PDF.
How far back can I get Capital One statements?
Up to seven years online for active accounts, for both credit cards and 360 accounts. 360 statements online require paperless enrolment.
How far back does Capital One 360 transaction history go?
Capital One says the website shows the past two years of account activity, and that statements cover up to seven years.
Which date should I use, transaction or posting?
Whichever matches how you keep the books — but use the same one every month. Mixing them produces a reconciliation that never quite agrees.
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. Converted output writes one signed column.
Is a 360 statement different from a card statement?
Yes. A 360 statement has a running balance and is checked row by row; a card statement has none and is checked against its totals. Convert them as separate batches.
Can I connect a Capital One card to QuickBooks instead?
Capital One describes linking business cards to QuickBooks and choosing how far back to pull history. For cycles outside that range, a converted QBO with Capital One’s bank ID fills the gap without duplicates.
Keep going
Related guides and converters
Formats for Capital One statements
Other banks
Other banks
Sources
The facts about Capital One on this page come from these pages, checked in October 2026. Banks change their online banking; if something here no longer matches, the bank’s own help page wins. Tell us and we will update it.
- Capital One: How long to keep credit card statements, up to seven years for active accounts (capitalone.com)
- Capital One: How to view transaction history, two years on the website (capitalone.com)
- Capital One: Online bank statements, up to 7 years and paperless enrollment (capitalone.com)
- Capital One: Venture Business card, download records into Quicken, QuickBooks and Excel (capitalone.com)
- Capital One: Business and QuickBooks integration guide (capitalone.com)
- Capital One: Card paperless terms, saving electronic statements (capitalone.com)
Convert your Capital One statements
Upload card or 360 PDFs, check each cycle against its totals, and export CSV, QBO, QFX or Excel.