The fast path to reconcile chaotic reports
400
Checking reports for a sample of 50 locations required 400 hours.
90%
The team saved 90% of the resolution time, reducing a sample from 400 hours to 40 hours.
1,000
The retailer had 1,000 locations to check and review.
At a glance
Client
U.S. retail chain
Industry
Retail
Our role
Streamline data collection
Our solution
Automated data collection workflow
Quickly collecting and checking sales data
Scenario
Point of sale terminals were reporting wrong transactions, in a chain with 1,000 locations.
Approach
The team created a workflow to automate data consolidation, then audit specialists ensured data accuracy.
Result
The team compressed 400 hours of estimated resolution time to only 40 hours, for a time savings of 90%.
Scenario
Time-consuming data consolidation
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.
Approach
Automated workflow
The retailer asked Grant Thornton to help solve the data consolidation 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 workflow that automated data consolidation, then audit specialists ensured the data was accurate and any questions were resolved.
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.
Result
Time savings and dependability
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.
Related Resources
INDUSTRY
Content disclaimer
This Grant Thornton Advisors LLC content provides information and comments on current issues and developments. It is not a comprehensive analysis of the subject matter covered. It is not, and should not be construed as, accounting, legal, tax, or professional advice provided by Grant Thornton Advisors LLC. All relevant facts and circumstances, including the pertinent authoritative literature, need to be considered to arrive at conclusions that comply with matters addressed in this content.
Grant Thornton Advisors LLC and its subsidiary entities are not licensed CPA firms.
For additional information on topics covered in this content, contact a Grant Thornton Advisors LLC professional.
Ready to talk? We’re ready to listen.
Request a meeting and a member of our team will be in touch to see what we can do to meet your needs.
Want to submit an RFP? Please submit your request through our RFP submission page.
Trending topics
No Results Found. Please search again using different keywords and/or filters.
Follow us
