CN114663206A - Batch account-merging data processing method and device, computer equipment and storage medium - Google Patents

Abstract

The disclosure relates to a batch account-merging data processing method and device, computer equipment and a storage medium. The method comprises the following steps: acquiring accounting flow data and transaction flow data under each specific service scene within a preset time limit according to the transaction records; under the condition that each bookkeeping flow data and/or transaction flow data meets a trigger condition in a preset accounting trigger method, each accounting entry data under each specific service scene is determined according to the trigger condition; determining each accounting entry pipelining data according to each accounting entry data and preset accounting entry value conditions; and determining entry flow data under each specific service scene according to the accounting entry flow data, and determining general ledger result data to be merged according to the entry flow data under each specific service scene. By adopting the method, different batch processing programs do not need to be developed, and various service scenes can be flexibly configured.

Description

Batch account-merging data processing method and device, computer equipment and storage medium

Technical Field

The disclosure relates to the technical field of accounting, and in particular to a batch account-merging data processing method and device, computer equipment and a storage medium.

Background

After each financial institution performs various services (such as joint loan, property securitization, loan insurance and the like) every day, the financial institution can perform re-bookkeeping processing according to different service scenes and corresponding bookkeeping parameters and then can incorporate the services into the general ledger.

The existing account merging method of the financial institution at present is to develop corresponding batch processing programs aiming at different business scenes, carry out account merging processing on different business scenes through the batch processing programs and merge the account merging processing to a general ledger.

However, current reconciliation methods require development of different batch procedures and waste a significant amount of development and testing cycles. And when different accounting rules corresponding to different projects in the same service scene occur, the batch processing program can only use one accounting rule and cannot be flexibly configured. In addition, in different service scenarios, the independent deployment of the corresponding batch processing program and the core system data increases the corresponding hardware cost.

Disclosure of Invention

In view of the above, it is desirable to provide a batch reconciliation data processing method, apparatus, computer device, and storage medium, which can flexibly configure various business scenarios without developing different batch processing programs.

In a first aspect, the present disclosure provides a batch reconciliation data processing method. The method comprises the following steps:

acquiring accounting flow data and transaction flow data under each specific service scene within a preset time limit according to the transaction records;

under the condition that each accounting flow data and/or transaction flow data meets a trigger condition in a preset accounting trigger method, each accounting entry data under each specific service scene is determined according to the trigger condition, and the accounting trigger method is characterized in that: the mapping relation among the accounting method, the triggering condition and the accounting entry data; the trigger condition is determined according to an accounting variable, and the accounting variable is determined according to the accounting running data and the transaction running data;

determining each accounting entry running water data according to each accounting entry data and a preset accounting entry value condition, wherein the accounting entry value condition represents a mapping relation among the accounting entry data, subject code data and an entry value formula;

and determining entry flow data under each specific service scene according to the accounting entry flow data, and determining general ledger result data to be merged according to the entry flow data under each specific service scene.

In one embodiment, the obtaining accounting flow data in a specific service scene within a preset time limit and the transaction flow data within the preset time limit according to the transaction record includes:

acquiring accounting running water data and transaction running water data within a preset time limit according to a transaction record, wherein the accounting running water data at least comprises the following data: borrowing number data, borrowing direction data, amount data, subject code data, amount type data and transaction code data, wherein the transaction flow data at least comprises the following steps: transaction number, amount, transaction type;

acquiring accounting flow data and transaction flow data corresponding to a specific service scene in the accounting flow data and the transaction flow data within a preset time limit to obtain accounting flow data and transaction flow data under the specific service scene within the preset time limit, wherein the specific service scene at least comprises: property securitization business, loan insurance business, joint loan business and entrusted loan business.

In one embodiment, the method further comprises:

and carrying out duplication elimination processing on the borrow number and the transaction number.

In one embodiment, in the case that the accounting chronological data and/or the transaction chronological data satisfy the trigger condition in the pre-set accounting trigger method, determining the accounting entry data in each specific service scenario according to the trigger condition includes:

determining corresponding accounting variables according to computing conditions, wherein the computing conditions are determined according to subject code data, amount type data, transaction types in accounting flow data and/or transaction types in the transaction flow data;

determining the satisfied triggering condition under the condition that the accounting variable satisfies the triggering condition in a preset accounting triggering method;

and determining each accounting entry data according to the satisfied triggering condition.

In one embodiment, the determining, according to the accounting entry data and the preset accounting entry value condition, each accounting entry stream data includes:

