Convert Simplii Financial Statements to CSV, Excel & QBO

Simplii Financial is one of Canada's largest online-only banks, and it has a longer history than its 2017 launch date suggests. Simplii is the direct banking division of CIBC, created when CIBC ended its long-running President's Choice Financial banking partnership and migrated former PC Financial banking customers to the new Simplii brand. There are no branches: Simplii runs entirely on CIBC's banking network and CIBC-branded ATMs, with everything else handled online or by phone. That branchless model means there is no teller to print you anything, and every record you keep arrives as a PDF eStatement. While Simplii keeps several years of those statements online, none of them comes as a spreadsheet. This guide covers every reliable way to convert Simplii Financial statements into CSV, Excel, or QBO, whether you hold a No Fee Chequing Account, a High Interest Savings Account, a Cash Back Visa, or a personal line of credit.

Can You Download CSV Directly from Simplii?

Only partially, and the gap matters. Simplii online banking does include a Custom Search tool that lets you filter transactions by date range and pull them as an activity feed, which can be exported. That is genuinely useful for a quick look at recent spending. But it is an activity feed, not the official monthly statement, and for anything beyond a recent reconciliation the limitations push you straight back to the PDF eStatements.

• eStatements are PDF-only: Simplii delivers monthly statements as PDF documents, full stop. There is no CSV or Excel version of a statement, even though several years of them sit in your online archive.
• Custom Search is a feed, not a statement: The Filter by date range export reflects a live activity feed, not 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.
• The Cash Back Visa is the weak spot: Your full Simplii Financial Cash Back Visa statement is built around the monthly PDF. Spreadsheet-friendly exports for card activity are limited, so a full year of credit card data almost always means working from the PDFs.
• No branch fallback: Simplii has no branches. There is no teller to reprint a statement, no in-person export, and no paper trail unless you saved the PDF. The eStatement is the record, and you are responsible for retrieving it.
• Paper statements are limited to seniors: Clients aged 60 and over can request free monthly paper chequing statements, but for everyone else the only format is the online PDF. Either way, paper or PDF, it is not a spreadsheet.

In practice, that means any job longer than a recent reconciliation ends up running through the monthly PDF statements: a full personal tax year, a CRA review, a mortgage application that needs 12 months of history, or bookkeeping catch-up for a client. Simplii keeps several years of eStatements online (roughly 7 years, in line with most Canadian banks), which makes the PDF the most reliable long-term source of truth. The question is how to get the data back out.

The manual alternatives are painful. Copy-pasting from a Simplii PDF into Excel mangles the column alignment, splits wrapped descriptions across rows, and silently drops negative signs. Excel's built-in PDF import does better with simple tables but stumbles on Simplii's section headers, carried-forward balances, and cash-back rewards summaries. For one short statement you might get away with 20 minutes of cleanup; for a year of statements across two accounts, you are looking at hours of error-prone work that a purpose-built converter finishes in under a minute. Simplii is hardly unique here. Its parent CIBC and rivals like RBC have their own export gaps, and our 2026 converter roundup compares the tools that fill them.

Simplii Statement Formats and Quirks

Simplii uses distinct statement layouts for everyday banking accounts, the Cash Back Visa, and lines of credit. Knowing which one you are holding makes a real difference to the converted output.

The Cash Back Visa date trap: Simplii Cash Back Visa statements list transactions as MMM DD (often with both a transaction date and a posting date) and leave the year to the statement header, because each statement covers a single billing cycle. If you are batching several months of Cash Back Visa statements, the converter has to read the year from the header rather than the rows. CapyParse does this automatically and outputs ISO dates (YYYY-MM-DD), so a December purchase that posts in January never lands in the wrong tax year.

Cash-back rewards are not money: Simplii prints a cash-back rewards summary on the Cash Back Visa statement: cash back earned this period, cash back redeemed, and the current reward balance. A naive PDF scraper will happily pull a dollar-denominated cash-back figure into your amount column and quietly wreck the reconciliation, because cash-back rewards look exactly like a transaction amount. CapyParse recognises the rewards section as non-monetary and keeps it out of your transaction rows entirely, the same way it isolates Scene+ points on Scotiabank cards.

Separate withdrawal and deposit columns: Simplii chequing and savings statements split money out and money in across two columns, with a running balance 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 in Excel (where two columns are often easier to work with).

Multi-line descriptions: Interac e-Transfer, bill payment, and pre-authorised debit entries on Simplii statements 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 Simplii PDF to CSV with CapyParse (Step-by-Step)

Here is how to turn any Simplii PDF statement into a clean CSV, Excel, or QBO file in under a minute.

Simplii Cash Back Visa and Other Accounts

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

Simplii Financial Cash Back Visa Card

The Simplii Financial Cash Back Visa Card follows the standard Simplii credit card statement format: an account activity summary up top, then a transaction list with transaction date, posting date, description, and a single amount column, plus a cash-back rewards summary showing the cash back you earned and redeemed during the cycle. Because that rewards figure is denominated in dollars, it is exactly the kind of line a generic scraper mistakes for a transaction. CapyParse tags purchases, payments, refunds, interest, and fees separately so your Excel export distinguishes real spend from card payments automatically, and it keeps the cash-back summary out of the money column entirely. 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 Cash Back Visa 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.

Savings, US$ Savings, Lines of Credit, GICs, and Mortgages

Beyond the No Fee Chequing Account, Simplii's lineup includes the High Interest Savings Account, a US$ Savings Account, personal and secured lines of credit, mortgages, GICs, and mutual funds, all of which generate PDF statements or transaction documents. CapyParse converts them while preserving the details that matter for reconciliation: interest postings on savings and GIC statements, advances and payments on line of credit statements, and the separate debit and credit columns on everyday accounts. The US$ Savings Account is worth a note: its statement amounts are in US dollars, and CapyParse keeps the currency consistent through the export so you do not accidentally mix USD and CAD figures in the same column. As a division of CIBC, Simplii often shows up alongside CIBC accounts in the same household or business books. If you handle both, see our CIBC statement to CSV guide for the parent bank's quirks, since CapyParse normalises statements from both into the same consistent output.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your Simplii 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, which matters most for Cash Back Visa statements where there is no native spreadsheet export to fall back on. Note that connecting Simplii to the QuickBooks bank feed only helps going forward. Feeds typically backfill a few months at most, so historical catch-up still runs through the PDF statements. 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 HST/GST categorisation formulas. The Excel (.xlsx) export preserves transaction-type tags on Cash Back Visa statements so you can slice card activity by purchases, payments, or interest in one click.

Already exported a QBO or OFX file somewhere? If you have a QuickBooks-format file and just want a spreadsheet, see our QBO to CSV conversion guide to flatten it into a spreadsheet.

Tips for Simplii Conversions

Frequently Asked Questions

Related Articles