PricingAPIDocsAbout
Log In

Convert PNC statements to Excel or CSV

A PNC statement lists deposits first and then splits money out by how it left: card purchases, online and electronic payments, other deductions. Upload the PDF and get every row back in one list you can sort and total, or a report on where the money went.

Drop your bank statement PDF here, or choose it

PDF, up to 10 MB. Nothing is stored.

Where to find your PNC statement PDF

  1. Sign on to PNC Online Banking or open the PNC Mobile app.
  2. Select the account, then Account Quick View and Statements and Documents. In the app, tap More, then Statements and Documents.
  3. Find the statement and select View PDF.

How PNC statements are read

Money out is split by how it left

After Deposits and Other Additions, money out is listed in separate tables: Banking/Debit Card Withdrawals and Purchases, Online and Electronic Banking Deductions and Other Deductions, each with a count and a total. Amounts carry no sign, so the converter takes the direction from the table and merges every row back into one list in date order.

Spend, Reserve and Growth are separate accounts

A Virtual Wallet is up to three accounts, and money moves between them often. Upload each account's statement and transfers between them are marked as your own money, so moving cash to Reserve is not spending and moving it back is not income.

Parse PNC statements in your own app

Send the PDF to the StatementBear API and get JSON back: every transaction with its direction and category, the account it belongs to, and a check that the totals reconcile. No bank login, no template per bank. The first 25 documents are free, then $0.49 each.

{
  "object": "document",
  "issuer": {
    "name": "PNC",
    "domain": "pnc.com"
  },
  "currency": "USD",
  "period": {
    "year": 2026,
    "month": 8
  },
  "accounts": [
    {
      "type": "bank",
      "last4": "8264",
      "primary": true,
      "totals": {
        "credits": 2610,
        "debits": 76.17
      },
      "transactions": [
        {
          "date": "2026-08-01",
          "description": "Direct Deposit - Payroll Fabrikam Inc",
          "amount": 2610,
          "direction": "credit",
          "category": "income"
        },
        {
          "date": "2026-08-03",
          "description": "Debit Card Purchase Xxxxx4382 Giant Eagle #6012 Pittsburgh PA",
          "amount": 64.18,
          "direction": "debit",
          "category": "groceries"
        },
        {
          "date": "2026-08-05",
          "description": "Recurring Debit Card Xxxxx4382 Spotify Usa",
          "amount": 11.99,
          "direction": "debit",
          "category": "subscriptions"
        }
      ]
    }
  ],
  "verification": {
    "reconciled": true,
    "issues": []
  }
}
Get an API keyRead the quickstart

Statements from other banks

Chase

Bank of America

Wells Fargo

Citi

Capital One

Amex

U.S. Bank

Truist

Discover

Navy Federal

USAA

Ally

Your bank is not listed? Upload it anyway: the converter reads any bank, in any currency. All banks

Bank Statement to ExcelBank Statement to QuickBooksBank Statement to OFXBank Statement to JSON

Three simple steps

01

Download your PNC PDF

Sign on to PNC Online Banking or open the PNC Mobile app. Select the account, then Account Quick View and Statements and Documents. In the app, tap More, then Statements and Documents. Find the statement and select View PDF.

02

Upload it here

Drop the PDF on the box at the top of this page. It is read in under a minute and nothing is stored.

03

Download the CSV

One row per transaction with date, description, amount, direction and category. Opens in Excel, Google Sheets and Numbers.

Frequently asked questions

Want a complete spending analysis?

Upload your statement for a spending score, category breakdown and honest AI feedback.

Get Started Free