Quarter end at an independent practice
Spectacle sales in the UK are generally treated as a mix of a dispensing service and the supply of goods, which have different VAT treatment, so the price has to be apportioned between them. The practice's accountant has agreed a method with the owner. Every quarter, someone exports the sales from the practice system, applies the method in a spreadsheet, adjusts for NHS vouchers, discounts and refunds, and sends the result to the accountant.
It works, most quarters. But the spreadsheet has grown over time, only one person understands it, and the numbers take days to produce.
Offers make it harder. A second pair at a reduced price, a free tint with varifocals, a voucher top-up where the patient chooses a frame above the voucher value: each of these needs the same method applied carefully, and each is a place where a quarterly spreadsheet can quietly go wrong.
Why this stays a spreadsheet job
- Practice systems record the sale price, but often not the split the practice's chosen method needs.
- Voucher contributions, patient top-ups, two-pair offers and discounts complicate each sale.
- Refunds and remakes may fall in a different quarter from the original sale.
- Contact lenses, accessories and eye tests each have their own treatment.
- The method was agreed years ago and is not written down anywhere the practice can see.
We are not tax advisers and do not choose or recommend an apportionment method. What we can do is make sure the method you and your accountant have chosen is applied to every sale, the same way, with a trail your accountant can check.
What the manual approach costs
| Issue | Effect |
|---|---|
| Quarterly spreadsheet | Days of work and a single point of failure |
| Adjustments applied by hand | Inconsistency between quarters |
| No per-sale record of the split | Hard to answer questions later |
| Method not documented | Risk when the person who knows it leaves |
How we build the calculation
- We sit down with you and, ideally, your accountant, and write the agreed method down as explicit rules, including how vouchers, discounts, offers and refunds are treated.
- Sales, vouchers and refunds are read from your practice management system each day through its API or an export.
- Each sale is split according to the rules, and the split is stored against the sale, so any line can be traced.
- Sales that the rules cannot handle, such as an unusual discount, go to a short review list rather than being guessed.
- A quarterly summary is produced in the format your accountant wants, with the underlying detail available.
- If your accountant changes the method, the new rules apply from a date, and earlier quarters stay as they were calculated.
- Totals can be posted to your accounts package, such as Xero, using the accounts your accountant specifies.
Quarter end, afterwards
The quarterly figures are ready without a spreadsheet session. Every sale has a recorded split that can be checked. The method is written down, so the practice no longer depends on one person's knowledge. Your accountant receives consistent, traceable figures, and remains the person who decides whether the method is right.
Questions become easier to answer, too. If HMRC or your accountant ever asks how a particular quarter was worked out, you can show the rules in force at the time and the split for each sale, rather than reopening an old spreadsheet and hoping the formulas have not been changed since. That record is useful whatever method you use.
Is this your quarter end?
- VAT apportionment is done in a spreadsheet each quarter.
- Only one person understands how the spreadsheet works.
- Vouchers and offers are adjusted by hand.
- You could not show how a particular sale was split.
- The method your accountant agreed is not written down.