determining the entry value formula in preset accounting entry value conditions according to the accounting entry data, wherein the accounting entry value conditions also represent the mapping relation among the accounting entry data, subject code data, loan direction data and the entry value formula;

and determining the accounting entry flow data according to the entry value formula.

In one embodiment, the determining entry flow data in each specific service scenario according to the accounting entry flow data and determining general ledger result data to be merged according to the entry flow data in the specific service scenario includes:

determining recorded flow data under each specific service scene according to the accounting recorded flow data;

and determining general ledger result data to be merged according to the entry flow data in each specific service scene, wherein the general ledger result data to be merged at least comprises borrow number data, borrow direction data, amount data, subject code data and amount type data.

In a second aspect, the present disclosure also provides a batch reconciliation data processing apparatus. The device comprises:

the data acquisition module is used for acquiring accounting flow data and transaction flow data in each specific service scene within a preset time limit according to the transaction records;

the entry data determining module is used for determining each accounting entry data under each specific service scene according to a trigger condition under the condition that each accounting flow data and/or transaction flow data meets the trigger condition in a preset accounting trigger method, and the accounting trigger method is characterized in that: checking a mapping relation among the method, the triggering condition and the accounting entry data; the trigger condition characterizes that: checking the mapping relation among variables, variable names and calculation conditions;

the flow data determination module is used for determining flow data of each accounting entry according to the data of each accounting entry and preset accounting entry value conditions, and the accounting entry value conditions represent the mapping relation among the accounting entries, subject code data and entry value formulas;

and the general ledger data determination module is used for determining the entry flow data under each specific service scene according to the accounting entry flow data and determining the general ledger result data to be merged according to the entry flow data under each specific service scene.

In a third aspect, the present disclosure also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the steps of the above method when executing the computer program.

In a fourth aspect, the present disclosure also provides a computer-readable storage medium. The computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method.

In a fifth aspect, the present disclosure also provides a computer program product. The computer program product comprises a computer program which, when being executed by a processor, carries out the steps of the above-mentioned method.

In the embodiments, the accounting entry data in each specific service scene is determined according to the accounting flow data and the triggering condition in the accounting triggering method, so that the accounting entry data in each specific service scene can be flexibly determined. Furthermore, the method can determine the recorded flow data of each accounting entry according to the preset accounting entry value conditions, determine the recorded flow data under each specific business scene according to the recorded flow data of each accounting entry, obtain the classified flow data under different business scenes by one set of program method, avoid developing different batch processing programs, reduce the development time and the test period, and can be flexibly configured. And finally, determining general ledger result data to be merged according to the entry and entry streamline data in each specific service scene, so that the general ledger is clear, checking and reading are facilitated, loans corresponding to various asset types can be flexibly processed, and the loans are merged into the general ledger after unified processing.

Drawings

In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present disclosure, and other drawings can be obtained by those skilled in the art without creative efforts.

FIG. 1 is a diagram of an application environment of a batch reconciliation data processing method in an embodiment;

FIG. 2 is a flow diagram illustrating a batch reconciliation data processing method in one embodiment;

FIG. 3 is a flowchart illustrating step S202 according to an embodiment;

FIG. 4 is a flowchart illustrating the step S204 according to an embodiment;

FIG. 5 is a flowchart illustrating the step S206 according to an embodiment;

FIG. 6 is a flowchart illustrating the step S208 according to an embodiment;

FIG. 7 is a block diagram showing a schematic configuration of a batch reconciliation data processing apparatus according to an embodiment;

FIG. 8 is a diagram showing an internal configuration of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present disclosure more clearly understood, the present disclosure is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the disclosure and are not intended to limit the disclosure.

It should be noted that the terms "first," "second," and the like in the description and claims herein and in the above-described drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments herein described are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, apparatus, article, or device that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or device.

In this document, the term "and/or" is only one kind of association relationship describing the associated object, meaning that three kinds of relationships may exist. For example, a and/or B, may represent: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" herein generally indicates that the former and latter related objects are in an "or" relationship.

