QuickBooks/Xero → Acumatica migration
For implementing partners · Test/sandbox write · not production
The prospect is outgrowing QuickBooks or Xero and wants to see their business in Acumatica before they commit. A throwaway demo does not close the deal — and a one-shot go-live is too late to learn.
You get. A test-tenant-first migration: source books connected and exported (Xero over read-only OAuth; QuickBooks the same connect-and-export shape), then loaded into versioned configuration and master data on a populated test tenant the client can click through. The same configuration tree iterates toward go-live through a rehearsable cutover — not a one-week tool drop.
This is a migration engagement with a rehearsable cutover — not a migration-tool product you install and run alone.
I connect Xero over OAuth, export the cutover pack, and stand up the Acumatica test tenant from YAML and GitOps Code. QuickBooks gets the same connect-and-export path — parallel to the Xero exporter, not a second product pitch.
the obvious question
“Why not just import QuickBooks or Xero data once and go live on cutover weekend?”
A single import pass can move masters and opening balances when the source is clean and the mapping is already trusted. For a tiny chart of accounts and a patient controller, one-shot load is sometimes enough.
- The prospect never saw their business in Acumatica before commit. A throwaway import on cutover night is too late to discover mapping mistakes, missing dimensions, or workflow gaps. The deal needs a clickable test tenant first.
- Field mapping dies in a spreadsheet. Workshop decisions that live only in email and Excel do not survive the next pass. Without mapping in the same configuration tree, every rehearsal restarts the argument.
- One dress rehearsal is not enough when setup costs a week. If rebuild and load are expensive, the team gets one attempt — or none — and the controller signs spreadsheets nobody fully trusts.
One-shot import when the source is trivial and risk is accepted. Use test-tenant-first migration when the prospect must click through their books in Acumatica and iterate the same tree toward a rehearsable go-live.
how it works
Source books → populated test tenant → field mapping in the tree → cutover dress rehearsal — one configuration tree.
Nothing installs inside Acumatica. This is a test-tenant-first migration engagement, not a one-week tool drop you keep running.
- Connect and export the source books
- Xero connects over read-only OAuth and exports a cutover data pack (masters, opening balances, open AR/AP). QuickBooks uses the same connect-and-export shape — not a live connector and not multi-year history unless the SOW says so.
- Populated Acumatica test tenant the prospect can click through
- That pack becomes versioned configuration and master data on a populated test tenant — their business in Acumatica, not a canned demo and not a one-shot cutover night.
- Field mapping that lives in the same tree
- Agreed field mappings sit in the same configuration tree as the tenant — reused on the next workshop pass, not lost in a dead spreadsheet.
- Cutover dress rehearsal on the same tree
- Rebuild, load what was scoped, exercise, reconcile, tear down — iterate the same configuration tree toward go-live until it is boring and the controller has a reconciliation trail.
Work product stays in your repository. Test and sandbox write only until the SOW says otherwise — never a silent production cutover. Source access is read-only on Xero/QuickBooks; your Acumatica version is pinned for the engagement.