Accounting data processing method, system and device and storage medium

Abstract

The invention provides an accounting data processing method, system and device and a storage medium, and relates to the technical field of computer application. The accounting data processing method comprises the following steps: acquiring transaction initial data; analyzing the transaction initial data and generating standard data of a preset structure; determining an accounting scene matched with the standard data according to a preset rule and an accounting XML file; analyzing an effective condition of an accounting action associated with the accounting scene and acquiring an accounting action to be executed; calculating an accounting amount according to the amount calculation rule of the to-be-executed accounting action; and generating an accounting entry according to the standard data, the accounting amount and the accounting entry XML, and storing the accounting entry. By adopting the method and the device, the processing efficiency of the accounting data can be improved, errors possibly occurring in the manual maintenance and management process are reduced, and the processing stability of the accounting data is improved.

Description

Technical Field

[0001] The present invention relates to the field of computer application technology, and more specifically, to an accounting data processing method, system, device and storage medium. Background Art

[0002] With the rapid development of Internet technology, Internet loan business has become a major service mode in the financial field. The account management system of Internet loans plays a vital role in the entire loan business. It is the core of loan transactions and bears the responsibility of ensuring the continuous and stable operation of the loan business. It not only tracks and records the account data generated by each transaction of the borrower, but also ensures the accuracy of various account balances. However, with the growth of business volume and the continuous changes in business methods, traditional loan account processing methods have been unable to meet existing needs, and the problems exposed have become increasingly prominent. At present, the conventional Internet loan account system has the following problems:

[0003] 1. Inefficiency and prone to errors. Loan accounting is usually handled manually or semi-automatically, which often requires a lot of manual maintenance and management. For example, the addition of accounting subjects, the setting of accounting entries, and the maintenance of various accounting reports are complex, inefficient, and prone to errors.

[0004] 2. Lack of flexibility. Since conventional loan account processing methods usually rely on fixed processing rules, they often cannot be effectively expanded for the emerging diversified and rapidly changing Internet loan business, and lack sufficient flexibility and response capabilities, which will lead to bottlenecks in system processing capabilities and waste of resources caused by frequent changes and online launches.

[0005] 3. Performance bottlenecks. Conventional Internet loan accounting systems often use a single database as the data storage and processing center, which has low processing efficiency, especially when facing large-scale concurrent processing and massive data queries, which can easily cause data bottlenecks and performance bottlenecks. At the same time, when a traditional single database fails, since all data is stored in the same database, there are security risks, which may cause the interruption of the entire business process and affect the normal operation of the service. Summary of the invention

[0006] In order to solve the problems existing in the above-mentioned prior art or at least part of the problems, the embodiments of the present invention provide an accounting data processing method, system, device, storage medium and computer program product, which determine the accounting scenario according to preset rules and accounting XML files, and then complete the accounting according to the to-be-executed accounting actions and amount calculation rules associated with the accounting scenario. This can improve the processing efficiency of accounting data, while reducing the errors that may occur during manual maintenance and management, and improve the stability of accounting data processing.

[0007] According to the first aspect of the present invention, an embodiment of the present invention provides an accounting data processing method, which includes: obtaining transaction initial data; parsing the transaction initial data and generating standard data of a preset structure; determining an accounting scenario that matches the standard data according to preset rules and an accounting XML file; parsing the effectiveness conditions of the accounting action associated with the accounting scenario and obtaining the accounting action to be executed; calculating the accounting amount according to the amount calculation rule of the accounting action to be executed; generating accounting entries according to the standard data, the accounting amount and the accounting entry XML and storing the accounting entries.

[0008] According to the above-mentioned implementation mode of the present invention, the accounting scenario is determined according to the preset rules and the accounting XML file, and then the accounting is completed according to the to-be-executed accounting actions and amount calculation rules associated with the accounting scenario, so that business personnel can support various complex business accounting needs through concise and clear preset rules and accounting XML file configurations, which greatly improves the processing efficiency of accounting data, and also effectively reduces the errors that may occur during manual maintenance and management, and improves the stability of accounting data processing.

[0009] In some implementations of the present invention, the accounting XML file includes: accounting scenario XML, accounting action XML, accounting subject XML, accounting entry XML, and account set XML.

[0010] According to the above implementation of the present invention, by introducing accounting scenario XML and accounting action group XML, accounting actions can be freely assembled, so that the accounting process can be automatically executed, greatly improving data processing efficiency and reducing human errors. At the same time, according to different business needs, flexible configuration is performed through account set XML and accounting entry XML, realizing more convenient accounting scenario application and meeting the diverse needs of Internet loan business.

[0011] In some embodiments of the present invention, a graphical user interface is used to create, modify and delete accounting actions and accounting scenarios and generate corresponding accounting XML files.

[0012] According to the above-mentioned embodiment of the present invention, an accounting XML file including an accounting scenario XML and an accounting action XML is generated through a graphical user interface, which enables free assembly of accounting actions, enables the accounting process to be executed automatically, greatly improves data processing efficiency, and reduces human errors.

[0013] In some embodiments of the present invention, the transaction initial data is obtained through an API interface, wherein the transaction initial data is stored in the following manner: a database to be stored is determined according to business attributes, and the transaction initial data is stored in a corresponding data table in the database according to the transaction attributes.

[0014] According to the above implementation of the present invention, by storing data in separate libraries and tables, optimized processing under high concurrency and large data volumes is achieved, solving the performance bottleneck problem that occurs in traditional loan account management systems when processing large amounts of data.