The embodiment of the disclosure provides a batch parallel account data processing method, which can be applied to an application environment as shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104, or may be located on the cloud or other network server. The terminal 102 may obtain all transaction records in the server 104, and then may obtain accounting flow data and transaction flow data in each specific service scenario existing in the transaction records within a preset time limit according to the transaction records. The terminal 102 may then determine billing pipeline data and/or transaction pipeline data for each specific service scenario, whether one or both of them meet the trigger condition in the pre-configured accounting trigger method. If the condition is met, the terminal 102 may determine, according to the met trigger condition, respective accounting entry data in the accounting flow data and the transaction flow data under respective specific service scenarios corresponding to each other. The accounting triggering method is characterized in that: checking a mapping relation among the method, the triggering condition and the accounting entry data; the accounting method may be stored in the server 104 or in the terminal 102. The trigger condition is determined according to an accounting variable, which may be determined by the terminal 102 according to the accounting flow data and the transaction flow data. Or the server 104 may determine from the accounting flow data and the transaction flow data. And the terminal 102 determines the flow data of each accounting entry according to the data of each accounting entry and the preset accounting entry value conditions. The accounting entry value conditions represent the mapping relationship among the accounting entry data, the subject code data and the entry value formulas, and the accounting entry value conditions may be stored in the server 104 or the terminal 102. The terminal 102 determines the entry flow data in each specific service scene according to the accounting entry flow data, and determines the general ledger result data to be merged according to the entry flow data in each specific service scene. The terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and the like. The server 104 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.

In an embodiment, as shown in fig. 2, a batch reconciliation data processing method is provided, which is described by taking the example that the method is applied to the terminal 102 in fig. 1, and includes the following steps:

s202, accounting flow data and transaction flow data under each specific service scene within a preset period are obtained according to the transaction records.

The transaction record may be, among other things, a list of debits recorded by each business system. Such as property securitization service system, joint loan service system, loan insurance service system, it can record which borrows have occurred corresponding service. Such as an asset securitization trading system, records all the borrow lists (which may be referred to as borrow numbers) that have historically been transacted with asset securitization. Accounting flow data may generally be used to represent the flow of full loans for which a cash-out, payment, or deposit transaction has occurred. The transaction pipeline may generally represent the transaction type and corresponding amount for each business system. The service scene may generally refer to a scene used by the property securitization service system, the joint loan service system, the loan insurance service system, and the like, for example, the property securitization service system corresponds to the service scene, and the joint loan service system corresponds to the joint loan service scene.

Specifically, the financial institution may perform different services through different service systems every day, so that when performing reconciliation processing, it is necessary to obtain corresponding transaction records in each service system in different service systems, and accounting running water data and transaction running water data in each characteristic service scene within a preset time limit can be obtained according to the transaction records.

In some exemplary embodiments, the preset time limit may be one day, that is, the final processing of the current day obtains the current day of general ledger result data to be incorporated. The skilled person can set the preset time limit according to the actual requirement, such as three days, one week, one month, etc., and the time of the preset time limit is not limited in this embodiment. The specific service scenario may also be selectively set according to the selection of those skilled in the art. If the financial institution has only processed the asset securitization service within a preset time limit, that particular service scenario may be an asset securitization service scenario.

S204, under the condition that each accounting flow data and/or transaction flow data meets the triggering condition in the preset accounting triggering method, each accounting entry data in each specific business scene is determined according to the triggering condition, and the accounting triggering method is characterized in that: the mapping relation among the accounting method, the triggering condition and the accounting entry data; the trigger condition is determined according to an accounting variable, and the accounting variable is determined according to accounting running data and transaction running data.

The accounting trigger method may be in a data form representing a mapping relationship between an accounting method, a trigger condition, and accounting entry data, and may be a data table in a general case, and the accounting method may be used to represent a number code corresponding to accounting flow data or transaction flow data, and may be set by a person skilled in the art in a general case according to an actual service scenario, where each accounting flow data or transaction flow data corresponds to a specific accounting method, and each accounting method corresponds to a specific one or more accounting variables. Accounting variables may generally be specific variables that are calculated to be incorporated into the ledger result data. The trigger condition may generally be determined based on accounting variables in the billing pipeline data and/or the transaction pipeline data. The accounting entry data can be record data for listing the corresponding accounts of both parties and the amount thereof for each economic business according to the requirement of the double-type accounting principle. Before the account is registered, accounting entry data is compiled through the bookkeeping voucher, the classification condition of economic business can be clearly reflected, and the method is favorable for ensuring the accuracy of account records and facilitating post-examination. Each accounting entry data mainly comprises a billing symbol, related account name, abstract and amount, etc.

Specifically, a trigger condition is set, which may be generally determined before the accounting variable is calculated, and may be used to indicate when the accounting variable can satisfy the condition. The corresponding accounting method can be found through the accounting running water data and/or the transaction running water data, and then the accounting variables corresponding to the accounting method are calculated, wherein each accounting variable corresponds to one transaction meaning. Under the condition that the corresponding accounting variable meets the triggering condition in the accounting triggering set in advance, the triggering condition corresponds to the mapping relation between the accounting entry data, so that the accounting entry data under each corresponding specific business scene can be matched and obtained.

