A method, system and related devices for aggregating accounting journal data

Abstract

The application discloses a method, system and related equipment for summarizing accounting entry data, the method comprising: when a task is triggered, determining the application source, entity and event classification of the accounting entry data to be summarized; based on the application source, entity and event classification, obtaining a first reference field, a second reference field and a third reference field from a preset summary rule configuration file; based on the first reference field, the second reference field and the third reference field, merging each header data and each line data in the accounting entry data to obtain target summary data, and the index of the target summary data comprises batch index, header index and line index. The application can summarize the accounting entry data based on the summary rule configuration file defined by the user, reduce the total amount of data, and improve the readability of the data through multi-level indexing.

Description

Technical Field

[0001] This application relates to the field of financial data processing technology, and more specifically, to a method, system, and related equipment for summarizing accounting entry data. Background Technology

[0002] Accounting entries can contain tens of thousands or even millions of header and line data. Uploading this data directly to the general ledger module of the financial system would put a huge storage burden on the general ledger module. In addition, there is also the problem of low readability.

[0003] Therefore, how to summarize and upload accounting entry data has become an urgent problem to be solved. Summary of the Invention

[0004] In view of this, this application provides a method, system and related equipment for summarizing accounting entries to solve at least one of the technical problems mentioned above.

[0005] To achieve the above objectives, the first aspect of this application provides a method for summarizing accounting entry data, comprising:

[0006] When a task is triggered, based on the accounting entries to be summarized, the application source, entity, and event category of the accounting entries are determined. The application source is used to indicate the application source of the accounting entries, the entity is used to indicate the nature of the accounting entries, and the event category is used to indicate the classification of the accounting entries.

[0007] Based on the application source, the entity, and the event classification, a first reference field, a second reference field, and a third reference field are obtained from a preset summary rule configuration file. The first reference field is used to represent the reference field for batch summarizing the header data, the second reference field is used to represent the reference field for summarizing the header data, and the third reference field is used to represent the reference field for summarizing the row data.

[0008] Based on the first reference field, the second reference field, and the third reference field, the header data and row data in the accounting entries are merged to obtain the target summary data. The index of the target summary data includes a batch index, a header index, and a row index.

[0009] Preferably, the process of merging the header data and row data in the accounting entry data based on the first reference field, the second reference field, and the third reference field to obtain the target summary data includes:

[0010] Select the first target header data from each header data whose first reference field value is equal, determine each first target header data as the same batch header data, and determine the value of the first reference field of the first target header data as the batch index of the batch header data;

[0011] Select the second target header data from each header data whose second reference field values ​​are equal, and determine the header index of the second target header data based on the values ​​of each second reference field of the second target header data;

[0012] Obtain the first target row data corresponding to the second target header data, and filter out the second target row data with the same value of the third reference field from each of the first target row data. Based on the value of each of the third reference fields of the second target row data, determine the row index of the second target row data.

[0013] The values ​​of each target field in the second target row data are summed to obtain the target value of the target field. The index of the target value includes the batch index of the batch in which the second target header data is located, the header index of the second target header data, and the row index of the second target row data.

[0014] Preferably, the process of determining the header index of the second target header data based on the values ​​of each second reference field of the second target header data includes:

[0015] The values ​​of each second reference field in the second target header data are concatenated to obtain the header index of the second target header data.

[0016] Preferably, the process of determining the row index of the second target row data based on the values ​​of each of the third reference fields of the second target row data includes:

[0017] The values ​​of the third reference fields of the second target row data are concatenated to obtain the row index of the second target row data.

[0018] Preferably, the process of triggering the task includes:

[0019] The task is triggered by a preset timer;

[0020] And / or,

[0021] Tasks are triggered by the user.

[0022] The second aspect of this application provides a system for summarizing accounting entry data, including a configuration management module, a summary processing module, and a data upload module;

[0023] The configuration management module is used to generate a summary rule configuration file based on the information input by the user.

[0024] The summary processing module is used to implement the various steps of the method for summarizing accounting entries as described above, so as to obtain the target summary data.

