How to Reconcile Pharmacy POS Sales and Inventory Reports
A worked retail inventory example and an end-of-day checklist for matching sales, refunds and stock across reports.

Reconcile pharmacy POS sales and inventory using the same location and business-day cutoff. Match sales and refunds to transaction records, then compare the stock movements with the opening and closing counts. Give each unexplained difference an owner.
Key takeaways
- Keep separate evidence for a refund and a physical restock.
- Compare inventory quantities in the same units.
- Track timing differences separately from missing or duplicate events.
Which reports should you pull?
Export POS line items, completed refunds and tender totals. Pull the opening stock snapshot and inventory movements through the same cutoff, along with the closing balance. Keep receipt ID, original sale ID for returns, item code, location, time, quantity and event type available. If you compare card settlements, use the processor batch report and record timing differences separately from till differences.
This checklist uses fictional front-store retail items. For dispensary inventory controls, review the process with the Designated Manager. Ontario College of Pharmacists inventory management policy
What should the end-of-day checklist cover?
| Check | What to match | If it differs |
|---|---|---|
| Sales total | Line extensions, discounts, refunds and tax using the POS report's definitions | Find transaction IDs and check void and refund dates. |
| Tender totals | Completed payments by tender and the till close | Separate unpaid, split-tender and late-settling transactions. |
| Units sold | POS sale quantity and the inventory decrement in the same unit | Check SKU aliases, pack conversion and missed or repeated imports. |
| Units returned | Refund record and any separately recorded restock | Verify the physical disposition and record the restock when applicable. |
| Closing stock | Opening units plus receipts, restocks and inbound transfers, less sales and outbound transfers, with signed adjustments | Recount the flagged SKU and trace any missing event. |
What does a discrepancy look like?
Assume a front-store SKU starts with 30 units. The location receives five, sells seven, refunds one returned unit that is set aside, and transfers two out. With the returned unit excluded from usable stock, the expected close is 26 usable units. The refund still reduces the POS sales total under the store's report definitions.
If the system shows 27 usable units and the shelf count is 26, check whether the refund automatically created a restock event. The owner can then review that event against the return record and document any approved correction. If the original sale was yesterday, keep the refund on today's POS report and link it to the original transaction.
How do you close an exception?
Record the affected location, business date, transaction or SKU, expected and reported figures, suspected cause and assigned owner. Keep the source exports and correction reference together. Close once the corrected report ties out or the reviewer confirms a documented timing difference.
If the same discrepancies recur, use the guide to choosing pharmacy management software to test your vendor's export and reconciliation features. Bring a sample mismatch to Wizy's software integration team if the POS and inventory system record the same event differently.
Frequently asked questions
Does every POS refund increase pharmacy stock?
The refund changes the financial record. Stock increases only if the returned unit is put back into usable inventory and a restock event is recorded.
How do you reconcile a return for a sale from a previous day?
Record the refund on the business day it occurred and link it to the original sale. Account for any stock movement on the day it was posted, then investigate unexplained differences.
What if card settlements arrive after the till close?
Compare completed card payments with the processor’s batch report. Record expected settlement timing separately from discrepancies in card payments or cash.