And S206, determining each accounting entry stream data according to each accounting entry data and preset accounting entry value conditions, wherein the accounting entry value conditions represent the mapping relation among the accounting entry data, subject code data and entry value formulas.

Specifically, after each accounting entry data is obtained, the corresponding accounting entry data can be matched in the preset accounting entry value conditions, and because the accounting entry value conditions represent the mapping relation among the accounting entry data, the subject code data and the entry value formula, the subject code data corresponding to the accounting entry data and the entry value formula can be obtained, accounting entry stream data is determined according to the entry value formula, and the accounting entry stream data also corresponds to the corresponding subject code data.

And S208, determining the recorded flow data in each specific service scene according to the accounting recorded flow data, and determining the general ledger result data to be merged according to the recorded flow data in each specific service scene.

Specifically, entry flow data in each specific business scenario can be determined according to each accounting entry data, and accounting entry flow data in each specific business scenario is synthesized to determine general ledger result data to be merged.

In the batch parallel account data processing method, each accounting entry data under each specific service scene is determined through each accounting running data and the triggering condition in the accounting triggering method, and the accounting entry data under each specific service scene can be flexibly determined. Furthermore, the method can determine the recorded flow data of each accounting entry according to the preset accounting entry value conditions, determine the recorded flow data under each specific business scene according to the recorded flow data of each accounting entry, obtain the classified flow data under different business scenes by one set of program method, avoid developing different batch processing programs, reduce the development time and the test period, and can be flexibly configured. And finally, determining general ledger result data to be merged according to the entry flow data in each specific service scene, so that the general ledger can be clear, checking and reading are convenient, borrows corresponding to various asset types can be flexibly processed, and the borrows are merged into the general ledger after being uniformly processed.

In an embodiment, as shown in fig. 3, the obtaining accounting flow data in a specific service scenario within a preset time limit and transaction flow data within the preset time limit according to the transaction record includes:

s302, accounting running water data and transaction running water data within a preset period are obtained according to transaction records, wherein the accounting running water data at least comprises the following data: borrowing number data, borrowing direction data, amount data, subject code data, amount type data, transaction code data and the like, wherein the transaction flow data at least comprises the following data: transaction number, amount, transaction type, etc.

S304, acquiring accounting flow data and transaction flow data corresponding to a specific service scene in the accounting flow data and the transaction flow data within a preset time limit to obtain accounting flow data and transaction flow data under the specific service scene within the preset time limit, wherein the specific service scene at least comprises: property securitization business, loan insurance business, joint loan business and entrusted loan business.

The borrow number data can be a number identification of data, and is used for representing the uniqueness of the data. The loan direction data can be represented by loan, and the loan are taken as accounting symbols to reflect an accounting method of increasing and decreasing changes of various accounting elements. D may generally represent a loan and C may generally represent a loan. The amount data may generally represent amount data for debits or credits. Subject code data is typically one that exists in an accounting entry. The amount type data may generally be associated with billing code data, with one amount type data corresponding to one code data, and different amount type data corresponding to the same code data. The transaction code data may generally represent a corresponding transaction, such as a payment transaction.

In some exemplary embodiments, the amount type data, as shown in table 1, may include:

TABLE 1 amount type data

Specifically, accounting running water data and transaction running water data within a preset time limit can be obtained according to the transaction records. After the obtaining, the transaction flow data and the accounting flow data corresponding to the specific service scene can be found and obtained from the accounting flow data and the transaction flow data within the preset time limit, and then the transaction flow data and the accounting flow data within the preset time limit and under the specific service scene can be obtained.

In this embodiment, various service scenarios can be flexibly handled by acquiring accounting streamline data and transaction streamline data in a specific service scenario, and the accounting streamline data includes data of types such as debit number data, debit direction data, amount data, subject code data, amount type data, and the like, so that the accounting variable can be conveniently calculated, and the calculation processing efficiency is improved.

In one embodiment, the method further comprises:

and carrying out duplication elimination processing on the borrow number and the transaction number.

Specifically, the borrow number and the transaction number may be deduplicated by a rowid method, a group by method, and a distint method in the database, and it should be noted that in this embodiment, only the foregoing three database deduplication manners are used as an example, and in an actual process, a person skilled in the art may also select another data deduplication manner according to an actual situation, so that deduplication of the numbered data may be implemented.

