Run the tools below in order. AR & AP Aging come before GL Detail — the aging defines what's open at cutover; GL Detail then fills in the historical transaction ledger using the aging-created rows as anchors. This preserves the original QB invoice numbers and keeps the AR/AP reports accurate.
Import QB Chart of Accounts. Tool maps QB account types into GENUS Account Sections, Groups, and chartmaster accounts. Preview & edit before commit.
Upload a QB Trial Balance to set starting balances at the cutover date (skip if GL Detail covers from day one). Posts gltrans + updates chartdetails for period-aware reporting.
If your Opening Balance TB is pre-close, run this to zero out P&L accounts and roll the net to Retained Earnings. Required before TB Compare matches a post-close QB TB.
Upload QB AR aging. Creates debtortrans rows for OPEN invoices/credits only, preserving the original QB invoice number as transno. Run BEFORE GL Detail so it can skip duplicates.
Upload QB AP aging. Creates supptrans rows for OPEN bills only, preserving the QB bill number as transno. AP Aging is the sole source of supptrans rows — GL Detail does not create supptrans.
Post all QB transactions to gltrans for full GL history. Optional opt-in: bring in fully settled closed invoices — creates closed-invoice debtortrans rows for reprint + one synthetic "QB Pre-Cutover Settled" offset per customer that nets them to zero in AR reports.
Optional: upload QB Sales by Item / Invoice Detail to add line-level stockmoves to historical invoices in the Historical location. Auto-creates discontinued SKUs for unknown items. Inventory unaffected.
Upload an inventory snapshot. Packs into masterpacks (cartoncount = full cases when case pack is provided, single carton otherwise). Posts purchorderdetails on the internal OPENING-STOCK PO, updates locstock, and writes opening-balance stockmoves. Warehouses and SKUs fuzzy-matched or auto-created.
Move inventory between locations from a spreadsheet. Each row (stockid + qty) is classified against the source's on-hand and masterpack composition: ok exact, whole packs, partial split, below min pack, exceeds source, or not at source. Commit updates locstock, writes stockmoves type=16, flips masterpacks.loccode, splits a masterpack if the qty doesn't align, and audits via loctransfers / loctransfermasterpacks.
Upload a QB Vendor Contact List. Each row is fuzzy-matched against existing suppliers using a word-overlap scorer that returns the top 5 weighted candidates per vendor. Pick one per row to update the matched supplier (address / contact / phone / email / fax / terms / tax id — only non-empty cells overwrite), create a stub, or skip. Column mapper for non-standard headers.
Upload a QB Customer Contact List. Each row is fuzzy-matched against existing debtorsmaster with six confidence buckets (auto ≥90% / fuzzy 70/60/50/<50% / no-match). Per-row dropdown of the top 5 candidates + bulk-set actions per bucket. Updates write to debtorsmaster.address1..6 (ship-to) and the primary custbranch row (braddress / phoneno / email / contactname / salesman); only non-empty cells overwrite. Column mapper for non-standard headers.
Upload the QB Trial Balance and diff against the GENUS GL state at the same as-of date. Account-by-account variance report verifies that opening balances, AR/AP, and inventory all tied out.
When TB ties but P&L doesn't. Upload the QB Profit & Loss for a date range and the tool diffs every P&L account against GENUS — calling out classification mismatches (same balance, different section), value diffs, and accounts missing from either side. Drill into any account to see the underlying gltrans.
Verify (and extend) the periods table to cover your GL Detail's full date range BEFORE running GL Detail. If a GL transaction predates the earliest period, the import otherwise silently dumps everything into period 1 and corrupts chartdetails. Required when the seed periods don't go back far enough.
Forensic toolkit for investigating TB Compare differences: inspect a list of accounts (chartmaster existence, chartdetails balance at as-of date, gltrans activity), search gltrans by narrative ("where did the chargebacks go?"), or find any specific amount across the GL.
Standalone tool: import open sales orders from a QuickBooks open-orders report. Independent of the migration flow above.
Wipe gltrans / chartdetails / sub-ledger / chartmaster from a target database so you can re-run the migration from scratch. Destructive — confirm-twice required.