Format PNC Bank CSV for QuickBooks

PNC Bank provides CSV exports that do not play nicely with accounting software. Because pnc labels its amount columns withdrawals and deposits instead of the standard debit and credit, causing most import tools to leave the amount field blank or fail silently, bookkeepers waste hours manually fixing columns every month. This tool recognises PNC column names and combines Withdrawals and Deposits into a single signed Amount correctly.

LedgerMatch works with Google Sheets™ for spreadsheet-based bank reconciliation. Send your bank and ledger data from a spreadsheet, match transactions, and review exceptions without connecting your bank account.

Read the PNC Bank CSV CSV format guide

Add to Chrome — it’s free · Included with all plans Install Google Sheets™ add-on Install for Microsoft Edge