About PNC statements
PNC statements print the amount before the description and without a sign, grouped into sections: Deposits and Other Additions, Checks and Substitute Checks, Banking/Debit Card Withdrawals and Purchases, Online and Electronic Banking Deductions and Other Deductions. Utilly signs each row by its section, turns checks into "Check 1043" rows, joins descriptions that wrap onto a second line and checks the result against the Beginning and Ending balance in the Balance Summary.
Works with PNC checking, Virtual Wallet and savings statements. Layout tested: Amount before the description, sections by type, Spend and Reserve on one statement.
Section by section: what we read on a PNC statement, Virtual Wallet Spend and Reserve, and how far back PNC statements go →
Why Xero?
Xero (US and Canada) can import some PDF statements directly. Elsewhere, and for scans or layouts it can't read, it needs CSV, OFX or QIF. The Xero CSV is laid out the way Xero expects, and Utilly has already checked it against your statement balances.
Rather import an OFX file than a CSV? The same results page has one, and Xero takes it under Import a Statement with no column mapping: see bank statement PDF to OFX.
Import failing, dates swapped or a balance that won't match? See Xero bank statement import errors and how to fix them.
Already have a CSV or Excel export from your bank? The free CSV to Xero converter turns Debit and Credit columns into one signed Amount and writes Xero's import layout.
Weighing Xero's own PDF import, Hubdoc or another converter? See bank statement to Xero converters compared.
Pricing
Preview any statement free. A $9 pack unlocks 5 full statements in every format, with no expiry and no subscription. Bookkeepers with many clients can go unlimited for $19/month. See pricing.
