← All insights
Case study

Momentum: Rewards partner reconciliation in minutes, not 80 hours

From an 80-hour monthly manual reconciliation to about 20 minutes, with the month-end close cut from 5 days to 3.

20 minutes

a month for the reconciliation, down from 80 hours (1 minute per workflow created)

3 days

for the month-end close, down from 5 days

Client
Momentum
Practice area
Finance Transformation
Function
  • Finance Operations
  • Reconciliation
  • Month-end close
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
  • Alteryx
  • SQL Server
  • Excel

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.

Key takeaways

A manual 80-hour monthly reconciliation now runs in about 20 minutes.

Month-end close dropped from 5 days to 3.

The finance team now spends its time on exceptions, not on matching files.

Finance Transformation

Talk to us about your Finance Transformation

Want business-led automation and AI solutions for your team?

60-minute session. Bring a process, we'll show you how we'd fix it.