[0025] The data upload module is used to upload the target summary data output by the summary processing module to the general ledger management system.

[0026] Preferably, the configuration management module includes a summary rule configuration component and a scheduled task configuration component;

[0027] The aggregation rule configuration component is used to configure aggregation rules for header data and row data;

[0028] The scheduled task configuration component is used to configure the timer that triggers the summary task.

[0029] A third aspect of this application provides an apparatus for summarizing accounting entry data, comprising:

[0030] The data feature determination unit is used to determine the application source, entity, and event classification of the accounting entry data to be summarized based on the accounting entry data when the task is triggered. The application source is used to indicate the application source of the accounting entry data, the entity is used to indicate the nature of the accounting entry data, and the event classification is used to indicate the classification of the accounting entry data.

[0031] The reference field determination unit is used to obtain a first reference field, a second reference field, and a third reference field from a preset summary rule configuration file based on the application source, the entity, and the event classification. The first reference field is used to represent the reference field for batch summarizing the header data, the second reference field is used to represent the reference field for summarizing the header data, and the third reference field is used to represent the reference field for summarizing the row data.

[0032] The journal entry data aggregation unit is used to merge the header data and row data in the accounting journal entry data based on the first reference field, the second reference field and the third reference field to obtain target aggregated data. The index of the target aggregated data includes a batch index, a header index and a row index.

[0033] A fourth aspect of this application provides an apparatus for summarizing accounting entry data, comprising: a memory and a processor;

[0034] The memory is used to store programs;

[0035] The processor is used to execute the program to implement the various steps of the above-described method for summarizing accounting entry data.

[0036] The fifth aspect of this application provides a storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the method for summarizing accounting entries as described above.

[0037] As can be seen from the above technical solution, when a task to summarize accounting entry data is triggered, the application source, entity, and event category of the accounting entry data are determined based on the accounting entry data to be summarized. The application source indicates the application origin of the accounting entry data, the entity indicates the nature of the accounting entry data, and the event category indicates the classification of the accounting entry data. Then, based on the application source, the entity, and the event category, a first reference field, a second reference field, and a third reference field are obtained from a preset summary rule configuration file. The first reference field represents a reference field for batch summarizing header data; multiple header data can be aggregated into a batch based on the value of the first reference field in the accounting entry data header data. The second reference field represents a reference field for summarizing header data; multiple header data can be aggregated into one type of header data based on the value of the second reference field in the accounting entry data header data. The third reference field represents a reference field for summarizing row data; multiple row data under the same header data can be aggregated into one type of row data based on the value of the third reference field in the accounting entry data row data. Finally, based on the first reference field, the second reference field, and the third reference field, the header data and row data in the accounting entry data are merged to obtain the target summary data. The index of the target summary data includes a batch index, a header index, and a row index. The batch index can be used to locate the corresponding batch data; the header index can be used to locate the corresponding header data; and the header index and the row index can be combined to locate the corresponding row data. This application can summarize accounting entry data based on a user-defined summary rule configuration file, reducing the total amount of data while improving data readability through multi-level indexing. Attached Figure Description

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

[0039] Figure 1 This is a schematic diagram of a system for summarizing accounting entries disclosed in an embodiment of this application;

[0040] Figure 2This application illustrates a workflow diagram for summarizing accounting entry data as disclosed in an embodiment of the present application.

[0041] Figure 3 This is a schematic diagram of the method for summarizing accounting entry data disclosed in an embodiment of this application;

[0042] Figure 4 This is a schematic diagram of the apparatus for summarizing accounting entries disclosed in an embodiment of this application;

[0043] Figure 5 This is a schematic diagram of a device for summarizing accounting entries as disclosed in an embodiment of this application. Detailed Implementation

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

[0045] The following describes a system for summarizing accounting entry data provided in an embodiment of this application. Please refer to... Figure 1 The system for summarizing accounting entries provided in this application embodiment may include a configuration management module 10, a summary processing module 20, and a data upload module 50.

