Skip to main content
Submit a Ticket

How can we help?

Tax Audit Report

The Tax Audit Report provides a line-by-line breakdown of every charge or receipt transaction in RMS with its associated tax calculation, making it the primary tool for auditing TAX, VAT or GST activity for a selected date range.

 

Overview

The Tax Audit Report is an accounting report in RMS that lists every transaction posted within a chosen date range alongside the tax applied to that transaction. It is used to reconcile tax liability, support external tax submissions, and verify the setup of Tax Methods against actual posted transactions.

The report title displayed on the output reflects the selected basis:

  • Tax Audit Report - Accrual - generated when Charge is selected, showing tax on charges posted in the date range regardless of payment status.
  • Tax Audit Report - Cash - generated when Cash is selected, showing tax on receipts (payments) received in the date range.

Depending on the property's region, the tax column heading may appear as TAX, VAT or GST. The report structure and functionality are the same in all cases.

The report can be built to screen, exported to CSV, or scheduled to email automatically using the Scheduled Reports functionality.

✎ Please Note: RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.

 

 

Guide

In the side menu of RMS, go to Reports > Accounting > Tax Audit Report.

  1. Select the Transactions Between date range.
  2. Select Charge to report on an accrual basis or Cash to report on a cash (receipts) basis.
  3. Select a Group By option to group the output by a chosen field (see Group By Options below).
  4. Select a Sort By option to control the order of rows within each group (see Sort By Options below).
  5. Select Build to generate the report, or Export To CSV to download it directly as a CSV file.

     

 

★ Tip: Select the Star favourite icon on an report favourite icon to mark this Report as a Favourite Report for quick access via the Favourite Reports Menu.

 

 

Group By Options

Groups results into subtotalled sections on the output:

Option Result
No Grouping All transactions listed as a single continuous table with one Grand Total.
GL Code Transactions grouped by the General Ledger Account Code assigned to the transaction.
Area Grouping & GL Code Transactions grouped first by Area grouping and then by GL Code within each group.
Category Transactions grouped by the Category the reservation is assigned to.
Tax Divisor Transactions grouped by the tax rate applied (useful for separating tax brackets such as 10%, 15%, or zero rated).

 

Sort By Options

Controls the order of rows within each group:

  • Transaction Date
  • Guest Name
  • Area
  • Account No
  • Reservation No
  • Arrive Date

 

More Options

Select More Options on the criteria screen to reveal additional filters. The button label changes to Less Options when expanded.

Screenshot of the Tax Audit Report criteria screen with More Options expanded showing Category, Category Attributes, Account Code, and the Group By Property, New Page Per Property, and Exclude Brand Alliance Property checkboxes.

 

Option Purpose
Category Limit the report to one or more selected Categories. Defaults to All Selected.
Category Attributes Limit the report to reservations with specific Category Attributes. Defaults to All Selected.
Account Code Limit the report to one or more General Ledger Account Codes. Defaults to All Selected.
Group By Property Enterprise only. Adds a property-level grouping layer above the selected Group By option.
New Page Per Property Enterprise only. Starts a new page in the report output for each property when Group By Property is enabled.
Exclude Brand Alliance Property Enterprise only. Excludes properties flagged as Brand Alliance properties from the report output.

 

Report Output

The generated report shows one row per transaction with the tax calculation split across the Full Tax and Concessional column groups. A Grand Total row appears at the bottom, along with any subtotals introduced by the selected Group By option.

Screenshot of the Tax Audit Report - Accrual output in RMS showing columns Acc No, Tax Inv, Res No, Area, Guest Name, Rec Date, Description, Total Charge, Total Tax, Tax Exclusive, Tax Free Charge, Full Tax (Charge, Tax, Tax Divisor), and Concessional (Charge, Tax).

 

Column Descriptions

Column Details
Acc No The Account Number the transaction was posted to.
Tax Inv The Tax Invoice number the transaction has been included on. Shows 0 when the transaction has not yet been invoiced.
Res No The Reservation Number associated with the account the transaction was posted to.
Area The Area the reservation is assigned to.
Guest Name The name of the Guest on the reservation or account.
Rec Date The receipt/record date of the transaction. For Accrual reports this is the posting date; for Cash reports this is the receipt date.
Description The transaction description, including the original charge and the rate or sundry applied. Voids appear as separate lines (original charge and reversing void line).
Total Charge The total gross value of the transaction, inclusive of tax.
Total Tax The total tax component of the transaction (sum of Full Tax and Concessional tax).
Tax Exclusive The value of the transaction excluding tax (Total Charge less Total Tax).
Tax Free Charge The portion of the Total Charge that is not subject to tax.
Full Tax: Charge The portion of the charge subject to the full (standard) tax rate.
Full Tax: Tax The tax amount calculated on the Full Tax charge.
Full Tax: Tax Divisor The effective tax rate applied to the transaction, expressed as a percentage.
Concessional: Charge The portion of the charge subject to a concessional (reduced) tax rate.
Concessional: Tax The tax amount calculated on the Concessional charge.

 

 

 

Related to:

Was this article helpful?

We're sorry to hear this article was not helpful, please let us know why here, so we can make it better.

Thanks for the positive feedback! We'd love to hear more, let us know here.

Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.

Contact us