Importing your records

Export them as CSV, upload them at Settings → Import, and check what MOTION says it found before letting it run.

MOTION reads the column headings and recognises what each one holds, including the headings in a Workshop Software export. Before anything is saved, it shows what it matched, what it could not, and how many rows will be created and updated.

What to bring, in order

  1. 1Customers first, because vehicles attach to them.
  2. 2Vehicles second, matched to customers by name.
  3. 3Suppliers, then products, because products can name a supplier.

Opening balances

Amounts customers owed you when you moved are imported as internal invoices, marked so that they never appear in sales or profit figures.

Analyse the whole file rather than a sample. A column that is correct for the first fifty rows and wrong for row three hundred would not show up in a sample.

Next