[0046] The configuration management module 10 is used to generate a summary rule configuration file based on user input. This summary rule configuration file describes the rules for summarizing accounting entry data and the rules for data uploading.

[0047] The summary processing module 20 is the core processing module of this system. It is used to summarize accounting entry data based on the summary rule configuration file output by the configuration management module 10 to obtain target summary data. It can be understood that this target summary data summarizes accounting entry data from multiple dimensions, which greatly reduces the total amount of data.

[0048] The data upload module 50 is used to upload the target summary data output by the summary processing module 20 to the general ledger management system.

[0049] In some embodiments of this application, the configuration management module 10 may include a summary rule configuration component and a scheduled task configuration component. The summary rule configuration component is used to configure the summary rules for header data and row data; the scheduled task configuration component is used to configure the timer that triggers the summary task.

[0050] For example, please refer to Figure 2 The data source includes accounting entries to be summarized, which consists of multiple entry headers, each containing multiple entry lines. The header data (composed of entry headers) and the line data (composed of entry lines) are extracted and merged using the client's SDK across three dimensions: batch, header, and line. The final summarized data is then transmitted to the EBS general ledger. Before extracting the batch, header, and line data, a summary configuration is obtained based on application source, entity, and event classification. This configuration includes summary rules for batch, header, and line data.

[0051] The summary processing module 20 of this system is the core functional part for summarizing accounting entry data. It is mainly used to execute the method for summarizing accounting entry data proposed in the embodiments of this application. The method is described in detail below. Please refer to... Figure 3 The method for summarizing accounting entry data provided in this application embodiment may include the following steps:

[0052] Step S101: When the task is triggered, determine the application source, entity, and event classification of the accounting entry data based on the accounting entry data to be summarized.

[0053] Among them, the application source is used to indicate the application source of the accounting entry data, which may include inventory management system, accounts payable management system, accounts receivable management system, etc.; the entity is used to indicate the nature of the accounting entry data, which may include prepayment and borrowing, loan, payment, refund, etc.; the event classification is used to indicate the classification of the accounting entry data, which may include liabilities, expenses and taxes, etc.

[0054] Step S102: Based on the application source, entity, and event classification, obtain the first reference field, the second reference field, and the third reference field from the preset summary rule configuration file.

[0055] The first reference field is used to indicate the reference field for batch aggregation of header data. For example, if the first reference field of accounting entry data is header-accounting date, then in the aggregation, all header data with the same accounting date in the accounting entry data will be clustered into one batch, i.e., clustered into one batch of accounting entry data. The second reference field is used to indicate the reference field for aggregation of header data. For example, if the second reference field of accounting entry data includes header-accounting date, header-accounting period, and header-accounting currency, then in the aggregation, header data with the same accounting date, the same accounting period, and the same accounting currency will be clustered into one type of header data. The third reference field is used to indicate the reference field for aggregation of row data. For example, if the third reference field of accounting entry data is row-account ID and row-debit / credit direction, then row data with the same account ID and debit / credit direction under the same type of header data will be clustered into one type of row data.

[0056] Step S103: Based on the first reference field, the second reference field, and the third reference field, merge the header data and row data in the accounting entry data to obtain the target summary data.

[0057] The index for the target summary data can consist of a batch index, a header index, and a row index.

[0058] When a task to summarize accounting entry data is triggered, the application source, entity, and event category of the accounting entry data are determined based on the accounting entry data to be summarized. The application source indicates the source of the accounting entry data, the entity indicates the nature of the accounting entry data, and the event category indicates the classification of the accounting entry data. Then, based on the application source, the entity, and the event category, a first reference field, a second reference field, and a third reference field are obtained from a preset summary rule configuration file. The first reference field represents a reference field for batch summarizing header data; multiple header data can be aggregated into a batch based on the value of the first reference field in the accounting entry data header data. The second reference field represents a reference field for summarizing header data; multiple header data can be aggregated into a single header data based on the value of the second reference field in the accounting entry data header data. The third reference field represents a reference field for summarizing row data; multiple rows of data under the same header data can be aggregated into a single row data based on the value of the third reference field in the accounting entry data row data. Finally, based on the first reference field, the second reference field, and the third reference field, the header data and row data in the accounting entry data are merged to obtain the target summary data. The index of the target summary data includes a batch index, a header index, and a row index. The batch index can be used to locate the corresponding batch data; the header index can be used to locate the corresponding header data; and the header index and the row index can be combined to locate the corresponding row data. This application can summarize accounting entry data based on a user-defined summary rule configuration file, reducing the total amount of data while improving data readability through multi-level indexing.

