Configuration financial statement development system and method and electronic equipment

Abstract

The invention provides a configured financial statement development system and method and electronic equipment, and the system comprises a front-end display layer which is used for providing a user interaction interface, and the front-end display layer comprises statement subject configuration, statement style configuration and the display and operation of a statement configuration function module; the business logic layer is used for processing a request transmitted by a front end and executing corresponding business logic, and the business logic layer comprises an interface for realizing functions of report subject query, addition, modification, deletion and the like and performing data interaction with the data storage layer; and the data storage layer is used for storing data information of report subjects, styles and configurations, and the data storage layer is used for storing the data information of the report subjects, styles, configurations and the like, including report subject information and report style information. Through a systematic development mode, the development period is shortened, and the development cost is reduced; and the flexibility and maintainability of the report are enhanced.

Description

Technical Field

[0001] The present invention relates to the field of financial information technology, and more specifically, to a configurable financial report development system, method and electronic equipment. Background Art

[0002] With the rapid development of the financial industry and the increasing complexity of credit business, higher requirements are placed on the development of financial statements for credit platforms. Traditional financial statement development methods have problems such as long development cycles, poor flexibility, and difficult maintenance, and cannot meet the new generation of credit platforms' needs for diversified, dynamic, and efficient financial statements. Therefore, a new type of financial statement development system and method is needed to improve the efficiency and quality of statement development and meet the actual needs of credit platforms. Summary of the invention

[0003] The present invention aims at the technical problems existing in the prior art and provides a configurable financial report development system, method and electronic equipment, which shortens the development cycle, reduces the development cost and enhances the flexibility and maintainability of the report through a systematic development approach.

[0004] According to a first aspect of the present invention, there is provided a configurable financial statement development system, comprising:

[0005] The front-end display layer is used to provide a user interaction interface; the front-end display layer includes the display and operation of the report subject configuration module, the report style configuration module and the report template configuration module;

[0006] The business logic layer is used to process requests from the front end and execute corresponding business logic; the business logic layer includes report account query, addition, modification and deletion, and an interface for data interaction with the data storage layer;

[0007] The data storage layer is used to store report subjects, styles and configuration data information; the data storage layer is used to store report subjects, styles and configuration data information, including report subject information and report style information.

[0008] Based on the above technical solution, the present invention can also make the following improvements.

[0009] Optionally, the report subject configuration module includes the report subject number, subject name, report type, and subject unit. The report subject configuration module fills in the subject information through the user interface layer, and the business logic layer receives the front-end request data and verifies the data rules. The subject number is set to start from 0001 and is submitted to the back-end database for storage after verification.

[0010] Optionally, the report subject configuration module supports querying, modifying or deleting subject information based on subject name or number.

[0011] Optionally, the report style configuration module includes style information and configuration subject information. The style information is filled in with subject information through the user interface layer. The business logic layer receives the front-end request data, verifies the data rules, and submits it to the back-end database for storage.

[0012] Optionally, the subject information configured in the report style is stored in a database, allowing query, addition, modification or deletion operations.

[0013] Optionally, the report template configuration module includes: report number, report name, and effective status. The report template configuration module adds the report sample from the front end and stores the information in the database, supporting query, addition, modification or deletion operations.

[0014] Optionally, the report subject information is a report indicator, which is used to define the account number, account name, report type, new and old report signs, units and formula information. Users query, view details, add, modify and delete report subjects through the front-end display layer. When adding or modifying report subjects, users need to fill in the corresponding information and store the information in the data storage layer through the business logic layer.

[0015] Optionally, the report style information is used to define the style of the report, including style number, style name, number of data columns, fields, new and old report signs, report type, header, footer and column header information. Users query, view details, add, modify and delete report styles through the front-end display layer. When adding or modifying a report style, users need to fill in the corresponding information and store the information in the data storage layer through the business logic layer.

[0016] According to a second aspect of the present invention, there is provided a configurable financial statement development method, comprising the following steps:

