hhudayet
← hudayet
Custom

Custom Excel systems

We turn the Excel your team already uses into a system that knows your reports and workflow. No extra licences, servers or new software to learn.

Example work

These are systems in use on the floor. Each one is adapted to the hotel's own reports and rules.

Guest registration (KBS) automation

Generates the bulk add and check-out templates of Turkey's official guest registration system from PMS reports; registers foreign guests in bulk and Turkish guests one by one, and lists the differences between the two systems.

  • Arrivals and departures in one macro
  • Turkish / foreign split and character clean-up
  • Mismatch report

Upsell tracking system

Collects room upgrade sales from front office and reservations through a form; manager approval, tiered commission, a leaderboard and per-person PDF statements make monthly payouts ready.

  • Staff can't see each other's entries
  • Commission tiers and staff managed from settings
  • Month close and archive

Invoice reconciliation

Compares invoices issued in the PMS with the e-invoice portal records and highlights missing, extra and mismatched invoices, with a tolerance for rounding.

  • Reusable every month
  • Adjustable tolerance
  • Colour-coded difference list

Downtime PMS

An Excel-based backup to keep the hotel running when the PMS is unavailable: reservations, room charges, notes and a housekeeping grid showing every room's status.

  • Bulk import from PMS reports
  • Exchange rate entry
  • Room status grid

How we work

1

Discovery call

We talk about the reports you work with, where time is lost and who receives the result.

2

Prototype

We build a first version that runs on your own sample reports and try it with the team.

3

Setup and training

We install the final version and leave a short guide and training deck.

Compatible with Office 2016 and later; VBA where macros are needed, formulas only where they're not.

Want to try it at your hotel?

Let's look at your team's workflow in a short call and set up the right tool together.

sefa@hudayet.com · LinkedIn ↗

Pressing Send opens a ready message in your email app.