WO2021227444A1 - Accounting report generation method and apparatus, and electronic device - Google Patents

Accounting report generation method and apparatus, and electronic device Download PDF

Info

Publication number
WO2021227444A1
WO2021227444A1 PCT/CN2020/132103 CN2020132103W WO2021227444A1 WO 2021227444 A1 WO2021227444 A1 WO 2021227444A1 CN 2020132103 W CN2020132103 W CN 2020132103W WO 2021227444 A1 WO2021227444 A1 WO 2021227444A1
Authority
WO
WIPO (PCT)
Prior art keywords
accounting
information
report
control
items
Prior art date
Application number
PCT/CN2020/132103
Other languages
French (fr)
Chinese (zh)
Inventor
周均
周志臻
周小英
Original Assignee
长沙华山信息技术有限公司
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 长沙华山信息技术有限公司 filed Critical 长沙华山信息技术有限公司
Publication of WO2021227444A1 publication Critical patent/WO2021227444A1/en

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/183Tabulation, i.e. one-dimensional positioning

Definitions

  • This application relates to the technical field of accounting intelligence, and more specifically, to a method and device for generating accounting statements, and an electronic device.
  • the current accounting subject is a non-resource business information coding method that does not consider the direction of borrowing and lending and adopts a serial arrangement. Since its coding is not resourceful, it is not shared and controllable; the current business documents are still derived from the manual era , The first person (business personnel) and all accounting subjects have not yet established complete business documents that can be opened and controlled, and the related business documents have not established a data chain connection, resulting in the ignorance of the business man-machine; The accounting at the end of the period and the end of the period are all based on uncontrollable business information codes, business documents, and accounting vouchers. The balance sheet and income statement are based on the period-end accounting settlement, and the cash flow statement is based on the balance sheet.
  • the purpose of this application is to provide a method and device for generating accounting statements, an electronic device, and a computer-readable storage medium, which can manage and control system data before and after in a logical way, and detect the system in real time in the form of normalized statements.
  • the data ensures the correctness of the data, so that the accounting statements have the function of normalization, timeliness and intelligent error detection and reporting.
  • this application provides a method for generating accounting statements, including:
  • the calculation relationship between the taskbar information of the report template is calculated to generate the target accounting report.
  • the prior control strategy is set in advance for the general ledger account: attribute setting tabulation, bill column activation tabulation, expansion and fine-tuning tabulation setting, business information association tabulation setting, business information special control setting tabulation, Set up tabulations for business information self-control, set up tabulations related to the balance sheet, set up tabulations related to the income statement, and set up tabulations related to the cash flow statement.
  • the error item is an item added to the cash flow table for recording system data errors
  • the adjustment item is an item added to the cash flow table for offsetting the repeated data collection of error items
  • the normal item is an item added to the cash flow statement for the cash flow statement to generate reports in a timely manner in any time period.
  • the use of the prior control strategy to manage and control the accounting element data in the value assignment process to generate fully controlled accounting informatization documents includes:
  • Pre-control and post-check the business information assigned on the accounting informatization documents by using the association, exclusive control, and self-control relationships of business information to generate the fully controlled accounting informatization documents.
  • the scheduling command command for generating the accounting report includes the selection information of the target accounting report and its type, and the start and end time of the report.
  • the post-control strategy includes business information association relationship logic detection items, business information specific control relationship logic detection items, business information self-control relationship logic detection items, data link information documents and amount detection items, data link information documents And quantity detection items, and cash flow detection items; the ex-post control strategy is also used to detect the accounting books and the target accounting statements.
  • it also includes:
  • a list of various types of document error information is generated to provide support for evaluating and correcting system data errors.
  • the process of generating the accounting statement includes:
  • Receive selection instructions designed for the items in the upper title bar of the accounting statement, and establish the command and dispatch relationship between each item selection instruction and various related accounting general ledger accounts;
  • the setting instruction is used to set the report task bar item as a collection item or a calculation item;
  • the collection item is used to realize the mapping conversion between the account book index and the report index The calculation relationship, the calculation item is used to realize the calculation and reorganization of the collection item and its own information in the report task bar;
  • the accounting report is generated in combination with the upper title bar, the task bar, and the lower title bar.
  • this application provides an accounting statement generating device, including:
  • the pre-control module is used to determine the pre-control strategy used to detect and control the data in the data assignment process
  • the data assignment module is used to obtain the accounting element data assigned by the user, use the prior control strategy to control the accounting element data in the assignment process, and generate fully controlled accounting information documents;
  • the data mapping module is used to map the document index information corresponding to the fully controlled accounting informationization document to the pre-designed accounting book, and establish the collection items of various accounting report task columns and various accounting general ledger account book indicators Mapping conversion calculation relationship;
  • the post-control module is used to determine the post-control strategy, and use the post-control strategy to re-check the accounting informationized documents and accumulated account book index information mapped to the accounting book, and correct the system according to the detection result The data is wrong, and the corrected accounting book information is obtained;
  • the report generation module is used to receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, and retrieve the corresponding account book index information from the corrected accounting book information according to the report generation command and map it to the accounting report template , And obtain the calculation relationship between the task bar information of the accounting statement template, and calculate and generate the target accounting statement.
  • an electronic device including:
  • Memory used to store computer programs
  • the processor is used to implement the steps of any of the aforementioned methods for generating accounting statements when the computer program is executed.
  • the present application provides a computer-readable storage medium with a computer program stored on the computer-readable storage medium, and when the computer program is executed by a processor, any one of the accounting report generation methods disclosed above is implemented A step of.
  • the method for generating accounting statements includes: determining a pre-control strategy for detecting and controlling data in the data assignment process; obtaining user-assigned accounting element data, and using the pre-control The strategy controls the accounting element data in the value assignment process to generate fully controlled accounting informatization documents; mapping the document index information corresponding to the fully controlled accounting informatization documents to pre-set accounting books; Determine the post-event control strategy, and use the post-event control strategy to re-check the accounting information documents and accumulated account book index information mapped to the accounting books, correct the system data errors according to the detection results, and get the post-correction
  • the accounting book information receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, according to the report generation command, retrieve the corresponding accounting book index information from the corrected accounting book information and map it to the accounting report template , And obtain the calculation relationship between the task bar information of the accounting statement template, and calculate and generate the target accounting statement.
  • this application can detect and control the accounting element data in the process of assigning it, and can check the data again based on the post-control strategy to avoid data errors. It can also automatically retrieve the corresponding information after receiving the report generation instruction In relation to calculation, the target accounting report is generated intelligently and automatically to ensure the correctness of the accounting report data, so that the accounting report has the function of normalization, timeliness and intelligent error detection and reporting.
  • the application also discloses an accounting statement generating device, an electronic device and a computer-readable storage medium, which can also achieve the above technical effects.
  • Figure 1 is a flowchart of a method for generating accounting statements disclosed in an embodiment of the application
  • Figure 2 is a block diagram of an accounting report generating device disclosed in an embodiment of the application.
  • Figure 3 is a simplified structural diagram of an accounting report generation system disclosed in an embodiment of the application.
  • FIG. 4 is a detailed structural diagram of an accounting report generation system disclosed in an embodiment of the application.
  • FIG. 5 is a structural diagram of an electronic device disclosed in an embodiment of the application.
  • Fig. 6 is a structural diagram of another electronic device disclosed in an embodiment of the application.
  • Any type of accounting book is composed of "Accounting General Ledger + Level 2 Subsidiary Ledger + Level 3 Subsidiary Ledger + Level N Subsidiary Ledger”, among which "Accounting General Ledger” is indispensable, and "Level 2 to N Level” subscribing accounts are based on The “Accounting General Ledger+Second-Level Subsidiary Ledger+Third-Level Subsidiary+N-Level Subsidiary Ledger” constitutes the specific “Business Information”.
  • the current method of string arrangement does not consider the direction of borrowing and lending of the general ledger, but uses its general ledger title as the starting point to list all levels of subheadings level by level, so that the general ledger subjects and subheads of all levels are mixed into one structure. Tandem business information coding method based on hierarchical membership.
  • Tandem is a purely coding method. With such a tiny pattern as hens and chicks, the limited tandem does not have the concept of resources to control all levels of sub-items. Tandem business information must be symmetric in the direction of lending and borrowing.
  • the salary N in the department and each link, the target salary to be audited by the relevant department is 1, but because the accounting subjects and sub-heads are not resource-based management, the string codes in each department and each link of the accounting general ledger have no commonality , The object of the audit becomes N. Because N is an unknown variable, neither the human brain nor the system can accurately complete the audit work, as are other things (such as taxes, depreciation, etc.).
  • the invention adopts the resource method: taking into account the direction of borrowing and lending the accounting general ledger, resource management is carried out at all levels of the accounting subjects, so that the accounting subjects lose the subordinate relationship of the upper and lower levels. For this reason, I have to use the special accounting general ledger As a "control item", the resource expands its lending direction to the second and lower sub-items infinitely symmetrically and asymmetrically. In order to make the control item better and more convenient and personalized, choose its lending direction to the second and lower related sub-items.
  • the limited resources are managed in a well-known and well-known way by man-machine consensus, and the well-known resources are freely combined according to management requirements to form enterprises and institutions.
  • the various types of business information of the unit make the massive inexhaustible business information under the control of limited resources.
  • the amount of compensation business information is the product of accounting levels, but the compensation category is subject to centralized management "namely: payable
  • the credit of employee compensation the sum of the debits of salary expenses in more than ten accounting general ledger accounts"; taking salary as an example, the wages in the employee compensation subject should correspond to the various departments and links of more than ten accounting general ledger accounts.
  • the wages of the relevant departments are to be audited by the relevant departments.
  • the wages are the same resource code in each department and each link of the accounting general ledger, so the audit is The object also becomes the same object, so the human brain and the system can accurately complete the audit work, as do other things (such as taxes, depreciation, etc.).
  • the embodiment of the application discloses a method for generating an accounting statement. As shown in FIG. 1, the method for generating an accounting statement disclosed in the embodiment of the application includes:
  • S101 Determine the prior control strategy used to detect and control the data in the data assignment process
  • a prior control strategy can be set in advance for detection and management during the data assignment process.
  • the above-mentioned pre-control strategy is set in advance for the general ledger accounts: attribute setting tabulation, bill column activation tabulation, expansion and fine-tuning tabulation setting, business information association tabulation setting, business information special control setting tabulation, business information Set up tabulation for self-control, set up tabulation in association with balance sheet, set up tabulation in association with income statement, and set up tabulation in association with cash flow statement.
  • association control tables are set in the editor of each accounting general ledger account, so as to enable the bill activation, account expansion, informationized document generation and circulation, business information association, and special control. , Self-control relationship, accounting statement collection items and accounting titles and accounting book index items retrieval calculation relationship for prior control management.
  • the expansion, fine-tuning, association, special control, self-control, documents, circulation, and mapping relations of each accounting general ledger account are set in the system in advance as the pre-control items: 1
  • the expansion and fine-tuning of accounting The management objects are classified and coded in segments, and various specific independent resources are assigned a unique code and collected into the corresponding category for management. Each category can be used as a group expansion item, and each independent resource can be used as a fine-tuning expansion item. Resource as a control item.
  • other resources are divided into symmetrical or asymmetrical combination of borrowing and lending directions into unlimited expansion of business information in various accounting general ledger subjects according to management requirements.
  • association of business information means that A business information must produce B business information. This is association, which means "if you have me, there must be an effect, if there is a cause, there must be an effect, and if there is an effect, there must be a cause.”
  • the management objects of accounting in the system are independent resources, and various resources are composed of infinite business information according to management requirements by control items. Because of the independence of resources, there is a human-machine consensus and it provides human-machine management business information.
  • the specific thing is to set in the system to use A accounting general ledger account combined with its debit or credit as the main control item to control the use of B accounting general ledger debit or credit secondary and tertiary sub-purposes, at this time B accounting general ledger combined
  • the debit or credit three-level sub-items constitute the accused item, and the accused item must look for the main control item.
  • the same level mutual control and cross mutual control of its main controlled business information can be set; example association
  • the specific application of the relationship, the salary category is to be managed centrally. Theoretically speaking, the cost and salary accrued by various business departments at all levels should be centralized under the unified management of the "Employee Salary Accounting General Ledger".
  • the employee salary accounting The credit of the general ledger account and the debit of the various types of compensation accounting general ledger accounts form an association relationship, and then take the correlation relationship of the salary category under the sales expense as an example.
  • the specific operation is to use "the credit of the employee compensation account "Control item” to control the use of "specific secondary sub-items and three-level salary category sub-items of the debit of the sales expense accounting general ledger", of course, at this time "debits of the sales expense accounting general ledger account and three-level salary category sub-items" constitute After the controlled item is set up, the same level mutual control and cross mutual control relationship can be set for the two mutually controlled business information after the master is set up; the system uses this to perform accounting informationization documents in the valuation process or in the system.
  • the special control of business information is to combine the "special control sub-item and the accused sub-item" with the designated accounting general ledger account.
  • the borrower and the lender or the lender or both parties to the special control level form the special control business information, which is specifically divided into two types: special control sub-items, special control and accused sub-items.
  • the debit and creditor of the general ledger or both the borrower and the lender to the special control level form special control business information, and the system uses this to perform special control on the accounting information documents that exist in the valuation process or in the system.
  • the special control of the accused sub-item is to combine the debit, lender, or both of the borrower and the lender of the accused sub-item and the designated accounting general ledger to the special control level to form special control business information, and the system uses this pair of accounting information in the valuation process or in the system.
  • the system uses "specially controlled sub-items, accused sub-items" to perform unlimited centralized management and indicator sub-items. Accurately locate and manage, to achieve centralized management and index sub-items, there must be places, and there must be no places where they are not.
  • the specialized-controlled sub-item and the accused sub-item can only constitute the specialized control business information and the accused business information, and the purpose is It is to strengthen the special control management of the "centralized management and index sub-items" in the system; 4
  • the self-control of business information is to combine the specific accounting general ledger items with the borrower, the lender or the borrower as a self-control item to control the secondary and secondary
  • the following sub-headings are used to carry out the secondary management and control of the different target directions, and also to reclassify the self-control business information of the set expansion items.
  • the system uses this to perform the accounting informationization documents in the evaluation process or in the system.
  • Self-control items are non-self-control business information exclusive pre- and post-test, otherwise an error will be reported; for example, an enterprise has a first-level accounting general ledger account for "internal transactions". Divided into "administrative department, production department, sales department, and other departments, Zhang San, Li Si, Wang Wu, and other individuals” departmental personnel mixed N multiple detailed accounting; in order not to make the second-level “departmental exchanges” followed by the third-level " "Personnel”, and in order not to cause the error of the second-level "personal contact” followed by the third-level "department", we have implemented two types of automatic control systems for the "internal transactions" first-level accounting general ledger, one of which is "internal transactions".
  • the control relationship between subject and bill column activation form, a complete accounting information document must be borrowed The direction is designed with more than N information entry columns.
  • the control relationship mentioned here refers to the setting of a certain accounting general ledger account that can be assigned to the debit and credit of various accounting information documents, or the first-level column of the borrower and the lender, that is, a certain accounting general ledger account.
  • the currency column and the comprehensive column are used to collect target information; such as current subjects
  • the second and third levels of the borrowing direction are the same.
  • the expansion assignment can be constituted on the circulation column.
  • the data link in the form of "receivables and receipts and receipts and receivables", and for expense accounts, the lending directions of the second and third levels are different. Expansion assignments can only constitute "receivables and receivables" in the circulation column.
  • a data link in the form of receipts and receivables" or “receivables and receipts and receipts"; 7 The relationship between accounting general ledger accounts and accounting statements is set up to form a table.
  • the accounting statement information is derived from the accounting book, but the statement Projects are not completely equivalent to accounting items.
  • one or more accounting items are integrated into one or more accounting statement information.
  • Accounting statements are divided into balance sheet profit performance gold flow statements, etc., in order to enable the system Analyze and process the relationship between accounting books and accounting statement information, design various accounting statement taskbar items as "collection items, calculation items", and then map various collection items to all accounting general ledger accounts for setting up and calculating specific accounting The relationship between general ledger account book indicators and specific accounting statement indicators.
  • the calculation items are used to calculate and reorganize the collection items mapped back by the accounting books and their own information to generate target accounting statements.
  • S102 Obtain the accounting element data assigned by the user, and use the prior control strategy to manage and control the accounting element data in the value assignment process to generate fully controlled accounting informationized documents;
  • the accounting element data in the user assignment process is obtained, and the data assigned by the current user is detected and controlled based on the foregoing prior control strategy.
  • use the accounting general ledger account as a control item to control the symmetrical or asymmetrical unlimited expansion and fine-tuning of the sub-purposes of the second and lower borrowing direction; you can use the bill column activation table set by various accounting general ledger subjects to control various accounting Assignment of accounting general ledger accounts for various columns on informationized documents; use specific accounting general ledger accounts assigned in any column on accounting informationized documents to control the assignment of secondary and lower sub-items of any column; use accounting informatization The first, second and third level subjects assigned in the circulation column on the receipt control the flow of the data link, which are divided into the same level 1, 2, and 3 subjects to realize the flow of the data link and different levels 1, 2, and 3 subjects to block the flow of the data link; use business information The relationship of association, special control, and self-control performs pre-control and post-testing on the business information assigned on
  • a complete accounting information document generally has more than N borrowing and lending direction information collection columns, and a column is divided into more than N sub-heading information entry points from the accounting general ledger account to the second level and below.
  • the same set of business accounting information documents generated in different periods, different links and different processes constitute a human-machine consensus data chain due to commonality; use the bill column activation table set up by various accounting general ledger accounts to control various types of accounting information documents Assignment of column accounting general ledger titles; use the specific accounting general ledger title assigned in any column of the accounting informationization document to control the assignment of the second and lower sub-items of any column; use the first of the circulation column assignment on the accounting informationization document Level two and three subjects control the flow of the data link, divided into the same level one, two and three subjects to realize the flow of the data link and different levels one, two and three subjects to block the flow of the data link; use the association, special control, and self-control relationship of business information Perform pre-control and post-test on the business information assigned on the accounting information documents
  • the design consists of "sales order, invoice, acceptance order, transfer order, material picking order, authorization order, entrusted order, loss and overflow order, special collection order, special payment order, payment order, receivable order, payment "Orders, payables, etc.” respectively constitute the circulation and association relationship of the data link.
  • the specific column assignments on the specific accounting informationization documents are controlled by the specific accounting general ledger accounts to realize the control of the entry relationship between the accounts and the documents, and the specific business is the main control item or the accused item to control and achieve "I “There must be you, there must be results, and there must be results” centrally manage the related control of business information, and use “special control sub-items and accused sub-items” combined with specific accounting general ledger items to form a special control project.
  • To control the generation of non-exclusively controlled business information and non-accused business information in the system so that there must be places where the controlled sub-items should have, and there must be no place where there must be no special control over business information.
  • the second level and the lower level are differentiated and targeted to achieve the self-control control of business information.
  • the first, second and third level account control is used to assign values to the circulation column on the accounting information document.
  • the circulation of the data link is divided into the same one, two and three subjects to realize the flow of the data link and different subjects at the first, two and three levels to block the flow of the data link, to generate fully controlled accounting information documents, and to achieve the daily economic information It is directly refined into accounting indicators to provide support for man-machine consensus and accounting intelligence.
  • first design such as "cash account, bank account, comprehensive account, advance account, contract account, payment account, business account, storage account, consignment account, manufacturing account, cost account, pending account" in the system.
  • Twelve types of intelligent accounting books are used to receive the amount and quantity analysis information mapped from various accounting information documents;
  • S104 Determine a post-control strategy, and use the post-control strategy to re-check the accounting information documents and accumulated account book index information mapped to the accounting books, and correct system data errors according to the detection results to obtain Corrected accounting book information;
  • the aforementioned post-control strategy may include, but is not limited to, business information association relationship logic detection items, business information specific control relationship logic detection items, business information self-control relationship logic detection items, data link information documents and amount detection items, data Chain informatization documents and quantity detection items, and cash flow detection items; the ex-post control strategy is also used to detect the accounting books and the target accounting statements.
  • the examples of this application automatically or non-automatically apply various pre-set post-control strategies to existing accounting informationized documents, accumulated accumulated accounting book information, and related accounting information on a regular or irregular basis. Reports are tested, and various types of document error information lists, requisition relations error information lists, account follow-up relations error information lists, and cash flow error information lists are generated to provide support for subsequent evaluation and correction of system data, thereby ensuring various accounting books The correctness of the indicator information.
  • association relationship, special control relationship, self-control relationship and data link congregation relationship, data link ledger relationship, and cash flow statement detection relationship set for each accounting general ledger subject in this embodiment of the application have an impact on the accounting that has been formed in the system.
  • Informationized documents, accounting books, and accounting statements carry out pre- and post-event logical control and testing to ensure the correctness of the system data.
  • the current various financial software cannot achieve this control and testing function.
  • S105 Receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, retrieve the corresponding account book index information from the corrected accounting book information according to the report generation command and map it to the accounting report template, and obtain The calculation relationship between the taskbar information of the accounting report template is calculated to generate the target accounting report.
  • a report generation command issued by a business person can be received, which can specifically include, but is not limited to, the target accounting report and the type, and the selection information of the start and end time of the report.
  • Receiving and transmitting the report generation commands issued by users, the process of generating target accounting statements can specifically include: receiving selection instructions designed for the items in the upper title bar of the accounting statements, and establishing each item selection instruction and various related accounting Command and dispatch relationship of general ledger accounts; receive setting instructions for task bar items in accounting statements; setting instructions are used to set task bar items as collection items or calculation items; collection items are used to realize the mapping conversion calculation relationship between account book indicators and report indicators , The calculation item is used to realize the calculation and reorganization of the collection items in the report task bar and its own information; obtain the layout design content in the accounting statement template, and determine the lower title bar of the accounting statement based on the layout design content; combine the upper title bar, The task bar and the lower title bar generate accounting reports.
  • the cash flow statement of the accounting statement template provided in the embodiment of the application may further include error items, adjustment items, and normal items; wherein, the error items are in the cash flow statement An item added to record system data errors, the adjustment item is an item added to the cash flow table to offset the repeated collection of error items, and the normal item is an item added to the cash flow table It is used to generate a report item in the cash flow statement in any time period in a timely manner.
  • this embodiment adds error items, adjustment items, and normal items to the current idealized cash flow statement and schedule based on accounting settlement, so that the cash flow statement and schedule have any time period normalization to the system data Report function for error detection.
  • the error detection of the return relationship is to use the return code of the data link to identify the massive accounting information documents in the system, and to detect the amount of errors in the accounting information documents and accounting books caused by the serial number of the data link;
  • the error detection of the account follow-up relationship is to use the return code of the data link to identify the existing mass logistics accounting information documents in the system, the inventory account book balance accumulated by the mass logistics accounting information form and the mass logistics accounting information form The balance of the random settlement in time is compared, and the number of logistics accounting information documents and accounting books caused by the serial number of the data link and random reasons is detected.
  • the association, special control, and self-control relationship established for business information are used, the reconciliation and account follow-up relationship established for the accounting books, and the additional "error items, adjustment items, normal conditions" in the cash flow statement and the attached tables Item", to perform prior billing control and post-error detection of new and existing massive accounting informationized documents; use automatic or non-automatic error detection of system data for any period of time to defend The correctness of the accounting statements also safeguards the correctness of the system data.
  • this application can detect and control the accounting element data in the process of assigning it, and can check the data again based on the post-control strategy to avoid data errors. It can also automatically retrieve the corresponding information after receiving the report generation instruction In relation to calculation, the target accounting report is generated intelligently and automatically to ensure the correctness of the accounting report data, so that the accounting report has the function of normalization, timeliness and intelligent error detection and reporting.
  • control, self-control, and the flow of data links makes daily economic business standardized indicators, systematically design the layout of current accounting statements, and introduce error items, adjustment items, and normal items, and select command and accounting for report types and periods.
  • the general ledger accounts establish the command and dispatch relationship, and also establish the mapping conversion calculation relationship for the report indicator project and the account book indicator project design. Through the pre-control and post-test, the automatic or non-automatic regular or irregular time period is normalized. There are reports with the function of detecting and reporting errors on system data.
  • This application abandons the current financial software’s "form import, document entry (uncontrollable), direct entry of accounting vouchers" for business information, which causes errors and uncontrollable errors that cannot be determined logically.
  • Choose a fully controlled accounting Informatization documents are the only carrier to enter daily economic business information in the form of resources and to associate, control, self-control, and determine the logical relationship of circulation, so that daily economic business information can be standardized and indexed. Take financial expenses as an example.
  • the debit can always only enter the occurrence amount, and its credit can always only enter the distribution amount, so the debit or credit of the accounting book or the accumulated or accumulated balance is classified or aggregated to form a single or category but unique indicator information At this time, both the system and the human brain can simply and conveniently use the indexed information to generate accounting statements.
  • the current national tax version of the accounting statements are designed line by line into the system; the accounting statements designed into the system are divided into an upper title bar, a task bar, and a lower title bar; the upper title bar is added
  • the accounting statement designed into the system are divided into an upper title bar, a task bar, and a lower title bar; the upper title bar is added
  • the general ledger account is used to set up the calculation relationship between each accounting general ledger account and sub-items at all levels and the collection items in the relevant accounting statement task bar, so as to realize the intercommunication of accounting book indicators and accounting statement indicators. Design the title column according to the relevant accounting statements
  • this application adds error items, reconciliation items, and normal items to the cash flow statement and the attached table, which solves the problem that the previous cash flow statement and attached table need to be settled by accounting and calculated from the balance sheet, income statement, etc. If the data is not flat, the data shall be filled in by inverted squeeze method. Now it is possible to directly generate the cash flow statement and the attached tables in a normal way, and after detecting and removing the logical errors of the existing accounting information documents in the system, the balance sheet and the income statement can be generated.
  • this application can solve the problem that in the past, accounting statements could only be generated after the end-of-term accounting and settlement, and it can intercept the index data of the account books at any time period to generate accounting statements, that is, normalized statements.
  • this application first implements a symmetrical or asymmetrical unlimited expansion system for various accounting general ledger subject lending directions in the second and lower sub-items according to management requirements in the system; design various types of accounting information in the system Documents can be opened and controlled in the system for all economic business; set various accounting informationized documents related fields for various accounting general ledger items in the system and the "Enable or Not" selection of the general accounting subjects; open
  • the single-time system uses the specific accounting general ledger items assigned to the relevant general ledger fields of the accounting information documents to control the assignment of the second and lower sub-purposes of the accounting information documents; the system uses the association, special control, and self-control of the business information when issuing the bills Method to control the logical relationship of the corresponding business information on the pre-opened accounting information documents; when issuing the bill, the system uses orders, sales, issuance, capital, logistics, collection, payment, etc.
  • This application sets up the documents, fine-tuning, association, special control, self-control, and circulation relations of each accounting general ledger account in the system, as a pre-control item, fill in the resource information of each column on the accounting informationization document in the billing
  • the specified value of the resource information is fully matched with the pre-set resource information and the relationship, exclusive control, self-control, and circulation of the business information are passed, it means that the indexed document can be generated, otherwise the document Can't produce.
  • This application further generates accounting statements through the systematic design of accounting statement layouts and index mapping transmission commands. Specifically, layout the upper title bar, task bar, and lower title bar of the current accounting report, and add report options in the upper title bar, such as: annual report, quarterly report, monthly report, and previous variable period, year, month , Day and post variable period, year, month, day, design the taskbar items as collection items and calculation items; map all the collection items set up in the above steps to each accounting general ledger account for setting up each accounting general ledger account and The mapping conversion calculation relationship between the sub-item indicators at all levels and the collection items in the task bar of the relevant accounting statements, to realize the intercommunication between the accounting book indicators and the accounting statement indicators; the upper title bar, task bar, lower title bar layout and report selection items of the accounting report Types, such as: annual report, quarterly report, monthly report and pre-variable period, year, month, day and post-variable period, year, month, day and collection items, calculation items are mapped to the report calculation module; when the report is generated, in the
  • this application adds error items, adjustment items, and normal items to the current idealized cash flow statement after accounting settlement and its attached tables, so as to realize the error detection of the normalization and timeliness of the accounting statements at any time period. That is, add error items, reconciliation items, and normal items to the current idealized cash flow statement and appendix based on accounting settlement; when generating statements, call index information from the accounting book module to the statement calculation module to generate accounting statements; when When the newly-added error item and adjustment item data in the report is not zero, it means that there are error factors in the existing accounting information documents in the system. When the newly-added normal item data in the report is not zero, it is expressed as a normalized report. When the newly added error items, adjustment items, and normal item data are all zero, it means that there is no logical error after the accounting settlement.
  • this application further corrects the accounting informationization documents, accounting books, and accounting statements afterwards.
  • the association relationship, special control relationship, self-control relationship, data link reunification relationship, data link account follow relationship, and cash flow error correction relationship set for each accounting general ledger account are formed into a post-test item; the above-mentioned relationship is used for testing.
  • Step one is to carry out index-based pre-control of daily economic business, that is, to fine-tune the expansion of accounting subjects, to control the relationship of business information, and to control the relationship of exclusive control and self-control of business information;
  • the fine-tuning of accounting subjects is to deactivate individual sub-items in the group project for the set expansion items, or use fine items to add individual sub-items to achieve symmetry of the expansion items at the second level and below.
  • 2 The association of business information means that A business information must produce B business information.
  • "Because" the accounting management objects in the accounting intelligent system are independent resources, and various resources are composed of control items according to management requirements to form infinite business information. Because of the independence of resources, there is a consensus between man and machine.
  • It provides a manipulator for man-machine management business information; specifically, it is set in the system to use A accounting general ledger account combined with its debit or credit as the main control item to control the use of B accounting general ledger debit or credit secondary and tertiary sub-purposes.
  • B Accounting General Ledger Section combines its debit or credit three-level sub-items to form the accused item, the accused item must look for the main control item. After setting the main charge, it can set the same level of mutual control and control of its main charge business information.
  • the specific application of the association relationship the salary category should be managed centrally, and the cost and salary accrued by various business departments at all levels should theoretically be centralized under the unified management of the "Employee Salary Accounting General Ledger Account”.
  • the specific operation is to "employee compensation accounting general ledger "Credit" is used as the "main control item” to control the use of "Debit specific secondary sub-items and three-level salary category sub-items of the general ledger of sales expense accounting".
  • Category sub-item constitutes the controlled item.
  • the two mutually controlled business information can be set up with the same level mutual control and cross mutual control relationship; the system uses this pair in the process of assigning value or has already existed in the system.
  • the accounting informationization documents of the company are tested before and after the existence of related items constitute "the establishment of the master and the accused,"
  • the debit and creditor or both the borrower and the lender of the designated accounting general ledger account form the special control business information, which is specifically divided into two types: special control sub-items, special control and accused sub-items.
  • Business information and non-accused business information are exclusively tested before and after, otherwise an error will be reported
  • the accused sub-item special control is to combine the accused sub-item and the debit and lender of the designated accounting general ledger account to the special control level to form special control business information
  • the system uses this to perform pre- and post-detection of the non-specific control business information and non-accused business information of the accused sub-items during the valuation process or the existing accounting information documents in the system, otherwise it will report an error;
  • the system uses the "special-control sub-items" "Accounted sub-items" carry out unlimited and precise positioning management of centralized management and index sub-items to achieve centralized management There must be places where management and indicator subheadings should exist,
  • any accounting sub-item can be set as "specially controlled sub-item and accused sub-item", and the exclusively-controlled sub-item and the accused sub-item can only constitute the specialized control business information and the accused business information. The purpose is to strengthen the control of the system.
  • the self-control of business information is to combine specific accounting general ledger items with its borrower, lender, or both parties as a self-control item to make differences between the sub-items used at the second and lower levels
  • the secondary management and control of the specific target direction is also the reclassification of the self-control business information of the set expansion items.
  • the system uses this to perform the self-control item non-self-control business information on the accounting information documents that exist in the value assignment process or in the system Exclusive pre- and post-test, otherwise an error will be reported; for example, an enterprise has an "internal transaction" first-level accounting general ledger account.
  • Step 2 Introduce "the influence of error factors on cash flow, adjustment of error factors, and normalization of supplements" to the idealized cash flow statement and attached tables;
  • the idealized cash flow statement and attached tables includes: introducing the influence of error factors on cash flow in the idealized cash flow statement and attached tables, adjusting the items of error factors, realizing the completeness of statement information and error detection; and attaching to the cash flow attached statement based on period-end accounting and settlement. Introduce normalized supplementary items to make it have the function of normalized report;
  • Step three in order to ensure the accuracy of accounting informationization documents, accounting books, and accounting statements, establish a post-test module for the system;
  • the establishment of data link information documents and quantity testing (accounts with method) project the influence of error factors in the cash flow statement and attached tables on cash flow and the adjustment of error factors to establish a "gold flow detection project; Together to form a post-detection module for error detection of system information:
  • Step four systematically design the layout of accounting statements
  • the following describes an accounting statement generating device provided in an embodiment of the present application.
  • the accounting statement generating device described below and the accounting statement generating method described above can be cross-referenced.
  • an accounting statement generating device provided by an embodiment of the present application includes:
  • the advance control module 201 is used to determine the advance control strategy used to detect and manage the data in the data assignment process
  • the data assignment module 202 is used to obtain the accounting element data assigned by the user, use the prior control strategy to control the accounting element data in the assignment process, and generate fully controlled accounting information documents;
  • the data mapping module 203 is used to map the document index information corresponding to the fully controlled accounting informationization document to a pre-designed accounting book, and collect items for various accounting report task columns and various accounting general ledger account book indicators Establish the mapping conversion calculation relationship;
  • first design such as "cash account, bank account, comprehensive account, advance account, contract account, payment account, business account, storage account, consignment account, manufacturing account, cost account, pending account" in the system.
  • Twelve types of intelligent accounting books are used to receive the amount and quantity analysis information mapped from various accounting information documents, and then divide the taskbars of various accounting statements into collection items and calculation items in the system, Projects are all mapped to the editing office of various accounting general ledger accounts, which are used to establish the specific conversion calculation relationship between various accounting general ledger account book indicators and various accounting statement indicators;
  • the post-control module 204 is used to determine the post-control strategy, and use the post-control strategy to re-check the accounting informationized documents and the accumulated account book index information mapped to the accounting book, and correct the system data according to the detection result Error, get the corrected accounting book information;
  • the report generation module 205 is used to receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, and retrieve the corresponding account book index information from the corrected accounting book information according to the report generation command and map it to the accounting report.
  • the template the calculation relationship between the task bar information of the accounting report template is obtained, and the target accounting report is calculated and generated.
  • the system includes an accounting general ledger account module, that is, a pre-control module; an accounting informationization document module; an accounting book module; and a report design module ; Report calculation module; post-detection module.
  • an accounting general ledger account module that is, a pre-control module; an accounting informationization document module; an accounting book module; and a report design module ; Report calculation module; post-detection module.
  • the accounting general ledger account module set up a system for each general account ledger: attribute setting tabulation, expansion and fine-tuning tabulation, bill column activation tabulation, business information association tabulation, business information special control tabulation, Self-control of business information tabulation, tabulation associated with the balance sheet, tabulation associated with the income statement, tabulation associated with the cash flow statement, thereby enabling bill activation, account expansion, informatization document generation and circulation, and business Information association, special control, self-control relationship, accounting statement collection project and accounting title and accounting book index project retrieval calculation relationship for prior control management.
  • Accounting informatization bill module using the bill column activation table set by various accounting general ledger accounts to control the assignment of various accounting general ledger accounts on various accounting informatization documents, and using the specific accounting general ledger assigned in any column on accounting informatization documents
  • Assign values to the second and lower sub-objects of any column in the account control use the first, second and third levels assigned in the circulation column on the accounting information document to control the flow of the data link, and divide the data into the same one, two and three subjects to achieve data
  • the circulation of the chain and different one, two and three levels of subjects block the circulation of the data chain, and use the association, special control, and self-control relationship of business information to perform pre-control and post-testing on the business information assigned on the accounting information documents to generate the complete Controlled accounting informatization documents, from which the daily business is controlled in advance, so that economic information can form accounting informatization documents in the direction of indexing.
  • Accounting book module in this module there are "cash account, bank account, consolidated account, advance account, contract account, payment account, business account, storage account, consignment account, manufacturing account, cost account, pending account”. These twelve types of intelligent accounting books receive records and transmit the index information of accounting informationized documents, which are mapped from various accounting general ledger modules according to the corresponding "report type, start period, and end period” commands given by the report calculation module. "Accounting general ledger and corresponding reports are linked to set up a table" to calculate and retrieve relevant account book information and pass it to the report calculation module to generate relevant reports.
  • Report design module where the upper title bar, task bar, and lower title bar layouts of various accounting statements are created and passed to the report calculation module. Collection items and calculation items are set in the task bars of various reports, and the collection will be collected Projects are mapped to the accounting general ledger of all accounting subjects in the accounting general ledger module and the corresponding report associations are set up on the table to realize the interconnection of general ledger subjects and accounting report information. Use calculation items to perform collection and calculation items in the taskbar. Logical management.
  • the report calculation module includes a balance sheet, profit statement, cash flow statement, and appendix.
  • a balance sheet When generating a report, select the report type, start period, and end period commands in the upper title bar of the corresponding report and pass them to the accounting book module for calculation and adjustment. Obtain data to generate accounting statements.
  • the post-mortem detection module is composed of business information association relationship logic detection, business information special control relationship logic detection, business information self-control relationship logic detection, data link informatization documents and amount detection, data link informatization documents and quantity detection, and cash flow detection.
  • business information association relationship logic detection business information special control relationship logic detection
  • business information self-control relationship logic detection business information self-control relationship logic detection
  • data link informatization documents and amount detection data link informatization documents and quantity detection
  • cash flow detection The system's accounting information documents, accounting books, and accounting statements are tested after the fact.
  • an electronic device As shown in FIG. 5, an electronic device provided by an embodiment of the present application includes:
  • the memory 100 is used to store computer programs
  • the processor 200 is configured to implement the steps provided in the foregoing embodiments when executing the computer program.
  • the memory 100 includes a non-volatile storage medium and an internal memory.
  • the non-volatile storage medium stores an operating system and computer-readable instructions
  • the internal memory provides an environment for running the operating system and the computer-readable instructions in the non-volatile storage medium.
  • the processor 200 may be a central processing unit (CPU), controller, microcontroller, microprocessor, or other data processing chip, which provides computing and control capabilities for electronic devices, and executes the
  • the computer program stored in the memory 100 can implement the steps of the method for generating accounting statements disclosed in any of the foregoing embodiments.
  • the electronic device further includes:
  • the input interface 300 is connected to the processor 200 and is used to obtain externally imported computer programs, parameters, and instructions, and store them in the memory 100 under the control of the processor 200.
  • the input interface 300 can be connected to an input device to receive parameters or instructions manually input by the user.
  • the input device can be a touch layer covered on the display screen, a button, a trackball or a touchpad provided on the terminal shell, or a keyboard, a touchpad, or a mouse.
  • the display unit 400 is connected to the processor 200 and is used for displaying data processed by the processor 200 and for displaying a visualized user interface.
  • the display unit 400 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode, organic light-emitting diode) touch device, etc.
  • the network port 500 is connected to the processor 200 and is used to communicate with external terminal devices.
  • the communication technology used in the communication connection can be wired communication technology or wireless communication technology, such as mobile high-definition link technology (MHL), universal serial bus (USB), high-definition multimedia interface (HDMI), wireless fidelity technology (WiFi), Bluetooth communication technology, low-power Bluetooth communication technology, communication technology based on IEEE802.11s, etc.
  • FIG. 6 only shows an electronic device with components 100-500. Those skilled in the art can understand that the structure shown in FIG. 6 does not constitute a limitation on the electronic device, and may include fewer or more components than shown in the figure. Components, or a combination of certain components, or different component arrangements.
  • This application also provides a computer-readable storage medium, which may include: U disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic Various media that can store program codes, such as discs or optical discs.
  • a computer program is stored on the storage medium, and when the computer program is executed by a processor, the steps of the method for generating accounting statements disclosed in any of the foregoing embodiments are realized.

