Tax Range Report

Tax Range Report Overview

Parent Hub: 💰 Finance & Accounting Reports

Category: 🏛️ Taxes & Expenses

Target Roles: Directors of Finance & Controllers, Night Auditors, Tax Compliance Officers, General Ledger Accountants

Key Value: Maintain municipal accommodation tax compliance for properties located in Japan by tracking per-person per-night fixed tiered tax brackets, guest headcounts across tax tiers, tax-exempt guest counts, and total municipal tax liabilities.

Executive Summary

The Tax Range Report is a specialized municipal tax compliance and local statutory reporting tool within the 🏛️ Taxes & Expenses category of the 💰 Finance & Accounting Reports suite. Exclusively designed for hotel properties operating in Japan that are subject to local prefectural/municipal Accommodation Tax (宿泊税) regulations (such as Tokyo, Osaka, Kyoto, Fukuoka, and Nagasaki municipalities), it tracks fixed per-person, per-night accommodation tax brackets.

Unlike percentage-based sales or lodging taxes, Japanese municipal accommodation tax rates apply fixed JPY tax tiers based on daily per-person room rates (e.g., ¥100, ¥200, ¥400, ¥500, or higher JPY brackets). By capturing daily guest headcounts (200_yen_people, 400_yen_people, 500_yen_people) alongside generated tax revenues (200_yen_amount, 400_yen_amount, 500_yen_amount), non-taxable low-rate guest headcounts (Under 7000 Yen People), and statutory tax-exempt guest categories (Exemption People Foreign Embassy, Exemption People Students, Exemption People ACOM), this report enables controllers and night auditors to verify municipal tax calculations, prepare monthly local tax returns for municipal ward offices, and audit tax-exempt guest profiles with complete accuracy.

Key Capabilities

• Japan Municipal Tiered Tax Auditing: Tracks per-person daily room rate tiers (e.g., ¥200, ¥400, ¥500) and calculates exact municipal accommodation tax amounts due.

• Non-Taxable Rate Threshold Isolation: Tracks guest counts whose per-person room rates fall below statutory municipal taxation thresholds (e.g., room rates under ¥7,000 or ¥10,000 per night depending on municipal jurisdiction).

• Statutory Tax Exemption Governance: Itemizes guest headcounts qualifying for municipal tax exemptions, including diplomatic/embassy personnel (Exemption People Foreign Embassy), official school/student educational trips (Exemption People Students), and designated commercial/government exemptions (Exemption People ACOM).

Report Views & Functional Breakdown

The Tax Range Report organizes municipal accommodation tax data across three structured operational perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                        TAX RANGE REPORT (JAPAN)                        │
├────────────────────────────────────────────────────────────────────────┤
│                         Daily Summary Ledger                           │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Tiered Tax Revenue &  │ 2. Non-Taxable Rate      │ 3. Statutory Tax  │
│    Headcount Breakdown   │    Threshold Tracking    │    Exemption     │
│                          │                          │    Auditing      │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Tiered Tax Revenue & Headcount Breakdown

Itemizes daily taxable guest headcounts and accrued municipal tax liabilities categorized by statutory JPY tax brackets.

• Primary Use: Verifying daily accommodation tax accruals per tax rate bracket and reconciling gross tax collections against municipal ward filing forms.

• Key Metrics: date, 200_yen_people, 200_yen_amount, 400_yen_people, 400_yen_amount, 500_yen_people, 500_yen_amount, Total People, Total Amount.

2. Non-Taxable Rate Threshold Tracking

Monitors registered guests whose per-person, per-night room rate falls below the statutory threshold required for accommodation tax assessment.

• Primary Use: Auditing low-tier room rate stays (e.g., daily rates under ¥7,000 JPY) to confirm they are correctly excluded from municipal tax assessments.

• Key Metrics: date, Under 7000 Yen People.

3. Statutory Tax Exemption Auditing

Tracks registered guests who qualify for official municipal accommodation tax waivers based on statutory government classifications.

• Primary Use: Reconciling tax exemption certificates, auditing diplomatic and educational group stays, and providing required tax exemption proof to local tax authorities.

• Key Metrics: date, Exemption People Foreign Embassy, Exemption People Students, Exemption People ACOM.

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available in this report:

💡 Japan Accommodation Tax Note: All monetary values (200_yen_amount, 400_yen_amount, 500_yen_amount, Total Amount) represent Gross Fixed JPY Tax Liabilities calculated per taxable guest per night. Tax rates apply based on the net room rate per person per night (excluding meals, consumption tax, and non-room charges).

Customization & Platform Features

User & Property Preferences

• The Tax Range report is a static Custom Data Extract, so it does not support the interactive filtering and customization features available in our dynamic reports.

Advanced Controls

• Exporting: Download in CSV, format to support monthly local prefectural/municipal ward accommodation tax returns.

🔗 Related Reports & Next Steps

Within 🏛️ Taxes & Expenses:

• Active Taxes & Charge Types – Review active property tax definitions, JPY fixed tax range setups, and charge code mappings.

• Tax Summary – Review daily date-by-date gross tax accruals, adjustments, exemptions, and net tax liabilities.

• Tax Report – Audit individual tax-exempt guest reservations, organizational exemption IDs, and diplomatic certificate files.

Cross-Pillar Deep Dives:

• ⚖️ Ledgers & Trial Balance: To verify how municipal accommodation tax liabilities post into general ledger liability accounts during night audit close, review Trial Balance or Day End Summary.

• 💳 Payments & Transactions: To inspect specific line-item room rate postings driving accommodation tax brackets, cross-reference All Transactions or Payment Activity.