Case Study
Video: How EVERSANA Retired Excel Forecasts with Trovata
We’ve seen far better accuracy in our cash forecast—and significantly reduced the time we spend manually reporting data to leadership.”
Tim Green
EVERSANA CTP, Treasury Manager
Headquarters
Chicago, IL
Founded
1995
Company Size
5000+
Industry
Pharmaceutical
Who Should Watch This?
- Small to mid-sized treasury teams that want to migrate forecasts out of Excel
- Finance pros looking to tighten cash forecast accuracy and automate variance reporting
- Finance executives who want to be able to slice and dice their forecasts and gain answers to questions in seconds, not hours
The Transformation at a Glance
- Forecast variance reduced to single-digit percentages
- Real-time visibility into global bank accounts
- Variance analysis that once took hours to complete is now automatic
- Excel-based forecast fully retired in < 4 months
The Challenges of Excel Forecasting
Like many finance teams, EVERSANA started with a manual, Excel-based forecast. In the webinar, “Forecast with Confidence, How EVERSANA Built a Global Source of Truth with Trovata,” Treasury Manager Tim Green remembers entering transaction data by hand every day, relying on bank statement downloads, and using Power Query for light automation.
We were only looking at the header account of our cash concentration structure… we had very little visibility into transactional-level detail.”
Tim Green
CTP, Treasury Manager, EVERSANA
The Excel file became massive—just opening it could take 20 minutes. Tim admitted he was the only person who used it. And the limitations didn’t stop there: the team could only forecast domestic accounts, categorizing cash activity in broad strokes that lacked the granularity needed for actionable insights.
Most importantly, their Excel-based model was not scalable. With growing complexity and increasing data volume, it became clear that the team needed a more robust and collaborative solution.
That’s when Tim started looking for a more scalable solution—and found Trovata.
How EVERSANA Built Their Forecast in Trovata
Implementing Trovata gave EVERSANA access to all their banking data—domestic and international—and the flexibility to tag transactions based on any bank-supplied data point: BAI codes, amounts, remittance fields, debit/credit indicators, and more.
Using Trovata’s tagging engine, Tim and his team built precise categories: payroll, vendor payments, customer receipts, benefits disbursements—each tracked with a higher level of detail than was ever possible in Excel.
Eversana’s setup began with:
Transaction Tags: to group inflows/outflows by category
Data Streams: individual forecast line items (e.g. payroll, HSA, benefits)
Repeat History Model: applied to real bank data to forecast the next 3+ months
Manual Adjustments: added easily for one-offs like bonuses or M&A flows
We created data streams for each major transaction type and rolled them up by entity—then grouped forecasts regionally, like all our EU entities together, for better visibility.”
Tim Green
CTP, Treasury Manager, EVERSANA
The result was a flexible, modular forecast structure that could be sliced by entity, region, or transaction type.
Implementation Timeline
Months 1-2: Set up tags, data streams, and forecasts
Months 3-4: Ran Trovata forecasts in parallel with Excel
After Month 4: 100% of forecasting completed in Trovata
“After four months, we retired our Excel cash forecast. I haven’t opened it since.”
Tim Green
CTP, Treasury Manager, EVERSANA
The Result: Greater Visibility, Flexibility, and Control
Once EVERSANA transitioned to Trovata, their forecasting workflow experienced a significant upgrade, not just in speed, but in depth and reliability. Just as importantly, they were able to unlock full visibility into every layer of their banking structure:
No longer limited to the header ZBA, the team could now see activity at the sub-account level
For the first time, global account data was integrated into the same system—ensuring a comprehensive, enterprise-wide view of cash
This holistic access to real-time data, combined with automation and customizable forecasting tools, gave EVERSANA the control and insight they needed to scale their cash forecasting with confidence.
Trovata now fuels EVERSANA’s daily reporting to senior leadership:
Current-day and prior-day cash activity
MTD performance
Trends vs. forecast
Top Cash Forecasting Improvements
More Granular Forecasting
Previously, transactions were grouped into broad categories due to limited visibility. With Trovata, the team can now break down cash activity by customer, vendor, or tag, enabling more precise forecasting. This shift away from “giant buckets” of data has made their forecasts far more accurate and useful for decision-making.
Instant Variance Analysis
What once took 1–5 hours each month to calculate manually in Excel is now available instantly. Trovata automatically compares forecasted values against actuals and calculates variance percentages, allowing the treasury team to identify gaps and respond quickly.
“We've been able to get our forecast variance down to a single digit percentage for our cash flow, which is significantly better than what we had when we were using our historical Excel based forecast.”
Tim Green CTP, Treasury Manager, EVERSANA
Click-to-Insight Capabilities
Instead of digging through spreadsheets or outdated bank statements, EVERSANA’s team can now click directly into a tagged data stream and view the underlying transactions immediately. This instant drill-down capability saves time and makes variance explanations far more efficient.
“Since implementing Trovata, we've seen far better accuracy in our cash forecast. We've gained visibility into all of our accounts globally that we didn't have before, and we've significantly reduced the time we spend manually reporting data to our senior leadership.”
Tim Green CTP, Treasury Manager, EVERSANA
How EVERSANA Calculated the ROI of Switching
Modern forecasting isn’t just about making projections. It’s about driving measurable value for your business. Tim shared that Trovata has provided significant value in two key areas: time saved and cash optimization.
Time Saved: Automating Manual Workflows
Trovata helps Tim reduce the time spent on:
Manual variance analysis
Creating and updating forecasts
Preparing reports for leadership
What once took hours each month is now done in seconds through automation and real-time data feeds. EVERSANA also scaled its international forecasting efforts much faster than would have been possible in Excel, saving weeks of effort across teams.
Cash Optimization: Putting Idle Capital to Work
In today’s rate environment, visibility into daily cash positions is critical. With Trovata, EVERSANA can now:
Identify trapped cash across global accounts
Reallocate funds into interest-earning vehicles
Pay down short-term debt more strategically
These decisions can translate into meaningful financial gains—often enough to justify the investment in Trovata several times over.
“Making sure you’re using that cash as optimally as possible, whether that’s investing in a money market fund or paying down debt, can deliver huge returns.”
Tim Green CTP, Treasury Manager, EVERSANA
Ready to Say Goodbye to Excel Forecasts?
Book a time to speak with our cash management experts.
Recommended for you
Book Trovata Demo