A method and system for automatic generation of single and combined audit reports

Abstract

The application provides a kind of single and consolidated audit report automatic generation method and system, including maintaining audited unit and setting audit project, determine project consolidation range;Interface or preset template of interfacing third-party system, obtain the un-audited accounting voucher or subject balance sheet of audited unit, carry out the preset specification processing logic, while carrying out report project mapping setting and configuring the disclosure dimension and disclosure data format of audit project, automatically generate single un-audited report, according to automatic voucher and manual supplementary record single adjustment entry, form single audit adjustment entry summary table, synchronize to single TB table, automatically generate audited single report and audited single report annex;According to audited single report, consolidated offsetting entry and voucher, generate consolidated offsetting entry summary table, synchronize to consolidated TB table, automatically generate audited consolidated financial report.The single audit report and consolidated audit report automatic generation method and system provided by the application are simple and easy to use, and have high intelligent degree.

Description

Technical Field

[0001] This invention relates to the fields of computer processing and auditing technology, specifically to a method and system for automatically generating individual and consolidated audit reports. Background Technology

[0002] Currently, most accounting firms rely heavily on Excel to manually prepare audit adjusting entries, TB tables, and transitional notes during annual audits. This heavy reliance on spreadsheets severely limits efficiency and speed. Furthermore, inherent limitations in Excel, such as hyperlinks between different forms, can lead to formula linking issues during the audit process, impacting audit output. Adding or removing auditees within an audit team necessitates resetting formulas and links in all tables; similarly, changes in disclosure requirements require manual resetting. All these factors contribute to the inefficiency of Excel, despite its wide applicability, due to its open-source nature and inability to support multi-person collaborative auditing.

[0003] Furthermore, after the audit spreadsheet data is generated, how can we quickly generate the audit firm's standard report template and WORD note template? At the same time, it is difficult for the accounting firm's quality control department to effectively trace and record the project team's data review.

[0004] Currently, most accounting firms complete audited financial statements and notes using spreadsheets, outputting Excel reports via formula links, and generating Word notes using Microsoft VBA. This method relies heavily on manual work, making it extremely inefficient. For example, a standard Word note might require disclosing 100 items, but the specific items required for each project vary depending on the project's needs. This necessitates manual intervention from the project manager in the generated Word document, further complicating the process.

[0005] Therefore, how to provide a simple, easy-to-use, and highly intelligent method and system for automatically generating individual audit reports and consolidated audit reports is a problem that urgently needs to be solved by those skilled in the art. Summary of the Invention

[0006] In view of this, the present invention proposes a method and system for automatically generating reports and notes for individual and consolidated audit reports.

[0007] To achieve the above objectives, the present invention adopts the following technical solution:

[0008] This invention discloses a method for automatically generating individual and consolidated audit reports, comprising the following steps:

[0009] Maintain the auditee and set up audit projects according to the setup instructions, determine the scope of consolidation of the auditee, and receive consolidation scope change instructions in real time to make corresponding changes to the consolidation scope;

[0010] By connecting to third-party system interfaces or preset templates, the system obtains the auditee's unaudited accounting vouchers or account balance sheets, performs preset standardized processing logic, sets up report item mapping, and configures the disclosure dimensions and disclosure data formats of audit items according to preset multi-dimensional variable forms, automatically generating individual unaudited reports.

[0011] Individual adjusting entry templates and consolidation elimination entry templates are generated based on the calculation logic of unaudited accounting documents or trial balances set by preset data from the balance sheet, income statement, and cash flow statement.

[0012] Based on the preset individual adjustment entry template, the individual unaudited report is adjusted to generate the individual TB table and the individual notes transition table, and further automatically generates the individual audited report and the individual audited report notes.

[0013] Based on the preset consolidation elimination entry template, the system automatically generates consolidated working paper data for the individual audited financial statements of the audited entities within the consolidation scope, then automatically generates consolidation elimination entries, generates a unified summary table of account adjustment entries based on automatic vouchers and manual adjustment vouchers, and synchronizes it to the consolidated TB table and the consolidated notes transition table, further automatically generating the audited consolidated financial statements and consolidated financial statement notes.

[0014] Based on the logical mapping between the individual TB table, the consolidated TB table, and the audited individual notes and consolidated financial statement notes configured by the project team, the individual financial statements and consolidated financial statement notes are automatically generated.

[0015] Preferably, the third-party system includes ERP or other external business systems.