[0059] In some embodiments of this application, step S103, which merges the header data and row data of accounting entries based on the first reference field, the second reference field, and the third reference field to obtain the target summary data, may include:

[0060] S1, select the first target header data with the same value in the first reference field from each header data, determine each first target header data as the same batch of header data, and determine the value of the first reference field of the first target header data as the batch index of this batch of header data.

[0061] S2, select the second target header data from each header data whose second reference field values ​​are equal, and determine the header index of the second target header data based on the values ​​of each second reference field of the second target header data.

[0062] S3, obtain the first target row data corresponding to the second target header data, and filter out the second target row data with the same value of the third reference field from each of the first target row data, and determine the row index of the second target row data based on the value of each of the third reference fields of the second target row data.

[0063] S4, sum the values ​​of each target field in the second target row of data to obtain the target value of the target field.

[0064] The index of the target value includes the batch index of the batch containing the second target header data, the header index of the second target header data, and the row index of the second target row data.

[0065] For example, suppose the first reference field is header-accounting date, the second reference field includes header-accounting period, header-journal category, and header-accounting currency, and the third reference field is row-account ID and row-debit / credit direction. Then, in the summary, all first target header data with the same accounting date in the accounting entry data will be identified as the same batch of header data; second target header data with the same accounting period, the same journal category, and the same accounting currency in the accounting entry data will be identified as one type of header data; and second target row data with the same account ID and debit / credit direction under the same type of header data will be clustered into one type of row data.

[0066] Furthermore, assuming that the target fields of the second target row data include input debit, input credit, accounting debit, and accounting credit, then the target value of the input debit is obtained by summing the values ​​of the input credit in each second target row data; the target value of the input credit is obtained by summing the values ​​of the accounting debit in each second target row data; and the target value of the accounting credit is obtained by summing the values ​​of the accounting credit in each second target row data.

[0067] In some embodiments of this application, the process of determining the header index of the second target header data based on the values ​​of each second reference field of the second target header data in S2 may include:

[0068] The values ​​of each second reference field in the second target header data are concatenated to obtain the header index of the second target header data.

[0069] For example, suppose the second reference field includes header-accounting period, header-journal category, and header-accounting currency, and for a certain type of header data, its header-accounting period, header-journal category, and header-accounting currency are 2022-09, FOS_SLA, and USD, respectively. Then, concatenating the values ​​of these fields will yield the string "2022-09,FOS_SLA,USD", which is the header index of the second target header data.

[0070] In some embodiments of this application, the process of determining the row index of the second target row data based on the values ​​of each third reference field of the second target row data in step S3 may include:

[0071] The values ​​of the third reference fields of the second target row data are concatenated to obtain the row index of the second target row data.

[0072] For example, suppose the third reference field is row-account ID and row-borrowing direction, and for a certain type of row data, its account ID and borrowing direction are 300666 and DR respectively. Then, after concatenating the values ​​of these fields, we get the string "300666,DR", which is the row index of the second target row data.

[0073] In some embodiments of this application, the process of triggering the task in step S101 may include:

[0074] S1 triggers the task through a preset timer.

[0075] S2, tasks are triggered by the user.

[0076] By scheduling a summary task, accounting entries can be uploaded to the general ledger periodically. Users can also manually trigger the summary task when needed.

[0077] The apparatus for summarizing accounting entries provided in the embodiments of this application will be described below. The apparatus for summarizing accounting entries described below can be referred to in correspondence with the method for summarizing accounting entries described above.

