# PNC Bank Statement to Excel: From Download to Rows

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Bank statements to Excel and CSV
- Canonical: https://fastbankconvert.com/blog/pnc-bank-statement-to-excel

> Turn a PNC bank statement to Excel: get the PDF statement online, split its activity sections into one list, and check the ending balance.
Getting a PNC bank statement to Excel takes three steps: open the statement in PNC online banking and save its PDF, combine its separate activity sections into one list where money in is positive and money out is negative, then confirm that the beginning balance plus that list equals the ending balance printed on the statement.

## Getting the PNC statement PDF from online banking

PNC keeps statements with your other account documents in online banking. PNC's own [digital banking tutorial on viewing documents and statements](https://www.pnc.com/content/pnc-branch-tablet-apps/en/digital-banking-tutorial/view-documents---statements-.html) describes a page that holds account statements, tax forms and other documents, where you select View PDF to see a full statement. Save that PDF to convert it.

### Pick the account and the month

Choose the account first, then the statement period. If you hold more than one PNC account, each has its own list of statements. Save each one to a folder under a name that includes the account and the month, so a later stack of files is easy to sort.

### How far back to expect

How many months or years of statements appear online depends on the account, and PNC's tutorial does not give a figure. Look at the oldest statement offered in the list for your account. If the month you need is older than that, ask PNC for a copy rather than trying to rebuild it from activity history.

### Three checks on the PDF

Before converting, open the file and run through a short list:

1. Select a word in a transaction line. If only that word highlights, the PDF has a text layer and converts cleanly.
2. Go to the last page. It should end with the activity sections or a balance table, not mid-list.
3. Look at the summary on the first page. Note the beginning balance, the ending balance and any totals printed for each type of activity. You will need them in a moment.

## PNC activity sections and the totals printed for each

Many checking statements group activity by type rather than printing one running list, so check whether your PNC statement does. If it does, look for a section for deposits and additions, one or more for withdrawals and deductions, and possibly one for checks. A summary near the top often prints a total for each type.

### Read your own statement first

Statement designs change, so treat any list of section names as a guide, not a rule. Open your PDF and write down each section heading in the order it appears. Next to each one, note the total the summary prints for it, if there is one. Those notes are the checklist for the rest of the work. If a section on the list has no rows in your spreadsheet later, you know at once that it was skipped.

### Why the section totals are useful

Section totals give you a second, finer check on top of the ending balance. The ending balance tells you whether the month as a whole adds up. The section totals tell you which section is wrong when it does not. With four or five sections, that narrows a hunt through fifty lines to a hunt through ten.

### More than one account in one PDF

If your PNC PDF lists more than one account, each will have its own sections and its own balances. Add an Account column and keep the accounts apart, since a balance check only makes sense one account at a time.

## Stacking PNC activity sections into one signed list

To stack the sections, label every line with the section it came from, give it a sign from that section, and then sort the whole list by date. Lines in money-in sections stay positive. Lines in withdrawal, deduction and check sections become negative. The labels let you check each section later.

### The steps

1. **Convert or copy each section** into Excel, one section below the next, keeping the date, description and amount columns.
2. **Add a Section column** and fill in the section heading for every row in that block. Fill handles make this quick: type the name once and drag it down the block.
3. **Add a Sign column** with 1 for money-in sections and -1 for money-out sections.
4. **Add a Signed amount column** with `=C2*E2`, where C is the printed amount and E is the sign.
5. **Fix the dates.** If the statement prints month and day only, add the year from the statement period, and take care with a period that spans January.
6. **Sort by date**, then by section, so same-day lines stay in a stable order.

### Let a converter carry the sign

The manual steps are worth knowing, because they show what a good conversion has to do. A statement converter that reads the layout should hand you the signed amount directly. [What a bank statement converter does with your PDF](/blog/bank-statement-converter) explains how that works and where general PDF tools fall short. FastBankConvert, which is getting ready to open, reads each statement's layout and says before you download if its balances do not add up; [the FastBankConvert home page](/) has the details.

