pnc bank statement example

Virtual Wallet accounts transfer between themselves

PNC's Virtual Wallet groups a primary spending account with short-term reserve and longer-term growth accounts. Money moves between them routinely, and each movement appears twice across your statements: as a debit on the account it left and a credit on the account it arrived in. Combine the statements without recognising those pairs and you will count the same money as both spending and income.

When you consolidate several PNC accounts into one spreadsheet, tag internal transfers before you total anything. A net cash-flow figure that includes transfers between your own accounts is not a cash-flow figure at all.

Each account has its own statement and cycle

Do not assume the accounts share a cycle. Each statement defines its own period, and a transfer made near a boundary can appear in one account's current statement and the other account's next one. That is correct behaviour, but it means the matching pair is not always on documents with the same dates.

Keep the account name and the period with every row you extract. Without them, a transfer pair separated across two months is impossible to reconstruct later.

Reference strings in descriptions

PNC transaction descriptions often carry abbreviated merchant names, transfer references or confirmation numbers. These strings can be long and numeric, and a spreadsheet will happily convert them into numbers, dropping leading zeros or switching to scientific notation. Once that has happened the reference cannot be matched back to anything.

Set the reference column to text before importing, not after. Reformatting a column that has already been converted does not recover the original digits.

Balance checks across linked accounts

Each account reconciles on its own: opening balance plus credits minus debits equals closing balance. Do that per account first. Only once each one closes individually should you build a combined view, and then only with internal transfers excluded or netted.

If one account closes and another does not, the error is isolated to the second one, which is a much smaller search than looking across the whole Virtual Wallet.

Card, ACH and check activity

Card purchases post a day or more after authorisation; ACH entries such as direct deposits and bill payments post on their settlement date; checks clear whenever presented. All three appear in the same activity list with different timing behaviour behind them.

Use the posting date PNC printed for reconciliation. If you need the transaction date for reporting, add it as a separate column rather than replacing the bank's.

Getting the authentic documents

Expect several downloads: each Virtual Wallet account is requested on its own. A Virtual Wallet customer will typically need several downloads for one month.

Keep the PDFs. A converted spreadsheet is a working copy; the statements are the record anyone reviewing the figures will ask for.

Linked accounts in this pnc bank statement example

Because Virtual Wallet spreads one relationship across several accounts, the first two rows decide how every amount below should be read.

A Virtual Wallet reconciliation is complete when:

• Internal transfers between Virtual Wallet accounts are tagged and netted
• Each account's balance chain closes on its own before any combined view
• Reference columns were set to text before import, not after

Why single-account banks never show a transfer twice

Single-account banks produce a simpler picture; comparing one shows exactly what the linked structure adds. Independent guidance for US account holders comes from Ask CFPB, the US consumer regulator's guidance.

Given the authentic document, try the Excel converter or the CSV converter, with the extraction guide for the detail.

PNC bank statement example: Spend, Reserve and netting