Desjardins Statement to CSV, Excel & QBO (AccèsD)

Desjardins (Mouvement Desjardins) is the largest cooperative financial group in North America and the dominant financial institution in Quebec. Rather than a single bank, it is a federation of credit unions called caisses (caisses populaires), where each member holds a folio at their local caisse. That cooperative structure, and Desjardins's reach across Quebec, means accountants and bookkeepers run into Desjardins PDF statements constantly, very often in French. The catch: Desjardins posts online statements (relevés) on the first day of the month and archives caisse account statements for 7 years, but every one of them is a PDF. AccèsD does offer a CSV download, and AccèsD Affaires adds TXT and OFX, but those downloads reach back months, not years. For older relevés, French-language statements, or any statement you only hold as a PDF, you need a converter. This guide covers every reliable way to turn Desjardins statements into CSV, Excel, or QBO, whether you hold a personal caisse folio, a Desjardins credit card (Visa or Mastercard), or a business folio on AccèsD Affaires.

Can You Download CSV Directly from Desjardins?

Only partially. Desjardins confirms that AccèsD, the online and mobile platform for individuals, lets you download a statement in CSV format for import into a database or accounting software. AccèsD Affaires gives business clients three formats: TXT, CSV, and OFX. That sounds helpful until you hit the limitations that push most people straight back to the PDF relevés.

• The download window is short: On AccèsD Affaires, transaction detail is available for the previous 62 days, downloadable CSV, TXT, and OFX data covers 12 months once online statements are turned on, and transaction search goes back up to 18 months. Desjardins publishes no window for the personal AccèsD download. Either way it is far short of the 7-year statement archive, so anything older exists solely as a monthly PDF.
• The 7-year archive is PDF: Desjardins delivers monthly account statements (relevés de compte) as PDF documents, posted the first day of the month and archived for 7 years for caisse accounts. The archive holds PDFs. The CSV, TXT, and OFX downloads are separate and reach back 18 months at most.
• Credit card downloads cover four months: Desjardins issues both Visa and Mastercard credit cards. For business cards, the AccèsD Affaires guide documents transaction lists in OFX or CSV from the Transactions tab of the card, available for four months. The monthly card statement itself is a PDF (business card statements are kept for up to 10 years), so a full year of card data almost always means working from the PDFs.
• The CSV has no header row: The CSV format documented in the AccèsD Affaires guide is a positional file with no column names. Each line carries the caisse, folio, account type, date (YYYY/MM/DD), sequence number, description, cheque number, withdrawal, deposit, interest, capital paid, advance, reimbursement, and balance, with unused fields left empty. You have to label the columns yourself (Desjardins offers templates) before the file is usable in Excel.
• No help for scanned or older statements: Paper relevés from before the online archive, or PDFs printed and rescanned for an audit file, cannot be exported from AccèsD at all. The PDF (or a scan of it) is all you have.

There is also a practical split between Desjardins's two channels. Business clients on AccèsD Affaires get documented TXT, CSV, and OFX downloads with published time limits, while for personal AccèsD Desjardins confirms only that a CSV statement download exists. If you are a sole proprietor running business expenses through a personal caisse folio or a personal Desjardins credit card, the complete record for a past year is still the stack of monthly PDF statements.

For a CRA or Revenu Quebec audit, a mortgage application, or any reconciliation older than the export window, the monthly PDF relevé is your only source. Desjardins archives caisse account statements online for 7 years, which makes the PDF the reliable long-term record, and conversion the missing step. Copy-pasting from a Desjardins PDF into Excel mangles the column alignment, splits wrapped descriptions across rows, and silently drops negative signs, and Excel's own PDF import stumbles on French headers and comma decimals. For one short relevé you might survive 20 minutes of cleanup. For a year across two folios, you are looking at hours of error-prone work that a purpose-built converter finishes in under a minute. Desjardins is not alone here. National Bank, the other major Quebec and French-language bank, has its own export gaps, and our 2026 converter roundup compares the tools that fill them.

Desjardins Statement Formats and Quirks

Desjardins produces distinct layouts for personal caisse folios, Desjardins credit cards, and business accounts on AccèsD Affaires. Statements come in English or French. 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 Desjardins members do, and your relevés arrive with French month names, French descriptions (Virement Interac, Retrait au guichet, Paiement préautorisé), 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: Desjardins caisse folio and business relevés typically split money out and money in across two columns (Retrait and Dépôt on French relevés), with a running balance (Solde) alongside. 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.

