A missing £20 note, a card batch that does not match the till report, or a refund entered after the drawer was counted can turn a busy closing routine into a frustrating investigation. Knowing how to reconcile pharmacy takings gives owners and branch teams a reliable way to account for every transaction, protect margin and identify issues while the details are still fresh.
For a community pharmacy, reconciliation is more than counting cash. It brings together counter sales, prescription charges, card payments, payment links where used, refunds, paid-out amounts and any service-related transactions recorded through the EPOS. Done well, it creates an accurate daily record without adding unnecessary pressure at the end of a long shift.
What reconciling pharmacy takings should achieve
Reconciliation compares what your EPOS says should be in each payment method with what has actually been received. The aim is not simply to make the figures look tidy. It is to explain every difference clearly, record it correctly and deal with repeat causes before they become a pattern.
A completed reconciliation should show the expected and actual total for cash, card and any other payment types accepted at the branch. It should also account for float movements, refunds, voids, discounts, prescription charge payments and money removed from the till. Your finance process may be daily, weekly or centralised across several branches, but the check at branch level should normally happen at the close of each trading day.
This matters commercially. Small discrepancies add up, particularly in a high-volume pharmacy where counter staff are moving between retail sales, prescription collections and patient queries. Accurate takings also give owners confidence in the sales figures used for stock planning, staffing decisions and branch performance reporting.
How to reconcile pharmacy takings at the end of the day
The best routine is consistent. The order can vary slightly according to your hardware and banking arrangements, but the core principle remains the same: take reports first, count independently, then compare.
Close or print the day’s EPOS reports
Before cash is counted, produce the end-of-day report from the EPOS. This should show gross sales, VAT where relevant, payment-method totals, refunds, voids, discounts and expected cash in drawer. If your system tracks prescription charge sales separately, retain that detail too. It can be useful when investigating a difference later.
Do not rely on a verbal handover or the figure displayed on a card terminal alone. The EPOS report is the operational record of what was processed at the counter. Save or print it according to your branch procedure so it can be reviewed with supporting payment reports.
Reconcile card payments separately
Run the terminal’s settlement or end-of-day report and compare its total with the card total on the EPOS report. For pharmacies with more than one terminal, match each terminal report rather than looking only at a combined figure. This makes it far easier to locate a transaction processed on the wrong device, a terminal that was not settled, or a payment that was started but not completed.
The totals may not always match exactly on the day. A transaction can be authorised but not captured if there was a connection interruption, and a manual entry or delayed terminal settlement can affect timing. The key is to record the reason and check that the payment appears correctly in the relevant merchant report or bank settlement.
Count cash away from the counter
Remove the cash drawer from public view and count it with a second person where staffing allows. Start by separating the opening float from the day’s takings. Count notes and coins by denomination, then add paid-in or paid-out records if your branch uses them.
The actual cash should equal the expected cash shown on the EPOS report, plus or minus any documented movements that have not been included automatically. Keep the float amount consistent wherever possible. A changing float is a common source of confusion, especially when staff are covering different shifts.
Once the total is confirmed, prepare the banking in line with your security procedure and record the amount deposited. The amount banked may differ from the day’s cash takings if you retain a fixed float, but the difference should always be straightforward to explain.
Check refunds, voids and corrections
Refunds and voids deserve their own check because they are legitimate transactions that can look like a discrepancy when paperwork is incomplete. Confirm that a refund was issued through the same method as the original payment where required, and that it has the appropriate authorisation.
A void removes a sale before payment is completed. A refund reverses a completed sale. If staff use these terms interchangeably, reports become harder to interpret and managers lose visibility of why value has left the till. Clear permissions and a simple approval process help prevent avoidable errors.
Record and investigate any variance
If the figures do not agree, do not adjust the record just to force a match. Record the expected amount, actual amount, value of the variance and the likely reason. Then investigate promptly while the relevant team members can remember the transaction.
Common causes include incorrect change, a cash payment entered as card, an unrecorded cash removal, duplicate card processing, a refund entered incorrectly, or a terminal report from the wrong settlement period. A small shortfall may be a simple counting error. A repeated difference in the same direction, at the same till or on the same shift needs closer attention.
Make the process practical for a busy pharmacy
The strongest reconciliation process is one that the team can complete reliably, even after a demanding day. It should not depend on one experienced person remembering a series of workarounds.
Start with a written closing procedure that names the reports to run, the person responsible for cash counting, the required checks and where records are stored. Keep it short enough to use at the counter office, not buried in a lengthy policy document. Train every appropriate team member on the same method and revisit it when hardware, payment processes or staffing arrangements change.
For multi-site operators, use the same reporting definitions across branches. A branch that records paid-outs differently from the rest of the group can create unnecessary work for finance and make comparisons unreliable. Central reporting is valuable, but it works best when each branch follows a consistent local process.
It also helps to separate duties where practical. The person taking payments should not be the only person checking the cash total. In a smaller pharmacy, this may not be possible every day, so a pharmacist, manager or owner can review reconciliations and variances at set intervals instead.
Use EPOS data to prevent recurring discrepancies
A pharmacy-specific EPOS can make reconciliation quicker because it gives the team clear visibility of payment types, sales corrections and counter activity in one place. The value is not simply in producing a report. It is in making that report understandable enough to act on.
Look for patterns rather than treating every variance as an isolated event. Are differences occurring on particularly busy collection days? Is one terminal regularly left unsettled? Are staff applying discounts without a clear reason? Do cash discrepancies rise when a temporary float is used? These questions turn reconciliation from an administrative task into a useful control for the business.
Reporting can also show the wider commercial picture. Once takings are dependable, pharmacy owners can assess retail category performance, review discounting, compare branches and make stock decisions with greater confidence. Less admin. More insight. Better results.
MedEpos is designed around pharmacy counter workflows, with payment and sales reporting that helps teams keep control of daily activity without relying on generic retail processes. The right setup should support the closing routine, not make it longer.
A well-reconciled day gives the next shift a clean starting point. More importantly, it lets your team spend less time searching for unexplained differences and more time serving patients well.