[0015] In some embodiments of the present invention, parsing the effectiveness conditions of the accounting actions associated with the accounting scenario and obtaining the accounting actions to be executed includes: using the JEXL expression engine to parse the effectiveness conditions of each accounting action associated with the accounting scenario, and taking the accounting actions that meet the current transaction characteristics as the accounting actions to be executed.

[0016] According to the above-mentioned implementation mode of the present invention, the JEXL expression language engine is used to implement complex data processing logic in the accounting transaction file in XML format, which can not only perform arithmetic operations, logical judgments and loop control operations, but also flexibly customize and adjust the processing rules according to actual needs, thereby ensuring the accuracy and efficiency of the accounting data processing process.

[0017] In some embodiments of the present invention, the accounting data processing method further includes: before saving the accounting entry, automatically mapping the internal account to the accounting account number in the financial system according to the accounting account XML configuration.

[0018] According to the above-mentioned embodiment of the present invention, by automatically mapping the internal accounts to the accounting account numbers in the financial system, the consistency and accuracy of the account numbers are ensured. Furthermore, after the mapping is completed, the accounting entries are saved, which facilitates the subsequent accounting processing and data aggregation, thereby realizing the automation and standardization of accounting information management.

[0019] According to the second aspect of the present invention, an embodiment of the present invention provides an accounting data processing system, which includes: an initial data acquisition module, used to acquire initial transaction data; a data standardization module, used to parse the initial transaction data and generate standard data of a preset structure; an accounting module, used to perform the following operations: determine the accounting scenario that matches the standard data according to preset rules and an accounting XML file; parse the effectiveness conditions of the accounting action associated with the accounting scenario and obtain the accounting action to be executed; calculate the accounting amount according to the amount calculation rule of the accounting action to be executed; generate accounting entries according to the standard data, the accounting amount and the accounting entry XML and store the accounting entries.

[0020] According to the above-mentioned implementation mode of the present invention, the accounting scenario is determined according to the preset rules and the accounting XML file, and then the accounting is completed according to the to-be-executed accounting actions and amount calculation rules associated with the accounting scenario, so that business personnel can support various complex business accounting needs through concise and clear preset rules and accounting XML file configurations, which greatly improves the processing efficiency of accounting data, and also effectively reduces the errors that may occur during manual maintenance and management, and improves the stability of accounting data processing.

[0021] In some implementations of the present invention, the accounting XML file includes: accounting scenario XML, accounting action XML, accounting subject XML, accounting entry XML, and account set XML.

[0022] According to the above implementation of the present invention, by introducing accounting scenario XML and accounting action group XML, accounting actions can be freely assembled, so that the accounting process can be automatically executed, greatly improving data processing efficiency and reducing human errors. At the same time, according to different business needs, flexible configuration is performed through account set XML and accounting entry XML, realizing more convenient accounting scenario application and meeting the diverse needs of Internet loan business.

[0023] In some embodiments of the present invention, a graphical user interface is used to create, modify and delete accounting actions and accounting scenarios and generate corresponding accounting XML files.

[0024] According to the above-mentioned embodiment of the present invention, an accounting XML file including an accounting scenario XML and an accounting action XML is generated through a graphical user interface, which enables free assembly of accounting actions, enables the accounting process to be executed automatically, greatly improves data processing efficiency, and reduces human errors.

[0025] In some embodiments of the present invention, the transaction initial data is obtained through an API interface, wherein the transaction initial data is stored in the following manner: a database to be stored is determined according to business attributes, and the transaction initial data is stored in a corresponding data table in the database according to the transaction attributes.

[0026] According to the above implementation of the present invention, by storing data in separate libraries and tables, optimized processing under high concurrency and large data volumes is achieved, solving the performance bottleneck problem that occurs in traditional loan account management systems when processing large amounts of data.

[0027] In some embodiments of the present invention, parsing the effectiveness conditions of the accounting actions associated with the accounting scenario and obtaining the accounting actions to be executed includes: using the JEXL expression engine to parse the effectiveness conditions of each accounting action associated with the accounting scenario, and taking the accounting actions that meet the current transaction characteristics as the accounting actions to be executed.

[0028] According to the above-mentioned implementation mode of the present invention, the JEXL expression language engine is used to implement complex data processing logic in the accounting transaction file in XML format, which can not only perform arithmetic operations, logical judgments and loop control operations, but also flexibly customize and adjust the processing rules according to actual needs, thereby ensuring the accuracy and efficiency of the accounting data processing process.

[0029] In some embodiments of the present invention, the accounting module is further used to perform the following operations: before saving the accounting entry, automatically mapping the internal account to the accounting account number in the financial system according to the accounting account XML configuration.

[0030] According to the above-mentioned embodiment of the present invention, by automatically mapping the internal accounts to the accounting account numbers in the financial system, the consistency and accuracy of the account numbers are ensured. Furthermore, after the mapping is completed, the accounting entries are saved, which facilitates the subsequent accounting processing and data aggregation, thereby realizing the automation and standardization of accounting information management.

[0031] According to the third aspect of the present invention, an embodiment of the present invention provides a computer-readable storage medium having computer-readable instructions stored thereon. When the computer-readable instructions are executed by a processor, the computer performs the following operations: the operations include the steps included in the accounting data processing method described in any one of the above embodiments.

