Use the Exclusive Tax Audit report to export the charges posted in a date range, with the exclusive tax on each charge split into a column for each tax.
Overview
The Exclusive Tax Audit report is a CSV (comma-separated values) export of the charges and credit notes posted in a date range, with the exclusive taxes linked to each charge. Each tax has its own column, so you can see how much of each tax was charged on each charge in the Detailed layout, or for each General Ledger Account Code (GL Acc Code) in the Summary layout.
The report is for Tax Exclusive properties, where taxes are added on top of the rate, such as properties in the United States. Accounts and finance teams run it to check the tax charged in a period, for example before preparing a tax return. Before you run the report, make sure your Security Profile allows Report Screens > Accounting Reports > Exclusive Tax Audit. 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 Exclusive Tax Audit report
The Exclusive Tax Audit report helps accounts teams check exclusive tax in situations like these:
- Monthly tax check - at the start of the month, the accounts team exports the Summary layout for Last Month to see the taxed revenue, the untaxed amount and the total of each tax for every GL Acc Code.
- Tracing a tax figure - when a tax total looks wrong, the accounts team exports the Detailed layout sorted by GL Code to find the charges behind it, with each charge's reservation, Area and transaction number.
- Checking a new tax - after setting up a tax, a manager exports the Detailed layout for a few days and checks that the tax appears on the expected charges.
How to access the Exclusive Tax Audit report
In the side menu of RMS, go to Reports > Accounting > Exclusive Tax Audit.
- Choose the report options. See Choose the Exclusive Tax Audit report options.
- Select Export to CSV.
RMS downloads a CSV file named ExclusiveTaxAudit_ followed by the From and To dates, for example ExclusiveTaxAudit_20261001_20261031.csv.
Open it in a spreadsheet program to read it. The report has no Build button and does not show its results on screen.
Tip! Select Add Report to Favourites Menu to add the Exclusive Tax Audit report to your Favourites, or select Schedule to have the file generated and emailed automatically. The Schedule button only appears if your Security Profile allows you to schedule reports. See Scheduled Reports.
Report Options
The table below lists each Exclusive Tax Audit report option, its default and what it controls.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Transaction Posted Between | Date range | Last Month | Includes charges posted on these dates. Choose a preset, such as Year To Date, or a Custom Range. |
| Property | Multi-select dropdown | All Selected | Limits the file to charges on the selected properties. Shown on multi-property databases only. |
| Report Type | Dropdown | Summary |
The layout of the file. Options:
|
| Sort By | Dropdown | Reservation No |
The row order of the Detailed layout. The Summary layout is always sorted by GL Acc Code. Options:
|
In the Detailed layout, rows with the same reservation, account, GL Acc Code or posting date are listed in transaction number order.
Report Columns
The Exclusive Tax Audit CSV file starts with four lines: the report name and layout (for example Exclusive Tax Audit - Summary), the selected properties, and the From and To dates. Two heading rows follow. The first holds the GL Acc Code of each tax column and is blank above the other columns. The second holds the column names. The file ends with a Total row that adds up every amount column. Amounts of zero are left blank.
The table below lists each Exclusive Tax Audit column, with the layouts it appears in. Where a value needs more explanation, the Source / Calculation column points to How the Exclusive Tax Audit report calculates its figures.
| Column | Description | Source / Calculation |
|---|---|---|
| ResNo | Detailed only. The reservation number, shown with two decimal places, for example 16.00. | The reservation the charge is on. Blank if the charge is not on a reservation. |
| Area | Detailed only. The Area of the reservation. | The Area the reservation has now, not when the charge was posted. Blank if no Area is assigned. |
| PostingDate | Detailed only. The date the charge was posted, for example 28/Jun/2017. | Transaction date of the charge. |
| TransactionDescription | Detailed only. The description of the charge, for example Best Available Rate - (28-Jun-17). | Transaction description. For voided charges, see Which transactions appear. |
| TransNo | Detailed only. The transaction number of the charge. | Transaction number on the account. |
| AccountNo | Detailed only. The number of the account the charge is on. | Account number on the transaction. |
| GLCode | The GL Acc Code of the charge. | See GL Acc Code Hierarchy. |
| GLCodeDescription | The description of the GL Acc Code. Shows Total on the Total row. | GL Acc Code setup. |
| Amount | The charge plus the tax linked to it. | See How a charge is split. |
| Revenue | The charge amount, for charges with tax linked to them. | See How a charge is split. |
| Exempt | The charge amount, for charges with no tax linked to them. | See How a charge is split. |
| One column for each tax | The amount of that tax. The heading is the description of the tax's GL Acc Code, with the GL Acc Code in the row above. | See Which taxes get a column. |
| Total Taxes | The total tax on the row. | The sum of the tax columns on the row. |
How the Exclusive Tax Audit report calculates its figures
The following concepts govern which charges appear on the Exclusive Tax Audit report and how each charge is split between Revenue, Exempt and the tax columns.
Which transactions appear on the Exclusive Tax Audit report?
The Exclusive Tax Audit report includes the charges and credit notes posted on the Transaction Posted Between dates on the selected properties, with the tax posted for each of them. Receipts and refunds are not included.
Voided charges appear twice. The original charge stays on the date it was posted, with Void added to the end of its description. A copy with negative amounts, starting with Void:, appears on the date the charge was voided. When both dates fall in the range, the two rows cancel each other out.
The Exclusive Tax Audit report leaves out these transactions:
- Charges on tour operator, manager and third party accounts.
- Transactions that Owner Accounting and Trust Accounting create automatically, such as Hold Payment, Trust Pool income, and Pay on Arrival or Pay on Departure income.
- Charges posted to the Suspense Charge GL Acc Code.
- Voided expenses on the property's cash account.
- Charges on owner accounts that have no GL Acc Code.
- Charges with an amount of zero.
The Exclusive Tax Audit report's rules for leaving out transactions are based on the Charge Report mode of the Cash/Charge Report but are not identical, so the totals of the two reports can differ.
How a charge is split into Revenue, Exempt and the tax columns
The Exclusive Tax Audit report groups each charge with the tax lines RMS posted for it, then fills in the amount columns as follows:
- Revenue is the charge amount if at least one tax line is linked to the charge.
- Exempt is the charge amount if no tax line is linked to it. A discount with no tax reduces Exempt, so Exempt can be negative.
- Each tax column holds the amount of that tax on the charge.
- Total Taxes is the sum of the tax columns.
- Amount is the charge plus all the tax lines linked to it.
For example, a 1 Bedroom charge of 149.00 with Hospitality Tax of 7.25 and State Tax of 7.83 shows Revenue 149.00, Total Taxes 15.08 and Amount 164.08. A Late Check Out charge of 20.00 with no tax shows 20.00 under Exempt. The Summary layout adds these figures up for each GL Acc Code, so one GL Acc Code can have amounts under both Revenue and Exempt.
Which taxes get a column on the Exclusive Tax Audit report?
The Exclusive Tax Audit report adds one column for each tax that appears on a charge in the file, so the columns change with the dates and properties you select. RMS posts a tax as its own tax line when you set up the tax in Setup > Accounting > Taxes and allocate it to what is charged, for example to a Category or a Sundry. See Set Up Taxes on a Category and Set Up Taxes on a Sundry.
The tax columns are sorted by the GL Acc Code of each tax. Each heading is the description of that GL Acc Code, not the name of the tax, so two taxes that share a GL Acc Code have two columns with the same heading.
Please Note! Exempt means that no tax line is linked to the charge, not that the charge is free of tax. A property's main Goods and Services Tax (GST) or Value Added Tax (VAT), worked out from the divisor in Setup > Accounting > Accounting Options, stays inside the charge amount and has no column. On a Tax Inclusive property that charges only GST or VAT, every charge appears under Exempt and the file has no tax columns.
Related Reports
- Tax Audit Report - lists each charge or receipt in a date range with the tax applied to it.
- Cash/Charge Report - in Charge Report mode, lists the charges raised in a date range by GL Acc Code, with each tax on its own row.
Related Articles
- Taxes - Tax Exclusive - the tax calculation options available to Tax Exclusive properties.
- Set up the tax method - choose whether a property is Tax Inclusive or Tax Exclusive.
- GL Acc Code Hierarchy - how RMS decides which GL Acc Code a charge uses.
Comments
0 comments
Please sign in to leave a comment.