CN116342304A - Data processing method, device, electronic equipment, system, medium and program product - Google Patents

Data processing method, device, electronic equipment, system, medium and program product Download PDF

Info

Publication number
CN116342304A
CN116342304A CN202310093863.7A CN202310093863A CN116342304A CN 116342304 A CN116342304 A CN 116342304A CN 202310093863 A CN202310093863 A CN 202310093863A CN 116342304 A CN116342304 A CN 116342304A
Authority
CN
China
Prior art keywords
certificate
withdrawal
current day
voucher
general ledger
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310093863.7A
Other languages
Chinese (zh)
Inventor
苏南生
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
CCB Finetech Co Ltd
Original Assignee
China Construction Bank Corp
CCB Finetech Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp, CCB Finetech Co Ltd filed Critical China Construction Bank Corp
Priority to CN202310093863.7A priority Critical patent/CN116342304A/en
Publication of CN116342304A publication Critical patent/CN116342304A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll

Abstract

The embodiment of the invention discloses a data processing method, a data processing device, electronic equipment, a medium and a program product. The invention relates to the technical field of big data. The method comprises the following steps: before daily check batch processing, acquiring accounting data generated by a business component on the same day, and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher line format; updating the current day general ledger subject balance according to the to-be-charged certificate at regular intervals, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list; and under the condition that the mechanism withdrawal exists, generating a mechanism withdrawal accounting transfer certificate according to a set rule, and generating a to-be-credited certificate according to the mechanism withdrawal accounting transfer certificate. According to the technical scheme, accounting data generated by a business component on the same day is obtained before daily junction batch processing, and a daily general ledger voucher is generated based on the accounting data; generating a to-be-checked-in voucher according to the organization withdrawal accounting transfer voucher so as to improve timeliness of the general ledger day check.

Description

