How to capture the menu in the new system with the categories you will report on
Capturing the menu in the hotel restaurant is not just typing names and prices. It is deciding, from day one, how the report will look six months from now. Here is the right order so you do not have to redo it all later.
The most expensive mistake when implementing a new system in a hotel restaurant does not happen at the register, it happens when the menu is captured. If you enter each dish however is convenient that day, without thinking about how the controller will read it six months later, you will have to recapture the whole menu once the first report shows up saying nothing useful.
Why the menu is not just a price list
In a standalone restaurant, the menu can live as a flat list: name, price, done. In a hotel restaurant, the menu is the foundation of several reports that cross-reference occupancy, the hospitality accounting standard, and the room charge (Room charge). If each dish’s category is not well defined from capture, none of those reports will be able to break down correctly.
Think about the question the controller will ask at month-end: “how much did we sell in food versus alcoholic beverages?” If the menu did not distinguish those two categories from the moment it was captured, no report can answer that question without someone reviewing dish by dish by hand.
The minimum categories a hotel needs
The hospitality accounting standard (USALI) splits food and beverage revenue into specific categories, and even if your hotel does not report at that level of detail yet, capturing the menu with those categories in mind from the start saves you a painful migration later. These are the minimum categories your menu should distinguish:
| Category | What it includes | Why it is separated |
|---|---|---|
| Food | Dishes, appetizers, desserts, bread | The base category of every F&B report |
| Non-alcoholic beverages | Soda, juice, coffee, water | Different turnover and margin than alcohol |
| Beer and wine | Beer, wine by the glass or bottle | Usually reported separately from spirits |
| Liquor and cocktails | Mixed drinks, spirits | Higher margin, higher waste control needs |
| Other F&B revenue | Service charges, event equipment rental | Not product sales, and distorts margin if mixed in |
The right order to capture
Do not capture the menu starting from the first dish that appears on the printed menu. The printed menu is organized for the guest, not for the report. Follow this order in the system, which is designed so the report comes out clean from day one.
- Define the top-level categories from the table above first, before capturing a single dish.
- Within each category, create the subcategories your menu needs: for example, within food, appetizers, mains, desserts.
- Capture dishes one by one, always assigning the correct category and subcategory, never “other” as an easy way out.
- Define common modifiers before capturing them dish by dish: meat doneness, milk type, no spice.
- Check that every alcoholic beverage has its correct beer-and-wine or liquor category, never mixed with non-alcoholic drinks.
- Do a final review cross-checking the captured menu against the printed one, dish by dish, before opening to the public.
Modifiers: the detail almost nobody captures well
A modifier is any change a guest requests on the base dish: meat doneness, type of milk in the coffee, no onion. The temptation is to write it as a free-text note on the order, but that breaks the report in two ways: you cannot count how many times each modifier was requested, and you cannot charge differently if the modifier has an added cost.
- Create modifiers as a structured list tied to each dish, not as free text.
- Define whether the modifier has an added cost or is free, and capture it that way from the start.
- Group common modifiers across several dishes, like meat doneness, instead of capturing it twenty different ways.
- Check with the kitchen which modifiers are requested most often before capturing the menu, so the common ones are not left out.
What happens if you capture everything as “various” or “food”
The easy way out of dumping everything under one generic category gets paid for later, when the monthly report reaches the controller unable to break anything down. If the whole bar was captured as “food” because nobody had time to create a beverage category, food and beverage revenue per occupied room (How food and beverage revenue per occupied room is calculated, and what a good number looks like) will be correct in total, but useless for knowing whether the bar or the kitchen is performing better.
Fixing this later is not just recategorizing in the system. It means losing the historical comparison for the badly captured period, because that period can no longer be rebuilt with the correct category unless someone reviews order by order.
This kind of mistake usually surfaces at the worst possible moment: during an internal audit, or when the hotel group asks for the F&B breakdown to consolidate several properties. By then there is no time left to recapture six months of history, and the controller ends up explaining at the meeting why the number cannot be broken down, which erodes trust in the whole report, not only the miscaptured category.
An illustrative example of why the category matters
The figures below are made up to show the calculation; they do not correspond to any real property.
| Category | Monthly sales (illustrative example) | Approximate margin |
|---|---|---|
| Food | 180,000 | 35 % |
| Non-alcoholic beverages | 22,000 | 55 % |
| Beer and wine | 38,000 | 60 % |
| Liquor and cocktails | 16,000 | 70 % |
In the example, if the four categories had been captured as one, the margin the controller sees would be a confusing average that does not say whether it makes sense to push more bar or kitchen sales. With the categories separated, the decision is obvious: every peso that moves from the dining room to the bar raises the restaurant’s overall margin.
When to migrate the menu and when to start from scratch
If you are coming from a previous system, the question is whether to migrate the menu as-is or capture it from scratch in the new system. The answer depends on how well it was categorized in the old system. If the previous system already distinguished food from alcoholic beverages with clean data, migrating and only adjusting the structure saves time. If everything was mixed together, capturing from scratch with the right categories ends up faster than fixing a half-done migration.
- Export the menu from the previous system and check whether the existing categories match what you need.
- If they match at least 80 percent, migrate and only fix the exceptions.
- If most of it is in one generic category, decide to capture from scratch instead of wasting time fixing it one by one.
- Use the migration to remove dishes that are no longer on the current menu, instead of carrying them over out of convenience.
Who should capture the menu
Menu capture should not be left only to IT or the provider, because they know the system but not necessarily the menu. It should not be left only to the chef either, because they know the menu but not necessarily how the report is structured. The right combination is the chef or the food and beverage manager defining the content, with the controller or IT validating that the categorization is correct for the report.
The hotel restaurant’s menu should be captured with the report you will need six months from now in mind, not the order of the printed menu. Clear categories for food, non-alcoholic beverages, beer and wine, and liquor, plus structured modifiers, are the difference between a useful report and one that only gives you a total.
What to do this week
- Define the five minimum categories from the table before capturing any new dish.
- Review the current menu and flag which dishes are miscategorized or sitting under “various”.
- Bring the chef or F&B manager together with whoever captures the system to review the full menu together.
- Structure the most common modifiers as lists tied to dishes, not as free-text notes.
- Do a cross-check of the printed menu against the system before opening to the public with the new menu.
Inn Restaurant organizes the menu from capture with the hospitality standard’s categories, so the food and beverage report (Reports) is ready from the first month. If you are about to implement the system in your hotel restaurant, book a 15-minute demo at (contact).
More guides
The first thirty days with the new system in the hotel restaurant: what to measure each week
The day of the switch is not what determines whether the new system worked. It is the month that follows. Here is what to check week by week in your hotel restaurant to reach the first monthly report with confidence.
How to run a live rehearsal of the point of sale with real orders before the first service
A live rehearsal is the difference between discovering that a room charge never reaches the folio with an empty dining room or with a full hotel. Here is how to set it up in your hotel’s restaurant: the scenario, who takes part, what gets tested and what has to happen to pass.
A guide to backing up and exporting the hotel restaurant’s data without depending on the provider
The hotel restaurant’s data belongs to the hotel, not to the system that stores it. This guide covers what to back up, which format to demand and how often to do it, so switching providers is never a leap into the dark.
Your hotel’s restaurant already sells well. Now the hotel needs to know it.
Fifteen minutes, with your menu and your tables. Nothing to install.