Case Study

Leading Spirits Company Saves 10 Hours Weekly with AI-Powered Cash Reporting and Forecasting

Trovata has recently partnered with a leading global spirits provider to streamline their US treasury operations, improve cash data quality, and optimize cash flow. Faced with the labor-intensive challenge of efficiently managing their banking structure and reconciling multiple accounts across different banks, they turned to Trovata.

Headquarters
Guadalajara, Mexico

Founded
1997

Company Size
200-500

Industry
Luxury Goods

~10
hours saved weekly by automating bank reconciliation with Banking APIs and AI for forecasting
Improved Alignment
Trovata improved alignment between the CFO and Treasury by saving time on data aggregation and providing more time for strategic analysis.

Challenges

Manual Workflows Made Analysis a Convoluted Process

Prior to implementing Trovata, the company’s treasury management process was manual, labor-intensive, and time consuming. As the company grew, adding new banks and accounts to their already complex mix, their workflows and reporting became increasingly difficult.

 

With multiple accounts across various banks, they had to log in to each bank individually, update spreadsheets, and categorize transactions manually. This process not only consumed a significant amount of time but also posed challenges in consolidating and reconciling data efficiently.

 

Before Trovata they spent roughly 10 hours a week on data aggregation and reporting. The process entailed categorizing every single transaction, adding them up, and validating the totals.

Solution

Upon implementing Trovata, the company witnessed a transformative change in their treasury management operations:

A Single Source of Truth

All US bank accounts were linked to Trovata, providing a centralized platform for streamlined management. Moreover, Trovata eliminated the hassle of managing user licenses across various accounts and banks. Team members are able to easily log in, enhancing security by providing user credentials only to those who require access to bank information.

f8be2b9a60895db6922a16a801bd642d

Categorization and Tagging

Mirroring existing cash flow report categories, Trovata allowed for instant categorization of receipts and reimbursements thanks to our TQL (Trovata Query Language) functionality. This enabled quick and accurate reporting. TQL makes it easy to set rules to transactions that seamlessly feed into existing tags, automatically categorizing data as it comes in. These tags serve as the foundation for automated reporting and forecasting. Once configured, the platform operates smoothly, requiring a one-time setup for continued efficiency.

90a26dee04783f116a18c21326bc052d

Automated, AI-Powered Cash Forecasting

By utilizing Trovata’s forecasting tools, they are able to harness the power of AI to produce precise forecasts. Trovata’s cash forecasting system offers flexibility, allowing them to select from various AI models. Additionally, it provides the option to oversee the process manually, and enables the incorporation of custom inputs that reflect human-driven business context.

 

By leveraging Trovata’s AI-powered forecasting tools, they have streamlined the process. As forecasts update, they simply check that everything is correctly categorized.

9cee1dbe43fde518ea5238ac4e9139ed

Efficiency Gains

By replacing time-consuming manual tasks with automated processes, they have freed up valuable hours for more strategic analysis and decision-making. With Trovata significantly improving their US operations, they hope to implement the platform in other global territories for even more time savings and efficiencies.

More Time to be a Strategic Partner

With real-time cash visibility, Trovata has also empowered the company’s CFO to spend less time supporting data aggregation, and more time to help steer revenue growth. With a single source of truth, the CFO and finance team are better equipped to align on data management strategies that add value to the business.

b75a4ffbc2ea5bca6673da3fe6d3f63c

Their CFO has regular up to date access to the company’s cash position at any given moment. This enables more time to focus on strategic alignment, defining what kind of analysis the company wants to do, and what reports are needed to be built for it.

Results

  1. ~10 hours saved weekly by automating bank reconciliation with Banking APIs and AI for forecasting
  2. Trovata improved alignment between the CFO and Treasury by saving time on data aggregation and providing more time for strategic analysis.
Book a time to speak with our cash management experts.
Download Case Study as a PDF
close