[0078] Please see Figure 4 The apparatus for summarizing accounting entry data provided in this application embodiment may include:

[0079] The data feature determination unit 21 is used to determine the application source, entity, and event classification of the accounting entry data to be summarized based on the accounting entry data when the task is triggered. The application source is used to indicate the application source of the accounting entry data, the entity is used to indicate the nature of the accounting entry data, and the event classification is used to indicate the classification of the accounting entry data.

[0080] The reference field determination unit 22 is used to obtain a first reference field, a second reference field, and a third reference field from a preset summary rule configuration file based on the application source, the entity, and the event classification. The first reference field is used to represent the reference field for batch summarizing the header data, the second reference field is used to represent the reference field for summarizing the header data, and the third reference field is used to represent the reference field for summarizing the row data.

[0081] The journal entry data aggregation unit 23 is used to merge the header data and row data in the accounting journal entry data based on the first reference field, the second reference field and the third reference field to obtain target aggregated data. The index of the target aggregated data includes a batch index, a header index and a row index.

[0082] In some embodiments of this application, the process by which the journal entry data summarization unit 23 merges the header data and line data of the accounting entries based on the first reference field, the second reference field, and the third reference field to obtain the target summary data may include:

[0083] Select the first target header data from each header data whose first reference field value is equal, determine each first target header data as the same batch header data, and determine the value of the first reference field of the first target header data as the batch index of the batch header data;

[0084] Select the second target header data from each header data whose second reference field values ​​are equal, and determine the header index of the second target header data based on the values ​​of each second reference field of the second target header data;

[0085] Obtain the first target row data corresponding to the second target header data, and filter out the second target row data with the same value of the third reference field from each of the first target row data. Based on the value of each of the third reference fields of the second target row data, determine the row index of the second target row data.

[0086] The values ​​of each target field in the second target row data are summed to obtain the target value of the target field. The index of the target value includes the batch index of the batch in which the second target header data is located, the header index of the second target header data, and the row index of the second target row data.

[0087] In some embodiments of this application, the process by which the entry data aggregation unit 23 determines the header index of the second target header data based on the values ​​of each second reference field of the second target header data may include:

[0088] The values ​​of each second reference field in the second target header data are concatenated to obtain the header index of the second target header data.

[0089] In some embodiments of this application, the process by which the journal entry data aggregation unit 23 determines the row index of the second target row data based on the values ​​of each third reference field of the second target row data includes:

[0090] The values ​​of the third reference fields of the second target row data are concatenated to obtain the row index of the second target row data.

[0091] In some embodiments of this application, the process of triggering a task in the data feature determination unit 21 may include:

[0092] The task is triggered by a preset timer;

[0093] And / or,

[0094] Tasks are triggered by the user.

[0095] The apparatus for summarizing accounting entry data provided in this application embodiment can be applied to devices that summarize accounting entry data, such as computers. Optionally, Figure 5 This diagram shows the hardware structure of the device used to summarize accounting entries. Figure 5 The hardware structure of the device for summarizing accounting entries may include: at least one processor 31, at least one communication interface 32, at least one memory 33 and at least one communication bus 34.

[0096] In this embodiment, the number of processor 31, communication interface 32, memory 33 and communication bus 34 is at least one, and processor 31, communication interface 32 and memory 33 communicate with each other through communication bus 34;

[0097] The processor 31 may be a central processing unit (CPU), an application-specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of this application.

[0098] The memory 33 may include high-speed RAM, and may also include non-volatile memory, such as at least one disk storage device;

[0099] The memory 33 stores a program, and the processor 31 can call the program stored in the memory 33. The program is used for:

[0100] When a task is triggered, based on the accounting entries to be summarized, the application source, entity, and event category of the accounting entries are determined. The application source is used to indicate the application source of the accounting entries, the entity is used to indicate the nature of the accounting entries, and the event category is used to indicate the classification of the accounting entries.

