How to Reconcile PNC Bank Statements

What you are checking against

PNC Virtual Wallet accounts combine Spend, Reserve and Growth views, and their statements reflect that linked structure.

Every statement carries its own test inside it. Add the opening balance to the transactions and you must land on the closing balance; walk the running balance and every row must step correctly from the one before. A conversion that passes both tests has earned trust; one that fails gets fixed against the PDF, not imported and hoped for. That is why the check runs before download here — the methodology page sets out the details.

The PNC Bank month-end reconciliation workflow

Prove the opening first. Before touching the month, confirm its opening balance equals last month's proven closing balance. If it does not, the problem is behind you, not in this month.
Convert with the check on. Run the month's PDF through the converter and take the reconciliation result seriously: reconciled, flagged or unverified are three different instructions.
Fix flagged rows at the source. Correct flagged rows against the statement PDF itself. Never adjust the books to match an unproven file.
Reconcile the software to the statement. Import the verified file and run the software's own reconciliation against the same closing balance and closing date.
Lock the month. Once both checks agree, the month is solid ground. Record it, and let next month build on it.

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

Reading one PNC Bank statement closely

A PNC Bank statement repays thirty seconds of orientation before any numbers move. Locate the balance pair the month is anchored to — opening and closing on deposit accounts, Previous and New on cards — and scan the transaction list for the period's biggest items, since a reconciliation difference is most often one of them. Note any section subtotals the layout prints; each one is a free checkpoint the converter's running-balance walk also uses. Pull the PDF from Statements in PNC Online Banking and the PNC Mobile app so you are always working from the issued document, not a re-export.

When a PNC Bank statement does not tie out

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.
A fee or interest line sits in its own section of the statement and was easy to overlook when eyeballing the total — it is a real row and belongs in the books.
A correction or reversal line nets against an earlier transaction. It looks like a duplicate when scanning quickly, but both lines are real and both belong in the file.
An interest credit or cashback posting lands on the closing date, after the last transaction row in some layouts — present on the statement, easy to miss in a manual total.

Teaching the routine to a successor

Reconciliation knowledge tends to live in one person's head, which makes it fragile. The defence is a written routine — this page is a template — plus the filed evidence trio for each month: statement, converted file, result. A successor who inherits both can reproduce any month without interviewing anyone, and the standard survives staff changes, vacations and growth.

Questions and answers

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 PNC Bank 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.

The difference is exactly one transaction's amount. Where is it?

Either that transaction is missing from the file or it is in twice. Search the converted file for the amount: zero hits means a dropped row, two hits where the statement shows one means a duplicate.

The difference is double a transaction's amount. What does that tell me?

A sign error: the transaction was read as money in when it was money out, or the reverse. The totals move by twice the amount because the correction has to both remove the wrong entry and add the right one.