## Do your PNC section totals match the account summary?

They should, section by section. Total your rows for each section with SUMIFS and compare the result with the figure printed in the summary. A section that matches is complete. A section that does not is where the missing or extra line is, and the difference is its amount.

### A worked example

The figures are made-up examples. The statement prints a beginning balance of 5,420.00 and these section totals in its summary: deposits and additions 3,275.00, card and other withdrawals 412.38, online and electronic deductions 1,640.00.

The PDF shows nine lines: three deposits (2,600.00, 575.00, 100.00), four card withdrawals (88.15, 23.50, 250.00, 50.73) and two online deductions (1,500.00 and 140.00). Your stacked list has only eight rows. Build a check table with `=SUMIFS(C:C,D:D,G2)`, where C holds the printed amounts, D holds the section name and G2 holds the section on that row of the check table:

| Section (example names) | Rows in sheet | Sheet total | Summary total | Difference |
| --- | --- | --- | --- | --- |
| Deposits and additions | 3 | 3,275.00 | 3,275.00 | 0.00 |
| Card and other withdrawals | 4 | 412.38 | 412.38 | 0.00 |
| Online and electronic deductions | 1 | 1,500.00 | 1,640.00 | -140.00 |

The third row is short by 140.00, and the row count is one below the two lines on the PDF. One online deduction of 140.00 did not make it into the sheet. Find it on the PDF, add it, and the difference drops to zero.

### Use the printed amount, not the signed one

Compare section totals using the printed, unsigned amounts. The summary prints withdrawal totals as positive figures, so a sum of negative numbers would never match it. Keep the signed column for the balance check that follows.

## Does the PNC ending balance tie out after the merge?

Once every section matches, the balance should tie: beginning balance plus the sum of the signed amounts equals the ending balance on the statement. In the example, 5,420.00 + 3,275.00 - 412.38 - 1,640.00 = 6,642.62, which is the ending balance to look for on the PDF.

### One formula

With the beginning balance in J1 and signed amounts in column F, the formula is `=J1+SUM(F:F)`. Put the printed ending balance in J2 and the difference in J3 with `=ROUND(J1+SUM(F:F)-J2,2)`. Zero means the list is complete.

### When sections match but the balance does not

This happens and has a short list of causes. A sign may be wrong on one section, often because a section was given 1 instead of -1, in which case the gap is twice that section's total. Or a section may exist on the PDF that you did not note in the first step, such as a small block of service charges near the end. Compare your section list with the PDF once more.

### When the balance matches but you still want proof

A tie-out at the end is strong evidence. If the statement also prints balances by day, you can test the list against those too, which shows the order of the rows is right as well as the total. That extra check is worth doing when you will use the sheet to show cash on hand on particular dates.

## PNC statement lines that belong in no activity section

Some rows in a converted PNC statement are not transactions at all. Balance lines, section subtotals, page headers and notices about fees or rates can land in the sheet and must come out. And a few kinds of statement are better handled another way than by converting them to a transaction list.

### Rows to delete

- **Beginning and ending balance lines.** Keep the figures in your check cells, not as rows in the list.
- **Section totals.** A total row inside the list counts that section twice in every sum.
- **Daily balance tables.** These are balances, not activity. Use them for checking, then leave them out.
- **Headers carried onto continued pages.** A heading repeated at the top of a page can arrive as a row with no amount.

Filter for rows with no date or no amount, compare each one with the PDF, and delete those that are not transactions.

### When a transaction list is the wrong goal

A business account statement may include service charge detail, analysis of fees, or lines that a personal account never has. Those lines need their own handling, covered in [converting a business bank statement to Excel](/blog/business-bank-statement-to-excel). If your next step is a script or an app rather than a spreadsheet, a CSV turned into structured data may suit it better than XLSX, and [converting CSV to JSON](/blog/csv-to-json) shows that step. And for another bank whose layout groups activity in a similar way, see [getting a TD Bank statement into Excel](/blog/td-bank-statement-to-excel).