[0101] Based on the application source, the entity, and the event classification, a first reference field, a second reference field, and a third reference field are obtained from a preset summary rule configuration file. The first reference field is used to represent the reference field for batch summarizing the header data, the second reference field is used to represent the reference field for summarizing the header data, and the third reference field is used to represent the reference field for summarizing the row data.

[0102] Based on the first reference field, the second reference field, and the third reference field, the header data and row data in the accounting entries are merged to obtain the target summary data. The index of the target summary data includes a batch index, a header index, and a row index.

[0103] Optionally, the refined and extended functions of the program can be found in the description above.

[0104] This application embodiment also provides a storage medium that can store a program suitable for execution by a processor, the program being used for:

[0105] When a task is triggered, based on the accounting entries to be summarized, the application source, entity, and event category of the accounting entries are determined. The application source is used to indicate the application source of the accounting entries, the entity is used to indicate the nature of the accounting entries, and the event category is used to indicate the classification of the accounting entries.

[0106] Based on the application source, the entity, and the event classification, a first reference field, a second reference field, and a third reference field are obtained from a preset summary rule configuration file. The first reference field is used to represent the reference field for batch summarizing the header data, the second reference field is used to represent the reference field for summarizing the header data, and the third reference field is used to represent the reference field for summarizing the row data.

[0107] Based on the first reference field, the second reference field, and the third reference field, the header data and row data in the accounting entries are merged to obtain the target summary data. The index of the target summary data includes a batch index, a header index, and a row index.

[0108] Optionally, the refined and extended functions of the program can be found in the description above.

[0109] In summary:

[0110] When a task to summarize accounting entry data is triggered, this application determines the application source, entity, and event category of the accounting entry data based on the accounting entry data to be summarized. The application source indicates the source of the accounting entry data, the entity indicates the nature of the accounting entry data, and the event category indicates the classification of the accounting entry data. Then, based on the application source, the entity, and the event category, a first reference field, a second reference field, and a third reference field are obtained from a preset summary rule configuration file. The first reference field represents a reference field for batch summarizing header data; multiple header data can be aggregated into a batch based on the value of the first reference field in the accounting entry data header data. The second reference field represents a reference field for summarizing header data; multiple header data can be aggregated into a single header data based on the value of the second reference field in the accounting entry data header data. The third reference field represents a reference field for summarizing row data; multiple row data under the same header data can be aggregated into a single row data based on the value of the third reference field in the accounting entry data row data. Finally, based on the first reference field, the second reference field, and the third reference field, the header data and row data in the accounting entry data are merged to obtain the target summary data. The index of the target summary data includes a batch index, a header index, and a row index. The batch index can be used to locate the corresponding batch data; the header index can be used to locate the corresponding header data; and the header index and the row index can be combined to locate the corresponding row data. This application can summarize accounting entry data based on a user-defined summary rule configuration file, reducing the total amount of data while improving data readability through multi-level indexing.

[0111] Finally, it should be noted that in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

[0112] The various embodiments in this specification are described in a progressive manner. Each embodiment focuses on the differences from other embodiments. The various embodiments can be combined as needed, and the same or similar parts can be referred to each other.

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

Claims

1. A method for summarizing accounting entry data, characterized in that, include: When a task is triggered, based on the accounting entries to be summarized, the application source, entity, and event category of the accounting entries are determined. The application source is used to indicate the application source of the accounting entries, the entity is used to indicate the nature of the accounting entries, and the event category is used to indicate the classification of the accounting entries. Based on the application source, the entity, and the event classification, a first reference field, a second reference field, and a third reference field are obtained from a preset summary rule configuration file. The first reference field is used to represent the reference field for batch summarizing header data, the second reference field is used to represent the reference field for summarizing header data, and the third reference field is used to represent the reference field for summarizing row data. Based on the first reference field, the second reference field, and the third reference field, the header data and row data in the accounting entry data are merged to obtain the target summary data. The index of the target summary data includes a batch index, a header index, and a row index. The process of merging the header data and line data of accounting entries based on the first reference field, the second reference field, and the third reference field to obtain the target summary data includes: Select the first target header data from each header data whose first reference field value is equal, determine each first target header data as the same batch header data, and determine the value of the first reference field of the first target header data as the batch index of the batch header data; Select the second target header data from each header data whose second reference field values ​​are equal, and determine the header index of the second target header data based on the values ​​of each second reference field of the second target header data; Obtain the first target row data corresponding to the second target header data, and filter out the second target row data with the same value of the third reference field from each of the first target row data. Based on the value of each of the third reference fields of the second target row data, determine the row index of the second target row data. The values ​​of each target field in the second target row data are summed to obtain the target value of the target field. The index of the target value includes the batch index of the batch in which the second target header data is located, the header index of the second target header data, and the row index of the second target row data.

