Banks · United States
Capital One 360 checking PDFs are usually a single table: Date, Description, Amount, and Balance. Debits are printed with a minus sign more often than at branch banks that use unsigned section totals. Dates are month/day/year.
A text-based Capital One PDF is read in your browser. The file is not uploaded. If the columns on your copy differ from the notes below, change the mapping in the preview before you download.
The 360 interface also lets you download activity as CSV. This converter is for the PDF statement, which is the document people archive. Credit-card PDFs from Capital One list purchases and payments and often have no running balance.
Typical columns: Date, Description, Amount, Balance. Date order: month/day/year. Currency on the statement: USD.
In Capital One, open the 360 account, choose Statements, and save the PDF. The CSV next to it is already a spreadsheet; use that if you only needed the latest activity.
Leave the Amount column as Amount. Negative numbers become debits and positive numbers become credits.
If the PDF added Category or Type, set it to Ignore unless you want those words in the description. You can also map it to Description to append them.
The balance column is kept in XLSX and CSV. QuickBooks CSV and OFX use the signed amount only.