[0032] According to the fourth aspect of the present invention, an embodiment of the present invention provides a computer device including a memory and a processor, wherein the memory is used to store one or more computer-readable instructions, wherein the one or more computer-readable instructions, when executed by the processor, can implement the accounting data processing method described in any one of the above embodiments.

[0033] According to a fifth aspect of the present invention, an embodiment of the present invention provides a computer program product including a computer program, and when the computer program is executed by a processor, the accounting data processing method described in any one of the above embodiments is implemented.

[0034] From the above, it can be seen that the accounting data processing method, system, device, storage medium and computer program product provided in the embodiments of the present invention determine the accounting scenario according to preset rules and accounting XML files, and then complete the accounting according to the to-be-executed accounting actions and amount calculation rules associated with the accounting scenario, so that business personnel can support various complex business accounting needs through concise and clear preset rules and accounting XML file configurations, greatly improving the processing efficiency of accounting data, while also effectively reducing the errors that may occur during manual maintenance and management, and improving the stability of accounting data processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 is a flow chart of the accounting data processing method according to Embodiment 1 of the present invention;

[0036] Figure 2 Schematic diagram of the architecture of the accounting data processing system according to Embodiment 3 of the present invention. DETAILED DESCRIPTION

[0037] The various aspects of the present invention are described in detail below in conjunction with the accompanying drawings and specific embodiments. Among them, well-known modules, units and their connections, links, communications or operations are not shown or described in detail. In addition, the described features, architectures or functions can be combined in any way in one or more embodiments. It should be understood by those skilled in the art that the various embodiments described below are only used for illustration and are not intended to limit the scope of protection of the present invention. It can also be easily understood that the modules or units or processing methods in each embodiment described herein and shown in the accompanying drawings can be combined and designed in various different configurations.

[0038] The following is a brief description of the terms used in this article.

[0039] XML: Extensible Markup Language, a markup language used to tag electronic documents to give them a structure.

[0040] API: Application Programming Interface, application programming interface.

[0041] JEXL: Java Expression Language, an expression language used primarily for dynamic expression evaluation in Java applications.

[0042] Accounting Action XML: A specific XML file used to standardize the definition of different accounting actions in a transaction.

[0043] Accounting action: a specific operation defined and described in an accounting action XML file.

[0044] [Example 1]

[0045] Figure 1 It is a flowchart of the accounting data processing method according to the first embodiment of the present invention.

[0046] like Figure 1 As shown, in Embodiment 1 of the present invention, the accounting data processing method may include: step S11, step S12, step S13, step S14, step S15 and step S16, and the above steps are described in detail below.

[0047] In step S11, the initial transaction data is obtained. The initial transaction data includes, but is not limited to, one or more of the following: transaction type, amount, transaction time, loan number, and overdue status information. The information in the initial transaction data is encoded and transmitted in a standardized XML or JSON format.

[0048] In some embodiments, the initial transaction data is obtained through an API interface, wherein the initial transaction data is stored in the following manner: a database to be stored is determined according to business attributes, and the initial transaction data is stored in a corresponding data table in the database according to the transaction attributes. Optionally, sharding database sharding technology is used to divide the data into libraries and save them to MySQL database tables. By dividing the data into libraries and tables, large-scale data is divided into multiple databases and tables, thereby improving the ability of parallel processing and the efficiency of data processing.

[0049] In an exemplary embodiment, a database and table sharding strategy centered on business needs is adopted. The business-centric database and table sharding can ensure that the segmentation and organization of the database are directly mapped to the actual business processes and product characteristics (such as loan types and customer categories), thereby achieving seamless integration of data management and business operations.

[0050] In a further embodiment, the accounting system supports the dynamic addition or adjustment of databases and tables to quickly respond to business growth and market changes. As a result, the system can be easily expanded according to new business needs without large-scale reconstruction, improving the fault tolerance and stability of the system. Moreover, even if some databases or tables fail, the system can ensure business continuity and data integrity through an automatic failover mechanism.

[0051] Optionally, the initial transaction data is loan account data, and the loan account data is subjected to a database sharding operation according to different products or business models. By decomposing the data, the data of different products or business models are stored in different databases, thereby reducing the load pressure of a single database and improving the efficiency of data access. Further, in each database, each business table is subjected to a table sharding process. Specifically, according to different business requirements, the business table is divided according to certain rules to form a plurality of small data tables. The use of the table sharding technology reduces the amount of data in each table, and improves the efficiency of query and operation. Furthermore, data routing and load balancing technology are used to evenly distribute user requests and data access to each sub-library and sub-table, thereby avoiding the overload of a single database or data table, and improving the processing capacity and response speed of the entire system. Therefore, the present invention can effectively solve the performance bottleneck problem existing in the loan account management system in the prior art. Specifically, the data is dispersedly stored through sub-libraries and sub-tables, avoiding the load pressure of a single database, and improving the concurrent processing capacity and response speed of the system. At the same time, data routing and load balancing technologies are used to balance the load of each sub-database and sub-table to ensure that the system can still run stably under high load conditions.

[0052] The present invention provides an example of a data storage method, which is applied to the storage of initial data, bookkeeping actions and accounting entry data, and specifically includes: mapping key business entities such as financial products, customers and transactions to the database architecture, and assigning a clear database and table structure to each business logic unit. For example, by deeply analyzing the characteristics of financial products, independent databases are configured for different business units, such as financial products or personal loans, so as to isolate and manage the data traffic of different businesses. Furthermore, according to characteristics such as product type, loan term or application channel, the database is subdivided to optimize the data processing of specific products. For example, using the financial product number as a sub-library key, the system automatically identifies and routes business requests to the corresponding product database. In addition, other business attributes can be flexibly selected as sub-library keys according to business needs to support diversified data management strategies.

