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
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.
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.
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.
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.
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
- ~10 hours saved weekly by automating bank reconciliation with Banking APIs and AI for forecasting
- Trovata improved alignment between the CFO and Treasury by saving time on data aggregation and providing more time for strategic analysis.