Import from Excel with a ready template
Every import has an Excel template whose Data sheet opens with dummy rows to replace, and an Instructions sheet. Journal entries (many lines each) and opening balances import too.
Aasan alfaaz mein: Har import ka Excel template hai: Data sheet mein dummy data hota hai jise apne data se badal dein, aur Instructions mein har column ki wazahat. Journal entries aur opening balances bhi Excel se aa jate hain.
Step by step
Pick what to import
Choose the list: products, customers, vendors, accounts, opening balances, opening stock, journal entries and more.
Where: Settings → Import
Download the Excel template
Click Download Excel template. The Data sheet opens with dummy rows: replace them with your own, keeping the same columns. Columns marked * are required.
Upload and map
Upload the file, choose the Data sheet, check that each column is matched to its field, then import.
Read the result
Rows that failed are listed with the reason and their line number; the others are already saved. Fix those rows and upload them again.
What happens in the books
- Journal entries: one row per line. Rows with the same Entry number become one draft entry, which must balance; an unbalanced entry is refused as a whole.
- Opening balances: all rows post together as one entry against 3900 Opening Balance Equity. Type is customer, vendor or account.
- Opening stock: each row posts Inventory against 3900 at its unit cost, or the product's purchase price if left empty. A product that already has stock movements is refused, so a second import cannot double stock.
- Negative stock is not imported. The row comes back marked Needs review: count the item, then enter the real quantity.
- Products also take description, purchase price, reorder point and default vendor. Import vendors first, because the default vendor is matched by name.
- A product sold in rolls: set Unit to m, the prices per metre, Packaging to Roll and Packaging quantity to the roll length (50). Invoices and orders can then use either unit.
- Customers and vendors also take company name, mobile, city, state, ZIP and country. A vendor whose name already exists is refused. Customers are not checked, because two customers can share a name, so import a customer file only once.
Tips
- Upload the template unchanged into a test company to see the importer work end to end.