Hotel Utility Formulas

Hotel Utility Refund - Simplified Formula
This worksheet will assist those hotels and motels who wish to calculate their hotel utilities refund using the simplified method. The link above is to a Microsoft Excel spreadsheet, you must have Microsoft Excel or an Excel Viewer to view this document. Please save the spreadsheet to your computer for future use. Also, once you've issued your exemption certificate to the utility company, you must accrue and remit that portion of utility services purchased that are not resold. Reference "Calculating Taxable Hotel Utilities - Simplified Formula" below to calculate the proper amount of tax to report and remit.
Calculating Taxable Hotel Utilities - Simplified Formula
Once hotels and motels issue their resale exemption certificate to their utility, the hotel and motel must accrue and remit the tax on utility services that have not been resold. The hotel or motel must report and remit the sales tax directly to the department on their sales tax return. This worksheet will assist hotels and motels in calculating the proper amount of tax to report using the simplified method.
Hotel Utility Refund - Detailed Formula
This worksheet will assist those hotels and motels who wish to calculate their hotel utilities refund using the detailed method. The link above is to a Microsoft Excel spreadsheet, you must have Microsoft Excel or an Excel Viewer to view this document. Please save the spreadsheet to your computer for future use. Also, once you've issued your exemption certificate to the utility company, you must accrue and remit that portion of utility services purchased that are not resold. Reference "Calculating Taxable Hotel Utilities - Detailed Formula" below to calculate the proper amount of tax to report and remit.
Calculating Taxable Hotel Utilities - Detailed Formula
Once hotels and motels issue their resale exemption certificate to their utility, the hotel and motel must accrue the tax on utility services that have not been resold. The hotel or motel must remit the sales tax directly to the department. This worksheet will assist hotels and motels in calculating the proper amount of tax to report using the detailed method.