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
- Open Import from Excel and pick what you are importing: Parties, Items or Stock.
- Download the Demo template (Excel). Its column names are the ones the import expects.
- Paste your data under the headings. Keep one party or item per row.
- 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.