[0016] Preferably, the method supports manual entry of offset adjustment vouchers for certain special scenarios, and then the system generates a unified summary table of account adjustment entries based on the automatic vouchers and manual adjustment vouchers.

[0017] Preferably, it also includes: building and reorganizing the accounting model according to the accounting model management instructions issued by the executing unit.

[0018] Preferably, the process also includes setting up users and roles: configuring roles for users and assigning corresponding data management permissions to different roles.

[0019] Preferably, it also includes: when a user logs in for the first time, or when a guidance configuration instruction is triggered, displaying a guidance configuration interface to assist the user in completing relevant parameter settings, the relevant parameter settings including: system basic settings, data completion, merging scope, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subjects and report item settings.

[0020] Preferably, configuring the disclosure dimensions and disclosure data format of audit projects according to the preset multi-dimensional variable form includes configuring the note disclosure items and note disclosure details; and establishing the reconciliation relationship between adjusting offset entries and note disclosure details.

[0021] Preferably, the steps for automatically generating consolidation elimination entries include: based on the ledger function, organizing and cleaning the data on accounts receivable and payable; advances from customers and prepayments; other receivables and other payables; notes receivable and notes payable; other current assets and other current liabilities; contract assets and contract liabilities; details of internal transactions; asset valuation increases and decreases; goodwill, etc., within the scope of consolidation, automatically generating working paper data for consolidation-level offsetting of intercompany transactions and equity transactions, and then automatically generating consolidation elimination entries; for manual maintenance vouchers in special scenarios, generating a unified summary table of account adjustment entries data and synchronizing it to the individual TB table and the consolidated TB table, automatically generating the audited individual report and consolidated financial statements.

[0022] Preferably, it also includes: analyzing and judging the correlation between various report data, automatically checking for risks and errors, and generating guidance prompts.

[0023] Preferred options also include:

[0024] The data obtained from the interface or preset template of the third-party system is cleaned by ETL.

[0025] By embedding an online spreadsheet, a secondary data cleaning interface is provided to complete the secondary processing of data and automatically generate consolidation elimination entries. The consolidation elimination entries include: elimination of unrealized profits within the consolidation scope, reclassification of accounts receivable and payable, elimination of accounts receivable and payable, adjustment of fair value statement, equity elimination, and profit and loss elimination. Unrealized profits include unrealized profit data from inventory transactions and unrealized profit data from asset transactions.

[0026] Preferably, it also includes: setting exchange rates according to different project groups, and generating individual original currency audit reports and consolidated base currency reports.

[0027] This invention also discloses an automatic generation system for individual and consolidated audit reports based on the aforementioned automatic generation method, comprising:

[0028] The system management module is used to maintain the audited entities and set up audit projects according to the setting instructions, determine the scope of project consolidation, and receive consolidation scope change instructions in real time to make corresponding changes to the consolidation scope.

[0029] The data management module is used to obtain the auditee's unaudited accounting vouchers or account balances through interfaces with third-party systems or preset templates, and generate unaudited reports that conform to reporting standards through preset standardized processing logic; and configure the disclosure dimensions and disclosure data formats of audit projects according to preset multi-dimensional variable forms.

[0030] The ledger management module is used to automatically generate individual adjusting entries and consolidated elimination entries for the unaudited accounting vouchers or account balances of the audited entity based on preset individual adjusting entry templates and consolidated elimination entry templates.

[0031] The financial reporting module is used to synchronize accounting adjustment data to the individual TB table and the consolidated TB table, and automatically generate audited individual reports and consolidated financial statements. After the individual TB table and the consolidated TB table are completed, the module automatically generates the individual notes transition table and the consolidated notes transition table, and then automatically generates the audited individual notes spreadsheet and the consolidated notes spreadsheet. The module automatically generates individual financial reports and consolidated financial reports based on the form documents configured by the project team.

[0032] Preferred options also include:

[0033] The configuration guidance module is used to display a configuration guidance interface when a user logs in for the first time or when a configuration guidance command is triggered, assisting the user in setting relevant parameters. These parameters include: system basic settings, data completion, merging scope, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subjects and report item settings; and / or,

[0034] The analysis and judgment module is used to analyze and judge the correlation between various report data, automatically check for risks and errors, and generate guidance prompts.

[0035] As can be seen from the above technical solution, compared with the prior art, the beneficial effects of the present invention include:

