RBC Statement to Excel Converter

The Canada Revenue Agency generally requires records to be kept for six years from the end of the tax year they relate to. RBC's seven-year eStatement archive covers that — as long as the account stays on eStatements, stays open, and you can still sign in.

When an account closes, a business is sold or an executor deals with an estate, the PDFs that were saved are what remains. Converting them to a reconciled Excel file turns a folder of monthly statements into something an accountant, a CRA reviewer or a lawyer can search and total — while the PDF stays the document of record.

A corporate year end, a T1 with self-employment income, a mortgage file or a separation agreement usually needs twelve months, often from more than one account. Smart Merge takes up to 100 RBC PDFs and builds one workbook with every transaction in date order, the source file on every row, and a check that each statement's closing balance is the next one's opening balance.

Statements from TD Canada Trust, Scotiabank, BMO or CIBC can be merged into the same workbook, matched column by column, for a household or business that banks in more than one place.

Canadian bookkeepers mostly work in QuickBooks Online, Xero or Sage 50. FlowParse exports a QBO file that QuickBooks imports as bank transactions, a CSV that fits Xero's or Sage's bank import, and an Excel file for checking first.

Because the full description is kept — e-Transfer sender, bill payee, merchant — each line can still be matched to its invoice or receipt after the import, and the categories you assign in QuickBooks or Xero rest on the bank's own text rather than a retyped version.

An eStatement downloaded from RBC Online Banking carries real text — FlowParse reads it directly, and every amount is what the bank printed. When the statements come from a client or an applicant, ask for the eStatement PDFs rather than screenshots or photos of paper statements; those can be converted through OCR, but a text PDF leaves nothing to interpret.

Upload each statement as one file so the proof can run from the opening to the closing balance. Before switching any account back to paper, download its eStatements first — RBC says earlier eStatements no longer appear in the archive once paper is selected.

The sign comes first: two unsigned columns that become one list of positive numbers when pasted. FlowParse signs each amount by its column and proves the result against the balance. The description is second: an Interac e-Transfer, a pre-authorized debit with its reference, or a US-dollar card purchase with the exchange details can wrap over two lines, and a hand copy turns it into two rows. FlowParse keeps one transaction per row.

Third, dates: RBC prints a short date without the year on each line, and a statement that spans December and January needs the right year on each row. FlowParse takes the year from the statement period, so a sheet sorted by date stays in order across the new year.

A bookkeeper takes on a small contractor who has not reconciled the business chequing account all year. The client downloads twelve RBC eStatements and sends them as PDFs. These figures are an illustration, not a real client's.

Uploaded together, the twelve statements become one workbook in date order. Each statement is proved against its own balances, and each closing balance matches the next opening balance, so no month is missing. The bookkeeper imports the QBO file into QuickBooks, where the e-Transfer and bill-payment descriptions make most transactions easy to categorize, and the year is caught up in an afternoon instead of a week of typing.

Before you rely on converted RBC statements, check four things. Coverage: every month in the period, each closing balance matching the next opening balance — Smart Merge flags any break. Signs: deposits positive, withdrawals negative, and the sum equal to the change in balance.

The reconciled mark: every statement proved against its own balances before you use the totals. And keep the PDFs: the converted file is a working copy, the RBC eStatement is the document of record, and the CRA generally expects records to be kept for six years — download them before an account is closed or switched to paper.

Chequing and savings statements, personal and business, are the main ones: transactions between an opening and a closing balance, which FlowParse turns into rows and proves. US-dollar account statements convert the same way, in USD. RBC credit card statements convert too, as a list of purchases and payments against the previous and new balance.

Documents that summarize rather than list — a tax slip, an investment summary, a confirmation of a single transfer — are references, not inputs for a bank reconciliation. Keep them with the statements; convert the statements.