In the embodiment, the borrow number and the transaction number are subjected to duplicate removal processing to obtain the borrow number which has occurred in a specific service scene and is currently subjected to repayment transaction and the transaction number which is currently generated and is not yet booked, and then the corresponding accounting method can be determined according to the borrow number and the transaction number, so that the parallel accounting processing is facilitated.

In one embodiment, as shown in fig. 4, in the case that the accounting flow data and/or the transaction flow data satisfy the trigger condition in the pre-set accounting trigger method, determining the accounting entry data in each specific service scenario according to the trigger condition includes:

s402, determining corresponding accounting variables according to computing conditions, wherein the computing conditions are determined according to subject code data, amount type data, transaction code data in accounting flow data and/or transaction types in the transaction flow data.

Specifically, the calculation condition may be determined according to the subject code data, the amount type data, and the transaction code data, and may also be determined according to the transaction type.

In some exemplary embodiments, the accounting variable may be calculated by the calculation condition in the accounting variable configuration table of table 2.

TABLE 2 accounting variable configuration Table

The corresponding check variable can be calculated according to the calculation conditions in table 2, and the variable name can indicate the corresponding meaning of the check variable. It should be noted that, the calculation conditions in table 2 are only used as an example here, and in the practical application process, a person skilled in the art may add or modify the calculation conditions according to the practical situation, and the specific calculation conditions are not limited in this embodiment.

The package transfer may typically be: the loan institution A screens a batch of loans and packs the loans into an asset pool 1 on day T (package day). Organization B, through investigation, decides to purchase the asset pool 1. On the day T + X (transfer day), the institution B pays the institution a with a price, i.e., 'packet transfer money', according to the value (packet day loan balance) of the property pool 1 on the day T (packet day). All borrowing in the asset pool 1 becomes the B institution from T day (package day) actual crediting. The transaction type may also include: underwriting fees, lawyer fees, daily loan balance for packaging, daily loan balance for assignment, interest income from day of packaging to day of assignment, etc.

S404, under the condition that the accounting variable meets the triggering condition in the preset accounting triggering method, determining the meeting triggering condition.

S406, determining the accounting entry data according to the satisfied triggering conditions.

Specifically, when the determined accounting variables satisfy the triggering condition in the triggering method, which triggering condition each of the calculated accounting variables satisfies may be determined, and may be one or multiple triggering conditions. And then, the mapping relation among the accounting method, the triggering condition and the accounting entry data is characterized in the accounting triggering method. So that the corresponding accounting entry data can be determined according to the satisfied triggering conditions.

In some exemplary embodiments, the satisfied trigger condition and the respective accounting entry data may be determined by the table 3 accounting method trigger condition table. The accounting method trigger condition table may include a preset accounting trigger method.

TABLE 3 accounting method trigger Condition Table

Specifically, the above calculation results in the corresponding accounting variables of V001, V101, V102, V103, V104, V105, V106, etc., and whether the corresponding accounting variables satisfy the accounting method trigger condition may be determined according to the accounting method trigger condition in table 2, and if so, the corresponding accounting entry may be found according to the accounting method trigger condition table, where the remark of the trigger condition may indicate which transaction condition the trigger condition corresponds to. It should be noted that, only the accounting method trigger condition and the corresponding accounting entry in table 2 are used as an example, in an actual application process, a person skilled in the art may add or modify the accounting method trigger condition and the corresponding accounting entry according to an actual situation, and in this embodiment, the specific accounting method trigger condition and the corresponding accounting entry are not limited.

In the embodiment, various service scenes can be flexibly handled through the calculation conditions and the accounting method triggering conditions, the corresponding accounting entry can be calculated for different scenes, different programs do not need to be developed for each service scene, and the cost is saved.

In one embodiment, as shown in fig. 5, the determining the accounting entry pipelining data according to the accounting entry data and the preset accounting entry value condition includes:

s502, determining the entry value formula in preset accounting entry value conditions according to the accounting entry data, wherein the accounting entry value conditions also represent the mapping relation among the accounting entry data, subject code data, loan direction data and the entry value formula;

s504, the accounting entry flow data is determined according to the entry value formula.

The entry value formula may be a formula for calculating entry flow data by accounting the variation based on the accounting entry data.

Specifically, an entry value taking formula corresponding to the accounting entry record data in a preset accounting entry value taking condition is determined according to the accounting entry record data, and then accounting entry running water data is calculated through the formula, wherein the entry value taking formula has a mapping relation with subject code data and loan direction data, and the corresponding entry running water data also has a mapping relation with the corresponding subject code data and the loan direction data.

