General Ledger + Converter in one subscription.
See pricingBY BANK · PNC
To convert a PNC bank statement to Excel, open Statements and Documents in PNC Online Banking, click View PDF and download it, then upload it to the ZeraBooks bank statement converter and download Excel or CSV. ZeraBooks merges PNC’s Activity Detail blocks into one dated list and proves it against the printed beginning and ending balance.
7-day trial · card required, nothing charged for 7 days · 1,000 pages a month from $79/month billed annually
STEP 1 · DOWNLOAD
PNC shows statements on each account’s own page. The full walk-through is in Download your PNC statements.
Larger businesses on PINACLE use that site’s statements or reports area instead.
Each checking or savings account has its own statements.
Checking and savings go back up to 7 years.
The account activity export (Excel, Quicken or QuickBooks) is a different file and usually has no balances.
Try it on your own documents. One-week free trial, both apps included.
HOW PNC LAYS IT OUT
A PNC business checking statement typically gives you the totals twice before the transactions: a Balance Summary, then a two-sided table of additions and deductions with item counts. The transactions themselves come later, under Activity Detail, one block per kind.
| Part of the statement | What it holds | In the converted file |
|---|---|---|
| Balance Summary | Beginning balance, deposits and other additions, checks and other deductions, ending balance | Used for the proof, not rows |
| Overdraft and Returned Item Fee Summary | Fees this period and year to date | Not rows; the fees themselves appear in Activity Detail |
| Additions and Deductions tables | Each kind of activity with its number of items and total | Not rows; a cross-check on each block |
| Daily Balance | Ledger balance at the end of each day, in three side-by-side bands | Not rows |
| Activity Detail: ACH Additions, deposits | Date posted, Amount, Transaction description, Reference number | Rows, Type Deposit, positive |
| Activity Detail: Debit Card, POS, ATM, ACH Deductions, Other Deductions | Money out, printed positive; card lines start with the card’s last 4 digits | Rows, Type Withdrawal, negative |
| Activity Detail: Service Charges and Fees | Overdraft and monthly fees | Rows, Type Fee, negative |
| Detail of Services Used | A fee analysis table of service volumes | Not rows: it describes fees, it doesn’t move money |
When the account is overdrawn, PNC prints the balance with a trailing minus, such as “1,441.08-”. That minus is the difference between owing and having money, and it is the first thing a copy-paste loses.
WORKED EXAMPLE
Mill Creek Hauling is a fictional trucking company with PNC Business Checking ending 7740. June 2026 starts overdrawn, printed as a beginning balance of 612.40-. Two broker payments, two fuel purchases on card 4471, a truck loan payment and an overdraft fee follow. In the Money in and out format, with its empty Balance column left off:
| Date | Description | Money In | Money Out |
|---|---|---|---|
| 06/02/2026 | Corporate ACH Broker Pay | 2,480.00 | |
| 06/03/2026 | Overdraft Item Fee | 36.00 | |
| 06/05/2026 | 4471 Debit Card Purchase Pilot Travel | 418.22 | |
| 06/10/2026 | Corporate ACH Truck Loan | 1,150.00 | |
| 06/16/2026 | Corporate ACH Broker Pay | 2,915.50 | |
| 06/19/2026 | 4471 Debit Card Purchase Pilot Travel | 397.06 | |
| Totals, ending at 2,781.82 | 5,395.50 | 2,001.28 |
The proof: −612.40 + 5,395.50 − 815.28 − 1,150.00 − 36.00 = 2,781.82, the ending balance PNC printed. Start from +612.40 instead, the way the number looks once the trailing minus is lost, and the month is off by 1,224.80, twice the opening balance. The format’s Balance column stays empty here, because PNC prints balances in its separate Daily Balance table rather than on each line, and ZeraBooks never fills a value the statement doesn’t print beside the row. For trucking books, see bookkeeping for trucking.
WHAT GOES WRONG
PNC statements are long for what they hold, and most of the length isn’t transactions.
The additions and deductions tables, the fee summary and the services table all have amounts in columns. Copy a page and they land in the sheet beside the real rows.
An overdrawn “612.40-” pastes as text or as a positive number. Everything after it is wrong by twice that amount.
The Reference number column holds 17 to 20 digits. Excel shows them in scientific notation and rounds off the end, so they no longer match the bank’s records.
A block that runs over a page break restarts with its headers. Pasted, that is a header row in the middle of the data.
CARDS AND EXPORTS
PNC CARDS
Sign in there, download the card statement PDF and upload it to the same Convert page. PNC keeps about 4 years of card statements online. A card is proven as previous balance plus charges minus payments equals the new balance; see credit card statement to Excel.
THE ACTIVITY EXPORT
PNC’s account activity export comes as Excel, Quicken or QuickBooks, separate from the statement. It usually has no beginning or ending balance. The statement PDF has both, and ZeraBooks uses them to mark it Proven before you download.
MORE BANKS
PNC keeps up to 7 years of checking and savings statements online, and about 4 years for credit cards. Older ones can be requested from PNC.
Yes. A negative beginning balance printed with a trailing minus is read as negative, and the proof starts from it. If it were read as positive, the account would be off by twice the overdraft and the statement would show Needs a look.
Yes. Upload the PDF to the same page. If one PDF holds more than one account, Convert splits the transactions by account and proves each against its own balances.
No. ZeraBooks has no bank feeds and never asks for your PNC sign-in. You download the PDF and upload it.
Convert comes with the ZeraBooks subscription: 1,000 pages a month for $79 a month billed annually or $149 monthly, after a 7-day trial. See ZeraBooks pricing.
ONE-WEEK FREE TRIAL
1,000 pages a month from $79 a month billed annually. Other banks: TD Bank, Citi and Chase. Want the books kept from these statements? See AI bookkeeping.
Last updated November 5, 2026 · Written by Damin Mutti, founder of ZeraBooks