The till may balance at the end of a busy day, yet the figures can still tell the wrong story. A missed cash payment, duplicated card transaction, incorrect tender type or unrecorded refund can create avoidable questions later. To reconcile pharmacy takings properly, pharmacy owners and branch teams need a repeatable routine that compares what was sold, what was paid and what was actually received.
This is not just an accounts task. Daily reconciliation protects margin, exposes process problems early and gives managers confidence in the sales data used for ordering, staffing and retail decisions. Done well, it should take a clear process rather than a long investigation.
What pharmacy takings reconciliation should confirm
Reconciling takings means matching the total value of sales recorded through the EPOS with each method of payment received during the trading day. That normally includes cash, card payments, account sales, vouchers, refunds and any other tender types accepted at the counter.
The key distinction is between sales and money received. A sale may be processed today but paid through an account later. A card terminal may settle funds into the bank on the next working day rather than overnight. Refunds reduce net takings, but need checking in their own right. Treating every figure as if it reaches the bank at the same time is where reconciliation becomes muddled.
A good daily record should let a manager answer three straightforward questions: what did the pharmacy sell, how did customers pay, and does the physical or electronic evidence agree with the EPOS report? When those answers are clear, small discrepancies stay small.
A practical daily process to reconcile pharmacy takings
The most effective process is completed at close of trade, while the people involved and the day’s activity are still fresh. In a pharmacy with longer opening hours or multiple counter points, a nominated supervisor should own the final check, even where several colleagues handle tills.
Start with the EPOS end-of-day report
Run the sales or takings report after all transactions for the day have been completed. It should show gross sales, VAT where relevant, discounts, refunds and a breakdown by payment type. Record the date, branch and till or terminal reference clearly.
Check that staff have closed all active transactions before producing the report. A suspended sale, a transaction left at the payment screen or a late correction can make a report appear wrong when the issue is simply that the day has not been closed cleanly.
For pharmacies using an integrated pharmacy EPOS, this is also the point to review exceptions. Look for unusually high discounts, manual price overrides, voids and refunds. These are not automatically errors. A legitimate price match, an out-of-date product or a customer return may explain them. The value is in ensuring there is a reason and an audit trail.
Count cash separately and consistently
Remove the agreed float, then count the remaining cash with a second team member where possible. Count notes and coins by denomination rather than relying on an estimated total. Record the cash counted, the float removed and the cash expected according to the EPOS.
If cash is banked through a safe, collection service or night-safe arrangement, log the deposit reference and amount. The banked amount may not match the day’s cash sales exactly if you retain a float or include prior-day cash, so the cash sheet should make that difference obvious.
Cash shortages and overages are easiest to resolve immediately. Check whether change was given from the wrong till, a cash sale was mistakenly entered as card, or a refund was paid from the drawer without being processed correctly. Avoid simply carrying a difference forward. That turns a manageable £5 question into an untraceable month-end issue.
Match card totals to terminal records
Print or save the card-terminal settlement report and compare its total with card takings on the EPOS report. Use the same cut-off time. If the card machine is settled at a different time from the till report, a legitimate timing difference can look like a discrepancy.
Where card processing is integrated with the counter system, transaction-level references can make this check faster. Where it is not, make sure terminal slips, declined-payment records and manually keyed card payments are available for review. A card receipt proves an attempted or approved payment; the terminal settlement report confirms what the terminal has processed for that period.
Do not expect the bank statement to match the card total on the same date. Acquirers usually deposit card funds after processing and may deduct agreed fees separately. Reconcile terminal settlements to EPOS first, then reconcile payouts to the bank as part of the wider cashbook process.
Account for refunds, vouchers and accounts sales
These categories deserve their own line on the reconciliation sheet. A refund should appear in the EPOS as a negative transaction and, where applicable, on the card terminal or cash count. It should be authorised according to the pharmacy’s procedure, especially for higher-value items.
Vouchers, supplier credit notes, local accounts and delivery accounts may reduce the amount paid at the counter without reducing the value of goods supplied. Check that they are recorded against the right tender type. If account sales are treated as cash or card takings, the day may appear to balance but debtor records and banking will be wrong.
Investigate differences before signing off
A reconciliation does not have to be perfect before close, but every difference needs a status. Record the amount, likely cause, action taken and who reviewed it. Small variances can be monitored against an agreed tolerance; repeated variances are a process signal, not just a number to write off.
Common causes include an incorrect payment method selected at the till, a card payment taken twice after a connection issue, cash given as change incorrectly, a refund processed on one system but not another, or a transaction entered after the report was run. A structured investigation should begin with the tender difference, then narrow down to the relevant transactions rather than searching every sale.
Make the process easier for the whole team
Reconciliation improves when the counter workflow makes the right action the easy action. Train every colleague to select the correct payment type, process returns through the system, request authorisation where required and retain evidence according to pharmacy policy. A written closing procedure is useful, but it must reflect how the branch actually trades.
Clear permissions matter too. Not every user should be able to issue refunds, alter prices or open the cash drawer without a sale. Role-based controls help protect the business while making genuine exceptions visible to the manager reviewing the day.
Technology should reduce duplicate work. Pharmacy-specific EPOS reporting can bring retail sales, tender types, discounts, returns and staff activity into one view, instead of asking the team to assemble figures from separate systems. MedEpos is designed around these pharmacy counter workflows, helping teams access the reports and controls needed to review a trading day with less admin and more confidence.
For multi-site operators, consistency is especially valuable. Use the same closing time, float policy, tender names and discrepancy log across every branch. Central reporting can then highlight patterns: one location with frequent cash differences, a terminal that regularly settles late, or a product category with an unusual level of returns. Context matters, but comparison gives managers a starting point for useful conversations.
Use reconciled data to improve pharmacy performance
Accurate takings are more than a finance safeguard. They make sales reports dependable enough to guide decisions. When tender data and refunds are correct, a pharmacy can assess retail performance, compare promotional activity, review staff training needs and understand which services or product ranges are contributing to turnover.
It also supports better patient service. A counter team that knows the closing process is controlled is less likely to rush, improvise or spend the following morning chasing paperwork. That leaves more time for informed conversations, healthier retail standards and the clinical work that patients expect from their local pharmacy.
Set a daily routine, assign clear ownership and treat unexplained differences as information worth acting on. The objective is not to create more paperwork. It is to finish each trading day knowing that the figures behind your pharmacy are reliable enough to run it well.