EVERSANA Moves Excel Forecasts to Trovata for Improved Accuracy and Time Savings
CTP, Treasury Manager, EVERSANA
Headquarters
Chicago, IL
Company Size
5000+
Founded
1995
Industry
Pharmaceutical
- Small 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
- Forecast variance reduced to single-digit percentages
- Real-time visibility into global bank accounts
- Variance analysis that used to take hours is now automatic
- Excel-based forecast fully retired in < 4 months
Headquarters
Chicago, IL
Company Size
5000+
Founded
1995
Industry
Pharmaceutical
The Challenges of Excel Forecasting
Like many finance teams, EVERSANA started with a manual, Excel-based forecast. Treasury Manager Tim Green remembers entering transaction data by hand every day, relying on bank statement downloads, and using Power Query for light automation.
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
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.”
CTP, Treasury Manager, EVERSANA
The Result: Greater Visibility, Flexibility, and Control
- No longer limited to the header ZBA, the team could now see activity at the sub-account level
- And 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.
CTP, Treasury Manager, EVERSANA
Click-to-Insight Capabilities
CTP, Treasury Manager, EVERSANA
How EVERSANA Calculated ROI
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.
CTP, Treasury Manager, EVERSANA
Ready to Say Goodbye to Excel Forecasts?
