QSR eligibility checks use outdated subscription version, causing inaccurate skip reasons
Problem
When determining skip reasons for Reconciliations, the system appears to be using an older version of the subscription for eligibility checks rather than the latest version. This results in inaccurate skip_reason values being recorded.
Example
This subscription has Turn On Seat Reconciliation = No on its latest version, so the expected skip reason would be reconciliations_disabled. However, the reconciliation was skipped with reason multiyear_subscription instead.
All reconciliations with multiyear_subscription skip reason.
Impact
- Skip reason data is inaccurate, making it difficult to analyze why reconciliations are being skipped
- Reporting and debugging efforts are affected by misleading skip reasons
Scale of impact
Analysis of reconciliations skipped with multiyear_subscription in October–November 2025 shows the majority of these subscriptions actually have QSR disabled (Turn On Seat Reconciliation = No):
This suggests the eligibility checks are evaluating an outdated subscription version where the QSR toggle may have had a different value.
Proposal
Update the QSR eligibility check logic to use the latest version of the subscription when determining the skip reason, ensuring the recorded reason accurately reflects the current subscription state at the time of the reconciliation.
Relevant code area: