Workflow Engine and Audit Trail Accelerate Wca's Budgeting Cycle

• 应用基础设施与中间件 - 数据交换与集成
• 应用基础设施与中间件 - 数据库管理和存储
• 平台即服务 (PaaS) - 数据管理平台

• 回收与废物管理

• 商业运营
• 质量保证

• 补货预测
• 过程控制与优化
• 远程资产管理

• 软件设计与工程服务
• 系统集成

WCA, a large U.S. waste management company, faced significant challenges in their budgeting process. The Finance team received budget templates in various formats and styles, requiring manual alterations before consolidation. Management lacked insight into users' workflow status without exchanging emails and phone calls. Additionally, a great deal of manual, time-consuming work was necessary to keep ledgers balanced across the organization's companies. Completing true budget to actuals reporting was difficult because the budget resided outside of WCA's reporting system.

WCA is a large waste management company based in the United States. The company deals with the collection, transportation, processing, and disposal of waste materials. With a significant number of employees and multiple companies under its umbrella, WCA handles a vast amount of data and transactions daily. The Finance team at WCA was responsible for creating, distributing, collecting, and consolidating hundreds of Excel templates for budgeting purposes. This process was highly manual and time-consuming, leading to inefficiencies and potential errors. WCA needed a solution to streamline their budgeting process, improve data accuracy, and provide better visibility into user activities.

Vena provided a comprehensive solution to WCA's budgeting challenges. Vena's ETL processes pull data from WCA's general ledgers on a regular basis and store it in a central, secure data repository. This central repository ensures that the most up-to-date data is available for budgeting purposes. Vena enables managers to design centrally managed budget templates in Excel that contributors and reviewers can access online. Every 'save' to the template automatically commits inputted data to the central repository, eliminating the need for manual data collection and consolidation. The workflow engine allows management to assign specific tasks to contributors, reviewers, and approvers, and quickly filter through templates to view their owner, due date, and workflow status. The audit trail feature date-, time-, and user-stamps every change made to a spreadsheet, providing a clear record of all modifications. Vena also makes it easy for the Finance team to identify intracompany transactions by recording data about expenses and revenues in a template that is eventually mapped to an expense or revenue account in another company's ledger.

• Automatic storage of saved data takes the manual work out of data collection and consolidation, reducing the number of emails being sent across the organization.
• The central database provides the organization with a 'single version of the truth' and keeps WCA's data secure, accessible, and up-to-date.
• The workflow engine keeps everyone on the same page and eliminates the need for managers and reviewers to track user activity through inefficient email exchanges and phone calls.

• Reduced the number of emails being sent across the organization by 50%.
• Decreased the time spent on manual data collection and consolidation by 40%.
• Improved data accuracy by 30% due to the elimination of manual adjustments.