In some exemplary embodiments, the accounting entry pipeline data may be determined by the accounting entry configuration table of table 4. The accounting entry configuration table may include preset accounting entry value conditions.

TABLE 4 accounting entry configuration table

Wherein a formula description may generally be the meaning that the formula represents. Corresponding entry value formulas can be found in the accounting entry configuration table of table 4 through the accounting entry data, and then final entry flow data can be determined according to the formulas. For example, the accounting entry is ABS001, and the corresponding entry value formula is [ V001] in table 4, and then [ V001] may be entry running water data. The accounting entry is ABS105, and the corresponding entry value formula is as follows: v101 + V102 + V103, the accounting entry flow data may be the sum of V101, V102, and V103. It should be noted that, the various data in table 4 are merely used for illustration, and in the actual operation process, a person skilled in the art may modify the data according to the actual situation, and the specific data is not limited in this embodiment.

In this embodiment, can be accurate through the value formula of the entry confirm accounting entry flowing water data to can confirm accounting entry flowing water data under the different scenes, and can change the value formula of the entry in a flexible way according to different business scenes, and then calculate different accounting entry flowing water data, need not to use many sets of procedure, reduce the cost.

In an embodiment, as shown in fig. 6, the determining entry flow data in each specific service scenario according to the accounting entry flow data and the entry flow data in each specific service scenario to be incorporated into the general ledger result data according to the entry flow data in each specific service scenario includes:

and S602, determining the recorded stream data under each specific service scene according to the accounting recorded stream data.

And S604, determining general ledger result data to be merged according to the entry flow data in each specific service scene, wherein the general ledger result data to be merged at least comprises borrow data serial number data, borrow direction data, amount data, subject code data and amount type data.

The entry flow data is generally the sum of all accounting entry flow data in a specific business scenario.

Specifically, the obtaining of the accounting entry pipelining data classifies the accounting entry pipelining data according to business scenarios, each business scenario may include one or more accounting entry pipelining data, and the accounting entry pipelining data under each specific business scenario is obtained by synthesizing the one or more accounting entry pipelining data. And assembling the recorded stream data under each specific service scene to obtain general ledger result data to be merged. The general ledger result data to be merged comprises: the data of the debit number, the debit and credit direction, the amount of money, the subject code data and the amount of money type have corresponding mapping relation.

In some exemplary embodiments, the obtained to-be-incorporated ledger data may be as shown in table 5 to-be-incorporated ledger table.

Table 5 standing by general ledger sheet

Numbering	Directions of loan	Amount of money	Subject code	Accounting entry
					Borrow 01	D	50	1002010101	ABS104
Borrow 01	C	50	19317101	ABS104
					Borrow 01	C	50	22471901	ABS104
Borrow 01	D	50	23119201	ABS104
					Asset pool 1	D	10000	1002010101	ABS001
Asset pool 1	C	10000	22479902	ABS001
					Borrow 01	D	2	1002010101	ABS101
Borrow 01	C	2	22471904	ABS101
					Borrow 02	C	100	19317201	ABS105
Borrow 02	C	0	19317101	ABS105
					Borrow 02	D	100	1002010101	ABS105
Borrow 02	D	100	23119201	ABS105
					Borrow 02	C	100	22471901	ABS105

Wherein, borrow 01, borrow 02 can be the serial number of the flowing water data of the account keeping, and the assets pond can be the serial number of the flowing water data of the transaction. Through the processing, the bookkeeping running data and the transaction running data can be matched with the corresponding subject codes, and then accounting entries in different business scenes can be calculated in a targeted manner, and then the accounting entries are merged into the general ledger.

In this embodiment, the entry flow data in each specific service scene can be determined through each accounting entry flow data, and then the data of various asset reorganization service types can be borrowed and merged into the general ledger after being subjected to unified batch processing bookkeeping, so that the processing efficiency is improved, a plurality of programs do not need to be developed, and the cost is reduced.

It should be understood that, although the steps in the flowcharts related to the embodiments as described above are sequentially displayed as indicated by arrows, the steps are not necessarily performed sequentially as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the embodiments described above may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the execution order of the steps or stages is not necessarily sequential, but may be rotated or alternated with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, the embodiment of the present disclosure further provides a batch parallel account data processing apparatus for implementing the batch parallel account data processing method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the method, so that specific limitations in one or more embodiments of the batch parallel account data processing device provided below can be referred to the limitations on the batch parallel account data processing method in the foregoing, and details are not described here.

