Calculated Accrual Figures for the Finance Department of a Technology Giant to Provide an Accurate View on Financial Liabilities of the Client

The client is a technology giant and worldwide leader in software, services and solutions. It relies on its partner organizations across the globe to promote, expand and retains its business. The client runs a skills Initiative program to promote sales of their cloud-based products by providing training to customers across the globe through partners. They pays incentives to partners every month based on volume of training activities reported.

Training activities reported by partners go through a series of validation checks before approval for payment. Successfully validated trainings are processed for payment. Partners resubmit unapproved trainings with corrected data in subsequent weeks for the payment. The client’s financial department needs to accrue for unapproved trainings to get an accurate view of actual financial liabilities.

TurnB Approach:

  • Created a single file by consolidating the individual training data reported by all partners in a week to a single file using an algorithm developed in python.
  • Identified net new trainings reported in the file and added these to already submitted trainings through last week to create the master consolidated file.
  • Listed down all the business rules related to incentive calculation such as type of training, course, the country where training is conducted, and special SOWs.
  • Devised an algorithm to calculate payout for reported trainings covering all these business rules.
  • Computed payout for all trainings reported by partners using devised logic.
  • Identified all the paid transactions from client’s internal data and calculated the already paid amount.
  • Estimated accruals by reducing already paid amount from the total computed payout.

Implications:

  • Monthly updated accrual files provided an accurate representation of the actual financial liabilities of client.
  • Partner, Country and Region level views of accruals catered to different stakeholders of client.
  • Accrual figures for scheduled trainings helped the finance team budget and forecast for related activities.