Moving from another billing app? Export your item list and customer list to Excel there, then import the files in Galla Guru. Sizes, colours, batches and khata balances come across too.
Import a file
- Open Settings › Import Data (shop owner only).
- Choose What to import: items, customers & khata, or (for restaurants) add-ons, raw materials and recipes.
- Pick the software you're coming from. The app shows exactly where to export the file there, and you can Download the format if you'd rather fill in a sheet yourself.
- Choose the file, check how its columns were matched, and import. Rows that can't be imported are listed with the reason.
Where to find the export in your old software
| Coming from | Items | Customers |
|---|---|---|
| Tally | Display More Reports › Stock Summary, then Export (Alt+E) › Excel | Display More Reports › Group Summary › Sundry Debtors, then Export (Alt+E) › Excel |
| Marg ERP | Reports › Stock & Inventory › Stock Status (batch-wise for a chemist), then Export › Excel | Reports › Outstanding › Party-wise (Sundry Debtors), then Export › Excel |
| Vyapar | Items › ⋮ › Export Items to Excel | Parties › ⋮ › Export Parties to Excel |
| Busy | Display › Inventory Books › Stock Status, then Export to Excel | Display › Outstanding Analysis › Party-wise Balance (Sundry Debtors), then Export to Excel |
| Petpooja | Menu › Items, then Export (or Download menu) to Excel | CRM › Customers, then Export to Excel |
| Excel or other | Any sheet with a header row: Item Name, MRP, Sale Price, Stock, GST %, HSN, Batch, Expiry… | Any sheet with a header row: Name, Mobile, GSTIN, City, State, Balance with Dr/Cr… |
Menu names can differ between versions of those apps. Tally's Stock Summary shows cost rates, so items from Tally come in needing a selling price.
A supplier's bill
To add stock from a supplier's bill without typing it, ask the supplier to export the bill to Excel (or send the GST e-invoice JSON), then open Purchases › New purchase bill and choose Import file.
Related articles
Still need help?
Open Help & Support in the app to send us a question with your shop details, or reach us directly. We answer Mon-Sat (10AM-6PM).