Tax Range Report
Tax Range Report
Report Description: The Tax Range Report provides a detailed daily breakdown of tax calculations and guest counts categorised by specific currency amount brackets and exemption types. This report is essential for finance and tax compliance teams to monitor daily tax liability and ensure accurate reconciliation. By including specialised metrics like the ACOM Exemption count, the report offers granular visibility into tax-exempt transactions, streamlining the audit and filing process for properties in regulated tax jurisdictions.
Date Range: This report can render data for a user-defined period, typically used for daily, monthly, or quarterly tax reconciliation.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
DATE | The specific business date for the recorded tax activity | Not Applicable | Not Applicable |
100 YEN AMOUNT | Total tax collected for transactions in the 100 Yen bracket | NO | =sum(tax amount) |
100 YEN PEOPLE | Total count of guests qualifying for the 100 Yen tax bracket | Not Applicable | Not Applicable |
200 YEN AMOUNT | Total tax collected for transactions in the 200 Yen bracket | NO | =sum(tax amount) |
200 YEN PEOPLE | Total count of guests qualifying for the 200 Yen tax bracket | Not Applicable | Not Applicable |
300 YEN AMOUNT | Total tax collected for transactions in the 300 Yen bracket | NO | =sum(tax amount) |
300 YEN PEOPLE | Total count of guests qualifying for the 300 Yen tax bracket | Not Applicable | Not Applicable |
400 YEN AMOUNT | Total tax collected for transactions in the 400 Yen bracket | NO | =sum(tax amount) |
400 YEN PEOPLE | Total count of guests qualifying for the 400 Yen tax bracket | Not Applicable | Not Applicable |
500 YEN AMOUNT | Total tax collected for transactions in the 500 Yen bracket | NO | =sum(tax amount) |
500 YEN PEOPLE | Total count of guests qualifying for the 500 Yen tax bracket | Not Applicable | Not Applicable |
TOTAL AMOUNT | Cumulative total tax amount collected across all brackets | NO | =sum(all tax amounts) |
TOTAL PEOPLE | Cumulative total count of guests across all tax brackets | Not Applicable | =sum(all people) |
UNDER 7000 YEN PEOPLE | Count of guests whose room rate is below the 7000 Yen taxable threshold | Not Applicable | Not Applicable |
EXEMPTION PEOPLE FOR | Count of guests exempt from tax under Foreign/Embassy rules | Not Applicable | Not Applicable |
EXEMPTION PEOPLE ST | Count of guests exempt under standard stay rules | Not Applicable | Not Applicable |
EXEMPTION PEOPLE ACOM | Count of guests/orders where the tax exemption code is specifically set to ACOM | Not Applicable | Not Applicable |
Misc Report Information:
Available Features:
Run: Ability to execute and view the report on-screen for the selected date range.
Export: Ability to download and save the data extract into an external format (e.g., XLSX) for further analysis.
Verification: Allows finance users to cross-reference daily ACOM exempt counts against individual transaction records.
Available Configuration:
User Preferences: Allows the user to customise their report view by repositioning or removing columns.
Property Preferences: Allows the property to customise the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment: None