RMK Tech Services logoRMK Tech ServicesAccurate & Accept

How to

Bring your products and parties from Excel or your old software

Import products with variants, units and opening stock, customers and suppliers from Excel or CSV — your own column names are matched for you.

  1. 1Open Products (or Customers & Suppliers) and click Import.
  2. 2Pick your file (.xlsx or .csv). Report titles above the headings are fine; the heading row is found for you.
  3. 3Each column is matched to a field: same name, a known name from other software (Item name, Selling rate, GST %, UOM, HSN code, Mobile, GSTIN…), or a guess marked “check”. Change any match from the drop-down.
  4. 4For a needed field with no column, type one value for every row.
  5. 5Preview shows new, changed and unchanged rows and every problem with its row number; Download rows to fix gives you just those rows back.
  6. 6Import. Opening stock goes in as stock entries you can correct on the Stock page.

Tip: Export on every master screen gives the same layout back, so you can edit in Excel and import again. Re-importing the same file doesn't double the stock.

More on RMK Billing