Convert City National Bank Statement to QuickBooks — Step-by-Step Guide

City National Bank PDF statement: Convert bank statement PDF to QBO for QuickBooks. Imports as a native bank feed — no manual entry. Works with QuickBooks Online and Desktop. Free.

Output format: QuickBooks (.qbo)

Supported account types: City National Personal Checking, Premier Checking, Private Client accounts, City National Savings, Money Market accounts, City National Visa Signature credit cards, City National Business Checking, Commercial banking accounts

How to Convert

1. Log in to https://www.cnb.com and download your statement as a PDF
2. Upload the PDF to Bank Statement Converter
3. Select QuickBooks as the output format and click Convert
4. Download your .qbo file — ready in under 20 seconds

Other formats: City National Bank to Excel · City National Bank to CSV · City National Bank to Xero · City National Bank to Google Sheets · City National Bank to Quicken

Frequently Asked Questions

Does this work with QuickBooks Online?

Yes. QuickBooks Online supports QBO (Web Connect) file import via Banking → Upload from file. The file imports as a bank feed with transaction date, description, and amount pre-populated.

Does this work with QuickBooks Desktop (Pro/Premier/Enterprise)?

Yes. QuickBooks Desktop accepts QBO files via File → Utilities → Import → Web Connect Files. All versions of QuickBooks Desktop support this import method.

Will QuickBooks automatically categorize transactions from the import?

QuickBooks will attempt to match imported transactions to existing rules and payees. New transactions without a match appear in the For Review tab in Banking for manual categorization.

What if I get an error importing the QBO file?

The most common error is a duplicate transaction (already imported). Check that you're not importing a date range you've already imported. If the error persists, try the CSV import option and manually map columns in QuickBooks.