Abstract

An accounting report generation method and apparatus, an electronic device, and a computer-readable storage medium. The method comprises: controlling an assignment process by using a feedforward control policy to generate a completely controlled accounting information document; mapping document information into an account book; adding error, adjustment and normal items to a report so that the report has a normalized checking and error reporting function, and using a feedback control policy to re-check and correct documents in the account book and accumulated information; and receiving and transmitting a report generation command, obtaining a corresponding report template, invoking, according to the report generation command, a corresponding index from the corrected account book, mapping the index into the template, obtaining a calculation relationship of a taskbar of the template, and generating a target accounting report by means of calculation. According to the present application, feedforward control and feedback control are performed on system data in a logical way, and the system data is checked in real time in the form of a normalized report, thus the correctness of the data is ensured, and the accounting report has a normalized, timely and intelligent checking and error reporting function.

Description

一种会计报表生成方法、装置及电子设备Method, device and electronic equipment for generating accounting statements
本申请要求于2020年05月14日提交中国专利局、申请号为202010406902.0、发明名称为“一种会计报表生成方法、装置及电子设备”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on May 14, 2020, the application number is 202010406902.0, and the invention title is "A method, device and electronic equipment for generating accounting statements", the entire content of which is incorporated by reference In this application.
技术领域Technical field
本申请涉及会计智能化技术领域,更具体地说,涉及一种会计报表生成方法、装置及一种电子设备。This application relates to the technical field of accounting intelligence, and more specifically, to a method and device for generating accounting statements, and an electronic device.
背景技术Background technique
现行会计科目是不考虑借贷方向采用串排方式的非资源性业务信息编码方法,由于其编码不俱有资源性也就不俱有共享性和可控性;现行的业务单据还是源于手工时代,第一人(业务人员)和所有的会计科目还没有建全完整的业务单据可开可控,相关联的业务单据也没有建立数据链式的连接,导致处理的业务人机不识;日常和期末的会计核算均是建立在不可控的业务信息编码和业务单据以及会计记账凭证上的,资产负债表和利润表是建立在期末会计结算上的,现金流量表是建立在资产负债表和利润表上的;到最后编不平现金流量表,教科书不得不说“具体操作中,由于是根据两大主表和部分明细账簿编制现金流量表,数据很难精确,该项目留到最后倒挤填列”。The current accounting subject is a non-resource business information coding method that does not consider the direction of borrowing and lending and adopts a serial arrangement. Since its coding is not resourceful, it is not shared and controllable; the current business documents are still derived from the manual era , The first person (business personnel) and all accounting subjects have not yet established complete business documents that can be opened and controlled, and the related business documents have not established a data chain connection, resulting in the ignorance of the business man-machine; The accounting at the end of the period and the end of the period are all based on uncontrollable business information codes, business documents, and accounting vouchers. The balance sheet and income statement are based on the period-end accounting settlement, and the cash flow statement is based on the balance sheet. And the income statement; at the end of the compilation of the uneven cash flow statement, the textbook has to say "In the specific operation, because the cash flow statement is prepared based on the two main tables and some detailed account books, the data is difficult to be accurate, and the item is left to the end. Squeeze to fill the column".
发明内容Summary of the invention
本申请的目的在于提供一种会计报表生成方法、装置及一种电子设备和一种计算机可读存储介质,以逻辑的方法对系统数据进行事前事后的管控,以常态化报表的方式实时检测系统数据,确保了数据的正确性,使会计报表俱有了常态化及时性智能性的检测报错功能。The purpose of this application is to provide a method and device for generating accounting statements, an electronic device, and a computer-readable storage medium, which can manage and control system data before and after in a logical way, and detect the system in real time in the form of normalized statements. The data ensures the correctness of the data, so that the accounting statements have the function of normalization, timeliness and intelligent error detection and reporting.
为实现上述目的,本申请提供了一种会计报表生成方法,包括:In order to achieve the above objectives, this application provides a method for generating accounting statements, including:
确定用于在数据赋值过程中对数据进行检测和管控的事前控制策略;Determine the prior control strategy used to detect and control the data in the data assignment process;
获取用户赋值的会计要素数据,利用所述事前控制策略对赋值过程中 的所述会计要素数据进行管控,生成完全受控的会计信息化单据;Acquire the accounting element data assigned by the user, use the prior control strategy to control the accounting element data in the assignment process, and generate fully controlled accounting information documents;
将所述完全受控的会计信息化单据对应的单据指标信息映射到预先设制的会计账簿中;Mapping the document index information corresponding to the fully controlled accounting informationization document to the pre-designed accounting book;
确定事后控制策略,并利用所述事后控制策略对映射到所述会计账簿中的所述会计信息化单据和累积的累计的账簿指标信息进行再次检测,根据检测结果校正系统数据错误,得到校正后的会计账簿信息;Determine the post-event control strategy, and use the post-event control strategy to re-check the accounting information documents and accumulated account book index information mapped to the accounting books, correct the system data errors according to the detection results, and get the post-correction Of accounting book information;
接收和传递用户下达的报表生成命令,获取对应的会计报表模板,根据所述报表生成命令从校正后的会计账簿信息中调取相应的账簿指标信息映射到该会计报表模板中,并获取该会计报表模板任务栏信息之间的计算关系,计算生成目标会计报表。Receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, according to the report generation command, retrieve the corresponding account book index information from the corrected accounting book information and map it to the accounting report template, and obtain the accounting report template. The calculation relationship between the taskbar information of the report template is calculated to generate the target accounting report.
可选的,所述事前控制策略为预先为会计总账科目设置的:属性设制表、票据栏目启用表、拓展及微调设制表、业务信息关联设制表、业务信息专控设制表、业务信息自控设制表、与资产负债表关联设制表、与利润表关联设制表、与现金流量表关联设制表。Optionally, the prior control strategy is set in advance for the general ledger account: attribute setting tabulation, bill column activation tabulation, expansion and fine-tuning tabulation setting, business information association tabulation setting, business information special control setting tabulation, Set up tabulations for business information self-control, set up tabulations related to the balance sheet, set up tabulations related to the income statement, and set up tabulations related to the cash flow statement.
可选的,为所述会计报表模板之现金流量表增设错误项、调节项和常态项,使其俱有常态化及时性智能性的检测报错报表功能;Optionally, add error items, adjustment items, and normal items to the cash flow statement of the accounting statement template, so that it has the function of normalization, timeliness, and intelligent error detection and reporting;
其中,所述错误项为在所述现金流量表中增设的用于记录系统数据错误的项目,所述调节项为在所述现金流量表中增设的用于抵消错误项重复采集数据的项目,所述常态项为在所述现金流量表中增设的用于所述现金流量表在任意时间段及时性生成报表的项目。Wherein, the error item is an item added to the cash flow table for recording system data errors, and the adjustment item is an item added to the cash flow table for offsetting the repeated data collection of error items, The normal item is an item added to the cash flow statement for the cash flow statement to generate reports in a timely manner in any time period.
可选的,所述利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据,包括:Optionally, the use of the prior control strategy to manage and control the accounting element data in the value assignment process to generate fully controlled accounting informatization documents includes:
利用会计总账科目作为控制项控制其借贷方向二级及二级以下子目的对称或非对称无限拓展和微调;Use the accounting general ledger account as a control item to control the symmetrical or asymmetrical unlimited expansion and fine-tuning of the second and lower sub-purposes of its borrowing direction;
利用各类会计总账科目设置的票据栏目启用表控制各类会计信息化单据上的各类栏目会计总账科目的赋值;Use the bill column activation table set by various accounting general ledger accounts to control the assignment of various general accounting accounts on various accounting information documents;
利用会计信息化单据上任一栏目中赋值的具体会计总账科目控制所述任一栏目的二级及二级以下子目的赋值;Use the specific accounting general ledger account assigned in any column of the accounting information document to control the assignment of the second and lower sub-items of any column;
利用会计信息化单据上流转栏赋值的一二三级科目控制数据链的流 转,分为相同的一二三级科目实现数据链的流转和不同的一二三级科目阻断数据链的流转;Use the first, second and third level subjects assigned in the circulation column of the accounting information documents to control the flow of the data link, which is divided into the same level 1, 2, and 3 subjects to realize the flow of the data link and different levels 1, 2, and 3 subjects to block the flow of the data link;
利用业务信息的关联、专控、自控关系对会计信息化单据上赋值的业务信息进行事前控制和事后检测,生成所述完全受控的会计信息化单据。Pre-control and post-check the business information assigned on the accounting informatization documents by using the association, exclusive control, and self-control relationships of business information to generate the fully controlled accounting informatization documents.
可选的,所述生成会计报表的调度指挥命令中包括目标会计报表及类型、报表起止时间的选择信息。Optionally, the scheduling command command for generating the accounting report includes the selection information of the target accounting report and its type, and the start and end time of the report.
可选的,所述事后控制策略包括业务信息关联关系逻辑检测项、业务信息专控关系逻辑检测项、业务信息自控关系逻辑检测项、数据链信息化单据及金额检测项、数据链信息化单据及数量检测项、以及现金流量检测项;所述事后控制策略还用于对所述会计账簿和所述目标会计报表进行检测。Optionally, the post-control strategy includes business information association relationship logic detection items, business information specific control relationship logic detection items, business information self-control relationship logic detection items, data link information documents and amount detection items, data link information documents And quantity detection items, and cash flow detection items; the ex-post control strategy is also used to detect the accounting books and the target accounting statements.
可选的,还包括:Optionally, it also includes:
在利用所述事后控制策略对所述会计信息化单据、所述会计账簿和所述目标会计报表进行检测之后,得到检测结果;After using the ex-post control strategy to detect the accounting informationization document, the accounting book and the target accounting statement, the detection result is obtained;
基于所述检测结果生成各类单据错误信息列表、归宗关系错误信息列表、账随关系错误信息列表、现金流量错误信息列表,为评估和校正系统数据错误提供支持。Based on the detection result, a list of various types of document error information, an error information list of a reconciliation relationship, an error information list of an account with a relationship, and a cash flow error information list are generated to provide support for evaluating and correcting system data errors.
可选的,所述会计报表的生成过程,包括:Optionally, the process of generating the accounting statement includes:
接收针对所述会计报表中上标题栏的表项进行设计的选择指令,并建立每个表项选择指令与各类相关会计总账科目的指挥调度关系;Receive selection instructions designed for the items in the upper title bar of the accounting statement, and establish the command and dispatch relationship between each item selection instruction and various related accounting general ledger accounts;
接收针对所述会计报表中任务栏项目的设置指令;所述设置指令用于将所述报表任务栏项目设置为采集项目或计算项目;所述采集项目用于实现账簿指标与报表指标的映射转换计算关系,所述计算项目用于实现对报表任务栏内的采集项目及其自身信息进行计算重组;Receive a setting instruction for the task bar item in the accounting report; the setting instruction is used to set the report task bar item as a collection item or a calculation item; the collection item is used to realize the mapping conversion between the account book index and the report index The calculation relationship, the calculation item is used to realize the calculation and reorganization of the collection item and its own information in the report task bar;
获取会计报表模板中的版面设计内容,并基于所述版面设计内容确定所述会计报表的下标题栏;Acquire the layout design content in the accounting statement template, and determine the lower title bar of the accounting statement based on the layout design content;
结合所述上标题栏、所述任务栏以及所述下标题栏生成所述会计报表。The accounting report is generated in combination with the upper title bar, the task bar, and the lower title bar.
为实现上述目的,本申请提供了一种会计报表生成装置,包括:In order to achieve the above objective, this application provides an accounting statement generating device, including:
事前控制模块,用于确定用于在数据赋值过程中对数据进行检测和管 控的事前控制策略;The pre-control module is used to determine the pre-control strategy used to detect and control the data in the data assignment process;
数据赋值模块,用于获取用户赋值的会计要素数据,利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据;The data assignment module is used to obtain the accounting element data assigned by the user, use the prior control strategy to control the accounting element data in the assignment process, and generate fully controlled accounting information documents;
数据映射模块,用于将所述完全受控的会计信息化单据对应的单据指标信息映射到预先设制的会计账簿中,给各类会计报表任务栏采集项目与各类会计总账科目账簿指标建立映射转换计算关系;The data mapping module is used to map the document index information corresponding to the fully controlled accounting informationization document to the pre-designed accounting book, and establish the collection items of various accounting report task columns and various accounting general ledger account book indicators Mapping conversion calculation relationship;
事后控制模块,用于确定事后控制策略,并利用所述事后控制策略对映射到所述会计账簿中的所述会计信息化单据和累积的累计的账簿指标信息进行再次检测,根据检测结果校正系统数据错误,得到校正后的会计账簿信息;The post-control module is used to determine the post-control strategy, and use the post-control strategy to re-check the accounting informationized documents and accumulated account book index information mapped to the accounting book, and correct the system according to the detection result The data is wrong, and the corrected accounting book information is obtained;
报表生成模块,用于接收和传递用户下达的报表生成命令,获取对应的会计报表模板,根据所述报表生成命令从校正后的会计账簿信息中调取相应的账簿指标信息映射到该会计报表模板中,并获取该会计报表模板任务栏信息之间的计算关系,计算生成目标会计报表。The report generation module is used to receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, and retrieve the corresponding account book index information from the corrected accounting book information according to the report generation command and map it to the accounting report template , And obtain the calculation relationship between the task bar information of the accounting statement template, and calculate and generate the target accounting statement.
为实现上述目的,本申请提供了一种电子设备,包括:In order to achieve the above objective, this application provides an electronic device, including:
存储器,用于存储计算机程序;Memory, used to store computer programs;
处理器,用于执行所述计算机程序时实现前述公开的任一种会计报表生成方法的步骤。The processor is used to implement the steps of any of the aforementioned methods for generating accounting statements when the computer program is executed.
为实现上述目的,本申请提供了一种计算机可读存储介质,所述计算机可读存储介质上存储有计算机程序,所述计算机程序被处理器执行时实现前述公开的任一种会计报表生成方法的步骤。In order to achieve the above objective, the present application provides a computer-readable storage medium with a computer program stored on the computer-readable storage medium, and when the computer program is executed by a processor, any one of the accounting report generation methods disclosed above is implemented A step of.
通过以上方案可知,本申请提供的一种会计报表生成方法,包括:确定用于在数据赋值过程中对数据进行检测和管控的事前控制策略;获取用户赋值的会计要素数据,利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据;将所述完全受控的会计信息化单据对应的单据指标信息映射到预先设制的会计账簿中;确定事后控制策略,并利用所述事后控制策略对映射到所述会计账簿中的所述会计信息化单据和累积的累计的账簿指标信息进行再次检测,根据检测结 果校正系统数据错误,得到校正后的会计账簿信息;接收和传递用户下达的报表生成命令,获取对应的会计报表模板,根据所述报表生成命令从校正后的会计账簿信息中调取相应的账簿指标信息映射到该会计报表模板中,并获取该会计报表模板任务栏信息之间的计算关系,计算生成目标会计报表。由上可知,本申请能够在会计要素数据赋值过程中对其进行检测管控,并可基于事后控制策略对数据进行再次检测,避免数据出现错误,还可以接收报表生成指令后自动调取相应的信息和计算关系,智能自动化地生成目标会计报表,确保了会计报表数据的正确性,使会计报表俱有了常态化及时性智能性的检测报错功能。It can be seen from the above scheme that the method for generating accounting statements provided by this application includes: determining a pre-control strategy for detecting and controlling data in the data assignment process; obtaining user-assigned accounting element data, and using the pre-control The strategy controls the accounting element data in the value assignment process to generate fully controlled accounting informatization documents; mapping the document index information corresponding to the fully controlled accounting informatization documents to pre-set accounting books; Determine the post-event control strategy, and use the post-event control strategy to re-check the accounting information documents and accumulated account book index information mapped to the accounting books, correct the system data errors according to the detection results, and get the post-correction The accounting book information; receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, according to the report generation command, retrieve the corresponding accounting book index information from the corrected accounting book information and map it to the accounting report template , And obtain the calculation relationship between the task bar information of the accounting statement template, and calculate and generate the target accounting statement. It can be seen from the above that this application can detect and control the accounting element data in the process of assigning it, and can check the data again based on the post-control strategy to avoid data errors. It can also automatically retrieve the corresponding information after receiving the report generation instruction In relation to calculation, the target accounting report is generated intelligently and automatically to ensure the correctness of the accounting report data, so that the accounting report has the function of normalization, timeliness and intelligent error detection and reporting.
本申请还公开了一种会计报表生成装置及一种电子设备和一种计算机可读存储介质,同样能实现上述技术效果。The application also discloses an accounting statement generating device, an electronic device and a computer-readable storage medium, which can also achieve the above technical effects.
应当理解的是,以上的一般描述和后文的细节描述仅是示例性的,并不能限制本申请。It should be understood that the above general description and the following detailed description are only exemplary and cannot limit the application.
附图说明Description of the drawings
为了更清楚地说明本申请实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本申请的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。In order to more clearly describe the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the drawings in the following description are only These are some embodiments of the present application. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative work.
图1为本申请实施例公开的一种会计报表生成方法的流程图;Figure 1 is a flowchart of a method for generating accounting statements disclosed in an embodiment of the application;
图2为本申请实施例公开的一种会计报表生成装置的模块图;Figure 2 is a block diagram of an accounting report generating device disclosed in an embodiment of the application;
图3为本申请实施例公开的一种会计报表生成系统的简化结构图;Figure 3 is a simplified structural diagram of an accounting report generation system disclosed in an embodiment of the application;
图4为本申请实施例公开的一种会计报表生成系统的详细结构图;Figure 4 is a detailed structural diagram of an accounting report generation system disclosed in an embodiment of the application;
图5为本申请实施例公开的一种电子设备的结构图;FIG. 5 is a structural diagram of an electronic device disclosed in an embodiment of the application;
图6为本申请实施例公开的另一种电子设备的结构图。Fig. 6 is a structural diagram of another electronic device disclosed in an embodiment of the application.
具体实施方式Detailed ways
下面将结合本申请实施例中的附图,对本申请实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本申请一部分实施例,而不是全部的实施例。基于本申请中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都属于本申请保护的范围。The technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of this application.
关于会计核算级次的特别说明:Special note on accounting levels:
任何一类会计账簿均是由《会计总账+二级明细账+三级明细账+N级明细账》构成,其中《会计总账》是不可少的,《二级至N级》明细账是按需求设置的,由《会计总账+二级明细账+三级明细账+N级明细账》就构成了具体的《业务信息》。Any type of accounting book is composed of "Accounting General Ledger + Level 2 Subsidiary Ledger + Level 3 Subsidiary Ledger + Level N Subsidiary Ledger", among which "Accounting General Ledger" is indispensable, and "Level 2 to N Level" subscribing accounts are based on The “Accounting General Ledger+Second-Level Subsidiary Ledger+Third-Level Subsidiary+N-Level Subsidiary Ledger” constitutes the specific “Business Information”.
由于业务信息中存在着拓展《N级》明细账的因素,对于任何一个企事业单位来说其业务信息将是无限的,因此无法对无限的业务信息进行穷尽的编码,业务信息的性质是组合的,相对于会计科目来说业务信息的组合有(串排法、资源法)两种方法,分别说明如下:Since there are factors in the business information to expand the "N-level" sub-ledger, the business information will be unlimited for any enterprise and institution, so it is impossible to exhaust the unlimited business information. The nature of the business information is combination Yes, there are two methods for the combination of business information relative to accounting subjects (string arrangement method and resource method), which are explained as follows:
现行采用串排法:不考虑会计总账科目的借贷方向,只是以其会计总账科目为起点逐级逐级的串排出各级子目,使会计总账科目与各级子目混为一体构成有上下级隶属关系的串排业务信息编码方法。The current method of string arrangement: does not consider the direction of borrowing and lending of the general ledger, but uses its general ledger title as the starting point to list all levels of subheadings level by level, so that the general ledger subjects and subheads of all levels are mixed into one structure. Tandem business information coding method based on hierarchical membership.
串排是一个纯编码的方法,以母鸡带小鸡这样微小的格局管控其有限串排不具资源概念的各级子目,串排的业务信息其借贷方向拓展一定是对称性的。Tandem is a purely coding method. With such a tiny pattern as hens and chicks, the limited tandem does not have the concept of resources to control all levels of sub-items. Tandem business information must be symmetric in the direction of lending and borrowing.
由于串排业务信息中不存在独立的资源独立的子目,也就不存在管理的对象,注定其会计总账科目因无管理对象而不可能作为控制项对企事业单位的资源进行计划管控。Since there is no independent resource independent sub-item in the serialized business information, there is no management object. It is destined that its accounting general ledger account cannot be used as a control item to plan and control the resources of enterprises and institutions because there is no management object.
串排的各级子目是不能脱离其总账科目而独立存在的,因为其串排的只是一串数字不俱资源性,也就是串排的数字没有名分,一旦脱离了母体便会出现人机不识,对于人机不识的数字也就无从谈管理了。The sub-items at all levels of the series cannot exist independently of their general ledger accounts, because they are just a series of numbers and are not resource-rich, that is, the numbers in the series have no name, and once they are separated from the parent body, people will appear. Without knowing the machine, there is no way to manage the numbers that do not know the man and machine.
相对于企事业单位来说其业务信息是无限的,如采用以会计总账科目为起点逐级逐级逐个逐个的串排出各类业务信息,那串排的业务信息将是海量的不可穷尽的。Compared with enterprises and institutions, their business information is unlimited. If you use accounting general ledger accounts as the starting point to discharge all kinds of business information level by level one by one, the series of business information will be inexhaustible.
例如:十几类薪酬在十多个会计总账科目的各部门和各环节内均有发生,薪酬类业务信息的量为核算级次的积且各自串编,但薪酬类是要进行归口管理的《即:应付职工薪酬的贷方发生额=十多个会计总账科目薪酬类费用借方发生额的总和》;以工资为例,应付职工薪酬科目中的工资1要对应十多个会计总账科目的各部门和各环节内的工资N,相关部门要稽查的目标工资是1,但由于会计科目及子目没有资源化管理,导致其在各会计总账科目的各部门和各环节内的串码没有共性,造成稽查的对象就变成了N,由于N是个未知的变量,所以人脑和系统都无法准确的完成这一稽查工作,其他(如:税费类、折旧类、等)也是如此。For example: more than a dozen types of salaries occur in more than a dozen accounting general ledger accounts in various departments and links. The amount of salary business information is the product of accounting levels and is compiled separately, but the salary category needs to be managed centrally "That is: the credit of employee compensation payable = the sum of the debits of more than ten accounting general ledger accounts"; take salary as an example, the salary 1 in the employee compensation account must correspond to each of the more than ten accounting general ledger accounts. The salary N in the department and each link, the target salary to be audited by the relevant department is 1, but because the accounting subjects and sub-heads are not resource-based management, the string codes in each department and each link of the accounting general ledger have no commonality , The object of the audit becomes N. Because N is an unknown variable, neither the human brain nor the system can accurately complete the audit work, as are other things (such as taxes, depreciation, etc.).
发明采用资源法:考虑到会计总账科目的借贷方向,将会计科目的各级均进行资源化管理,使会计科目丧失了上下级串排的隶属关系,为此只好请出会计总账科目这一特殊资源作为“控制项”对其借贷方向二级及二级以下子目进行对称与非对称的无限拓展,为使控制项更好更便利的个性化选择其借贷方向二级及二级以下相关子目,将各类被管理的资源按其类别成立“子目集团拓展”项目,再将各类别中的全部或个别资源组成“子目精细拓展”项目,听任各控制项对其的召唤,随时准备着去充当控制项借贷方向二级及二级以下对称或非对称无限拓展的子目,实现了会计科目子目的精细化控制,达到所有专控子目该有的地方一定有该无的地方一定无,如“税收滞纳金”,我们称之为资源法。由此开启会计智能化的先河。The invention adopts the resource method: taking into account the direction of borrowing and lending the accounting general ledger, resource management is carried out at all levels of the accounting subjects, so that the accounting subjects lose the subordinate relationship of the upper and lower levels. For this reason, I have to use the special accounting general ledger As a "control item", the resource expands its lending direction to the second and lower sub-items infinitely symmetrically and asymmetrically. In order to make the control item better and more convenient and personalized, choose its lending direction to the second and lower related sub-items. In order to establish a “sub-project group expansion” project for various managed resources according to their categories, and then group all or individual resources in each category into a “sub-project fine expansion” project, let each control item call it at any time It is ready to serve as a symmetrical or asymmetric infinitely expanded subheading of the second and lower level of the control item lending direction, and realizes the refined control of the accounting subject sub-heads, and achieves that all the special control sub-heads must have something that must be absent. There must be none, such as "tax late fees", which we call resource law. This opens a precedent for intelligent accounting.
以资源法编列的各类业务信息,其会计总账科目借贷方向二级及二级以下拓展的各类子目均是一个个独立的资源,独立的资源在系统中均是有名有分的,资源有名分也就人机均可识,可识就可谈管理。All kinds of business information compiled by the resource method, and the various sub-heads expanded in the direction of the second and lower levels of the general ledger account are all independent resources. Independent resources are well-known and divided in the system. Resources If you have a reputation, you can know both man and machine, and you can talk about management if you know it.
相对于企事业单位来说其所拥有的资源总是有限的,在系统中对有限的资源进行人机共识的有名有分的管理,以有名分的资源按管理的要求自由组合生成为企事业单位的各类业务信息,使海量不可穷尽的业务信息归于有限资源的管控。Compared with enterprises and institutions, the resources they have are always limited. The limited resources are managed in a well-known and well-known way by man-machine consensus, and the well-known resources are freely combined according to management requirements to form enterprises and institutions. The various types of business information of the unit make the massive inexhaustible business information under the control of limited resources.
例如:十几类薪酬在十多个会计总账科目的各部门和各环节内均有发生,薪酬类业务信息的量为核算级次的积,但薪酬类是要进行归口管理的《即:应付职工薪酬的贷方发生额=十多个会计总账科目薪酬类费用借方 发生额的总和》;以工资为例,应付职工薪酬科目中的工资要对应十多个会计总账科目的各部门和各环节内的工资,相关部门要稽查的目标是工资,由于会计总账科目和各级子目均进行了资源化管理,致使工资在各会计总账科目的各部门和各环节内是同一资源编码,因此稽查的对象也就变成了同一对象,所以人脑和系统都能准确的完成这一稽查工作,其他(如:税费类、折旧类、等)也是如此。For example, more than a dozen types of compensation occur in various departments and links of more than ten accounting general ledger subjects. The amount of compensation business information is the product of accounting levels, but the compensation category is subject to centralized management "namely: payable The credit of employee compensation = the sum of the debits of salary expenses in more than ten accounting general ledger accounts"; taking salary as an example, the wages in the employee compensation subject should correspond to the various departments and links of more than ten accounting general ledger accounts. The wages of the relevant departments are to be audited by the relevant departments. Because the accounting general ledger items and sub-items at all levels have been resource-based management, the wages are the same resource code in each department and each link of the accounting general ledger, so the audit is The object also becomes the same object, so the human brain and the system can accurately complete the audit work, as do other things (such as taxes, depreciation, etc.).
本申请实施例公开了一种会计报表生成方法,参见图1所示,本申请实施例公开的一种会计报表生成方法包括:The embodiment of the application discloses a method for generating an accounting statement. As shown in FIG. 1, the method for generating an accounting statement disclosed in the embodiment of the application includes:
S101:确定用于在数据赋值过程中对数据进行检测和管控的事前控制策略;S101: Determine the prior control strategy used to detect and control the data in the data assignment process;
可以理解的是,本申请实施例可以预先设置事前控制策略,用于在数据赋值过程中进行检测和管控。具体地,上述事前控制策略为预先为会计总账科目设置的:属性设制表、票据栏目启用表、拓展及微调设制表、业务信息关联设制表、业务信息专控设制表、业务信息自控设制表、与资产负债表关联设制表、与利润表关联设制表、与现金流量表关联设制表。也即,本申请实施例在每个会计总账科目的编辑处为其设置了上述九类关联控制表,由此对票据启用、科目拓展、信息化单据生成及流转、业务信息的关联、专控、自控关系、会计报表采集项目与会计科目及会计账簿指标项目的调取计算关系进行事前控制管理。It is understandable that in the embodiment of the present application, a prior control strategy can be set in advance for detection and management during the data assignment process. Specifically, the above-mentioned pre-control strategy is set in advance for the general ledger accounts: attribute setting tabulation, bill column activation tabulation, expansion and fine-tuning tabulation setting, business information association tabulation setting, business information special control setting tabulation, business information Set up tabulation for self-control, set up tabulation in association with balance sheet, set up tabulation in association with income statement, and set up tabulation in association with cash flow statement. That is, in the embodiment of the application, the above nine types of association control tables are set in the editor of each accounting general ledger account, so as to enable the bill activation, account expansion, informationized document generation and circulation, business information association, and special control. , Self-control relationship, accounting statement collection items and accounting titles and accounting book index items retrieval calculation relationship for prior control management.
具体地,本实施例预先在系统内设制好各会计总账科目的拓展、微调、关联、专控、自控、单据、流转、映射关系作为事前控制项目:①会计科目的拓展和微调,将会计的管理对象分类分段编码,给各类具体的独立资源分配一个唯一编码归集到相应类别管理,各类别可作为集团拓展项,各独立资源可作为微调拓展项,以会计总账科目这一特殊资源作为控制项将其他资源按管理的要求在各类会计总账科目分借贷方向对称或非对称的组合成无限拓展的业务信息,分为借贷方向集团拓展和微调或指定拓展唯一子目或专控子目;②业务信息的关联,就是产生了A业务信息必定产生B业务信息这就是关联,也就说“有我必有你、有因必有果、有果必有因”,在会计智能化系统内会计的管理对象是一个个独立的资源,由控制项按管理 的要求将各类资源组成无穷的业务信息,因资源的独立性就具备了人机共识也就为人机管理业务信息提供了操手;具体的就是在系统中设定以A会计总账科目结合其借方或贷方作为主控项去控制B会计总账科借方或贷方二级三级子目的使用,此时B会计总账科结合其借方或贷方三级子目就构成了被控项,被控项必须寻找主控项,设置主被控后又可对其主被控业务信息设同级互控和交叉互控;例关联关系的具体应用,薪酬类是要进行归口管理的,各级各类业务部门计提的成本薪酬理论上讲是要归口到《应付职工薪酬会计总账科目》统一管理的,此时应付职工薪酬会计总账科目贷方与各类计提薪酬会计总账科目借方就形成了关联关系,再以销售费用下薪酬类设制关联关系为例,具体操作就是以“应付职工薪酬会计总账科目的贷方”作为“主控项”去控制“销售费用会计总账科目的借方具体二级子目及三级薪酬类子目”的使用,当然此时“销售费用会计总账科目的借方和三级薪酬类子目”就构成了被控项,当主被控设好后又可对两互控的业务信息设制同级互控和交叉互控关系;系统利用此对赋值过程中或系统内已有的会计信息化单据进行存在关联项是否构成“主被控建立、被主控建立”的事前事后检测,否则报错;③业务信息的专控,就是将“专控子目、被控子目”与指定会计总账科目的借方贷方或借贷双方至专控级次组成专控业务信息,具体分为专控子目专控和被控子目专控两类;专控子目专控就是将专控子目和指定会计总账科目的借方贷方或借贷双方至专控级次组成专控业务信息,系统利用此对赋值过程中或系统内已有的会计信息化单据进行专控子目非专控业务信息、非被控业务信息排他的事前事后检测,否则报错;被控子目专控就是将被控子目和指定会计总账科目的借方贷方或借贷双方至专控级次组成专控业务信息,系统利用此对赋值过程中或系统内已有的会计信息化单据进行被控子目非专控业务信息、非被控业务信息排他的事前事后检测,否则报错;系统利用“专控子目、被控子目”对归口管理和指标性子目进行无限的精确定位管理,达到归口管理和指标性子目该有的地方一定有,该无的地方一定无,如《税收滞纳金专控子目》,该专控子目只在《营业外支出会计总账科目》下才有列支,任何一个会计子目均可设为“专控子目、被控子目”,专控子目和被控子目只能构成专控 业务信息、被控业务信息,目的是加强对系统中“归口管理和指标性子目”指标的专控管理;④业务信息的自控,就是由具体会计总账科目结合其借方贷方或借贷双方作为自控项,去对其二级及二级以下使用子目进行差异性目标性方向性的二次管控,也是对设定了的拓展项进行自控业务信息的再分类,系统利用此对赋值过程中或系统内已有的会计信息化单据进行自控项非自控业务信息排他的事前事后检测,否则报错;如:某企业设有“内部往来”一级会计总账科目,其二级分为“部门往来、个人往来”两类核算,其三级分为“行政部、生产部、销售部、等部门、张三、李四、王五、等个人”部门人员混合的N多明细核算;为了不使二级“部门往来”后串三级“人员”、也为了不使二级“个人往来”后串三级“部门”的错误产生,为此我们对“内部往来”一级会计总账科目进行两类自控设制,其一为“内部往来、借贷双方、部门往来、部门类”,其二为“内部往来、借贷双方、个人往来、员工类”;⑤科目与票据栏目启用表的控制关系,一张完整的会计信息化单据必定按借贷方向分别设计有N多的信息录入栏目,在此所述控制关系是指设定某会计总账科目可以赋值相关各类会计信息化单据的借方贷方或借贷双方一级栏目,也就是某会计总账科目能否录入或勾选启用某会计信息化单据某栏目的控制关系;⑥数据链的流转控制关系,给同一组经济业务不同时期不同环节不同过程的单据用共性连接在一起,达到人机共识我们称之为数据链,以“应收单、收款单”构成数据链为例,应收单和收款单分别设计有“流转栏、货币栏、综合栏”,流转栏的一二三级科目控制数据链的流转关系,相同的一二三级科目实现数据链的流转,不同的一二三级科目阻断数据链的流转,货币栏、综合栏用于采集目标信息;如往来类科目其借贷方向二三级是相同的拓展赋值在流转栏上就可构成“应收单和收款单和收款单和应收单”形式的数据链,又如费用类科目其借贷方向二三级是不同的拓展赋值在流转栏上只能构成“应收单和应收单和应收单”或“收款单和收款单和收款单”形式的数据链;⑦会计总账科目与会计报表关系的关联设制表,会计报表信息源于会计账簿,但报表项目并不完全等同于会计科目,大多数情况下是一个或多个会计科目信息汇集成一个或多个会计报表信息,会计报表又分为资产负债表利润表现金流 量表等,为了使系统能分析处理会计账簿与会计报表信息的关系,将各类会计报表任务栏项目分别设计成为“采集项目、计算项目”,再将各类采集项目映射到所有会计总账科目内用于设制计算具体会计总账科目账簿指标与具体会计报表指标的关联关系,计算项目用于对由会计账簿映射回的采集项目及其自身信息进行计算重组生成目标会计报表。Specifically, in this embodiment, the expansion, fine-tuning, association, special control, self-control, documents, circulation, and mapping relations of each accounting general ledger account are set in the system in advance as the pre-control items: ①The expansion and fine-tuning of accounting The management objects are classified and coded in segments, and various specific independent resources are assigned a unique code and collected into the corresponding category for management. Each category can be used as a group expansion item, and each independent resource can be used as a fine-tuning expansion item. Resource as a control item. According to management requirements, other resources are divided into symmetrical or asymmetrical combination of borrowing and lending directions into unlimited expansion of business information in various accounting general ledger subjects according to management requirements. Subheading; ②The association of business information means that A business information must produce B business information. This is association, which means "if you have me, there must be an effect, if there is a cause, there must be an effect, and if there is an effect, there must be a cause." The management objects of accounting in the system are independent resources, and various resources are composed of infinite business information according to management requirements by control items. Because of the independence of resources, there is a human-machine consensus and it provides human-machine management business information. The specific thing is to set in the system to use A accounting general ledger account combined with its debit or credit as the main control item to control the use of B accounting general ledger debit or credit secondary and tertiary sub-purposes, at this time B accounting general ledger combined The debit or credit three-level sub-items constitute the accused item, and the accused item must look for the main control item. After the main control is set, the same level mutual control and cross mutual control of its main controlled business information can be set; example association The specific application of the relationship, the salary category is to be managed centrally. Theoretically speaking, the cost and salary accrued by various business departments at all levels should be centralized under the unified management of the "Employee Salary Accounting General Ledger". At this time, the employee salary accounting The credit of the general ledger account and the debit of the various types of compensation accounting general ledger accounts form an association relationship, and then take the correlation relationship of the salary category under the sales expense as an example. The specific operation is to use "the credit of the employee compensation account "Control item" to control the use of "specific secondary sub-items and three-level salary category sub-items of the debit of the sales expense accounting general ledger", of course, at this time "debits of the sales expense accounting general ledger account and three-level salary category sub-items" constitute After the controlled item is set up, the same level mutual control and cross mutual control relationship can be set for the two mutually controlled business information after the master is set up; the system uses this to perform accounting informationization documents in the valuation process or in the system. Whether the existence of related items constitutes the pre- and post-test of "the establishment of the main control and the establishment of the main control", otherwise an error will be reported; ③The special control of business information is to combine the "special control sub-item and the accused sub-item" with the designated accounting general ledger account. The borrower and the lender or the lender or both parties to the special control level form the special control business information, which is specifically divided into two types: special control sub-items, special control and accused sub-items. The debit and creditor of the general ledger or both the borrower and the lender to the special control level form special control business information, and the system uses this to perform special control on the accounting information documents that exist in the valuation process or in the system. Pre- and post-test for exclusive business information, otherwise an error will be reported ; The special control of the accused sub-item is to combine the debit, lender, or both of the borrower and the lender of the accused sub-item and the designated accounting general ledger to the special control level to form special control business information, and the system uses this pair of accounting information in the valuation process or in the system. The system uses "specially controlled sub-items, accused sub-items" to perform unlimited centralized management and indicator sub-items. Accurately locate and manage, to achieve centralized management and index sub-items, there must be places, and there must be no places where they are not. For example, "Tax Late Fee Special Control Sub-item", this special-control sub-item is only in "Non-operating Expenditure Accounting General Ledger Account" There are only sub-items listed below. Any accounting sub-item can be set as “specially controlled sub-item, accused sub-item”. The specialized-controlled sub-item and the accused sub-item can only constitute the specialized control business information and the accused business information, and the purpose is It is to strengthen the special control management of the "centralized management and index sub-items" in the system; ④The self-control of business information is to combine the specific accounting general ledger items with the borrower, the lender or the borrower as a self-control item to control the secondary and secondary The following sub-headings are used to carry out the secondary management and control of the different target directions, and also to reclassify the self-control business information of the set expansion items. The system uses this to perform the accounting informationization documents in the evaluation process or in the system. Self-control items are non-self-control business information exclusive pre- and post-test, otherwise an error will be reported; for example, an enterprise has a first-level accounting general ledger account for "internal transactions". Divided into "administrative department, production department, sales department, and other departments, Zhang San, Li Si, Wang Wu, and other individuals" departmental personnel mixed N multiple detailed accounting; in order not to make the second-level "departmental exchanges" followed by the third-level " "Personnel", and in order not to cause the error of the second-level "personal contact" followed by the third-level "department", we have implemented two types of automatic control systems for the "internal transactions" first-level accounting general ledger, one of which is "internal transactions". , Borrowers and lenders, departmental transactions, departmental categories", the second is "internal transactions, borrowers and lenders, personal transactions, employee categories"; ⑤The control relationship between subject and bill column activation form, a complete accounting information document must be borrowed The direction is designed with more than N information entry columns. The control relationship mentioned here refers to the setting of a certain accounting general ledger account that can be assigned to the debit and credit of various accounting information documents, or the first-level column of the borrower and the lender, that is, a certain accounting general ledger account. Can you enter or check the control relationship of a certain column of a certain accounting informationization document; ⑥The flow control relationship of the data chain, the same group of economic business documents in different periods, different links and different processes are connected together with commonality to achieve human-machine consensus. Call it a data link. Take the data link composed of "receivables and collections" as an example. The receivables and collections are designed with "transfer column, currency column, and comprehensive column" respectively. The first, second, and third levels of the transfer column The account controls the transfer relationship of the data link. The same one, two and three subjects realize the transfer of the data link, and different one, two and three subjects block the transfer of the data link. The currency column and the comprehensive column are used to collect target information; such as current subjects The second and third levels of the borrowing direction are the same. The expansion assignment can be constituted on the circulation column. The data link in the form of "receivables and receipts and receipts and receivables", and for expense accounts, the lending directions of the second and third levels are different. Expansion assignments can only constitute "receivables and receivables" in the circulation column. A data link in the form of receipts and receivables" or "receivables and receipts and receipts"; ⑦The relationship between accounting general ledger accounts and accounting statements is set up to form a table. The accounting statement information is derived from the accounting book, but the statement Projects are not completely equivalent to accounting items. In most cases, one or more accounting items are integrated into one or more accounting statement information. Accounting statements are divided into balance sheet profit performance gold flow statements, etc., in order to enable the system Analyze and process the relationship between accounting books and accounting statement information, design various accounting statement taskbar items as "collection items, calculation items", and then map various collection items to all accounting general ledger accounts for setting up and calculating specific accounting The relationship between general ledger account book indicators and specific accounting statement indicators. The calculation items are used to calculate and reorganize the collection items mapped back by the accounting books and their own information to generate target accounting statements.
S102:获取用户赋值的会计要素数据,利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据;S102: Obtain the accounting element data assigned by the user, and use the prior control strategy to manage and control the accounting element data in the value assignment process to generate fully controlled accounting informationized documents;
本步骤中,获取用户赋值过程中的会计要素数据,并基于上述事前控制策略检测控制当前用户赋值的数据。在具体实施中,利用会计总账科目作为控制项控制其借贷方向二级及二级以下子目的对称或非对称无限拓展和微调;可以利用各类会计总账科目设置的票据栏目启用表控制各类会计信息化单据上的各类栏目会计总账科目的赋值;利用会计信息化单据上任一栏目中赋值的具体会计总账科目控制所述任一栏目的二级及二级以下子目的赋值;利用会计信息化单据上流转栏赋值的一二三级科目控制数据链的流转,分为相同的一二三级科目实现数据链的流转和不同的一二三级科目阻断数据链的流转;利用业务信息的关联、专控、自控关系对会计信息化单据上赋值的业务信息进行事前控制和事后检测,生成所述完全受控的会计信息化单据。In this step, the accounting element data in the user assignment process is obtained, and the data assigned by the current user is detected and controlled based on the foregoing prior control strategy. In the specific implementation, use the accounting general ledger account as a control item to control the symmetrical or asymmetrical unlimited expansion and fine-tuning of the sub-purposes of the second and lower borrowing direction; you can use the bill column activation table set by various accounting general ledger subjects to control various accounting Assignment of accounting general ledger accounts for various columns on informationized documents; use specific accounting general ledger accounts assigned in any column on accounting informationized documents to control the assignment of secondary and lower sub-items of any column; use accounting informatization The first, second and third level subjects assigned in the circulation column on the receipt control the flow of the data link, which are divided into the same level 1, 2, and 3 subjects to realize the flow of the data link and different levels 1, 2, and 3 subjects to block the flow of the data link; use business information The relationship of association, special control, and self-control performs pre-control and post-testing on the business information assigned on the accounting information documents to generate the fully controlled accounting information documents.
在具体实施中,一张完整的会计信息化单据一般俱有N多的借贷方向信息采集栏目,一个栏目从会计总账科目到其二级及二级以下又分为N多的子目信息录入点,同一组业务不同时期不同环节不同过程产生的会计信息化单据又因共性构成人机共识的数据链;利用各类会计总账科目设置的票据栏目启用表控制各类会计信息化单据上的各类栏目会计总账科目的赋值;利用会计信息化单据上任一栏目中赋值的具体会计总账科目控制所述任一栏目的二级及二级以下子目的赋值;利用会计信息化单据上流转栏赋值的一二三级科目控制数据链的流转,分为相同的一二三级科目实现数据链的流转和不同的一二三级科目阻断数据链的流转;利用业务信息的关联、专控、自控关系对会计信息化单据上赋值的业务信息进行事前控制和事后检测,生成所述完全受控的会计信息化单据。当新开或派生一张会计信息 化单据时,从各相关栏目赋值会计总账科目后再赋值二级及二级以下子目构成一条业务信息的流转,再到对应业务信息是否存在关联、专控、自控管制,均需要逐条访问系统预设制的拓展、微调、关联、专控、自控、流转参数,符合才能产生单据,否则不能生成单据。In specific implementation, a complete accounting information document generally has more than N borrowing and lending direction information collection columns, and a column is divided into more than N sub-heading information entry points from the accounting general ledger account to the second level and below. , The same set of business accounting information documents generated in different periods, different links and different processes constitute a human-machine consensus data chain due to commonality; use the bill column activation table set up by various accounting general ledger accounts to control various types of accounting information documents Assignment of column accounting general ledger titles; use the specific accounting general ledger title assigned in any column of the accounting informationization document to control the assignment of the second and lower sub-items of any column; use the first of the circulation column assignment on the accounting informationization document Level two and three subjects control the flow of the data link, divided into the same level one, two and three subjects to realize the flow of the data link and different levels one, two and three subjects to block the flow of the data link; use the association, special control, and self-control relationship of business information Perform pre-control and post-test on the business information assigned on the accounting information documents to generate the fully controlled accounting information documents. When opening or deriving an accounting informationized document, assigning the accounting general ledger account from the relevant columns and then assigning the second and lower sub-items to form a business information circulation, and then to whether the corresponding business information is related or specifically controlled , Automatic control, all need to visit the expansion, fine-tuning, association, special control, automatic control, and transfer parameters of the system one by one. Only when they meet the requirements, the documents can be generated. Otherwise, the documents cannot be generated.
同理设计由“销售单、发货票、验收单、调拨单、领料单、委托单、受托单、损溢单、专用收款单、专用付款单、收款单、应收单、付款单、应付单等”分别构成数据链的流转和关联关系。In the same way, the design consists of "sales order, invoice, acceptance order, transfer order, material picking order, authorization order, entrusted order, loss and overflow order, special collection order, special payment order, payment order, receivable order, payment "Orders, payables, etc." respectively constitute the circulation and association relationship of the data link.
另外,本申请实施例是以具体会计总账科目控制具体会计信息化单据上的具体栏目赋值来实现科目与单据的录入关系控制,以具体业务为主控项或被控项去管控达成“有我必有你、有因必有果、有果必有因”归口管理业务信息的关联管制,以“专控子目、被控子目”结合具体会计总账科目借方贷方或借贷双方构成专控项目去控制系统内非专控业务信息非被控业务信息的产生,使专控被控子目该有的地方一定有该无的地方一定无达成业务信息的专控管制,在已设制好的会计总账科目控制项下再对其二级及二级以下进行差异性目标性方向性的二次设制达成业务信息的自控管制,利用会计信息化单据上流转栏赋值的一二三级科目控制数据链的流转,分为相同的一二三级科目实现数据链的流转和不同的一二三级科目阻断数据链的流转,生成完全受控的会计信息化单据,进而达到将日常经济信息直接炼化成会计指标,为人机共识及会计智能化提供支持。In addition, in the embodiment of this application, the specific column assignments on the specific accounting informationization documents are controlled by the specific accounting general ledger accounts to realize the control of the entry relationship between the accounts and the documents, and the specific business is the main control item or the accused item to control and achieve "I “There must be you, there must be results, and there must be results” centrally manage the related control of business information, and use “special control sub-items and accused sub-items” combined with specific accounting general ledger items to form a special control project. To control the generation of non-exclusively controlled business information and non-accused business information in the system, so that there must be places where the controlled sub-items should have, and there must be no place where there must be no special control over business information. Under the account control item of the general ledger, the second level and the lower level are differentiated and targeted to achieve the self-control control of business information. The first, second and third level account control is used to assign values to the circulation column on the accounting information document. The circulation of the data link is divided into the same one, two and three subjects to realize the flow of the data link and different subjects at the first, two and three levels to block the flow of the data link, to generate fully controlled accounting information documents, and to achieve the daily economic information It is directly refined into accounting indicators to provide support for man-machine consensus and accounting intelligence.
S103:将所述完全受控的会计信息化单据对应的单据指标信息映射到预先设制的会计账簿中;S103: Map the document index information corresponding to the fully controlled accounting informatization document to a pre-designed accounting book;
在具体实施中,先在系统中设计如“现金账、银行账、综合账、预款账、合同账、货款账、商务账、仓储账、托付账、制造账、成本账、待处账”等十二类会计智能化账簿,用于接受各类会计信息化单据映射来的金额数量分析信息;In the specific implementation, first design such as "cash account, bank account, comprehensive account, advance account, contract account, payment account, business account, storage account, consignment account, manufacturing account, cost account, pending account" in the system. Twelve types of intelligent accounting books are used to receive the amount and quantity analysis information mapped from various accounting information documents;
S104:确定事后控制策略,并利用所述事后控制策略对映射到所述会计账簿中的所述会计信息化单据和累积的累计的账簿指标信息进行再次检测,根据检测结果校正系统数据错误,得到校正后的会计账簿信息;S104: Determine a post-control strategy, and use the post-control strategy to re-check the accounting information documents and accumulated account book index information mapped to the accounting books, and correct system data errors according to the detection results to obtain Corrected accounting book information;
在具体实施中,上述事后控制策略可以包括但不限于业务信息关联关 系逻辑检测项、业务信息专控关系逻辑检测项、业务信息自控关系逻辑检测项、数据链信息化单据及金额检测项、数据链信息化单据及数量检测项、以及现金流量检测项;所述事后控制策略还用于对所述会计账簿和所述目标会计报表进行检测。In specific implementation, the aforementioned post-control strategy may include, but is not limited to, business information association relationship logic detection items, business information specific control relationship logic detection items, business information self-control relationship logic detection items, data link information documents and amount detection items, data Chain informatization documents and quantity detection items, and cash flow detection items; the ex-post control strategy is also used to detect the accounting books and the target accounting statements.
作为一种优选的实施方式,本申请实施例定期或不定期自动或非自动的运用预设制的各类事后控制策略对已有的会计信息化单据、累积的累计的会计账簿信息以及相关会计报表进行检测,并生成各类单据错误信息列表、归宗关系错误信息列表、账随关系错误信息列表、现金流量错误信息列表,为后续评估和校正系统数据提供支持,进而确保了各类会计账簿指标信息的正确性。As a preferred implementation manner, the examples of this application automatically or non-automatically apply various pre-set post-control strategies to existing accounting informationized documents, accumulated accumulated accounting book information, and related accounting information on a regular or irregular basis. Reports are tested, and various types of document error information lists, requisition relations error information lists, account follow-up relations error information lists, and cash flow error information lists are generated to provide support for subsequent evaluation and correction of system data, thereby ensuring various accounting books The correctness of the indicator information.
由上可知,本申请实施例对各会计总账科目设定的关联关系、专控关系、自控关系及数据链归宗关系、数据链账随关系、现金流量表检测关系对系统内已形成的会计信息化单据、会计账簿、会计报表进行事前事后的逻辑控制检测,确保了系统数据的正确性,现行各类财务软件是无法实现这种控制检测功能的。From the above, it can be seen that the association relationship, special control relationship, self-control relationship and data link congregation relationship, data link ledger relationship, and cash flow statement detection relationship set for each accounting general ledger subject in this embodiment of the application have an impact on the accounting that has been formed in the system. Informationized documents, accounting books, and accounting statements carry out pre- and post-event logical control and testing to ensure the correctness of the system data. The current various financial software cannot achieve this control and testing function.
S105:接收和传递用户下达的报表生成命令,获取对应的会计报表模板,根据所述报表生成命令从校正后的会计账簿信息中调取相应的账簿指标信息映射到该会计报表模板中,并获取该会计报表模板任务栏信息之间的计算关系,计算生成目标会计报表。S105: Receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, retrieve the corresponding account book index information from the corrected accounting book information according to the report generation command and map it to the accounting report template, and obtain The calculation relationship between the taskbar information of the accounting report template is calculated to generate the target accounting report.
本步骤中,可以接收业务人员下发的报表生成命令,其中,可以具体包括但不限于目标会计报表及类型、报表起止时间的选择信息。In this step, a report generation command issued by a business person can be received, which can specifically include, but is not limited to, the target accounting report and the type, and the selection information of the start and end time of the report.
接收和传递用户下达的报表生成命令,生成目标会计报表的过程可以具体包括:接收针对会计报表中上标题栏的表项进行设计的选择指令,并建立每个表项选择指令与各类相关会计总账科目的指挥调度关系;接收针对会计报表中任务栏项目的设置指令;设置指令用于将任务栏项目设置为采集项目或计算项目;采集项目用于实现账簿指标与报表指标的映射转换计算关系,计算项目用于实现对报表任务栏内的采集项目及其自身信息进行计算重组;获取会计报表模板中的版面设计内容,并基于版面设计内容确定会计报表的下标题栏;结合上标题栏、任务栏以及下标题栏生成会计 报表。Receiving and transmitting the report generation commands issued by users, the process of generating target accounting statements can specifically include: receiving selection instructions designed for the items in the upper title bar of the accounting statements, and establishing each item selection instruction and various related accounting Command and dispatch relationship of general ledger accounts; receive setting instructions for task bar items in accounting statements; setting instructions are used to set task bar items as collection items or calculation items; collection items are used to realize the mapping conversion calculation relationship between account book indicators and report indicators , The calculation item is used to realize the calculation and reorganization of the collection items in the report task bar and its own information; obtain the layout design content in the accounting statement template, and determine the lower title bar of the accounting statement based on the layout design content; combine the upper title bar, The task bar and the lower title bar generate accounting reports.
在一种优选的实施方式中,本申请实施例提供的会计报表模板之现金流量表中还可以进一步包括错误项、调节项和常态项;其中,所述错误项为在所述现金流量表中增设的用于记录系统数据错误的项目,所述调节项为在所述现金流量表中增设的用于抵消错误项重复采集数据的项目,所述常态项为在所述现金流量表中增设的用于所述现金流量表在任意时间段及时性生成报表的项目。具体地,本实施例对现行基于会计结算后理想化的现金流量表及附表增设错误项和调节项及常态项,使现金流量表及附表因此俱有了任意时间段常态化对系统数据进行错误检测的报表功能。在生成报表时,从会计账簿模块调取指标信息到报表计算模块生成会计报表;当报表增设的错误项和调节项数据不为零时即表示系统内已有的会计信息化单据存在错误因素,当报表增设的常态项数据不为零时即表示为任意时间段的常态化报表,当报表增设的错误项和调节项及常态项数据均为零时即表示为会计结算后无逻辑错误的报表。In a preferred embodiment, the cash flow statement of the accounting statement template provided in the embodiment of the application may further include error items, adjustment items, and normal items; wherein, the error items are in the cash flow statement An item added to record system data errors, the adjustment item is an item added to the cash flow table to offset the repeated collection of error items, and the normal item is an item added to the cash flow table It is used to generate a report item in the cash flow statement in any time period in a timely manner. Specifically, this embodiment adds error items, adjustment items, and normal items to the current idealized cash flow statement and schedule based on accounting settlement, so that the cash flow statement and schedule have any time period normalization to the system data Report function for error detection. When generating the report, call the index information from the accounting book module to the report calculation module to generate the accounting report; when the error item and adjustment item data added to the report are not zero, it means that there are error factors in the existing accounting information documents in the system. When the added normal item data of the report is not zero, it is expressed as a normalized report for any time period. When the added error item, adjustment item and normal item data of the report are all zero, it is expressed as a report without logic errors after accounting settlement. .
还有归宗关系错误检测就是利用数据链的归宗码对系统内已有的海量会计信息化单据进行归宗识别,检出因数据链串号造成会计信息化单据和会计账簿的金额错误;账随关系错误检测就是利用数据链的归宗码对系统内已有的海量物流会计信息化单据进行归宗识别,由海量物流会计信息化单累计的存货账簿余额和由海量物流会计信息化单及时随机结算的余额进行比对,检出因数据链串号和随机原因造成的物流会计信息化单据和会计账簿数量错误。In addition, the error detection of the return relationship is to use the return code of the data link to identify the massive accounting information documents in the system, and to detect the amount of errors in the accounting information documents and accounting books caused by the serial number of the data link; The error detection of the account follow-up relationship is to use the return code of the data link to identify the existing mass logistics accounting information documents in the system, the inventory account book balance accumulated by the mass logistics accounting information form and the mass logistics accounting information form The balance of the random settlement in time is compared, and the number of logistics accounting information documents and accounting books caused by the serial number of the data link and random reasons is detected.
本申请实施例中,利用对业务信息设制的关联、专控、自控关系,对会计账簿建立的归宗和账随关系,对现金流量表及附表增设的“错误项、调节项、常态项”,对新增的和已有的海量会计信息化单据进行事前的开单控制及事后的错误检测;利用对系统数据进行任意时间段常态化的自动或非自动错误检测,以此来捍卫会计报表的正确性也就捍卫了系统数据的正确性。In the embodiments of this application, the association, special control, and self-control relationship established for business information are used, the reconciliation and account follow-up relationship established for the accounting books, and the additional "error items, adjustment items, normal conditions" in the cash flow statement and the attached tables Item", to perform prior billing control and post-error detection of new and existing massive accounting informationized documents; use automatic or non-automatic error detection of system data for any period of time to defend The correctness of the accounting statements also safeguards the correctness of the system data.
由上可知,本申请能够在会计要素数据赋值过程中对其进行检测管控,并可基于事后控制策略对数据进行再次检测,避免数据出现错误,还可以 接收报表生成指令后自动调取相应的信息和计算关系,智能自动化地生成目标会计报表,确保了会计报表数据的正确性,使会计报表俱有了常态化及时性智能性的检测报错功能。It can be seen from the above that this application can detect and control the accounting element data in the process of assigning it, and can check the data again based on the post-control strategy to avoid data errors. It can also automatically retrieve the corresponding information after receiving the report generation instruction In relation to calculation, the target accounting report is generated intelligently and automatically to ensure the correctness of the accounting report data, so that the accounting report has the function of normalization, timeliness and intelligent error detection and reporting.
下面以具体应用实例对本申请实施例提供的会计报表生成方法进行详细地阐述。因现行会计科目的编码是业务信息不俱资源性也就不俱可控性,导致其日常录入的数据是业务信息而非资源信息,以及会计报表是建立在会计结算基础上的和现行会计报表的不完整性,致使系统不能生成俱有常态化检测功能的会计报表,就不能对日常录入的业务信息进行正确性的判别;借贷记账法的记账规则是“有借必有贷,借贷必相等”,说明其只考虑了经济业务的平衡性,没有考虑经济业务的方向性,也就没有考虑经济业务的指标性;教科书上经常能看到“借记或贷记本科目,贷记或借记某某科目”的记账方法,由此说明该记账方法没有指标化和标准化,相同类经济业务可以记录在借方或贷方,如此记账就造成会计账簿借贷方向丧失了独立反映会计指标的功能,报表时只能人脑分析数据系统分析不了,也就丧失了系统的智能性,其会计账簿累积形成的借方发生额或贷方发生额均不能构成独立的指标信息,所有的指标信息要经过人脑对每笔借方发生额与贷方发生额分析后才能得出,跨越的核算期越长则分析的工作量就越大分析的可信度就越差,此时分析的对象就像座数据山,系统无法分析数据的对错及关联性,也就出现了教科书所说的“具体操作中,由于是根据两大主表和部分明细账簿编制现金流量表,数据很难精确,该项目留到最后倒挤填列”。由此,本申请以完全受控的会计信息化单据作为系统数据录入的唯一载体,控制会计信息化单据栏目内会计总账科目与二级及二级以下资源信息的录入和业务信息的关联、专控、自控关系、数据链的流转关系,使日常经济业务标准化指标化,将现行会计报表版面进行系统化设计的同时引入错误项、调节项、常态项内容并给报表类型期间等选择命令与会计总账科目建立指挥调度关系,还给报表指标项目与账簿指标项目设计建立映射转换计算关系,通过事前的控制和事后的检测,自动或非自动的定期或不定期的任意时间段常态化的生成俱有对系统数据进行检测报错功能的报表。The method for generating accounting statements provided in the embodiments of the present application will be described in detail below with specific application examples. Because the coding of the current accounting subjects is that business information is not resourceful and controllable, the data entered daily is business information rather than resource information, and the accounting statements are based on accounting settlements and current accounting statements. Due to the incompleteness of the system, the system cannot generate accounting statements with normalized detection functions, and cannot judge the correctness of the daily entered business information; the bookkeeping rule of the debit and credit accounting method is "If there is a debit, there must be a loan. "Must be equal", which means that it only considers the balance of economic business, does not consider the direction of economic business, and therefore does not consider the index of economic business; textbooks can often see "debit or credit book subjects, credit Or debit the accounting method of "or debit a certain account", which shows that the accounting method is not standardized and standardized. The same type of economic business can be recorded on the debit or credit side. Such accounting will cause the accounting book to lose the direction of debit and credit. The indicator function can only be analyzed by the human brain when reporting data, and the system cannot analyze it, and therefore loses the intelligence of the system. The debit or credit accumulated in its accounting books cannot constitute independent indicator information. All indicator information After the human brain analyzes the amount of each debit and the amount of credit, it can be concluded that the longer the accounting period that spans, the greater the workload of the analysis, the worse the credibility of the analysis, the object of analysis at this time is like In a mountain of data, the system is unable to analyze the right, wrong, and relevance of the data, so the textbook says "in the specific operation, because the cash flow statement is compiled based on the two main tables and some detailed account books, the data is difficult to be accurate. The items are left until the end." Therefore, this application uses fully controlled accounting informatization documents as the only carrier for system data entry, and controls the entry of accounting general ledger items in the accounting informatization documents column and the entry of secondary and lower resource information and the association and specialization of business information. The relationship between control, self-control, and the flow of data links makes daily economic business standardized indicators, systematically design the layout of current accounting statements, and introduce error items, adjustment items, and normal items, and select command and accounting for report types and periods. The general ledger accounts establish the command and dispatch relationship, and also establish the mapping conversion calculation relationship for the report indicator project and the account book indicator project design. Through the pre-control and post-test, the automatic or non-automatic regular or irregular time period is normalized. There are reports with the function of detecting and reporting errors on system data.
本申请放弃了现行财务软件对业务信息的“表格导入、单据录入(不可控的)、会计记账凭证直接填入”造成无法逻辑判别而出现的错误和不可控,选择以完全受控的会计信息化单据作为唯一载体以资源的方式录入日常经济业务信息并对其加以关联、专控、自控、流转逻辑关系的判别,使日常经济业务信息实现了标准化指标化,以财务费用为例,其借方永远只能录入发生额,其贷方永远只能录入分配额,如此会计账簿的借方或贷方或余额累积的或累计的就分类别的或汇总的构成了单个的或类别的但唯一的指标信息,此时系统及人脑均可简单的方便的利用该指标化信息生成会计报表。This application abandons the current financial software’s "form import, document entry (uncontrollable), direct entry of accounting vouchers" for business information, which causes errors and uncontrollable errors that cannot be determined logically. Choose a fully controlled accounting Informatization documents are the only carrier to enter daily economic business information in the form of resources and to associate, control, self-control, and determine the logical relationship of circulation, so that daily economic business information can be standardized and indexed. Take financial expenses as an example. The debit can always only enter the occurrence amount, and its credit can always only enter the distribution amount, so the debit or credit of the accounting book or the accumulated or accumulated balance is classified or aggregated to form a single or category but unique indicator information At this time, both the system and the human brain can simply and conveniently use the indexed information to generate accounting statements.
进一步地,本申请将现行国税版的会计报表一字一行不差的原样设计进系统内;将设计进系统内会计报表分为上标题栏、任务栏、下标题栏;在上标题栏内增设如:资产负债表、利润表、现金流量表、现金流量附表、年报、季报、月报和前变量期,年、月、日及后变量期,年、月、日的选择命令,报表时将被选中的选择命令传递到会计账簿模块调取指标信息到报表计算模块生成会计报表;并将其任务栏内的项目分别设计为采集项目、计算项目,将所有的采集项目全部映射到各会计总账科目内用于设制各会计总账科目及各级子目与相关会计报表任务栏内采集项目的计算关系,实现会计账簿指标与会计报表指标的互通。按国税版相关会计报表设计其下标题栏。Furthermore, in this application, the current national tax version of the accounting statements are designed line by line into the system; the accounting statements designed into the system are divided into an upper title bar, a task bar, and a lower title bar; the upper title bar is added Such as: balance sheet, income statement, cash flow statement, cash flow appendix, annual report, quarterly report, monthly report and previous variable period, year, month, day and subsequent variable period, year, month, day selection command, report time Pass the selected selection command to the accounting book module to retrieve index information to the report calculation module to generate accounting statements; design the items in the task bar as collection items and calculation items, and map all collection items to each accountant The general ledger account is used to set up the calculation relationship between each accounting general ledger account and sub-items at all levels and the collection items in the relevant accounting statement task bar, so as to realize the intercommunication of accounting book indicators and accounting statement indicators. Design the title column according to the relevant accounting statements of the National Tax Edition.
另外,本申请在现金流量表及附表中增设了错误项和调节项及常态项,从而解决了以往现金流量表及附表需要通过会计结算后,由资产负债表、利润表、等框算得出,如数据不平采取倒挤方式填列。现在能够常态化的直接生成现金流表及附表,并检测去除了系统内已有的会计信息化单据的逻辑错误后,再生成资产负债表及利润表。In addition, this application adds error items, reconciliation items, and normal items to the cash flow statement and the attached table, which solves the problem that the previous cash flow statement and attached table need to be settled by accounting and calculated from the balance sheet, income statement, etc. If the data is not flat, the data shall be filled in by inverted squeeze method. Now it is possible to directly generate the cash flow statement and the attached tables in a normal way, and after detecting and removing the logical errors of the existing accounting information documents in the system, the balance sheet and the income statement can be generated.
基于上述改进的基础上,本申请可以解决以往只能做完期末会计结算后才能生成会计报表,实现截取任意时间段账簿的指标数据生成会计报表,即常态化报表。Based on the above improvements, this application can solve the problem that in the past, accounting statements could only be generated after the end-of-term accounting and settlement, and it can intercept the index data of the account books at any time period to generate accounting statements, that is, normalized statements.
具体地,本申请首先在系统中对各类会计总账科目借贷方向二级及二级以下子目分别按管理的要求进行对称的或非对称的无限拓展设制;在系 统中设计各类会计信息化单据,使所有经济业务在系统内均有单据可开可控;在系统中对各类会计总账科目设定各类会计信息化单据相关栏目与该会计总账科目的“是否启用”选择;开单时系统利用会计信息化单据相关总账栏目赋值的具体会计总账科目其拓展方式控制该会计信息化单据二级及二级以下子目的赋值;开单时系统利用业务信息的关联、专控、自控方法控制预开会计信息化单据上对应业务信息的逻辑关系;开单时系统利用订、销、发、资金、物流、收款、付款、等命令控制同一组经济业务在不同时期不同环节不同过程产生的会计信息化单据的流转结果,实现由信息智能管控到日常经济业务的指标化。也即,本申请在系统内设制好各会计总账科目的单据、微调、关联、专控、自控、流转关系,作为事前控制项目,在开单填制会计信息化单据上各栏目的资源信息时,自动访问事前控制项目;当具体赋值的资源信息与预先设制的资源信息完全匹配和业务信息的关联、专控、自控、流转关系通过时,即表示该指标化单据可以产生,否则单据不能产生。通过上述步骤能够对企事单位日常发生的所有经济业务均做到可控的有单据可开,也就是由信息智能管控到日常经济业务的指标化。Specifically, this application first implements a symmetrical or asymmetrical unlimited expansion system for various accounting general ledger subject lending directions in the second and lower sub-items according to management requirements in the system; design various types of accounting information in the system Documents can be opened and controlled in the system for all economic business; set various accounting informationized documents related fields for various accounting general ledger items in the system and the "Enable or Not" selection of the general accounting subjects; open The single-time system uses the specific accounting general ledger items assigned to the relevant general ledger fields of the accounting information documents to control the assignment of the second and lower sub-purposes of the accounting information documents; the system uses the association, special control, and self-control of the business information when issuing the bills Method to control the logical relationship of the corresponding business information on the pre-opened accounting information documents; when issuing the bill, the system uses orders, sales, issuance, capital, logistics, collection, payment, etc. to control the same group of economic business in different periods, different links and different processes The result of the circulation of the generated accounting information documents realizes the indexing from the intelligent management of information to the daily economic business. That is, this application sets up the documents, fine-tuning, association, special control, self-control, and circulation relations of each accounting general ledger account in the system, as a pre-control item, fill in the resource information of each column on the accounting informationization document in the billing When the specified value of the resource information is fully matched with the pre-set resource information and the relationship, exclusive control, self-control, and circulation of the business information are passed, it means that the indexed document can be generated, otherwise the document Can't produce. Through the above steps, all the daily economic operations of the enterprise can be controlled and documented, that is, from the intelligent management of information to the indexing of daily economic operations.
本申请进而通过对会计报表版面的系统化设计及指标映射传递命令计算生成会计报表。具体地,将现行会计报表的上标题栏、任务栏、下标题栏进行版面化设计,在上标题栏内增设报表选择项类型,如:年报、季报、月报和前变量期,年、月、日及后变量期,年、月、日,将任务栏项目设计为采集项目、计算项目;将上述步骤设制的采集项目全部映射到各会计总账科目内用于设制各会计总账科目及各级子目指标与相关会计报表任务栏内采集项目的映射转换计算关系,实现会计账簿指标与会计报表指标的互通;将会计报表的上标题栏、任务栏、下标题栏版面及报表选择项类型,如:年报、季报、月报和前变量期,年、月、日及后变量期,年、月、日和采集项目、计算项目映射到报表计算模块;在生成报表时,在计算模块内选择相关报表的类型,如:年报、季报、月报和前变量期,年、月、日及后变量期,年、月、日命令,传递到会计账簿模块调取指标信息生成会计报表。This application further generates accounting statements through the systematic design of accounting statement layouts and index mapping transmission commands. Specifically, layout the upper title bar, task bar, and lower title bar of the current accounting report, and add report options in the upper title bar, such as: annual report, quarterly report, monthly report, and previous variable period, year, month , Day and post variable period, year, month, day, design the taskbar items as collection items and calculation items; map all the collection items set up in the above steps to each accounting general ledger account for setting up each accounting general ledger account and The mapping conversion calculation relationship between the sub-item indicators at all levels and the collection items in the task bar of the relevant accounting statements, to realize the intercommunication between the accounting book indicators and the accounting statement indicators; the upper title bar, task bar, lower title bar layout and report selection items of the accounting report Types, such as: annual report, quarterly report, monthly report and pre-variable period, year, month, day and post-variable period, year, month, day and collection items, calculation items are mapped to the report calculation module; when the report is generated, in the calculation module Select the type of related reports in the menu, such as: annual report, quarterly report, monthly report and variable period before, year, month, day and after variable period, year, month, and day commands, and pass them to the accounting book module to retrieve index information to generate accounting statements.
进一步地,本申请对现行基于会计结算后理想化的现金流量表及附表增设错误项和调节项及常态项,实现会计报表任意时间段常态化及时性的错误检测。也即,对现行基于会计结算后理想化的现金流量表及附表增设错误项和调节项及常态项;在生成报表时,从会计账簿模块调取指标信息到报表计算模块生成会计报表;当报表新增的错误项和调节项数据不为零时即表示系统内已有的会计信息化单据存在错误因素,当报表新增的常态项数据不为零时即表示为常态化报表,当报表新增的错误项和调节项及常态项数据均为零时即表示为会计结算后无逻辑错误的报表。Furthermore, this application adds error items, adjustment items, and normal items to the current idealized cash flow statement after accounting settlement and its attached tables, so as to realize the error detection of the normalization and timeliness of the accounting statements at any time period. That is, add error items, reconciliation items, and normal items to the current idealized cash flow statement and appendix based on accounting settlement; when generating statements, call index information from the accounting book module to the statement calculation module to generate accounting statements; when When the newly-added error item and adjustment item data in the report is not zero, it means that there are error factors in the existing accounting information documents in the system. When the newly-added normal item data in the report is not zero, it is expressed as a normalized report. When the newly added error items, adjustment items, and normal item data are all zero, it means that there is no logical error after the accounting settlement.
另外,本申请还进一步对会计信息化单据、会计账簿、会计报表进行事后纠错。具体地,将对各会计总账科目设定的关联关系、专控关系、自控关系及数据链归宗关系、数据链账随关系、现金流量纠错关系组成事后检测项目;检测时以上述关联关系、专控关系、自控关系为依据对系统已经存在的会计信息化单据进行事后逻辑检测;以数据链归宗关系、数据链账随关系为依据对系统内有归宗关系、账随关系的会计账簿进行事后逻辑检测;以现金流量纠错关系为依据对系统内有纠错关系的会计报表进行实时逻辑检测;经过检测后可以分别生成各类单据错误信息列表、归宗关系错误信息列表、账随关系错误信息列表、现金流量错误信息列表,供相关人员事后分析处理。In addition, this application further corrects the accounting informationization documents, accounting books, and accounting statements afterwards. Specifically, the association relationship, special control relationship, self-control relationship, data link reunification relationship, data link account follow relationship, and cash flow error correction relationship set for each accounting general ledger account are formed into a post-test item; the above-mentioned relationship is used for testing. , Based on the exclusive control relationship and self-control relationship, perform post-logic detection of the accounting information documents that already exist in the system; based on the data link relegation relationship and the data link account relationship relationship, the accounting that has the relegation relationship and the account follower relationship in the system The account book is subjected to post-event logical detection; based on the cash flow error correction relationship, real-time logical detection of the accounting statements with error correction relationships in the system; after the detection, various types of document error information lists, reconciliation error information lists, and accounts can be generated respectively. The list of error information along with the relationship and the list of cash flow error information are provided for the relevant personnel to analyze and process afterwards.
具体地,下面对本申请实施例提供的由信息智能管控到常态化会计报表方法进行进一步介绍,具体包括:Specifically, the following further introduces the method from intelligent information management to normalized accounting statements provided by the embodiments of the present application, which specifically includes:
步骤一,对日常经济业务进行指标化的事前管控,即对会计科目拓展进行微调、对业务信息的关联关系、对业务信息的专控关系和自控关系进行管控;Step one is to carry out index-based pre-control of daily economic business, that is, to fine-tune the expansion of accounting subjects, to control the relationship of business information, and to control the relationship of exclusive control and self-control of business information;
其中,①会计科目的微调是对设定了的拓展项,进行集团项目中的个别子目停用,或利用精细项目增设个别子目,达到对拓展项二级及二级以下子目对称性与非对称性无限拓展的要求;②业务信息的关联,就是产生了A业务信息必定产生B业务信息这就是关联,也就说“有我必有你、有因必有果、有果必有因”,在会计智能化系统内会计的管理对象是一个个独立的资源,由控制项按管理的要求将各类资源组成无穷的业务信息,因资源 的独立性就具备了人机共识也就为人机管理业务信息提供了操手;具体的就是在系统中设定以A会计总账科目结合其借方或贷方作为主控项去控制B会计总账科借方或贷方二级三级子目的使用,此时B会计总账科结合其借方或贷方三级子目就构成了被控项,被控项必须寻找主控项,设置主被控后又可对其主被控业务信息设同级互控和交叉互控;例关联关系的具体应用,薪酬类是要进行归口管理的,各级各类业务部门计提的成本薪酬理论上讲是要归口到《应付职工薪酬会计总账科目》统一管理的,此时应付职工薪酬会计总账科目贷方与各类计提薪酬会计总账科目借方就形成了关联关系,再以销售费用下薪酬类设制关联关系为例,具体操作就是以“应付职工薪酬会计总账科目的贷方”作为“主控项”去控制“销售费用会计总账科目的借方具体二级子目及三级薪酬类子目”的使用,当然此时“销售费用会计总账科目的借方和三级薪酬类子目”就构成了被控项,当主被控设好后又可对两互控的业务信息设制同级互控和交叉互控关系;系统利用此对赋值过程中或系统内已有的会计信息化单据进行存在关联项是否构成“主被控建立、被主控建立”的事前事后检测,否则报错;③业务信息的专控,就是将“专控子目、被控子目”与指定会计总账科目的借方贷方或借贷双方至专控级次组成专控业务信息,具体分为专控子目专控和被控子目专控两类;专控子目专控就是将专控子目和指定会计总账科目的借方贷方或借贷双方至专控级次组成专控业务信息,系统利用此对赋值过程中或系统内已有的会计信息化单据进行专控子目非专控业务信息、非被控业务信息排他的事前事后检测,否则报错;被控子目专控就是将被控子目和指定会计总账科目的借方贷方或借贷双方至专控级次组成专控业务信息,系统利用此对赋值过程中或系统内已有的会计信息化单据进行被控子目非专控业务信息、非被控业务信息排他的事前事后检测,否则报错;系统利用“专控子目、被控子目”对归口管理和指标性子目进行无限的精确定位管理,达到归口管理和指标性子目该有的地方一定有,该无的地方一定无,如《税收滞纳金专控子目》,该专控子目只在《营业外支出会计总账科目》下才有列支,任何一个会计子目均可设为“专控子目、被控子目”,专控子目和被控子目只能构成专控业务信息、被控业务信息,目的是加强对系统 中“归口管理和指标性子目”指标的专控管理;④业务信息的自控,就是由具体会计总账科目结合其借方贷方或借贷双方作为自控项,去对其二级及二级以下使用子目进行差异性目标性方向性的二次管控,也是对设定了的拓展项进行自控业务信息的再分类,系统利用此对赋值过程中或系统内已有的会计信息化单据进行自控项非自控业务信息排他的事前事后检测,否则报错;如:某企业设有“内部往来”一级会计总账科目,其二级分为“部门往来、个人往来”两类核算,其三级分为“行政部、生产部、销售部、等部门、张三、李四、王五、等个人”部门人员混合的N多明细核算;为了不使二级“部门往来”后串三级“人员”、也为了不使二级“个人往来”后串三级“部门”的错误产生,为此我们对“内部往来”一级会计总账科目进行两类自控设制,其一为“内部往来、借贷双方、部门往来、部门类”,其二为“内部往来、借贷双方、个人往来、员工类”;Among them, ① The fine-tuning of accounting subjects is to deactivate individual sub-items in the group project for the set expansion items, or use fine items to add individual sub-items to achieve symmetry of the expansion items at the second level and below. With the requirement of unlimited expansion of asymmetry; ②The association of business information means that A business information must produce B business information. "Because", the accounting management objects in the accounting intelligent system are independent resources, and various resources are composed of control items according to management requirements to form infinite business information. Because of the independence of resources, there is a consensus between man and machine. It provides a manipulator for man-machine management business information; specifically, it is set in the system to use A accounting general ledger account combined with its debit or credit as the main control item to control the use of B accounting general ledger debit or credit secondary and tertiary sub-purposes. When the B Accounting General Ledger Section combines its debit or credit three-level sub-items to form the accused item, the accused item must look for the main control item. After setting the main charge, it can set the same level of mutual control and control of its main charge business information. Cross and mutual control; For example, the specific application of the association relationship, the salary category should be managed centrally, and the cost and salary accrued by various business departments at all levels should theoretically be centralized under the unified management of the "Employee Salary Accounting General Ledger Account". At this time, there is an association relationship between the credit of the accounting general ledger account of employee compensation payable and the debit of the various accrued salary accounting general ledger accounts. Then take the relationship of the salary category under the sales expense as an example. The specific operation is to "employee compensation accounting general ledger "Credit" is used as the "main control item" to control the use of "Debit specific secondary sub-items and three-level salary category sub-items of the general ledger of sales expense accounting". "Category sub-item" constitutes the controlled item. When the master is set up, the two mutually controlled business information can be set up with the same level mutual control and cross mutual control relationship; the system uses this pair in the process of assigning value or has already existed in the system. The accounting informationization documents of the company are tested before and after the existence of related items constitute "the establishment of the master and the accused," The debit and creditor or both the borrower and the lender of the designated accounting general ledger account form the special control business information, which is specifically divided into two types: special control sub-items, special control and accused sub-items. Controlling subheadings and designated accounting general ledger accounts, the borrower and lender or both parties to the special control level form special control business information, and the system uses this to perform special control subheads non-special control on the existing accounting information documents in the valuation process or in the system Business information and non-accused business information are exclusively tested before and after, otherwise an error will be reported; the accused sub-item special control is to combine the accused sub-item and the debit and lender of the designated accounting general ledger account to the special control level to form special control business information , The system uses this to perform pre- and post-detection of the non-specific control business information and non-accused business information of the accused sub-items during the valuation process or the existing accounting information documents in the system, otherwise it will report an error; the system uses the "special-control sub-items" "Accounted sub-items" carry out unlimited and precise positioning management of centralized management and index sub-items to achieve centralized management There must be places where management and indicator subheadings should exist, and there must be no places where they shouldn't. For example, the "Special Controlling Subhead of Tax Late Payment", this special control subheading is only listed under the "Non-operating Expenditure Accounting General Ledger Account". Any accounting sub-item can be set as "specially controlled sub-item and accused sub-item", and the exclusively-controlled sub-item and the accused sub-item can only constitute the specialized control business information and the accused business information. The purpose is to strengthen the control of the system. Centralized management and dedicated control management of index sub-items" indicators; ④The self-control of business information is to combine specific accounting general ledger items with its borrower, lender, or both parties as a self-control item to make differences between the sub-items used at the second and lower levels The secondary management and control of the specific target direction is also the reclassification of the self-control business information of the set expansion items. The system uses this to perform the self-control item non-self-control business information on the accounting information documents that exist in the value assignment process or in the system Exclusive pre- and post-test, otherwise an error will be reported; for example, an enterprise has an "internal transaction" first-level accounting general ledger account. Production department, sales department, and other departments, Zhang San, Li Si, Wang Wu, and other individual" department personnel mixed N multiple detailed accounting; in order not to make the second-level "departmental exchanges" followed by the third-level "personnel", and also to avoid To cause the error of the second-level "personal transactions" followed by the third-level "departments", we have implemented two types of self-control settings for the "internal transactions" level-one accounting general ledger, one of which is "internal transactions, borrowing and lending, and departmental transactions." , Department category", the second is "internal transaction, borrower and lender, personal transaction, employee category";
步骤二,对理想化的现金流量表及附表引入“错误因素对现金流量的影响、错误因素调节、常态化补充”项目;Step 2: Introduce "the influence of error factors on cash flow, adjustment of error factors, and normalization of supplements" to the idealized cash flow statement and attached tables;
具体包括:对理想化的现金流量表及附表引入错误因素对现金流量的影响、错误因素调节项目,实现报表信息的完整性及错误检测;对建立在期末会计结算基础上的现金流量附表引入常态化补充项目,使其具有常态化报表的功能;Specifically, it includes: introducing the influence of error factors on cash flow in the idealized cash flow statement and attached tables, adjusting the items of error factors, realizing the completeness of statement information and error detection; and attaching to the cash flow attached statement based on period-end accounting and settlement. Introduce normalized supplementary items to make it have the function of normalized report;
步骤三,为确保会计信息化单据、会计账簿、会计报表的正确性对系统建立事后检测模块;Step three, in order to ensure the accuracy of accounting informationization documents, accounting books, and accounting statements, establish a post-test module for the system;
具体包括:将各科目设定的业务信息关联关系信息汇总成业务信息关联关系逻辑检测项目;将各科目设定的业务信息被控关系信息和业务信息专控关系信息汇总成业务信息专控关系逻辑检测项目;将各科目设定的业务信息自控关系信息汇总成业务信息自控关系逻辑检测项目;利用数据链的归宗关系建立数据链信息化单据及金额检测(归宗法)项目;利用数据链的账随关系建立数据链信息化单据及数量检测(账随法)项目;利用现金流量表及附表的错误因素对现金流量的影响、错误因素调节建立“金流量检测项目;由以上六项共同构成事后检测模块对系统信息进行错误检测:Specifically include: summarizing the business information association relationship information set by each subject into a business information association relationship logic test item; summarizing the business information controlled relationship information and business information specific control relationship information set for each subject into a business information dedicated control relationship Logical test items; summarize the business information self-control relationship information set by each subject into business information self-control relationship logic test items; use the data link to establish data link information documents and amount detection (patriarchy) items; use the data link The establishment of data link information documents and quantity testing (accounts with method) project; the influence of error factors in the cash flow statement and attached tables on cash flow and the adjustment of error factors to establish a "gold flow detection project; Together to form a post-detection module for error detection of system information:
步骤四,对会计报表版面进行系统化设计;Step four, systematically design the layout of accounting statements;
具体地,对会计报表的上标题栏、任务栏、下标题栏版面进行系统化设计;在会计报表的上标题栏内增设类型,如:年报、季报、月报,选择前变量期,年、月、日和后变量期,年、月、日等非打印的选择命令;将会计报表的任务栏项目设计转化为采集项目、计算项目,再将采集项目映射到各会计总账科目内用于报表和账簿指标的关联设制计算,由计算项目计算报表任务栏的逻辑关系;以“现金流量表任务栏项目设制”为例,在此设定现金流量表任务栏内的所有采集项目和计算项目,并将设定好的采集项目映射到所有会计总账科目内的“现金流量表采集项目(指标化)选制”下,供其选择设定会计科目指标与现金流量表任务栏采集项目关联的设制计算公式;在会计总账科目列表内对每一个具体的总账科目分别设定其与“资产负债表、利润表、现金流量表及附表”任务栏采集项目指标的映射关系,实现科目与报表信息的互联;在会计报表的下标题栏内设计打印流水号、打印密码等项目;Specifically, systematically design the upper title bar, task bar, and lower title bar layouts of accounting statements; add types in the upper title bar of accounting statements, such as annual report, quarterly report, and monthly report, select the previous variable period, year, Month, day and post-variable period, year, month, day and other non-printing selection commands; convert the task bar item design of accounting statements into collection items and calculation items, and then map the collection items to each accounting general ledger account for reporting For the calculation of the association setting with the account book index, the logical relationship of the report task bar is calculated by the calculation item; take the "cash flow statement task bar item setting" as an example, set all the collection items and calculations in the cash flow statement task bar here Project, and map the set collection items to the "Cash Flow Statement Collection Items (Indexed) Selection System" in all general ledger accounts, so that they can choose to set the accounting title indicators to associate with the cash flow statement task bar collection items The calculation formula of the system; in the accounting general ledger account list, for each specific general ledger account, set the mapping relationship between it and the "balance sheet, income statement, cash flow statement and appendix" task bar collection item index to realize the account Interconnection with report information; design and print serial number, print password and other items in the title bar of the accounting report;
以上四项步骤完成后,生成报表时通过选择类型,如:年报、季报、月报,即可自动变更相应的报表显示值,选择前变量期,年、月、日和后变量期,年、月、日即可采集相应期的数据,并将此选择命令传导至会计账簿模块计算调取数据生成会计报表。After the above four steps are completed, you can automatically change the display value of the corresponding report by selecting the type when generating the report, such as annual report, quarterly report, and monthly report. Select the previous variable period, year, month, day and post variable period, year, The month and day can collect the data of the corresponding period, and transmit this selection command to the accounting book module to calculate and retrieve the data to generate an accounting report.
下面对本申请实施例提供的一种会计报表生成装置进行介绍,下文描述的一种会计报表生成装置与上文描述的一种会计报表生成方法可以相互参照。The following describes an accounting statement generating device provided in an embodiment of the present application. The accounting statement generating device described below and the accounting statement generating method described above can be cross-referenced.
参见图2所示,本申请实施例提供的一种会计报表生成装置包括:As shown in Fig. 2, an accounting statement generating device provided by an embodiment of the present application includes:
事前控制模块201,用于确定用于在数据赋值过程中对数据进行检测和管控的事前控制策略;The advance control module 201 is used to determine the advance control strategy used to detect and manage the data in the data assignment process;
数据赋值模块202,用于获取用户赋值的会计要素数据,利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据;The data assignment module 202 is used to obtain the accounting element data assigned by the user, use the prior control strategy to control the accounting element data in the assignment process, and generate fully controlled accounting information documents;
数据映射模块203,用于将所述完全受控的会计信息化单据对应的单据指标信息映射到预先设制的会计账簿中,给各类会计报表任务栏采集项目与各类会计总账科目账簿指标建立映射转换计算关系;The data mapping module 203 is used to map the document index information corresponding to the fully controlled accounting informationization document to a pre-designed accounting book, and collect items for various accounting report task columns and various accounting general ledger account book indicators Establish the mapping conversion calculation relationship;
在具体实施中,先在系统中设计如“现金账、银行账、综合账、预款账、合同账、货款账、商务账、仓储账、托付账、制造账、成本账、待处账”等十二类会计智能化账簿,用于接受各类会计信息化单据映射来的金额数量分析信息,再在系统中将各类会计报表的任务栏分为采集项目和计算项目,将各类采集项目全映射到各类会计总账科目的编辑处,用于设制各类会计总账科目账簿指标与各类会计报表指标具体的射转换计算关系;In the specific implementation, first design such as "cash account, bank account, comprehensive account, advance account, contract account, payment account, business account, storage account, consignment account, manufacturing account, cost account, pending account" in the system. Twelve types of intelligent accounting books are used to receive the amount and quantity analysis information mapped from various accounting information documents, and then divide the taskbars of various accounting statements into collection items and calculation items in the system, Projects are all mapped to the editing office of various accounting general ledger accounts, which are used to establish the specific conversion calculation relationship between various accounting general ledger account book indicators and various accounting statement indicators;
事后控制模块204,用于确定事后控制策略,并利用所述事后控制策略对映射到所述会计账簿中的所述会计信息化单据和累计的账簿指标信息进行再次检测,根据检测结果校正系统数据错误,得到校正后的会计账簿信息;The post-control module 204 is used to determine the post-control strategy, and use the post-control strategy to re-check the accounting informationized documents and the accumulated account book index information mapped to the accounting book, and correct the system data according to the detection result Error, get the corrected accounting book information;
报表生成模块205,用于接收和传递用户下达的报表生成命令,获取对应的会计报表模板,根据所述报表生成命令从校正后的会计账簿信息中调取相应的账簿指标信息映射到该会计报表模板中,并获取该会计报表模板任务栏信息之间的计算关系,计算生成目标会计报表。The report generation module 205 is used to receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, and retrieve the corresponding account book index information from the corrected accounting book information according to the report generation command and map it to the accounting report. In the template, the calculation relationship between the task bar information of the accounting report template is obtained, and the target accounting report is calculated and generated.
关于上述模块201至205的具体实施过程可参考前述实施例公开的相应内容,在此不再进行赘述。For the specific implementation process of the foregoing modules 201 to 205, reference may be made to the corresponding content disclosed in the foregoing embodiments, and details are not described herein again.
下面对本申请实施例提供的会计报表生成系统进行介绍,参见图3和图4所示,该系统包括会计总账科目模块,即事前控制模块;会计信息化单据模块;会计账簿模块;报表设制模块;报表计算模块;事后检测模块。The following describes the accounting report generation system provided by the embodiments of the application. As shown in Figures 3 and 4, the system includes an accounting general ledger account module, that is, a pre-control module; an accounting informationization document module; an accounting book module; and a report design module ; Report calculation module; post-detection module.
具体地,在会计总账科目模块内为每个会计总账科目设制:属性设制表、拓展及微调设制表、票据栏目启用表、业务信息关联设制表、业务信息专控设制表、业务信息自控设制表、与资产负债表关联设制表、与利润表关联设制表、与现金流量表关联设制表,由此对票据启用、科目拓展、信息化单据生成及流转、业务信息的关联、专控、自控关系、会计报表采集项目与会计科目及会计账簿指标项目的调取计算关系进行事前控制管理。Specifically, in the accounting general ledger account module, set up a system for each general account ledger: attribute setting tabulation, expansion and fine-tuning tabulation, bill column activation tabulation, business information association tabulation, business information special control tabulation, Self-control of business information tabulation, tabulation associated with the balance sheet, tabulation associated with the income statement, tabulation associated with the cash flow statement, thereby enabling bill activation, account expansion, informatization document generation and circulation, and business Information association, special control, self-control relationship, accounting statement collection project and accounting title and accounting book index project retrieval calculation relationship for prior control management.
会计信息化单据模块,利用各类会计总账科目设置的票据栏目启用表控制各类会计信息化单据上的各类栏目会计总账科目的赋值,利用会计信息化单据上任一栏目中赋值的具体会计总账科目控制所述任一栏目的二级 及二级以下子目的赋值,利用会计信息化单据上流转栏赋值的一二三级科目控制数据链的流转,分为相同的一二三级科目实现数据链的流转和不同的一二三级科目阻断数据链的流转,利用业务信息的关联、专控、自控关系对会计信息化单据上赋值的业务信息进行事前控制和事后检测,生成所述完全受控的会计信息化单据,由此对日常业务进行事前管控,使经济信息以指标化的方向形成会计信息化单据。Accounting informatization bill module, using the bill column activation table set by various accounting general ledger accounts to control the assignment of various accounting general ledger accounts on various accounting informatization documents, and using the specific accounting general ledger assigned in any column on accounting informatization documents Assign values to the second and lower sub-objects of any column in the account control, use the first, second and third levels assigned in the circulation column on the accounting information document to control the flow of the data link, and divide the data into the same one, two and three subjects to achieve data The circulation of the chain and different one, two and three levels of subjects block the circulation of the data chain, and use the association, special control, and self-control relationship of business information to perform pre-control and post-testing on the business information assigned on the accounting information documents to generate the complete Controlled accounting informatization documents, from which the daily business is controlled in advance, so that economic information can form accounting informatization documents in the direction of indexing.
会计账簿模块,在此模块内设“现金账、银行账、综合账、预款账、合同账、货款账、商务账、仓储账、托付账、制造账、成本账、待处账”,由此十二类会计智能化账簿接收记录并传递会计信息化单据的指标信息,按报表计算模块给出的相应“报表类型、起始时期、终止时期”命令结合各类会计总账模块映射过来的“会计总账与相应报表关联设制表”计算调取相关账簿信息传递至报表计算模块生成相关报表。Accounting book module, in this module there are "cash account, bank account, consolidated account, advance account, contract account, payment account, business account, storage account, consignment account, manufacturing account, cost account, pending account". These twelve types of intelligent accounting books receive records and transmit the index information of accounting informationized documents, which are mapped from various accounting general ledger modules according to the corresponding "report type, start period, and end period" commands given by the report calculation module. "Accounting general ledger and corresponding reports are linked to set up a table" to calculate and retrieve relevant account book information and pass it to the report calculation module to generate relevant reports.
报表设制模块,在此设制各类会计报表的上标题栏、任务栏、下标题栏版面并传递至报表计算模块,在各类报表的任务栏内设制采集项目、计算项目,将采集项目映射到会计总账模块内所有会计科目的会计总账与相应报表关联设制表上进行选择设制,实现总账科目与会计报表信息的互联,用计算项目对任务栏内的采集项目、计算项目进行逻辑管理。Report design module, where the upper title bar, task bar, and lower title bar layouts of various accounting statements are created and passed to the report calculation module. Collection items and calculation items are set in the task bars of various reports, and the collection will be collected Projects are mapped to the accounting general ledger of all accounting subjects in the accounting general ledger module and the corresponding report associations are set up on the table to realize the interconnection of general ledger subjects and accounting report information. Use calculation items to perform collection and calculation items in the taskbar. Logical management.
报表计算模块,设资产负债表、利润表、现金流量表及附表,生成报表时在相应报表的上标题栏内选择报表类型、起始时期、终止时期的命令并传递至会计账簿模块计算调取数据生成会计报表。The report calculation module includes a balance sheet, profit statement, cash flow statement, and appendix. When generating a report, select the report type, start period, and end period commands in the upper title bar of the corresponding report and pass them to the accounting book module for calculation and adjustment. Obtain data to generate accounting statements.
事后检测模块,由业务信息关联关系逻辑检测、业务信息专控关系逻辑检测、业务信息自控关系逻辑检测、数据链信息化单据及金额检测、数据链信息化单据及数量检测、现金流量检测,对系统的会计信息化单据、会计账簿、会计报表进行事后检测。The post-mortem detection module is composed of business information association relationship logic detection, business information special control relationship logic detection, business information self-control relationship logic detection, data link informatization documents and amount detection, data link informatization documents and quantity detection, and cash flow detection. The system's accounting information documents, accounting books, and accounting statements are tested after the fact.
本申请还提供了一种电子设备,参见图5所示,本申请实施例提供的一种电子设备包括:The present application also provides an electronic device. As shown in FIG. 5, an electronic device provided by an embodiment of the present application includes:
存储器100,用于存储计算机程序;The memory 100 is used to store computer programs;
处理器200,用于执行所述计算机程序时可以实现上述实施例所提供的步骤。The processor 200 is configured to implement the steps provided in the foregoing embodiments when executing the computer program.
具体的,存储器100包括非易失性存储介质、内存储器。该非易失性存储介质存储有操作系统和计算机可读指令,该内存储器为非易失性存储介质中的操作系统和计算机可读指令的运行提供环境。处理器200在一些实施例中可以是一中央处理器(Central Processing Unit,CPU)、控制器、微控制器、微处理器或其他数据处理芯片,为电子设备提供计算和控制能力,执行所述存储器100中保存的计算机程序时,可以实现前述任一实施例公开的会计报表生成方法的步骤。Specifically, the memory 100 includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer-readable instructions, and the internal memory provides an environment for running the operating system and the computer-readable instructions in the non-volatile storage medium. In some embodiments, the processor 200 may be a central processing unit (CPU), controller, microcontroller, microprocessor, or other data processing chip, which provides computing and control capabilities for electronic devices, and executes the The computer program stored in the memory 100 can implement the steps of the method for generating accounting statements disclosed in any of the foregoing embodiments.
在上述实施例的基础上,作为优选实施方式,参见图6所示,所述电子设备还包括:On the basis of the foregoing embodiment, as a preferred implementation manner, referring to FIG. 6, the electronic device further includes:
输入接口300,与处理器200相连,用于获取外部导入的计算机程序、参数和指令,经处理器200控制保存至存储器100中。该输入接口300可以与输入装置相连,接收用户手动输入的参数或指令。该输入装置可以是显示屏上覆盖的触摸层,也可以是终端外壳上设置的按键、轨迹球或触控板,也可以是键盘、触控板或鼠标等。The input interface 300 is connected to the processor 200 and is used to obtain externally imported computer programs, parameters, and instructions, and store them in the memory 100 under the control of the processor 200. The input interface 300 can be connected to an input device to receive parameters or instructions manually input by the user. The input device can be a touch layer covered on the display screen, a button, a trackball or a touchpad provided on the terminal shell, or a keyboard, a touchpad, or a mouse.
显示单元400,与处理器200相连,用于显示处理器200处理的数据以及用于显示可视化的用户界面。该显示单元400可以为LED显示器、液晶显示器、触控式液晶显示器以及OLED(Organic Light-Emitting Diode,有机发光二极管)触摸器等。The display unit 400 is connected to the processor 200 and is used for displaying data processed by the processor 200 and for displaying a visualized user interface. The display unit 400 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode, organic light-emitting diode) touch device, etc.
网络端口500,与处理器200相连,用于与外部各终端设备进行通信连接。该通信连接所采用的通信技术可以为有线通信技术或无线通信技术,如移动高清链接技术(MHL)、通用串行总线(USB)、高清多媒体接口(HDMI)、无线保真技术(WiFi)、蓝牙通信技术、低功耗蓝牙通信技术、基于IEEE802.11s的通信技术等。The network port 500 is connected to the processor 200 and is used to communicate with external terminal devices. The communication technology used in the communication connection can be wired communication technology or wireless communication technology, such as mobile high-definition link technology (MHL), universal serial bus (USB), high-definition multimedia interface (HDMI), wireless fidelity technology (WiFi), Bluetooth communication technology, low-power Bluetooth communication technology, communication technology based on IEEE802.11s, etc.
图6仅示出了具有组件100-500的电子设备,本领域技术人员可以理解的是,图6示出的结构并不构成对电子设备的限定,可以包括比图示更少或者更多的部件,或者组合某些部件,或者不同的部件布置。FIG. 6 only shows an electronic device with components 100-500. Those skilled in the art can understand that the structure shown in FIG. 6 does not constitute a limitation on the electronic device, and may include fewer or more components than shown in the figure. Components, or a combination of certain components, or different component arrangements.
本申请还提供了一种计算机可读存储介质,该存储介质可以包括:U盘、移动硬盘、只读存储器(Read-Only Memory,ROM)、随机存取存储器(Random Access Memory,RAM)、磁碟或者光盘等各种可以存储程序 代码的介质。该存储介质上存储有计算机程序,所述计算机程序被处理器执行时实现前述任一实施例公开的会计报表生成方法的步骤。This application also provides a computer-readable storage medium, which may include: U disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic Various media that can store program codes, such as discs or optical discs. A computer program is stored on the storage medium, and when the computer program is executed by a processor, the steps of the method for generating accounting statements disclosed in any of the foregoing embodiments are realized.
说明书中各个实施例采用递进的方式描述,每个实施例重点说明的都是与其他实施例的不同之处,各个实施例之间相同相似部分互相参见即可。对于实施例公开的系统而言,由于其与实施例公开的方法相对应,所以描述的比较简单,相关之处参见方法部分说明即可。应当指出,对于本技术领域的普通技术人员来说,在不脱离本申请原理的前提下,还可以对本申请进行若干改进和修饰,这些改进和修饰也落入本申请权利要求的保护范围内。The various embodiments in the specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same or similar parts between the various embodiments can be referred to each other. As for the system disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant information can be referred to the description of the method part. It should be pointed out that for those of ordinary skill in the art, without departing from the principles of this application, several improvements and modifications can be made to this application, and these improvements and modifications also fall within the protection scope of the claims of this application.
还需要说明的是,在本说明书中,诸如第一和第二等之类的关系术语仅仅用来将一个实体或者操作与另一个实体或操作区分开来,而不一定要求或者暗示这些实体或操作之间存在任何这种实际的关系或者顺序。而且,术语“包括”、“包含”或者其任何其他变体意在涵盖非排他性的包含,从而使得包括一系列要素的过程、方法、物品或者设备不仅包括那些要素,而且还包括没有明确列出的其他要素,或者是还包括为这种过程、方法、物品或者设备所固有的要素。在没有更多限制的情况下,由语句“包括一个……”限定的要素,并不排除在包括所述要素的过程、方法、物品或者设备中还存在另外的相同要素。It should also be noted that in this specification, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply these entities or operations. There is any such actual relationship or sequence between operations. Moreover, the terms "include", "include" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements not only includes those elements, but also includes those that are not explicitly listed Other elements of, or also include elements inherent to this process, method, article or equipment. If there are no more restrictions, the element defined by the sentence "including a..." does not exclude the existence of other identical elements in the process, method, article, or equipment that includes the element.

