Skip to content

Convert a PNC bank statement to QBO

PNC exports and statements keep withdrawals and deposits in separate columns. We turn them into one signed amount per transaction, the way QuickBooks needs it.

Columns (only if we guess wrong)

Column numbers in your CSV or Excel file, counting the first column as 1.

No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.

How it works

  1. Step 1

    Upload

    The CSV or Excel download from online banking, or a PDF statement.

  2. Step 2

    Check

    Free preview of every transaction as QuickBooks will read it: date, payee, signed amount.

  3. Step 3

    Import

    QuickBooks Online: Banking > Upload transactions. Desktop: File > Utilities > Import > Web Connect Files.

What you get

PNC export
Date,Description,Withdrawals,Deposits,Balance
03/04/2026,DEBIT CARD PURCHASE STAPLES 00123,45.10,,1954.90
03/05/2026,ACH CREDIT ACME CO,,1200.00,3154.90
As QuickBooks will read it
DatePayeeAmount
2026-03-04DEBIT CARD PURCHASE STAPLES 00123-45.10
2026-03-05ACH CREDIT ACME CO1,200.00

Getting your transactions out of PNC

  • Recent activity: in PNC Online Banking open the account activity and use the Export or download option to save a CSV for the dates you need.
  • Older history: download PDF statements from Statements. PDF statements list deposits and withdrawals in separate sections, which we combine and check against the statement balances.

What to watch for in PNC files

  • Separate Withdrawals and Deposits columns: we make withdrawals negative and deposits positive.
  • Business account statements can include a daily balance summary. Those lines are balances, not transactions, and are left out.

Pricing

Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.

  • 1 file

    $9 per file

    $9

  • 10 filesBest value

    $2.90 per file

    $29

  • Unlimited files every month

    $0.08 per file, billed monthly, cancel any time, fair use 500 files a month

    $39/mo

Deleted after 24 hours

Your upload and the result are removed automatically.

Never used for training

Files are processed only to make your result.

Refund if it is wrong

If a result is unusable, we fix it or refund you.

Privacy policy · Refund policy

Questions

My PNC columns are named differently. Will it still work?

Yes. We detect columns by name and by their values. If a guess is wrong, choose the columns yourself in the preview.

Can I convert a PNC credit card statement?

Yes. Upload the CSV or PDF and choose Credit card as the account type.

Is my statement kept?

No. Files are deleted automatically 24 hours after upload and never used to train AI.

How much does it cost?

The preview is free. $9 per file, $29 for 10 files, or $39 a month for unlimited files.

Does it work with QuickBooks Online and QuickBooks Desktop?

Yes. The same QBO (Web Connect) file imports in both. QFX for Quicken and OFX for Xero download from the same conversion.

Is this made by Intuit or my bank?

No. This is an independent tool. QuickBooks and Quicken are trademarks of Intuit Inc.; bank names are used only to describe their files.