How to Export a Capital One Statement to CSV

TL;DR: Capital One lets you download recent transactions from its website in spreadsheet-friendly formats, which is the quickest route for current activity. For older months or the official statement, convert the PDF. With credit cards especially, pay attention to the sign of each amount, because "credit" means something different on a card than on a checking account.

Capital One is interesting because so many people know it for credit cards first and banking second. That matters for conversions. A credit card statement and a checking statement look alike at a glance, but they behave in opposite ways, and a CSV that mixes up the two will quietly turn your payments into spending.

In this guide we cover both: Capital One credit cards and Capital One checking or savings accounts (the 360 accounts many people use). We'll go through where to find data, how to get it into CSV, and how to make the file import cleanly into Excel, QuickBooks, Xero or a budgeting tool.

Card statements vs. bank statements

Let's get the sign convention straight, because everything else depends on it.

On a checking or savings account, the balance is money you have. Deposits increase it, purchases and withdrawals decrease it. In a CSV, money in is usually positive and money out is negative.

On a credit card, the balance is money you owe. Purchases increase it, payments and refunds decrease it. Card exports often list purchases as positive numbers (debits to your account) and payments as negative (credits). Some exports use separate debit and credit columns instead.

Neither is wrong. They're just describing different kinds of accounts. The problem appears when you combine card and bank data in one sheet, or import a card CSV into software that expects bank-style signs. Suddenly your card payment looks like income and your grocery shopping looks like deposits.

Our rule: decide what convention your destination expects, then flip signs if necessary, before anything else.

Getting your data out of Capital One

Downloading transactions

Capital One's website lets you view and download transactions for a card or bank account. General steps:

1. Sign in on the Capital One website (downloads are generally easier on desktop than in the app).
2. Open the account.
3. Look for a download transactions option near the transaction list.
4. Choose a date range or statement period, and pick a format. CSV is the safest for spreadsheets; other formats are aimed at Quicken and QuickBooks.
5. Save the file.

The range you can download is limited, so if you need a full prior year or more, you may need statements.

Getting the PDF statements

Statements are typically in a Statements or Statements & Documents area for each account. Download the months you need. Capital One keeps a run of past statements online; for anything older, contact customer service.

For credit cards in particular, the statement is useful even when you have the CSV, because it shows interest charges, fees, and the previous and new balances on one page. That gives you a reliable check.

Converting Capital One PDFs to CSV

When the download doesn't cover your dates, or you need the CSV to match the official statement, convert the PDF:

1. Upload the statement to SheetStatement's bank statement to CSV converter, or the credit card statement converter for cards. They're the same engine, and it detects the account type, but the card page explains card-specific handling.
2. The converter extracts each transaction with its date, description and amount.
3. For cards, it separates payments and credits from purchases and puts interest and fees on their own rows.
4. It checks the math against the statement's balances.
5. Review flagged rows, then export CSV.

We keep notes on tested layouts on the Capital One bank page.

Verifying a credit card CSV

The verification formula for a card is the mirror image of a bank account:

Previous balance + purchases + fees + interest − payments − credits = new balance

To check it in Excel, with a signed Amount column where purchases are positive and payments negative:

1. Put the previous balance from the statement in a cell, say H1.
2. In H2, =H1+SUM(Amount).
3. Compare H2 with the new balance on the statement.

If it's off, look at:

• Interest charged. It's often listed in a separate section of the statement, and some tools skip it.
• Fees. Late fees and foreign transaction fees can appear outside the main transaction list.
• Payments. Make sure they came through with the opposite sign of purchases.
• Authorized users. Some statements list transactions per cardholder in separate groups. Make sure every group was captured.

Our balance checker will run this check for you if you'd rather not build the formula.

Verifying a checking or savings CSV

For a 360 Checking or Savings account, it's the familiar bank formula:

Beginning balance + deposits − withdrawals = ending balance

Savings accounts usually have few transactions, often just interest and transfers, so they verify quickly. Checking accounts have more. Sort by date and scan for any day where your running balance and the statement disagree.

