Budget assistant — your own workbook

Most companies already keep their budget in their own Excel workbook. On the Budgets page, Upload your own workbook takes that file as it is — your layout, your labels, your months — and the budget assistant reads it for you. Nothing is loaded until you have looked at the result and clicked Create draft.

What to upload

• One Excel workbook (.xlsx or the older .xls) per company and version: a budget, a forecast or a reforecast of the profit and loss, by month. Choose the Company it belongs to before you upload.
• Months in columns or in rows, Czech, English or German month names, dates, 01/2027 or M1 … M12 — all are read.
• Departments as blocks, one sheet per department with a summary sheet, totals first or last, costs entered as positive or negative numbers, amounts in units or in thousands — all are recognised.
• Statistics rows inside the budget (rooms sold, covers, guests) are read onto the group's measures.
• A CSV file is not read. A workbook that is not a budget or forecast (a cash-flow model, a loan schedule, a board pack) is named for what it is, with advice and the template to download — nothing is loaded from it.

What the assistant does — and does not do

• It never changes your numbers. It proposes, for every row, which line of the P&L layout it belongs to (or which measure, or that the row is not a budget line), with a confidence and a short reason.
• Subtotals are found by arithmetic (formulas such as SUM, or the figures themselves) and skipped, so nothing is counted twice. A row the assistant thinks is a total but the arithmetic cannot confirm is left for you to decide.
• The AI model sees a description of the workbook — labels, positions, totals and a few sample rows — never the file.
• Only the codes your group already has can be proposed: your layouts, lines, measures and companies.

The review page

1. The assistant's reading says what it found: the kind of workbook, the company, fiscal year, currency, how many months, how costs are entered, how many lines map, how many subtotals are skipped and how many need your choice.
2. Setup — company, hotel, fiscal year, first month, currency, budget rate, version name, how costs are entered, units and the layout. Change anything that is wrong; a different layout re-lists the lines and a row whose line is not on the new layout becomes not mapped.
3. The grid lists every row in workbook order (rows still to decide on top): sheet, row, label, the row's year total in the workbook, the Target (a line of the layout, exclude with a reason, or Statistics → measure), confidence and reason. Rows the assistant is not sure about are marked; rows taken from a recipe say remembered.
4. Tie-out: workbook − mapped shows, per month, what the rows that are neither mapped nor excluded add up to. It must be 0 in every month: map the rows it names, or exclude them on purpose.
5. Create draft loads the budget exactly as the template upload would: the result page of the version follows, and an admin approves it as usual. Discard drops the workbook.

The version page offers Download as template: the platform's layout template with your figures in it — what was actually loaded, and the easiest way to learn the template for next time.

Recipes

When you create a draft, the assistant remembers the workbook's shape and your confirmed rows as a recipe for that company. Next year's workbook of the same shape is read from the recipe: rows it knows are filled in at once, and only new rows are sent to the AI model — when it knows every row, no AI model is used at all. Recipes (link under Your workbooks) lists them; an admin can delete one. Recipes never leave your group.