[0053] For example, there are two databases in the system, and each database has multiple tables for storing loan data. One database stores product A loan data, and the other database stores product B loan data. More specifically, in each database, each table represents a specific account type and different deposit data, thereby achieving separate databases and tables, thereby improving the efficiency of loan business query and processing.

[0054] In an optional implementation, the number of account tables is set at the account table level according to the business volume forecast or loan business characteristics, and a sub-table key is defined, such as a loan number or an accounting institution number. Then, by calculating the hash value of the sub-table key and performing a modulo operation, the transaction data is accurately allocated to the corresponding account table, ensuring the efficiency and accuracy of data processing.

[0055] In step S12, the transaction initial data is parsed and standard data of a preset structure is generated. In some implementations, the transaction initial data is verified for integrity and correctness.

[0056] In step S13, the accounting scenario matching the standard data is determined according to the preset rules and the accounting XML file. The accounting XML file includes: accounting scenario XML, accounting action XML, accounting subject XML, accounting entry XML, and account set XML. The accounting scenario is associated with a group of accounting actions, and the accounting action has an effective condition and an amount calculation rule.

[0057] In this embodiment, the preset rules include determining the matching accounting scenarios according to the transaction type or accounting scenario code field in the standard data sent by the business system. For example, if the transaction type field is sent, the accounting system will filter one or more matching accounting scenarios in the accounting scenario XML (the business personnel pre-configure the mapping relationship between transaction type and accounting scenario in the accounting scenario XML) according to the transaction type, or if the business system directly specifies the accounting scenario code, the accounting system will directly match this accounting scenario.

[0058] In some embodiments, a graphical user interface is used to create, modify and delete accounting actions and accounting scenarios and generate corresponding accounting XML files. Through the graphical user interface, business personnel can create, modify and delete accounting actions and accounting scenarios without programming knowledge. At the same time, by introducing accounting scenario XML and accounting action group XML, accounting actions can be freely assembled (for example, action codes, names and groups can be freely set), so that the accounting process can be automatically executed, greatly improving processing efficiency and reducing human errors; at the same time, according to different business needs, a graphical user interface is used to create, modify and delete accounting sets and accounting entries and generate corresponding accounting XML files. Account set XML and accounting entry XML can be flexibly configured, realizing more convenient accounting scenario applications and meeting the diverse needs of Internet loan business.

[0059] Among them, business personnel can modify the accounting action configuration at any time in the graphical interface. After the modification is completed, the accounting system will generate a new accounting action group XML and load it into the cache, and overwrite the old XML. After that, after receiving the accounting request from the business system, the accounting system will read the new accounting action group XML in the cache for processing. Therefore, after the accounting action is freely assembled, the accounting system caches the new accounting action group XML in real time. After that, when the accounting system performs accounting processing, it will synchronously read the accounting action group XML in this cache, so that the accounting process can be executed automatically without the need for manual frequent synchronization and online of the modified XML in the accounting system.

[0060] In an exemplary embodiment, the graphical user interface is divided into multiple functional modules, such as accounting action definition, accounting scenario configuration, etc. The operation of the business personnel generating the accounting XML file through the graphical user interface includes: first, the business personnel specifies a unique action code and name for each accounting action to configure the accounting action, and organizes the configured accounting actions into logical groups to achieve effective management and quick call. Secondly, the business personnel set specific effective conditions for each accounting action and configure the amount calculation rules. Then, the business personnel create personalized accounting scenarios based on actual business needs, and define the key business fields required for each scenario, such as loan overdue days, account status and related business amounts, etc., and further customize the accounting actions and their execution order for each business scenario, so as to achieve a highly customized accounting process. Finally, the accounting system automatically generates an XML file containing all configuration information according to the user operation. Among them, the system has a built-in script editor that supports multiple scripting languages, so that business personnel can write, test and optimize the aforementioned conditions and rules. In addition, the accounting system has a version control unit for tracking changes and rolling back to previous configurations.

[0061] In this embodiment, the diverse transaction scenarios and events are mapped into structured accounting scenario XML and accounting action XML, and the key elements in accounting practice, accounting subjects and accounting entries, are encapsulated into account set XML and accounting entry XML respectively. By constructing accounting XML files, not only the organization and operability of data are improved, but also the adaptability and scalability of the system are greatly enhanced. Specifically, when business needs change or new transaction types appear, new business scenarios can be quickly adapted by adding or modifying relevant configurations in XML files without making complex changes to existing system codes. Secondly, the modular nature of XML files allows the system to update or expand the configuration of a specific function separately without affecting other parts, such as adding new accounting rules or accounting subjects, thereby improving the flexibility of the system. In addition, the standardized XML format facilitates data exchange and integration with other systems, allowing the system to easily interact with external applications or services, enhancing its usability and integration capabilities in different business environments. Finally, the self-describing nature of XML files makes data easy to understand and maintain, and new users or systems can quickly understand existing configurations and expand on this basis, further promoting the long-term development and technical iteration of the system.

