# Running a hotel without spreadsheets: replace your Excel lists in 30 days

Canonical: https://staystryk.com/mk/guides/hotel-without-excel/
Language: mk
Updated: 2026-10-14

Tape chart, room list, guest list and deposits in Excel? The risks, what to replace first and a 30-day plan for small hotels to move off spreadsheets.

## Најважното накратко

In many small hotels and guesthouses, Excel is the hidden operating system: the booking chart, the housekeeping room list, deposits, tourist tax and revenue all live in spreadsheets, topped up with notes at the front desk. It works surprisingly well for a long time, until a file goes missing or the one person who keeps it all in their head is off sick. This guide shows which lists to replace with what, in which order, and how to do it in 30 days.

- Excel is a good calculation tool but a poor home for data that several people change at the same time: occupancy, room status and outstanding payments.
- The biggest risks are outdated versions, typos nobody checks, guest data in unprotected files and dependence on a single person.
- Replace the booking chart first, then housekeeping and guest data, and finally deposits, tourist tax and revenue lists.
- Excel still makes sense for analysis: exports as CSV or XLSX for your own reports and packages for your accountant.

## Where Excel and paper notes hide today

Hardly any property has just one spreadsheet. It is usually a web of files that someone created at some point and that have kept growing ever since.

A typical setup is a booking chart with one row per room and one column per day, colour-coded by guest or OTA. Alongside it there is a room list printed for housekeeping every morning, a guest list with addresses for registration and regulars, a list of deposits, a tourist tax sheet for the municipality and, at month end, a revenue list for the owner and the accountant.

Each of these lists has a purpose, and each was created out of a real need. The problem isn’t Excel; it is that the same booking appears in four files and every change has to be updated by hand in four places.

### Typical lists and what they become in hotel software

| List today | What it is used for | In hotel software |
| --- | --- | --- |
| Booking chart in Excel | See free rooms, enter bookings | Tape chart with daily, weekly and monthly views, move bookings by drag and drop |
| Housekeeping room list | Who cleans which room, departure or stayover | Daily schedule from actual arrivals and departures, room status visible to everyone |
| Guest list | Addresses, registration data, regulars | Guest profiles with stays, duplicate check and registration data from online check-in |
| Deposit list | Who has paid, who needs a reminder | Payments attached to the booking, outstanding amounts visible |
| Tourist tax sheet | Overnight stays and levy for the municipality | Tourist tax calculated per booking and shown on the invoice |
| Revenue list | Monthly figures for owner and accountant | Reports by period, export for Excel and for your accountant |

## The risks of Excel in day-to-day hotel operations

The first risk is versions. If the booking chart lives on the front desk computer, there is soon a copy in the back office, one on the owner’s laptop and a printout from this morning. Which one is right? On a quiet Tuesday you can find out. On a Saturday evening with three arrivals and a call from Booking.com, you can’t.

The second risk is errors nobody checks. Excel doesn’t warn you when a room is entered twice for the same night, when a departure is a day too early or when a formula shifts as you insert a row. Hotel software rejects a booking for an occupied room before the guest receives a confirmation.

The third risk concerns guest data. Names, addresses, dates of birth and sometimes ID numbers in a file that is emailed around or carried on a USB stick sit uneasily with the GDPR’s requirements for access control and deletion. In software with individual logins and permissions, you can trace who sees which data. The fourth risk is dependence: often only one person knows the colour codes, abbreviations and special rules. If they are away, the hotel grinds to a halt.

### Example: a 12-room guesthouse in peak season

In the morning, the owner enters a phone booking into her Excel file on her laptop. The part-timer at the front desk works from the morning printout and gives the same room to a walk-in guest in the afternoon. All details are an example.

- **Cause:** Two versions of the same chart
- **Consequence:** A guest has to be walked to another hotel in the evening
- **Cost:** Replacement room, taxi, a goodwill gesture and an annoyed review
- **With hotel software:** The second confirmation for the room is rejected on saving

## What to replace first

Not everything at once. Start where a mistake costs the most.

The booking chart comes first, because that is where double bookings happen. As soon as all bookings, including phone and walk-in, are in one place, the biggest risk is gone. If you sell through OTAs, connecting them via a channel manager belongs in this step too.

Housekeeping and guest data come second, because they depend directly on occupancy. The morning room list is then generated from arrivals and departures, and the guest database grows with every booking without anyone retyping addresses. Deposits, tourist tax and revenue lists come third. They benefit most once the first two steps are in place, because then every figure comes from real bookings.

### Order for replacing your spreadsheets

- Booking chart: from now on, all bookings go into the hotel software only, including phone and walk-ins.
- OTAs: connect Booking.com and other OTAs through the channel manager and stop maintaining availability in the extranet.
- Housekeeping: daily schedule from the software instead of an Excel printout.
- Guest data: guest profiles and registration data from the booking and online check-in.
- Deposits: payment status on the booking instead of in a separate list.
- Tourist tax and revenue: reports and exports from the software instead of a monthly list.

## The 30-day plan

Thirty days are enough for a small property if you break the switch into weeks and give each week a clear goal. What matters is a fixed cut-over date after which the Excel booking chart is no longer changed. Until then, both can exist side by side; afterwards there is only one source of truth.

### From Excel to hotel software in four weeks

1. **Days 1 to 7: the basics**

   Set up rooms, room types, rates with and without breakfast, cancellation policies and tourist tax. Create an individual login with suitable permissions for each person on the team.