[0017] Users select corresponding function modules through the front-end display layer to perform operations on report subjects, styles or configurations;

[0018] The business logic layer receives user requests and executes corresponding business logic according to the request type, including data query, addition, modification or deletion operations;

[0019] The business logic layer interacts with the data storage layer to store the information filled in by the user in the database or query the corresponding information from the database;

[0020] The data storage layer returns the query results or storage results to the business logic layer, and the business logic layer returns the processing results to the front-end presentation layer for display.

[0021] According to a third aspect of the present invention, there is provided an electronic device, comprising a memory and a processor, wherein the processor is configured to implement steps of a configurable financial statement development method when executing a computer program stored in the memory.

[0022] Technical effects and advantages of the present invention:

[0023] The present invention provides a configurable financial report development system, method and electronic equipment, which improve the efficiency and quality of report development, shorten the development cycle and reduce the development cost through a systematic development method; enhance the flexibility and maintainability of the report, and users can add, modify and delete report subjects, styles and configurations at any time according to actual needs; meet the needs of a new generation of credit platforms for the diversification, dynamism and efficiency of financial reports, and improve the processing efficiency and management level of credit business.

[0024] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] Figure 1 A schematic diagram of the credit platform financial report development system architecture provided by an embodiment of the present invention;

[0026] Figure 2 A flow chart of report account configuration provided by an embodiment of the present invention;

[0027] Figure 3 A flow chart of report style configuration provided by an embodiment of the present invention;

[0028] Figure 4 A flow chart of report configuration provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0029] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0030] It should be noted that traditional reports only pile up table structure data to make a fixed financial report, which has no flexibility at all. The configurable financial report development system and method described in the embodiment of the present invention can flexibly adjust the report subjects, report forms and subject calculation formulas, and can quickly configure a financial report template without a lot of development work.

[0031] It is understandable that based on the defects in the background technology, the embodiment of the present invention proposes a configurable financial report development system, specifically Figure 1 As shown, the system includes a front-end display layer, a business logic layer and a data storage layer; wherein,

[0032] The front-end display layer is used to provide a user interaction interface, and the front-end display layer includes the display and operation of the report subject configuration module, the report style configuration module and the report configuration module;

[0033] The business logic layer is used to process requests from the front end and execute corresponding business logic. The business logic layer includes the implementation of functions such as report account query, addition, modification and deletion, as well as an interface for data interaction with the data storage layer;

[0034] The data storage layer is used to store data information such as report subjects, styles and configurations. The data storage layer is used to store data information such as report subjects, styles and configurations, including report subject information and report style information.

[0035] Specific as Figure 2 As shown, the report account configuration module includes report account number (0001, 0002, 0003...), account name (total operating income, operating cost, sales expense, administrative expense...), attribution report type (balance sheet, cash flow statement, profit and loss statement, etc., because the report type is relatively fixed, the report type is pre-designed, and the front-end operation is directly selected from the set report type), and account unit (yuan, ten thousand yuan). Fill in the account information through the user interface layer, the business logic layer receives the front-end request data, and verifies the data rules. The account number is set to start from 0001. The account number is the unique identifier of the account and no duplication is allowed; after verification, it is submitted to the back-end database for storage. At the same time, it can support querying, modifying, and deleting account information based on the account name or number.

[0036] The subject configuration table stores information of all subjects and constitutes the subject library.

[0037] The report style configuration module needs to design the report style configuration first, including style information and configuration subject information. The style information includes:

[0038] Style number: 001 (custom)

[0039] Style name: Balance sheet (new accounting standards) (customized)

[0040] Number of data columns: 4

[0041] Columns: 2

[0042] Attribution report types: balance sheet, income statement, financial indicator statement, cash flow statement...

[0043] Style header information: subject, row number, beginning value, ending value, same period last year, indicator value...

