What this tool does

The Capital One Statement Analyzer converts your bank or credit card statement into a clean, analytics-ready dataset. Upload a CSV or OFX/QFX file and we will normalize dates, amounts, and descriptions, detect recurring payments, and summarize inflows, outflows, and net cashflow. Everything happens locally in your browser—no sign-ups, no uploads, and no data storage on our servers. You can review every line in the table below, adjust the categorization if you like, and then download a clean CSV for budgeting, reimbursement, or tax prep.

Supported Capital One formats

Capital One provides different exports depending on the product: (1) Credit Card CSV where outflows and inflows appear in separate Debit and Credit columns; (2) 360 Checking/Savings CSV with a single signed Amount column; and (3) OFX/QFX downloads for certain accounts. This analyzer recognizes these layouts automatically and maps them into one consistent structure: date, description, amount, type, category, balance, source.

How we map common Capital One CSVs

{
  "Capital One Credit Card CSV": {
    "date": ["Transaction Date","Date","Posted Date","Posting Date"],
    "description": ["Description","Transaction Description","Memo"],
    "debit": ["Debit","Charge","Debit Amount"],
    "credit": ["Credit","Payment","Credit Amount"],
    "balance": ["Balance"]
  },
  "Capital One 360 Checking/Savings CSV": {
    "date": ["Transaction Date","Date","Posted Date"],
    "description": ["Description","Transaction Description","Details"],
    "amount": ["Amount"],
    "type": ["Type","Category"],
    "balance": ["Balance"]
  }
}

We normalize date formats (e.g., MM/DD/YYYY or YYYY-MM-DD), handle thousands separators and parentheses for negatives, and convert Debit/Credit pairs into a single signed amount field (credits become positive, debits negative). If both “Transaction Date” and “Posted Date” exist, we prefer posted date for cashflow, while preserving the original in a meta object.

How to export Capital One statements

Credit card (web)

1. Sign in to Capital One online banking and open the credit card account.
2. Go to Transactions or Activity.
3. Select a date range (last 3/6/12 months). Choose CSV for best results.
4. Download the file, then upload it to this page.

360 Checking/Savings (web)

1. Open your 360 account and view recent activity.
2. Choose a custom date range to include the months you need.
3. Click Download and pick CSV (OFX/QFX is also supported).
4. Upload to the analyzer and review your results.

Mobile app quick tip

If you don’t see a download button in the app, switch to the browser on your phone or use a desktop and sign in to Capital One online banking. Exports are easier to find on the web interface.

What you’ll get: insights and clean data

• Top categories by spend and by count, with simple rules for merchants like supermarkets, rideshare, and streaming.
• Recurring payments detection using a monthly cadence to find subscriptions and billers.
• Cashflow summary showing inflows, outflows, and net for the chosen period.
• Merchant cleanup that trims codes like “POS AUTH” and common prefixes/suffixes.
• CSV export that works in Excel/Google Sheets, bookkeeping, or your budgeting app.

Known quirks with Capital One files

• Credit card CSVs sometimes place refunds/returns in the Credit column and purchases in Debit; we convert them to signed amounts.
• 360 Checking may include a running balance; we preserve it when present.
• Some exports include both “Transaction Date” and “Posted Date.” We prefer posted date for calculations.
• Descriptions can contain channel flags (e.g., “POS, ECOM, ATM”); we remove the flag when creating a merchant label.

Step-by-step: from upload to insights

1. Upload your CSV/OFX and pick currency (USD by default).
2. We detect whether it’s credit card or 360 checking and apply the correct mapping preset.
3. We normalize dates and amounts, infer type (debit/credit), and create a merchant label.
4. We compute recurring patterns (monthly repeats) and top-level KPIs (in/out/net).
5. Review the table, then click Download Clean CSV.

Use cases

This analyzer is ideal for personal budgeting, preparing taxes, auditing subscriptions, claiming reimbursements, or validating side-business transactions. If you manage multiple Capital One accounts, combine their exports, run the tool, and download a single normalized file for analysis or pivot tables in Sheets/Excel.

FAQs

Do you store my statement?

No. Parsing runs entirely in your browser; we don’t upload or save your files.

Which formats work best?

CSV is the most reliable. OFX/QFX also works. Scanned PDFs are not supported in this version.

Can I change categories?

Yes. Edit the “category” cell after parsing and your change will be included in the download.

Does this support business cards and joint accounts?

Yes, as long as the exported CSV/OFX layout is one of the patterns above.

Will my totals match Capital One?

They should. We use posted amounts and standard sign conventions. If you spot a discrepancy, check the date range and whether pending items were exported.

How do I handle refunds and chargebacks?

Refunds appear as positive amounts (credits). Purchases show as negative (debits). Chargebacks usually arrive as credits followed by adjustments.

What about categories from the bank?

If your CSV contains bank categories, we preserve them in a “source” field. Our analyzer can also infer categories from merchant names.

Privacy, security & disclaimers

This page is for information and education only. Calculations and categorizations are estimates and may not fit every situation. Always verify results before making important financial decisions. For privacy details, see our Privacy Policy.

Changelog

• v1.0 (2025-11-28): Initial release — CSV/OFX support, recurring detection, KPIs, normalized export.