[0036] This invention utilizes a multidimensional database and OLAP (Online Analytical Processing) technology to achieve parallel and multi-level merging, and solves the problem of auditors working remotely to process data adjustments of audited entities simultaneously. It also enables data access control based on role management, and addresses the flexible and ever-changing data disclosure requirements of accounting firms for different types of audited entities.

[0037] Through an advanced technological framework, it solves the problem of flexible settings for multiple standards, multiple ledgers, and multiple dimensions, and generates financial statements and management analyses based on legal entities / virtual entities. At the same time, through embedded online spreadsheet technology, accounting firms can easily adjust the TB table, summary table of adjusting entries, and transitional table of notes to suit the audit requirements of different audit projects, and automatically generate individual notes and consolidated notes, intelligently generating audit reports that meet the needs of accounting firms.

[0038] This invention generates audited individual financial statements based on automatically adjusting entries, and simultaneously forms audited consolidated financial statements based on the audited financial statements and automatically consolidating and eliminating entries. Through individual audit reports (TBs), summary audit reports (TBs), and consolidated audit reports (TBs), the system automatically generates individual report notes simultaneously with the generation of audit adjusting entries. Based on the individual report notes and in conjunction with the consolidated audit reports (TBs), it automatically generates consolidated report notes. Each project team of accounting firms adjusts its own pre-set templates to the applicable disclosure content for that project. After uploading to the system, the system automatically generates WORD report notes, providing an intelligent assistant service for accounting and auditing work. Attached Figure Description

[0039] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on the provided drawings without creative effort.

[0040] Figure 1 A schematic diagram illustrating the principle of the automatic generation method for individual and consolidated audit reports provided in this embodiment of the invention;

[0041] Figure 2 A diagram of the report item mapping settings interface of the automatic generation system for individual and consolidated audit reports provided in this embodiment of the invention;

[0042] Figure 3 The configuration notes for the automatic generation system of individual and consolidated audit reports provided in this embodiment of the invention disclose the interface diagram of the project.

[0043] Figure 4 A basic settings interface diagram of the automatic generation system for individual and consolidated audit reports provided in this embodiment of the invention;

[0044] Figure 5 A diagram showing the data processing function interface of the automatic generation system for individual and consolidated audit reports provided in this embodiment of the invention;

[0045] Figure 6 A diagram of the individual adjusting entries interface of the automatic generation system for individual and consolidated audit reports provided in this embodiment of the invention;

[0046] Figure 7 A diagram of the merge transition / notes table interface of the automatic generation system for individual and merged audit reports provided in this embodiment of the invention;

[0047] Figure 8 A schematic diagram of the boot configuration module of the automatic generation system for individual and consolidated audit reports provided in an embodiment of the present invention;

[0048] Figure 9 A schematic diagram of the ledger management module of the automatic generation system for individual and consolidated audit reports provided in an embodiment of the present invention;

[0049] Figure 10 This is a schematic diagram of the individual adjusting entries and consolidation offsetting entries templates for the automatic generation system of individual and consolidated audit reports provided in this embodiment of the invention. Detailed Implementation

[0050] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0051] like Figure 1 As shown, the first aspect of this invention discloses a method for automatically generating individual and consolidated audit reports, comprising the following steps:

[0052] S1. Maintain the audited entity and set up audit projects according to the configuration instructions, determine the scope of project consolidation, and receive consolidation scope change instructions in real time, making corresponding changes to the consolidation scope. In specific execution:

[0053] Accounting firms set up audit projects, maintaining the main equity amounts and equity investment / return ratios of the audited entity; the project team defines the consolidation scope based on the audited entity's equity ratio. This invention supports real-time changes to the consolidation scope of audit projects and ensures that historical data is not lost.

[0054] S2. By connecting to the interface of the third-party system or the preset template, obtain the auditee's unaudited accounting vouchers or account balance sheets, perform preset standardized processing logic, set up report item mapping, and configure the disclosure dimensions and disclosure data format of the audit items according to the preset multi-dimensional variable form, and automatically generate individual unaudited reports.

[0055] Based on the preset entity adjustment entry template, entity adjustment entries are made for the unaudited entity reports to generate entity TB tables and entity note transition tables, and further, unaudited entity reports and audited entity notes are automatically generated. Specifically, during execution:

[0056] like Figure 2 The image shows the report item mapping settings interface.

