|
|
|
Lodging Tax Exempt (LODGING_TAX_EXEMPT.REP)
The Lodging Tax Exempt (LODGING_TAX_EXEMPT.REP) report lists all reservations that were exempted from tax posting on ‘Lodging’ type (Room revenue related) transaction codes, due to a rule / tax type. Data is grouped by the transaction code used to post the tax and within that it is sorted by Reservation Confirmation number in ascending order.
The CASHIERING > TAX TYPES application parameter and CASHIERING >ADVANCED GENERATES application function must be active for this report to be available. The Generic Tax Types feature must be used to configure the taxes along with Advanced Generates functionality for appropriate taxes and exemptions to be applied, and to define days to stop posting tax based on the length of stay.
If the taxable Lodging type revenue is adjusted using the Adjust Transaction right-click option in the Billing screen or manually by posting an appropriate lodging transaction code, the tax adjustments are posted along with the revenue adjustment as long as the same tax generate transaction codes are associated. If the adjusted revenue was posted by selecting a specific lodging transaction and then using the right-click Adjust Transaction option where adjustment postings are made automatically, these adjusted revenue / postings are accounted for within the date range for the rate that is associated with the original lodging transaction that was adjusted. If the adjusted revenue was posted manually without selecting a specific lodging transaction and then using the right-click Adjust Transaction option, these manually adjusted revenue / postings are accounted for within the date range for the rate that is posted on the date this manual adjustment posting occurred.
If there is any Lodging type revenue posted on a transaction code that has no tax configured for it, it is not included on the report.
The primary condition for the tax exempt report to identify the exempt revenue is that the date range used to run the report must include the date/day when the tax posting stopped for a reservation included in the report, based on the Do Not Post after value specified in advanced generates. That date is the trigger for this report to consider the room / lodging revenue posted to a reservation and determines which was posted prior to this trigger date and which was posted after to distinguish Exempt revenue and Exempt revenue previously taxed. If this trigger date does not fall between the report date range for any reservations included in the report, the Exempt revenue and Exempt revenue previously taxed amounts will be 0.00.
This report is irrespective of the Tax Type Calculation setting (i.e., Reservation or Profile), it simply lists the Exempt revenue and Exempt revenue previously taxed for the reservation for the date range.
If within a selected date range, the eligible reservation has multiple rates, then there is a separate row on the report for each rate amount posted. For example, the shaded records below are for 1 reservation that has different rates during the 20 nights stay and appear multiple times on the report for each rate amount.
Guest Name |
Check-In Date (permanent) |
Beginning Exemption Date |
Ending Exemption Date |
# of Nights |
Room Rate |
Total |
Ron Landau |
7/10/2014 |
8/10/2014 |
8/10/2014 |
1 |
102.60 |
102.60 |
Ron Landau |
7/10/2014 |
8/11/2014 |
8/13/2014 |
3 |
111.15 |
333.45 |
Ron Landau |
7/10/2014 |
8/14/2014 |
8/17/2014 |
4 |
102.60 |
410.40 |
Ron Landau |
7/10/2014 |
8/18/2014 |
8/20/2014 |
3 |
111.15 |
333.45 |
Michael Hurst |
5/10/2014 |
8/8/2014 |
8/31/2014 |
24 |
109.00 |
2,616.00 |
The report can be filtered by these parameters:
Tax exempt Lodging type revenue is reported based on the Transaction Code and the Tax Type (Tax rule) associated with the guest in-house, OPEN FOLIO /checked out record. These are the report columns:
Confirmation Number. Reservation confirmation number.
Guest Name. Profile last name and first name.
Tax Type. Tax Type code associated with the profile/reservation.
Arrival Date. Day, month and year (MM/DD/YYYY).
Exempt Begin Date. The date that the tax exemption began for the specific rate amount, this is the same date that this rate was posted for the first time.
Exempt End Date. The date that the tax exemption ended for the specific rate amount, this is same date that this rate was posted for the last time after the begin date in continuity (i.e., without interruption).
Res. Status. Checked In or Checked Out.
Nights. Number of nights for the specific rate amount (i.e., Exempt End Date minus Exempt begin date. (Minimum 1 night, no 0 nights). Day use is 1 night.
Room Rate. Rate amount for the range of the exempt begin and end dates.
Total Room Rate. Room Rate multiplied by Nights.
Exempt Revenue. Amount of Lodging type revenue only that was exempted for the tax transaction code during the time period selected, for the specific rate. Trn Type of the transaction code must be 'Lodging'. This revenue should not have been previously taxed (i.e., this revenue is posted after the reservation stayed past the number of Do Not Post Days on tax configuration).
Exempt Revenue Previously Taxed. Amount of Lodging type revenue only that has been previously taxed and has earned tax exempt eligibility during the reported time period for the specific rate, Trn Type of the transaction code must be 'Lodging'. This revenue should have been previously taxed (i.e., this revenue is posted before the reservation stayed past the number of Do Not Post Days on tax configuration). For example, for a reservation staying for 20 nights, a lodging transaction was taxed for 10 nights at 10%; however, this transaction is tax exempt if the reservation is for more than 10 nights. The tax is posted for each of the 10 nights assuming the transaction posts every night; however, on the 11th day, the tax could automatically be adjusted based on the Advanced Generates configuration. If a report is taken for this transaction code on the 15th day of the stay, this column shows the revenue against the lodging transaction code for the first 10 nights when the tax was actually posted. Since after 10 days, there are no more tax postings, the revenue for the remaining nights is accounted for under the Exempt Revenue column. This amount is shown as a single lump sum; it is not broken down by different rate amounts for various stay date ranges like the Exempt Revenue amount.
Total Exempt Revenue. Total Tax Exempt Revenue (Exempt Revenue + Exempt Revenue Previously Taxed).
This report has a bottom row for each Tax Transaction Code, which displays the total for each of the 3 revenue related columns.
