Download
License: Private Use (not for distribution or resale). See our Terms of Use.
You are safe to download the resources. We've added our digital signatures to the files.
Description | Size | Download |
---|---|---|
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates. | 666 KB | Download |
Download this if you want this design to be set as the default template by the installer program. | 6.29 MB | Download |
Screenshots and Images
The printed version.

Open the template in Excel.

Detail
Looking for easy hotel invoicing software? Hotel Receipt Template is a free Excel spreadsheet formatted template for hotel and motel / hostel businesses, for invoicing room tental and bed and breakfast. It is also one of the samples on how to customize the default sales invoice template shipped with Invoice Manager for Excel.
A hotel or motel needs different invoice and receipt formats than a generic sales invoice template or generic service invoice template for purchasing goods and service. The blank receipt form provided here on InvoicingTemplate.com offers a sample hotel receipt that you could use to create your hotel bills in an easy way. Our templates are in Microsoft Excel format. All templates here are not protected with password, so that you can easily customize the layout without problems. You can also download a printable PDF version of the hotel invoice template here. If you are looking for a hotel invoice template in Word ".doc" format online, we recommend this Excel-format template instead, as Excel provides more features for calculations and data validations.
Front office transactions are typically charted on account statement as Invoice or Folios. Invoice consists of Debit and Credit (Also refer to Credit Memo Template) affecting the balance of a single guest account or room. This is different than general house rent, for which InvoicingTemplate.com also has a house rental invoice template too at House Rent Receipt Template.
If you use the Invoice Manager for Excel version of the hotel invoice template / hotel receipt template, the receipt# (or invoice#) is generated automatically when you save the document.
A hotel receipt is also called guest invoice, folios or bill format for hotels. Usually when a folio is opened the starting balance is zero. All transactions which increase (debit) or decrease (credit) the balance of the account are recorded on the folio. In Invoice Manager for Excel, when guest does the final settlement of the invoice should be returned to zero balance by any of the method of payment given by guest. The process of recording transactions on an Invoice or a receipt is called posting. A transaction is posted either debit or credit when it has been recorded on the proper folio in the proper location and a new balance is determined.
This templates use several custom fields that are not found in the default sales invoice template shipped with Invoice Manager for Excel. The definition of the custom fields could be found by a travel to the corresponding data edit form in Invoice Manager for Excel.
While there are complex and expensive hotel management software programs available, which, generally, could also produce invoices and receipts for you, this free hotel invoice template and receipt template offers a budget-free way for creating professional invoices and receipts. The intuitive blank form of this template allows you to prepare and draft your invoices and receipts without a hard learning curve.
The template has two taxes defined on the bottom of the form - which you can easily change the names and rates depending on your requirements. The Taxable column found in the default sales invoice template was removed from the hotel receipt template.
Format and Specification
Template# | c7005 |
Name | Hotel Receipt Template |
Category | Receipt Template |
Release Date | Monday, January 20, 2014 |
Format (XLS or XLSX) | .xlsx |
Feature Gallery | |
Columns | 7 |
Lines | 12 |
Line Height (Points) | 19.50 |
Print Area | $D$3:$N$45 |
Papaer Size / Orientation | Portrait |
Default Margins (Points) | |
Left | 22.68 |
Right | 22.68 |
Top | 45.35 |
Bottom | 45.35 |
Price | Free (0.00USD) |
System | Windows 7 and later, and Excel 2007 and later. |
Update History
August 13, 2016
- The "Invoice" worksheet is protected by default.
- Unfreeze panes.
- Converted from ".xls" to ".xlsx" format.
- New color schema.
- "Bookman Old Style" font.
May 16, 2019
- Removed hyperlink from the "Phone Number" line.
- Linked to online document.