CN115423587A - Automatic generation method and system for single and combined audit reports - Google Patents

Automatic generation method and system for single and combined audit reports Download PDF

Info

Publication number
CN115423587A
CN115423587A CN202211055469.6A CN202211055469A CN115423587A CN 115423587 A CN115423587 A CN 115423587A CN 202211055469 A CN202211055469 A CN 202211055469A CN 115423587 A CN115423587 A CN 115423587A
Authority
CN
China
Prior art keywords
report
audit
automatically generating
combined
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202211055469.6A
Other languages
Chinese (zh)
Inventor
蔡乐敏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xiamen E Account Cloud Information Technology Co ltd
Original Assignee
Xiamen E Account Cloud Information Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Xiamen E Account Cloud Information Technology Co ltd filed Critical Xiamen E Account Cloud Information Technology Co ltd
Priority to CN202211055469.6A priority Critical patent/CN115423587A/en
Publication of CN115423587A publication Critical patent/CN115423587A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/169Annotation, e.g. comment data or footnotes
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • General Engineering & Computer Science (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Human Resources & Organizations (AREA)
  • Health & Medical Sciences (AREA)
  • Finance (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • Data Mining & Analysis (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention provides a method and a system for automatically generating single and combined audit reports, which comprises the steps of maintaining an audited unit, setting an audit project and determining a project combination range; the method comprises the steps of butting an interface or a preset template of a third-party system, obtaining an unexamined accounting document or a subject balance list of an audited unit, carrying out preset standard processing logic, simultaneously carrying out report project mapping setting and configuring disclosure dimensions and disclosure data formats of audit projects, automatically generating a single-body unexamined report, adjusting entries according to automatic documents and manual entry-adding monomers, forming a single-body audit adjustment entry summary list, synchronizing to a single-body TB list, and automatically generating an examined single-body report and an examined single-body report supplementary note; and generating a combined offset entry summary table according to the examined individual report, the combined offset entry and the certificate, synchronizing to the combined TB table, and automatically generating an examined combined financial report. The automatic generation method and the system for the single audit report and the combined audit report are simple and easy to use and have high intelligent degree.

Description

Automatic generation method and system for single audit report and merged audit report
Technical Field
The invention relates to the technical field of computer processing and auditing, in particular to a method and a system for automatically generating single and combined audit reports.
Background
At present, most accounting offices basically rely on EXCEL to manually compile audit account adjustment entries, TB tables and supplementary notes transition tables during annual audit, and due to the fact that a large number of electronic forms depend on, efficiency and speed are greatly limited. Meanwhile, due to the inherent defects of EXCEL, the hyperlink setting among different forms causes the problem of formula link easily occurring in the auditing process of project groups, and further influences the output of the auditing result. When an audited unit is newly added or removed in a certain audit project group, the project group is required to reset various table formulas and links; the set of items is also required to manually reset the table formulas and links once the exposure requirements change. All of the above results in spreadsheet that is not very adaptable, but is inefficient because EXCEL spreadsheets are too open-source and cannot be synchronized by multiple people.
In addition, after the data of the audit electronic watch is generated, how to quickly generate an audit post standard report template and a WORD supplementary note template, and meanwhile, effective data tracing and rechecking trace retention are difficult to form by the quality control department of the accounting firm to recheck project group data.
At present, most accounting firms output EXCEL reports in a formula link mode according to approved reports and notes finished by spreadsheets, and generate WORD notes in a VBA mode of OFFICE. Most of the method is completed by a manual mode, and the efficiency is very low. Such as: the standard version of WORD notes that 100 items need to be disclosed, but the items that need to be disclosed for each item are determined according to the situation of the item, and at this time, a series of manual intervention is needed for the item manager to generate the WORD document, which is very inefficient.
Therefore, how to provide a simple and easy-to-use automatic generation method and system for single audit reports and merged audit reports with high intelligence degree is a problem that needs to be solved by those skilled in the art.
Disclosure of Invention
In view of this, the invention provides a method and a system for automatically generating reports and notes of single and merged audit reports.
In order to achieve the purpose, the invention adopts the following technical scheme:
the invention discloses an automatic generation method of single and combined audit reports, which comprises the following steps:
maintaining the audited unit and the audit item according to the setting instruction, determining the merging range of the audited unit, receiving a merging range changing instruction in real time, and correspondingly changing the merging range;
the method comprises the steps of obtaining an unexamined accounting voucher or a subject balance table of an audited unit by butting an interface of a third-party system or a preset template, carrying out preset standard processing logic, carrying out report item mapping setting, configuring disclosure dimensions and disclosure data formats of audit items according to a preset multi-dimensional variable form, and automatically generating a single-body unexamined report;
the monomer adjustment entry template and the combination offset entry template are generated by setting the calculation logic of the unexamined accounting document or the subject balance sheet according to the preset data of the asset balance sheet, the profit sheet and the cash flow sheet;
according to a preset monomer adjustment entry template, performing monomer adjustment entry on the monomer unexamined report to generate a monomer TB table and a monomer supplementary note transition table, and further automatically generating a monomer examined report and a monomer examined report supplementary note;
automatically generating manuscript data of a merging layer according to a preset merging offset entry template on a single audited report of an audited unit in a merging range, then automatically generating a merging offset entry, generating a unified entry adjustment entry data summary table according to an automatic certificate and a manual adjustment certificate, synchronizing to a merging TB table and a merging additional note transition table, and further automatically generating a reviewed merged report and a merging report additional note;
and automatically generating a single financial report and a combined financial report according to the logical mapping of the disclosure contents of the single TB table, the combined TB table, the examined single remark and the combined report remark configured by the project group.
Preferably, the third party system comprises an ERP or other external business system.
Preferably, the method supports manual entry-supplementing offsetting adjustment certificates of part of special scenes, and then the system generates a uniform account adjustment entry data summary table according to the automatic certificates and the manual adjustment certificates.
Preferably, the method further comprises the following steps: and according to an accounting mode management instruction sent by an executed unit, building and recombining a corresponding module pattern for the accounting mode.
Preferably, the method further comprises the step of setting the user and the role: and configuring roles for the user, and endowing corresponding data management authorities to different roles.
Preferably, the method further comprises the following steps: when a user logs in for the first time or when a guide configuration instruction is triggered, a guide configuration interface is displayed to assist the user in completing relevant parameter setting, wherein the relevant parameter setting comprises the following steps: system foundation setting, data perfection, merging range, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subject and report item setting.
Preferably, the configuring of the disclosure dimension and the disclosure data format of the audit item according to the preset multi-dimensional variable form includes configuring an annotation disclosure item and an annotation disclosure detail; establishing a check relation of adjustment offset entry-supplementary notes disclosure detail.
Preferably, the step of automatically generating the merged offset entry comprises: according to the machine account function, accounts receivable and accounts payable among audited units within the merging range are combined; prepayment and prepayment; other accounts receivable, other accounts payable; bill to be received and bill to be paid; other liquidated assets, other liquidated liabilities; contract assets, contract liabilities; internal transaction details; asset assessment add-subtract value condition; data arrangement and cleaning are carried out on the reputation and the like, manuscript data of the mutual offset and the stock right transaction offset of a merging layer are automatically generated, and then a merging offset entry is automatically generated; and for manual maintenance certificates of special scenes, generating a unified account item adjustment entry data summary table, synchronizing the statement table to the single TB table and the combined TB table, and automatically generating an examined single report and a combined report.
Preferably, the method further comprises the following steps: analyzing and judging the checking relationship among various report data, automatically checking risks and errors, and generating a guidance prompt.
Preferably, the method further comprises the following steps:
performing primary cleaning on data acquired by an interface of the third-party system or a preset template through an ETL (extraction transformation Loading);
providing a secondary data cleaning interface by embedding an online spreadsheet, and finishing the steps of carrying out secondary processing on data and automatically generating, combining and offsetting entries; the merge offset entry includes: and realizing profit offset, forward and backward reclassification, forward and backward offset, fair value statement adjustment, equity offset and profit-loss offset in the merging range, wherein the unrealized profit comprises unrealized profit data of stock type transaction and unrealized profit data of asset type transaction.
Preferably, the method further comprises the following steps: and setting exchange rates according to different project groups, and generating a single original currency audit report and a merged local currency merging report.
The invention also discloses a monomer and combined audit report automatic generation system according to the monomer and combined audit report automatic generation method, which comprises the following steps:
the system management module is used for maintaining the audited units and setting the audit projects according to the setting instructions, determining project merging ranges, receiving merging range changing instructions in real time and correspondingly changing the merging ranges;
the data management module is used for acquiring an unexamined accounting voucher or a subject balance table of an audited unit through an interface or a preset template which is butted with a third-party system, and generating an unexamined report which accords with the report specification through a preset specification processing logic; configuring the disclosure dimension and the disclosure data format of an audit project according to a preset multi-dimensional variable form;
the standing book management module is used for automatically generating a single body adjustment entry and a combined offset entry for the unexamined accounting voucher or the subject balance table of the audited unit according to a preset single body adjustment entry template and a combined offset entry template;
the financial report module is used for synchronizing the account adjustment data to the single TB table and the combined TB table and automatically generating an examined single report and a combined report; after the single TB table and the combined TB table are finished, automatically generating a single note attached transition table and a combined note attached transition table, and further automatically generating an approved single note attached electronic table and a combined note attached electronic table; and automatically generating single financial reports and combining financial reports according to the form documents configured by the project group.
Preferably, the method further comprises the following steps:
the guidance configuration module is used for displaying a guidance configuration interface when a user logs in for the first time or when a guidance configuration instruction is triggered, and assisting the user to complete related parameter setting, wherein the related parameter setting comprises the following steps: system foundation setting, data perfection, merging range, report period, user management, currency and exchange rate, auxiliary accounting management, accounting subject and report item setting; and/or the presence of a gas in the gas,
and the analysis and judgment module is used for analyzing and judging the checking relationship among various report data, automatically checking risks and errors and generating a guidance prompt.
Through the technical scheme, compared with the prior art, the invention has the beneficial effects that:
the invention realizes parallel combination and multilayer combination through a multidimensional database and an OLAP technology (online analysis and processing), solves the problem that an auditor synchronously processes the data adjustment operation of audited units in different places, realizes the data authority isolation according to the management of roles, and solves the flexible and changeable data disclosure requirement of different types of audited units required by an accounting firm;
through an advanced technical framework, the problems of multi-caliber, multi-account book and multi-dimension flexible setting are solved, financial statements and management analysis are issued according to law main bodies/virtual main bodies, meanwhile, an accountant firm can easily adjust a TB table, an account item adjustment and entry summary table and an additional note transition table which are suitable for audit requirements of the project according to the characteristics of different audit projects through an embedded online spreadsheet technology, single additional notes and combined additional notes are automatically generated, and audit reports meeting the requirements of the accountant firm are intelligently issued.
The invention generates the checked single report according to the automatic adjustment entries, and simultaneously forms the checked combined report according to the checked report and the automatic combination offset entries. Through the monomer TB, the summary TB and the combined TB table, when the audit adjustment entry is generated, the system automatically generates a monomer remark, and the combined TB table is matched to automatically generate a combined remark on the basis of the monomer remark. The method comprises the steps of automatically adjusting to-be-disclosed contents applicable to the project according to a template preset by an accounting firm of each project group, automatically generating WORD notes by the system after uploading to the system, and providing intelligent assistant service for accounting audit work.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts;
FIG. 1 is a functional block diagram of a method for automatically generating a monolithic and consolidated audit report according to an embodiment of the present invention;
FIG. 2 is a report item mapping interface diagram of a system for automatically generating single and merged audit reports according to an embodiment of the present invention;
FIG. 3 is a diagram of a configuration comment disclosure project interface for a system for automated generation of monolithic and consolidated audit reports provided by an embodiment of the present invention;
FIG. 4 is a basic configuration interface diagram of a system for automatically generating reports for individual and consolidated audits, according to an embodiment of the present invention;
FIG. 5 is a data consolidation function interface diagram of an automatic generation system for single and merged audit reports according to an embodiment of the present invention;
FIG. 6 is a diagram of a monomer adjustment entry interface of an automatic generation system for monomer and merged audit reports, according to an embodiment of the present invention;
FIG. 7 is a merged transition/remarks table interface diagram of a system for automatically generating a single and merged audit report according to an embodiment of the present invention;
FIG. 8 is a schematic diagram of a bootstrap configuration module of a system for automated generation of consolidated audit reports and monomer provided by an embodiment of the present invention;
FIG. 9 is a diagram illustrating a ledger administration module of a system for automated generation of individualized and consolidated audit reports, in accordance with an embodiment of the present invention;
fig. 10 is a schematic diagram of a monomer adjustment entry and merge cancellation entry template of the system for automatically generating single and merged audit reports according to the embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, a first aspect of the embodiment of the present invention discloses an automatic generation method of single and merged audit reports, including the following steps:
s1, maintaining the audited unit and the audit item according to the setting instruction, determining the item merging range, receiving the merging range changing instruction in real time, and correspondingly changing the merging range. When the concrete execution is carried out:
the accounting firm carries out audit project setting and maintains the main equity amount and the equity investment/income proportion of the legal entity of the audited unit; and the project group completes the definition of the merging range according to the stock right proportion of the audited unit. The invention supports real-time change and merging range of audit items and ensures that historical data is not lost.
S2, obtaining an unexamined accounting voucher or a subject balance table of an audited unit by butting an interface of a third-party system or a preset template, performing preset standard processing logic, performing report project mapping setting, configuring disclosure dimensions and disclosure data formats of audit projects according to a preset multi-dimensional variable form, and automatically generating a single-body unexamined report;
and according to a preset monomer adjustment entry template, performing monomer adjustment entry on the monomer unexamined report to generate a monomer TB table and a monomer supplementary note transition table, and further automatically generating the monomer unexamined report and the examined monomer supplementary note. When the concrete execution is carried out:
as shown in FIG. 2, an interface is provided for the report item mapping.
As shown in FIG. 3, the system can easily configure the remark disclosure item and the remark disclosure detail, and set the generation data or not according to the concrete condition of each item. And the report form is subjected to normalized processing, and meanwhile, the configuration of the note disclosing item is completed, so that the TB table is ensured to synchronously form note content.
Through the multidimensional database technology, a multidimensional variable form is preset in the system, and an accountant can easily configure the form style to be disclosed according to the characteristics of the project. And completes the field setting of the item to be disclosed.
S3, automatically generating manuscript data of a merging layer according to a preset merging offset entry template on a monomer audited report of an audited unit in a merging range, then automatically generating a merging offset entry, supporting a manual additional entry offset adjustment voucher of part of special scenes, then generating a unified entry adjustment entry data summary table according to the automatic voucher and the manual adjustment voucher, synchronizing the summary table to a merging TB table and a merging remark transition table, and automatically generating a reviewed merged report and a merging report remark after being rechecked to be correct by an accountant;
and the monomer adjustment entry template and the combination offset entry template set the calculation logic of the unexamined accounting document or the subject balance sheet according to the preset data of the asset balance sheet, the profit sheet and the cash flow sheet.
And S4, automatically generating a single financial report and a combined financial report according to the logical mapping of the disclosure contents of the single TB table, the combined TB table and the examined single remark and the combined report remark configured by the project group. The monomer financial reports include: an asset and debt statement, a profit statement, a cash flow statement, an owner's equity change statement and a monomer report remark; merging financial reports includes: merging the balance sheet, merging the profit sheet, merging the cash flow sheet, merging the ownership change sheet and merging the statement remarks.
The embodiment adopts an OLAP technology based on a multi-dimensional database, and by matching OLAP technologies such as drilling, slicing, cutting, rotating and the like with the dimension, the hierarchy of the dimension, the member of the dimension and the measurement, configuration requirements needed by an audit project group are flexibly constructed, the multi-dimensional data used by the audit project is physically stored in a multi-dimensional array form, an auditor is convenient to define various items to be disclosed according to the characteristics of the audit project, and various TB tables and additional note forms are formed so as to meet the data specification requirements of information disclosure requirements of the financial department and the China certificate Authority. The problem of the auditor face the data of different enterprises and get the data demand is solved.
The embodiment also adopts a machine account management mode, and by embedding a strong online spreadsheet function, an accountant is allowed to use own audit professional judgment to carry out secondary cleaning and processing on data while applying an ETL technology, so that automatic entry of monomers and merging layers of current offset, internal transaction offset, reclassification and access and the like is automatically generated.
In one embodiment, further comprising: and according to an accounting mode management instruction sent by an executed unit, building and recombining a corresponding module pattern for an accounting mode.
In one embodiment, the method further comprises the step of setting the user and the role: and configuring roles for the user, and endowing corresponding data management authorities to different roles. For an accounting firm, role and user definition and addition are completed through a system, and corresponding data authority management is performed through configuration of users and roles.
In one embodiment, further comprising: when a user logs in for the first time or when a guide configuration instruction is triggered, a guide configuration interface is displayed to assist the user in finishing relevant parameter setting, wherein the relevant parameter setting comprises the following steps: system basic setting, data perfection, merging range, report period, user management, currency and exchange rate, auxiliary accounting management, accounting subject and report item setting.
In one embodiment, configuring the disclosure dimension and the disclosure data format of the audit item according to a preset multi-dimensional variable form comprises configuring a comment disclosure item and a comment disclosure detail; establishing a check relation of adjustment offset entry-supplementary notes disclosure detail.
In one embodiment, further comprising: analyzing and judging the checking relationship among various report data, automatically checking risks and errors, generating a guidance prompt and guiding a user to perform manual intervention.
In one embodiment, further comprising:
performing primary cleaning on data acquired by an interface of a third-party system or a preset template through an ETL (extraction transformation Loading);
considering that audit projects depend on professional ability of accountants, the system provides a standing book management platform to enable the accountants to perform secondary data cleaning. Providing a secondary data cleaning interface by embedding an online spreadsheet, and finishing the steps of carrying out secondary processing on data and automatically generating, combining and offsetting entries; the merge cancellation entry includes: profit offset, current reclassification, current offset, fair value report adjustment, equity offset and profit-loss offset are not realized inside.
In one embodiment, further comprising: and each project group sets the exchange rate according to the project, generates a single original currency audit report and a combined local currency combined report, and can also automatically generate multi-dimensional chart data analysis.
In one embodiment, multi-dimensional chart data analysis is automatically generated according to the data of the steps S3 to S5, and the data of the steps S3 to S5 is subjected to summarizing, offsetting and combining analysis.
As shown in fig. 4, the second aspect of the present invention also discloses an automatic generation system of single and merged audit reports according to the first aspect, comprising:
and the system management module is used for maintaining the audited units and the audit items according to the setting instructions, determining the merging range of the items, receiving the merging range change instructions in real time and correspondingly changing the merging range. The system management module is also used for determining user and role setting; and (4) building and recombining a management accounting mode according to a module style according to the management requirements under the support of a legal person main body.
A data management module, as shown in fig. 5, configured to obtain an unexamined accounting document or a subject balance table of an audited unit by interfacing with an interface of a third-party system or a preset template, and generate an unexamined report meeting a report specification through a preset specification processing logic; configuring the disclosure dimension and the disclosure data format of an audit project according to a preset multi-dimensional variable form;
the account book management module is used for acquiring data through an interface or importing the data as shown in fig. 6, providing professional judgment for an accountant by the system, adjusting an entry template and combining and offsetting the entry template according to a preset monomer, performing secondary processing on the data, and automatically generating a monomer adjustment entry and combining and offsetting an entry for an unexamined accounting voucher or a subject balance table of an audited unit; fig. 9 shows an example of statistical data of a subject balance table of an audited unit in a merging range, and fig. 10 shows a specific example of a single adjustment entry template and a merging offset entry template.
A financial report module, as shown in fig. 7, configured to synchronize account adjustment data to a single TB table and a merged TB table, and automatically generate an approved single report and a merged report; after the single TB table and the combined TB table are finished, automatically generating a single note attached transition table and a combined note attached transition table, and further automatically generating an approved single note attached electronic table and a combined note attached electronic table; and automatically generating single financial reports and combining financial reports according to the form documents configured by the project group. Wherein the financial report includes: report and note of report
In one embodiment, further comprising:
the guidance configuration module, as shown in fig. 8, is configured to, when a user logs in for the first time or when an instruction of guidance configuration is triggered, display a guidance configuration interface to assist the user in completing relevant parameter setting, where the relevant parameter setting includes: system foundation setting, data perfection, merging range, report cycle, user management, currency and exchange rate, auxiliary accounting management, accounting subject and report item setting; and/or the presence of a gas in the gas,
and the analysis and judgment module is used for analyzing and judging the checking relationship among various report data, automatically checking risks and errors, generating a guidance prompt and guiding a user to perform manual intervention.
In one embodiment, the system further comprises a basic setting module, which is used for each project group to set exchange rate, report period, disclosure dimension and disclosure data format according to the condition of the project.
In one embodiment, the system provides a data storage space, an accountant can conveniently store the audit work manuscript according to the characteristics of the project, and the permission isolation is set, so that the manuscript is ensured to be only open to the personnel with permission to read.
In one embodiment, the system further comprises an analysis module used for automatically generating multi-dimensional chart data analysis aiming at the data of the standing book management module and the financial report module.
The method and the system for automatically generating the single audit report and the merged audit report provided by the invention are described in detail, a specific example is applied in the embodiment to explain the principle and the implementation mode of the invention, and the description of the embodiment is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined in this embodiment may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended 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 (10)

1. A method for automatically generating single and combined audit reports is characterized by comprising the following steps:
maintaining the audited unit and the audit item according to the setting instruction, determining the merging range of the audited unit, receiving the merging range changing instruction in real time, and correspondingly changing the merging range;
obtaining an unexamined accounting voucher or a subject balance table of an audited unit by butting an interface of a third-party system or a preset data import template, performing preset standard processing logic, performing report item mapping setting, configuring disclosure dimensions and disclosure data formats of audit items according to a preset multi-dimensional variable form, and automatically generating a single-body unexamined report;
according to a preset monomer adjustment entry template, performing monomer adjustment entry on the monomer unexamined report to generate a monomer TB table and a monomer supplementary notes transition table, and further automatically generating a monomer examined report and a examined monomer supplementary notes;
automatically generating manuscript data of a merging layer for the monomer audited reports of the audited units in the merging range according to a preset merging offset entry template, then automatically generating merging offset entries, automatically generating a unified account adjustment entry data summary table according to automatic certificates and manual adjustment certificates, synchronizing to a merging TB table and a merging remark transition table, and further automatically generating the audited merged reports and merging remarks of the reports;
the monomer adjustment entry template and the combination offset entry template set the calculation logic of the unexamined accounting document or the subject balance sheet according to preset data of the asset liability statement, the profit sheet and the cash flow sheet;
and automatically generating a single financial report and a combined financial report according to the logical mapping of the disclosure contents of the single TB table, the combined TB table, the examined single remark and the combined report remark configured by the project group.
2. The method of automatically generating a monolithic and consolidated audit report according to claim 1 and further comprising: and according to an accounting mode management instruction sent by an executed unit, building and recombining a corresponding module style for the accounting mode.
3. The method for automatically generating audit reports on-board and merged according to claim 1, further comprising the step of setting users and roles: and configuring roles for the user, wherein different roles are endowed with corresponding data management authorities.
4. The method of automatically generating a monolithic and consolidated audit report according to claim 1 and further comprising: when a user logs in for the first time or when a guide configuration instruction is triggered, a guide configuration interface is displayed to assist the user in completing relevant parameter setting, wherein the relevant parameter setting comprises the following steps: system basic setting, data perfection, merging range, report period, user management, currency and exchange rate, auxiliary accounting management, accounting subject and report item setting.
5. The method for automatically generating individual and combined audit reports according to claim 1 wherein configuring the disclosure dimensions and disclosure data formats of audit items according to a preset multidimensional variable form includes configuring remark disclosure items, remark disclosure details; establishing a check relation of adjustment offset entries-remarks and disclosure details.
6. The method of automatically generating a monolithic and consolidated audit report according to claim 5 further comprising: analyzing and judging the checking relationship among various report data, automatically checking risks and errors, and generating a guidance prompt.
7. The method of automatically generating a monolithic and consolidated audit report according to claim 1 further comprising:
performing primary cleaning on data acquired by an interface of the third-party system or a preset template through an ETL (extraction transformation Loading);
providing a secondary data cleaning interface by embedding an online spreadsheet, and completing the steps of secondary processing of data and automatically generating, merging and offsetting entries; the merge offset entry includes: within the merging range, profit offset, forward reclassification, forward offset, fair value report adjustment, equity offset and profit and loss offset are not realized.
8. The method of automatically generating a monolithic and consolidated audit report according to claim 1 and further comprising: and setting exchange rates according to different project groups, and generating a single original currency audit report and a combined local currency combined report.
9. An automatic generation system of single and merged audit reports according to the automatic generation method of single and merged audit reports of any of claims 1-8, comprising:
the system management module is used for maintaining the audited units and the audit items according to the setting instructions, determining the merging range of the items, receiving the merging range changing instructions in real time and correspondingly changing the merging range;
the data management module is used for acquiring an unexamined accounting document or a subject balance list of an audited unit by butting an interface of a third-party system or a preset template, and generating an unexamined report meeting report specification through a preset specification processing logic; configuring the disclosure dimension and the disclosure data format of an audit project according to a preset multi-dimensional variable form;
the standing book management module is used for automatically generating a single body adjustment entry and a combined offset entry for the unexamined accounting voucher or the subject balance table of the audited unit according to a preset single body adjustment entry template and a combined offset entry template;
the financial report module is used for synchronizing the account adjustment data to the single TB table and the combined TB table and automatically generating an examined single report and a combined report; after the single TB table and the combined TB table are finished, automatically generating a single note attached transition table and a combined note attached transition table, and further automatically generating an approved single note attached electronic table and a combined note attached electronic table; and automatically generating a single financial report and a combined financial report according to the form document configured by the project group.
10. The system for automated generation of singulated and merged audit reports according to claim 9 further comprising:
the guidance configuration module is used for displaying a guidance configuration interface when a user logs in for the first time or when a guidance configuration instruction is triggered, and assisting the user to complete related parameter setting, wherein the related parameter setting comprises the following steps: system foundation setting, data perfection, merging range, report period, user management, currency and exchange rate, auxiliary accounting management, accounting subject and report item setting; and/or the presence of a gas in the gas,
and the analysis and judgment module is used for analyzing and judging the checking relationship among various report data, automatically checking risks and errors and generating a guidance prompt.
CN202211055469.6A 2022-08-29 2022-08-29 Automatic generation method and system for single and combined audit reports Pending CN115423587A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211055469.6A CN115423587A (en) 2022-08-29 2022-08-29 Automatic generation method and system for single and combined audit reports

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211055469.6A CN115423587A (en) 2022-08-29 2022-08-29 Automatic generation method and system for single and combined audit reports

Publications (1)

Publication Number Publication Date
CN115423587A true CN115423587A (en) 2022-12-02

Family

ID=84201001

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211055469.6A Pending CN115423587A (en) 2022-08-29 2022-08-29 Automatic generation method and system for single and combined audit reports

Country Status (1)

Country Link
CN (1) CN115423587A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116861880A (en) * 2023-09-04 2023-10-10 北京至臻云智能科技有限公司 Digital technology-based electronic audit report generation method and device

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116861880A (en) * 2023-09-04 2023-10-10 北京至臻云智能科技有限公司 Digital technology-based electronic audit report generation method and device

Similar Documents

Publication Publication Date Title
US6477510B1 (en) Euro booking currency conversion method
US9830366B2 (en) Online analytic processing cube with time stamping
CN103903081B (en) The method and system of concerning taxes voucher is generated using the concerning taxes bills data in ERP system
CN103426070B (en) Compilation method and device of group combined financial statement
US20220101449A1 (en) Processing apparatus having a reference identification tied to a locked entry
CN103440557A (en) Generation method and system for group consolidated accounts and consolidated statements
WO2019134231A1 (en) Method and device for managing summarized tax declaration, terminal device, and storage medium
CN107767005A (en) Profit flow table injustice checking method and system based on bookkeeping voucher
CN110147365B (en) Method, device, equipment and medium for checking business data and financial data
CN107492032A (en) A kind of business financial auditing reports management system and its database platform
CN110458674A (en) A kind of method and system generating bookkeeping voucher
US20060253372A1 (en) Consolidated accounting
CN110992158A (en) Financial voucher management system
CN115423587A (en) Automatic generation method and system for single and combined audit reports
CN115760460A (en) Financial robot financial management system
CN113657846A (en) Enterprise fund management method and system in financial sharing mode
CN111178826A (en) Consumption financial risk management method based on block chain and cloud platform
CN102521776A (en) Method for performing financial analysis on accounting entry
CN101122991A (en) The fourth generation finance core business system systematic structure and intelligent financial accounting method
CN114742634A (en) Method and device for processing data of same-industry deposit receipt and electronic equipment
CN103310372A (en) Method and system of extracting finance system data for taxation adjusting data processing
JP4570302B2 (en) Commercial law accounting document creation system, consolidated financial statement creation system, and commercial law accounting document creation processing program
CN112613960A (en) Real estate land increment tax clearing method and system based on bill information
Hashim et al. Core Functional Requirements for Fiscal Management Systems
US20140058925A1 (en) Apparatus, method and article to automate and manage formula or asset-based lending in a networked environment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination