# Capital One Statement to Excel for Bank and Card

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Bank statements to Excel and CSV
- Canonical: https://fastbankconvert.com/blog/capital-one-statement-to-excel

> Turn a Capital One statement to Excel for checking, savings or a credit card: find the right PDF, handle its layout, and set the signs right.
To get a Capital One statement into Excel, download the PDF through View statements on the website or Statements in the app, then convert it to rows. Decide first whether it is a bank or a credit card statement: the two use opposite signs, so a purchase is negative on checking and positive on the card.

## Finding the Capital One statement PDF on the web and in the app

Capital One puts statements one click below each account. Its [online statements help page](https://www.capitalone.com/help-center/checking-savings/online-statements/) says to sign in, open the account and choose view statements, or in the mobile app to open the account, scroll to the bottom and tap statements. Active accounts show up to seven years online.

The same page says statements are typically generated online by the 6th of each month. If you are building a sheet for the month that just ended, waiting until after that date saves you from converting a partial activity view and redoing it later.

### Saving files for a year of work

Download each month as its own PDF and name it so it sorts by date, for example `c1-checking-2026-04.pdf` or `c1-card-2026-04.pdf`. Put the account type in the name. When bank and card files sit in one folder, that prefix is what keeps you from feeding a card statement into a checking workbook.

Keep the downloaded PDF itself. A printout scanned back in, or a phone photo of the screen, loses the text layer, and every digit then has to be guessed by character recognition instead of read.

## Is it a Capital One bank statement or a card statement?

The account type decides how you treat every amount. A checking or savings statement reports money you hold, so spending reduces the balance. A credit card statement reports money you owe, so spending increases the balance. Same bank, same logo, opposite arithmetic.

You can usually tell at a glance. A deposit account statement opens with a beginning balance and an ending balance and lists deposits and withdrawals. A card statement opens with a previous balance, a new balance, a minimum payment due and a payment due date. If you see a minimum payment, you are holding a card statement.

### Why this matters before converting

Pick the treatment before you build formulas. A converter will happily produce rows from either kind, but the balance test is different. On the bank side, the beginning balance plus deposits minus withdrawals gives the ending balance. On the card side, the previous balance plus purchases, fees and interest, minus payments and credits, gives the new balance. Apply the wrong test and a perfect conversion looks broken.

## Capital One checking and savings rows in Excel

For a Capital One checking or savings statement, keep four columns: date, description, amount and balance. Deposits go in as positive numbers, withdrawals as negative ones, and the balance column, where the statement prints one, lets you test every row instead of only the month.

### Columns worth adding

Two extra columns pay for themselves. An Account column holds the last four digits of the account, which matters the moment you combine checking and savings in one workbook. A Source column holds the file name, so any odd row can be traced back to the exact PDF and page.

### Transfers between your own accounts

A transfer from checking to savings appears twice: once leaving checking and once arriving in savings. In a combined workbook that is correct, as long as the two rows carry opposite signs and you exclude them from any income or spending total. A simple Type column with the value Transfer handles it. If you only convert checking, the transfer is a normal outflow.

### A quick balance test

Put the statement's beginning balance in a cell, then in the first row of a check column add it to the first amount. Each following row adds its amount to the row above. Wherever that computed figure parts from the printed balance, the row above it is where something went wrong. The method is the same one a [bank statement converter uses to check balances](/blog/bank-statement-converter#does-a-bank-statement-converter-check-balances), done by hand.

## Capital One credit card lines and their signs

On a Capital One card statement, charges are positive and payments and credits are negative, because the statement measures what you owe. If you only track the card, keep that convention. If you combine the card with checking in one sheet, multiply every card amount by minus one so money out is negative everywhere.

### Bank and card side by side

This example table shows one invented purchase and one invented payment as they appear on each statement, and the sign each row should carry in a combined sheet where spending is negative.

| Example row | On the checking statement | On the card statement | In a combined sheet |
| --- | --- | --- | --- |
| Grocery purchase on debit card | 64.20 withdrawal | (not on card) | -64.20 |
| Grocery purchase on credit card | (not on checking) | 64.20 charge | -64.20 |
| Card payment from checking | 250.00 withdrawal | 250.00 payment | -250.00 on checking, +250.00 on card |

The third row is the one people get wrong. The payment leaves checking and lowers the card balance. In a combined sheet it is a transfer between two of your own accounts, so it should net to zero across both and stay out of your spending totals.

### Interest, fees and card summary lines

Interest charged and any fees are real transactions and belong in the sheet as charges. The rate table and the summary box near them are not; they explain the figures and should not become rows. Tag interest and fees in a Type column so you can total what the card costs separately from what you bought.

### Billing cycles that cross calendar months

A card statement covers a billing cycle, and the cycle rarely runs from the first of a month to the last. A cycle might close on the 18th, for example, so one statement holds the second half of one month and the first half of the next. If you want calendar-month spending totals, do not assign a whole statement to one month. Use each row's own date in a SUMIFS or a pivot grouped by month, and accept that the latest month stays incomplete until the next statement arrives.

The same applies when you match card payments to checking. The payment leaves checking on its own date, which may fall in a different card cycle from the purchases it paid for. Match on amount and date, not on statement month.

If your other card is an American Express, the guide to [American Express statements in Excel](/blog/american-express-statement-to-excel) covers additional card members and foreign spend lines, which follow the same sign logic.

## Can Word open a Capital One PDF for Excel?

Word can open a PDF and turn it into an editable document, and some people copy the tables from there into Excel. On a statement it is a slow route. Word rebuilds the page for reading, so columns can become tabs, text boxes or merged cells, and the cleanup often takes longer than the conversion.

The Word route has one fair use: a single page you need once, such as a year-end summary or one month for a form. For that, the step-by-step on [converting PDF to Excel using Word](/blog/convert-pdf-to-excel-using-word) explains what to click and which table repairs to expect.

For a run of months, work from a tool that outputs rows directly. Once you have more than a handful of statements, each manual repair of a Word table becomes another chance to drop a line, and a dropped line is exactly what the balance test exists to catch.

## Quarterly Capital One savings statements and other gaps

Not every Capital One account produces a statement each month. The online statements help page notes that savings products generate statements on a quarterly basis when there is no activity to prompt a monthly one. A quiet savings account can therefore show gaps that are expected, not missing files.

### Telling a real gap from a quiet quarter

Line up the statements by period. If one statement's ending balance equals the next statement's beginning balance, nothing is missing between them, however many months apart they are. If the two figures differ, there was activity in between, and a statement is missing from your download.

### Closed accounts and older years

The seven-year figure on the help page refers to active accounts. If you closed an account, or need history beyond what you can see online, contact the bank before assuming the statements are gone, and convert what you have in the meantime.

### Mixing statement years

Statement layouts can change over seven years. Run the balance test on every month instead of only the first one you convert, especially where one year's files sit next to another's.

### Doing the conversion

When the PDFs are ready, a converter built for statements saves the row-by-row work. FastBankConvert, which is getting ready to open, is designed for checking, savings and credit card statements, gives you Excel, CSV or JSON, and flags a statement whose balances fail to add up before you download it. [Get started](/get-started) to be told when it opens. For a bank that bundles several accounts into one PDF, see how to keep them apart in the [Citibank statement to Excel guide](/blog/citibank-statement-to-excel).