Formatting the CSV for its destination

For Excel analysis

Keep it simple: Date, Description, Amount, Category. If you want to see card spending as positive numbers in a spending report, add a separate "Spend" column with =MAX(0,[@Amount]) instead of flipping the original. Keeping the original signed amount means your balance check still works.

For QuickBooks Online

In QuickBooks, a credit card is set up as a credit card account. When you upload a CSV to it, QuickBooks interprets amounts relative to that account. Map columns carefully on the upload screen and check a couple of transactions after import: a purchase should increase the card balance, and a payment should decrease it. If they're backwards, delete the import, flip the signs, and import again. Our guide to QuickBooks Online CSV import errors covers this and the other common problems.

A QBO file is often cleaner than CSV here, since the file itself carries the account type and transaction IDs. Our QuickBooks converter can produce one.

For Xero

Xero wants a single signed amount column for statement imports. For credit card accounts in Xero, spend is negative and payments to the card are positive, which follows the same "from the account's point of view" logic as a bank account. Check two or three lines after import to make sure they landed on the right side. See our Xero CSV import format guide.

For budgeting tools

Most budgeting apps that accept CSV expect bank-style signs: spending negative, income positive. Card exports may need flipping. Try importing one month first and confirm a known purchase shows as spending.

Handling the awkward transactions

Refunds. A refund on a card is a credit, which reduces the balance. Don't delete the original purchase; keep both. They net out, and your history stays accurate.

Payments from another bank. If you pay the Capital One card from a different bank account, the payment appears on both statements: as money out of the bank and money in to the card. In bookkeeping, that's a transfer between two accounts, not income or an expense. Tag it.

Foreign transactions. International purchases often show the converted US dollar amount and sometimes a separate foreign transaction fee line. Keep the fee as its own row with its own category.

Rewards redemptions. Cash back redeemed as a statement credit appears as a credit on the card. How you treat it depends on your situation; for a business card, ask your accountant how they want rewards recorded. We just tag them "Rewards" so they're easy to find.

Pending charges. Downloads can include pending items that drop off or change. If you're matching to a statement, exclude pending.

Combining several months or cards

If you're consolidating multiple cards or a card plus checking:

1. Convert and verify each statement individually.
2. Add an "Account" column so you know which statement each row came from.
3. Normalize signs to one convention for the combined sheet. We usually use "from my wallet's point of view": money out negative, money in positive, regardless of account type, and keep the original signed value in a separate column.
4. Tag transfers and card payments so they can be excluded from spending totals.

A pivot table by Account and Category then gives you a combined view without double counting. If you're doing this across many months, our guide to catching up on bookkeeping has a process that scales.

Business cards and employee spending

If you run a business on a Capital One card, the CSV becomes the basis for expense reports and bookkeeping, and a few extra columns pay off.

Cardholder. When employees have their own cards on one account, add a column for the cardholder. Statements often group transactions by card number; carry that grouping into the data so you can produce a per-person report without re-reading the PDF.

Receipt status. A simple Yes/No column for "receipt received" turns your converted statement into a checklist. At month end, filter for No and chase the missing ones. This is usually the most tedious part of card bookkeeping, and having it in the same sheet as the transactions makes it much less painful.

Business purpose. For meals, travel and anything that could look personal, a one-line note on why it was a business expense is worth writing while you still remember. Your accountant will ask, and "I think that was the client lunch in March" is not a great answer.

Billable flag. If you re-bill clients for expenses, mark which rows are billable and to whom. A pivot table on that column becomes your re-billing list.

None of this requires special software. It's just columns in the same sheet. The key is starting from complete, verified data, which is why the conversion and balance check come first.

Keeping a clean archive

We recommend keeping three things for every statement period: the original PDF, the converted CSV, and a note of the verification result (even just "balanced 2026-09-03"). Store them in a folder per year with consistent file names. If questions come up later, from a tax authority, a lender or your own memory, you can answer them in minutes. The PDF is the evidence; the CSV is the working copy; the note proves you checked.

