Table of Contents
- What You’ll Need Before You Start
- Switching Accounting Software Checklist
- How to Organize Financial Records for a New Accountant
- CRA Record Keeping Requirements for Small Business
- Security and Access Revocation During a Bookkeeping Transition
- Post-Transition Audit and Internal Controls
- Common Mistakes to Avoid in a Bookkeeping Transition
- Frequently Asked Questions
Last Updated: September 28, 2026
What You’ll Need Before You Start
A bookkeeping transition checklist for businesses works best when you gather everything first. Most owners jump straight into the new system and then spend weeks chasing missing records. Don’t do that.
Here’s what to have ready:
- Access credentials for your current accounting software
- Bank and credit card statements for the past 12 months
- Payroll records and employee tax slips
- A list of open bills you still owe
- Your most recent profit and loss and balance sheet
- Contact details for your current bookkeeper or accountant
The businesses that prepare a clean handover file save themselves weeks of cleanup later.
One warning before you begin. Don’t cancel your old software subscription until the new system is fully running. You’ll need both open during the overlap.
Switching Accounting Software Checklist
Switching accounting software takes planning, not luck. The right order is export, verify, then import. Skip the verify step and you’ll import errors you won’t find for months.
Follow these steps:
- Export all data from your current system
- Check totals against your bank statements
- Set up the new software and its chart of accounts
- Import opening balances
- Run both systems side by side for one month
- Confirm the numbers match, then close the old account
Export and Verify Your Data
Export your general ledger, customer list, vendor list, and all open balances. Save these as CSV or Excel files and store them somewhere safe.
Then verify. Add up your accounts receivable and accounts payable. Compare them to your last financial statements. If the totals don’t match, find out why before you move anything.
A common mistake is exporting only the current year. Pull at least two full fiscal years. You’ll need the history for tax filing and for any future audit trail.
Platform-to-Platform Migration Protocols
Most guides stop at “export your data.” That advice fails the moment you try to move between two real platforms, because each one structures data differently. Here is what actually happens when you move between the common pairings.
Xero to QuickBooks Online. Xero exports a single general ledger CSV, but QuickBooks Online expects separate files for customers, vendors, and items. The chart of accounts maps reasonably well, but Xero’s tracking categories do not carry over as QuickBooks classes, you must recreate them manually. Bank rules and repeating invoices do not transfer at all. Budget for two to three hours of manual re-entry per year of history.
QuickBooks Online to Xero. QuickBooks exports through its own export tool, but the file splits accounts, customers, and suppliers into separate sheets. Xero’s import wizard accepts them one at a time. Watch for QuickBooks’ “Ask My Accountant” and “Uncategorized Expense” accounts, they usually contain real transactions that need reclassification before import. Xero’s bank feed rules must be rebuilt from scratch.
Desktop to cloud (QuickBooks Desktop or Sage 50 to a cloud platform). Desktop files carry years of history that cloud importers often cap. Most cloud tools accept only the current fiscal year plus one prior year through their standard importer. Older history usually has to be attached as a PDF archive or entered manually. If you need the full history searchable, confirm the importer’s year limit before you commit.
Sage 50 to QuickBooks Online. Sage 50’s chart of accounts uses account numbers that QuickBooks Online does not require but will accept.
Map Your Chart of Accounts
Your chart of accounts is the list of categories your money moves through. The old system’s categories rarely match the new one’s exactly.
- Duplicate categories that mean the same thing
- Accounts that mix expenses and assets
- Missing tax-related categories
Before you import, run a trial import into a sandbox or test company file if your new platform offers one. Fix the mapping errors there, not in your real books.
How to Organize Financial Records for a New Accountant
Organize financial records by type and by year. A new accountant should be able to find any document in under a minute. That’s the standard to aim for.
Receipts, Bank Feeds, and Reconciliation
Receipt management is where most handovers fall apart. Loose receipts in a shoebox won’t cut it.
Here’s a simple system:
Get Started Today, book an appointment →
- Photograph every receipt the day you get it
- Store images in one cloud folder, sorted by month
- Link each receipt to the matching bank feed entry
- Reconcile your bank feeds weekly, not yearly
Payroll Records and Accounts Payable
Payroll record accuracy matters more than almost anything else in your books. Errors here create tax problems that take months to fix.
Keep these on file for every employee:
- Pay stubs and pay periods
- Source deductions you withheld
- Records of any benefits or expense reimbursements
Set up a shared folder for your new accountant before the handover meeting. Upload your chart of accounts, open payables list, and last two years of statements. It cuts the first meeting from three hours to one.
CRA Record Keeping Requirements for Small Business
The Canada Revenue Agency requires most businesses to keep records for at least six years from the end of the last tax year they relate to. Some records, like those for capital assets, must be kept longer.
What counts as a record:
- Sales and purchase invoices
- Bank statements and deposit slips
- Payroll and source deduction records
- Contracts and agreements
- Any document that supports a tax deduction you claimed
Destroying records too early is a real risk. If the CRA reviews your return and you can’t produce the paperwork, you can lose the deduction and face penalties. When in doubt, keep it one extra year.
Security and Access Revocation During a Bookkeeping Transition
Access revocation is the step almost everyone forgets. When a bookkeeper leaves, their login stays active. That’s a security gap you can’t afford.
Do this on handover day:
- Change the password on every shared account
- Remove the old bookkeeper’s user access
- Revoke any third-party app connections they set up
- Check your bank feeds for unknown linked accounts
The Access Types Most Owners Miss
A login is only one door into your books. A departing bookkeeper typically holds four or five others, and each one needs to be closed separately.
Set Up Least-Privilege Access for the New Provider
Give your new bookkeeper the narrowest role that lets them do the job. Most platforms offer at least three levels: read-only, standard user, and administrator. A bookkeeper who only records transactions does not need administrator rights, and should not have them.
A practical setup:
- Standard user access for day-to-day bookkeeping
- Read-only access for anyone reviewing reports
- Administrator access limited to one owner or the firm principal
- Separate logins for each person, never shared credentials
Do not delete the old bookkeeper’s user account until you have exported an audit log of their activity. Most platforms keep a user activity report showing who changed what and when. Once the account is deleted, that trail can become harder to retrieve. Export it first, then remove access.
Post-Transition Audit and Internal Controls
A post-transition audit catches problems while they’re still small. Run it 30 to 60 days after the switch.
Check these items:
| Check | What to Compare | Red Flag |
|---|---|---|
| Opening balances | New system vs. old statements | Any mismatch over a few dollars |
| Bank reconciliation | Ledger vs. bank feed | Unmatched entries older than 30 days |
| Accounts receivable | Customer list vs. open invoices | Missing or duplicate customers |
| Accounts payable | Vendor list vs. unpaid bills | Bills paid twice |
| Payroll totals | Pay stubs vs. journal entries | Rounding or deduction errors |
- One person records, another approves
- Monthly reconciliation, no exceptions
- A second set of eyes on any payment over a set amount
Common Mistakes to Avoid in a Bookkeeping Transition
The biggest mistake is rushing the cutover date. Owners pick a date, then discover half their data won’t import. Give yourself a full month of overlap.
Other mistakes we see often:
- Mixing business and personal finances in the new system
- Skipping the chart of accounts mapping
- Forgetting to revoke old user access
- Not reconciling before the switch
- Leaving payroll records in the old software only
Frequently Asked Questions
What documents do I need to transfer when switching bookkeepers?
You’ll need your general ledger, chart of accounts, bank and credit card statements, payroll records, accounts payable and receivable reports, and any prior tax filings. Also include login credentials for cloud accounting software, bank feeds, and merchant processors. A complete bookkeeping transition checklist for businesses should list every file so nothing is missed. Keep copies of everything you hand over.
How do I ensure data integrity during a bookkeeping system migration?
Run your accounts receivable and accounts payable aging reports, reconcile all bank and credit card accounts to zero, and back up your old data before exporting. After importing into the new system, compare opening balances, the trial balance, and key reports like profit and loss and balance sheet. Any difference means a mapping error. Document your journal entries and keep an audit trail.
What are the CRA record keeping requirements for small business during a transition?
The Canada Revenue Agency requires you to keep records for at least six years from the end of the last tax year they relate to. Records include sales invoices, purchase receipts, bank statements, contracts, and payroll records. During a transition, ensure all records are transferred and stored securely. If you keep records electronically, back them up regularly and make sure they are readable.
How long should I keep old financial records after switching systems?
Keep records for a minimum of six years after the end of the tax year they relate to, as required by the Canada Revenue Agency. For assets like property or equipment, keep records until six years after you dispose of the asset. When in doubt, retain older records longer. Digitize paper documents and store them in a secure cloud folder so you can access them if the CRA requests them.
A messy transition costs you clean books, and clean books are what every tax filing and funding application rests on. Scanlan Innovations helps owners move their records without the chaos. We focus on accounting foundations, start-up planning, and systems built for long-term growth. Book an appointment with Scanlan Innovations and start your next fiscal year with books you can trust.
Recent Comments