GST Reports Incorrectly Include Void or Cancelled Orders in Tax Due Calculations

Environment

• Environment: Production

• Module: GST Reporting / Tax Reporting

• Affected Components:

  • UI Reporting

  • Backend Tax Calculation Logic

  • Exported GST Reports

  • Potential API reporting endpoints [clarify endpoint]

Problem Statement

GST reports currently include orders with a status of Void or Cancelled when calculating GST tax totals. These orders should not contribute to tax liability because they were never completed transactions.

This results in inflated GST totals and inaccurate tax reporting.

Preconditions

• GST taxation is enabled.

• Orders exist with statuses:

  • Void

  • Cancelled

• GST reports are generated for a date range containing these orders.

Steps to Reproduce

1. Create or locate an order with GST applied.

2. Change the order status to Void or Cancelled.

3. Generate a GST report covering the transaction date.

4. Review the GST totals and included transactions.

Expected Result

• Void and cancelled orders should be excluded from:

  • GST tax due calculations

  • GST report totals

  • GST export files

• Only completed/valid billable transactions should appear in GST reporting.

Actual Result

• Void and cancelled orders are included in GST reports.

• GST totals include taxes from non-billable transactions.

Business Impact

• Produces inaccurate GST filings and financial reports.

• Creates reconciliation discrepancies between accounting systems and Pelcro reports.

• Increases manual accounting adjustments for finance teams.

• Potential compliance and audit risk for clients using GST reporting for tax submissions.

Severity / Priority

• Severity: High

• Priority: High

Reason:
This affects financial accuracy and tax compliance reporting.

Suspected Root Cause

The GST reporting query or aggregation logic may not exclude invalid order statuses before calculating tax totals.

Possible missing filters:

• status != void

• status != cancelled

Recommended Fix

Update GST reporting logic to:

• Exclude voided orders

• Exclude cancelled orders

• Ensure tax aggregation only includes finalized/collectible transactions

Review affected areas:

• Reporting API endpoints

• Export generation services

• Dashboard summaries

• Tax aggregation jobs

Definition of Done (DoD)

• Void orders no longer appear in GST reports.

• Cancelled orders no longer appear in GST reports.

• GST totals match finalized transactions only.

• API responses reflect corrected totals.

• Existing exports generate accurate tax values.

• Regression testing completed for:

  • Refunded orders

  • Partial refunds

  • Failed payments

  • Completed orders

• Automated test coverage added for excluded statuses.

Additional Notes

• Verify whether this issue affects:

  • Historical reports

  • Scheduled exports

  • Third-party accounting integrations

  • Other tax report types beyond GST (VAT/HST/etc.)