Steps

  1. Open Sales, Purchases or Expenses, press Import / Export, then Import from Excel or CSV.
  2. Download the Sample sheet (Excel or CSV). Fill one row per invoice line: the rows with the same invoice number make one invoice, and its date, customer or vendor, invoice discount, shipping and payment are read from its first row. Expenses take one row each.
  3. Customers and vendors are found by code, VAT number, phone or name, and products by code, barcode, part number or name. Leave Create the ones the store does not have on to add them on the way, or turn it off to see them as errors.
  4. Amount paid empty means paid in full, 0 means on credit, any other amount is what was paid; add a Second payment (part cash, part bank), a Payment date and a Paid from account when you need them. Prices include VAT = yes turns VAT-inclusive prices back into prices before VAT.
  5. Choose the file. The check shows each invoice as Ready, Imported before or Error with the row and the reason, its total, and how many customers, vendors and products will be created. Press Import, then download Rows with errors (CSV) to fix and import again.

Tips

  • Imported invoices get StartERP numbers; the old number is kept on the invoice (and as the vendor invoice number on purchases, the reference on expenses), and importing it again is skipped.
  • Imported sales take stock out and imported purchases put it in, as when they are typed. If your products' stock is already today's count, check it with a stock count after the import.
  • Saudi Arabia: imported sales are history your old system already reported to ZATCA, so StartERP shows them as Imported and never sends them again.
  • Returns are not imported: each one belongs to its original invoice, so enter it with the return form.

In the app, press F1 or ? on this screen to open this guide next to your work.

Related guides

More guides in Getting started

All guides

Still need help?

Our team answers in Arabic and English by email and phone.