National Bank Statement to CSV: Beyond 25 Months

National Bank of Canada (Banque Nationale, NBC) is Canada's sixth-largest bank, headquartered in Montreal and founded in 1859 by francophone businessmen. It dominates Quebec banking and has been expanding across the country, which means accountants and bookkeepers everywhere increasingly run into NBC PDF statements, often in French. The catch: National Bank's online transaction download only reaches back about 25 months, while its PDF eStatement archive holds up to 7 years. For anything older than two years, you need a converter. The same goes for any statement written in French with comma decimals and accented descriptions. This guide covers every reliable way to turn National Bank statements into CSV, Excel, or QBO, whether you hold an NBC chequing account, a National Bank Mastercard, or a business account on Internet Banking Solutions for Businesses.

Can You Download CSV Directly from National Bank?

Partially. National Bank online banking includes a transaction export that supports CSV (Excel-readable), QBO (QuickBooks), OFX, and QFX (Quicken) formats. On the business side it can handle up to 10,000 transactions per export. That sounds generous until you hit the limitations that push most people back to the PDF statements.

• History capped at about 25 months: National Bank's online transaction history for bank accounts and credit card operations reaches back roughly 25 months. The export can only cover what the history shows. Anything older exists solely as a monthly PDF eStatement, of which NBC keeps up to 7 years.
• Transaction feed, not the statement: The export reflects a live activity feed rather than the official monthly statement. Statement-period balances, interest postings, and the exact cut-off dates your accountant reconciles against live in the PDF, not the feed.
• Official Mastercard statements are PDF-only: Your full National Bank credit card statement is accessed through Download my eStatements in online banking or the app, and that download is a PDF. There is no statement-period CSV for the official credit card statement.
• The 2-year statement search window: Even within the 7-year eStatement archive, the statement search tool only covers a 2-year date range at a time. Pulling a full audit trail means running the search several times. Even then you still end up with PDFs, not spreadsheets.

There is also a practical gap between NBC's two banking channels. Business clients on Internet Banking Solutions for Businesses get the full export menu (CSV, QBO, OFX, QFX, filters, and high transaction limits), while personal banking leans much more heavily on PDF documents, especially for credit cards, where the complete monthly statement is a PDF download. If you are a sole proprietor running business expenses through a personal NBC account or a personal Mastercard, you inherit the weakest export options precisely where you need spreadsheets most.

For a CRA or Revenu Quebec audit, a mortgage application, or any reconciliation older than two years, the monthly PDF eStatement is your only source. NBC has archived chequing account statements since April 2016 and Mastercard statements since August 2020, keeping up to 7 years online, which makes the PDF the reliable long-term record, and conversion the missing step.

National Bank Statement Formats and Quirks

National Bank produces distinct layouts for personal chequing, Mastercard credit cards, and business accounts. Every layout exists in both English and French, depending on the language of your account profile. Knowing which you are working with makes a big difference to the converted output.

The French statement trap: Bank in French (as a huge share of NBC's Quebec customers do) and your statements arrive with French month names (10 juin, 3 fevr.), French descriptions (Virement Interac, Retrait au GAB, Paiement de facture), and French-Canadian number formatting with comma decimals and spaced thousands (1 234,56). Generic PDF converters built for US banks choke on all three: the dates fail to parse, the comma decimal lands in the wrong column, and accented characters come out garbled as Dépôt instead of Dépôt when Excel misreads the encoding. CapyParse's extraction works regardless of statement language: it reads French dates and amounts natively, outputs ISO dates (YYYY-MM-DD) and standard decimal-point numbers, and exports clean UTF-8 so every accent survives the trip into Excel or QuickBooks.

Separate withdrawal and deposit columns: NBC personal and business chequing statements split debits and credits across two columns. CapyParse exports both the original two-column layout and a normalised signed amount column in the same file, so you can import into QuickBooks (which prefers a signed amount) or pivot the two columns in Excel.

Older and scanned statements: If you hold paper NBC statements from before the eStatement archive began, or PDFs that were printed and rescanned for an audit file, the online export cannot help at all. CapyParse's OCR pipeline handles scanned statements in both languages, reading the same table structure from an image-based PDF that it reads from a native one. See our guide to converting scanned bank statements to CSV for the details.

Convert National Bank PDF to CSV with CapyParse (Step-by-Step)

Here is how to turn any National Bank PDF statement (English or French) into a clean CSV, Excel, or QBO file in under a minute.

National Bank Mastercard and Business Accounts

CapyParse handles more than NBC chequing accounts. Here is what to expect with the main National Bank product lines.

World Elite, Platinum, and mycredit Mastercard

National Bank World Elite Mastercard, Platinum Mastercard, mycredit Mastercard, and NBC's other personal and business credit cards share the standard NBC credit card statement layout: transaction and posting dates, merchant descriptions, and a single amount column, with payments, credits, interest, and fees mixed into the activity. Since the official monthly statement is only available as a PDF through Download my eStatements, CapyParse is the practical route to a spreadsheet: it tags purchases, payments, refunds, and interest so your Excel export separates real spend from card servicing automatically. Foreign currency purchases are preserved alongside their CAD equivalent, and NBC keeps Mastercard eStatements online going back to August 2020, all of which CapyParse can convert.

Business Banking and Internet Banking Solutions for Businesses

NBC business clients on Internet Banking Solutions for Businesses get the strongest native export of any National Bank channel: CSV, QBO, OFX, and QFX, up to 10,000 transactions at a time, across as many as 100 accounts. But it shares the same ceiling: the export only covers the online transaction history window, and the official record for anything older is the PDF statement (archived up to 7 years). CapyParse preserves the full narrative field on NBC business statements, including cheque numbers, EFT references, and payroll batch descriptions. It also keeps the separate debit and credit columns intact, so your bookkeeper can reconcile against QuickBooks Online, Xero, or Sage without manual cleanup. Multi-account business statements are split into separate files automatically.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your National Bank statement as a QBO file from CapyParse and import it directly into QuickBooks Online via Banking > Upload transactions, or into QuickBooks Desktop via File > Utilities > Import > Web Connect Files. The QBO format skips CSV column mapping entirely. That is particularly useful for French statements, where QuickBooks' CSV importer can stumble over French dates and comma decimals. CapyParse has already normalised both before the file reaches QuickBooks.

Excel and Google Sheets

The CSV export opens directly in Excel or Google Sheets. All transaction fields appear in separate columns: date, description, withdrawal, deposit, running balance, and a normalised signed amount. Everything is ready for sorting, filtering, pivot tables, or custom GST/QST categorisation formulas. Because CapyParse exports clean UTF-8, French merchant names and accented descriptions display correctly instead of turning into mojibake.

One Excel-specific tip for francophone users: if your copy of Excel runs in French-Canadian regional settings, it expects semicolon-delimited CSVs and comma decimals, which can scramble a standard comma-delimited file on double-click. Import via Data > From Text/CSV instead and Excel will detect the delimiter correctly. Google Sheets handles either convention automatically on upload, and the Excel (.xlsx) export from CapyParse sidesteps the issue entirely since it carries no delimiter at all.

Already have a QBO or QFX file from National Bank? See our QBO to CSV conversion guide to flatten it into a spreadsheet.

Tips for National Bank Conversions

Frequently Asked Questions

Working with other Canadian banks too? We have matching guides for RBC Royal Bank statements and BMO statements, plus a full roundup of the best bank statement to CSV converters in 2026 if you want to compare tools before committing.

Related Articles