BoostExcel main content

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.

735 KB Download

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

6.30 MB Download

Screenshots and Images

The printed version.

Hotel Bill Format with Online Payment Button

Open the template in Excel.

Hotel Bill Format with Online Payment Button (IMFE Edition)

Detail

Looking for hotel billing software in Excel? This is the one you need. In the hotel / motel businesses customers usually pay at the front office. For those clients who are under long term contracts, or for the rental of meeting room etc., it is useful to add a PayPal button to invoices / receipts so that the clients are able to pay online.

Note: Download Invoice Manager for Excel to make this template a fully functional hotel billing software in Excel!

By including the PayPal payment button on the PDF invoice (test it!), the client is able to pay you through PayPal by clicking / tapping on the PayPal button. The hyperlink takes the client to PayPal web site, with the invoice# (receipt#) and amount included as the transaction detail. This reduces typo mistakes. Being in the widely supported PDF format, the invoice and the PayPal payment button work on almost any devices today - not only Windows desktop computers, but also Mac, and even mobile phone devices. Feel free to see all our invoice templates in PDF format!

Note due to the internal hyperlink handling / caching mechanism of Microsoft Excel, the payment button does not work directly on the Excel spreadsheet template. Furthermore, the link on the Excel spreadsheet is just a template, which includes variables such as "oknBalanceDue" and "oknInvoiceID". However when generating the PDF invoice, Invoice Manager for Excel will update the link to replace the variables with transaction details reflected on the current invoice - for example, the invoice# will be inserted to item description, the invoice balance will be the amount to pay.

When you click the "Extract/Email" button to send the electronical PDF invoice to your clients, Invoice Manager for Excel will update databases to record whether or not the email was successfully sent out.

The form layout of this template is based on c7005 Hotel Receipt Template published here on InvoicingTemplate.com. As the original design, it includes 7 columns - "Room #", "Name", "Check in", "Check out", "# of Nites". "Price / Nite", "Line Total". The automatic calculation of the subtotals, totals, taxes are done using Excel formulas. This is one of the big advantages of Excel spreadsheet templates - you can use formulas to do calculations. While it is easy to do document formatting in Microsoft Word too, the auto calculation of Excel spreadsheet makes it much easier to create invoices.

With this design, we've also removed the original "Country" field, placed the "Email Address" field in the "Bill To" section. "Other Information" is now a general purpose, multiple lined "Notes" box.

With this design, we've set the number of taxes to one. To change the taxing options, click the "Settings" button on the "Invoice" ribbon tab, and then go to the "Taxes" tab.

Although we've cleared the custom fields in the "Other Information" section, they are still in the Microsoft Access database. So this template and c7005 Hotel Receipt Template could share the same database definition. If you have the Enterprise license of UIS, you can even use SQL Server database and put it online so that you are able to access it via Internet from anywhere!

Format and Specification

Template# c7030
Name Hotel Bill Format with Online Payment Button
Category Receipt Template
Release Date Saturday, August 13, 2016
Format (XLS or XLSX) .xlsx
Feature Gallery
Columns 7
Lines 12
Line Height (Points) 18.00
Print Area $D$3:$N$45
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 18.00
Right 18.00
Top 75.60
Bottom 75.60
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.

Update History

May 16, 2019

  • Updated sample data on this template.

Related

Thumbnail for Hotel Receipt Template
Thumbnail for Hotel Receipt Format with Blue Gradient Design
Thumbnail for Hotel Guest Folios with Satisfied Business Traveler
Thumbnail for Receipt Sample for Seafood Restaurant
Thumbnail for Restaurant Dining Invoice Template (VAT)
Thumbnail for Restaurant Dining Invoice Template (No Tax)
Thumbnail for Business Invoice Template