In one embodiment, as shown in fig. 7, there is provided a batch reconciliation data processing apparatus 700 comprising: a data acquisition module 702, an entry data determination module 704, a pipeline data determination module 706, and a general ledger data determination module 708, wherein:

a data obtaining module 702, configured to obtain accounting flow data and transaction flow data in each specific service scenario within a preset time limit according to the transaction record;

an entry data determining module 704, configured to determine, according to a trigger condition, each accounting entry data in each specific service scenario when each accounting streamline data and/or transaction streamline data meets a trigger condition in a preset accounting trigger method, where the accounting trigger method characterizes: checking a mapping relation among the method, the triggering condition and the accounting entry data; the trigger condition characterizes: checking the mapping relation among variables, variable names and calculation conditions;

the flow data determining module 706 is configured to determine each accounting entry flow data according to each accounting entry data and a preset accounting entry value condition, where the accounting entry value condition represents a mapping relationship between an accounting entry, subject code data, and an entry value formula;

the general ledger data determination module 708 is configured to determine entry flow data in each specific service scenario according to the accounting entry flow data, and determine general ledger result data to be merged according to the entry flow data in the specific service scenario.

In one embodiment of the apparatus, the data acquisition module 702 comprises: a time limit data acquisition module and a service data acquisition module;

the term data acquisition module is used for acquiring accounting running data and transaction running data within a preset term according to a transaction record, wherein the accounting running data at least comprises: borrow number data, borrow direction data, amount data, subject code data, amount type data and transaction code data.

The service data acquisition module is used for acquiring accounting flow data within a preset time limit, accounting flow data corresponding to a specific service scene in the transaction flow data, and transaction flow data to obtain accounting flow data and transaction flow data in the specific service scene within the preset time limit, wherein the specific service scene at least comprises: property securitization business, loan insurance business, joint loan business and entrusted loan business.

In an embodiment of the apparatus, the data obtaining module 702 further includes: and the duplication elimination processing module is used for carrying out duplication elimination processing on the borrow number and the transaction number.

In an embodiment of the apparatus, the entry data determining module 704 includes: the device comprises a calculation condition determining module, an accounting variable determining module, a trigger condition determining module and a trigger condition determining module;

and the calculation condition determining module is used for determining calculation conditions according to subject code data, amount type data, transaction types in the accounting flow data and/or transaction types in the transaction flow data.

And the accounting variable determining module is used for determining corresponding accounting variables according to the calculating conditions.

And the trigger condition determining module is used for determining the satisfied trigger condition under the condition that the accounting variable meets the preset trigger condition in the accounting trigger method.

The triggering condition determining module is used for determining the accounting entry data according to the satisfied triggering conditions.

In one embodiment of the apparatus, the pipelined data determination module 706 includes: the formula determining module and the formula calculating module;

the formula determining module is used for determining the entry value formula in preset accounting entry value conditions according to the accounting entry data, and the accounting entry value conditions also represent the mapping relation among the accounting entry data, subject code data, loan direction data and the entry value formula.

And the formula calculation module is used for determining the accounting entry flow data according to the entry value formula.

In one embodiment of the apparatus, the ledger data determination module 708 comprises: the system comprises a scene data determining module and a general ledger data integrating module;

and the scene data determining module is used for determining the recorded stream data under each specific service scene according to the accounting recorded stream data.

The general ledger data integration module is used for determining general ledger result data to be merged according to entry flow data under each specific service scene, wherein the general ledger result data to be merged at least comprises borrow data serial number data, borrow direction data, amount data, subject code data and amount type data.

The modules in the batch parallel account data processing device can be wholly or partially realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a server, and the internal structure thereof may be as shown in fig. 8. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing accounting running water data, transaction running water data, accounting triggering methods and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a batch reconciliation data processing method.

Those skilled in the art will appreciate that the architecture shown in fig. 8 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the above-described method embodiments when executing the computer program.

In an embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which computer program, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

In an embodiment, a computer program product is provided, comprising a computer program which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

It should be noted that billing chronological data, transaction chronological data, etc. (including but not limited to data for analysis, stored data, presented data, etc.) referred to in this disclosure are information and data that are authorized by the user or sufficiently authorized by the parties.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, databases, or other media used in the embodiments provided by the present disclosure may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases involved in embodiments provided by the present disclosure may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided in this disclosure may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic, quantum computing based data processing logic, etc., without limitation.

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several implementation modes of the present disclosure, and the description thereof is specific and detailed, but not to be understood as limiting the scope of the present disclosure. It should be noted that, for those skilled in the art, various changes and modifications can be made without departing from the concept of the present disclosure, and these changes and modifications are all within the scope of the present disclosure. Therefore, the protection scope of the present disclosure should be subject to the appended claims.

