Trimming Sage 50 History with the Purge Wizard Before a QuickBooks Conversion
Old fiscal years bloat a Sage 50 file and follow it into a QuickBooks Desktop conversion; this playbook shows how to hand over a trimmed, balanced backup.
QuickBooks Desktop conversions from Sage 50 run on the backup exactly as it is provided. Nothing trims the data on the way through. When you want recent history only, the trimming has to happen in Sage first, with the Purge Wizard. Run on a verified copy, the wizard is safe and predictable. Run on the original, it deletes history permanently. Our engineers use the sequence below whenever a cutoff date matters.
What does a Sage 50 purge remove?
The wizard deletes transaction detail from closed fiscal years. It keeps your chart of accounts and your customer, vendor, and employee lists. Open items survive too: unpaid invoices, unpaid bills, quotes, sales orders, and open purchase orders carry over untouched. Balances from the removed years roll into beginning balances for the earliest year kept, and prior-year income and expense fold into retained earnings at the cutoff. The detail behind those numbers is what disappears, and it does not come back. Cleared status in the purged bank reconciliations goes with it.
Which years should you keep?
Set the cutoff on a fiscal year boundary, because the wizard works in whole closed years. Keep every year your reporting still depends on, including payroll quarters and sales tax periods. Keep at least the current year and the one before it, more if your reporting obligations reach back further. Decide deliberately, because after conversion the trimmed file becomes the live company. The purged years will exist only in the archive you keep of the original.
Prepare the copy, never the original
Close every fiscal year you plan to remove; the wizard will not touch an open year. Working in the original, print your acceptance baselines first. You want a trial balance dated the last day of the purge range. Add an aged receivables report, an aged payables report, an inventory valuation, and a list of open orders. Then take a full backup of the original and store it as the permanent archive. Restore that backup into a separate folder as the working copy, open it, and confirm it matches the original.
Never point the wizard at the original. The purge is irreversible, and the original is the only complete record of the years being removed. The archived backup is your rollback point for everything that follows, so treat both as read-only from here on.
Run the purge on the copy
Launch the Purge Wizard inside the copy, and let it back up before it starts; that backup is the rollback point for this step. Select the closed years through your cutoff. Some releases also offer to drop inactive names, such as customers or vendors with no recent activity. Skip that unless you truly want the lists thinned, because name lists are cheap to convert and expensive to rebuild.
Let the purge run to the end without interruption; a large file can take a while. When it finishes, run Sage's data verification on the copy before you judge anything else.
Confirm the balances carried forward
Open the earliest retained year and compare its opening trial balance, account by account, against the closing trial balance you printed earlier. Every line must match. Compare the aging reports at the cutoff date; open receivables and payables must agree to the cent. Check quantities on hand against the inventory valuation from the original. Run a balance sheet dated the first day of the retained range, and confirm assets equal liabilities plus equity. If you are inside a payroll year, verify the year-to-date wage figures survived.
If any check fails, do not patch the numbers by hand. Restore the pre-purge backup of the copy, narrow the purge to fewer years, and run it again. The original has not been touched at any point; that is the design.
Build the backup that gets converted
With every check green, make a fresh Sage backup of the trimmed copy and note the new file size beside the old one. The shrink is your confirmation the purge did real work. This backup is the file that gets converted, and conversion runs on it as provided, so the fiscal years inside it are exactly the ones that arrive in QuickBooks Desktop. Label the archive and the trimmed backup clearly; you will want both later. Have the admin credentials and the first month of your fiscal year written down. If we are handling the move, our Sage 50 to QuickBooks conversion service page describes what happens to the file next.
What does a clean outcome look like?
The trimmed copy opens cleanly and passes data verification. The first retained year begins with balances that match the original's closing balances exactly. Aging reports and inventory quantities agree with the pre-purge baselines, and the backup restores on a second machine without complaint. The original, still whole, holds every year you removed. You end with two deliberate files: a live QuickBooks Desktop company carrying the years you chose, and a complete Sage archive holding the rest.