Why not just connect the card to software?

Bank feeds are great for ongoing transactions, and if your accounting or budgeting software connects to Capital One, use it for new activity. Feeds have limits, though. They usually only pull a limited history when you first connect, they occasionally drop or duplicate transactions, and they don't help when you're working with someone else's statements. Converted statements fill the gaps: historical periods before the feed started, months where the feed broke, and any situation where you only have PDFs. Many bookkeepers use both, feeds for the present and converted statements for the past.

A short worked example

Here's an invented card statement to illustrate:

• Previous balance: 1,284.50
• Payments: 1,284.50
• Purchases: 932.18
• Fees: 0.00
• Interest: 0.00
• New balance: 932.18

After conversion, the purchases column sums to 932.18 and the single payment is −1,284.50. Previous balance plus the sum of amounts equals 932.18. It balances.

Now suppose it didn't: our sum gave 902.18. A 30.00 gap. We filter for 30.00 and find nothing. So it's not a single missing row. We sort purchases by date and compare them with the statement page by page. On page two, one purchase of 47.99 was read as 17.99 from a slightly blurry scan. Correct it, and the gap closes. A flagged running balance would have pointed straight at that row; on card statements without a running balance, page-by-page comparison of subtotals is the next best tool.

Our take

Capital One makes recent activity easy to download, so use that for day-to-day work. For anything historical or official, convert the PDF, and treat the sign convention as the first thing you check rather than the last. Most "my numbers are crazy" problems with card data come down to signs, and they take seconds to fix once you see them.

The free plan converts 3 pages a month, enough to test a statement and see whether the output fits your workflow.

Troubleshooting Capital One conversions

Card and bank accounts use different sign conventions. Credit card exports often show purchases as positive or in a debit column; checking accounts show withdrawals as negative. Convert each account separately and standardize before combining.

The CSV has separate Debit and Credit columns. Merge them into one signed amount for tools that want it: =N(Credit)-N(Debit).

Card payments appear on both accounts. The payment leaving checking and arriving on the card is one transfer. Tag both sides as a transfer.

Export range doesn't match statement periods. For reconciliation, use statement periods so opening and closing balances can be checked.

Pending transactions. Remove them from anything you reconcile.

A second worked example: debt payoff tracking

A reader paying down a Capital One card wanted to see progress. Converting twelve statements, they built a table of previous balance, purchases, payments, interest and new balance per month, and a line chart of the balance. Seeing that interest was more than a fifth of their monthly payment pushed them to increase the payment. The data was all on the statements; the spreadsheet made it visible.

Mini checklist

1. Each account converted separately.
2. One sign convention after combining.
3. Transfers tagged on both sides.
4. Statement periods used for checks.
5. Posted transactions only.

FAQ

Can I download Capital One transactions as a CSV?

Yes. The Capital One website offers a transaction download with spreadsheet and accounting formats. The available date range is limited, so for older periods you'll need to convert PDF statements.

Why are my Capital One card payments showing as positive?

Credit card exports describe transactions from the card's point of view: purchases increase what you owe and payments reduce it. Depending on the export and your destination, you may need to flip signs so payments and purchases are on the correct sides.

How do I verify a converted credit card statement?

Start with the previous balance, add purchases, fees and interest, subtract payments and credits, and confirm you reach the new balance printed on the statement.

Should I use CSV or QBO for QuickBooks?

CSV works with QuickBooks Online but requires column mapping. A QBO file carries account details and transaction IDs, which reduces mapping work and helps avoid duplicates. Either is fine if you check the result.

How do I handle card payments when combining accounts?

A payment from your checking account to the card appears on both statements. Treat it as a transfer between accounts, not as income or an expense, and tag it so it's excluded from spending totals.

Can I convert Capital One 360 checking statements too?

Yes. Checking and savings statements convert like any bank statement. Verify that the beginning balance plus deposits minus withdrawals equals the ending balance.