Pharmacy Software: Automate SIPNAP Reports, FEFO & Controlled Drugs

Licensed pharmacies carry a burden ordinary retail doesn’t: mandatory reporting. Every month, the usage of certain drug classes must be reported to SIPNAP (Indonesia’s Narcotics and Psychotropics reporting system). When this recap is done by hand from a logbook or Excel at month’s end, the process is slow, exhausting, and error-prone — even though the data already exists in every checkout transaction.

This article covers SIPNAP reporting obligations, how controlled-drug classes work, FEFO discipline for expiring drugs, and how pharmacy software turns a manual recap into a report that’s calculated automatically.

A reporting obligation you can’t negotiate

SIPNAP requires pharmacies to report the usage of Narcotics and Psychotropics (and other controlled classes) periodically. What’s usually needed is a Usage and Recapitulation report: how much came in, how much went out, and remaining stock per class.

The problem isn’t “hard to report” — it’s that the data is scattered. If controlled-drug sales are recorded at the cashier but reporting is done from a separate logbook, the two records don’t connect. The month-end recap becomes copy-work: prone to typos, prone to omissions, and eating up the pharmacist’s time that should go to patients.

Controlled-drug class must attach to the product

The key to automation is that the drug class attaches to the product from the start. Proper pharmacy software lets you tag each product with its class — Narcotics, Psychotropics, Morphine, Pethidine, Precursors, and so on.

Once the class is attached, every sale and stock movement is automatically recorded per class. There’s no double bookkeeping: the cashier runs as usual, and the system quietly gathers exactly the data needed for reporting.

A SIPNAP recap that calculates itself

Because the class is already attached and every movement is recorded, the Usage & Recapitulation report can be calculated automatically from transaction/stock data — not copied from a logbook. You simply:

1. Choose the reporting period.
2. The system computes usage and recapitulation per class.
3. Export CSV — ready to open in Excel, then upload to the SIPNAP portal as usual.

What used to be hours of copying data at month’s end becomes a few clicks. And because the figures come straight from transactions, the risk of miscopying disappears.

Complementing this, a pharmacy profile (name, address, tax ID, license number, responsible pharmacist, registration) is stored once and used in every report — no re-entering it each month.

FEFO: keeping expired drugs off the shelf

Beyond reporting, pharmacies face the risk of expiring drugs. Without discipline, newer stock can sell first while stock closer to expiry sits on the shelf until it expires — a direct loss and a safety risk.

The solution is FEFO (First Expired, First Out): the item nearest its expiry date goes out first. Pharmacy software that supports this:

• Tracks lot/batch and expiry date per receipt.
• Suggests FEFO picking on a sale — the nearest-to-expiry is prioritized to go out.
• Supports per-lot recall when a product is withdrawn from a specific batch.

That way, drugs nearing expiry are used first systematically, not by relying on a staffer’s memory.

Connected to pharmacy operations

Reporting automation is most valuable when it merges with the daily cashier:

• Compounded drugs — composite products with a recipe (BOM) automatically deduct ingredient stock.
• The cashier keeps running offline — the queue doesn’t stop when the internet drops; transactions sync automatically when online.
• Purchasing & suppliers — purchase orders and staged receiving, stock per location, low-stock alerts.
• WhatsApp receipts & automatic bookkeeping — receipts sent to the patient’s WhatsApp, every sale posts to the ledger.

Conclusion

A pharmacy’s reporting burden is heavy precisely because the data is done twice: once at the cashier, once in the report logbook. The right pharmacy software removes that double work — the drug class attaches to the product, the SIPNAP recap is calculated automatically and exported to CSV, and FEFO keeps expiring drugs off the shelf. The pharmacist goes back to serving patients, not copying numbers.

Want to see controlled classes, automatic SIPNAP recaps, and FEFO work for your pharmacy? Explore the Tenavora Pharmacy solution or start free for 30 days, no credit card required.