Business records

What to Export Before Leaving QuickBooks: A Complete Checklist

A step-by-step checklist for preserving usable reports, source documents, open balances and business context before leaving QuickBooks Online.

SilaTrail Editorial Team · 8 min read · October 15, 2026

Changing business software is not only a subscription decision. It is a records decision.

Before you cancel QuickBooks Online—or any system that holds years of financial history—make sure you have usable copies of the information your business may need later. A single spreadsheet export is rarely enough. Reports summarize what happened, but source documents, customer and supplier details, open balances, settings and audit context explain how those totals were built.

This checklist is designed for Canadian small-business owners. It is not a substitute for migration advice from your accountant or bookkeeper. Your exact export list depends on your legal structure, tax accounts, payroll setup, payment services and the system you plan to use next.

Start before you cancel

Do not wait until the final day of your billing period.

Give yourself enough time to:

identify every company or Business file connected to the login;
ask your accountant which reports and date ranges they require;
export attachments and supporting documents;
confirm whether payroll, payments or other add-ons have separate data and cancellation steps;
test that downloaded files actually open; and
correct obvious gaps while the account is still editable.

QuickBooks Canada currently says a cancelled paid QuickBooks Online subscription generally remains available in read-only mode for one year. Its official guidance also recommends exporting or printing data before cancellation. Treat that access period as a temporary recovery window—not your long-term archive. Provider policies, account status and product-specific rules can change.

1. Make an inventory of every connected service

Begin with a simple map. List:

each QuickBooks company;
the subscription owner and authorized administrators;
the reporting currency and fiscal year-end;
linked bank and credit-card accounts;
payroll products;
payment-processing services;
receipt or document-capture tools;
third-party applications and integrations; and
accountant or bookkeeper access.

If you operate multiple Businesses, repeat the checklist for each company. Do not assume one export contains every Business associated with the same login.

Record which services are billed separately. Cancelling the accounting subscription may not cancel payroll, payments or another add-on.

2. Choose a clear cutoff date

Decide when the old system stops being the active source and the new workflow begins.

A clean cutoff is often the end of a month, quarter or fiscal year, but the best date depends on your accounting process. Ask your accountant whether transactions should be fully reconciled before the move and how outstanding invoices, bills, deposits, credits and payroll items should carry forward.

Write down:

the final date entered in the old system;
the first date to be entered in the new system;
who is responsible for late-arriving transactions; and
how corrections to the closed period will be documented.

Without a cutoff, it is easy to duplicate or omit activity.

3. Export the core financial reports

At minimum, discuss these reports with your accountant:

general ledger;
trial balance;
profit and loss statement;
balance sheet;
statement of cash flows, if used;
transaction detail by account;
account list or chart of accounts;
journal report;
sales-tax or GST/HST reports;
accounts receivable aging;
accounts payable aging; and
bank and credit-card reconciliation reports.

Export the reports for the full retention period you need, not only the current year. Save both human-readable PDFs and machine-readable spreadsheet files when the platform offers them. PDFs preserve the presentation you reviewed; spreadsheets are easier to search, filter and reuse.

Run reports using the correct accounting basis and date range. Label the basis in the file name so a future reviewer does not have to guess.

4. Export customers, suppliers and working lists

Financial statements do not preserve every operational detail.

Export relevant lists such as:

customers and contact information;
suppliers or vendors;
products and services;
recurring transaction templates;
classes, locations or projects;
payment terms;
tax codes; and
inactive records that still explain historical transactions.

Before moving contact data, confirm that the destination is authorized and secure. Customer and supplier information can contain personal information that should not be copied casually into shared drives.

5. Preserve transaction-level detail

Totals are not enough when you later need to answer a specific question.

Export or print the supporting detail for:

sales invoices and credit notes;
customer payments and deposits;
supplier bills and credits;
expenses and purchase transactions;
journal entries;
transfers;
estimates and purchase orders, if they matter to ongoing work;
outstanding cheques or payments; and
loans, owner contributions, draws and repayments.

