Import customers, suppliers, items and opening stock from Excel

Move from Tally, BUSY or a spreadsheet in minutes: download the sample file, paste your data and import parties, items and stock.

You do not have to type your masters one by one. Company → Import from Excel (shortcut Alt+O) takes Excel (.xlsx) and CSV files.

Steps

  1. Open Import from Excel and pick what you are importing: Parties, Items or Stock.
  2. Download the Demo template (Excel). Its column names are the ones the import expects.
  3. Paste your data under the headings. Keep one party or item per row.
  4. Upload the file and click Import. Rows that cannot be read are listed with the reason, so you can fix only those and import again.

Tips

  • From Tally or BUSY: export the ledger or stock item list to Excel, then copy the columns into the demo template.
  • GSTIN and state: give the GSTIN for registered parties. The state is read from it, and it decides whether CGST + SGST or IGST is charged.
  • HSN / SAC and GST rate on items save time on every invoice later.
  • Opening stock: import items first, then stock with the Stock as on date. Usually that is the day before you start billing in the app.

Common questions

Will importing the same file twice create duplicates?

Check the result list after each import, and import only the rows that failed the second time. That way the parties and items that already came in are not added again.

Was this article helpful?