Tax Reports

Details on what tax reports are offered, and how they are calculated.

Brent Kleinheksel avatar
Written by Brent Kleinheksel
Updated over a week ago

There are two tax reports, but they have completely different uses. The Sales / Use Tax report reports on what taxes are due for a given reporting period. The Guest Register report is meant ONLY to be used in the event of a tax audit and you need to provide proof of bodies in rooms for individual dates of the month.

Because of all the calculations necessary to arrive at a daily rate, tax, etc. the guest register report will many times be off by pennies or more from the actual amount owed which is shown in the Sales / Use Tax report. Additionally, the Guest Register Report columns are force summed to match the numbers in the Sales / Use Tax report. You should NEVER use the Guest Register Report to determine taxes owed.

Sales / Use Tax Report

The Sales / Use Tax report will calculate the tax generated for each day of the reporting period. This is based on dates of stay, not the date the tax (invoice payment) was actually collected.

This report is prorated by night, so for reservations that span multiple reporting periods, Lodgix will calculate the tax generated for each day. This will include taxes collected for the reservation amount and any fees that are set to be taxable.

Note that taxes are collected per reservation, and due to rounding on each invoice the final number will not necessarily match the totals from other financial reports. For example... the total gross revenue for a reporting period, multiplied by the tax rate, will not always match the total from the Sales / Use Tax report.

For this reason, you should ONLY use the Sales / Use tax report to determine taxes owed and not rely on or try to compare tax figures from other financial reports.

Clicking on the tax owed for a particular property/tax will generate a filtered Guest Register Report for that property, tax, and reporting period.

A Note on Airbnb Taxes

You will see two types of Airbnb taxes on the Sales / Use Tax report.

  1. Airbnb Collected Tax: This is tax that was collected by Airbnb and will be remitted by Airbnb. You do not owe this tax.

  2. Airbnb Pass Through Tax: This is tax that was configured in Lodgix, charged by Airbnb, and passed to you. You DO owe this tax to the taxing authority.

Guest Register Report

As discussed above, the Sales / Use Tax report captures tax for all reservations within a given reporting period. When part of a reservations falls outside of the reporting period, the total taxable revenue for the invoice will be prorated to arrive at a revenue per night number.

The revenue per night is then multiplied by the actual number of nights falling within the reporting period for that reservation and those numbers are multiplied by their respective taxes.

The Guest Register Report on the other hand is only concerned at arriving at a rate and tax per day. Thus nearly every night is a calculated rate / tax.

Here is an example of the difference. The following two calculations are for the same invoice, which is a 10 night reservation at $106.53 per night with a 13% tax rate...

Sales / Use Tax Report

$106.53 x 10 = $1065.30

$1065.30 x 13% = $138.49 total tax

Guest Register Report

$106.53 x 13% = $13.85

$13.85 x 10 = $138.50 total tax

Both values are correct. If we don't have to display the daily amounts, we just calculate the final sum. But for the Guest Register Report we have to display daily amounts.

Each column in the Guest Register Report is force summed to match the numbers in the Sales / Use Tax Report. If manually calculating the total for a specific column, it may differ from the forced total. This is why the Guest Register report is not a tax report and should be used only for auditing purposes. You should never compare the totals in the Guest Register Report to any other report in Lodgix.

Did this answer your question?