Hotel Invoice Template

Setup takes about 20 minutes the first time. Download the .xlsx file and open it in Excel or Google Sheets. Start with the Tax Calculator sheet — enter your property's current occupancy tax rate, F&B tax rate, and any resort or amenity fees. These feed into the Invoice sheet automatically, so getting them right upfront means every invoice you create will have the correct tax calculations. Then move to the Corporate Account Directory and add your regular corporate accounts and travel agencies. Finally, review the Rate Schedule and update it with your room types and current rates.

To create an invoice, go to the Invoice / Folio sheet and enter the invoice number, select the client from the Corporate Account Directory dropdown, and fill in the stay dates and confirmation number. In the line items section, enter each charge by category — room nights at the rate from the Rate Schedule, any F&B charges, parking, incidentals — and the subtotals calculate automatically. The tax block pulls from the Tax Calculator sheet and applies the correct rate to each charge type. Review the total, add any deposit received, and the balance due calculates itself. Print or export to PDF to send.

After sending, log the invoice in the Invoice Log. Enter the invoice number, client name, dates, total, and set the status to Outstanding. Update the status to Paid when payment clears — or flag as Overdue if it hasn't arrived by the due date. Hotels with active city ledger accounts typically do a weekly AR review: five minutes scanning the Invoice Log for anything approaching or past due, then following up with the corporate travel coordinator or travel agency. Corporate clients who regularly use your property expect a smooth billing process, and a consistent follow-up cadence is the main thing that separates hotels with clean AR from those always chasing payments at month-end.

Hotel invoicing is more complex than most industries because a single stay can generate charges across three or four different revenue centers — rooms, F&B, spa, parking — each of which may carry a different tax rate and need to appear as a distinct line item. Corporate clients billed through a city ledger account often have strict requirements: specific account codes on the invoice, occupancy tax separated from F&B tax, and resort fees called out individually. Generic invoice templates force you to compress all of that into a flat line-item list, which creates disputes and slows payment. A hotel-specific template structures the folio the way corporate accounts and travel agencies expect to receive it.

The city ledger is where most hotel billing risk lives. ADR for a full-service hotel typically runs $150–$300, but a group block or corporate account billing several hundred room nights per year represents tens or hundreds of thousands of dollars in receivables. The standard expectation in the industry is Net 30, but many corporate accounts push for Net 45 or Net 60, and travel agencies often operate on their own reconciliation cycles. Tracking all of this in a structured Invoice Log — with clear due dates, payment statuses, and outstanding balance totals — is the difference between a clean AR aging report and a revenue recognition problem at quarter-end.

The rate schedule is an underappreciated operational tool. Hotels negotiate dozens of corporate rates, group rates, and package rates simultaneously, and it's easy to bill at the wrong tier when invoices are created ad hoc. Maintaining a single Rate Schedule sheet that feeds the Invoice / Folio via dropdown means the correct contracted rate is applied consistently — whether the invoice is created by the front office manager, the sales coordinator, or the GM. When a corporate client disputes a rate, you have clear documentation of what was agreed and when. That same rate table also makes annual rate renewal easier, because you can see all contracted accounts in one place rather than hunting through individual contracts.