Convert Capital One 360 Statements to Excel and CSV
A Capital One 360 statement is the record of an account you manage online. It lists the money that came in and the money that went out, one line after another, for the month.
Statements to Sheets reads that list and returns a CSV with a full date, a description and a signed amount on every row. When the file prints a running balance, you get it in its own column. Open the result in Excel, Google Sheets or QuickBooks and sort it however you like.
Upload your Capital One 360 statement to see the first rows before you pay. The first 50 transactions are free.
What the conversion looks like
Sample converter output for a statement of this type, with invented data.
As converted
| Date | Description | Amount | Balance |
|---|---|---|---|
| 11/03/2024 | Deposit from Example Co Payroll Credit + | 1200.00 | 2450.00 |
| 11/07/2024 | Example Market 1122 Debit | -64.30 | 2385.70 |
| 11/14/2024 | Example Utility Co Autopay Debit | -88.15 | 2297.55 |
| 11/21/2024 | Transfer from Example Checking Credit + | 300.00 | 2597.55 |
| 11/28/2024 | Example Cafe 3344 Debit | -12.40 | 2585.15 |
Why a Capital One 360 statement is hard to convert
Direction is not always a minus sign. A statement can show whether money came in or went out in more than one way. Copy the numbers into a sheet and they can all look positive, so your spending reads as income.
Transfers between your own accounts fill the list. A savings account that feeds a checking account produces many short lines with similar names. They are easy to mistake for each other when the descriptions have been cut apart from their amounts.
Banks send a statement every month. If you need twelve months for a loan file or a tax return, you have twelve separate PDFs. Each one must be merged with the others before the totals mean anything.
A running balance sits beside each amount. It is useful, but a basic tool can read it as a second amount and double every row. Telling the two numbers apart takes attention to where each sits on the line.
About Capital One 360 statements
- Capital One 360 is an online bank account, and statements are delivered as PDFs through the website and the app. Customers can download them one month at a time.
- People ask for these files when they apply for a mortgage, rent an apartment, file taxes or close the books for a small business that banks online.
- Many customers print or scan their statements to keep a paper copy, and those scans need to be read by OCR.
How we convert it
- Credits are positive. Debits are negative, whether the statement marks them with a symbol or a sign.
- Every row gets the full year.
- Transfers between accounts are kept as ordinary rows with their own sign, so you can filter them out in your sheet.
- A Balance column appears only when the file prints one. We never calculate or guess a balance.
- The second line of a wrapped description is not counted as a separate transaction.
- Scanned pages are read with OCR, and sideways pages are turned upright.
Every conversion also checks each page against the page image, and lines that continue a wrapped description are not counted as extra transactions.
The result is a CSV with Date, Description and Amount columns (plus Balance when the statement has one) that opens in Excel and imports into Google Sheets and QuickBooks. You pay per transaction, not per page. See plans and pricing.
What people do with the file
Mortgage and rental applications. A lender may ask for two or three months of records. Merge the monthly files, sort by date, and send one tidy sheet in place of a stack of PDFs.
Tracking a savings goal. Filter the credits to see how much you put aside each month, and filter the debits to see where the rest went.
Small business bookkeeping. Load the CSV into QuickBooks and categorize the rows there. Debits are already negative, so nothing has to be flipped first.
Good to know
- Capital One 360 savings and Capital One credit card statements may be laid out differently from the bank statement described here.
- Scans can contain OCR digit errors. Compare totals with the statement.
Questions
Will money going out come out as a negative number?
Yes. Debits are negative and credits are positive, so the Amount column adds up to the net change for the month.
Do I get the running balance?
Only when the PDF prints one. We never work out a balance of our own.
I downloaded twelve monthly statements. Can I combine them?
Convert each file, and every row carries its full year. Paste the CSV files into one sheet and sort by date.
What does it cost?
The preview is free, and so are the first 50 transactions. After that you pay per transaction, not per page.
Related Guides

Written by
Jeff GoughFounder of Statements to Sheets and Cascade Foundry LLC. Built this tool after converting 300+ pages of printed bank statements into CSV for a friend's QuickBooks catch-up. Read the full story →