Guidelines

Convert PNC Financial Services Group Bank Statement PDF to Excel

Zawwad Ul Sami

08 Nov 2024 • 3 min read

PNC Financial Services Group, a key player in the banking industry, provides a vast amount of valuable information through its bank statements. However, navigating and extracting the data you need from these statements can be a challenge, particularly when dealing with PDF formats.

So if you are looking for a way to convert your PNC Financial Services Group bank statement to Excel or CSV format, then this article is for you.

This tutorial will show you how you can use the web tool Bank Statement Converter to easily convert your PDF bank statements into Excel or CSV files in an automated manner.

How to Convert PNC Financial Services Group Bank Statement PDF to Excel

STEP 1: Go to convertmybankstatement.com and sign up using Google.

STEP 2: Click on the “Click Here to Convert a PDF ” button.

STEP 3: Go to the location where you downloaded your bank statement and select the file to upload it. You can also choose multiple bank statements to convert simultaneously.

STEP 4: After the files have been completely uploaded, press the "Convert" button to start your process.

STEP 5: The site will provide you with a preview of the output. Press "Download" on the top right to download it.

How to Download PNC Financial Services Group Bank Statement Options

Option 1: Using the PNC website

The first thing to do is to go to the PNC website.

To enter your account, click on the sign-in button and log in using your ID and password.
When you arrive at the main screen of your PNC bank account, you need to find the checking account you would want a statement for.
Once you get to the checking account page, you need to find “online statements” from which you should click on “view in account activity”.
You can now select from the list of months for which you can download your bank statement in PDF format.
Select the location on your desktop where you want to download your PDF statement.
Simply open the PDF file from your computer and check out your statement.

Option 2: Using the PNC Financial Services Group Bank App

Open up your PNC Bank App.
You should be able to see the dashboard screen of your PNC bank account.
Click on your virtual wallet's spending account.
On the very bottom of the screen, you can find the “Account actions” section for your account of virtual wallet spending.
Press on the “online statement”
You will find your monthly statements grouped by year, to find your statement click on the specific month.
Lastly, you now need to press the three dots and download your PDF bank statement.

Further Optimization of Excel PNC Bank Statement

PNC statements do not include data such as year and currency symbol, but in this article, we will show you how to further optimize your Excel table.

Including the Year

The quickest way to add new data to your Excel file is to create a new column in your document by using the “DATE” function. Below is the formula you will need to use.=DATE(2023, LEFT(A2, FIND(“/”, A2) – 1), MID(A2, FIND(“/”, A2) + 1, 2))

Combine with VLOOKUP

PNC statements organize your transactions into categories like "deposits and other additions," "banking/debit card withdrawals and purchases" and "online and electronic banking deductions," among others.

To Summarise

With these simple steps, you can easily convert as many bank statements as you want simultaneously without the hassle of manual input and the worries of human error when transferring your data from a PDF bank statement to an Excel or CSV file.