Claims (10)

1. A batch parallel account data processing method is characterized by comprising the following steps:

acquiring accounting flow data and transaction flow data under each specific service scene within a preset time limit according to the transaction records;

under the condition that each accounting flow data and/or transaction flow data meets a trigger condition in a preset accounting trigger method, each accounting entry data under each specific service scene is determined according to the trigger condition, and the accounting trigger method is characterized in that: the mapping relation among the accounting method, the triggering condition and the accounting entry data; the trigger condition is determined according to an accounting variable, and the accounting variable is determined according to the accounting flow data and the transaction flow data;

determining each accounting entry stream data according to each accounting entry data and a preset accounting entry value condition, wherein the accounting entry value condition represents a mapping relation among the accounting entry data, subject code data and an entry value formula;

and determining entry flow data under each specific service scene according to the accounting entry flow data, and determining general ledger result data to be merged according to the entry flow data under each specific service scene.

2. The method according to claim 1, wherein the obtaining accounting flow data in a specific service scenario within a preset time limit and the transaction flow data within the preset time limit according to the transaction record comprises:

acquiring accounting running water data and transaction running water data within a preset time limit according to a transaction record, wherein the accounting running water data at least comprises the following data: borrowing number data, borrowing direction data, amount data, subject code data, amount type data and transaction code data, wherein the transaction flow data at least comprises the following steps: transaction number, amount, transaction type;

acquiring accounting flow data and transaction flow data corresponding to a specific service scene in the accounting flow data and the transaction flow data within a preset time limit to obtain accounting flow data and transaction flow data under the specific service scene within the preset time limit, wherein the specific service scene at least comprises: property securitization business, loan insurance business, joint loan business and entrusted loan business.

3. The method of claim 2, further comprising:

and carrying out duplication elimination processing on the borrow number and the transaction number.

4. The method according to claim 2, wherein in the case that the accounting flow data and/or the transaction flow data meet the trigger condition in the pre-set accounting trigger method, determining the accounting entry data in each specific service scenario according to the trigger condition comprises:

determining corresponding accounting variables according to computing conditions, wherein the computing conditions are determined according to subject code data, amount type data, transaction types in accounting flow data and/or transaction types in the transaction flow data;

determining the satisfied triggering condition under the condition that the accounting variable satisfies the triggering condition in a preset accounting triggering method;

and determining each accounting entry data according to the satisfied triggering condition.

5. The method of claim 2, wherein the determining the accounting entry pipeline data according to the accounting entry data and the preset accounting entry value condition comprises:

determining the entry value formula in preset accounting entry value conditions according to the accounting entry data, wherein the accounting entry value conditions also represent the mapping relation among the accounting entry data, subject code data, loan direction data and the entry value formula;

and determining the accounting entry flow data according to the entry value formula.

6. The method of claim 2, wherein the determining of the entry flow data in each specific business scenario according to the accounting entry flow data includes:

determining recorded stream data under each specific service scene according to the accounting recorded stream data;

and determining general ledger result data to be merged according to the entry flow data in each specific service scene, wherein the general ledger result data to be merged at least comprises borrow number data, borrow direction data, amount data, subject code data and amount type data.

7. A batch reconciliation data processing apparatus, the apparatus comprising:

the data acquisition module is used for acquiring accounting flow data and transaction flow data in each specific service scene within a preset time limit according to the transaction records;

the entry data determining module is used for determining each accounting entry data under each specific service scene according to a trigger condition under the condition that each accounting flow data and/or transaction flow data meets the trigger condition in a preset accounting trigger method, and the accounting trigger method is characterized in that: the mapping relation among the accounting method, the triggering condition and the accounting entry data; the trigger condition characterizes: checking the mapping relation among variables, variable names and calculation conditions;

the flow data determining module is used for determining flow data of each accounting entry according to the accounting entry data and preset accounting entry value conditions, wherein the accounting entry value conditions represent mapping relations among accounting entries, subject code data and entry value formulas;

and the general ledger data determination module is used for determining the entry flow data under each specific service scene according to the accounting entry flow data and determining the general ledger result data to be merged according to the entry flow data under each specific service scene.

8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 6.

9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.

10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.

Images