Case Study: Spreadsheet Automation for Multi-Currency Revenue Reporting
Every two weeks, Natalie (Name has been changed for privacy reasons), APAC Director of a global consultancy firm, spent two hours after work preparing for a 30-minute regional performance review meeting with headquarters. The task itself wasn’t difficult, but it was repetitive, time-consuming, and prone to human error.
With projects billed in USD, EUR, AUD, and SGD, preparing a consolidated revenue report required multiple rounds of currency conversion and validation. Her process involved an Excel workbook with 13 tabs—one for every month and a dedicated “calculations” tab. She spent hours manually grouping rows by currency, retrieving current exchange rates, and verifying calculations to ensure the C-suite received accurate data presented in 3 different currencies.
The Challenge:
- Grouping projects by currency.
- Calculating subtotals for each.
- Manually fetching exchange rates and performing conversions.
- Summing grand totals.
- Re-converting those totals into three different currencies.
- Performing a manual audit to ensure no errors. A step often fraught with the anxiety of “did I miss a row?” or “is this calculation correct?”
Because the figures were used for management reporting, mistakes were not an option. A single omitted row or incorrect conversion could affect the final numbers and create unnecessary rework. When an error occurred, the “error carried forward” meant it was often faster to redo the entire report than to audit the spreadsheet.
The Solution: Optimized, Not Overhauled
When Natalie shared her workflow with us, she had one clear requirement: “I want to minimise manual involvement, but not eliminate it entirely. And if possible, I want as little change to the format and structure as possible.“
Instead of redesigning the entire spreadsheet, we enhanced the existing workbook. We transformed a six-step process that took 120 minutes into a simple three-step workflow that takes just 10 minutes:
- Input: Update the real-time exchange rates in a simple “Currency Exchange” table.
- Automate: We implemented logic-based formulas. In simple terms, we instructed Excel to include only rows matching a specific currency when calculating totals.
- Verify: A final, quick sanity check.
By automating the categorization and conversion, we removed the risk of human error in the math while keeping Natalie in the driver’s seat. The only manual step remaining was updating the latest exchange rates before each reporting cycle. Reporting also became more consistent because calculations now follow the same logic every time, regardless of who updates the spreadsheet.
With automation, Natalie saves nearly 48 hours annually. That’s more than a full work week every year.
In addition, the solution was designed to scale.
New projects can be added without modifying formulas, and additional currencies can be introduced simply by updating the exchange rate table.
The Impact of Our Solution
| Feature | Before (Manual Process) | After (Optimized Process) |
| Time Investment | 120 Minutes | 10 Minutes |
| Calculation Method | Manual grouping & cell-by-cell conversion | Automated logic-based formulas |
| Risk of Human Error | High (manual formulas/omissions) | Minimal (automated validation) |
| Data Scalability | Rigid (prone to breaking) | Flexible (scales with new data) |
| Primary Outcome | Time spent on reporting | Time spent with family |
Why We Didn’t Fully Automate It
Some readers may wonder why we didn’t completely automate exchange rate retrieval and reporting.
The answer comes down to business preference.
Natalie wanted to remain involved in the process and maintain visibility over the figures being presented.
By keeping a small amount of manual interaction, she retained confidence in the reporting process while still eliminating the majority of repetitive work.
The result was a balanced solution: significantly faster reporting, reduced risk of human error, and continued human oversight where it mattered most.
Outcome Summary
- Reporting preparation reduced from 2 hours to 10 minutes
- More than 47 hours saved annually
- Lower risk of calculation errors
- Automatic handling of new projects
- Scalable for additional currencies
- Minimal disruption to existing workflows
Today, those 110 minutes saved are no longer spent in Excel. They’re spent helping her children with homework, watching a movie on Disney Plus, and reclaiming her work-life balance.
Sometimes the best automation isn’t about replacing people.
It’s about giving them their time back.
Do you also have a repetitive task that consumes hours every week?
We help businesses identify manual processes that can be streamlined with practical, cost-effective automation.
Contact us for a no-obligation discussion.