2. **Days 8 to 14: migrate data**

   Prepare future bookings and the guest list from Excel as CSV or XLSX, map the columns and check in a test run what would be created. Only then import, and compare the number of bookings per month with your list.

3. **Day 15: cut-over date**

   From today, bookings are made in the software only. The Excel file is stored read-only and is used for reference only.

4. **Days 15 to 21: housekeeping and OTAs**

   Use the housekeeping schedule from the software. Connect the OTAs through the channel manager and check that every OTA room type is mapped to the right room type.

5. **Days 22 to 30: payments and reports**

   Create deposits and invoices from the booking, pull your first monthly report from the software and agree the export format with your accountant.

### A trial day helps

Before the cut-over date, play through a complete day with front desk and housekeeping: arrival, room move, extra, invoice, departure, cleaning. Anything that jars can be sorted out before it matters.

## Which reports and exports still make sense

Without Excel doesn’t mean without spreadsheets. For your own analysis, talks with the bank or a year-on-year comparison, a spreadsheet is often exactly right. The difference: the data is no longer maintained in Excel but exported from the software when needed. That way you always work with the current figures and never with a copy from last week.

Three kinds of export remain especially useful: booking lists for a period, for example to analyse sources or length of stay yourself; reports on occupancy, average rate and revenue for owners and the bank; and the package for your accountant in the format their firm works with. Everything else that is produced today as a monthly list should be something the software can display itself.

### Exports worth having

| Export | For whom | Format |
| --- | --- | --- |
| Booking list for a period | Management, own analysis | CSV or XLSX |
| Occupancy, ADR and revenue | Owner, bank | PDF for filing, XLSX for further calculations |
| Invoices and payments | Bookkeeping | PDF and spreadsheet export |
| Package for your accountant | Tax advisor | The firm’s format, e.g. DATEV or BMD |

## How STRYK handles it

In STRYK the tape chart replaces the Excel spreadsheet: daily, weekly, two-week and monthly views, drag-and-drop to move bookings, walk-ins and multi-room bookings created directly. New bookings, including those from OTAs, appear without reloading. Before every save, STRYK checks whether the room type is still free for every night, so a room is never promised twice. You manage portals such as Booking.com, Expedia and Airbnb from STRYK once your property has a confirmed connection to them. Manage rates and availability centrally and handle OTA reservations in the calendar.

The housekeeping schedule is generated daily from actual occupancy, with room statuses such as dirty, clean and inspected, assignment to staff members and a PDF schedule that STRYK can email every day if you wish. Guest data goes into the guest profiles, registration data comes from online check-in; for Austria, STRYK monitors the registration deadline and creates the export for the registration system. Deposits are handled through online payment and are attached to the booking. STRYK calculates tourist tax per booking, including age bands and exemptions, and shows it on the invoice.

For analysis, STRYK offers reports as PDF, XLSX and CSV, booking lists can be exported as CSV or XLSX, and for your accountant there are exports including DATEV and BMD format. You bring over your existing Excel lists through the data import with column mapping and a test run. Everyone works with their own login and suitable permissions, there is no limit on the number of users, and the activity log shows who changed what.

### Your next step

During the trial, take your Excel booking chart for the next four weeks, bring it in through the data import and compare the result room by room. You will then see which of your lists you no longer need after the cut-over date.

## Што нè прашуваат хотелиерите пред промената.

### Is there a good Excel template for a hotel booking chart?

For one or two rooms a template may be enough. As soon as several people take bookings or you sell through an OTA, any template hits its limits, because Excel doesn’t prevent double bookings and doesn’t talk to Booking.com. At that point hotel software is the better alternative.

### From how many rooms is software worth it instead of Excel?

It depends less on the number of rooms than on the number of channels and people. If you sell through your own website and an OTA, or two people work the front desk, software immediately makes things safer.

### Can I bring my Excel lists into STRYK?

Yes. With the data import, you map the columns of your file to the fields in STRYK. A test run shows in advance what would be created, linked or skipped, without saving anything.

### Can I still create Excel files from STRYK?

Yes. Booking lists can be exported as CSV or XLSX, reports as PDF, XLSX or CSV. For your accountant there are dedicated exports, including DATEV and BMD format.

### Is a guest list in Excel allowed under the GDPR?

The GDPR doesn’t prohibit Excel, but it requires, among other things, access control and the deletion of data that is no longer needed. That is hard to comply with for files that are copied and emailed around. For a specific assessment of your property, talk to your data protection advisor.

### How long does it take to move from Excel to hotel software?

For a small property, 30 days is realistic: one week of set-up, one week of data migration with a test run, then the cut-over date and two weeks in which housekeeping, OTAs, payments and reports follow.

## Дознај повеќе

- [Hotel operating system: one all-in-one hotel software instead of five separate tools](https://staystryk.com/mk/guides/hotel-os/)
- [How to avoid hotel overbooking: causes, prevention and what to do when it happens](https://staystryk.com/mk/guides/avoid-overbooking/)
- [Hotel housekeeping planning: daily schedule, cleaning times and room status](https://staystryk.com/mk/guides/housekeeping-planning/)
- [Миграција на податоци](https://staystryk.com/mk/features/data-import/)
- [Hotel Insights](https://staystryk.com/mk/features/reporting/)
- [Календар за зафатеност](https://staystryk.com/mk/features/calendar/)