[0062] Among them, an account set refers to a group of interrelated accounting subjects. An account set usually represents an independent accounting entity, such as the accounting subject information of a company or a department, with the purpose of managing the accounting data of different entities separately. The encapsulated account set XML is used to classify and manage the accounting subject numbers of different accounting entities. In subsequent accounting, the accounting entity to which the current accounting belongs is obtained from the account set XML according to the account set code configured in the accounting entry XML, so as to obtain the accounting subject number mapped by the system internal subject according to the current accounting entity in the accounting subject XML according to the accounting entity number and the system internal subject number.

[0063] In this embodiment, the accounting system uses an XML parser to achieve data mapping and structuring. Specifically, when the business personnel complete the configuration of accounting scenarios, accounting actions, account sets, accounting subjects and accounting entries through the graphical user interface and save them, the accounting system triggers the XML parser. The XML parser corresponds the data items entered in the interface to the tags and attributes of the XML file one by one according to the predefined templates and rules. For example, for accounting scenario XML, the parser will map information such as transaction code value, scenario code value, scenario name, etc. to the corresponding XML elements; for accounting action XML, the parser will fill in details such as action code, debit and credit direction, amount calculation logic, etc. into the file; the generation of account set XML, accounting subject XML and accounting entry XML also follows a similar process to ensure that the code, name, type of each accounting subject and the number and amount of each entry are accurately recorded in the corresponding XML file. Therefore, through the XML parser, the accounting system can convert the interface operation into a structured, machine-readable XML file, thereby providing a basis for subsequent data processing and automated accounting.

[0064] Furthermore, the JEXL expression language engine is used to implement complex data processing logic in the accounting transaction file in XML format, which can not only perform operations such as arithmetic operations, logical judgments and loop control, but also flexibly customize and adjust processing rules according to actual needs, thereby ensuring the accuracy and efficiency of the processing process. In addition, the present invention directly and seamlessly embeds the JEXL expression language engine as a plug-in into the existing XML accounting transaction data processing application. This integration method allows developers to use the powerful functions of the JEXL engine to execute complex data processing logic without changing the original system architecture. Specifically, developers can simply call the API interface of the JEXL engine in the application, pass the defined data processing rules to the engine in the form of JEXL expressions, and the engine is responsible for executing these expressions and returning the results. This integration method not only reduces the modification of the original code and avoids complex system reconstruction, but also simplifies the development and deployment process through the automated data processing process, significantly improves the automation level of data processing, reduces manual operations, and reduces errors and costs caused by human factors. At the same time, the high flexibility and customization of the JEXL engine enable the system to easily adapt to changes in future business needs and enhance the maintainability and scalability of the system.

[0065] Among them, existing XML accounting transaction data processing applications generally follow standard data processing procedures, for example: 1. Extract basic information from the transaction data sent to the business system, such as transaction date, amount and account information; 2. Perform data verification to ensure the integrity and accuracy of all transaction information; 3. Through the built-in XML parser, relying on preset and relatively fixed data processing rules, classify, summarize and convert data to finally generate accounting entries.

[0066] The present invention provides an example of a configuration method for an accounting XML file, and realizes refined accounting management by pre-configuring a series of accounting XML files in a business system, specifically including: defining accounting events in transactions in a standardized manner through accounting action XML, and clarifying key information such as action code, name and group; mapping accounting account numbers within the system and the financial system through accounting subject XML, ensuring dynamic maintenance and extensibility of account numbers; specifying the accounting entries corresponding to each accounting action in detail through accounting entry XML, covering elements such as action code, accounting subject, amount calculation logic, account set code and red and blue character identification, providing a detailed description for accounting actions; integrating multiple accounting actions into specific accounting scenarios through accounting scenario XML, including action codes, effective conditions and amount calculation rules, to meet complex business needs, thereby integrating multiple operation steps in the actual accounting process into a specific scenario. Thus, flexible, scalable and highly automated accounting processing can be achieved.

[0067] In this embodiment, in the process of creating and pre-configuring accounting action XML, a specific accounting action is formulated according to a specific business scenario. For example, for a personal loan business, a personal loan accounting action XML is configured, which contains specific information such as the accounting action, sequence number, and effective conditions of the personal loan; for a commercial loan business, a commercial loan accounting action XML is configured, and the content is different from that of a personal loan, and so on, and specific accounting action XMLs are configured for various business scenarios.

[0068] In step S14, the validity conditions of the accounting actions associated with the accounting scenario are parsed and the accounting actions to be executed are obtained.

[0069] In some embodiments, parsing the validity conditions of the accounting actions associated with the accounting scenario and obtaining the accounting actions to be executed includes: using the JEXL expression engine to parse the validity conditions of each accounting action associated with the accounting scenario, and using the accounting actions that meet the current transaction characteristics as the accounting actions to be executed. Compared with the traditional manual or semi-automatic accounting processing methods, the automated Internet loan accounting management that combines XML configuration and the JEXL expression engine and optimizes the data storage of sub-libraries and sub-tables has higher processing efficiency, stronger business adaptability, and better system performance, which can meet the complex, diverse, and efficient requirements of modern financial services for accounting processing systems.

[0070] In step S15, the accounting amount is calculated according to the amount calculation rule of the accounting action to be executed.

[0071] In step S16, accounting entries are generated and stored according to the standard data, the accounting amount and the accounting entry XML, wherein the accounting entries include but are not limited to: action code, debit and credit identification, internal accounting subjects, amount calculation logic, account set information and red and blue word marks.

[0072] In some implementations, the accounting data processing method further includes: before saving the accounting entry, automatically mapping the internal account to the accounting account number in the financial system according to the accounting account XML configuration.

