The Treasury team relied on Microsoft Excel for cash flow planning, forecasting, and reporting, which required extensive manual effort to consolidate and reconcile data across various systems. With each new data update, like the addition of customers, significant time was spent adjusting the Excel model to accommodate these changes. The team aimed to reduce the time spent on data collection and model adjustments, allowing them to focus more on analysis and reporting for better cash flow insights.

Keyrus assisted with designing, developing, and deploying an automated 13-week cash forecasting model in Anaplan. The model includes a detailed projection of expected cash receipts and disbursements from operating activities, cash from investing and financing, and bank balances. An automated process was developed to automate source data loads and calculate strategic cash flow metrics. The model was configured for users to drill down from summarized reports to source transactional data. Treasury, Finance and Accounting can quickly conduct scenario modeling for instant insights and improved decision making.