How to Reconcile Capital One Statements

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

What you are checking against

Capital One is card-heavy: for many customers the primary statement is a credit-card statement with a Previous Balance / New Balance layout, while 360 deposit accounts issue their own monthly statements.

Whatever the layout, the arithmetic underneath a statement is always the same shape: an opening figure, the period's transactions, and a closing figure the transactions must reproduce exactly. Reconciliation is the discipline of insisting on that proof for every month, in order. The converter runs the check at conversion time — totals first, then the running balance row by row — so a bad file is caught before it reaches the books, and the methodology page explains both checks in full.

The Capital One month-end reconciliation workflow

Work one month, start to finish. Resist batching the judgement calls. Convert, check, import and reconcile a single month completely before opening the next PDF.
Read the conversion result like a verdict. Reconciled: proceed. Flagged: the marked rows are your whole workload — fix them against the PDF. Unverified: the statement printed no balances, so add your own total check before importing.
Compare closing balances in both places. The statement's closing balance, the converted file's implied closing balance and the software's reconciled balance should be one number said three ways.
Write down the exceptions. Outstanding cheques and deposits in transit explain honest differences. List them on the month so next month's hunt starts from knowledge, not archaeology.
Chain forward. Next month's opening balance is this month's closing. Verify the chain link before starting the next month — it takes seconds and catches missing statements instantly.

These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.

Reading one Capital One statement closely

Before reconciling a Capital One statement, read it once as a document rather than a data source. Find the opening balance on the first page and the closing balance where the period ends, then notice how the middle is organized — one chronological run, or sections for deposits, withdrawals and fees. That structure tells you how a difference will behave: in a sectioned statement, compare section totals first; in a chronological one, the running balance walk is your fastest instrument. The statements themselves are filed under Statements & Documents in Capital One online banking and the Capital One app, so the document you reconcile is always the bank-issued original.

When a Capital One statement does not tie out

The statement's opening balance belongs to a different period — usually a gap month in the set. Check that consecutive statements chain: each closing balance should equal the next opening balance.
A pending card transaction appears on one statement and posts on the next, so both statements are right and the import order is what needs care.
Two transactions with the same amount were collapsed or one was duplicated — compare the row count in the flagged region against the PDF.
The PDF is a scan and OCR misread a digit. The flagged rows name the expected and printed balances; correct those rows against the image.

Deposit and card accounts, reconciled together

Most relationships reconcile as a set, not as islands: payments leave the deposit account and land on the card statement, transfers move between accounts, and each leg appears on two statements. Reconcile the deposit account first, then the card, and expect the cross-account transactions to explain each other's odd rows. A difference that survives both reconciliations, in equal and opposite amounts, is almost always a transfer recorded on one side only.

Questions and answers

My Capital One statement does not tie out after conversion. What now?

Work the flagged rows first — the check marks exactly where the arithmetic breaks. The causes section on this page lists the usual suspects in order of likelihood.

How often should I reconcile?

Monthly, in step with the statements. Reconciling a year in one sitting is exactly the catch-up scenario the batch converter exists to shorten — and month-by-month chaining is what makes it provable.

Does reconciling in QuickBooks or Xero replace the conversion check?

They check different things. The conversion check proves the file matches the statement; the software reconciliation proves the books match the file. Doing both, in that order, is what makes a month solid.

Can I reconcile several Capital One accounts together?

Convert and check each account's statements separately — balances are per account — then reconcile each account in your software. Combined Excel exports keep one sheet per statement so accounts never blur.

What does an outstanding item mean for reconciliation?

A cheque written but not yet cleared, or a deposit recorded but not yet at the bank, makes honest books differ from the statement by exactly those items. They are listed, carried forward, and expected to clear next month — they are not errors.