Tally for pharma distributors works well when three things are set up correctly: batch-wise stock with expiry dates, scheme (free quantity) handling, and godown-wise control. Running that TallyPrime setup on the cloud adds live access for your godown, billing counter, salesmen and the owner, so everyone sees the same batch and expiry position at the same time. This guide shows how to configure it and how to run it day to day.
It is written for C&F agents, super stockists, stockists and wholesale chemists, the businesses between pharma companies and retail chemists.
Why pharma distribution is harder to account for than normal trading
A general trader sells “an item”. A pharma distributor sells a specific batch of an item, with a manufacturing date, an expiry date and an MRP that may differ from the previous batch. On top of that:
- Near-expiry stock has to be identified early and returned to the company or cleared.
- Companies run schemes like “10+1” that change the effective cost.
- Retail chemists buy on credit, often with weekly or fortnightly payment cycles.
- Cold-chain products, high-value items and fast-moving OTC items often sit in separate storage areas.
- Invoices must carry batch number, expiry and the licence details the law requires.
Getting any of these wrong costs money directly, usually through expired stock nobody noticed in time.
Setting up batch and expiry in TallyPrime
TallyPrime has built-in batch tracking. Here is the configuration we normally do for distributors:
- Enable batches at company level. In company features (F11), under Inventory, enable batch-wise details along with expiry date and manufacturing date tracking.
- Turn on batches for each stock item. In the stock item master, set “Maintain in batches” to Yes, and enable expiry date tracking for that item. Do this for every medicine. Non-batch items like carry bags or display material can stay without batches.
- Enter batch details on purchase. Every purchase invoice line captures batch number, manufacturing date and expiry date. This is the most important discipline: if the purchase entry is wrong, every later report is wrong.
- Select the batch on sale. While billing, the user picks the batch from a list showing available quantity and expiry. Train billing staff to pick the earliest-expiring batch first unless a retailer asks otherwise.
- Use MRP in the item or batch. Since MRP can change between batches, keep MRP information updated so invoices print correctly.
Reports you will use every week
- Batch-wise stock summary to see quantity per batch per godown.
- Batch reports sorted or filtered by expiry date to see what expires in the next 30, 60 or 90 days. (If you need a ready-made near-expiry format, a small TDL add-on can provide one.)
- Godown summary to see what sits where.
- Bill-wise outstanding for retailer collections.
A simple rule many distributors follow: every Monday, the godown in-charge pulls the 90-day expiry list, and the sales team pushes those batches that week. Anything within the company’s return window gets processed as a return claim immediately.
Handling schemes and free quantity
Schemes are where most distributors’ stock and margins go out of sync. If a company gives 10+1, you receive 11 strips but pay for 10. If you pass a scheme to retailers, the same happens on the sales side.
TallyPrime has an option to use separate actual and billed quantity in vouchers. Actual quantity is what physically moves (11); billed quantity is what is charged (10). Stock stays correct, and the invoice value stays correct. Enable this in company features and train billing staff to use it consistently.
Discount columns on the invoice handle trade discounts and cash discounts. Many distributors also use price levels to keep separate rates for different classes of customers, such as hospitals, retailers and sub-stockists.
Multi-godown control
Create a godown in TallyPrime for every physical or logical storage area. A typical distributor setup:
| Godown | What it holds | Why separate |
|---|---|---|
| Main Godown | Regular saleable stock | Default for billing |
| Cold Storage | Insulin, vaccines and other cold-chain items | Restricted handling, separate check |
| Expiry / Breakage | Expired, damaged, returned-from-market goods | Kept out of saleable stock; feeds company claims |
| Branch / Second town | Stock at another location | Branch-wise availability and transfers |
| In Transit | Stock moving between locations | Prevents “missing” stock between transfers |
When a retailer returns expired stock, record the credit note into the Expiry / Breakage godown. That keeps it out of saleable stock and gives you a clean list for the company’s expiry claim.
Where cloud makes the difference for distributors
Everything above works on a single office computer too. The cloud changes who can use it and from where.
Godown and counter on the same live data
Many distributors have the billing counter in the market and the godown elsewhere. On the cloud, when the godown receives a consignment and enters it with batches, the counter can bill it immediately. No waiting for an evening sync.
Salesmen checking stock from the field
A medical representative or order booker standing in a chemist’s shop gets asked, “Is that batch available, and what’s my outstanding?” With a limited cloud login on their phone, they can check stock and that retailer’s outstanding without calling the office. TallyPrime’s security controls let you restrict them to viewing reports, not creating or changing vouchers. Our guide on using TallyPrime on your mobile phone covers the phone setup.
Owner visibility
The owner can check daily sales, collections and near-expiry value from home or while visiting a company’s office, without asking anyone to send screenshots.
Branches and second towns
Distributors expanding into a nearby town do not need a second server or data-merging process. The branch logs in to the same company with its own godown.
Data safety
A distributor’s Tally data holds years of batch history, party balances and claims. Losing it to a failed hard disk is a serious business problem. A good Tally on Cloud setup includes daily server backups, and TallyPrime 7.0 users with active TSS can also use TallyDrive for automatic backups. Read our TallyDrive backup guide for how to combine both.
Distributors near Baddi and in Punjab: a regional note
North India has a strong pharma ecosystem, with manufacturing concentrated around Baddi and Solan in Himachal and large distribution networks running through Chandigarh, Ludhiana, Jalandhar and Amritsar. Many distributors in this region deal with dozens of companies’ products and hundreds of retail chemists. That is exactly the scale at which batch discipline plus live multi-location access starts paying off.
Setup checklist before going live
- Batch, expiry and manufacturing date tracking enabled at company and item level.
- Actual and billed quantity enabled for schemes.
- Godowns created, including Expiry / Breakage and In Transit.
- Invoice format checked to print batch, expiry, MRP and required licence details.
- Separate users with rights: billing, godown, accounts, salesmen (view only), owner.
- Credit limits and credit periods set on retailer ledgers.
- Opening stock entered batch-wise, verified against physical stock.
- Backups confirmed and a restore tested once.
Frequently Asked Questions
Can TallyPrime track batch number and expiry date for medicines?
Yes. TallyPrime supports batch-wise stock with manufacturing and expiry dates. Enable it in company features and in each stock item, then capture batch details on every purchase.
How do I record a 10+1 scheme in TallyPrime?
Enable separate actual and billed quantity in company features. Enter 11 as actual quantity and 10 as billed quantity, so stock and value are both correct.
Can my salesmen see stock on their phones without changing anything?
Yes. On Tally on Cloud, give each salesman a separate login with view-only rights to the stock and outstanding reports they need.
How should expired returns from chemists be handled?
Record the credit note into a separate Expiry / Breakage godown. This keeps it out of saleable stock and gives you a ready list for company claims.
Is Tally on Cloud suitable for a distributor with two towns?
Yes. Both locations work on the same company with separate godowns, and stock transfers between them are recorded with batches intact.
Set up Tally on Cloud for your pharma distribution
Sukam Apps (Jalandhar, since 2011) configures TallyPrime for pharma distributors and moves it to the cloud, with on-site training in Hindi or Punjabi across Punjab, Chandigarh Tricity, Haryana, Delhi NCR and Himachal (Baddi, Solan), and remote setup across India. You get a dedicated account manager, not a queue. WhatsApp +91 99142 49191 for a free demo or contact us.
