Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Keep Track of Hotel Gift Vouchers for Stays, Dinners and Afternoon Tea Without a Spreadsheet?
Problems We Solve

How Do We Keep Track of Hotel Gift Vouchers for Stays, Dinners and Afternoon Tea Without a Spreadsheet?

Hotel gift vouchers are sold online, redeemed at the desk or restaurant, and tracked in a spreadsheet. We build one voucher record linked to your PMS and EPOS.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Hotels sell gift vouchers for overnight stays, dinners and afternoon teas, often through a voucher platform or their own website, and redeem them at reception or in the restaurant. The spreadsheet in between is where things go wrong: vouchers redeemed twice, expiry dates missed, packages that do not match the current menu. We build one voucher record that links each voucher to the booking, the table and the till.

A voucher for a dinner, bed and breakfast stay that no longer exists

In December, a customer bought a gift voucher for a dinner, bed and breakfast stay for two, as a present for her parents. It was sold on your website through a voucher platform, and the details went into a spreadsheet the reservations manager keeps. In May, the parents ring to book. The package on the voucher was changed in March and the three-course dinner is now two courses plus a glass of wine. Reception is not sure what to honour.

The same week, a voucher for afternoon tea is redeemed in the restaurant. Nobody marks it on the spreadsheet. Two weeks later the same voucher code is presented again, by a friend of the person who received it, and the restaurant accepts it because the code looks valid.

Why voucher tracking gets messy

Vouchers touch several parts of the hotel: they are sold online, booked through reservations or the restaurant, redeemed at the desk or the till, and accounted for in the finance system. Each part has its own system and none of them owns the voucher.

  • Voucher platforms issue the code, but redemption happens in your PMS or EPOS.
  • Packages change over time, while vouchers promise what was on sale when they were bought.
  • Partial redemptions (a monetary voucher used across a stay and dinner) are hard to track.
  • Expiry dates, extensions and exceptions are decided case by case.
  • Accounts need to know the value of unredeemed vouchers, which the spreadsheet does not show reliably.

What loose voucher records cost

Vouchers redeemed twice are money lost. Arguments about what a voucher includes damage a gift that was meant to be a pleasure, and the guest remembers. Reservations and restaurant staff spend time searching spreadsheets and emails for the terms of a voucher sold last year.

For the accounts, an uncertain figure for unredeemed vouchers makes month-end harder, and your accountant will ask how it was worked out.

Christmas makes all of this worse. Vouchers sell in large numbers in the weeks before, many as last-minute presents, and a surge of redemptions follows in spring. The spreadsheet that just about coped in October is overwhelmed by January, and that is when the double redemptions and forgotten terms tend to happen.

How we build a voucher record for the whole hotel

  1. Every voucher sold, through a voucher platform, your website or at the desk, is recorded with its code, what it covers as sold, its value, purchase date and expiry.
  2. The terms as sold are frozen on the voucher, so if the package changes later, staff can see exactly what was promised.
  3. When reservations books a voucher stay, the voucher is attached to the PMS booking and marked as booked. Restaurant voucher bookings are attached in the table booking system.
  4. At redemption, the desk or the till checks the code against the record. A code already redeemed shows as used, with when and where.
  5. Monetary vouchers show the remaining balance after each use.
  6. Expiry reminders go to voucher holders before the date, if you choose, and the accounts view shows outstanding voucher value at any time.
VoucherStatusWhat staff see
Dinner, bed and breakfast for twoBooked for MayTerms as sold in December, including the three-course dinner
Afternoon tea for twoRedeemedRedeemed on a set date in the restaurant, cannot be reused
Monetary voucherPart usedBalance remaining after the spa treatment
Overnight stayExpiring next monthReminder sent to holder

If you already use a voucher platform, we connect to it rather than replacing it. The record sits between the platform and your PMS and EPOS.

What changes at the desk and the till

When the parents ring to book, reception sees the voucher, the package exactly as sold, and books it against the stay. On arrival, the restaurant knows it is a three-course dinner. When the afternoon tea code comes back a second time, the till shows it was used, when and by whom.

At month-end, the accounts team takes the outstanding voucher figure from the record instead of rebuilding it from a spreadsheet.

Signs your vouchers are out of control

  • Voucher details are kept in a spreadsheet.
  • A voucher has been redeemed twice.
  • Staff are unsure what an old voucher includes.
  • Monetary voucher balances are worked out by hand.
  • The value of unredeemed vouchers is hard to state at month-end.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

We use a voucher platform already. Do we need this?

Possibly not. If the platform connects to your PMS and EPOS and handles redemption, we will say so. We build the gaps, not a replacement.

Can it handle vouchers for other outlets like the spa?

Yes. Any outlet that redeems vouchers can check and mark them against the same record.

How should we treat expired vouchers?

That is your policy and your accountant's advice. The record applies whatever rules you set.

What drives the cost?

The number of places vouchers are sold and redeemed, and your voucher platform, PMS and EPOS connections.

What do you need from us?

Your voucher platform details, your current spreadsheet, and the outlets that redeem vouchers.

Keep reading

More on Problems We Solve

Start here

Tell us where your hotel's day gets stuck

Describe how your hotel runs today: the property management system and other tools you use, how many rooms and sites, and the job that eats your team's time. We will tell you what we would build and what we would leave alone, and if a setting in your PMS already does it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →