Feature: Settlement-Based Room Posting Exclusion in GST India Report

1. Objective:

To enhance the GST India Report by enabling accurate exclusion of Room Posting transactions based on Settlement Method, ensuring correct GST reporting and eliminating reconciliation differences between POS and PMS systems used in hotel operations.

2. Functional Requirements:

2.1 GST India Report Enhancement

Provide improved logic for the “Exclude Room Posting” option available in the GST India report.

The exclusion mechanism should evaluate transactions based on Settlement Payment Method instead of only relying on Order Type.

2.2 Settlement-Based Exclusion Logic

When Exclude Room Posting option is enabled:

• System must exclude all transactions where
  Settlement Payment Method = Room Posting

• Exclusion should apply irrespective of:

  • Order Type (Dine-In / Takeaway / Room Service / Others)

  • Billing source

  • Posting workflow

2.3 Real-Time Operational Compatibility

System should support common hotel workflows where:

• Orders are initially created under Dine-In.

• Guests request settlement during checkout.

• Bills are transferred using Room Posting settlement.

Such transactions must automatically be excluded from GST India report when exclusion is selected.

2.4 Data Validation

System should:

• Identify Room Posting transactions using settlement records.

• Ensure excluded transactions remain traceable for audit purposes.

• Maintain consistency with Settlement Detail Report filtering logic.

3. Reporting Requirements

Enhanced GST India Report should:

• Generate GST data excluding all room-posted settlements accurately.

• Maintain visibility of excluded transactions through reference reporting.

• Ensure alignment between:

  • POS GST Report

  • PMS Billing & GST computation

Export options should continue to support:

• Excel

4. Operational Benefits

Implementation of settlement-based exclusion will provide:

• Accurate GST liability calculation

• Elimination of duplicate taxation between POS and PMS

• Reduced manual reconciliation effort

• Faster month-end GST filing

• Improved report reliability for hotel users

• Reduction in customer support dependency

5. User Roles Impacted

Accounts / Finance Team

• Reliable GST data extraction

• Simplified statutory filing

Restaurant Operations

• No change in billing workflow required

Management

• Improved financial accuracy across systems

0 Votos