Pharmacy Stock Reconciliation in Pakistan: Daily and Monthly Checklist

Last updated on Friday, 23, October, 2026

Every pharmacy or medical store owner has lived this moment: the system says you have 24 strips of a product, the shelf has 19, and nobody can say where the other five went. Multiply that by hundreds of products and a few months of busy counters, and the gap between your records and your real stock becomes a serious financial and compliance problem.

Pharmacy stock reconciliation is the routine that closes that gap. This guide explains what it is, why it matters in a Pakistani pharmacy, and gives you a daily checklist and a monthly checklist you can start using this week.

What is pharmacy stock reconciliation?

Stock reconciliation means comparing three things and explaining every difference between them:

1. What your records say you should have. Opening stock, plus purchases, minus sales, returns and write-offs.
2. What is physically on your shelves. Confirmed by a physical stock count.
3. What your paperwork supports. Supplier invoices, sales bills or counterfoils, return notes and damage or expiry write-off records.

When these three agree, your stock figure can be trusted. When they don’t, you have an inventory discrepancy. The goal is not just to spot it, but to find the cause and fix the process that created it.

Why it matters for pharmacies in Pakistan

Money. Medicines are high-value, fast-moving items. A few missing strips of an expensive product every week quietly becomes a large annual loss, and most pharmacies don’t see it because the loss is spread across many small items.

Compliance. Pharmacies and medical stores operate under a drug sale licence issued under the Drugs Act, 1976 and the relevant provincial Drug Rules. Two points are worth knowing:

• Licence conditions and drug sale rules require suppliers and sellers to keep pharmacy purchase records and sale records and to produce them for a drug inspector on demand. Retention periods are stated in the rules, and they have differed between rule versions (for example, three years in some provincial procedure rules, five years in older ones). Check the current Drug Sale Rules of your province and keep records at least as long as they require.
• The licence application declaration states that the licensee will not sell or stock expired, spurious, substandard, unregistered or misbranded drugs. Expiry management is therefore part of staying compliant, not just good housekeeping.
• DRAP has specifically reminded provincial authorities that pharmacies must maintain proper sale records for medicines containing controlled substances, and that these cannot be sold without a registered medical practitioner’s prescription.

Patient safety. Wrong unit quantities, mixed-up batches and expired stock on the shelf are not only accounting errors. They can reach a patient, where they become medication errors.

Key terms, in plain language

• Physical stock count: Counting what is actually on the shelves, in the fridge, in the back store and in any cartons not yet shelved.
• System (book) stock: The quantity your register, spreadsheet or software says you should have.
• Variance (discrepancy): The difference between book stock and physical stock.
• Cycle count: Counting a small section of stock every day or week instead of closing the shop to count everything at once.
• Write-off: Formally removing damaged, expired or lost stock from your records, with a reason and a signature.

The daily checklist (15 to 20 minutes at closing)

Daily reconciliation catches errors while people still remember what happened. Keep it short enough that it actually gets done.

Sales and cash

• Match the day’s sales bills or POS entries against the cash and digital payments (Easypaisa, JazzCash, card) collected.
• Check for missing bill numbers. A gap in the sequence needs an explanation.
• Confirm that every prescription-only or controlled-substance sale has the required prescription and register entry.
• Record any returns accepted and confirm the stock was handled correctly (restocked, quarantined or written off).

Purchases and receiving

• Enter every supplier delivery received today. Check the invoice against what physically arrived: product, strength, quantity, batch number, expiry date and rate.
• Note short supply, excess supply and wrong items on the invoice before the delivery person leaves.
• Keep unreceived or disputed items separate from sellable stock.

Shelf checks

• Count 10 to 20 fast-moving or high-value items and compare against book stock. Rotate the list daily so every key item gets checked regularly.
• Count all controlled and prescription-restricted medicines against their registers every day.
• Check that the fridge items (insulin, vaccines, certain injections) are stored correctly and the temperature log is filled in.
• Pull out anything damaged, leaking, broken or with torn packaging and put it in a labelled quarantine box.

Close-out

• List every variance found today, however small, with a one-line suspected reason.
• Have the person who counted sign and date the daily sheet, and have the manager or owner initial it.
• Handle any large variance that day. Don’t carry it forward.

The monthly checklist (half a day, ideally on a fixed date)

The monthly routine is deeper: it is a full stock audit of your pharmacy or medical store. Pick a consistent day, such as the last Sunday, and block the time.

1. Prepare

• Complete all pending purchase entries, sales entries and returns up to the cut-off date and time.
• Freeze stock movement during the count if possible, or record sales made during counting separately.
• Assign counters in pairs: one counts, one records. Ideally, the person counting is not the person who normally orders or receives that stock.

2. Physical stock count

• Count every section: counter shelves, back shelves, drawers, fridge, back store and cartons.
• Count by unit as recorded in your system (strip, box, bottle, vial) and write the unit next to every figure.
• Record batch number and expiry date for each batch counted, not just the product total.

3. Compare and investigate

• Compare each counted quantity with book stock and mark every variance.
• Rank variances by rupee value. Investigate the largest first.
• Trace each one back through purchase invoices, sales bills, returns and write-offs for the period.
• Record the cause. If the cause is unknown, mark it “unexplained” and watch that item more closely next month.

4. Expiry review

• List everything expiring in the next 3 months (or the window your suppliers accept for returns).
• Move short-dated stock to the front and flag it to counter staff.
• Arrange supplier returns or exchanges where the supplier allows it.
• Remove expired stock from shelves, record it as a write-off in your expiry register with quantity, batch, expiry date and value, and store or dispose of it according to your procedure.

