Method, apparatus, electronic device, and storage medium for data processing
By filtering and compensating for target items in business data, calculating the VAT compensation amount, and generating new business data, the problem of processing errors caused by the separation of price and tax in the financial system was solved, and the accuracy of data processing was improved.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-09-26
- Publication Date
- 2026-03-17
AI Technical Summary
In existing technologies, the uniform price-tax separation method in financial systems leads to errors in the price-tax separation processing of some business data, reducing the accuracy and efficiency of business data processing.
By receiving pending business data, obtaining the business type, filtering out the target accounts that need to be separated from prices and taxes, calculating the compensation amount, generating new business data, updating the pending data, and finally sending it to the financial system for unified separation of prices and taxes.
This improved the accuracy of business data processing and avoided processing errors caused by the unified price and tax separation method.
Smart Images

Figure CN115619576B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of big data analysis technology, and in particular to a data processing method, apparatus, electronic device, and storage medium. Background Technology
[0002] In the financial sector, to facilitate VAT management of business data, financial systems typically perform unified price-tax separation during business data processing. In existing technologies, since price-tax separation in financial systems is usually configured based on unified accounting subjects, it is also uniformly separated according to the configured accounting subjects during business data processing. However, for some specific business transactions, only a portion of the business data needs price-tax separation. Therefore, when processing this business data through the financial system, errors in price-tax separation processing can easily occur, reducing the accuracy and efficiency of business data processing. Summary of the Invention
[0003] In view of this, embodiments of the present invention provide a data processing method, apparatus, electronic device, and storage medium that can solve the problem that errors in the price and tax separation processing of business data that only require partial price and tax separation can easily occur, reducing the accuracy and efficiency of business data processing.
[0004] To achieve the above objectives, according to one aspect of the present invention, a data processing method is provided.
[0005] A data processing method according to an embodiment of the present invention includes: receiving business data to be processed and obtaining the corresponding business type;
[0006] In response to the business type being a preset type, the corresponding set of accounting entries is obtained from the business data to be processed, so as to filter the target account in the set of accounting entries. The target account represents the accounting account that needs to be separated from the price and tax.
[0007] Obtain the tax rate corresponding to the target item, and calculate the corresponding compensation amount based on the amount in the target item;
[0008] Obtain the attribute parameters of the target subject, generate new business data based on the attribute parameters and the compensation amount, and update the pending business data;
[0009] Send updated pending business data to the financial system.
[0010] In one embodiment, new business data is generated based on the attribute parameters and the compensation amount, including:
[0011] Obtain the accounting entry template for the target account, determine the field values of each field in the accounting entry template based on the attribute parameters and the compensation amount, add the field values to the accounting entry template, and generate new business data.
[0012] In yet another embodiment, determining the field values of each field in the accounting entry template based on the attribute parameters and the compensation amount includes:
[0013] The compensation amount is added and determined as the field value of the amount field in the accounting entry template;
[0014] Invoke preset rules to generate field values for the accounting subject field in the accounting entry template based on the target subject, and determine the field values for the debit / credit direction field in the accounting entry template by combining the debit / credit direction of the target subject;
[0015] The field values of the remaining fields in the accounting entry template are determined based on the attribute parameters.
[0016] In yet another embodiment, generating the field value of the accounting subject field in the accounting entry template based on the target subject includes:
[0017] Obtain the preset compensation mark text, combine the text of the target account with the compensation mark text, and generate the first field value of the accounting account field in the accounting entry template;
[0018] Query the preset general accounting subjects and determine the second field value of the accounting subject field in the accounting entry template.
[0019] In yet another embodiment, filtering the target accounts in the set of accounting entries includes:
[0020] Each accounting item in the set of accounting entries is matched with a preset price-tax separation account to filter out the successfully matched accounting items and determine them as target accounts.
[0021] In yet another embodiment, filtering the target accounts in the set of accounting entries includes:
[0022] Obtain the account identifiers of the accounting subjects included in the accounting entry set, and call the preset price-tax separation tag array to query the tag value corresponding to the account identifier;
[0023] Based on the subject identifier with the label value set to a preset value, the corresponding target subject is determined.
[0024] In yet another embodiment, obtaining the corresponding set of accounting entries from the business data to be processed includes:
[0025] Query the associated parameters corresponding to the preset type, and obtain the corresponding set of accounting entries from the business data to be processed based on the associated parameters.
[0026] To achieve the above objectives, according to another aspect of the present invention, a data processing apparatus is provided.
[0027] An embodiment of the present invention provides a data processing apparatus comprising: a receiving unit, configured to receive business data to be processed and obtain the corresponding business type;
[0028] A filtering unit is used to obtain the corresponding set of accounting entries from the business data to be processed in response to the business type being a preset type, so as to filter the target account in the set of accounting entries, wherein the target account represents the accounting account that needs to be separated from the price and tax.
[0029] A calculation unit is used to obtain the tax rate corresponding to the target item, and to calculate the corresponding compensation amount in combination with the amount of the target item;
[0030] A generation unit is used to obtain the attribute parameters of the target subject, generate new business data based on the attribute parameters and the compensation amount, and update the business data to be processed.
[0031] The sending unit is used to send updated pending business data to the financial system.
[0032] In one embodiment, the generating unit is specifically used for:
[0033] Obtain the accounting entry template for the target account, and add the attribute parameters and the compensation amount to the accounting entry template to generate new business data.
[0034] In yet another embodiment, the generating unit is specifically used for:
[0035] The compensation amount is added and determined as the field value of the amount field in the accounting entry template;
[0036] Invoke preset rules to generate field values for the accounting subject field in the accounting entry template based on the target subject, and determine the field values for the debit / credit direction field in the accounting entry template by combining the debit / credit direction of the target subject;
[0037] The field values of the remaining fields in the accounting entry template are determined based on the attribute parameters.
[0038] In yet another embodiment, the generating unit is specifically used for:
[0039] Obtain the preset compensation mark text, combine the text of the target account with the compensation mark text, and generate the first field value of the accounting account field in the accounting entry template;
[0040] Query the preset general accounting subjects and determine the second field value of the accounting subject field in the accounting entry template.
[0041] In yet another embodiment, the filtering unit is specifically used for:
[0042] Each accounting item in the set of accounting entries is matched with a preset price-tax separation account to filter out the successfully matched accounting items and determine them as target accounts.
[0043] In yet another embodiment, the filtering unit is specifically used for:
[0044] Obtain the account identifiers of the accounting subjects included in the accounting entry set, and call the preset price-tax separation tag array to query the tag value corresponding to the account identifier;
[0045] Based on the subject identifier with the label value set to a preset value, the corresponding target subject is determined.
[0046] In yet another embodiment, the filtering unit is specifically used for:
[0047] Query the associated parameters corresponding to the preset type, and obtain the corresponding set of accounting entries from the business data to be processed based on the associated parameters.
[0048] To achieve the above objectives, according to another aspect of the present invention, an electronic device is provided.
[0049] An electronic device according to an embodiment of the present invention includes: one or more processors; and a storage device for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors implement the data processing method provided in the embodiment of the present invention.
[0050] To achieve the above objectives, according to another aspect of the present invention, a computer-readable medium is provided.
[0051] An embodiment of the present invention provides a computer-readable medium having a computer program stored thereon, which, when executed by a processor, implements the data processing method provided in the embodiment of the present invention.
[0052] To achieve the above objectives, according to another aspect of the present invention, a computer program product is provided.
[0053] A computer program product according to an embodiment of the present invention includes a computer program that, when executed by a processor, implements the data processing method provided in the embodiment of the present invention.
[0054] One embodiment of the above invention has the following advantages or beneficial effects: In this embodiment, for pending business data that requires partial price-tax separation, the target accounting entries requiring price-tax separation can be screened out, and then value-added tax (VAT) compensation can be applied to these accounting entries to generate corresponding new business data, which is then updated to the pending business data. In this embodiment, after applying VAT compensation to the accounting entries in a specific business that require price-tax separation, the updated pending business data is sent to the financial system. This avoids errors in price-tax separation processing of business data due to the uniform price-tax separation processing method in the financial system, thus improving the accuracy of data processing.
[0055] The further effects of the aforementioned unconventional alternative methods will be explained below in conjunction with specific implementation methods. Attached Figure Description
[0056] The accompanying drawings are provided to better understand the invention and are not intended to unduly limit the scope of the invention. Wherein:
[0057] Figure 1 This is a schematic diagram of a system architecture for a data processing system according to an embodiment of the present invention;
[0058] Figure 2 This is a schematic diagram of a main flow of a data processing method according to an embodiment of the present invention;
[0059] Figure 3 This is a schematic diagram of another main flow of a data processing method according to an embodiment of the present invention;
[0060] Figure 4 This is a schematic diagram of another main flow of a data processing method according to an embodiment of the present invention;
[0061] Figure 5 This is a schematic diagram of the main units of a data processing apparatus according to an embodiment of the present invention;
[0062] Figure 6 This is yet another exemplary system architecture diagram to which embodiments of the present invention can be applied;
[0063] Figure 7 This is a schematic diagram of the structure of a computer system suitable for implementing embodiments of the present invention. Detailed Implementation
[0064] The following description, in conjunction with the accompanying drawings, illustrates exemplary embodiments of the present invention, including various details to aid understanding. These details should be considered merely exemplary. Therefore, those skilled in the art will recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of the invention. Similarly, for clarity and brevity, descriptions of well-known functions and structures are omitted in the following description.
[0065] It should be noted that, unless otherwise specified, the embodiments and features described in the present invention can be combined with each other. The acquisition, storage, use, and processing of data in the technical solutions of this application all comply with the relevant provisions of national laws and regulations.
[0066] This invention provides a data processing system that can be used in scenarios where price and tax are separated from business data, specifically in scenarios where only partial price and tax separation is required for business data processing.
[0067] This invention uses the processing of business data in the financial field as an example, such as processing transaction data from credit transactions in the financial sector. Price-tax separation refers to the practice of separately reflecting the price and turnover tax of goods and corresponding services on invoices during daily circulation. In financial business processing, price-tax separation refers to separating taxable income such as interest into price and tax.
[0068] Credit transactions are typically processed by a business processing system, which may include account opening, loan disbursement, repayment, automatic deductions, overdue non-accrual transfer, account write-off, account settlement, and accounting. After processing, the system generates corresponding business data, which may include accounting entries for each transaction. An accounting entry, based on the principles of double-entry bookkeeping, lists the corresponding accounts and amounts for each transaction. In this embodiment of the invention, price and tax separation can be performed based on the accounting entries in the business data.
[0069] In credit business processing scenarios, multiple business systems can be set up. Each system can divide its processing based on characteristics such as borrower type, industry attributes, or the bank's internal management department corresponding to the credit business. The processed business data from each system can be sent to the financial system for price-tax separation. To facilitate unified VAT management, the financial system typically uses a price-tax separation strategy configured uniformly based on accounting subjects, thus performing uniform price-tax separation processing on business data. This avoids issues with VAT processing in the business systems, making price-tax separation imperceptible to the business systems. However, in some business systems, the accounting subjects uniformly configured for price-tax separation in the financial system may not require price-tax separation. Therefore, if this business data is processed through the financial system for price-tax separation, it will not meet business requirements, leading to errors in the price-tax separation processing of the business data.
[0070] In this embodiment of the invention, value-added tax compensation is pre-processed for business data that requires partial price-tax separation. This is to compensate for errors that occur when the financial system processes the compensation business data for price-tax separation, so that the compensated business data will not have errors after being processed by the financial system for unified price-tax separation, thereby improving the accuracy of price-tax separation processing of business data.
[0071] It should be noted that, since only the business data processed by the business system needs to be compensated for price and tax separation, in this embodiment of the invention, the data processing system can be set between the business system and the financial system that need to be compensated for price and tax separation, so as to facilitate the data processing of the business data in this embodiment of the invention.
[0072] Specifically, the data processing system can be set up independently of the business system and the financial system, or it can be set up within the business system or the financial system. Taking a data processing system set up within a business system as an example... Figure 1 The diagram shown is a schematic representation of a system architecture for a data processing system according to an embodiment of the present invention. Figure 1 As shown, taking Business System 1 and Business System 2 as examples, the business systems are connected to the financial system.
[0073] The business system includes a business processing module and an accounting module. The business processing module processes each business transaction to generate corresponding transaction data. Specifically, it processes and records information on changes in funds, including principal, interest, and fees, whether actively initiated or passively initiated (e.g., interest accrual, non-accrual transfer). The accounting module calculates the transaction data generated by the business processing module to generate business data, i.e., the corresponding accounting entries. When there are business transactions in the business system that do not require price-tax separation, a value-added tax (VAT) compensation module can be set up—that is, the data processing system in this embodiment—to compensate VAT on business data that do not require price-tax separation according to rules, such as... Figure 1 As shown in Business System 1. When all transactions in the business system require price and tax separation, a VAT compensation module is not needed in the business system, such as... Figure 1 As shown in business system 2. This is how it is done. Figure 1 The system architecture shown can perform VAT compensation on business data that does not require price-tax separation, and then send it to the financial system for unified price-tax separation, thereby improving the accuracy of business data processing.
[0074] This invention provides a data processing method, which can be executed by a data processing system, such as... Figure 2 As shown, the method includes:
[0075] S201: Receive the business data to be processed and obtain the corresponding business type.
[0076] Among them, business data can be the data processed by the business system, specifically... Figure 1 The accounting entries processed by the accounting module in the business system shown are illustrated. In this embodiment of the invention, the business types requiring price-tax separation can be pre-configured, and then the business data requiring VAT compensation in the pending data can be determined based on the business type. Since the business system processes multiple businesses corresponding to a certain characteristic, the business type of each pending data can be obtained first in this step.
[0077] Specifically, the transaction records for each business process in the business system include the business type to which they belong. After generating accounting entries based on the transaction records, there are correlation parameters between the accounting entries and the business type. Thus, in this step, the business type of each accounting entry in the data to be processed can be determined based on the correlation parameters.
[0078] As shown in Table 1, this is a transaction record table generated by the business system for processing credit transactions. The transaction record table records the business type of each transaction and other parameters.
[0079] Table 1
[0080] Serial Number Loan Account Amount type Business type Direction of change Amount 1 A principal Repayment reduce 200 yuan 2 A Interest Repayment reduce 5 yuan 3 B principal Securitization Sale reduce 5000 yuan 4 B Interest Securitization Sale reduce 106 yuan
[0081] After performing accounting on the data in Table 1, the corresponding accounting entries can be obtained, as shown in Table 2.
[0082] Table 2
[0083] Serial Number Loan account Accounting Subjects Lending direction Amount 1 A Personal housing loans loan 100 yuan 2 A Personal housing loan interest income loan 53 yuan 3 A over-the-counter cash borrow 153 yuan 4 B Personal housing loans loan 5000 yuan 5 B Accrued personal housing loan interest loan 106 yuan 6 B Personal housing loan interest income borrow 106 yuan 7 B Securitization consideration borrow 5000 yuan
[0084] As shown in Tables 1 and 2, for each business type, a corresponding associated parameter can be set as the loan account number. In this way, for each accounting entry in Table 2, the corresponding business type can be queried based on the loan account number.
[0085] S202: In response to the business type being a preset type, retrieve the corresponding set of accounting entries from the pending business data to filter the target account in the set of accounting entries.
[0086] The target account refers to the accounting account that requires price and tax separation.
[0087] In this embodiment of the invention, the business types requiring VAT compensation are configured, i.e., preset types are defined. For example, the preset type could be "securitized sale" as shown in Table 1. Step S201 obtains the business type of the data to be processed and then matches it with the preset type. If the match is successful, it means that the business type it belongs to is the preset type, i.e., the type requiring VAT compensation; if the match is unsuccessful, it means that the business type it belongs to is not the preset type, i.e., the type not requiring VAT compensation.
[0088] When the business type of the data to be processed is a preset type, the data to be processed of that type can be filtered out, that is, the corresponding set of accounting entries can be obtained from the business data to be processed. At this time, the set of accounting entries contains the accounting entries in the data to be processed that correspond to the preset business type.
[0089] For example, taking the data to be processed as shown in Table 2, the business type corresponding to each accounting entry can be obtained from Table 1. Taking the preset type as "securitized sale" as an example, it can be determined that the accounting entry with loan account B is the business data that needs to be compensated for value-added tax. Therefore, the set of accounting entries consisting of accounting entries numbered 4 to 7 can be obtained from Table 2.
[0090] Each business type can correspond to multiple accounting entries, and not all of these accounting entries may require VAT compensation. Since price-tax separation is usually based on accounting subject configuration, in this embodiment of the invention, after obtaining the set of accounting entries, the accounting subjects that need to be separated into price-tax, i.e., the target subjects, are selected.
[0091] Specifically, in one aspect, in this embodiment of the invention, a price-tax separation account can be preset, that is, a price-tax separation account. Then, the price-tax account of each accounting entry in the accounting entry set in this step can be matched with the preset price-tax separation account. The accounting account that is successfully matched can be determined as the target account.
[0092] On the other hand, in this embodiment of the invention, a pre-defined price-tax separation label array can also be used. Each element in the price-tax separation label array corresponds one-to-one with the identifier of each accounting subject. Each element in the price-tax separation label array represents whether its corresponding accounting subject needs to undergo price-tax separation, and the value of the element represents the label value of its corresponding accounting subject, that is, whether the accounting subject needs to undergo price-tax separation. For example, an element value of 0 can be set to indicate that the corresponding accounting subject does not need to undergo price-tax separation; an element value of 1 can indicate that the corresponding accounting subject needs to undergo price-tax separation. Thus, in this step, after determining the set of accounting entries, the subject identifiers of the accounting subjects included in the set of accounting entries can be obtained, and then the pre-defined price-tax separation label array can be called to query the label value corresponding to the subject identifier in the price-tax separation label array. Therefore, based on the label value corresponding to the subject identifier, the subjects that need to undergo price-tax separation can be determined.
[0093] It should be noted that the accounting subjects for price-tax separation required in this embodiment of the invention are the accounting subjects for price-tax separation uniformly configured in the financial system, so as to maintain consistency with the configuration in the financial system.
[0094] S203: Obtain the tax rate corresponding to the target account, and calculate the corresponding compensation amount in combination with the amount in the target account.
[0095] Since different accounts may have different VAT rates, this embodiment of the invention can pre-configure the tax rates corresponding to each accounting account, and calculate the VAT compensation amount by aggregating the amounts of the accounting accounts. The formula for calculating the compensation amount can be: Compensation amount corresponding to the target account = Amount of the target account × Tax rate ÷ (1 + Tax rate).
[0096] Specifically, in this embodiment of the invention, a preset price-tax separation rule table can be used to preset whether each accounting item should be subject to price-tax separation, and the tax rate for accounting items subject to price-tax separation. For example, it can be as shown in Table 3.
[0097] Table 3
[0098] Accounting Subjects Is the price and tax separated? tax rate Personal housing loans no Personal housing loan interest income yes 6% Accrued personal housing loan interest no over-the-counter cash no Adjustment of personal housing loan interest income no
[0099] As shown in Table 3, the target is personal housing loan interest income, which is 106 yuan in Table 2. Therefore, the corresponding compensation amount can be calculated to be 6 yuan.
[0100] S204: Obtain the attribute parameters of the target subject, generate new business data based on the attribute parameters and compensation amount, and update the pending business data.
[0101] In this embodiment of the invention, after calculating the compensation amount, it needs to be recorded in the pending data according to the format of accounting entries so that the financial system can process it correctly. Since the accounting entries for VAT compensation correspond to the target account, some attribute parameters in the accounting entries are the same as those in the accounting entries of the target account. Therefore, in this step, new business data can be generated based on the attribute parameters and the compensation amount, and updated to the pending business data.
[0102] Specifically, in this embodiment of the invention, an accounting entry template can be set to generate new business data based on the accounting entry template. Since generating new business data requires updating the data to be processed so that the financial system can process it correctly, the fields of the accounting entry template must be the same as those of the corresponding accounting entry in the data to be processed. Taking the accounting entries in Table 2 as an example, the accounting entry template may include several parameters such as loan account number, accounting subject, debit / credit direction, and amount. Therefore, the step of generating new business data in this step can be specifically executed as follows: obtain the accounting entry template of the target subject, determine the field values of each field in the accounting entry template based on the attribute parameters and the compensation amount, add the field values to the accounting entry template, and generate new business data. Since the fields of the accounting entry template are the same as those of the corresponding accounting entry in the data to be processed, in this embodiment of the invention, the attribute parameters include the parameter values of each field in the accounting entry corresponding to the target subject. Some values of each field in the accounting entry template are the same as the attribute parameters of the target subject, while others are different. The different parts need to be calculated, such as the accounting subject, debit / credit direction, and amount.
[0103] Taking an accounting entry template that includes a loan account, accounting subject, debit / credit direction, and amount as an example, the amount refers to the compensation amount calculated in step S203. The debit / credit direction is determined by the debit / credit direction corresponding to the target account. The accounting subject can be generated according to preset rules and combined with the accounting entry of the target account, while the loan account is the same as the loan account of the target account. Therefore, the method for determining the field values of each field in the accounting entry template in this step can be executed as follows: add the compensation amount as the field value of the amount field in the accounting entry template; call the preset rules to generate the field value of the accounting subject field in the accounting entry template based on the target account, and combine the debit / credit direction of the target account to determine the field value of the debit / credit direction field in the accounting entry template; determine the field values of the remaining fields in the accounting entry template based on the attribute parameters.
[0104] For example, new business data may include two accounting entries: one reflecting the VAT on the target account, and the other reflecting VAT compensation. The accounting entries and debit / credit values differ between the two. In this step, a pre-defined general accounting entry can be used as the field value of the accounting subject in the accounting entry reflecting the VAT on the target account. Therefore, in this embodiment, the pre-defined general accounting entry can be queried and determined as the second field value of the accounting subject field in the accounting entry template. The general accounting subject can specifically be "VAT Payable". The field value of the accounting subject in the accounting entry reflecting VAT compensation can be generated based on the text of the target account and a pre-defined compensation marker text. The pre-defined compensation marker text can be "Adjustment," and the combination method can be concatenation. Therefore, in this step, the concatenation result of the text of the target account and the pre-defined compensation marker text can be determined as the field value of the accounting subject in the accounting entry reflecting VAT compensation. For example, if the target account is "Personal Housing Loan Interest Income," the compensation marker text can be "Adjustment," and the concatenation can be "Personal Housing Loan Interest Income Adjustment."
[0105] Taking the target item as "personal housing loan interest income" corresponding to loan account B in Table 2 as an example, the corresponding new business data can be obtained as shown in Table 4.
[0106] Table 4
[0107] Serial Number Loan account Accounting Subjects Lending direction Amount 1 B Adjustment of personal housing loan interest income borrow 6 yuan 2 B Value Added Tax Payable loan 6 yuan
[0108] After updating the new business data in Table 4 to Table 2, the updated pending business data is shown in Table 5.
[0109] Table 5
[0110] Serial Number Loan account Accounting Subjects Lending direction Amount 1 A Personal housing loans loan 100 yuan 2 A Personal housing loan interest income loan 53 yuan 3 A over-the-counter cash borrow 153 yuan 4 B Personal housing loans loan 5000 yuan 5 B Accrued personal housing loan interest loan 106 yuan 6 B Personal housing loan interest income borrow 106 yuan 7 B Securitization consideration borrow 5000 yuan 8 B Adjustment of personal housing loan interest income borrow 6 yuan 9 B Value Added Tax Payable loan 6 yuan
[0111] S205: Send updated pending business data to the financial system.
[0112] Once the updated pending business data is obtained, it can be sent to the financial system to perform price and tax separation. The financial system can process the updated pending business data based on the preset price and tax separation rules, which are shown in Table 3.
[0113] Taking the financial system's price-tax separation processing of the business data shown in Table 5 according to the price-tax separation rules shown in Table 3 as an example, the accounting entries for price-tax separation of the accounting item "Personal Housing Loan Interest Income" in Table 5 are shown in Table 6. By merging Table 5 and Table 6, the price-tax separation results obtained after processing the data in Table 2 based on the price-tax separation requirements of each business type can be obtained, as shown in Table 7.
[0114] Table 6
[0115] Serial Number Loan account Accounting Subjects Lending direction Amount 1 A Personal housing loan interest income borrow 3 yuan 2 A Value Added Tax Payable loan 3 yuan 3 B Personal housing loan interest income borrow 6 yuan 4 B Value Added Tax Payable borrow 6 yuan
[0116] Table 7
[0117] Serial Number Loan account Accounting Subjects Lending direction Amount 1 A Personal housing loans loan 100 yuan 2 A Personal housing loan interest income loan 53 yuan 3 A over-the-counter cash borrow 153 yuan 4 B Personal housing loans loan 5000 yuan 5 B Accrued personal housing loan interest loan 106 yuan 6 B Personal housing loan interest income borrow 106 yuan 7 B Securitization consideration borrow 5000 yuan 8 B Adjustment of personal housing loan interest income borrow 6 yuan 9 B Value Added Tax Payable loan 6 yuan 10 A Personal housing loan interest income borrow 3 yuan 11 A Value Added Tax Payable loan 3 yuan 12 B Personal housing loan interest income borrow 6 yuan 13 B Value Added Tax Payable borrow 6 yuan
[0118] As shown in Table 7, accounting entries 9 and 13 corresponding to Loan Account B are offset, so the VAT payable is 0, which is equivalent to no separation of price and tax.
[0119] In this embodiment of the invention, after VAT compensation is applied to the accounting entries that require price-tax separation in a specific business transaction, the updated pending business data is sent to the financial system. This prevents errors in the price-tax separation processing of business data due to the uniform price-tax separation processing method in the financial system, thereby improving the accuracy of data processing.
[0120] The following is combined with Figure 1 The system architecture shown and Figure 2 The illustrated embodiment provides a detailed description of the data processing method in this invention, such as... Figure 3 As shown, the method includes:
[0121] S301: Receive business data to be processed and obtain the corresponding business type.
[0122] S302: In response to the business type being a preset type, query the associated parameters corresponding to the preset type to obtain the corresponding set of accounting entries from the business data to be processed based on the associated parameters.
[0123] S303: Match each accounting item in the accounting entry set with the preset price-tax separation account to filter out the successfully matched accounting items and determine them as the target accounts.
[0124] S304: Obtain the tax rate corresponding to the target account, and calculate the corresponding compensation amount in combination with the amount in the target account.
[0125] S305: Obtain the attribute parameters and accounting entry templates for the target account.
[0126] S306: Determine the field values of each field in the accounting entry template based on the attribute parameters and the compensation amount, so as to add the field values to the accounting entry template and generate new business data.
[0127] S307: Update the pending business data with new business data and send the updated pending business data to the financial system.
[0128] It should be noted that the data processing principle in the embodiments of the present invention is the same as... Figure 2 The data processing principles in the illustrated embodiments are the same, and will not be repeated here.
[0129] The following is combined with Figure 1 The system architecture shown and Figure 2 The illustrated embodiment provides a detailed description of the data processing method in this invention, such as... Figure 4 As shown, the method includes:
[0130] S401: Receive business data to be processed and obtain the corresponding business type.
[0131] S402: In response to the business type being a preset type, query the associated parameters corresponding to the preset type to obtain the corresponding set of accounting entries from the business data to be processed based on the associated parameters.
[0132] S403: Obtain the account identifiers of the accounting subjects included in the accounting entry set, call the preset price and tax separation label array to query the label value corresponding to the account identifier; determine the corresponding target account based on the account identifier with the label value preset value.
[0133] S404: Obtain the tax rate corresponding to the target account, and calculate the corresponding compensation amount in combination with the amount in the target account.
[0134] S405: Obtain the attribute parameters and accounting entry templates for the target account.
[0135] S406: Add the compensation amount as the field value of the amount field in the accounting entry template.
[0136] S407: Call the preset rules to generate the field values of the accounting subject field in the accounting entry template based on the target subject, and determine the field values of the debit / credit direction field in the accounting entry template in combination with the debit / credit direction of the target subject; determine the field values of the remaining fields in the accounting entry template based on the attribute parameters.
[0137] S408: Add field values to the accounting entry template to generate new business data.
[0138] S409: Update the pending business data with new business data and send the updated pending business data to the financial system.
[0139] It should be noted that the data processing principle in the embodiments of the present invention is the same as... Figure 2 The data processing principles in the illustrated embodiments are the same, and will not be repeated here.
[0140] To address the problems existing in the prior art, embodiments of the present invention provide a data processing apparatus 500, such as... Figure 5 As shown, the device 500 includes:
[0141] The receiving unit 501 is used to receive business data to be processed and obtain the corresponding business type.
[0142] The filtering unit 502 is used to obtain the corresponding set of accounting entries from the business data to be processed in response to the business type being a preset type, so as to filter the target account in the set of accounting entries, wherein the target account represents the accounting account that needs to be separated from the price and tax.
[0143] The calculation unit 503 is used to obtain the tax rate corresponding to the target item, and calculate the corresponding compensation amount in combination with the amount of the target item;
[0144] The generation unit 504 is used to obtain the attribute parameters of the target subject, generate new business data based on the attribute parameters and the compensation amount, and update the business data to be processed.
[0145] The sending unit 505 is used to send updated pending business data to the financial system.
[0146] It should be understood that the manner in which embodiments of the present invention are implemented is different from the implementation method. Figure 2 The embodiments shown are the same and will not be described again here.
[0147] In one embodiment, the generating unit 504 is specifically used for:
[0148] Obtain the accounting entry template for the target account, and add the attribute parameters and the compensation amount to the accounting entry template to generate new business data.
[0149] In yet another embodiment, the generation unit 504 is specifically used for:
[0150] The compensation amount is added and determined as the field value of the amount field in the accounting entry template;
[0151] Invoke preset rules to generate field values for the accounting subject field in the accounting entry template based on the target subject, and determine the field values for the debit / credit direction field in the accounting entry template by combining the debit / credit direction of the target subject;
[0152] The field values of the remaining fields in the accounting entry template are determined based on the attribute parameters.
[0153] In yet another embodiment, the generation unit 504 is specifically used for:
[0154] Obtain the preset compensation mark text, combine the text of the target account with the compensation mark text, and generate the first field value of the accounting account field in the accounting entry template;
[0155] Query the preset general accounting subjects and determine the second field value of the accounting subject field in the accounting entry template.
[0156] In yet another embodiment, the filtering unit 502 is specifically used for:
[0157] Each accounting item in the set of accounting entries is matched with a preset price-tax separation account to filter out the successfully matched accounting items and determine them as target accounts.
[0158] In yet another embodiment, the filtering unit 502 is specifically used for:
[0159] Obtain the account identifiers of the accounting subjects included in the accounting entry set, and call the preset price-tax separation tag array to query the tag value corresponding to the account identifier;
[0160] Based on the subject identifier with the label value set to a preset value, the corresponding target subject is determined.
[0161] In yet another embodiment, the filtering unit 502 is specifically used for:
[0162] Query the associated parameters corresponding to the preset type, and obtain the corresponding set of accounting entries from the business data to be processed based on the associated parameters.
[0163] It should be understood that the manner in which embodiments of the present invention are implemented is different from the implementation method. Figure 2 , 3 The same method is used in the embodiments shown in 4, and will not be described again here.
[0164] In this embodiment of the invention, after VAT compensation is applied to the accounting entries that require price-tax separation in a specific business transaction, the updated pending business data is sent to the financial system. This prevents errors in the price-tax separation processing of business data due to the uniform price-tax separation processing method in the financial system, thereby improving the accuracy of data processing.
[0165] According to embodiments of the present invention, an electronic device and a readable storage medium are also provided.
[0166] An electronic device according to an embodiment of the present invention includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to cause the at least one processor to perform the data processing method provided in the embodiment of the present invention.
[0167] Figure 6 An exemplary system architecture 600 is shown, in which a data processing method or data processing apparatus to which embodiments of the present invention can be applied is illustrated.
[0168] like Figure 6As shown, system architecture 600 may include terminal devices 601, 602, and 603, a network 604, and a server 605. Network 604 serves as the medium for providing communication links between terminal devices 601, 602, and 603 and server 605. Network 604 may include various connection types, such as wired or wireless communication links or fiber optic cables, etc.
[0169] Users can use terminal devices 601, 602, and 603 to interact with server 605 via network 604 to receive or send messages, etc. Various client applications can be installed on terminal devices 601, 602, and 603.
[0170] Terminal devices 601, 602, and 603 may be, but are not limited to, smartphones, tablets, laptops, and desktop computers, etc.
[0171] Server 605 can be a server that provides various services. The server can analyze and process data such as received product information query requests, and feed back the processing results (such as product information - just an example) to the terminal device.
[0172] It should be noted that the data processing method provided in the embodiments of the present invention is generally executed by server 605, and correspondingly, the data processing device is generally disposed in server 605.
[0173] It should be understood that Figure 6 The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.
[0174] The following is for reference. Figure 7 It shows a schematic diagram of the structure of a computer system 700 suitable for implementing embodiments of the present invention. Figure 7 The computer system shown is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments of the present invention.
[0175] like Figure 7 As shown, the computer system 700 includes a central processing unit (CPU) 701, which can perform various appropriate actions and processes based on programs stored in read-only memory (ROM) 702 or programs loaded from storage section 708 into random access memory (RAM) 703. The RAM 703 also stores various programs and data required for the operation of the system 700. The CPU 701, ROM 702, and RAM 703 are interconnected via a bus 704. An input / output (I / O) interface 705 is also connected to the bus 704.
[0176] The following components are connected to the I / O interface 705: an input section 706 including a keyboard, mouse, etc.; an output section 707 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and speakers, etc.; a storage section 708 including a hard disk, etc.; and a communication section 709 including a network interface card such as a LAN card, modem, etc. The communication section 709 performs communication processing via a network such as the Internet. A drive 710 is also connected to the I / O interface 705 as needed. A removable medium 711, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on the drive 710 as needed so that computer programs read from it can be installed into the storage section 708 as needed.
[0177] In particular, according to the embodiments disclosed in this invention, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments disclosed in this invention include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication section 709, and / or installed from removable medium 711. When the computer program is executed by central processing unit (CPU) 701, it performs the functions defined above in the system of this invention.
[0178] It should be noted that the computer-readable medium shown in this invention can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In this invention, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media can also be any computer-readable medium other than computer-readable storage media, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.
[0179] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of the present invention. In this regard, each block in a flowchart or block diagram may represent a unit, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, may be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.
[0180] The units described in the embodiments of the present invention can be implemented in software or hardware. The described units can also be housed in a processor; for example, a processor can be described as including a receiving unit, a filtering unit, a calculation unit, and a generating and transmitting unit. The names of these units do not necessarily limit the specific unit; for example, a receiving unit can also be described as a "unit with data receiving function."
[0181] In another aspect, the present invention also provides a computer-readable medium, which may be included in the device described in the above embodiments; or it may exist independently and not assembled into the device. The computer-readable medium carries one or more programs that, when executed by the device, cause the device to perform the data processing method provided by the present invention.
[0182] In another aspect, the present invention also provides a computer program product, including a computer program that, when executed by a processor, implements the data processing method provided in the embodiments of the present invention.
[0183] The specific embodiments described above do not constitute a limitation on the scope of protection of this invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can occur depending on design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this invention.
Claims
1. A method of data processing, characterized by, The method comprises the following steps: receiving to-be-processed business data, and obtaining a corresponding business type; in response to the business type being a preset type, obtaining a corresponding set of accounting records from the to-be-processed business data, screening a target subject in the set of accounting records, the target subject representing an accounting subject that needs to perform price-tax separation, and the preset type representing a business type that needs to perform value-added tax compensation; obtaining a tax rate corresponding to the target subject, combining the amount of the target subject to calculate a corresponding compensation amount; obtaining an attribute parameter of the target subject, generating new business data based on the attribute parameter and the compensation amount, and updating the to-be-processed business data; sending the updated to-be-processed business data to a financial system, so that the financial system performs price-tax separation processing on the updated to-be-processed business data; generating new business data based on the attribute parameter and the compensation amount, comprising: obtaining an accounting record template of the target subject, determining the field values of each field in the accounting record template based on the attribute parameter and the compensation amount, adding the field values to the accounting record template to generate new business data.
2. The method of claim 1, wherein, determining the field values of each field in the accounting record template based on the attribute parameter and the compensation amount, comprising: adding the compensation amount to determine the field value of the amount field in the accounting record template; calling a preset rule to generate the field value of the accounting subject field in the accounting record template based on the target subject, and determining the field value of the debit-credit direction field in the accounting record template based on the debit-credit direction of the target subject; determining the field values of the remaining fields in the accounting record template based on the attribute parameter.
3. The method of claim 2, wherein, generating the field value of the accounting subject field in the accounting record template based on the target subject, comprising: obtaining a preset compensation marker text, combining the text of the target subject with the compensation marker text to generate a first field value of the accounting subject field in the accounting record template; querying a preset general accounting subject to determine a second field value of the accounting subject field in the accounting record template.
4. The method of claim 1, wherein, screening the target subject in the set of accounting records, comprising: matching each accounting subject in the set of accounting records with a preset price-tax separation subject to screen out the accounting subjects that match successfully and determine as the target subject.
5. The method of claim 1, wherein, screening the target subject in the set of accounting records, comprising: obtaining the subject identifier of the accounting subjects included in the set of accounting records, calling a preset price-tax separation label array to query the label value corresponding to the subject identifier; determining the corresponding target subject based on the subject identifier with the preset value.
6. The method of claim 1, wherein, obtaining the corresponding set of accounting records from the to-be-processed business data, comprising: querying the associated parameters corresponding to the preset type to obtain the corresponding set of accounting records from the to-be-processed business data based on the associated parameters.
7. An apparatus for data processing, characterized by The method comprises the following steps: receiving to-be-processed business data, and obtaining a corresponding business type; The screening unit is configured to, in response to the business type being a preset type, acquire a corresponding set of accounting records from the to-be-processed business data, to screen a target subject in the set of accounting records, the target subject representing an accounting subject that needs to perform VAT separation, and the preset type representing a business type that needs to perform VAT compensation. The calculation unit is configured to acquire a tax rate corresponding to the target subject, to calculate a corresponding compensation amount in combination with an amount of the target subject. The generation unit is configured to acquire an attribute parameter of the target subject, to generate new business data based on the attribute parameter and the compensation amount, and to update the new business data to the to-be-processed business data. The sending unit is configured to send the updated to-be-processed business data to a financial system, to enable the financial system to perform VAT separation processing on the updated to-be-processed business data. The generation unit is specifically configured to: acquire an accounting record template of the target subject, to add the attribute parameter and the compensation amount to the accounting record template, and to generate new business data.
8. The apparatus of claim 7, wherein, The generation unit is specifically configured to: add the compensation amount as a field value of an amount field in the accounting record template; invoke a preset rule, to generate a field value of an accounting subject field in the accounting record template based on the target subject, to determine a field value of a debit-credit direction field in the accounting record template in combination with a debit-credit direction of the target subject, and to determine a field value of a remaining field in the accounting record template based on the attribute parameter. The generation unit is specifically configured to:
9. The apparatus of claim 7, wherein, acquire a preset compensation marker text, to combine a text of the target subject and the compensation marker text, and to generate a first field value of the accounting subject field in the accounting record template; query a preset general accounting subject, to determine a second field value of the accounting subject field in the accounting record template. The screening unit is specifically configured to:
10. The apparatus of claim 7, wherein, match each accounting subject in the set of accounting records with a preset VAT separation subject, to screen out a matching successful accounting subject, and to determine the matching successful accounting subject as the target subject. The method comprises:
11. An electronic device, comprising: one or more processors; a storage device configured to store one or more programs, when the one or more programs are executed by the one or more processors, the one or more processors implement the method in any one of claims 1-6. The program is executed by the processor to implement the method in any one of claims 1-6.
12. A computer readable medium having stored thereon a computer program, characterized in that, The program is executed by the processor to implement the method in any one of claims 1-6.
13. A computer program product comprising a computer program, characterized in that,
Citation Information
Patent Citations
Method, apparatus and device for obtaining expense sum tax rate and storage medium
CN108022163A
Price-tax separation method, device and system
CN109034920A