Use the Tax Exemption report to see which reservations in a date range have a tax exemption, and which are charged taxes that belong to a tax exemption.
Overview
The Tax Exemption report lists the reservations staying on a property in a date range, with each reservation's Rate, the code of its Tax Exemption, and two columns that mark reservations charged a tax that belongs to the selected Tax Exemptions. A Tax Exemption stops selected taxes from applying to the reservations you select it on. See Set Up and Apply a Tax Exemption.
Accounts teams and front office managers run the report to check that guests who should be exempt from a tax have their Tax Exemption, and to list the exempt stays in a period. Before you run the report, make sure your Security Profile allows Report Screens > Accounting Reports > Tax Exemption. See Configure a Security Profile.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
When to use the Tax Exemption report
The Tax Exemption report helps in situations like these:
- Listing exempt stays - at month end, the accounts team ticks Show Only Tax Exemption Reservations and runs the report for Last Month to list every exempt stay with its code and Rate Amount.
- Finding a missing exemption - the front office manager runs the report for the coming week and checks each reservation with an X under Auto Charge: its Rate carries a tax that belongs to a Tax Exemption, but the reservation does not have that Tax Exemption.
- Checking long-term stays - the accounts team checks the Fixed Charge column for Long Term reservations whose Repeat Charge carries such a tax.
How to access the Tax Exemption report
In the side menu of RMS, go to Reports > Accounting > Tax Exemption.
- Choose the report options. See Choose the Tax Exemption report options.
- Select Build.
RMS shows the report on the Report tab, with one row for each reservation and a Total Count row at the end. Use the report toolbar to print or export it.
Tip! Select Add Report to Favourites Menu to add the Tax Exemption report to your Favourites, or select Schedule to have it generated and emailed automatically. The Schedule button only appears if your Security Profile allows you to schedule reports. See Scheduled Reports.
Choose the Tax Exemption report options
All the Tax Exemption report options are on the Report Options panel; the report has no More Options section.
The table below lists each Tax Exemption report option, its default and what it controls.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Reservation Staying Between | Date range | Today | Includes reservations staying at least one night in this range. Choose a preset, such as This Month, or a Custom Range. |
| Property | Dropdown | The first property in the list | The property to report on, one at a time. Lists your properties. Shown on multi-property databases only. |
| Tax Exemption Code | Multi-select dropdown | None Selected | The Tax Exemptions to report on, listed by code. None Selected means all of them. See What selecting a Tax Exemption Code changes. |
| Reservation Status | Multi-select dropdown | All Selected | Limits the report to the selected statuses: Arrived, Confirmed, Departed and Unconfirmed. |
| Show Only Tax Exemption Reservations | Checkbox | Off | Lists only reservations that have a Tax Exemption, whichever code it has. |
What the Tax Exemption column headers show
The Tax Exemption report shows the property name, the report name and the From and To dates at the top, then one row for each reservation. The table below lists each Tax Exemption column. Where a value needs more explanation, the Source / Calculation column points to How the Tax Exemption report calculates its figures.
| Column | Description | Source / Calculation |
|---|---|---|
| Area | The Area of the reservation. | The reservation. Blank if no Area is assigned. |
| Res No | The reservation number. | The reservation. |
| Guest Name | The primary guest, as surname, then given name. | The primary guest on the reservation. |
| Arrive | The arrival date. | The reservation. |
| Depart | The departure date. | The reservation. |
| Res Status | The reservation status. | The reservation. |
| Rate Code | The name of the reservation's Rate Type, for example Bed & Breakfast. | The Rate Type on the reservation. |
| Rate Amount | The Rate for the whole stay, including packages and taxes, less any discount. Long Term reservations show 0.00. | See How the Rate Amount is worked out. |
| Nationality | The Nationality of the primary guest. | The Nationality field on the guest profile, not the Country Of Residence. Blank if not set. |
| Tax Exemption Code | The code of the reservation's Tax Exemption. | Shown only when that Tax Exemption is one of the selected codes. See What selecting a Tax Exemption Code changes. |
| Fixed Charge | An X marks a Long Term reservation whose Repeat Charge carries a tax that belongs to the selected Tax Exemptions. | See When Fixed Charge and Auto Charge show an X. |
| Auto Charge | An X marks a reservation that does not have one of the selected codes and whose Rate carries a tax that belongs to the selected Tax Exemptions. | See When Fixed Charge and Auto Charge show an X. |
The Total Count row adds up the Rate Amount of every reservation listed, and counts the reservations with a Tax Exemption Code, with an X under Fixed Charge and with an X under Auto Charge.
How the Tax Exemption report calculates its figures
The following concepts govern which reservations appear on the Tax Exemption report, how its Rate Amount is worked out, and when its Fixed Charge and Auto Charge columns show an X.
Which reservations appear on the Tax Exemption report?
The Tax Exemption report lists the reservations on the selected property that stay at least one night between the From and To dates: they arrive on or before the To date and depart after the From date. A same-day reservation is included only if Include Day Use in Used for Occupancy is ticked in Setup > Property Options > Property Information > Options, or you have set up its Category as Book by Day. Reservations with other statuses, such as Cancelled, are never listed, and neither are group master reservations; each reservation in a group is listed on its own.
If no reservations match the report options, the report shows one row with Res No 0, Arrive and Depart dates of 01 Jan 0001 and a Rate Amount of 0.00. That row means there is nothing to report.
What selecting a Tax Exemption Code changes
Selecting Tax Exemption Codes does not remove any reservations from the Tax Exemption report. It changes two things:
- The Tax Exemption Code column shows a reservation's code only when its Tax Exemption is one of the selected codes.
- The Fixed Charge and Auto Charge columns look only for taxes that belong to the selected Tax Exemptions.
None Selected and All Selected both mean every Tax Exemption. To list only the reservations that have a Tax Exemption, tick Show Only Tax Exemption Reservations.
How the Rate Amount is worked out
Rate Amount is the Rate for the whole stay, from the Arrive date to the Depart date, even when only part of the stay falls in the date range. RMS works it out from the reservation's Rate when you build the report, adding packages and taxes and taking off any discount; it is not read from the charges posted to the reservation account. For example, a three-night stay with a Rate Amount of 1,200.00 shows 1,200.00 whichever of its nights you run the report for.
Long Term reservations show 0.00, because their accommodation is charged through a Repeat Charge rather than a Rate. See Long Term Reservations.
When Fixed Charge and Auto Charge show an X
Both columns look for taxes that belong to the selected Tax Exemptions. A tax belongs to a Tax Exemption when you allocate it on the exemption's Exempt Taxes tab or its Additional Taxes tab in Setup > Accounting > Tax Exemption.
- Auto Charge shows an X when a reservation that is not Long Term, and shows no code in the Tax Exemption Code column, has a Rate that carries one of those taxes. RMS checks the Rate for the whole stay, as it does for Rate Amount. Charges already posted to the reservation account, such as Sundry charges, are not checked.
- Fixed Charge shows an X when a Long Term reservation has an active Repeat Charge whose Sundry carries one of those taxes, whether or not the reservation has a Tax Exemption. See What is a Repeat Charge?
Please Note! Taxes on the Additional Taxes tab count as well as the Exempt Taxes. The Additional Taxes are the taxes a Tax Exemption applies in place of the exempt taxes, so a reservation charged one of them can show an X even though the Tax Exemption does not remove that tax.
Related Reports
- Tax Audit Report - lists each charge or receipt in a date range with the tax applied to it.
- Exclusive Tax Audit Report - exports the charges posted in a date range, with each exclusive tax in its own column.
- GST Assignment Report - shows the Categories and Sundries linked to each tax.
- Repeat Charge Report - lists the current Repeat Charges on reservations and guest accounts.
Related Articles
Comments
0 comments
Please sign in to leave a comment.