If the destination system will receive opening balances instead of full history, keep the detailed exports in your archive anyway.

6. Download receipts and attachments separately

An exported report may include a transaction without embedding its attached receipt, contract or invoice.

QuickBooks’ current Canadian export guidance provides a separate attachments export. Download those files and test the archive. Confirm that you can connect each attachment back to a transaction using a stable name, date, amount or reference number.

Also preserve source documents stored outside QuickBooks, including:

emailed receipts;
signed agreements;
bank and card statements;
loan documents;
mileage logs;
deposit records;
contractor documents; and
correspondence explaining unusual transactions.

Do not place private attachments in a public or broadly shared folder merely to simplify the move.

7. Resolve open items

Create a list of anything that will still be outstanding on the cutoff date:

unpaid customer invoices;
customer credits or deposits;
unpaid supplier bills;
uncashed cheques;
unreconciled bank activity;
uncategorized transactions;
missing receipts;
owner-paid expenses awaiting repayment; and
questions waiting for your accountant.

For each item, record who owns the next action. Open items are easiest to lose when a migration is treated as a file-transfer exercise.

8. Handle payroll and payments as separate projects

Payroll and payment processing have their own legal, operational and data requirements.

If you use payroll, coordinate the transition with a qualified payroll professional. Preserve the records and reports required for employee earnings, deductions, remittances and slips. Do not assume that exporting the general ledger fully transfers payroll history.

If you use a payment service, document pending deposits, refunds, chargebacks, reserves and customer-payment links. Confirm how and when that service must be cancelled separately.

SilaTrail does not run payroll, file tax returns or process customer payments. Those workflows require their own destination and acceptance plan.

9. Preserve settings and audit context

Take privacy-safe screenshots or exports of settings that affect how reports were produced:

fiscal year and tax settings;
accounting method;
account mappings;
invoice numbering;
recurring templates;
user and accountant access;
closing dates; and
integration mappings.

Export an audit log when available and appropriate. It can help explain who changed a record and when. Never include passwords, tokens, private keys or bank credentials in the archive.

10. Verify the archive before cancellation

Create a verification sample:

1. Open every exported file type.

2. Compare the final trial balance and key reports with the old system.

3. Choose several transactions across different years.

4. Confirm that their source documents can be found.

5. Confirm that open customer and supplier balances match.

6. Check that every Business has its own complete folder.

7. Ask your accountant to review the package before access changes.

Keep a small index explaining what each folder contains, the date exported and the person who performed the check.

11. Keep the records for the required period

The Canada Revenue Agency generally requires business records to be kept for at least six years from the end of the last tax year they relate to. Some records and circumstances have different requirements. The CRA also says business owners remain responsible for adequate records even when a third-party provider keeps them.

Do not delete the old archive simply because the information now appears in another application. Maintain secure backups and confirm the retention period that applies to your Business.

A compact leaving-QuickBooks checklist

[ ] Every company and connected service is identified.
[ ] The cutoff date is documented.
[ ] Core financial reports are saved in PDF and spreadsheet form.
[ ] Customers, suppliers and working lists are exported.
[ ] Transaction-level detail is preserved.
[ ] Receipts and attachments are downloaded and matched.
[ ] Open balances and unresolved items are listed.
[ ] Payroll and payments have separate transition plans.
[ ] Settings and audit context are preserved safely.
[ ] Files open and key balances have been checked.
[ ] Each Business has a separate archive.
[ ] Retention and backup responsibilities are assigned.

Where SilaTrail fits

SilaTrail is a focused recordkeeping workspace for receipts, expenses, mileage, invoices, owner-paid purchases and monthly review. It can help you organize new and ongoing Business records and prepare reviewable exports. It is not a general ledger, a payroll system, a tax-filing service or a complete one-click migration destination for every QuickBooks record.

Plan the accounting-system transition with your accountant. Use SilaTrail where you need a clearer, review-first trail between source evidence and the records you prepare for professional review.

Clearer records. More confident decisions.