5. Purchase records review

• Match supplier invoices to supplier statements and payments. Note unpaid, double-paid or disputed invoices.
• Check that the rates entered match the invoice rates, and that the units entered match the units received.
• Look for items bought repeatedly in small lots from different suppliers, which can signal poor ordering or leakage.

6. Adjust and sign off

• Post stock adjustments only with a written reason, and only after investigation.
• Calculate the month’s total variance in units and in rupees, and track it month over month.
• Owner or manager signs the reconciliation report and files it with your records.

Book a Pharmacy Management Software Demo         

Common discrepancies and how to trace them

These four causes are among the most common reasons a pharmacy’s stock does not match its records. Each example below is illustrative.

1. Unrecorded sales

What happens: A busy counter sells a product without making the bill. It might be a customer in a hurry, a regular who “will pay later”, or an item sold from a loose strip.

Example: Book stock shows 30 strips of a common antacid, and the shelf holds 24. No bill numbers are missing, but the six strips never appeared on any bill.

How to trace it: Check the day’s cash against bills, and look for “pay later” or credit notes that were never entered. Check whether loose-strip sales are being recorded in strips or in boxes. Repeated unrecorded sales on one shift is a training or supervision issue.

Prevent it: Make “no bill, no sale” a rule. Have a quick way to enter fast sales at the counter, because slow billing is the main reason staff skip it.

2. Purchase-entry errors

What happens: The invoice says one thing and the entry says another: wrong product, wrong strength, wrong quantity, a missed batch or an invoice entered twice.

Example: A supplier delivers 10 units of a 500 mg product and 10 units of a 250 mg product. The entry clerk enters 20 units of the 500 mg product. The 500 mg item now shows 10 units too many, and the 250 mg item shows 10 too few.

How to trace it: When one item is over and a similar item is under by the same amount, suspect a look-alike mix-up. Compare the supplier invoice line by line with your entry.

Prevent it: Enter purchases against the invoice on the day of delivery, and have a second person check high-value invoices.

3. Damaged and expired stock

What happens: Broken vials, crushed cartons, leaked syrups, melted or heat-damaged items and expired products are removed from the shelf but never removed from the books.

Example: A carton of syrup is dropped in the back store and three bottles break. Nobody records it. At month-end, book stock is three bottles higher than the shelf.

How to trace it: Check your quarantine box and write-off sheet. If there is no write-off sheet, that is the root cause.

Prevent it: Keep a damage and expiry register. Every removal needs a date, product, batch, quantity, reason and a signature.

4. Incorrect unit quantities

What happens: The same product is counted or entered in different units: strips, boxes, cartons or individual tablets.

Example: A supplier delivers 10 boxes, each with 10 strips. The system tracks strips. The entry clerk enters 10, not 100. The system shows 90 strips too few, and staff conclude stock was stolen, when it was a unit error. The reverse is also common: 100 entered where 10 boxes were meant.

How to trace it: If a variance is an exact multiple of the pack size (10, 12, 14, 100), suspect a unit error before suspecting loss.

Prevent it: Decide, per product, the one unit you track and write the pack conversion (for example, 1 box = 10 strips) where the entry clerk can see it. Never leave the unit unspecified on a count sheet.

Rules that make reconciliation work

• Separate duties. The person who receives stock, the person who counts it and the person who approves adjustments should not all be the same person.
• Never adjust without a reason. An adjustment with no explanation hides the problem. Write down the cause every time.
• Track the trend, not just the total. One bad month can be a one-off. Three months of the same product going missing is a pattern.
• Fix the process, not just the number. If unit errors keep happening, fix how units are entered. If unrecorded sales keep happening, fix billing speed.

Where software can help (and what to verify first)

A register or spreadsheet can work for a small shop, but as product count and sales volume grow, manual reconciliation gets slow and error-prone. A digital inventory workflow can help by keeping sales, purchases and stock in one place, so you compare the shelf with a single, current figure.

When you evaluate any pharmacy software, ask the vendor to demonstrate, not just describe, these capabilities, and confirm each one individually:

• Purchase entry against supplier invoices, with the unit of measure clearly handled
• Sales billing that reduces stock automatically
• Batch number and expiry date recording per delivery
• Stock reports you can print for a physical count
• A record of adjustments, returns and write-offs with reasons
• Alerts for low stock or approaching expiry, if you need them
• Controlled-substance and prescription record keeping that fits your province’s rules

Features differ widely between products, and “automated reconciliation” can mean very different things. Software does not replace the physical count. It makes the comparison faster, and it can’t fix a bad entry made at the counter.

If you are considering a move from paper or spreadsheets to a digital inventory workflow, you can look at the pharmacy software page to see what is available and how it fits your pharmacy.

Practical takeaway

Stock reconciliation is not a once-a-year panic. It is a small daily habit and a disciplined monthly review:

• Every day: match bills to cash, enter and check deliveries, count a handful of key items and all controlled medicines, remove damaged stock, and record every variance.
• Every month: count everything, compare it with your records, trace the biggest variances, review expiry dates and purchase records, and sign off a written report.
• When you find a gap: check unrecorded sales, purchase-entry errors, damaged or expired stock and unit mix-ups first. These explain most discrepancies.

Start small. Print the daily pharmacy stock checklist, assign one person to own it, and hold your first monthly count within the next 30 days. Within two or three cycles you will know where your stock is really going.