Claims (10)

  1. 一种会计报表生成方法,其特征在于,包括:A method for generating accounting statements, which is characterized in that it includes:
    确定用于在数据赋值过程中对数据进行检测和管控的事前控制策略;Determine the prior control strategy used to detect and control the data in the data assignment process;
    获取用户赋值的会计要素数据,利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据;Acquire the accounting element data assigned by the user, use the prior control strategy to manage and control the accounting element data in the assignment process, and generate fully controlled accounting information documents;
    将所述完全受控的会计信息化单据对应的单据指标信息映射到预先设制的会计账簿中;Mapping the document index information corresponding to the fully controlled accounting informationization document to the pre-designed accounting book;
    确定事后控制策略,并利用所述事后控制策略对映射到所述会计账簿中的所述会计信息化单据和累积的累计的账簿指标信息进行再次检测,根据检测结果校正系统数据错误,得到校正后的会计账簿信息;Determine the post-event control strategy, and use the post-event control strategy to re-check the accounting information documents and accumulated account book index information mapped to the accounting books, correct the system data errors according to the detection results, and get the post-correction Of accounting book information;
    接收和传递用户下达的报表生成命令,获取对应的会计报表模板,根据所述报表生成命令从校正后的会计账簿信息中调取相应的账簿指标信息映射到该会计报表模板中,并获取该会计报表模板任务栏信息之间的计算关系,计算生成目标会计报表。Receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, according to the report generation command, retrieve the corresponding account book index information from the corrected accounting book information and map it to the accounting report template, and obtain the accounting report template. The calculation relationship between the taskbar information of the report template is calculated to generate the target accounting report.
  2. 根据权利要求1所述的会计报表生成方法,其特征在于,所述事前控制策略为预先为会计总账科目设置的:属性设制表、票据栏目启用表、拓展及微调设制表、业务信息关联设制表、业务信息专控设制表、业务信息自控设制表、与资产负债表关联设制表、与利润表关联设制表、与现金流量表关联设制表。The method for generating accounting statements according to claim 1, wherein the prior control strategy is set in advance for accounting general ledger subjects: attribute setting tabulation, bill column activation tabulation, expansion and fine-tuning tabulation setting, business information association Set up tabulation, business information dedicated control set up tabulation, business information self-controlled set up tabulation, set up tabulation in association with balance sheet, set up tabulation in association with income statement, and set up tabulation in association with cash flow statement.
  3. 根据权利要求1所述的会计报表生成方法,其特征在于,为所述会计报表模板之现金流量表增设错误项、调节项和常态项,使其俱有常态化及时性智能性的检测报错报表功能;The method for generating accounting statements according to claim 1, characterized in that error items, adjustment items, and normal items are added to the cash flow statement of the accounting statement template, so that it has normalization, timeliness, and intelligent error detection reports. Function;
    其中,所述错误项为在所述现金流量表中增设的用于记录系统数据错误的项目,所述调节项为在所述现金流量表中增设的用于抵消错误项重复采集数据的项目,所述常态项为在所述现金流量表中增设的用于所述现金流量表在任意时间段及时性生成报表的项目。Wherein, the error item is an item added to the cash flow table for recording system data errors, and the adjustment item is an item added to the cash flow table for offsetting the repeated data collection of error items, The normal item is an item added to the cash flow statement for the cash flow statement to generate reports in a timely manner in any time period.
  4. 根据权利要求1所述的会计报表生成方法,其特征在于,所述利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据,包括:The method for generating an accounting statement according to claim 1, wherein the use of the prior control strategy to manage and control the accounting element data in the value assignment process to generate a fully controlled accounting informatization document includes:
    利用会计总账科目作为控制项控制其借贷方向二级及二级以下子目的对称或非对称无限拓展和微调;Use the accounting general ledger account as a control item to control the symmetrical or asymmetrical unlimited expansion and fine-tuning of the second and lower sub-purposes of its borrowing direction;
    利用各类会计总账科目设置的票据栏目启用表控制各类会计信息化单据上的各类栏目会计总账科目的赋值;Use the bill column activation table set by various accounting general ledger accounts to control the assignment of various general accounting accounts on various accounting information documents;
    利用会计信息化单据上任一栏目中赋值的具体会计总账科目控制所述任一栏目的二级及二级以下子目的赋值;Use the specific accounting general ledger account assigned in any column of the accounting information document to control the assignment of the second and lower sub-items of any column;
    利用会计信息化单据上流转栏赋值的一二三级科目控制数据链的流转,分为相同的一二三级科目实现数据链的流转和不同的一二三级科目阻断数据链的流转;Use the first, second and third level subjects assigned in the flow column of the accounting information documents to control the flow of the data link, which is divided into the same level 1, 2, and 3 subjects to realize the flow of the data link and different levels 1, 2, and 3 subjects to block the flow of the data link;
    利用业务信息的关联、专控、自控关系对会计信息化单据上赋值的业务信息进行事前控制和事后检测,生成所述完全受控的会计信息化单据。Pre-control and post-check the business information assigned on the accounting informatization documents by using the association, exclusive control, and self-control relationships of business information to generate the fully controlled accounting informatization documents.
  5. 根据权利要求1所述的会计报表生成方法,其特征在于,所述生成会计报表的调度指挥命令中包括目标会计报表及类型、报表起止时间的选择信息。The method for generating an accounting report according to claim 1, wherein the scheduling command for generating an accounting report includes the selection information of the target accounting report and the type, and the start and end time of the report.
  6. 根据权利要求1所述的会计报表生成方法,其特征在于,所述事后控制策略包括业务信息关联关系逻辑检测项、业务信息专控关系逻辑检测项、业务信息自控关系逻辑检测项、数据链信息化单据及金额检测项、数据链信息化单据及数量检测项、以及现金流量检测项;所述事后控制策略还用于对所述会计账簿和所述目标会计报表进行检测。The method for generating an accounting report according to claim 1, wherein the post-control strategy includes business information association relationship logic detection items, business information specific control relationship logic detection items, business information self-control relationship logic detection items, and data link information Documents and amount detection items, data link information documents and quantity detection items, and cash flow detection items; the ex post control strategy is also used to detect the accounting books and the target accounting statements.
  7. 根据权利要求6所述的会计报表生成方法,其特征在于,还包括:The method for generating accounting statements according to claim 6, characterized in that it further comprises:
    在利用所述事后控制策略对所述会计信息化单据、所述会计账簿和所述目标会计报表进行检测之后,得到检测结果;After using the ex-post control strategy to detect the accounting informationization document, the accounting book and the target accounting statement, the detection result is obtained;
    基于所述检测结果生成各类单据错误信息列表、归宗关系错误信息列表、账随关系错误信息列表、现金流量错误信息列表,为评估和校正系统数据错误提供支持。Based on the detection result, a list of various types of document error information, an error information list of a reconciliation relationship, an error information list of an account with a relationship, and a cash flow error information list are generated to provide support for evaluating and correcting system data errors.
  8. 根据权利要求1至7任一项所述的会计报表生成方法,其特征在于,所述会计报表的生成过程,包括:The method for generating accounting statements according to any one of claims 1 to 7, wherein the generating process of the accounting statements includes:
    接收针对所述会计报表中上标题栏的表项进行设计的选择指令,并建立每个表项选择指令与各类相关会计总账科目的指挥调度关系;Receive selection instructions designed for the items in the upper title bar of the accounting statement, and establish the command and dispatch relationship between each item selection instruction and various related accounting general ledger accounts;
    接收针对所述会计报表中任务栏项目的设置指令;所述设置指令用于将所述报表任务栏项目设置为采集项目或计算项目;所述采集项目用于实现账簿指标与报表指标的映射转换计算关系,所述计算项目用于实现对报表任务栏内的采集项目及其自身信息进行计算重组;Receive a setting instruction for the task bar item in the accounting report; the setting instruction is used to set the report task bar item as a collection item or a calculation item; the collection item is used to realize the mapping conversion between the account book index and the report index The calculation relationship, the calculation item is used to realize the calculation and reorganization of the collection item and its own information in the report task bar;
    获取会计报表模板中的版面设计内容,并基于所述版面设计内容确定所述会计报表的下标题栏;Acquire the layout design content in the accounting statement template, and determine the lower title bar of the accounting statement based on the layout design content;
    结合所述上标题栏、所述任务栏以及所述下标题栏生成所述会计报表。The accounting report is generated in combination with the upper title bar, the task bar, and the lower title bar.
  9. 一种会计报表生成装置,其特征在于,包括:An accounting statement generating device, which is characterized in that it comprises:
    事前控制模块,用于确定用于在数据赋值过程中对数据进行检测和管控的事前控制策略;The pre-control module is used to determine the pre-control strategy used to detect and control the data in the data assignment process;
    数据赋值模块,用于获取用户赋值的会计要素数据,利用所述事前控制策略对赋值过程中的所述会计要素数据进行管控,生成完全受控的会计信息化单据;The data assignment module is used to obtain the accounting element data assigned by the user, use the prior control strategy to control the accounting element data in the assignment process, and generate fully controlled accounting information documents;
    数据映射模块,用于将所述完全受控的会计信息化单据对应的单据指标信息映射到预先设制的会计账簿中,给各类会计报表任务栏采集项目与各类会计总账科目账簿指标建立映射转换计算关系;The data mapping module is used to map the document index information corresponding to the fully controlled accounting informationization document to the pre-designed accounting book, and establish the collection items of various accounting report task columns and various accounting general ledger account book indicators Mapping conversion calculation relationship;
    事后控制模块,用于确定事后控制策略,并利用所述事后控制策略对映射到所述会计账簿中的所述会计信息化单据和累积的累计的账簿指标信息进行再次检测,根据检测结果校正系统数据错误,得到校正后的会计账簿信息;The post-control module is used to determine the post-control strategy, and use the post-control strategy to re-check the accounting informationized documents and accumulated account book index information mapped to the accounting book, and correct the system according to the detection result The data is wrong, and the corrected accounting book information is obtained;
    报表生成模块,用于接收和传递用户下达的报表生成命令,获取对应的会计报表模板,根据所述报表生成命令从校正后的会计账簿信息中调取相应的账簿指标信息映射到该会计报表模板中,并获取该会计报表模板任务栏信息之间的计算关系,计算生成目标会计报表。The report generation module is used to receive and transmit the report generation command issued by the user, obtain the corresponding accounting report template, and retrieve the corresponding account book index information from the corrected accounting book information according to the report generation command and map it to the accounting report template , And obtain the calculation relationship between the task bar information of the accounting statement template, and calculate and generate the target accounting statement.
  10. 一种电子设备,其特征在于,包括:An electronic device, characterized in that it comprises:
    存储器,用于存储计算机程序;Memory, used to store computer programs;
    处理器,用于执行所述计算机程序时实现如权利要求1至8任一项所述会计报表生成方法的步骤。The processor is configured to implement the steps of the method for generating accounting statements according to any one of claims 1 to 8 when the computer program is executed.
