Importing from Excel
Bring in items, vendors, employees, opening stock, balances and BOQs from Excel, with every row checked first.
Who does this: Owner or administrator Head of accounts HR administrator Store keeper
Steps#
- Open Admin, then Data import, and choose what to import.
- Download the template. Each column has a note explaining what goes there.
- Fill it. Keep the column names as they are.
- Upload. Core checks every row and shows a preview: rows that will be added, rows that will update existing records, and rows with problems, with the reason for each.
- Fix problem rows in Excel and upload again, or go ahead with only the good rows.
- Import. Each import is recorded with who ran it.
What you can import#
| Import | Notes |
|---|---|
| Items | Units and conversions in the same sheet |
| Vendors | GSTIN is checked; PAN and state fill from it |
| Employees and workers | With department, site and bank details |
| BOQ | One sheet per project |
| Opening stock | Per store, as counted on your go-live date |
| Opening balances | Ledger, vendors, clients and bank, as on the go-live date |
Tips#
- Import in this order: items, vendors, employees, BOQs, opening stock, opening balances.
- Start with a few rows to check the result, then import the rest.
- An import that updates records keeps the old values in the history.
Did this page help?Still stuck? Contact support