Data processing method, device, electronic equipment, system, medium and program product
Technical Field
Embodiments of the present invention relate to the field of big data technologies, and in particular, to a data processing method, apparatus, electronic device, system, medium, and program product.
Background
The bank general ledger needs to wait for all upstream components to be closed, and the daily batch processing can be started after new account data is not generated on the same day. If the mechanism is withdrawn on the same day, the operation of transferring the balance of the financial accounts of the withdrawal mechanism needs to be added in the daily check batch processing process, so that the total account daily check completion time is delayed compared with the total account daily check without the mechanism withdrawal, and if the mechanism is withdrawn before the total account daily check, the problem of unclean financial account transfer is caused because of old mechanism financial data generated on the same day.
In the prior art, as all accounting data is not received in the daytime of the general ledger, the traditional general ledger system transfers the mechanism withdrawal and accounting to the daily settlement step for processing. Because the historical stock data is more, the day account settlement of the current day can be completed after one to two hours, the batch processing and report issuing timeliness of a downstream system depending on the day account settlement data are affected, the mechanism withdrawal accounting balance settlement is converted into the day account settlement step processing, the day account settlement time is prolonged, and the day account settlement batch processing needs to wait for all account settlement of an upstream business component to start processing, so that the timeliness is lower.
Therefore, how to improve the timeliness of the general ledger is a problem to be solved.
Disclosure of Invention
The embodiment of the invention provides a data processing method, a device, equipment, a system, a medium and a program product, which are used for improving timeliness of general ledger day-knot.
In a first aspect, an embodiment of the present invention provides a data processing method, including:
before daily check batch processing, acquiring accounting data generated by a business component on the same day, and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher line format;
updating the current day general ledger subject balance according to the to-be-charged certificate at regular intervals, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list;
and under the condition that the mechanism withdrawal exists, generating a mechanism withdrawal accounting transfer certificate according to a set rule, and generating a to-be-checked-in certificate according to the mechanism withdrawal accounting transfer certificate.
In a second aspect, an embodiment of the present invention further provides a data processing apparatus, including:
the data acquisition module is used for acquiring accounting data generated by the business component on the same day before daily check batch processing and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher line format;
The withdrawal judging module is used for periodically updating the current day general ledger subject balance according to the to-be-checked-in certificate, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list;
and the certificate generation module is used for generating a mechanism withdrawal accounting transfer certificate according to a set rule under the condition that the mechanism withdrawal exists, and generating a to-be-checked certificate according to the mechanism withdrawal accounting transfer certificate.
In a third aspect, an embodiment of the present invention further provides an electronic device, including a memory, a processor, and a computer program that is stored in the memory and is executable on the processor, where the processor executes the program to implement a data processing method according to any one of the embodiments of the present invention.
In a fourth aspect, an embodiment of the present invention further provides a data processing system, including a browser end, a service server, an authentication server and a security monitoring server that are communicatively connected, where the authentication server and the security monitoring server implement the data processing method according to any one of the embodiments of the present invention when executing the program.
In a fifth aspect, embodiments of the present invention further provide a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a data processing method according to any of the embodiments of the present invention.
In a sixth aspect, embodiments of the present invention also provide a computer program product comprising a computer program which, when executed by a processor, implements a data processing method according to any of the embodiments of the present invention.
According to the embodiment of the invention, the accounting data generated by the business component on the same day is obtained before daily junction batch processing, and the daily general ledger voucher is generated based on the accounting data; updating the account balance of the general ledger on the same day according to the to-be-credited certificate at regular intervals; judging whether the mechanism withdrawal exists on the same day, and generating a mechanism withdrawal accounting transfer certificate according to a set rule under the condition that the mechanism withdrawal exists, and generating a to-be-checked-in certificate according to the mechanism withdrawal accounting transfer certificate so as to improve timeliness of the general account day check.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic diagram of an application scenario in the prior art provided by an embodiment of the present invention;
FIG. 2 is a flowchart of a data processing method according to an embodiment of the present invention;
FIG. 3 is a flowchart of another data processing method according to an embodiment of the present invention;
FIG. 4 is a flowchart of another data processing method according to an embodiment of the present invention;
FIG. 5 is a flowchart of another data processing method according to an embodiment of the present invention;
FIG. 6 is a flowchart of another data processing method according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of a data processing apparatus according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise 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, system, article, or apparatus 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 apparatus. The data acquisition, storage, use, processing and the like in the technical scheme meet the relevant regulations of national laws and regulations.
Fig. 1 is a prior art application scenario diagram of data processing. As shown in FIG. 1, the mechanism withdrawal and accounting balance transfer is processed in the daily accounting step, which results in the prolongation of the daily accounting time, and the daily accounting batch processing needs to wait for all accounting of the upstream business components to start processing, so that the timeliness is low, and the mechanism withdrawal and accounting transfer is due to the fact that the multidimensional COA comprises a plurality of subject systems, so that hundreds of millions of history certificates need to be processed, and the time consumption is long and the steps are complicated.
The withdrawal of the institution can be the withdrawal or combination of each website and branch of the bank in consideration of prevention risk and improvement of self-operation benefit.
The daily statement may be a daily statement made by a bank at the end of a daily job.
Closing may refer to validating a previous period of economic service before a new account is enabled. After closing, the functions of making a bill, entering, checking, modifying and transferring, etc. cannot be used, i.e. no billing service can be performed during closing. Accounting can be used to confirm the income and expense of the previous period.
Because the general ledger day has not received all the accounting data, the traditional general ledger system transfers the institution withdrawal accounting to the day check step for processing. Because the historical stock data is more, the day account settlement of the current day can be completed after one to two hours, the batch processing and report issuing timeliness of a downstream system depending on the day account settlement data are affected, the mechanism withdrawal accounting balance settlement is converted into the day account settlement step processing, the day account settlement time is prolonged, and the day account settlement batch processing needs to wait for all account settlement of an upstream business component to start processing, so that the timeliness is lower.
Aiming at the technical problems, the application provides the following technical conception: before daily check batch processing, acquiring accounting data generated by a business component on the same day, and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher line format; updating the current day general ledger subject balance according to the to-be-charged certificate at regular intervals, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list; and under the condition that the mechanism withdrawal exists, generating a mechanism withdrawal accounting transfer certificate according to a set rule, and generating a to-be-credited certificate according to the mechanism withdrawal accounting transfer certificate. Therefore, the problem of low timeliness of the general ledger daily statement in the prior art can be solved.
The following describes the technical solutions of the present application and how the technical solutions of the present application solve the above technical problems in detail with specific embodiments. The following embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 2 is a flowchart of a data processing method according to an embodiment of the present invention, where the method may be implemented by a data processing device, and the data processing device may be implemented in hardware and/or software, and the data processing device may be configured in an electronic device with data processing capability. As shown in fig. 2, the method includes:
S210, acquiring accounting data generated by a business component on the same day before daily check batch processing, and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher row format.
The daily batch settlement processing can be daily batch settlement carried out by financial institutions such as banks and the like when daily work is finished; the business components may be individual economic business related components contained in a bank ledger system for generating accounting data; specifically, the service components may include a plurality of upstream service components and a plurality of downstream service components, where the downstream service components may be configured to receive accounting data generated by the upstream service components, and so on; the business component data in this embodiment can be understood as each upstream business component of the generated accounting data.
The accounting data can be used for reflecting the financial conditions, operation achievements and the like of enterprises; the general ledger can be a general classified ledger or a summary ledger. Unlike the detail records of the statement, the general ledger is directly summarized. The system can be used for recording statistics and economic business, setting the accounting system into a general ledger according to the objective content of each accounting department, and assembling a financial report by the data of the general ledger. For example: inventory cash and bank deposit, etc.
In this embodiment, the general ledger system of the bank can be used to perform unified accounting on account data generated by the service components on the same day, where the general ledger system of the bank can bear the function of full-line accounting by means of a multi-dimensional COA (accounting of account) system of the account, and the service system is docked by means of the accounting engine, and after all the components are closed, the general ledger system of the bank performs unified accounting on account data generated by all the service components on the present day.
The multi-dimensional COA subject system can be used for defining a combined structure of an account structure and a section, and can be used for accounting to a specific dimension according to different accounting criteria, enterprise types, enterprise demands and the like when an enterprise is billed.
In this embodiment, the day ledger voucher may be accounting data before receiving the day ledger of all business components in a set time, and is used to generate the day ledger voucher. The day ledger voucher may be the original ledger voucher generated based on the accounting records of the upstream business components.
Illustratively, obtaining the accounting data generated by the business component on the current day, generating the current day general ledger voucher based on the accounting data according to the general ledger voucher line format may include: acquiring accounting data generated on the same day and sent by each business component; under the condition that the fields of the general ledger voucher row comprise a voucher account COA, a borrower amount and a lender amount, a set COA section, the borrower amount and the lender amount in the accounting data are obtained, and the general ledger voucher on the current day is generated according to the set COA section, the borrower amount and the lender amount.
In this embodiment, the field table for generating the general ledger voucher based on the accounting data according to the general ledger voucher line format may be as follows in table 1:
table 1 general ledger voucher field table
Figure GDA0004119980060000051
It should be emphasized that the amounts of the borrower and lender amounts in the above-described tables are merely examples and are not meant to be limiting.
S220, updating the current day general ledger subject balance according to the to-be-charged certificate periodically, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list.
The general account subject balance can be the current balance of each subject in the general account of the enterprise, can be used for reflecting the assets, liabilities, equities and variation conditions of the enterprise, and is an important basis for the enterprise to make decisions.
The mechanism withdraw list of the current day can be the specific names and the like of each website and branch structure of the banks for counting the mechanism withdraw occurring on the current day, and is uniformly stored in the mechanism withdraw list of the current day, and the mechanism withdraw scope of the current day and the mechanism withdraw and post-deposit accounting transfer to the corresponding target mechanism can be obtained according to the mechanism withdraw list.
Specifically, the withdrawal mechanism table may be shown in table 2 below, which shows the specific names of withdrawal mechanisms and incorporation mechanisms at different times.
Table 2 withdrawal mechanism table
Date of day Revocation mechanism Incorporating mechanisms
2022-11-08 Mechanism A Mechanism B
2022-11-08 Mechanism D Mechanism F
It should be noted that the dates in the table are only examples and are not limited thereto.
In this embodiment, the general ledger can periodically check out the non-checked-in credentials, so as to update the general ledger subject balance, specifically, if the non-checked-in credentials are checked out, the general ledger subject balance is correspondingly increased/decreased, and if the non-checked-in credentials are not checked out, the general ledger subject balance is unchanged.
For example, updating the daily ledger subject balance periodically based on the to-be-credited credentials may include: under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate; and under the condition that the to-be-checked-in voucher exists, checking in the to-be-checked-in voucher, and updating the general ledger subject balance on the same day.
The timing task can be understood as determining the to-be-checked-in credentials which are not checked-in the accounting data generated by the business component on the same day according to fixed time, and monitoring the to-be-checked-in credentials which are not checked-in.
The mechanism withdrawal and accounting transfer certificate can be understood as an accounting certificate for proving that the economic service matters are transferred if each website and branch generation mechanism of a certain bank are withdrawn and the general ledger balance is transferred to the other general ledger balance in the same day.
In this embodiment, if there is a to-be-checked-in certificate that is not checked-in, the to-be-checked-in certificate is checked-in, and the general ledger account balance is increased or decreased in the same day.
Illustratively, the fields of the current day ledger subject balance may include: the voucher account, the primary borrower balance, the primary lender balance, the present borrower occurrence and the present lender occurrence.
In this embodiment, the following table 3 may be used to show a field table of the general ledger subject balance:
table 3 general ledger subject balance field table
Figure GDA0004119980060000061
Figure GDA0004119980060000071
It should be emphasized that the specific numbers of voucher accounts, primary debit balances, primary credit balances, present debit occurrences and present credit occurrences in the above-described tables are by way of example only and are not meant to be limiting.
Illustratively, posting the to-be-posted credential, updating the current day general ledger subject balance may include: when the to-be-charged certificate is charged, the daily general ledger subject balance is updated according to the certificate account COA, the initial borrower balance, the initial lender balance, the generated amount of the present borrower and the generated amount of the present lender in the to-be-charged certificate.
In this embodiment, if the to-be-charged certificate is charged, the certificate account COA, the primary debit balance, the primary credit balance, the generated amount of the present debit and the generated amount of the present credit are updated, and the updated result is used as the update of the general account balance on the same day.
Illustratively, determining whether there is an institution withdrawal on the day based on the day ledger voucher, the day ledger subject balance, and the day institution withdrawal list may include: before daily account batch processing, respectively acquiring a day general ledger voucher and a voucher account in the day general ledger account balance; inquiring the mechanism withdrawal list of the current day according to the certificate account, and judging whether the mechanism withdrawal exists on the current day according to the inquiry result.
In this embodiment, the institution withdrawal list of the current day may be queried according to a certain subject of the multi-dimensional COA subject system of the credential account, and whether the institution withdrawal exists on the current day is determined according to the query result.
Specifically, the mechanism section of the credential account may be queried, which is not limited in this embodiment, and may be flexibly set according to actual needs.
Illustratively, querying the institution withdrawal list of the current day according to the credential account, and judging whether the institution withdrawal exists on the current day according to the query result may include: inquiring a withdrawal list of the current day mechanism according to the mechanism section in the voucher account of the current day general ledger voucher; if the mechanism section corresponding to the day general ledger voucher is matched with the revocation mechanism in the day mechanism revocation list, determining that the mechanism revocation exists on the day, wherein the mechanism revocation information is derived from the day general ledger voucher; inquiring a current day organization withdraw list according to the organization section in the voucher account of the current day general account balance; if the institution segment corresponding to the current day general ledger account balance is matched with the revocation institution in the current day institution revocation list, determining that the current day has the institution revocation, and the institution revocation information is derived from the current day general ledger account balance.
In this embodiment, in the case where it is determined that the mechanism withdrawal occurs on the same day, the source of the mechanism withdrawal information may be determined.
And S230, under the condition that the mechanism is withdrawn, generating a mechanism withdrawn accounting transfer certificate according to a set rule, and generating a to-be-credited certificate according to the mechanism withdrawn accounting transfer certificate.
In this embodiment, if there is a withdrawal of the institution, a withdrawal accounting transfer voucher is generated according to a set rule, a to-be-checked-in voucher is generated according to the withdrawal of the institution, and daily check batch processing is performed according to the to-be-checked-in voucher.
The setting rule can be an institution withdrawal accounting transfer certificate generated for each institution generating the institution withdrawal according to the service requirement.
According to the method, the to-be-checked-in voucher is generated according to the mechanism withdrawal accounting transfer voucher before daily check, so that daily check batch processing is not required to be processed again, daily check aging is improved, meanwhile, the mechanism withdrawal accounting transfer is advanced to daily check batch processing pretreatment, daily check batch processing time is not required to be occupied, and total account daily check batch processing steps can be reduced, so that daily check aging is further improved.
Illustratively, the to-be-credited voucher is generated from the day ledger voucher without the withdrawal of the institution.
In this embodiment, if there is no mechanism withdrawal, the to-be-checked-in certificate may be directly generated according to the general account certificate on the same day.
Before daily check batch processing, the embodiment of the invention generates a daily general ledger voucher based on accounting data; updating the current day general ledger account balance according to the to-be-charged certificate, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger account balance and the current day mechanism withdrawal list; under the condition that the mechanism withdrawal exists, generating a mechanism withdrawal accounting transfer certificate according to a set rule, generating a to-be-checked certificate according to the mechanism withdrawal accounting transfer certificate, and reducing the batch processing steps of the general ledger and the daily check without occupying the batch processing time of the daily check, thereby improving the timeliness of the general ledger and the daily check.
Fig. 3 is a flowchart of another data processing method according to an embodiment of the present invention, where "generating a mechanism withdrawal accounting transfer certificate according to a set rule" is further defined on the basis of the above embodiment. As shown in fig. 3, the data processing method includes the steps of:
s310, acquiring accounting data generated by a business component on the same day before daily check batch processing, and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher line format.
Illustratively, obtaining the accounting data generated by the business component on the current day, generating the current day general ledger voucher based on the accounting data according to the general ledger voucher line format may include: acquiring accounting data generated on the same day and sent by each business component; under the condition that the fields of the general ledger voucher row comprise a voucher account COA, a borrower amount and a lender amount, a set COA section, the borrower amount and the lender amount in the accounting data are obtained, and the general ledger voucher on the current day is generated according to the set COA section, the borrower amount and the lender amount.
Illustratively, determining whether there is an institution withdrawal on the day based on the day ledger voucher, the day ledger subject balance, and the day institution withdrawal list may include: before daily account batch processing, respectively acquiring a day general ledger voucher and a voucher account in the day general ledger account balance; inquiring the mechanism withdrawal list of the current day according to the certificate account, and judging whether the mechanism withdrawal exists on the current day according to the inquiry result.
Illustratively, querying the institution withdrawal list of the current day according to the credential account, and judging whether the institution withdrawal exists on the current day according to the query result may include: inquiring a withdrawal list of the current day mechanism according to the mechanism section in the voucher account of the current day general ledger voucher; if the mechanism section corresponding to the day general ledger voucher is matched with the revocation mechanism in the day mechanism revocation list, determining that the mechanism revocation exists on the day, wherein the mechanism revocation information is derived from the day general ledger voucher; inquiring a current day organization withdraw list according to the organization section in the voucher account of the current day general account balance; if the institution segment corresponding to the current day general ledger account balance is matched with the revocation institution in the current day institution revocation list, determining that the current day has the institution revocation, and the institution revocation information is derived from the current day general ledger account balance.
S320, updating the current day general ledger subject balance according to the to-be-charged certificate periodically, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list.
For example, updating the daily ledger subject balance periodically based on the to-be-credited credentials may include: under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate; and under the condition that the to-be-checked-in voucher exists, checking in the to-be-checked-in voucher, and updating the general ledger subject balance on the same day.
For example, updating the daily ledger subject balance periodically based on the to-be-credited credentials may include: under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate; and under the condition that the to-be-checked-in voucher exists, checking in the to-be-checked-in voucher, and updating the general ledger subject balance on the same day.
Illustratively, the fields of the current day ledger subject balance may include: the voucher account, the primary borrower balance, the primary lender balance, the present borrower occurrence and the present lender occurrence.
Illustratively, posting the to-be-posted credential, updating the current day general ledger subject balance may include: when the to-be-charged certificate is charged, the daily general ledger subject balance is updated according to the certificate account COA, the initial borrower balance, the initial lender balance, the generated amount of the present borrower and the generated amount of the present lender in the to-be-charged certificate.
S330, under the condition that the mechanism withdrawal exists, under the condition that the mechanism withdrawal information is derived from the day general ledger voucher, generating two mechanism withdrawal account transfer vouchers according to the day general ledger voucher and the first set rule; wherein, the first setting rule includes: the method comprises the steps that a voucher account of a general ledger voucher on the same day is kept unchanged, and a borrower amount and a lender amount are multiplied by-1 respectively to obtain a mechanism withdrawal accounting transfer voucher; and replacing the withdrawal mechanism in the certificate account of the general account certificate on the current day with the merging mechanism, and keeping the borrower amount and the lender amount unchanged to obtain a withdrawal accounting transfer certificate of another mechanism.
If the institution withdrawal information originates from the day ledger voucher, the voucher account (COA), the debit amount and the credit amount may be used as input fields, as shown in the day ledger voucher source table shown in table 4:
Table 4 day general ledger voucher Source Table
Figure GDA0004119980060000091
It should be noted that the amount of the borrower in the above table is merely an example, and does not represent a specific limitation thereof.
In this embodiment, two institution withdrawal and accounting transfer certificates may be generated according to a first rule table set as shown in table 5 below.
TABLE 5 first set rules Table
Figure GDA0004119980060000101
In this embodiment, two mechanism withdrawal and accounting transfer certificates are generated according to the first setting rule table, and the two mechanism withdrawal and accounting transfer certificate tables in the following table 6 are shown:
table 6 two institutions withdraw accounting transfer certificate table
Figure GDA0004119980060000102
It should be noted that the amount of the borrower in the above table is merely an example, and does not represent a specific limitation thereof.
S340, generating a to-be-credited certificate according to the institution withdrawal accounting transfer certificate.
Illustratively, the to-be-credited voucher is generated from the day ledger voucher without the withdrawal of the institution.
According to the embodiment of the invention, the day general ledger voucher is generated based on the accounting data before day-setting batch processing; updating the current day general ledger account balance according to the to-be-charged certificate, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger account balance and the current day mechanism withdrawal list; under the condition that the mechanism is withdrawn, the mechanism withdrawal accounting transfer certificates are generated according to different setting rules, each to-be-checked certificate is generated according to the mechanism withdrawal accounting transfer certificates, the daily check batch processing time is not required to be occupied, and the daily check batch processing steps of the general ledger can be reduced, so that the timeliness of the daily check of the general ledger is improved.
Fig. 4 is a flowchart of yet another data processing method according to an embodiment of the present invention, where "generating a mechanism withdrawal accounting transfer certificate according to a set rule" is further defined on the basis of the above embodiment. As shown in fig. 4, the data processing method includes the steps of:
s410, acquiring account data generated by the business component on the same day before daily check batch processing, and generating a daily general ledger voucher based on the account data according to the general ledger voucher line format.
Illustratively, obtaining the accounting data generated by the business component on the current day, generating the current day general ledger voucher based on the accounting data according to the general ledger voucher line format may include: acquiring accounting data generated on the same day and sent by each business component; under the condition that the fields of the general ledger voucher row comprise a voucher account COA, a borrower amount and a lender amount, a set COA section, the borrower amount and the lender amount in the accounting data are obtained, and the general ledger voucher on the current day is generated according to the set COA section, the borrower amount and the lender amount.
Illustratively, determining whether there is an institution withdrawal on the day based on the day ledger voucher, the day ledger subject balance, and the day institution withdrawal list may include: before daily account batch processing, respectively acquiring a day general ledger voucher and a voucher account in the day general ledger account balance; inquiring the mechanism withdrawal list of the current day according to the certificate account, and judging whether the mechanism withdrawal exists on the current day according to the inquiry result.
Illustratively, querying the institution withdrawal list of the current day according to the credential account, and judging whether the institution withdrawal exists on the current day according to the query result may include: inquiring a withdrawal list of the current day mechanism according to the mechanism section in the voucher account of the current day general ledger voucher; if the mechanism section corresponding to the day general ledger voucher is matched with the revocation mechanism in the day mechanism revocation list, determining that the mechanism revocation exists on the day, wherein the mechanism revocation information is derived from the day general ledger voucher; inquiring a current day organization withdraw list according to the organization section in the voucher account of the current day general account balance; if the institution segment corresponding to the current day general ledger account balance is matched with the revocation institution in the current day institution revocation list, determining that the current day has the institution revocation, and the institution revocation information is derived from the current day general ledger account balance.
S420, updating the current day general ledger subject balance according to the to-be-charged certificate periodically, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list.
For example, updating the daily ledger subject balance periodically based on the to-be-credited credentials may include: under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate; and under the condition that the to-be-checked-in voucher exists, checking in the to-be-checked-in voucher, and updating the general ledger subject balance on the same day.
For example, updating the daily ledger subject balance periodically based on the to-be-credited credentials may include: under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate; and under the condition that the to-be-checked-in voucher exists, checking in the to-be-checked-in voucher, and updating the general ledger subject balance on the same day.
Illustratively, the fields of the current day ledger subject balance may include: the voucher account, the primary borrower balance, the primary lender balance, the present borrower occurrence and the present lender occurrence.
Illustratively, posting the to-be-posted credential, updating the current day general ledger subject balance may include: when the to-be-charged certificate is charged, the daily general ledger subject balance is updated according to the certificate account COA, the initial borrower balance, the initial lender balance, the generated amount of the present borrower and the generated amount of the present lender in the to-be-charged certificate.
S430, under the condition that mechanism withdrawal exists, under the condition that mechanism withdrawal information is derived from the current day general ledger subject balance, generating four mechanism withdrawal account transfer certificates according to the current day general ledger subject balance and a second set rule; wherein the second setting rule includes: the voucher account in the general account subject balance of the current day is kept unchanged, the difference value between the primary borrower balance of the calculation period multiplied by-1 and the generated amount of the primary borrower is taken as the borrower amount, the lender amount is set as a set value, and the first institution withdrawal accounting transfer voucher is obtained; the voucher account in the general account balance of the current day is kept unchanged, the debit amount is set as a set value, the difference between the calculated primary credit balance multiplied by-1 and the generated amount of the present credit is used as a credit amount, and a second institution withdrawal accounting transfer voucher is obtained; replacing a withdrawal mechanism in the account balance of the general ledger on the current day with a merging mechanism, calculating the sum of the account balance at the beginning of the period and the account generated at the current period as the debit, and setting the credit as a set value to obtain a withdrawal accounting transfer certificate of a third mechanism; and replacing the withdrawal mechanism in the current day general account balance with an merging mechanism, setting the debit amount as a set value, calculating the sum of the initial credit balance and the current period credit occurrence amount as the credit amount, and obtaining a fourth mechanism withdrawal accounting transfer certificate.
In this embodiment, if the institution withdrawal information is derived from the current day account balance, the available voucher account (COA), the initial term debit balance, the initial term credit balance, the current term debit occurrence and the current term credit occurrence are used as input fields, as shown in the current day account balance source table shown in table 7 below:
TABLE 7 general ledger subject balance Source List on the same day
Figure GDA0004119980060000121
It should be noted that the amounts of the voucher account, the primary borrower balance, the primary lender balance, the present borrower occurrence amount, and the present lender occurrence amount in the above table are merely examples, and do not represent specific limitations thereon.
In this embodiment, the general ledger balance on the same day may generate four institution withdrawal accounting transfer certificates according to the second set rule table shown in table 8 below.
Table 8 second set rule table
Figure GDA0004119980060000122
Figure GDA0004119980060000131
In this embodiment, according to the second setting rule table, four mechanism withdrawal and accounting transfer voucher tables in the following table 9 may be generated:
table 9 four institutions withdraw the accounting and transfer certificate table
Figure GDA0004119980060000132
It should be noted that the amount of the borrower in the above table is merely an example, and does not represent a specific limitation thereof.
S440, generating a to-be-credited certificate according to the institution withdrawal accounting transfer certificate.
Illustratively, the to-be-credited voucher is generated from the day ledger voucher without the withdrawal of the institution.
According to the embodiment of the invention, the day general ledger voucher is generated based on the accounting data before day-setting batch processing; updating the current day general ledger account balance according to the to-be-charged certificate, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger account balance and the current day mechanism withdrawal list; under the condition that the mechanism is withdrawn, the mechanism withdrawal accounting transfer certificates are generated according to different setting rules, each to-be-checked certificate is generated according to the mechanism withdrawal accounting transfer certificates, the daily check batch processing time is not required to be occupied, and the daily check batch processing steps of the general ledger can be reduced, so that the timeliness of the daily check of the general ledger is improved.
Fig. 5 is a flowchart of another data processing method according to an embodiment of the present invention, where on the basis of the foregoing embodiment, the "generating two corresponding mechanism withdrawal accounting transfer certificates and four mechanism withdrawal accounting transfer certificates according to the first setting rule and the second setting rule" is further defined. As shown in fig. 5, the data processing method further includes the following steps:
s510, acquiring account data generated by the business component on the same day before daily check batch processing, and generating a daily general ledger voucher based on the account data according to the general ledger voucher line format.
Illustratively, obtaining the accounting data generated by the business component on the current day, generating the current day general ledger voucher based on the accounting data according to the general ledger voucher line format may include: acquiring accounting data generated on the same day and sent by each business component; under the condition that the fields of the general ledger voucher row comprise a voucher account COA, a borrower amount and a lender amount, a set COA section, the borrower amount and the lender amount in the accounting data are obtained, and the general ledger voucher on the current day is generated according to the set COA section, the borrower amount and the lender amount.
S520, updating the account balance of the general ledger on the same day according to the to-be-checked-in vouchers at regular intervals.
For example, updating the daily ledger subject balance periodically based on the to-be-credited credentials may include: under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate; and under the condition that the to-be-checked-in voucher exists, checking in the to-be-checked-in voucher, and updating the general ledger subject balance on the same day.
Illustratively, posting the to-be-posted credential, updating the current day general ledger subject balance may include: when the to-be-charged certificate is charged, the daily general ledger subject balance is updated according to the certificate account COA, the initial borrower balance, the initial lender balance, the generated amount of the present borrower and the generated amount of the present lender in the to-be-charged certificate.
S530, before daily account batch processing, acquiring the daily general ledger vouchers and voucher accounts in the daily general ledger account balances respectively.
Illustratively, the fields of the current day ledger subject balance may include: the voucher account, the primary borrower balance, the primary lender balance, the present borrower occurrence and the present lender occurrence.
S540, inquiring the withdrawal list of the current day organization according to the organization section in the certificate account of the current day general ledger certificate.
S550, if the mechanism section corresponding to the day ledger voucher is matched with the revocation mechanism in the day mechanism revocation list, determining that the mechanism revocation exists on the day, and the mechanism revocation information is derived from the day ledger voucher.
S560, inquiring the withdrawal list of the current day organization according to the organization section in the voucher account of the current day general ledger account balance.
S570, if the mechanism section corresponding to the current day general ledger account balance is matched with the revocation mechanism in the current day mechanism revocation list, determining that the mechanism revocation exists on the current day, and the mechanism revocation information is derived from the current day general ledger account balance.
S580, generating a mechanism withdrawal accounting transfer certificate according to the set rule under the condition that the mechanism withdrawal exists, and generating a to-be-checked-in certificate according to the mechanism withdrawal accounting transfer certificate.
Illustratively, generating the institution withdrawal accounting transfer voucher according to the set rules may include: under the condition that the mechanism withdrawal information is derived from the day general ledger voucher, generating two mechanism withdrawal accounting transfer vouchers according to the day general ledger voucher and the first set rule; wherein, the first setting rule includes: the method comprises the steps that a voucher account of a general ledger voucher on the same day is kept unchanged, and a borrower amount and a lender amount are multiplied by-1 respectively to obtain a mechanism withdrawal accounting transfer voucher; and replacing the withdrawal mechanism in the certificate account of the general account certificate on the current day with the merging mechanism, and keeping the borrower amount and the lender amount unchanged to obtain a withdrawal accounting transfer certificate of another mechanism.
Illustratively, generating the institution withdrawal accounting transfer voucher according to the set rules may include: generating four mechanism withdrawal account transfer certificates according to the current general ledger account balance and a second set rule under the condition that the mechanism withdrawal information is derived from the current general ledger account balance; wherein the second setting rule includes: the voucher account in the general account subject balance of the current day is kept unchanged, the difference value between the primary borrower balance of the calculation period multiplied by-1 and the generated amount of the primary borrower is taken as the borrower amount, the lender amount is set as a set value, and the first institution withdrawal accounting transfer voucher is obtained; the voucher account in the general account balance of the current day is kept unchanged, the debit amount is set as a set value, the difference between the calculated primary credit balance multiplied by-1 and the generated amount of the present credit is used as a credit amount, and a second institution withdrawal accounting transfer voucher is obtained; replacing a withdrawal mechanism in the account balance of the general ledger on the current day with a merging mechanism, calculating the sum of the account balance at the beginning of the period and the account generated at the current period as the debit, and setting the credit as a set value to obtain a withdrawal accounting transfer certificate of a third mechanism; and replacing the withdrawal mechanism in the current day general account balance with an merging mechanism, setting the debit amount as a set value, calculating the sum of the initial credit balance and the current period credit occurrence amount as the credit amount, and obtaining a fourth mechanism withdrawal accounting transfer certificate.
Illustratively, the to-be-credited voucher is generated from the day ledger voucher without the withdrawal of the institution.
According to the embodiment of the invention, the day general ledger voucher is generated based on the accounting data before day-setting batch processing; updating the current day general ledger account balance according to the to-be-charged certificate, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger account balance and the current day mechanism withdrawal list; under the condition that the mechanism is withdrawn, the mechanism withdrawal accounting transfer certificates are generated according to different setting rules, each to-be-checked certificate is generated according to the mechanism withdrawal accounting transfer certificates, the daily check batch processing time is not required to be occupied, and the daily check batch processing steps of the general ledger can be reduced, so that the timeliness of the daily check of the general ledger is improved.
Fig. 6 is an application scenario diagram of another data processing method according to an embodiment of the present invention. As shown in fig. 6, the method includes:
s601, acquiring accounting data generated by a service component on the same day.
S602, generating a day general ledger voucher based on the accounting data.
S603, judging whether the mechanism is withdrawn on the current day according to the current day general ledger voucher, the current day general ledger subject balance and the current day mechanism withdrawal list, if so, executing S604, otherwise, executing S605.
S604, generating a mechanism withdrawal accounting transfer certificate according to a set rule, and generating a to-be-credited certificate according to the mechanism withdrawal accounting transfer certificate.
S605, generating a to-be-checked-in certificate according to the general ledger certificate of the current day.
S606, updating the account balance of the general ledger on the same day according to the to-be-checked-in vouchers at regular intervals.
According to the embodiment of the invention, whether the mechanism is withdrawn on the same day is judged according to the general ledger vouchers on the same day, the general ledger subject balances on the same day and the mechanism withdrawal list on the same day; under the condition that the mechanism withdrawal exists, generating a mechanism withdrawal accounting transfer certificate according to a set rule, generating a to-be-checked certificate according to the mechanism withdrawal accounting transfer certificate, and reducing the batch processing steps of the general ledger and the daily check without occupying the batch processing time of the daily check, thereby improving the timeliness of the general ledger and the daily check.
Fig. 7 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present invention. The device can execute the data processing method provided by the embodiment of the invention to improve the timeliness of the general ledger date knot. The apparatus is configured in an electronic device, e.g., a server or a server farm. As shown in fig. 7, the apparatus includes: a data acquisition module 701, a withdrawal and judgment module 702 and a credential generation module 703;
The data acquisition module 701 is configured to acquire accounting data generated by a service component on the same day before daily check batch processing, and generate a daily general ledger voucher based on the accounting data according to a general ledger voucher line format;
the withdrawal judging module 702 is configured to update the current day general ledger subject balance periodically according to the to-be-checked-in certificate, and judge whether there is a withdrawal of the mechanism on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list;
the credential generation module 703 is configured to generate an institution withdrawal accounting transfer credential according to a set rule when there is an institution withdrawal, and generate a to-be-credited credential according to the institution withdrawal accounting transfer credential.
The data processing device provided in the embodiment of the present invention is configured to implement a data processing method, and the implementation principle and technical effects of the data processing device are similar to those of the data processing method, and are not described herein again.
Further, the evacuation and judging module 702 includes:
the voucher account obtaining unit is used for respectively obtaining the day general ledger vouchers and the voucher accounts in the day general ledger account balances before day-to-day batch processing;
and the inquiring unit is used for inquiring the mechanism withdrawal list on the same day according to the certificate account and judging whether mechanism withdrawal exists on the same day according to an inquiring result.
Further, the query unit is specifically configured to:
inquiring the current day organization withdraw list according to the organization section in the certificate account of the current day general ledger certificate;
if the mechanism section corresponding to the current day general ledger voucher is matched with the revocation mechanism in the current day mechanism revocation list, determining that the mechanism revocation exists on the current day, and the mechanism revocation information is derived from the current day general ledger voucher;
inquiring the current day mechanism withdraw list according to the mechanism section in the voucher account of the current day general ledger account balance;
and if the mechanism section corresponding to the current day general ledger account balance is matched with the revocation mechanism in the current day mechanism revocation list, determining that mechanism revocation exists on the current day, and the mechanism revocation information is derived from the current day general ledger account balance.
Further, the query unit is specifically configured to:
generating two mechanism withdrawal account transfer certificates according to the current day general account certificate according to a first set rule under the condition that the mechanism withdrawal information is derived from the current day general account certificate;
wherein the first setting rule includes: the certificate account of the general ledger certificate on the same day is kept unchanged, and the debit amount and the credit amount are multiplied by-1 respectively to obtain a mechanism withdrawal accounting transfer certificate;
And replacing the revocation organization in the certificate account of the general ledger certificate on the same day with the merging organization, and keeping the borrower amount and the lender amount unchanged to obtain a certificate for withdrawing the account transfer by another organization.
Further, the query unit is specifically configured to:
generating four mechanism withdrawal account transfer certificates according to the current day general ledger account balance and a second set rule under the condition that the mechanism withdrawal information is derived from the current day general ledger account balance;
wherein the second setting rule includes: the voucher account in the general account subject balance of the current day is kept unchanged, the difference value between the primary borrower balance of the calculation period and the generated amount of the primary borrower after being multiplied by-1 is taken as the borrower amount, the lender amount is set as a set value, and a first institution withdrawal and accounting transfer voucher is obtained;
the voucher account in the current day general account subject balance is kept unchanged, the debit amount is set as a set value, the difference between the calculated primary credit balance multiplied by-1 and the generated amount of the primary credit is used as a credit amount, and a second institution withdrawal accounting transfer voucher is obtained;
replacing the withdrawal mechanism in the current day general account subject balance with an merging mechanism, calculating the sum of the initial period debit balance and the current period debit as debit amount, and setting the credit amount as a set value to obtain a third mechanism withdrawal accounting transfer certificate;
And replacing the withdrawal mechanism in the current day general account subject balance with an merging mechanism, setting the debit amount as a set value, calculating the sum of the initial credit balance and the current period credit occurrence amount as a credit amount, and obtaining a fourth mechanism withdrawal accounting transfer certificate.
Further, the data acquisition module 701 is specifically configured to:
acquiring accounting data generated on the same day and sent by each business component;
under the condition that the fields of the general ledger voucher row comprise a voucher account COA, a borrower amount and a lender amount, acquiring a set COA section, the borrower amount and the lender amount in the accounting data, and generating the general ledger voucher on the same day according to the set COA section, the borrower amount and the lender amount.
Further, the evacuation and determination module 702 is specifically configured to:
under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate;
and under the condition that the to-be-checked-in certificate exists, checking in the to-be-checked-in certificate, and updating the current general ledger account balance.
Further, the fields of the current day general ledger account balance include: the voucher account, the primary borrower balance, the primary lender balance, the present borrower occurrence and the present lender occurrence.
Further, the evacuation and determination module 702 is specifically configured to:
and updating the current day general account subject balance according to the voucher account COA, the initial borrower balance, the initial lender balance, the current borrower occurrence amount and the current lender occurrence amount in the to-be-charged voucher when the to-be-charged voucher is charged.
Further, the device further comprises:
and the to-be-checked-in certificate generation module is used for generating to-be-checked-in certificates according to the current day general account certificate under the condition that no institution withdrawal exists.
The data processing device provided by the embodiment of the invention can execute the steps executed by the server in the data processing method provided by the embodiment of the method of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
Fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 8, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as a data processing method.
In some embodiments, a data processing method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. One or more steps of a data processing method described above may be performed when a computer program is loaded into RAM 13 and executed by processor 11. Alternatively, in other embodiments, the processor 11 may be configured to perform a data processing method in any other suitable way (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
Optionally, an embodiment of the present invention further provides a computer program product comprising a computer program which, when executed by a processor, implements a data processing method as provided in any embodiment of the present application.
Computer program product in the implementation, the computer program code for carrying out operations of the present invention may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims (14)

1. A method of data processing, comprising:
before daily check batch processing, acquiring accounting data generated by a business component on the same day, and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher line format;
updating the current day general ledger subject balance according to the to-be-charged certificate at regular intervals, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list;
And under the condition that the mechanism withdrawal exists, generating a mechanism withdrawal accounting transfer certificate according to a set rule, and generating a to-be-checked-in certificate according to the mechanism withdrawal accounting transfer certificate.
2. The method of claim 1, wherein the determining whether there is an institution withdrawal on the day based on the day ledger voucher, the day ledger subject balance, and the day institution withdrawal list comprises:
before daily account batch processing, respectively acquiring the daily general ledger vouchers and voucher accounts in the daily general ledger account balances;
inquiring the mechanism withdrawal list of the current day according to the certificate account, and judging whether mechanism withdrawal exists on the current day according to the inquiring result.
3. The method of claim 2, wherein the querying the institution withdrawal list for the current day based on the credential account, and determining whether there is an institution withdrawal for the current day based on the query result, comprises:
inquiring the current day organization withdraw list according to the organization section in the certificate account of the current day general ledger certificate;
if the mechanism section corresponding to the current day general ledger voucher is matched with the revocation mechanism in the current day mechanism revocation list, determining that the mechanism revocation exists on the current day, and the mechanism revocation information is derived from the current day general ledger voucher;
Inquiring the current day mechanism withdraw list according to the mechanism section in the voucher account of the current day general ledger account balance;
and if the mechanism section corresponding to the current day general ledger account balance is matched with the revocation mechanism in the current day mechanism revocation list, determining that mechanism revocation exists on the current day, and the mechanism revocation information is derived from the current day general ledger account balance.
4. The method of claim 3, wherein generating the institution withdrawal accounting transfer voucher according to the set rules comprises:
generating two mechanism withdrawal account transfer certificates according to the current day general account certificate according to a first set rule under the condition that the mechanism withdrawal information is derived from the current day general account certificate;
wherein the first setting rule includes: the certificate account of the general ledger certificate on the same day is kept unchanged, and the debit amount and the credit amount are multiplied by-1 respectively to obtain a mechanism withdrawal accounting transfer certificate;
and replacing the revocation organization in the certificate account of the general ledger certificate on the same day with the merging organization, and keeping the borrower amount and the lender amount unchanged to obtain a certificate for withdrawing the account transfer by another organization.
5. The method of claim 3, wherein generating the institution withdrawal accounting transfer voucher according to the set rules comprises:
Generating four mechanism withdrawal account transfer certificates according to the current day general ledger account balance and a second set rule under the condition that the mechanism withdrawal information is derived from the current day general ledger account balance;
wherein the second setting rule includes: the voucher account in the general account subject balance of the current day is kept unchanged, the difference value between the primary borrower balance of the calculation period and the generated amount of the primary borrower after being multiplied by-1 is taken as the borrower amount, the lender amount is set as a set value, and a first institution withdrawal and accounting transfer voucher is obtained;
the voucher account in the current day general account subject balance is kept unchanged, the debit amount is set as a set value, the difference between the calculated primary credit balance multiplied by-1 and the generated amount of the primary credit is used as a credit amount, and a second institution withdrawal accounting transfer voucher is obtained;
replacing the withdrawal mechanism in the current day general account subject balance with an merging mechanism, calculating the sum of the initial period debit balance and the current period debit as debit amount, and setting the credit amount as a set value to obtain a third mechanism withdrawal accounting transfer certificate;
and replacing the withdrawal mechanism in the current day general account subject balance with an merging mechanism, setting the debit amount as a set value, calculating the sum of the initial credit balance and the current period credit occurrence amount as a credit amount, and obtaining a fourth mechanism withdrawal accounting transfer certificate.
6. The method of claim 1, wherein the obtaining accounting data generated by the business component on the current day, generating the current day ledger voucher based on the accounting data in a ledger voucher row format, comprises:
acquiring accounting data generated on the same day and sent by each business component;
under the condition that the fields of the general ledger voucher row comprise a voucher account COA, a borrower amount and a lender amount, acquiring a set COA section, the borrower amount and the lender amount in the accounting data, and generating the general ledger voucher on the same day according to the set COA section, the borrower amount and the lender amount.
7. The method of claim 1, wherein the periodically updating the current day ledger subject balance based on the to-be-credited voucher comprises:
under the condition of timing task triggering, monitoring whether a to-be-checked-in certificate exists or not, wherein the to-be-checked-in certificate comprises a general ledger certificate on the same day and/or a mechanism withdrawal and accounting transfer certificate;
and under the condition that the to-be-checked-in certificate exists, checking in the to-be-checked-in certificate, and updating the current general ledger account balance.
8. The method of claim 7, wherein the field for the current day general ledger subject balance comprises: the voucher account, the primary borrower balance, the primary lender balance, the present borrower occurrence and the present lender occurrence.
9. The method of claim 8, wherein the posting the to-be-posted credential to update a daily general ledger subject balance, comprising:
and updating the current day general account subject balance according to the voucher account COA, the initial borrower balance, the initial lender balance, the current borrower occurrence amount and the current lender occurrence amount in the to-be-charged voucher when the to-be-charged voucher is charged.
10. The method as recited in claim 1, further comprising:
and generating the to-be-checked-in certificate according to the current day general ledger certificate under the condition that no institution withdrawal exists.
11. A data processing apparatus, comprising:
the data acquisition module is used for acquiring accounting data generated by the business component on the same day before daily check batch processing and generating a daily general ledger voucher based on the accounting data according to a general ledger voucher line format;
the withdrawal judging module is used for periodically updating the current day general ledger subject balance according to the to-be-checked-in certificate, and judging whether the mechanism withdrawal exists on the current day according to the current day general ledger certificate, the current day general ledger subject balance and the current day mechanism withdrawal list;
and the certificate generation module is used for generating a mechanism withdrawal accounting transfer certificate according to a set rule under the condition that the mechanism withdrawal exists, and generating a to-be-checked certificate according to the mechanism withdrawal accounting transfer certificate.
12. An electronic device comprising a memory, a processor, a computer program on the memory and executable by the processor, wherein the processor implements the data processing method according to any of claims 1-10 when executing the computer program.
13. A computer-readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements a data processing method according to any one of claims 1-10.
14. A computer program product comprising a computer program, which, when executed by a processor, implements the data processing method according to any of claims 1-10.
CN202310093863.7A 2023-01-30 2023-01-30 Data processing method, device, electronic equipment, system, medium and program product Pending CN116342304A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310093863.7A CN116342304A (en) 2023-01-30 2023-01-30 Data processing method, device, electronic equipment, system, medium and program product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310093863.7A CN116342304A (en) 2023-01-30 2023-01-30 Data processing method, device, electronic equipment, system, medium and program product

Publications (1)

Publication Number Publication Date
CN116342304A true CN116342304A (en) 2023-06-27

Family

ID=86884768

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310093863.7A Pending CN116342304A (en) 2023-01-30 2023-01-30 Data processing method, device, electronic equipment, system, medium and program product

Country Status (1)

Country Link
CN (1) CN116342304A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117036074A (en) * 2023-10-09 2023-11-10 中国航空结算有限责任公司 Civil aviation settlement system, method, electronic equipment and storage medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117036074A (en) * 2023-10-09 2023-11-10 中国航空结算有限责任公司 Civil aviation settlement system, method, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
AU2017221777B2 (en) Generating integrated data records by correlating source data records from disparate data sources
US8768809B1 (en) Methods and systems for managing financial data
US8612318B1 (en) Payroll tax settlement services
US20160027126A1 (en) Managed bank account system for use in reconciliation services
CN111198873B (en) Data processing method and device
WO2019196257A1 (en) Automatic repayment method and system, and terminal device
US20200058025A1 (en) System, methods, and devices for payment recovery platform
US20130080298A1 (en) System and method for processing a financial account
CN115409590A (en) Unified account checking method, device, equipment and storage medium
CN102496126A (en) Custody asset transaction data monitoring equipment
CN116342304A (en) Data processing method, device, electronic equipment, system, medium and program product
WO2017132072A1 (en) Methods, systems and computer program products for calculating an estimated result of a tax return
CN110046980B (en) Financial data generation system and method
CN116167860A (en) Account checking processing method and device, electronic equipment and storage medium
CN115858489A (en) Transaction processing method and device based on data migration, computer equipment and medium
US10235719B2 (en) Centralized GAAP approach for multidimensional accounting to reduce data volume and data reconciliation processing costs
US20170148098A1 (en) Data creating, sourcing, and agregating real estate tool
KR102148152B1 (en) Processing method and apparatus for financial instrument information
Ma et al. Exchange rate factors, income levels, and investment abroad: An empirical study based on a sample of emerging economies
US20200302550A1 (en) Cost allocation estimation using direct cost vectors and machine learning
CN109447777B (en) Financial data processing method and device, electronic equipment and readable medium
CN111401850B (en) Financial architecture implementation method for mapping billing without account management
TWI811004B (en) System and method for automatically checking finance
CN113971007B (en) Information processing method, device, electronic equipment and medium
CN116450659A (en) Transaction information accounting method, device, equipment and medium based on distributed system

Legal Events

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