[0044] Fill in the subject information through the user interface layer, the business logic layer receives the front-end request data, verifies the data rules, and submits it to the back-end database for storage.

[0045] Configuration subject information includes:

[0046] Add subject: Select a subject from the subject library and fill in the subject position, including the column, sequence, row number display, and subject editing method.

[0047] Subject editing methods include:

[0048] Constant item: You need to configure the constant default value, including the beginning and ending values; Beginning value: When the account editing mode is constant, you need to configure the constant value; Ending value: When the account editing mode is constant, you need to configure the constant value; Calculation formula: When the account editing mode is automatic calculation, you need to calculate the formula. Manual input item: Manually enter the value in the report:

[0049] Automatically calculated items: Automatically calculated based on the calculation company.

[0050] For example: the editing method for monetary funds accounts is manual input, and the value is manually entered in the form; the editing method for total current assets accounts is automatic calculation, and the calculation formula needs to be filled in.

[0051] How to fill in the calculation formula: Report type number. Report subject. End value (beginning value) + / - Report type. Report subject. End value (beginning value)......

[0052] {01.4001-paid-in capital (or share capital).[09-end adjustment value]}+{01.4002-other equity instruments.[09-end adjustment value]}+{01.4003-capital reserve.[09-end adjustment value]}-{01.4004-treasury stock.[09-end adjustment value]}+{01.4005-other comprehensive income.[09-unadjusted value]}+{01.4006-surplus reserve.[09-end adjustment value]}+{01.4007-retained profit.[09-end adjustment value]}

[0053] The account information configured in the report style is also stored in the database, allowing query, addition, modification or deletion operations. The above completes the configuration of the report style account.

[0054] The report template configuration module includes: report number (such as number 0001), report name (such as new accounting standards report, small and medium-sized enterprise summary report, etc.), and effective status (effective, to be effective).

[0055] After adding the table sample from the front end, the information is stored in the database, supporting addition, deletion, modification and query.

[0056] Select a report style from the sample and associate it with the report template. The new accounting standard report template includes balance sheet, income statement, cash flow statement and other samples. Select the configured sample from the sample and associate it with the template. The report template configuration is completed.

[0057] In this embodiment, the report subject is the report indicator. The embodiment of the present invention provides a report subject configuration function for defining the main information such as the subject number, subject name, report type, new and old report flags, units, formulas, etc. Users can query, view details, add, modify and delete report subjects through the front-end display layer. When adding or modifying report subjects, users need to fill in the corresponding information, and the information is stored in the data storage layer through the business logic layer. The subject configuration function allows users to configure subjects on demand to realize the function of the subject library.

[0058] The embodiment of the present invention provides a report style configuration function for defining the style information of the report, including the style number, style name, number of data columns, fields, new and old report flags, report type, header, footer and column header information, etc. Users can query, view details, add, modify and delete report styles through the front-end display layer. When adding or modifying a report style, users can fill in the corresponding information, and the information is stored in the data storage layer through the business logic layer.

[0059] In addition, users can also configure the account for the selected style record, including filling in and saving information such as account number, sequence number, row number, and column. The configured account is queried from the report account library to obtain the account number and account name configuration, and it also supports the configuration of account value calculation formulas for accounts that need to be calculated in the style.

[0060] The present invention provides a report configuration function for configuring financial report templates and setting the relationship between reports and styles. Users can query, view details, add, modify and delete report configurations through the front-end display layer. When adding or modifying report configurations, users need to fill in information such as report number, report name, balance sheet style, profit and loss statement style, cash flow statement style, financial indicator table style, owner's equity change style, simple table style, new and old report flags, enterprise report flags and effective status, and store the information in the data storage layer through the business logic layer.

[0061] According to a second aspect of the present invention, an embodiment of the present invention further provides a credit platform financial statement development method, comprising the following steps:

[0062] Users select corresponding function modules through the front-end display layer to perform operations on report subjects, styles or configurations;

