| Files | Excel (.xlsx, .xls) and CSV; photos and PDFs of distributor bills |
|---|---|
| Columns needed | Medicine name and quantity; batch, expiry, pack, free quantity, purchase rate, MRP, GST % and HSN are read when present |
| Excel and CSV | Always free, no limit |
| Photo or PDF | One scan page per page of the bill; 10 free a month, refilled on the 1st |
| Where | App: Inventory → Upload distributor bill. Web: Inventory → Import |
From an Excel or CSV file
- Export your stock. Save your stock list from your old software or your own sheet as Excel or CSV. One row per batch works best, with name, batch, expiry, quantity and MRP.
- Upload it. In the app, open Inventory → Upload distributor bill. On the web dashboard, open Inventory → Import.
- Match the columns once. On the Check your file screen, confirm which column is the name, quantity, batch, expiry and price. MedCounter remembers the match for your next file.
- Review and confirm. Each row is matched to the catalogue of over 2,50,000 Indian medicines, and you can change any line before it goes into stock.
From a photo of the distributor's bill
Photograph the bill, up to 10 photos in one import, or upload its PDF. AI reads every line, including batch, expiry, quantity, free quantity, rates, GST and MRP, and matches each one to the catalogue. Each page uses one scan page. Every shop gets 10 free scan pages a month, refilled on the 1st, and a scan that fails does not use one up. Need more? Watch a short ad in the Android app, or buy a top-up on the web dashboard.
What happens at review
- Fix any lineChange the medicine, batch, expiry, quantity, free quantity, rates or GST before you confirm.
- Items not in the catalogueThey still go into stock, under the name printed on the bill, as your shop's own item.
- Register medicines checkedIf a line may be a Schedule H1, X or NDPS medicine, MedCounter asks you to confirm it before it is added.
- Same bill twiceIf the invoice number matches a bill you already imported, MedCounter warns you before the quantities are doubled.
- Distributor accountConfirming a distributor bill can save it to your payables, so you know what you owe each distributor.
Common questions
- How do I import my medicine stock from Excel?
- Save your stock list as an Excel or CSV file, upload it in MedCounter, and match the columns (name, quantity, batch, expiry, price) once. Every row is matched to the medicine catalogue, and you review the list before it goes into stock. Spreadsheet imports are free and unlimited.
- What columns does the Excel file need?
- Only the medicine name and quantity are required. MedCounter also reads batch, expiry, pack size, free quantity, purchase rate, MRP, GST % and HSN when your file has them.
- How many distributor bills can I scan for free?
- Every shop gets 10 free AI scan pages a month, refilled on the 1st, and each page of a bill uses one. For more, watch a short ad in the Android app or buy a top-up on the web dashboard. Excel and CSV imports never use scan pages.
- What if a medicine on the bill is not in the catalogue?
- It is still added to your stock, under the name printed on the bill, as your shop's own item.