This free invoice template offers a sample of guest invoice and bill format for hotels. There are 7 columns on the invoice body: room#, name, and check in, check out, #of nites, price/nite, and line total. On the invoice heading section, you can enter your own hotel/motel information, including hotel name, hotel street address, hotel city and prov., hotel country and postcode, hotel phone number and fax number, hotel toll-free number, hotel email address and web site.
Invoice date and invoice number fields are located to the right of your own hotel or motel information. When creating an invoice, make sure the invoice# (or invoice number) is unique. If you use our Invoice Manager program, the program can generate a unique invoice number automatically.
When posting transactions on the invoice form, you enter the details of the transaction on the invoice body. All the summary information, including line total, subtotal, taxes, total and total due, are calculated automatically. This free invoice template assumes all the items on the invoice body sections are taxable. This differs from many of the invoice templates available on this site, where a 'taxable' column implemented as a list of checkboxes allows you to specify whether the current item is taxable on a line by line basis.
Hotel Invoice Template is featured on the following hot pages.
Tip: Enlarge an image by clicking on it.
Hotel Invoice Template
This is how hotel invoice template will look like when you open it with Microsoft Excel.
Hotel Invoice Template freeware version
The following Uniform Invoice Software version of Hotel Invoice Template should be used with Uniform Invoice Software installed.
Hotel Invoice Template for Uniform Invoice Software
Choose the format you like and download Hotel Invoice Template for free.
Make Hotel Invoice Template a powerful invocing program.
Hotel Invoice Template in PDF format.
Find out how to use Hotel Invoice Template with Uniform Invoice Software
There are 3 columns on the invoice body, i.e. line#, description, and amount. Both the description and the amount are editable. If the amount on a line is filled in, the corresponding line# is filled in automatically using Excel formula. This sales invoice template has two taxes set on the bottom of the invoice form. You can modify the default tax name and tax rate to meet your needs.
It's easy to make adjustment to the invoice format we provide to create your own invoice form by dragging and dropping cells in Excel. To do this, firstly drag your mouse to select the cell or cells you want to move, and then push your mouse on the border of the selected area and drag it to its new location you like. Excel also provides many tools you can use to format the invoice form, simply right-click the cell / cells you want to format, choose Format Cells from the menu - and, on the Format Cells dialog box, you may find a number of options for formatting the cell, including number format, fonts, borders, patterns, etc.
This is another sample of how to modify an existing invoicing template (in this case, a VAT invoice template with 2 VAT rates) to create a new one. The original free invoice template places the 'VAT Rate' and 'VAT Amount' columns outside the print area. While the original form design leaves more spaces for writing item descriptions etc., by moving the VAT Rate and VAT Amount columns into the print area you give your customers / clients more clear figures on how everything is calculated.
This free sample invoice template implements a feature that allows you to charge different tax rates based on the type of an invoicing item - for example, one tax rate for labor and another tax rate for general items (products). The type of an item can be selected from a dropdown list, the Excel formulas implemented in the template check the type, and apply correct tax rate to the current item. The template then calculates all the line totals, subtotal, tax total and grand total, all done in an automated way. You might think this type feature could be hard to find even in some complicated invoicing programs, but with Excel it is done without a line of programming code. This is another good example of how to fulfill your special business requirements by using Excel-based invoicing.
On the top of the invoice the form shows your company information and the big word 'INVOICE'. Following it there is a customer section located on the left (usually titled with 'Bill To' in the templates available on Uniform Software - but this type of static text can be changed easily - you can simply type in your own labels to replace the existing one.) At the right hand there are fields for 'VAT REG #', 'Tax Date', 'Invoice Number', 'Purchase Order #', 'Payment Term' and 'Due Date'. On the invoice detail section there are 4 columns inside the print area, i.e. 'Description', 'Price', 'VAT' and 'TOTAL'. Since this invoice template is designed for service business, the 'Quantity' column is fixed to '1' and located outside the print area. Another feature of this invoice template is that it allows you to specify VAT Rate for each item (again, outside the print area). If your items are always at the same vat level, you can fill in the VAT Rate column and lock this column of values.
The most interesting part of this invoice template is that how the template translate address the Holland format - the template allows you to enter the client address information (both the 'Bill To' and 'Ship To' addresses) in 'City (State) ZIP' format, and then transform it into 'ZIP CODE space City' format, for example '567 AA Amsterdam'. The transformation is done automatically with Excel formula. Another point to notice about this invoice template is that the invoice body has 6 columns - since this invoice template is designed for clothing-related business, a 'Size' (Maat) column is necessary - and usually important enough to list it as a dedicated column.