2. The method according to claim 1, characterized in that, The process of determining the header index of the second target header data based on the values ​​of each second reference field of the second target header data includes: The values ​​of each second reference field in the second target header data are concatenated to obtain the header index of the second target header data.

3. The method according to claim 1, characterized in that, The process of determining the row index of the second target row data based on the values ​​of each third reference field includes: The values ​​of the third reference fields of the second target row data are concatenated to obtain the row index of the second target row data.

4. The method according to claim 1, characterized in that, The process of triggering a task includes: The task is triggered by a preset timer; And / or, Tasks are triggered by the user.

5. A system for summarizing accounting entry data, characterized in that, It includes a configuration management module, a data aggregation and processing module, and a data upload module; The configuration management module is used to generate a summary rule configuration file based on the information input by the user. The summary processing module is used to implement each step of the method for summarizing accounting entry data as described in any one of claims 1 to 4, so as to obtain target summary data; The data upload module is used to upload the target summary data output by the summary processing module to the general ledger management system.

6. The system according to claim 5, characterized in that, The configuration management module includes a summary rule configuration component and a scheduled task configuration component; The aggregation rule configuration component is used to configure aggregation rules for header data and row data; The scheduled task configuration component is used to configure the timer that triggers the summary task.

7. An apparatus for summarizing accounting entry data, characterized in that, include: The data feature determination unit is used to determine the application source, entity, and event classification of the accounting entry data to be summarized based on the accounting entry data when the task is triggered. The application source is used to indicate the application source of the accounting entry data, the entity is used to indicate the nature of the accounting entry data, and the event classification is used to indicate the classification of the accounting entry data. The reference field determination unit is used to obtain a first reference field, a second reference field, and a third reference field from a preset summary rule configuration file based on the application source, the entity, and the event classification. The first reference field is used to represent the reference field for batch summarizing the header data, the second reference field is used to represent the reference field for summarizing the header data, and the third reference field is used to represent the reference field for summarizing the row data. The journal entry data aggregation unit is used to merge the header data and row data in the accounting journal entry data based on the first reference field, the second reference field and the third reference field to obtain target aggregated data. The index of the target aggregated data includes batch index, header index and row index. The process by which the journal entry data aggregation unit merges the header data and line data of the accounting entries based on the first reference field, the second reference field, and the third reference field to obtain the target aggregated data includes: Select the first target header data from each header data whose first reference field value is equal, determine each first target header data as the same batch header data, and determine the value of the first reference field of the first target header data as the batch index of the batch header data; Select the second target header data from each header data whose second reference field values ​​are equal, and determine the header index of the second target header data based on the values ​​of each second reference field of the second target header data; Obtain the first target row data corresponding to the second target header data, and filter out the second target row data with the same value of the third reference field from each of the first target row data. Based on the value of each of the third reference fields of the second target row data, determine the row index of the second target row data. The values ​​of each target field in the second target row data are summed to obtain the target value of the target field. The index of the target value includes the batch index of the batch in which the second target header data is located, the header index of the second target header data, and the row index of the second target row data.

8. A device for summarizing accounting entry data, characterized in that, include: Memory and processor; The memory is used to store programs; The processor is configured to execute the program to implement the steps of the method for summarizing accounting entry data as described in any one of claims 1 to 4.

9. A storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements each step of the method for summarizing accounting entry data as described in any one of claims 1 to 4.

Images