下载PDF
实例探究 > Elimination of Manual Processes Makes Reporting to the SEC Significantly Smoother

Elimination of Manual Processes Makes Reporting to the SEC Significantly Smoother

技术
  • 分析与建模 - 预测分析
  • 应用基础设施与中间件 - 数据交换与集成
  • 功能应用 - 企业资源规划系统 (ERP)
适用行业
  • 金融与保险
适用功能
  • 商业运营
  • 质量保证
用例
  • 过程控制与优化
  • 监管合规监控
  • 远程协作
服务
  • 软件设计与工程服务
  • 系统集成
挑战
The bank faced several challenges in their reporting process, primarily due to the manual creation, distribution, and consolidation of Excel templates. These templates were sent via email to multiple business groups for data collection, leading to issues with version control and the potential loss of important information. The daily exchange of dozens of emails made it difficult to track the status of each task without constant communication through emails and phone calls with contributors, approvers, and reviewers. Additionally, the lack of a formal workflow and audit trail made it challenging to determine where changes had been made to spreadsheets without manually comparing versions or waiting for user responses.
关于客户
The customer is a large bank based in the United States, responsible for managing footnote disclosure for their 10Q and 10K filings to the U.S. Securities and Exchange Commission (SEC). The bank's finance team was heavily reliant on manually creating, distributing, collecting, and consolidating Excel templates from multiple business groups. This process was not only time-consuming but also prone to errors, leading to issues with version control and email overload. The bank needed a more efficient and reliable solution to streamline their reporting process and ensure the accuracy of their reports to the SEC.
解决方案
Vena provided a comprehensive solution to the bank's challenges by combining the flexibility and familiarity of Microsoft Excel with the structure and security of an enterprise-class Corporate Performance Management (CPM) solution. Vena's central data repository stored all of the bank's most up-to-date spreadsheets, templates, business drivers, assumptions, and more. This ensured that any changes made to the data in the repository were automatically reflected in the templates and formulas. The implementation of formal workflow processes allowed managers to assign tasks and deadlines to specific users and instantly view the status of all tasks in the process. Automatically generated templates were sent to both managers and users when a user missed their deadline or when a task was completed and ready for review and approval. Managers had instant access to consolidated data and individual group submissions, and a detailed audit trail provided date-, time-, and user-stamped activity, enabling users to roll back to previous spreadsheet versions to analyze differences over any time period.
运营影响
  • The finance team no longer had to manually collect and consolidate data, saving time and eliminating issues with email overload and version control.
  • Formal workflow processes helped move projects along by sending automatically generated emails to managers when submitted templates were available for review.
  • Managers could see with one click which user had started their task, who had finished, who had yet to start, and who had been rejected from contributing, allowing them to instantly identify and correct bottlenecks.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.