Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Hotel Receipt Template. Double-click the downloaded file to extract all files.
  2. Open the template "hotelreceipt.xlsx" or "hotelreceipt-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Hotel Receipt Template

Hotel Receipt Template (c7005)

c7005 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open hotelreceipt-uis.xlsx.

Hotel Receipt Template (UIS Edition)

Hotel Receipt Template - UIS edition

Download Hotel Receipt Template (c7005)

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.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

322 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.78 MBDownload

Detail

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 Uniform Invoice Software.

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 Uniform Invoice Software 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 Uniform Invoice Software, 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 Uniform Invoice Software. The definition of the custom fields could be found by a travel to the corresponding data edit form in Uniform Invoice Software.

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.

Like other form designs here on InvoicingTemplate.com, Hotel Invoice Template is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c7005
NameHotel Receipt Template
CategoryReceipt Template
Release DateMonday, January 20, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns7
Lines12
Line Height (Points)19.50
Print Area$D$3:$N$45
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

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.

    Sample Templates