Several accounts on one relevé: A single Desjardins relevé typically lists several accounts under one folio, identified by product codes such as EOP, ET, CS, and ES, each with its own opening balance line and running balance. Some members also hold a US$ account alongside their CAD accounts. CapyParse keeps each folio's currency and running balance intact rather than blending them, so a US$ folio does not contaminate your CAD reconciliation. Multi-folio relevés are split into separate files automatically.

Multi-line descriptions: Interac e-Transfer (Virement Interac), bill payment, and pre-authorised debit (Paiement préautorisé) entries on Desjardins relevés often wrap across two or three lines, with the payee on one line and the reference number on the next. Row-based PDF scrapers split these into phantom transactions or orphan the amount from its description. CapyParse stitches wrapped lines back into a single transaction row with the full narrative intact, which is exactly what you want when matching payees in QuickBooks or building categorisation rules in Excel.

Convert Desjardins PDF to CSV with CapyParse (Step-by-Step)

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

Desjardins Credit Card and Business Accounts

CapyParse handles more than Desjardins caisse folios. Here is what to expect with the main Desjardins product lines.

Desjardins Credit Cards (Visa and Mastercard)

Desjardins issues both Visa and Mastercard credit cards. The monthly statement lists purchases alongside payments, credits, interest, and fees, and summarises the cycle with a previous total balance and a new total balance. Transaction lists can be downloaded as OFX or CSV from the Transactions tab of the card (the AccèsD Affaires guide documents a four-month window for business cards), but the official monthly statement is a PDF. For anything older, 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 so cross-border spending reconciles cleanly. A typical use case: a sole proprietor who put 2,400 CAD of deductible expenses on a personal Desjardins credit card over the year can convert all 12 statements, filter by merchant in Excel, and hand the accountant a clean expense schedule instead of a stack of PDFs.

Business Folios and AccèsD Affaires

Desjardins business clients on AccèsD Affaires manage business folios and business credit cards such as Visa Affaires, and can download statements in three formats: TXT, CSV, and OFX. The limits are published. Transaction detail covers the previous 62 days, downloadable data covers 12 months once online statements are turned on, and transaction search goes back up to 18 months. Business credit card transaction lists (OFX or CSV) are available for four months, while the PDF card statements are kept for up to 10 years. The CSV has no header row, so columns must be labelled by position. For anything older than those windows, the official record is the PDF relevé (archived 7 years for caisse accounts). CapyParse preserves the full narrative field on Desjardins business statements, including cheque numbers, EFT references, and payroll batch descriptions, and keeps the separate debit and credit columns intact, so your bookkeeper can reconcile against QuickBooks Online, Xero, or Sage without manual cleanup. Multi-folio business statements (an operating folio and a payroll folio in one PDF, for example) are split into separate files automatically.

French-Language Statement Handling

Because Desjardins is rooted in Quebec, a large share of its relevés are issued entirely in French, and this is where most generic converters fall apart. A French Desjardins relevé combines three things that trip up US-built tools at once: French month names in the dates, accented French descriptions (Dépôt, Retrait au guichet, Virement Interac, Paiement préautorisé, Frais mensuels), and French-Canadian number formatting where the decimal separator is a comma and thousands are separated by a space (1 234,56). A converter that does not understand this will misread the date, push the comma decimal into the wrong column, and mangle every accent into mojibake the moment Excel opens the file. CapyParse parses French relevés as accurately as English ones: it normalises French dates to ISO format (YYYY-MM-DD), converts comma decimals to standard decimal-point numbers, and exports clean UTF-8 so Dépôt stays Dépôt rather than turning into Dépôt. If you manage a mix of French and English clients, every statement lands in the same consistent column layout regardless of its original language.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your Desjardins relevé 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 relevés, where QuickBooks' CSV importer can stumble over French dates and comma decimals. CapyParse has already normalised both before the file reaches QuickBooks. Note that connecting Desjardins to the QuickBooks bank feed only helps going forward. Feeds backfill a few months at most, so historical catch-up still runs through the PDF relevés. For a detailed walkthrough, see our guide on importing bank statement CSVs into 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 an OFX file from Desjardins? Desjardins does not offer a QBO download, and its AccèsD Affaires guide suggests renaming the .ofx file to .qbo for QuickBooks. To open it as a spreadsheet instead, see our QBO to CSV conversion guide to flatten it into a spreadsheet.

Tips for Desjardins Conversions

Frequently Asked Questions

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

Related Articles