How To Convert National Bank of Canada Statement To Excel, CSV, And QBO
National Bank of Canada provides PDF statements through online banking and the National Bank app. This guide shows you how to convert NBC PDF statements to Excel, CSV, or QBO using DocuClipper.
National Bank of Canada (Banque Nationale, NBC) provides monthly statements as PDFs through National Bank Online and the National Bank app. As Canada's sixth-largest bank with strong presence in Quebec and the Maritimes, NBC serves a large base of small businesses and personal-banking customers, most of whom share data with bookkeepers and accountants as PDFs.
For fraud detection, anomaly review, and audit-style bank statement analysis, DocuClipper's bank statement analyzer helps flag unusual activity and supports investigations after statements are digitized.
Retyping a National Bank PDF into Excel is slow and creates errors that surface during reconciliation. In this guide we'll show you how to use DocuClipper's bank statement converter to convert NBC PDF statements to Excel, CSV, or QBO. For any bank, our bank statement to Excel converter handles the full conversion.
Upload your National Bank statement here and follow the steps below:
Drag & Drop Bank Statement Here
or
While you are here
Extract every transaction from any bank PDF
Upload a statement from any bank and DocuClipper returns a clean table with dates, amounts, descriptions, and running balance intact. No reformatting before you can reconcile or import.
Step 1: Upload National Bank Statement to DocuClipper
Log into DocuClipper, or sign up for a free trial. Open the Bank and Credit Card Statements section.
Drag and drop your NBC PDF statement. DocuClipper handles English and French statements, and works with both digital and scanned PDFs (scan at 300 DPI or higher for best results).
You can also email statements directly to the address found in your account settings. Uploaded files appear under "Converted Files" in the sidebar.
Step 2: Analyze National Bank Statement
DocuClipper shows the original PDF and the extracted spreadsheet side by side with a dashboard summarizing all transactions.
Review each transaction row. NBC statements include both CAD and, for some account types, USD entries, the dashboard makes currency lines easy to spot.
Step 3: Reconcile National Bank Statements
DocuClipper reconciles the statement automatically, comparing extracted transactions against opening and closing balance figures printed on the statement. Discrepancies are flagged as not reconciled.
Edit amounts, dates, or descriptions by clicking the arrow next to each row. Use "Add Transaction" for anything missed.
Step 4: Export National Bank Statement to Excel, CSV, QBO
Click Download to export.
Export National Bank Statement to Excel
From the export menu, select Excel, then XLSX, then Download. The file saves with all transactions in structured columns.
Export National Bank Statement to CSV
Select Excel then CSV. DocuClipper provides premade formats for Xero, Sage, MYOB, Quicken, and other accounting platforms used by Canadian firms.
Export National Bank Statement to QBO
For QuickBooks, select QuickBooks to download a QBO Web Connect file. See bank statement to QuickBooks for the full workflow.
More guides on importing bank statements into different software:
- Import bank statements into QuickBooks
- Import bank statements into Sage
- Import bank statements into Xero
- Import bank statements into NetSuite
Step 5: Configure the Output Format
Before downloading, review the spreadsheet output format.
Adjust date formats (DD/MM/YYYY is common in Canada), reorder columns, and save custom layouts.
Put it into practice
Manual copy-paste is where errors begin
Split rows, drifting balances, missed transactions: they all trace back to re-keying. DocuClipper preserves the bank's layout so debits, credits, and totals tie out the first time.
How to Download National Bank of Canada Statements
NBC delivers statements through National Bank Online and the National Bank mobile app. Statements are PDFs.
On National Bank Online (website):
- Sign in at nbc.ca.
- Select My Accounts and choose the account.
- Click Statements (or Documents).
- Choose the statement period and download the PDF.
In the National Bank mobile app:
- Open the National Bank app and sign in.
- Tap the account.
- Tap Statements (or the document icon).
- Select the period and tap to view or save the PDF.
NBC retains seven years of statements through online banking. For older periods, contact a National Bank branch.
Final Advice
Canadian banks generally provide PDFs as the official statement format. CSV downloads, where available, only cover recent transaction activity, not full statement periods. For client work, prior years, or scanned paper statements, PDFs are what you'll receive.
DocuClipper converts those PDFs to Excel, CSV, and QBO automatically, so you can focus on bookkeeping rather than typing.
Why Use DocuClipper to Convert National Bank of Canada Statements
DocuClipper is a web-based tool that converts PDF bank statements into XLS, CSV, and QBO using OCR. It integrates with QuickBooks, Sage, Xero, and other accounting platforms used across Canada.
Transaction categorization groups transactions automatically, which is helpful for forensic accounting and cash-flow analysis. Beyond bank statements, DocuClipper handles credit card statements, brokerage statements, receipts, and invoices.
FAQs about National Bank of Canada Statement to Excel
Can I export my National Bank of Canada statement to Excel?
Yes. Download the PDF statement from National Bank Online or the mobile app, upload it to DocuClipper, and export to Excel (XLSX).
Does DocuClipper handle French-language National Bank statements?
Yes. DocuClipper extracts transactions from both English and French NBC statements. Column headers, transaction descriptions, and date formats are handled in either language.
Can DocuClipper convert scanned National Bank statements?
Yes. DocuClipper handles digital and scanned image-based PDFs. Scan at 300 DPI or higher for best OCR accuracy.
How do I import a National Bank statement into QuickBooks?
Convert the NBC PDF to QBO using DocuClipper's QuickBooks export option, then import via QuickBooks' Web Connect flow. See bank statement to QuickBooks.
How far back can I convert National Bank statements?
DocuClipper converts any NBC PDF regardless of age. National Bank Online retains seven years of statements; older statements can be requested from a branch.
Related Articles
Next step
Upload your first statement free
No credit card required. See extracted transactions in seconds, then export to Excel, CSV, or QBO when you're ready to scale.