Financial Services

Finance

Risk & Compliance

Advanced Analytics

Data Quality

LeavePlus Logo

 

3 min read | Posted Aug-2026 | Geoff Morgan

At a Glance

Client: LeavePlus, administrator of Victoria’s Portable Long Service Leave Scheme for the construction industry

Challenge: Validating variances found between two interest calculation models for Working Subcontractor member accounts

Approach: An independent Power BI validation model, benchmarked against LeavePlus’s own remediation model, to test accuracy and pinpoint data quality issues

Outcome: Assurance on the accuracy of member balances, evidence for leadership to proceed with treatment plans, and a broader data quality initiative born from the findings

About LeavePlus

LeavePlus is a Victorian company that administers the Portable Long Service Leave Scheme for the construction industry. Through the scheme, all members of the construction industry which includes employers, and all types of workers must register with LeavePlus.

The Challenge

LeavePlus conducted a review of the interest rate calculations for working subcontractors’ (WSC) member accounts. The review prompted LeavePlus to conduct a parallel run of the production and a “production-like” interest calculation model which resulted to potential issues with the application of interest rates as shown by variances between the two models.

Potential causes of variances are known to LeavePlus but are not appropriately understood. As part of the member balance remediation activities, validating the root cause of the variance is needed to determine the extent of the treatment plan required.  Doing this will provide assurance to LeavePlus that member balances are moving as expected and that appropriate treatment plans are laid out for those that have underlying data quality issues.

The Approach

To get a clear path to remediation, validation of account movements was conducted through an interest remediation validation model that helped validate accuracy of interest calculations as well as identify potential underlying data quality issues. This approach provided an understanding of their root cause along with the appropriate treatment plans. The overall strategy was as follows:

  • Created new “Validation Model” using Power BI, that replicates LeavePlus business rules for interest calculations.
  • Compared outputs of Revenite’s “Validation Model” to LeavePlus’s remediation model, both built using production WSC data, with updated business rules and interest rates.
  • Categorised WSC member records according to known process or data issues. Defined tolerance thresholds to determine priority of WSC member records to analyse and investigate.
  • Performed WSC member analysis for member records that are outside of tolerance threshold.

The Outcome

Revenite’s Validation Model alongside the outcomes of the member analysis process provided LeavePlus with confidence and assurance on the accuracy and validity of the interest calculations implemented in their Remediation Model. With minimal issues identified in LeavePlus’s Remediation model, it provided the leadership team the supporting evidence to go as planned with the intended treatment plans across member records needing remediation.

In addition, Revenite’s Validation Model has highlighted new and unknown data quality issues which prompted LeavePlus’s Data team to venture into a broader Data Quality initiative, with Revenite providing the required guidance and support during planning and execution phases.

Contact us today to arrange a consultation

Get in touch

Contact

Are you ready to future-proof your analytics?