PCT/CN2020/132103 2020-05-14 2020-11-27 Accounting report generation method and apparatus, and electronic device WO2021227444A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202010406902.0A CN111598674B (en) 2020-05-14 2020-05-14 Accounting report generation method and device and electronic equipment
CN202010406902.0 2020-05-14

Publications (1)

Publication Number Publication Date
WO2021227444A1 true WO2021227444A1 (en) 2021-11-18

Family

ID=72183716

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2020/132103 WO2021227444A1 (en) 2020-05-14 2020-11-27 Accounting report generation method and apparatus, and electronic device

Country Status (2)

Country Link
CN (1) CN111598674B (en)
WO (1) WO2021227444A1 (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111598674B (en) * 2020-05-14 2023-05-09 长沙华山信息技术有限公司 Accounting report generation method and device and electronic equipment
CN115423595B (en) * 2022-11-02 2023-03-28 深圳高灯计算机科技有限公司 File information processing method and device, computer equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030229589A1 (en) * 2002-06-07 2003-12-11 First Data Corporation Systems and methods for presenting payoff information to credit card customers
CN103714480A (en) * 2013-12-30 2014-04-09 山东中创软件工程股份有限公司 Self-defined financial statement generation system
CN109710237A (en) * 2019-01-10 2019-05-03 厦门商集网络科技有限责任公司 A kind of online modification method of calibration and equipment based on customized two-dimentional report
CN111598674A (en) * 2020-05-14 2020-08-28 长沙华山信息技术有限公司 Accounting report generation method and device and electronic equipment

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101882266A (en) * 2010-06-22 2010-11-10 方志忠 Account making system for medium-sized and small enterprises
US9697271B2 (en) * 2013-03-06 2017-07-04 Tata Consultancy Services Limited Business intelligence reports with navigable reference indicators
CN103970851B (en) * 2014-05-05 2017-07-04 神华集团有限责任公司 The method that magnanimity Credential data directly provides general headquarters of large-size enterprise group financial statement
CN105589755A (en) * 2014-11-18 2016-05-18 远光软件股份有限公司 Verifying method and system when generating certificate
CN107885709A (en) * 2017-09-29 2018-04-06 深圳市共济科技股份有限公司 A kind of report form generation method, system and storage medium
CN109658115A (en) * 2018-12-24 2019-04-19 安徽经邦软件技术有限公司 Financial statement antifraud method
CN110457666B (en) * 2019-08-19 2023-09-01 亿企赢网络科技有限公司 Report generation method, system, electronic equipment and storage medium

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030229589A1 (en) * 2002-06-07 2003-12-11 First Data Corporation Systems and methods for presenting payoff information to credit card customers
CN103714480A (en) * 2013-12-30 2014-04-09 山东中创软件工程股份有限公司 Self-defined financial statement generation system
CN109710237A (en) * 2019-01-10 2019-05-03 厦门商集网络科技有限责任公司 A kind of online modification method of calibration and equipment based on customized two-dimentional report
CN111598674A (en) * 2020-05-14 2020-08-28 长沙华山信息技术有限公司 Accounting report generation method and device and electronic equipment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
LI SHUAI: "Research on the Industrial Accounting Statements System Based on the B/S Framework and Data Warehouse Construction", CHINA MASTER’S THESES FULL-TEXT DATABASE, ECONOMICS AND MANAGEMENT SCIENCE, no. 6, 15 June 2008 (2008-06-15), XP055866020 *

Also Published As

Publication number Publication date
CN111598674A (en) 2020-08-28
CN111598674B (en) 2023-05-09

Similar Documents

Publication Publication Date Title
Debreceny et al. Data mining journal entries for fraud detection: An exploratory study
CN103426070B (en) Compilation method and device of group combined financial statement
CN103440557A (en) Generation method and system for group consolidated accounts and consolidated statements
WO2021227444A1 (en) Accounting report generation method and apparatus, and electronic device
CN107767005A (en) Profit flow table injustice checking method and system based on bookkeeping voucher
CN105431878A (en) System and method for automatically providing a/r-based lines of credit to businesses
CN110458674A (en) A kind of method and system generating bookkeeping voucher
US20180255160A1 (en) Computerized accounting information system and a method of processing accounting data
CN101201908A (en) Enterprise intelligent accounting architecture and intelligent accounting algorithm
JP2012146158A (en) Accounting processing system
JP6049799B2 (en) Management support program
CN106327321A (en) Method for automatically generating financial data
US20170236119A1 (en) System and method for implementing multi-rate currency aspects of multi-book accounting
JP2018077813A (en) Accounting data processing system and program
Hashim et al. A Diagnostic Framework to Assess the Capacity of a Government's Financial Management Information System as a Budget Management Tool
Guo Data source analysis of computerized management accounting based on data warehouse and mobile edge computing
US20060218060A1 (en) Accounting method and system
CN202433952U (en) General network reporting system
CN110457308A (en) A kind of accounting data processing analysis method and system
CN108876584A (en) A kind of personnel's revenue control and Individual Income Tax accounting system, method and electronic equipment
CN101122991A (en) The fourth generation finance core business system systematic structure and intelligent financial accounting method
CN115630113A (en) Account flow checking method and device
CN106528625B (en) Rolling budget system and method based on Oracle Hyperion
US7409365B1 (en) Risk provision implementation financial processing in a relational database management system
Satyendra et al. Evaluation of Banking Standards to ascertain their suitability for building Data Models for Big data based Data Lake for Banking Domain

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 20935539

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 20935539

Country of ref document: EP

Kind code of ref document: A1