[0057] like Figure 3 As shown, the system allows for easy configuration of note disclosure items and details, and allows users to choose whether or not to generate data for each item based on its specific requirements. Note disclosure item configuration is completed simultaneously with report standardization, ensuring that note content is generated synchronously in the TB table.

[0058] Utilizing multidimensional database technology, the system pre-sets multidimensional variable forms, allowing accountants to easily configure the form styles to be disclosed based on the characteristics of the project and complete the field settings for the items to be disclosed.

[0059] S3. Based on the preset consolidation elimination entry template, automatically generate consolidated working paper data for the audited individual financial statements of the audited entities within the consolidation scope, and then automatically generate consolidation elimination entries. It supports manual supplementation of elimination adjustment vouchers for some special scenarios. Then, based on the automatic vouchers and manual adjustment vouchers, it generates a unified summary table of account adjustment entry data and synchronizes it to the consolidated TB table and the consolidated notes transition table. After the accountant reviews and confirms that there are no errors, it automatically generates the audited consolidated financial statements and consolidated financial statement notes.

[0060] Individual adjusting entry templates and consolidation elimination entry templates set the calculation logic for unaudited accounting documents or account balance sheets based on preset data from the balance sheet, income statement, and cash flow statement.

[0061] S4. Based on the logical mapping between the individual TB statements, consolidated TB statements, and the audited individual and consolidated financial statement notes configured by the project team, automatically generate individual and consolidated financial reports. Individual financial reports include: balance sheet, income statement, cash flow statement, statement of changes in equity, and individual financial statement notes; consolidated financial reports include: consolidated balance sheet, consolidated income statement, consolidated cash flow statement, consolidated statement of changes in equity, and consolidated financial statement notes.

[0062] This embodiment employs OLAP technology based on multidimensional databases. Through dimensions, dimension levels, dimension members, and measures, coupled with OLAP techniques such as drill-down, slicing and dicing, and rotation, it flexibly constructs the configuration requirements needed by the audit team. This allows the multidimensional data used in the audit project to be physically stored as multidimensional arrays, facilitating auditors to customize various items to be disclosed based on the characteristics of the audit project, generating various TB tables and footnote forms to comply with the data specifications and information disclosure requirements of the Ministry of Finance and the China Securities Regulatory Commission. This solves the auditors' data retrieval needs when dealing with different companies.

[0063] This embodiment also adopts a ledger management mode. By embedding powerful online spreadsheet functions, while using ETL technology, it allows accountants to use their auditing expertise to perform secondary cleaning and processing of data, thereby automatically generating individual and consolidated entries such as intercompany offsetting, internal transaction offsetting, and reclassification data retrieval.

[0064] In one embodiment, the method further includes: constructing and reorganizing the accounting model according to the accounting model management instructions issued by the executing unit.

[0065] In one embodiment, the system also includes a step of setting up users and roles: configuring roles for users, and assigning corresponding data management permissions to different roles. For accounting firms, roles and users are defined and added through the system, and corresponding data permission management is performed through the configuration of users and roles.

[0066] In one embodiment, the method further includes: displaying a configuration interface when a user logs in for the first time or when a configuration guidance instruction is triggered, to assist the user in setting relevant parameters, including: system basic settings, data completion, merging scope, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subjects and report items settings.

[0067] In one embodiment, the disclosure dimensions and disclosure data format of the audit project are configured according to a preset multi-dimensional variable form, including configuring the note disclosure items and note disclosure details; and establishing the reconciliation relationship between adjusting offset entries and note disclosure details.

[0068] In one embodiment, the method further includes: analyzing and determining the correlation between various report data, automatically checking for risks and errors, generating guidance prompts, and guiding users to make manual interventions.

[0069] In one embodiment, it also includes:

[0070] ETL is used to clean the data obtained from the interface of a third-party system or a preset template.

[0071] Considering that audit projects rely heavily on the professional skills of accountants, the system provides a ledger management platform to allow accountants to perform secondary data cleaning. By embedding an online spreadsheet, it provides a secondary data cleaning interface to complete the secondary processing of data and automatically generate consolidation and elimination entries. Consolidation and elimination entries include: elimination of unrealized internal profits, reclassification of accounts receivable and payable, elimination of accounts receivable and payable, fair value adjustments to financial statements, equity elimination, and profit and loss elimination.

[0072] In one embodiment, the method further includes: each project team generating a single original currency audit report and a merged base currency merger report based on the exchange rate set for the project, and can also automatically generate multi-dimensional chart data analysis.

