AccountEdge Pro to QuickBooks Online: a Full Migration Playbook
Moving an AccountEdge Pro company to QuickBooks Online stalls on currency rules and untidy cards; this playbook carries it through, balances intact.
AccountEdge Pro grew out of MYOB, and its files carry structures QuickBooks Online does not expect. Cards replace name lists, accounts sit under header levels, and a multi-currency setting can decide the whole route. Our engineers run this migration as four phases: confirm eligibility, clean the source, move the data, and reconcile the result. Each phase ends at a rollback point, and none can be skipped.
Does the file qualify for a direct conversion?
Single currency is the gate. If the AccountEdge file tracks more than one currency, the direct path closes. The online product treats multi-currency as a one-way setting, fixed when the company is created, and mixed-currency history does not survive intact. A multi-currency file must be reduced to one home currency first, or moved by a route that rebuilds balances rather than translating them.
Eligibility also depends on size and health. The import enforces its own limits on lists and history, and damaged records fail before those checks run. Open the file as administrator, run its verification utility, and export a current backup. That backup is the first rollback point; archive it read-only and leave it untouched.
Clean the cards, accounts, and history before export
Start with cards. AccountEdge keeps one card per contact, and a single card can act as both customer and supplier. The online product splits contacts into separate customer and vendor lists, so a dual-purpose card imports twice or drops one side. Separate those cards into two clearly distinct names. Inactive cards with open balances are the next trap; they produce agings that never tie. Zero the balances or leave the cards active.
Then the chart of accounts. Collapse header levels you do not need: the destination supports one level of subaccount, and deeper nesting flattens on arrival. Confirm every detail account maps to a supported type. Equity and liability classifications differ between the products, and an unmapped account lands in a catch-all you must journal out later.
History comes last. Fix a cutover date, and convert open balances plus only the history you will actually reference. Before export, save the trial balance, balance sheet, profit and loss, both agings, and every bank reconciliation as of that date. Those reports are the reconciliation baseline; they cannot be regenerated faithfully afterward. Take a second backup once cleanup is done, and treat it as the rollback point for the export.
The route through QuickBooks Desktop
When a direct conversion does not qualify, do not force it. The reliable alternative lands the data in QuickBooks Desktop first, then exports from Desktop through the vendor's built-in migration tool. Desktop accepts more of the AccountEdge structure, and the Desktop-to-online pipeline is the most mature path the vendor runs. The first leg of that route is our AccountEdge and MYOB conversion service.
In Desktop, run Verify Data and resolve everything it flags. Set the cutover balances and confirm the trial balance against your baseline. If the intermediate file is oversized or sluggish, preparing a Desktop file for QuickBooks Online import trims it to survive the upload. Have the AccountEdge backup and its administrator password ready before this leg starts.
One boundary is worth stating plainly: the upload into the online product is performed solely by the vendor's import tool. We repair, condense, and verify the company file so it clears that upload; we do not run the upload itself. Keep the Desktop intermediate file after go-live. If the online load drops lists or mangles balances, you correct the Desktop file and export again rather than restart from AccountEdge. That file is the rollback point for the whole online phase.
Reconcile the balances after go-live
Freeze new entry until reconciliation is done, or the cleanup will chase a moving target. Work in this order:
- Compare the trial balance as of the cutover date against the saved baseline, and investigate every difference beyond rounding.
- Reconcile each bank and credit card account to the statement date last used in the old file. The beginning balance must equal the final reconciled ending balance; if it differs, an opening entry was shifted.
- Tie the receivables and payables aging totals to the final old-system agings. Duplicates from split cards surface here first.
- Spot-check inventory quantities and the inventory asset value against the old item list.
- Clear Opening Balance Equity down to documented opening entries only; whatever remains is a mapping error.
For the wider discipline, our month-end close and reconciliation practice covers what a migration does to a set of books and how to close it cleanly afterward.
What does a clean outcome look like?
The trial balance ties to the baseline within rounding. Every bank and card account reconciles through the cutover statement, and both agings match the source. Each contact appears once, under the correct list. Opening Balance Equity holds only entries you can explain.
Archive the old file read-only alongside the saved reports. The migration is not a reason to discard the source; retention obligations outlast any conversion, and the archive is the fallback if a question surfaces a year later.