Migrating from spreadsheets to QuickBooks Online
The 30-day migration playbook that keeps books clean.
- Export 12 months of transactions to CSV.
- Set up QBO Chart of Accounts before importing.
- Import opening balances as journal entries, not transactions.
- Bulk categorise using Bank Rules.
- Reconcile month by month backwards until the trial balance ties.