- Client
- Momentum
- Practice area
- Finance Transformation
- Function
- The problem in one line
- Reconciling partner Rewards files to company files was manual, slow and error-prone, leaving little time to chase exceptions.
- The outcome in one line
- The process now takes about 20 minutes a month instead of 80 hours, and the month-end close is two days shorter.
- Technologies used
Background
The Finance Operations Manager at MMI had to reconcile MMI's partner Rewards files with MMI files. MMI asked Dimago, an analytics, data science and process automation consultancy that works on the Alteryx platform, for help.
A set of Alteryx workflows was built to produce reports that give insight into the reconciliation.
The Challenge
Reconciling the partner Rewards files and MMI files was time-consuming and complex. The process was manual with many steps. Because it took so long, the Finance Operations Manager could not focus on investigating and fixing exceptions.
- Manual process with multiple steps.
- Higher risk of errors, and difficulty ensuring data accuracy.
- Too little time left to investigate and fix highlighted exceptions.
The Solution
Dimago pulled the partner data and the MMI data from a SQL Server into Alteryx. The datasets were combined in a workflow and written to Excel files. The Excel files were read into several Alteryx workflows of three types:
- Reconciliations of partner data to MMI data.
- Building journals from customer and partner data.
- Invoice calculations.
These workflows produce Excel reports. The solution used mainly Alteryx's In-Database, filter, summarize and formula tools.
A proof of value (POV) was run on 16 May 2022 and finished within an hour. A workflow was built in 30 minutes using no-code software, with no developer (IT) help.
Next step: Alteryx Server, so the workflows can run on a schedule or ad hoc through an easy-to-use app interface.
The Impact
The first phase was completed within one month, with these savings:
- Rand 3 million, MDS commission
- Rand 2.8 million, cashbacks
Other results:
- Partner/supplier reconciliation takes 3 minutes to run, a 98% time saving.
- Month-end close reduced from 5 days to 3 days.
- Time for the process reduced from 80 hours per month to 20 minutes (1 minute per workflow created).
- More time to investigate and confirm or fix exceptions, so Rewards partners' information is correct on the MMI side before it goes to members.