Background Notes:
In 2009, Lixin joined BDO International, the world's fifth-largest international accounting network, which uses a uniform audit approach across its member firms globally, fully complying with the principles of International Standards on Auditing (ISAs) while also providing additional guidance as required by the different regions to ensure a consistent level of service across the globe. Today, Lixin's audit processes and records are electronic. However, audit work is not static, and BDO's audit tools need to be continuously optimized and upgraded in order to provide clients with the best possible consulting services. Based on the continuous expansion of BDO's audit methods, tools and guidelines, Lixin has launched the industry's first intelligent audit cloud platform based entirely on cloud technology, which is used to unify the audit software in the firm, and to realize remote review by auditors and unified data management.
System Description:
Smart Audit Cloud Platform (SACP) is the first cloud-based intelligent audit system developed independently by Lixin in the industry, which is based on the requirements of the risk-oriented audit model, taking the identification, assessment and response to the risk of material misstatement as the main line of work, taking data as the basis, data mining as the core, and data sharing as the link, focusing on the data, being based on the data, integrating the interface of big data, and driving the audit plan with the data. system. Smart Audit Cloud Platform (SACP) is committed to building three platforms, four modules and five core competencies. Among them
Three platforms: Intelligent Audit Cloud Platform, Client Portal Platform, Project Management Platform
Four modules: Client data compilation, financial inquiries and analysis, project draft center, and employee self-training.
Five core competencies: Data Decision Analytics Center, Artificial Intelligence Computing Center, Intra-Enterprise Search Center, Modeling Center, Cloud Storage Center
The process of Smart Audit Cloud Platform (SACP) is as follows:
- Integration platform: Establishment of a resource sharing pool to realize a unified two-way storage channel for projects, clients, auditors and quality control personnel, and real-time links to various types of data.
- Data automation:: Automated validation of data; automatic calculation, generation and validation of trial balances, working papers, statements, cash flow statements, consolidated statements and audit reports.
- Big Data Docking: Combine financial data with Enterprise Search, Baidu, wind report, express and other data, big data analysis, verification of affiliation, verification of the address of the letter sent, analysis of statements, scanning for risks and other in-depth excavation of business risks.
- Remote review: Site managers, quality controllers and partners have real-time access to project implementation progress, real-time access to project documents and attachments, real-time participation in project information and technical guidance, and effective control of the quality of audit work regardless of the constraints of time and space.
- human-computer collaborationCell phone: cell phone draw, inventory, multi-terminal, multi-device collaborative auditing, cloud + client + cell phone three-end fusion, to provide friendly human-computer interaction for the auditor.
- knowledge sharingBuilt-in standardized audit procedures and draft templates, as well as customized audit procedures and drafts based on the industry and client, which can be shared within the firm.
Smart Audit Cloud Platform (SACP) Core Capabilities and Stage Characteristics
Applied Practice:
Smart Audit Cloud Platform (SACP) involves a large number of operations and modules related to forms and reports, with high requirements in data validation, data analysis, strong logical control, data verification, cross-indexing, one-way linking, and labeling, as follows:
data validationAutomatic validation of data is a very important function for auditors, so SACP needs to support a variety of automatic validation methods. With SpreadJS's custom data validation interface, SACP realizes 18 types of validation, including balance validation, voucher type validation, negative debit and positive credit validation, duplicity validation, maker and auditor validation, and auxiliary accounting validation. Automatic data validation allows auditors to see the quality of data at a glance and helps auditors to find abnormal data.
data analysisData analysis is especially important in auditing. With the formula functions of SpreadJS, SACP has designed a variety of data analysis methods, such as absolute number of accounts, large amount of vouchers, non-utilized accounts, and industry average analysis, etc., of which the industry average analysis is built by using the financial database of the publicly listed companies as well as Lixin's own financial database.
strong logical control: Every document and procedure in the SACP is linked to each other as a result of the audit, including the linkage of attachments to the draft, the linkage of the draft to the audit procedures, the linkage of the audit procedures to the subject identification, and the linkage of the subject identification to the audit plan. Such associations are not folder-like groupings, but linkable, searchable, penetrable, and mandatorily controlled by the system. Utilizing the import/export and hyperlink interface capabilities of SpreadJS, SACP perfectly realizes the above functions.
data reconciliation: The biggest headache for reviewers is the correctness and consistency of figures during the audit process. With thousands of drafts, annexes to the final report, how to programmatically ensure that every number is traceable and valid? From attachments, drafts, notes, guidance tables, adjustment tables, trial balance tables, statements, reports to stamping and printing, SACP realizes an online work style where data can be kept on the ground throughout the process, which is a real audit on the cloud. At the same time, SACP also supports offline work, and can do online verification.
File association and cross-indexing
In addition to this, SACP offers several heavy-duty features for control, which include:
1）cross-indexingIn SACP, cross-indexed documents can be opened and formulized in a single page, which ensures the consistency of figures in different documents handled by different auditors. Based on the cross-indexing function realized by SpreadJS, the figures in different drafts can be verified with each other, which effectively ensures the consistency of data.
2）one-way link: The one-way link function makes it easier to trace the relationship between figures and the basis for adjustments. When designing or reviewing drafts, it supports opening them on the same page, making it easier for auditors to use them. In addition, the SpreadJS-based unidirectional linking feature allows you to specify an Excel cell to point to a cell or an attachment in a specific document.
One-way links for online attachment preview
3）tab (of a window) (computing): The labeling function is mainly used to correlate numbers in Excel with numbers in the system in a customized way. Based on the SpreadJS implementation of the labeling function, allowing the auditor to make labels in any of the bottom draft cell as well as the system's guide table, trial balance table.
Enables jumping between different Excel documents and data acquisition
online assignmentThe Smart Audit Cloud Platform (SACP) supports online collaborative remote work. SACP realizes nearly the same function and experience as Excel online, and can interoperate with Excel as well as page fields and do validation with each other, making full use of the advantages of the Internet to enable project teams in different locations to work together seamlessly.
Free audit trail style through customized shortcuts
Value Description:
The Smart Audit Cloud Platform (SACP) leveragesSpreadJS With an online experience that is nearly identical to Excel and the ability to share Excel files and page fields for mutual validation, the platform takes full advantage of the Internet to seamlessly connect project teams in different locations by sharing data. The value that SpreadJS brings to the Intelligent Audit Cloud Platform is reflected in the following aspects:
- Provide a unified online mode of operationSmart Design Cloud Platform (SACP) supports online remote collaborative work. With the Excel-like features of SpreadJS, SACP provides a functional experience that is nearly identical to that of Excel, so that people in different locations and different project teams can seamlessly connect and change the work mode of repeated online and offline interactions.
- Seamless reuse of manuscripts for fast online interaction: SpreadJS supports online import and export of Excel (xlsx), which allows users to load and modify various Excel documents in the browser and save the modified data to the database. The advantage of this is that for existing manuscript files can be reused seamlessly, so that data assets are not wasted. At the same time, for new draft documents, there is no need for business staff to re-upload the documents, and the electronic draft can be designed online and realize rapid interaction with the document system.
- Convenient online operation mode to enhance work efficiency: The Smart Audit Cloud Platform (SACP) can support auditors to remotely review and summarize the problem points online, and can penetrate to the endorsement online, which can effectively improve the work efficiency.
- Flexible integration and scalability for interconnecting tools: In the audit process will involve the use of multiple tools , SpreadJS has good integration and expansion capabilities , in the front-end can be realized with third-party application plug-ins seamless connection , to help achieve the audit of auxiliary tools for interactive use .
- Dual lines of development and business to improve work efficiencyWith the SpreadJS online form editor, business people have more flexibility in designing base draft templates without the need for developers to get involved.
Extended Links:
[Dry Goods Release] The key points of financial statement collation analysis, read all in one article!
Why aren't your financial statements great? It's recommended that you understand these four design points and
Pure front-end Excel spreadsheet control for reporting and analyzing scenarios