[0073] In one embodiment, multi-dimensional chart data analysis is automatically generated based on the data from steps S3 to S5, and summarization, offsetting, and merging analysis is performed based on the data from steps S3 to S5.

[0074] like Figure 4 As shown, a second aspect of the present invention also discloses an automatic generation system for individual and consolidated audit reports based on the first aspect, comprising:

[0075] The system management module is used to maintain the audited entities and set up audit projects according to configuration instructions, determine the scope of project consolidation, and receive consolidation scope change instructions in real time, making corresponding changes to the consolidation scope. The system management module is also used to determine user and role settings; it supports the construction and reorganization of management and accounting models in a modular format under legal entities according to management needs.

[0076] Data management module, such as Figure 5 As shown, it is used to obtain the auditee's unaudited accounting vouchers or account balances through interfaces or preset templates connected to third-party systems, and generate unaudited reports that conform to reporting standards through preset standardized processing logic; and configure the disclosure dimensions and disclosure data formats of audit projects according to preset multi-dimensional variable forms.

[0077] Ledger management module, such as Figure 6 As shown, the system is used to obtain data through interfaces or imports. The system provides data to accountants for professional judgment. Based on the preset individual adjusting entry templates and consolidation elimination entry templates, the system performs secondary processing on the data and automatically generates individual adjusting entries and consolidation elimination entries for the auditee's unaudited accounting vouchers or trial balance. Figure 9 The image shown is an example of the account balance sheet statistics for the audited entity within the consolidated scope. Figure 10 The following are specific examples of individual adjustment entry templates and consolidation offset entry templates.

[0078] Financial reporting module, such as Figure 7As shown, this system is used to synchronize accounting adjustment data to the individual TB table and the consolidated TB table, automatically generating audited individual reports and consolidated financial statements. After the individual and consolidated TB tables are completed, individual and consolidated transitional notes tables are automatically generated, which in turn automatically generate audited individual and consolidated notes spreadsheets. Based on the form documents configured by the project team, individual and consolidated financial reports are automatically generated. The financial reports include: financial statements and notes to the financial statements.

[0079] In one embodiment, it also includes:

[0080] Boot configuration module, such as Figure 8 As shown, this is used to display a configuration guide interface when a user logs in for the first time or when a configuration guide command is triggered, assisting the user in setting relevant parameters. These parameters include: system basic settings, data completion, merging scope, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subjects and report item settings; and / or,

[0081] The analysis and judgment module is used to analyze and judge the correlation between various report data, automatically check for risks and errors, generate guidance prompts, and guide users to make manual interventions.

[0082] In one embodiment, a basic settings module is also included, which allows each project team to set exchange rates, reporting cycles, disclosure dimensions, and disclosure data formats according to the specific circumstances of the project.

[0083] In one embodiment, the system provides data storage space to facilitate accountants in storing audit working papers according to the characteristics of the project, and sets access control to ensure that the working papers are only accessible to authorized personnel.

[0084] In one embodiment, an analysis module is also included, which is used to automatically generate multi-dimensional chart data analysis for the data from the ledger management module and the financial reporting module.

[0085] The above provides a detailed description of the automatic generation method and system for individual and consolidated audit reports provided by the present invention. Specific examples are used in this embodiment to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only for the purpose of helping to understand the method and core ideas of the present invention. At the same time, for those skilled in the art, there will be changes in the specific implementation methods and application scope based on the ideas of the present invention. Therefore, the content of this specification should not be construed as a limitation of the present invention.

