Convert National Bank statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Sage 50, Excel files from the PDF.
National Bank statement PDFs are not password-protected, whether they come from the personal online bank, online banking for business or the app. Online banking for business has an Export button above the transaction list offering PDF, CSV, QBO, OFX or QFX, and it respects whatever filters you have set, so filter first.
Drop your National Bank statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in CAD.
Last updated
How to download a National Bank statement as a PDF
- Sign in to your online bank at nbc.ca and select the chequing or savings account from the overview.
- Click Documents and statements, choose the document type, set the time period and click Search.
- Click the download link beside each month you need and save the PDF. It arrives in the language your account is set to.
- Business clients: in online banking for business go to Accounts and transactions, then Statements, tick the months you want and download. Several months come as a ZIP, with a bell notification when the file is ready.
- In the National Bank app: select the account, tap More, then Documents and statements, pick the time frame, tap Search and open the statement to save or share it.
Then drop the file above; several months of National Bank statements at once come back as one workbook.
Is the National Bank PDF password-protected?
National Bank statement PDFs are not password-protected, whether they come from the personal online bank, online banking for business or the app. Upload them as they are.
What National Bank statements look like
Date, Description, Withdrawals, Deposits, Balance in English, or the same table with Retrait, Dépôt and Solde on French-language accounts, with opening and closing balance lines bracketing the table.
National Bank issues statements in English or French depending on the language on your file, and the two versions share one layout: a date column, a description, separate withdrawal and deposit columns and a balance, with Retrait, Dépôt and Solde standing in for the English headers on French files. Dates are day and month with the year fixed by the period in the header. Personal statements are monthly and run two to four pages; business statements are posted around the fifth business day of the following month and carry cheque images on trailing pages, which hold no rows and add nothing to the output. US dollar accounts get their own statement in USD, so name the files accordingly, and Mastercard statements are a different document with a separate download under the card.
Why not use National Bank's own export?
Online banking for business has an Export button above the transaction list offering PDF, CSV, QBO, OFX or QFX, and it respects whatever filters you have set, so filter first. The PDF export stops at 1,000 transactions while the data formats go to 10,000, and transaction history there reaches back about 25 months. The personal online bank is thinner: the formal record is the monthly PDF, and any transaction download covers recent activity only and carries no opening or closing balance to tie to. Statements are archived for seven years, which is the archive to convert from once you are past the two-year window.
Where National Bank statements trip up converters
- French and English statements share one layout, so a mixed batch comes out with identical columns; descriptions stay in whichever language was printed.
- Business statements append cheque image pages that carry no transaction rows and add nothing to the sheet.
- Dates print without a year; the statement period in the header supplies it, and the balance check confirms the December-to-January rollover.
Which software National Bank customers import into
National Bank customers most often import into QuickBooks Online, Sage 50, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
National Bank questions
My National Bank statement is in French. Do the headers matter?
No. Retrait, Dépôt and Solde land in the same debit, credit and balance columns as their English counterparts, and the reconciliation from the opening Solde to the closing one runs the same way. Descriptions stay in French, which is what you want when matching them to your ledger. If a French and an English month sit in the same batch, both come out with identical column headings.
The business Export gave me a PDF that stopped partway through the year. Why?
The PDF export is capped at 1,000 transactions, so a busy operating account runs out before the period does. Switch the export format to CSV, which goes to 10,000, or download the monthly statement PDFs from Statements and convert those. The statements also carry the opening and closing balances that the export leaves out, so each month can be checked instead of trusted.
Can I export more than about two years from online banking for business?
Not through the transaction export; history there runs to roughly 25 months. The statement archive goes back seven years, so for an older period pick the months under Statements, download them (a multi-select arrives as a ZIP) and convert the PDFs. The closing balance of one month should equal the opening balance of the next, and a mismatch means a month is missing from the folder.
How do I convert a National Bank statement PDF to Excel?
Download it from National Bank using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many National Bank statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.