Close
Close

The fast path to reconcile chaotic reports

An alyx™ case study

RFP
Challenge A retailer needed to accelerate 400 hours of report reconciliation In retail, the point of sale is the point of everything. When one retail chain’s point of sale terminals appeared to be reporting incorrect, duplicate and missing transactions, the retailer needed to both resolve the issue and also confirm the resolution. But, with terminals at more than 1,000 locations, the retailer needed to check a sample of at least 50 locations – requiring 400 hours of manual review. The retailer needed confirmation sooner than that.

The retailer needed to quickly gather and reconcile reports from point of sale terminals at more than 50 locations, including more than 480 spreadsheets.

Solution alyx matched workflows and specialists for clear confirmation The retailer asked Grant Thornton to help solve the problem. The Grant Thornton team used the alyx platform to develop a solution that combined the power of automation and the confidence of financial oversight. The team created a client-specific Alteryx workflow that automated data consolidation, then audit specialists ensured the data was accurate and any questions were resolved.

Alteryx
The automated solution soon played a critical role twice over, as some of the terminal reports had to be re-sent and re-processed after a new problem emerged during the initial run. Fortunately, automated processing meant that the project was not delayed.

Results The retailer reconciled the reports 90 faster The Grant Thornton team was able to compress the 400 hours of estimated resolution time to only 40 hours with the alyx solution, a time savings of 90%. The savings meant that the retailer’s locations could resume normal operations with a dependable point of sale – which is really the point.

This project was just one of the solutions that make our clients thankful they can call on the power of alyx:



Contacts:
Jason P. Rogers
Partner, Audit
T +1 404 475 0082

Chip Goodroe
Senior Manager, Audit
T +1 404 704 0117