Preview before importing, preserve the source exports, and compare trial balance and financial statements at the same cutoff before connecting new bank activity.
1. Define the migration scope and cutoff
Confirm the legal or reporting entity, accounting basis, fiscal year, source QuickBooks file, and the last date included in the historical export. Decide whether the destination is empty or contains data that may be replaced.
Document modules that are outside the supported migration. A financials import may not include payroll, inventory, projects, attachments, bank rules, app integrations, or historical reconciliations.
- Correct source company
- Accounting basis and fiscal calendar
- Historical cutoff date
- In-scope and excluded records
2. Preserve and inspect the exports
Save the source Chart of Accounts and Journal CSVs with a clear date and company name. Keep a read-only source copy and export the source trial balance, Income Statement, and Balance Sheet at the same cutoff.
Inspect date, amount, account, memo, and identifier columns before upload. Spreadsheet formatting can silently change dates, remove leading zeros, or turn long identifiers into scientific notation.
- Chart of Accounts CSV
- Journal CSV
- Source trial balance
- Source financial statements
3. Run a preview and resolve validation issues
Review account normalization, account types, duplicate identifiers, journal balance, date ranges, currency or amount parsing, and the number of accounts and entries expected.
If the destination contains ledger data, read the replacement summary carefully. A confirmation should be tied to the current preview so later source drift cannot reuse an old approval.
- Balanced journal entries
- Account type mapping
- Date and amount validity
- Current destination impact
4. Import once the plan is understood
Use an idempotent or tracked import workflow so a retry does not create duplicate history. Record the import job and retain the uploaded files and preview evidence according to firm policy.
Do not start new live bank activity during an uncertain cutoff. Decide which source owns each date range.
- Tracked import job
- Explicit replacement confirmation
- No overlapping live-feed cutoff
- Preserved source and preview evidence
5. Prove the destination books
Compare destination trial balance totals and account balances with the source at the same date. Review the Income Statement and Balance Sheet, inspect retained earnings and equity, and spot-check high-volume or material accounts in the register.
Then configure bank accounts, Plaid activity, statement coverage, and the opening reconciliation position. Migration is complete when the destination books and operating cutoff are understood—not merely when the job says success.
- Trial balance comparison
- Financial statement comparison
- Register spot checks
- Bank and reconciliation opening setup
Related reading
Put the workflow into practice