[0073] The above-mentioned accounting data processing method of Example 1 of the present invention is adopted. On the one hand, combined with the accounting processing mode of Internet loans, automatic loan account management is performed based on XML configuration and JEXL expression engine, and various transaction scenarios and transaction events are abstracted and attributed to accounting scenario XML and accounting action XML, and the accounting subjects and accounting entries commonly used in the accounting field are extracted and defined as account sets XML and accounting entries XML; various XML elements are deeply integrated and uniformly managed, so that business personnel can support various complex business accounting needs through concise and clear configuration. As a result, the efficiency of accounting data processing is greatly improved, and the errors that may occur in the processing process are also effectively reduced, providing a guarantee for the stability of Internet loan business. On the other hand, by freely configuring accounting actions, various accounting scenarios are generated, and flexible assembly of accounting actions according to business needs can be achieved, which greatly improves the flexibility of loan account management. In addition, since the accounting actions are freely assembled, they can dynamically adapt to different Internet loan business needs, thereby achieving the effect of supporting multiple businesses and providing higher business processing capabilities.

[0074] The present invention provides an example of implementing automated accounting processing using the above-mentioned accounting data processing method of Example 1: First, through the graphical user interface provided by the accounting system, business personnel are allowed to define a series of accounting actions according to specific business needs, including key information such as specified action codes, names, debit and credit directions, and amount calculation logic. Then, using the defined accounting actions, business personnel can create personalized accounting scenarios, and configure applicable accounting action sequences and corresponding effective conditions for each scenario, such as transaction amount thresholds, payment status or time factors. In addition, business personnel can also set priorities and dependencies to ensure that accounting actions can be executed in a predetermined order and logic in complex business processes. Finally, these configuration information is used to generate an accounting scenario XML file, which guides the accounting system to automatically identify applicable scenarios and execute corresponding accounting actions when actual transactions occur, thereby realizing refined and automated accounting processing for different business scenarios.

[0075] [Example 2]

[0076] Embodiment 2 of the present invention provides an example of implementing accounting processing by using the accounting data processing method of embodiment 1, wherein the accounting processing includes the following steps:

[0077] (1) Receiving business system information: The business system sends initial transaction data containing transaction details through a predefined API interface. The initial transaction data encapsulates the core information of the transaction, such as key fields such as transaction type, amount, transaction time, loan number, overdue status, etc. The information in the initial transaction data is usually encoded and transmitted in a standardized XML or JSON format to ensure that the data is structured and easy to parse.

[0078] (2) Parsing input data: After receiving the initial transaction data, the accounting system uses the built-in parser to convert the initial transaction data from its original format into a data structure that can be processed within the accounting system. At the same time, during the parsing process, the accounting system performs data integrity and correctness verification to ensure that all required fields not only exist but also meet the preset format requirements.

[0079] (3) Matching accounting scenarios: The accounting system analyzes the received data based on preset logic or rules to match the most appropriate accounting scenario. For example, when the transaction type is identified as "loan issuance", the accounting system will automatically select the accounting scenario related to loan issuance to ensure that the transaction is correctly processed.

[0080] (4) Generate accounting actions: After successfully identifying and matching the accounting scenario, the accounting system starts the relevant accounting action processing flow according to the preset configuration of the scenario. These configurations are pre-set by business personnel to ensure the standardization and consistency of the processing flow. Each accounting scenario is associated with a specific set of accounting actions. Business personnel set clear effective conditions and amount calculation rules for each accounting action, and these rules are written in a scripting language. Then, the accounting system uses the JEXL expression engine to parse the effective conditions of each accounting action, and selects the accounting actions that meet the current transaction characteristics as the accounting actions to be executed based on the effective conditions. For each accounting action to be executed that is screened out, the accounting system will execute the corresponding amount calculation rule script, which accurately calculates the specific accounting amount of each accounting action based on the preset calculation logic.

[0081] (5) Generate and save corresponding entries: When the accounting actions to be executed that meet the conditions are determined, the accounting system automatically generates detailed accounting entries based on the preset accounting entry XML. The accounting entries include core elements such as action code, debit and credit identifiers, internal accounting subjects, amount calculation logic, account set code, and red and blue text marks. Before saving the accounting entries, the accounting system automatically maps the internal subjects to the accounting subject numbers in the financial system based on the accounting subject XML configuration to ensure the consistency and accuracy of the subject numbers. After completing the internal subject mapping, the accounting system saves the accounting entries, which facilitates subsequent accounting processing and data aggregation, thereby realizing the automation and standardization of accounting information management.

[0082] (6) Complete accounting: After the preparatory steps such as data reception, parsing, and entry generation are completed, the accounting system automatically performs accounting actions and efficiently generates formal detailed accounts and sub-account data. Specifically, the accounting system first automatically performs the following steps based on the received transaction data and the preset accounting rules: the system parses the transaction data and matches the associated accounting entry rules from the accounting entry XML according to the accounting action code, and generates accounting entries according to the rule content, including determining the debit and credit direction, calculating the amount, and specifying the accounting subject. Then, the system records these entry information in the detailed account and sub-account in the preset format. The detailed account records the detailed information of each transaction, while the sub-account summarizes the transaction data by account. Furthermore, the built-in timed task mechanism of the accounting system ensures that the debit-level sub-account is batch processed at a specific preset time every day, so as to automatically summarize and generate the product-level general ledger. As a result, the automated accounting process significantly reduces manual operations, which not only improves the efficiency of accounting, but also enhances the accuracy and reliability of data processing.

