Convert PNC Bank statements to Excel and CSV

Not affiliated with PNC. statement.work is an independent tool. PNC is a trademark of its owner and is named here only to describe the statements this page is about.

About PNC statements

PNC is a large US bank headquartered in Pittsburgh, Pennsylvania, serving consumers and businesses across much of the country. Some PNC customers use bundles of linked accounts, such as a spending account alongside savings, and their statements can reflect that.

What the statements typically contain

• The statement period, account holder and masked account numbers.
• A balance summary for each account covered.
• Transactions with dates, descriptions and amounts, plus balances.
• Fees, interest and, for linked accounts, transfers moving money between them.

Treat this as a general description; check your own statements for the details.

Common conversion problems

• Several accounts in one document. When one PDF covers more than one account, rows from different accounts can end up in one list. Keep an account label on every row so balances still add up per account.
• Internal transfers. Moving money from checking to savings shows up as a withdrawal on one account and a deposit on the other. Counted naively, it inflates both income and spending. Categorize these as transfers.
• Per-account balances. A running balance only makes sense within one account. Check each account’s opening and closing balance separately.
• Section headers mid-page. Account headers repeated on each page get mixed into copied text.

How to convert it

1. Download the statement PDF from PNC online banking, or use a scan or photo.
2. Upload it to statement.work.
3. Review the transactions, keeping each account’s rows together.
4. Export to Excel or CSV.
5. For each account, check opening balance plus deposits minus withdrawals against the closing balance.

Reconciling linked accounts

Reconcile one account at a time, then confirm transfers match in both directions: every transfer out of checking should appear as a transfer into savings for the same amount and date. The reconciliation guide covers matching transfers. Clients with accounts at U.S. Bank or Truist can be converted in the same batch.