[0063] The business logic layer receives user requests and executes the business logic of the front-end display layer according to the request type, including data query, addition, modification or deletion operations;

[0064] The business logic layer interacts with the data storage layer to store the information filled in by the user in the database or query the corresponding information from the database;

[0065] The data storage layer returns the query results or storage results to the business logic layer, and the business logic layer returns the processing results to the front-end presentation layer for display.

[0066] According to the third aspect of the present invention, an embodiment of the present invention provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the implementation steps of the above-mentioned method for developing financial statements of a credit platform are implemented.

[0067] In addition, the logic instructions in the above-mentioned memory can be implemented in the form of software functional units and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0068] Although the preferred embodiments of the present invention have been described, those skilled in the art may make other changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0069] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.

[0070] Finally, it should be noted that the above is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, it is still possible for those skilled in the art to modify the technical solutions described in the aforementioned embodiments or to make equivalent substitutions for some of the technical features therein. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A configurable financial report development system, characterized in that: include: The front-end display layer is used to provide a user interaction interface; the front-end display layer includes the display and operation of the report subject configuration module, the report style configuration module and the report template configuration module; The business logic layer is used to process requests from the front end and execute corresponding business logic; the business logic layer includes report account query, addition, modification and deletion, and an interface for data interaction with the data storage layer; The data storage layer is used to store report subjects, styles and configuration data information; the data storage layer is used to store report subjects, styles and configuration data information, including report subject information and report style information.

2. A configurable financial report development system according to claim 1, characterized in that: The report subject configuration module includes the report subject number, subject name, report type, and subject unit. The report subject configuration module fills in the subject information through the user interface layer, and the business logic layer receives the front-end request data and verifies the data rules. The subject number is set to start from 0001 and is submitted to the back-end database for storage after verification.

3. A configurable financial report development system according to claim 1, characterized in that: The report subject configuration module supports querying, modifying or deleting subject information based on subject name or number.

4. A configurable financial report development system according to claim 1, characterized in that: The report style configuration module includes style information and configuration subject information. The style information is filled in with subject information through the user interface layer. The business logic layer receives the front-end request data, verifies the data rules, and submits it to the back-end database for storage.

5. A configurable financial report development system according to claim 1, characterized in that: The subject information configured in the report style is stored in the database, allowing query, addition, modification or deletion operations.

6. A configurable financial report development system according to claim 1, characterized in that: The report template configuration module includes: report number, report name, and effective status. After adding the report template from the front end, the report template configuration module stores the information in the database and supports query, addition, modification or deletion operations.

7. A configurable financial report development system according to claim 1, characterized in that: The report subject information is a report indicator, which is used to define the subject number, subject name, report type, new and old report signs, units and formula information. Users query, view details, add, modify and delete report subjects through the front-end display layer. When adding or modifying report subjects, users need to fill in the corresponding information, and the information is stored in the data storage layer through the business logic layer.

8. A configurable financial report development system according to claim 1, characterized in that: The report style information is used to define the style of the report, including style number, style name, number of data columns, fields, new and old report signs, report type, header, footer and column header information. Users can query, view details, add, modify and delete report styles through the front-end display layer. When adding or modifying a report style, users need to fill in the corresponding information, and the information will be stored in the data storage layer through the business logic layer.

9. A configurable financial statement development method, characterized in that: The following steps are involved: Users select corresponding function modules through the front-end display layer to perform operations on report subjects, styles or configurations; The business logic layer receives user requests and executes the business logic of the business logic layer according to the request type, including data query, addition, modification or deletion operations; The business logic layer interacts with the data storage layer to store the information filled in by the user in the database or query the corresponding information from the database; The data storage layer returns the query results or storage results to the business logic layer, and the business logic layer returns the processing results to the front-end presentation layer for display.

10. An electronic device, characterized in that: It comprises a memory and a processor, wherein the processor is used to implement a configurable financial statement development method as claimed in claim 9 when executing a computer program stored in the memory.

Images