[0086] The above description of the disclosed embodiments enables those skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined in these embodiments may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the invention is not to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for automatically generating individual and consolidated audit reports, characterized in that, Includes the following steps: Maintain the auditee and set up audit items according to the setup instructions, determine the consolidation scope of the auditee, and receive consolidation scope change instructions in real time to make corresponding changes to the consolidation scope; By connecting to third-party system interfaces or using preset data import templates, the system obtains the auditee's unaudited accounting vouchers or account balance sheets, performs preset standardized processing logic, sets up report item mapping, and configures the disclosure dimensions and disclosure data formats of audit items according to preset multi-dimensional variable forms, automatically generating individual unaudited reports. The configuration of the disclosure dimensions and disclosure data format of the audit project based on the preset multi-dimensional variable form includes configuring the note disclosure items and note disclosure details; Establish a reconciliation relationship between adjusting and offsetting entries and the details disclosed in the notes; Based on the preset single-entity adjustment entry template, single-entity adjustment entries are made on the unaudited single-entity report to generate a single-entity TB table and a single-entity notes transition table, and then the audited single-entity report and audited single-entity notes are automatically generated. Based on the preset consolidation elimination entry template, the system automatically generates consolidated working paper data for the individual audited financial statements of the audited entities within the consolidation scope, then automatically generates consolidation elimination entries, and automatically generates a unified summary table of account adjustment entries based on automatic vouchers and manual adjustment vouchers, and synchronizes it to the consolidated TB table and the consolidated notes transition table, and further automatically generates the audited consolidated financial statements and consolidated financial statement notes. The individual adjusting entry template and the consolidation elimination entry template are set with the calculation logic of unaudited accounting vouchers or account balance sheets based on the preset data of the balance sheet, income statement and cash flow statement. The data obtained from the interface or preset template of the third-party system is cleaned by ETL. By embedding an online spreadsheet, a secondary data cleaning interface is provided to complete the secondary processing of data and automatically generate consolidation and offsetting entries; The consolidation elimination entries include: elimination of unrealized profits within the consolidation scope, reclassification of accounts receivable and payable, elimination of accounts receivable and payable, fair value adjustment of financial statements, equity elimination, and profit and loss elimination. Based on the logical mapping between the individual TB table, the consolidated TB table, and the audited individual notes and consolidated financial statement notes configured by the project team, the individual financial statements and consolidated financial statement notes are automatically generated.

2. The method for automatically generating individual and consolidated audit reports according to claim 1, characterized in that, Also includes: Based on the accounting model management instructions issued by the executing unit, the accounting model is constructed and reorganized in accordance with the corresponding module styles.

3. The method for automatically generating individual and consolidated audit reports according to claim 1, characterized in that, It also includes steps for setting up users and roles: configuring roles for users, and assigning corresponding data management permissions to different roles.

4. The method for automatically generating individual and consolidated audit reports according to claim 1, characterized in that, Also includes: When a user logs in for the first time, or when a configuration guidance command is triggered, a configuration guidance interface is displayed to assist the user in setting relevant parameters. These parameters include: system basic settings, data completion, merging scope, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subjects and report item settings.

5. The method for automatically generating individual and consolidated audit reports according to claim 1, characterized in that, Also includes: It analyzes and judges the correlation between data in various reports, automatically checks for risks and errors, and generates guidance and prompts.

6. The method for automatically generating individual and consolidated audit reports according to claim 1, characterized in that, Also includes: Exchange rates are set according to different project groups, and individual original currency audit reports and consolidated base currency reports are generated.

7. A system for automatically generating individual and consolidated audit reports according to any one of claims 1-6, characterized in that, include: The system management module is used to maintain the audited entities and set up audit projects according to the setting instructions, determine the scope of project consolidation, and receive consolidation scope change instructions in real time to make corresponding changes to the consolidation scope. The data management module is used to obtain the auditee's unaudited accounting vouchers or account balances through interfaces with third-party systems or preset templates, and generate unaudited reports that conform to reporting standards through preset standardized processing logic; and configure the disclosure dimensions and disclosure data formats of audit projects according to preset multi-dimensional variable forms. The ledger management module is used to automatically generate individual adjusting entries and consolidated elimination entries for the unaudited accounting vouchers or account balances of the audited entity based on preset individual adjusting entry templates and consolidated elimination entry templates. The financial reporting module is used to synchronize accounting adjustment data to the individual TB table and the consolidated TB table, and automatically generate audited individual reports and consolidated financial statements; After the individual TB table and consolidated TB table are completed, the individual notes transition table and consolidated notes transition table are automatically generated, and then the audited individual notes spreadsheet and consolidated notes spreadsheet are automatically generated; the individual financial report and consolidated financial report are automatically generated based on the form documents configured by the project team.

8. The automatic generation system for individual and consolidated audit reports according to claim 7, characterized in that, Also includes: The guidance configuration module is used to display the guidance configuration interface when a user logs in for the first time or when the guidance configuration command is triggered, to assist the user in completing the relevant parameter settings. The relevant parameter settings include: system basic settings, data completion, merging scope, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subject and report item settings. And / or, The analysis and judgment module is used to analyze and judge the correlation between various report data, automatically check for risks and errors, and generate guidance prompts.

Images