[0083] Among them, the accounting system automatically performs accounting actions and generates detailed accounts and sub-account data, including: the accounting system first automatically performs the following steps based on the received transaction data and the preset accounting rules: the system parses the transaction data and matches the associated accounting entry rules from the accounting entry XML according to the accounting action code, and generates accounting entries according to the rule content, including determining the debit and credit direction, calculating the amount, and specifying the accounting subject. Then, the system records these entry information in the detailed account and sub-account in the preset format. The detailed account records the detailed information of each transaction, while the sub-account summarizes the transaction data by account.

[0084] Among them, the accounting amount obtained by the above calculation is directly taken as the accounting amount of the detailed account. In this embodiment, the generation of the detailed account is based on the above accounting amount and related transaction attributes (such as transaction time, transaction parties, amount, currency type, etc.), according to the entry rules configured in the accounting entry XML, and automatically creates a detailed record entry for each transaction in the detailed account. The record entry contains information such as the accounting amount, debit and credit direction, accounting date, accounting subject, etc., and is sorted by date and time to ensure the integrity and traceability of the transaction. For the generation of sub-account data, the accounting system classifies and summarizes according to the records in the detailed account according to specific accounts, calculates the debit and credit balances and changes of each account in a specific period, and thus forms a sub-account. The built-in scheduled task of the accounting system will run at a specific time every day (such as midnight), summarize all the detailed account data of the day, and generate a higher-level product-level general ledger.

[0085] In an exemplary implementation, generation rules are set according to specific business needs to automatically generate detailed accounts, sub-accounts and general ledgers. Specifically, based on the fields actually sent by the business system, such as transaction type, amount, accounting time and other parameters, combined with the parsing of accounting XML and the reading of accounting rules, transaction data is processed in real time. Whenever specific conditions are met, such as transaction completion or reaching a specific time point, the system automatically executes the corresponding accounting processing flow. Among them, the detailed account is generated based on the detailed information of each transaction; the transactions of the same account in the detailed account are aggregated to generate the sub-account; and the detailed accounts of the day are summarized to generate the general ledger. For example, a general ledger is generated every evening based on all the business of the day, or when the business of a certain account reaches a preset number or amount, detailed accounts and sub-accounts are automatically generated, which helps to improve the efficiency and accuracy of account management.

[0086] [Example 3]

[0087] Figure 2 Schematic diagram of the architecture of the accounting data processing system according to Embodiment 3 of the present invention.

[0088] like Figure 2As shown, the accounting data processing system includes an initial data acquisition module 210 , a data standardization module 220 and an accounting module 230 .

[0089] The initial data acquisition module 210 is used to acquire initial transaction data. The initial transaction data includes, but is not limited to, one or more of the following: transaction type, amount, transaction time, loan number, and overdue status information. The information in the initial transaction data is encoded and transmitted in a standardized XML or JSON format.

[0090] In some implementations, the initial transaction data is obtained through an API interface, wherein the initial transaction data is stored in the following manner: a database to be stored is determined according to business attributes, and the initial transaction data is stored in a corresponding data table in the database according to the transaction attributes. By storing data in separate databases and tables, large-scale data is divided into multiple databases and tables, thereby improving the parallel processing capability and data processing efficiency.

[0091] The data standardization module 220 is used to parse the initial transaction data and generate standard data of a preset structure. In some embodiments, the data standardization module 220 is also used to verify the integrity and correctness of the initial transaction data.

[0092] The accounting module 230 is used to perform the following operations: determine the accounting scenario that matches the standard data according to preset rules and the accounting XML file; parse the effectiveness conditions of the accounting action associated with the accounting scenario and obtain the accounting action to be executed; calculate the accounting amount according to the amount calculation rule of the accounting action to be executed; generate accounting entries according to the standard data, the accounting amount and the accounting entry XML and store the accounting entries.

[0093] In some implementations, the accounting module 230 is further configured to perform the following operations: before saving the accounting entry, automatically map the internal account to the accounting account number in the financial system according to the accounting account XML configuration.

[0094] The accounting XML file includes: accounting scenario XML, accounting action XML, accounting subject XML, accounting entry XML, and account set XML. The accounting scenario is associated with a group of accounting actions, and the accounting action has an effective condition and an amount calculation rule.

[0095] In some embodiments, a graphical user interface is used to create, modify and delete accounting actions and accounting scenarios and generate corresponding accounting XML files. Through the graphical user interface, business personnel can create, modify and delete accounting actions and accounting scenarios without programming knowledge.

[0096] In some embodiments, parsing the effectiveness conditions of the accounting actions associated with the accounting scenario and obtaining the accounting actions to be executed includes: using the JEXL expression engine to parse the effectiveness conditions of each accounting action associated with the accounting scenario, and taking the accounting actions that meet the current transaction characteristics as the accounting actions to be executed.

