Skip to content
Export119 Docs

Migration to Export119

The Migration wizard is how trading companies bring in existing inventory, AR, AP, vault balances, cars in transit, and ownership structure from QuickBooks / Xero / Zoho / Odoo / spreadsheets. It walks you through eight ordered steps and ends with a Verify OBE checkpoint that lets you confirm your opening trial balance before going live.

When to use it

Section titled “When to use it”

Run the wizard if any of these is true:

  • You have cars currently in your inventory (purchased, shipped, or arrived but not yet sold)
  • You have open AR balances (customers owe you money)
  • You have open AP balances (you owe suppliers money)
  • You have cash in vaults or bank accounts
  • You have equity owners or investment agreements

If you’re starting from zero — first car you ever bought is going to be entered fresh — skip the wizard entirely.

The cutover concept

Section titled “The cutover concept”

Pick a conversion date (often the last day of the previous fiscal month) and freeze every balance as of that date. Everything before is history that lives in your old system; everything from the conversion date forward lives in Export119.

All migrated balances post to 3001 Opening Balance Equity (OBE) as the balancing side. After all eight steps are committed, OBE holds the algebraic sum Assets − Liabilities of your cutover. Step 8 (Owners) is where that OBE balance gets reclassified into real equity accounts — Owner’s Capital, Investor Capital Payable, Unpaid Profit Payable — based on the ownership and agreement structure you declare.

The eight steps

Section titled “The eight steps”

1. Currencies

Home + foreign currencies, spot rates at conversion date. Start →

2. Vaults

Cash drawers and bank accounts, with opening balances per currency. →

3. Counterparties

Suppliers, buyers, and stakeholders with opening AR or AP. →

4. Cars

Inventory at cutover — make/model/VIN/landed cost, with sourcing (principal or consignment). →

5. Containers

In-transit containers that link to cars from step 4. →

6. Verify OBE

Read-only checkpoint. Confirm your opening trial balance + balance sheet composition. →

7. Owners & investors

Equity holders and Mudaraba agreements. OBE reclassifies into real equity here. →

The flow is linear by accounting logic: all opening balances post first → checkpoint → reclassify equity at the end. You can navigate back and forth between steps; each step’s commit is idempotent on re-submit.

Inputs you’ll need before starting

Section titled “Inputs you’ll need before starting”
  • Conversion date. The single date everything posts on.
  • List of currencies you trade in, with spot rates against home as of conversion date.
  • Vault list, with opening balances per currency.
  • Counterparty list (suppliers + buyers), with name and opening balance (positive = AR, negative = AP) per currency.
  • Car inventory with make/model/year/VIN/landed cost per car, grouped by purchase currency.
  • In-transit container list with the cars on each.
  • Ownership structure — equity owners with %, and any Mudaraba or equity-investment agreements with declared capital and profit split.

The fastest way to enter Steps 3, 4, 5 is the Excel templates offered on each step. Each template has a Validate button that shows row-by-row errors before commit. Inline grids are available for smaller datasets (≤50 rows).

What “going live” looks like

Section titled “What “going live” looks like”

After Step 7 commits:

  • Your 3001 OBE account should be zero (or close to it, modulo legitimate residual ownership).
  • Your trial balance is your cutover state.
  • Your balance sheet balances (Assets = Liabilities + Equity).
  • You can immediately add new cars, issue invoices, record payments — all on top of the migrated foundation.
Section titled “Related”