[0097] The above-mentioned accounting data processing system of Example 3 of the present invention is adopted. On the one hand, combined with the accounting processing mode of Internet loans, automatic loan account management is performed based on XML configuration and JEXL expression engine, and various transaction scenarios and transaction events are abstracted and attributed to accounting scenario XML and accounting action XML, and the accounting subjects and accounting entries commonly used in the accounting field are extracted and defined as account sets XML and accounting entries XML; various XML elements are deeply integrated and uniformly managed, so that business personnel can support various complex business accounting needs through concise and clear configuration. As a result, the efficiency of accounting data processing is greatly improved, and the errors that may occur in the processing process are also effectively reduced, providing a guarantee for the stability of Internet loan business. On the other hand, by freely configuring accounting actions, various accounting scenarios are generated, and flexible assembly of accounting actions according to business needs can be achieved, which greatly improves the flexibility of loan account management. In addition, since the accounting actions are freely assembled, they can dynamically adapt to different Internet loan business needs, thereby achieving the effect of supporting multiple businesses and providing higher business processing capabilities.

[0098] Through the description of the above implementation modes, those skilled in the art can clearly understand that the present invention can be implemented by combining software with a hardware platform. Based on such an understanding, all or part of the contribution of the technical solution of the present invention to the background technology can be embodied in the form of a software product, which can be stored in a storage medium such as ROM / RAM, a magnetic disk, an optical disk, etc., and includes several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in various implementation modes of the present invention or some parts of the implementation modes.

[0099] Correspondingly, an embodiment of the present invention further provides a computer-readable storage medium on which computer-readable instructions or programs are stored. When the computer-readable instructions or programs are executed by a processor, the computer performs the following operations: the operations include the steps included in the accounting data processing method described in any of the above embodiments, which are not repeated here. The storage medium may include, for example, a CD, a hard disk, a floppy disk, a flash memory, a magnetic tape, etc.

[0100] In addition, an embodiment of the present invention further provides a computer device including a memory and a processor, wherein the memory is used to store one or more computer-readable instructions or programs, wherein the one or more computer-readable instructions or programs can implement the accounting data processing method described in any of the above embodiments when executed by the processor. The computer device can be, for example, a server, a desktop computer, a notebook computer, a tablet computer, etc.

[0101] The embodiment of the present invention also provides a computer program product including a computer program, wherein the computer program includes a program code for executing the accounting data processing method shown in the flowchart. When the computer program product is run in a computer system, the program code is used to enable the computer system to implement the accounting data processing method provided by the embodiment of the present disclosure.

[0102] According to an embodiment of the present disclosure, the program code for executing the computer program provided by the embodiment of the present disclosure can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, Java, C++, python, "C" language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on the remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (for example, using an Internet service provider to connect through the Internet).

[0103] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit them; although the present invention is described in detail with reference to the above embodiments, a person skilled in the art should understand that the technical solutions described in the above embodiments can still be modified, or some of the technical features can be replaced by equivalents; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the various embodiments of the present invention. Therefore, the protection scope of the present invention shall be subject to the claims.

Claims

1. A method for processing accounting data, characterized in that: The accounting data processing method comprises: Get initial transaction data; Parsing the initial transaction data and generating standard data with a preset structure; Determine an accounting scenario that matches the standard data according to preset rules and the accounting XML file; Parsing the validity conditions of the accounting actions associated with the accounting scenario and obtaining the accounting actions to be executed; Calculate the accounting amount according to the amount calculation rule of the accounting action to be executed; Accounting entries are generated according to the standard data, the accounting amount and the accounting entry XML and the accounting entries are stored.

2. The accounting data processing method according to claim 1, characterized in that: The accounting XML file includes: accounting scenario XML, accounting action XML, accounting subject XML, accounting entry XML, and account set XML.

3. The accounting data processing method according to claim 2, characterized in that: Use the graphical user interface to create, modify and delete accounting actions and accounting scenarios and generate corresponding accounting XML files.

4. The accounting data processing method according to claim 1, characterized in that: Obtain the initial transaction data through the API interface, The transaction initial data is stored in the following manner: determining a database to be stored according to business attributes, and storing the transaction initial data in a corresponding data table in the database according to transaction attributes.

5. The accounting data processing method according to claim 1, characterized in that: Parsing the validity conditions of the accounting action associated with the accounting scenario and obtaining the accounting action to be executed includes: The JEXL expression engine is used to parse the effectiveness conditions of each accounting action associated with the accounting scenario, and the accounting actions that meet the current transaction characteristics are used as accounting actions to be executed.

6. The accounting data processing method according to claim 1, characterized in that: The accounting data processing method further includes: before saving the accounting entry, automatically mapping the internal account to the accounting account number in the financial system according to the accounting account XML configuration.

7. An accounting data processing system, characterized in that: The accounting data processing system comprises: An initial data acquisition module is used to acquire initial transaction data; A data standardization module, used to parse the initial transaction data and generate standard data with a preset structure; The accounting module is used to perform the following operations: Determine an accounting scenario that matches the standard data according to preset rules and the accounting XML file; Parsing the validity conditions of the accounting actions associated with the accounting scenario and obtaining the accounting actions to be executed; Calculate the accounting amount according to the amount calculation rule of the accounting action to be executed; Accounting entries are generated according to the standard data, the accounting amount and the accounting entry XML and the accounting entries are stored.

8. A computer-readable storage medium storing computer-readable instructions, characterized in that: The computer-readable instructions are executed by a processor to implement the accounting data processing method according to any one of claims 1 to 6.

9. A computer device comprising a memory and a processor, The memory stores computer-readable instructions, characterized in that: The processor executes the computer-readable instructions to implement the accounting data processing method according to any one of claims 1 to 6.

10. A computer program product comprising a computer program, characterized in that When the computer program is executed by the processor, the accounting data processing method according to any one of claims 1 to 6 is implemented.

Images