Financial budget comparison method, device, equipment and medium based on database

Abstract

The present application discloses a financial budget comparison method, device, equipment, and medium based on a database, the method comprising: receiving a first budget mapping table sent by a financial system indicating a mapping relationship between a financial project, a reference budget, first data description information, and a first budget calculation requirement including a first formula identifier; obtaining target data corresponding to the first data description information in a database; calling a first reference code corresponding to the first formula identifier in a formula code library and combining to obtain a first target code, and calculating a target budget based on the target data and the first target code; and comparing the target budget with the reference budget to obtain a target comparison result. The target component freely combines the codes of the formula database as needed to obtain the target code to calculate the target budget according to the budget calculation requirements of different financial projects sent by the financial system, which reduces the workload of developers compared to the method in which developers write codes to calculate the budget according to the budget calculation requirements.

Description

Technical Field

[0001] The present application relates to but is not limited to the field of budget processing technology, and in particular to a database-based financial budget comparison method, device, equipment, and medium. Background Art

[0002] The process of financial budget comparison is: calculate the actual budget according to the sub-expense items associated with the financial project, compare the actual budget with the preset budget corresponding to the financial project, and determine whether they are consistent. Financial budget comparison can quickly identify and handle data inconsistencies, and can effectively improve the timeliness and effectiveness of financial decisions. In the process of calculating the actual budget of a financial project, the existing method is that the financial personnel set a budget calculation requirement for the financial project, and the developer writes the corresponding operation code according to the budget calculation requirement of the financial project. When the budget calculation service of the target financial project is triggered, the corresponding operation code is called for calculation. When the budget calculation requirement corresponding to the financial project changes, the developer needs to rewrite the corresponding operation code. When there are multiple financial projects and the budget calculation requirements of multiple financial projects change, the developer needs to frequently modify the operation code, which greatly increases the workload of the developer. Summary of the invention

[0003] The embodiments of the present application provide a database-based financial budget comparison method, device, equipment, and medium, which can effectively reduce the workload of developers and thus reduce development costs.

[0004] In a first aspect, an embodiment of the present application provides a financial budget comparison method based on a database, the method is applied to a target component, the target component is respectively connected to a database and a financial system for communication, the target component has a built-in formula code library, the formula code library includes multiple formula codes, the method includes:

[0005] receiving a first budget mapping table sent by the financial system, wherein the first budget mapping table is used to indicate a mapping relationship between a financial project, a reference budget, first data description information, and a first budget calculation requirement, the reference budget is a preset budget of the financial project, the first data description information represents reference data for calculating a target budget, and the first budget calculation requirement includes a plurality of first formula identifiers;

[0006] Matching the first data description information with each reference data description information in a data identifier mapping table, determining the data identifier corresponding to the successfully matched reference data description information as the target data identifier of the first data description information, and acquiring the target data corresponding to the target data identifier from the database, wherein the data identifier mapping table is used to indicate the mapping relationship between the data identifier and the reference data description information;

[0007] Invoking each first reference code corresponding to each first formula identifier in the formula code library, combining each first reference code to obtain a first target code, and calculating the target budget based on the target data and the first target code;

[0008] The target budget is compared with the reference budget to obtain a target comparison result.

[0009] In some embodiments, the financial system displays a visualization interface, the visualization interface includes multiple first fields, multiple second fields, and multiple input boxes, different first fields are used to uniquely identify different financial items, the second fields include multiple different formula identifiers and multiple different operators, each input box is used to receive the first data description information input by a user, and the first budget mapping table is generated according to the following steps:

[0010] In response to the user's association operation between each of the first fields and multiple target fields and the input box, each of the first fields, the reference budget corresponding to each of the first fields, the first data description information, and the target field are obtained, wherein the target field is selected by the user from the multiple formula identifiers and the multiple operators;

[0011] Generate the first budget calculation requirement based on the target field corresponding to the first field, establish a mapping relationship between each of the first fields, each of the corresponding reference budgets, each of the first data description information and the first budget calculation requirement, and generate each first record;

[0012] The first budget mapping table is generated according to all the first records.

[0013] In some embodiments, the first budget calculation requirement further includes a plurality of operators, each of the operators is arranged alternately with each of the first formula identifiers, each of the first reference codes includes an input statement, an operation statement, and an output statement, the number of the target data is multiple, each of the target data corresponds to a different data type, each of the first reference codes is combined to obtain a first target code, and the target budget is calculated based on the target data and the first target code, including:

[0014] Merging all the input statements corresponding to the first reference codes to obtain a target input statement, wherein the target input statement corresponds to a plurality of target input parameters, and different target input parameters correspond to target data of different data types;

[0015] Obtaining sorting information between the operator and the first formula identifier in the first budget calculation requirement, and merging the operation statements corresponding to all the first reference codes based on the sorting information to obtain a target operation statement;

[0016] Merging the output statements corresponding to all the first reference codes to obtain a target output statement;

[0017] Combining the target input statement, the target operation statement and the target output statement to obtain the first target code;

[0018] Substituting each of the target data into each of the target input parameters corresponding to the target input statement, and calculating all of the target data through the target calculation statement to obtain the target budget;

[0019] The target budget is outputted through the target output statement.

[0020] In some embodiments, after comparing the target budget with the reference budget to obtain a target comparison result, the method further includes:

[0021] When receiving the second budget mapping table sent by the financial system, comparing the second budget mapping table with the first budget mapping table to obtain a comparison result;

[0022] When the comparison result indicates that the second budget mapping table is inconsistent with the first budget mapping table, obtaining change content from the comparison result, wherein the change content includes a second budget calculation requirement and / or second data description information corresponding to the same financial item;

[0023] The target comparison result is recalculated based on the changed content.

[0024] In some embodiments, recalculating the target comparison result based on the changed content includes:

[0025] When the change content is the second budget calculation requirement, multiple second formula identifiers are obtained from the second budget calculation requirement, second reference codes corresponding to each second formula identifier are called again in the formula code library, each second reference code is combined to obtain a second target code, a second target budget is calculated based on the first target data and the second target code, and the second target budget is compared with the reference budget to obtain a new target comparison result;

[0026] When the changed content is the second data description information, second target data corresponding to the second data description information is obtained in the database, a third target budget is calculated based on the second target data and the first target code, and the third target budget is compared with the reference budget to obtain a new target comparison result;

[0027] When the change content includes the second data description information and the second budget calculation requirement, the second target data corresponding to the second data description information is re-acquired from the database, multiple second formula identifiers are obtained from the second budget calculation requirement, the second reference code corresponding to each second formula identifier is re-called in the formula code library, each second reference code is combined to obtain a second target code, a fourth target budget is calculated based on the second target data and the second target code, and the fourth target budget is compared with the reference budget to obtain a new target comparison result.

[0028] In some embodiments, after comparing the target budget with the reference budget to obtain a target comparison result, the method further includes:

[0029] Acquire a target difference from the target comparison result, wherein the target difference is a difference between the target budget and the reference budget;

[0030] When the target difference exceeds a preset difference threshold, an alarm message is generated based on the target budget, the reference budget and the target difference, the alarm message is sent to the financial system, and displayed on the visualization interface;

[0031] When the target difference does not exceed the preset difference threshold, the target comparison result is sent to the financial system and displayed on the visualization interface.

[0032] In a second aspect, an embodiment of the present application provides a control device, comprising at least one control processor and a memory for communicating with the at least one control processor; the memory stores instructions executable by the at least one control processor, and the instructions are executed by the at least one control processor so that the at least one control processor can execute the database-based financial budget comparison method as described in the first aspect.

[0033] In a third aspect, an embodiment of the present application further provides an electronic device, comprising the control device of the second aspect.

[0034] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium storing computer-executable instructions, wherein the computer-executable instructions are used to execute the database-based financial budget comparison method as described in the first aspect.

[0035] The embodiment of the present application provides a financial budget comparison method, device, equipment, and medium based on a database, the method comprising: receiving a first budget mapping table sent by the financial system, wherein the first budget mapping table is used to indicate the mapping relationship between a financial project, a reference budget, first data description information, and a first budget calculation requirement, wherein the reference budget is a preset budget of the financial project, the first data description information represents reference data used to calculate a target budget, and the first budget calculation requirement includes multiple first formula identifiers; matching the first data description information with each reference data description information in the data identifier mapping table, and determining the data identifier corresponding to the successfully matched reference data description information as the target data identifier of the first data description information, wherein the data identifier mapping table is used to indicate the mapping relationship between the data identifier and the reference data description information; acquiring the target data corresponding to the target data identifier from the database; calling each first reference code corresponding to each first formula identifier in the formula code library, combining each first reference code to obtain a first target code, and calculating the target budget based on the target data and the first target code; comparing the target budget with the reference budget to obtain a target comparison result. . According to the solution provided in the embodiment of the present application, the target component is freely combined into the target code from the formula database as needed according to the budget calculation requirements of different financial projects sent by the financial system to calculate the target budget. Compared with the existing method in which developers write codes according to the budget calculation requirements, it can effectively reduce the workload of developers and reduce development costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 is a flowchart of the steps of a database-based financial budget comparison method provided by an embodiment of the present application;

[0037] Figure 2 is a schematic diagram of a database-based financial budget comparison method provided by another embodiment of the present application;

[0038] Figure 3 It is a structural diagram of a control device provided in another embodiment of the present application. DETAILED DESCRIPTION

[0039] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0040] It is understood that although the functional modules are divided in the device schematic diagram and the logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than the module division in the device or the order in the flowchart. The terms "first", "second", etc. in the specification, claims or the above drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence.

[0041] The process of financial budget comparison is: calculate the actual budget according to the sub-expense items associated with the financial project, compare the actual budget with the preset budget corresponding to the financial project, and determine whether they are consistent. Financial budget comparison can quickly identify and handle data inconsistencies, and can effectively improve the timeliness and effectiveness of financial decisions. In the process of calculating the actual budget of a financial project, the existing method is that the financial personnel set a budget calculation requirement for the financial project, and the developer writes the corresponding operation code according to the budget calculation requirement of the financial project. When the budget calculation service of the target financial project is triggered, the corresponding operation code is called for calculation. When the budget calculation requirement corresponding to the financial project changes, the developer needs to rewrite the corresponding operation code. When there are multiple financial projects and the budget calculation requirements of multiple financial projects change, the developer needs to frequently modify the operation code, which greatly increases the workload of the developer.

[0042] To solve the above-mentioned problems, an embodiment of the present application provides a financial budget comparison method, device, equipment, and medium based on a database, the method comprising: receiving a first budget mapping table sent by the financial system, wherein the first budget mapping table is used to indicate a mapping relationship between a financial project, a reference budget, first data description information, and a first budget calculation requirement, the reference budget is a preset budget for the financial project, the first data description information represents reference data for calculating a target budget, and the first budget calculation requirement includes multiple first formula identifiers; matching the first data description information with each reference data description information in a data identifier mapping table, and determining the data identifier corresponding to the successfully matched reference data description information as a target data identifier of the first data description information, wherein the data identifier mapping table is used to indicate a mapping relationship between a data identifier and the reference data description information; acquiring the target data corresponding to the target data identifier from the database; calling each first reference code corresponding to each first formula identifier in the formula code library, combining each first reference code to obtain a first target code, and calculating the target budget based on the target data and the first target code; comparing the target budget with the reference budget to obtain a target comparison result. According to the solution provided in the embodiment of the present application, the target component freely combines into target codes from the formula database as needed according to the budget calculation requirements of different financial projects sent by the financial system to calculate the target budget. When the budget calculation requirements change, it is only necessary to reassemble new target codes from the formula database through the target component. Compared with the existing method in which developers write codes according to budget calculation requirements and need to rewrite the original codes when the requirements change, it can effectively reduce the workload of developers and reduce development costs.

[0043] The embodiments of the present application are further described below in conjunction with the accompanying drawings.

[0044] refer to Figure 1 , Figure 1 The present invention provides a method for comparing financial budgets based on a database, which is a flowchart of the steps of a method for comparing financial budgets based on a database provided by an embodiment of the present invention. The present invention provides a method for comparing financial budgets based on a database, which is applied to a target component, wherein the target component is respectively connected to a database and a financial system for communication, and wherein the target component has a formula code library built therein, wherein the formula code library includes a plurality of formula codes, and the method includes but is not limited to the following steps:

[0045] Step S10, receiving a first budget mapping table sent by the financial system, wherein the first budget mapping table is used to indicate a mapping relationship between a financial project, a reference budget, first data description information and a first budget calculation requirement, the reference budget is a preset budget for the financial project, the first data description information represents reference data for calculating a target budget, and the first budget calculation requirement includes a plurality of first formula identifiers.

[0046] Specifically, the financial system and database of this embodiment can be part of the corresponding business system of the enterprise. It can be understood that the enterprise has expenditures for financial items of different business types, such as labor fees, technical consulting fees, travel expenses, etc., and for different types of financial items, the enterprise will pre-set a reference budget to control the enterprise's expenditure costs. In actual applications, it is also necessary to calculate whether the actual budget of each financial item is different from the preset reference budget, so as to effectively improve the timeliness and effectiveness of the enterprise's financial decision-making.

[0047] Specifically, the first budget mapping table of this embodiment is as follows: Figure 2 As shown, it includes financial projects, reference budgets, first data description information and first budget calculation requirements, that is, each financial project corresponds to a reference budget, first data description information and first budget calculation requirements, the first data description information is the basic calculation data required to calculate the actual budget corresponding to the corresponding financial project, the first budget requirement is the calculation formula for calculating the actual budget of the financial project, and the first data description information and first budget calculation requirements corresponding to each financial project in the first budget mapping table are selected or filled in by the financial personnel of the financial system as needed.

[0048] It can be understood that the target component of this embodiment is a software plug-in, which is connected to the financial system and the database respectively. After receiving the first budget mapping table sent by the financial system, it can freely match and combine the target code from the formula database as needed according to the budget calculation requirements and data description information of different financial items in the first budget mapping table, and extract the target data from the database as needed, and then can input the extracted target data into the target code to calculate the actual budget and complete the budget comparison. That is to say, the first budget mapping table can provide an effective data basis for subsequent financial budget comparison operations.

[0049] Specifically, in a specific embodiment, the financial system displays a visual interface, which includes multiple first fields, multiple second fields, and multiple input boxes. Different first fields are used to uniquely identify different financial items. The second fields include multiple different formula identifiers and multiple different operators. Each input box is used to receive the first data description information and reference budget input by the user. The steps of generating the first budget mapping table of the above embodiment include but are not limited to the following steps:

[0050] Step S11, in response to the user's association operation between each first field and multiple target fields and the input box, obtaining each first field, the reference budget corresponding to each first field, the first data description information and the target field, wherein the target field is obtained by the user selecting from multiple formula identifiers and multiple operators;

[0051] Step S12, generating a first budget calculation requirement based on the target field corresponding to the first field, establishing a mapping relationship between each first field, each corresponding reference budget, each first data description information and the first budget calculation requirement, and generating each first record;

[0052] Step S13: Generate a first budget mapping table according to all first records.

[0053] Specifically, the first budget mapping table of this embodiment includes multiple first records, each first record corresponds to a different financial item, and each first record is constructed by the user selecting a first field in the visual interface of the financial system, and associating the selected first field with an input box and a target field. The association operation of this embodiment is to connect the selected first field with the input box and the target field or click to select in sequence.

[0054] Specifically, the target field is obtained by selecting and combining a plurality of different formula identifiers and a plurality of different operators in the second field as needed by a user who logs into the financial system. In this embodiment, when each formula identifier in the second field of the visualization interface is detected to be selected, formula description information is mapped and displayed, so that the user can select as needed and select an operator as needed, and then generate a first budget calculation requirement based on the selected formula identifier and operator combination.

[0055] It is understandable that, since the user group of the financial system of this embodiment is financial personnel rather than R&D personnel, the visual interface that can provide the first budget mapping table construction service is displayed in the financial system, which can facilitate users to build the first budget mapping table and improve the construction efficiency of the first budget mapping table. In addition, when the budget calculation requirements of the financial project or the basic data and reference budget used to calculate the budget change, the user can timely adjust the associated operation of the corresponding first field that has changed in the visual interface, thereby updating the first budget mapping table.

[0056] Step S20, match the first data description information with each reference data description information in the data identifier mapping table, determine the data identifier corresponding to the successfully matched reference data description information as the target data identifier of the first data description information, and obtain the target data corresponding to the target data identifier from the database, wherein the data identifier mapping table is used to indicate the mapping relationship between the data identifier and the reference data description information.

[0057] It can be understood that, referring to the description of the above embodiment, since the financial system is for financial staff, the first data description information is text information input on demand, and the target component needs to parse the first data description information and convert it into a data identifier that can be recognized by the database, such as Figure 2 As shown, the first data description information is converted into a target data identifier, so that data for calculating the target budget of the corresponding financial project can be obtained from the database.

[0058] Specifically, the specific operation of this embodiment to obtain target data for calculating the target budget of the corresponding financial project from the database is by maintaining a data identifier mapping table for indicating the mapping relationship between the data identifier and the reference data description information, matching the first data description information with each reference data description information in the data identifier mapping table, determining the data identifier corresponding to the successfully matched reference data description information as the target data identifier of the first data description information, and obtaining the target data corresponding to the target data identifier from the database, thereby providing an effective data basis for the subsequent calculation of the target budget.

[0059] Step S30, calling each first reference code corresponding to each first formula identifier in the formula code library, combining each first reference code to obtain a first target code, and calculating a target budget based on the target data and the first target code.

[0060] Specifically, the formula code library of this embodiment includes multiple formula codes, each of which is a code pre-written by a developer, such as a sales cost calculation code, a production cost calculation code, and a management cost calculation code. Each formula code is associated with a first formula identifier. According to different first budget calculation requirements corresponding to different financial items in the first budget mapping table, a first target code is freely selected and combined. When the first budget calculation requirement corresponding to the financial item changes, the target component triggers the operation of re-selecting a new formula code from the formula code library according to the updated requirement and combining it into a new first target code. There is no need for developers to rewrite new operation codes, which greatly reduces the workload of developers and reduces enterprise costs.

[0061] Specifically, in one embodiment, the first budget calculation requirement further includes a plurality of operators, each operator is arranged alternately with each first formula identifier, each first reference code includes an input statement, an operation statement and an output statement, the number of target data is multiple, and each target data corresponds to a different data type. Figure 1 The step S30 combines the first reference codes to obtain the first target code, and calculates the target budget based on the target data and the first target code, including but not limited to the following steps:

[0062] Step S31, merging all input statements corresponding to the first reference code to obtain a target input statement, wherein the target input statement corresponds to a plurality of target input parameters, and different target input parameters correspond to target data of different data types;

[0063] Step S32, obtaining the sorting information between the operator and the first formula identifier in the first budget calculation requirement, and merging all the operation statements corresponding to the first reference code based on the sorting information to obtain the target operation statement;

[0064] Step S33, merging all output statements corresponding to the first reference codes to obtain a target output statement;

[0065] Step S34, combining the target input statement, the target operation statement and the target output statement to obtain a first target code;

[0066] Step S35, substituting each target data into each target input parameter corresponding to the target input statement, and calculating all the target data through the target calculation statement to obtain the target budget;

[0067] Step S36: output the target budget through a target output statement.

[0068] Specifically, the sorting information of this embodiment includes the arrangement order of operators and first formula identifiers.

[0069] It can be understood that the present embodiment realizes combining various first reference codes to obtain the first target code, and the operation of calculating the target budget based on the target data and the first target code is specifically to merge the selected first reference codes into input statements, merge operation statements and merge output statements. Specifically, the merge operation statement is based on the sorting information of the interval arrangement of various operators and various first formula identifiers in the first budget calculation requirement, and combines the various operation statements in combination with the operator to obtain a new logical combination, that is, the target operation statement; when the number of target data is multiple, different target data corresponds to different data types. In the present embodiment, when multiple target data are simultaneously input in the target input statement, the target budget of the financial project is calculated at one time through the merged target operation statement, and output through the target output statement, that is, after the combination of the formula code, multiple data inputs and one result output can be realized. Compared with each target data block input into different first reference codes, each first reference code outputs the corresponding result, and finally the final target budget is calculated according to the sorting information of the operator and the first formula identifier of the corresponding first budget calculation requirement, which effectively simplifies the operation process and improves the operation efficiency.

[0070] Step S40, comparing the target budget with the reference budget to obtain a target comparison result.

[0071] In summary, this embodiment uses a target component associated with the financial system and the database respectively to realize the budget calculation requirements of different financial projects sent by the financial system, and freely combines the target code from the formula database as needed to calculate the target budget. When the budget calculation requirements change, it is only necessary to reassemble the new target code from the formula database through the target component. Compared with the existing method in which developers write code according to the budget calculation requirements and need to rewrite the original code when the requirements change, it can effectively reduce the workload of developers and reduce development costs.

[0072] Additionally, in some embodiments, executing Figure 1 After step S40, the database-based financial budget comparison method of the embodiment of the present application further includes but is not limited to the following steps:

[0073] Step S41, when receiving the second budget mapping table sent by the financial system, compare the second budget mapping table with the first budget mapping table to obtain a comparison result;

[0074] Step S42: when the comparison result indicates that the second budget mapping table is inconsistent with the first budget mapping table, obtaining change content from the comparison result, wherein the change content includes a second budget calculation requirement and / or second data description information corresponding to the same financial project;

[0075] Step S43: recalculate the target comparison result based on the changed content.

[0076] In addition, the changes in the present embodiment may also include changes in reference budgets for historical financial items, new financial items, and the like.

[0077] Specifically, in one embodiment, step S43 includes but is not limited to the following steps:

[0078] Step S431: when the changed content is a second budget calculation requirement, multiple second formula identifiers are obtained from the second budget calculation requirement, second reference codes corresponding to each second formula identifier are re-called in the formula code library, each second reference code is combined to obtain a second target code, a second target budget is calculated based on the first target data and the second target code, and the second target budget is compared with the reference budget to obtain a new target comparison result;

[0079] Step S432, when the changed content is the second data description information, obtain the second target data corresponding to the second data description information in the database, calculate the third target budget based on the second target data and the first target code, and compare the third target budget with the reference budget to obtain a new target comparison result;

[0080] Step S433, when the changed content includes the second data description information and the second budget calculation requirement, the second target data corresponding to the second data description information is obtained from the database again, multiple second formula identifiers are obtained from the second budget calculation requirement, the second reference code corresponding to each second formula identifier is called again in the formula code library, the second reference codes are combined to obtain the second target code, the fourth target budget is calculated based on the second target data and the second target code, and the fourth target budget is compared with the reference budget to obtain a new target comparison result.

[0081] It can be understood that when receiving the second budget mapping table sent by the financial system, that is, the new budget mapping table, this embodiment first compares the specific contents of the second budget mapping table with the first budget mapping table to obtain a comparison result; when the comparison result indicates that the second budget mapping table is inconsistent with the first budget mapping table, the change content is obtained from the comparison result, wherein the change content includes the second budget calculation requirement and / or second data description information corresponding to the same financial project, and the target comparison result is recalculated based on the change content. That is to say, the target component of this embodiment can support changes in budget calculation requirements, based on the specific change requirement content, flexibly match the formula codes from the formula code library, or re-acquire new target data from the database, calculate the new target budget, and then obtain a new target comparison result, which can enhance the flexibility of the target component and improve the user experience of the target component.

[0082] Specifically, in this implementation, the target component dynamically processes the changes based on the content as follows: when the change content is a second budget calculation requirement, that is, the budget calculation method of the historical financial project changes, the target component obtains multiple second formula identifiers from the second budget calculation requirement, and re-calls the second reference code corresponding to each second formula identifier in the formula code library, combines each second reference code to obtain a second target code, calculates the second target budget based on the first target data and the second target code, and compares the second target budget with the reference budget to obtain a new target comparison result; when the change content is second data description information, that is, the basic data used to calculate the target budget of the historical financial project changes, the second target data corresponding to the second data description information is obtained in the database, and based on the first target data and the second target code, the second target budget is calculated. The second target data and the first target code are used to calculate a third target budget, and the third target budget is compared with the reference budget to obtain a new target comparison result; when the change content includes the second data description information and the second budget calculation requirement, that is, the budget calculation method of the historical financial project and the basic data used to calculate the target budget are changed, the second target data corresponding to the second data description information is obtained from the database again, multiple second formula identifiers are obtained from the second budget calculation requirement, the second reference code corresponding to each second formula identifier is called again in the formula code library, and each second reference code is combined to obtain the second target code, and the fourth target budget is calculated based on the second target data and the second target code, and the fourth target budget is compared with the reference budget to obtain a new target comparison result.

[0083] Additionally, in some embodiments, executing Figure 1 After step S40, the database-based financial budget comparison method of the embodiment of the present application further includes but is not limited to the following steps:

[0084] Step S44, obtaining a target difference from the target comparison result, wherein the target difference is the difference between the target budget and the reference budget;

[0085] Step S45, when the target difference exceeds the preset difference threshold, an alarm message is generated based on the target budget, the reference budget and the target difference, the alarm message is sent to the financial system, and displayed on the visual interface;

[0086] Step S46, when the target difference does not exceed the preset difference threshold, the target comparison result is sent to the financial system and displayed on the visualization interface.

[0087] It is understandable that since the target comparison results are used to quickly identify and process data inconsistencies for financial personnel, and provide effective support for improving the timeliness and effectiveness of financial decisions, after the target component calculates the target comparison results between the target budget and the reference budget of the financial project, the target difference between the target budget and the reference budget is obtained from the target comparison results, and the target difference is compared with the preset difference threshold. When the target difference does not exceed the preset difference threshold, the target comparison results are sent to the financial system and displayed on the visual interface; when the target difference exceeds the preset difference threshold, it means that the corresponding financial project is significantly different from the expected conditions and needs to be paid attention to. At this time, an alarm message is generated based on the target budget, reference budget and target difference, and the alarm message is sent to the financial system, which can prompt the financial personnel to take countermeasures in time.

[0088] like Figure 3 As shown, Figure 3 : is a structural diagram of a control device provided by an embodiment of the present application. The present invention also provides a control device 300, including:

[0089] The processor 310 may be implemented by a general-purpose central processing unit (CPU), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of the present application;

[0090] The memory 320 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 320 can store an operating system and other application programs. When the technical solution provided in the embodiment of this specification is implemented by software or firmware, the relevant program code is stored in the memory 320, and the processor 310 calls and executes the database-based financial budget comparison method of the embodiment of this application;

[0091] Input / output interface 330, used to implement information input and output;

[0092] Communication interface 340, used to realize communication interaction between the apparatus and other devices, which can be realized by wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.);

[0093] bus 350 , which transmits information between the various components of the device (e.g., processor 310 , memory 320 , input / output interface 330 , and communication interface 340 );

[0094] The processor 310 , the memory 320 , the input / output interface 330 and the communication interface 340 are connected to each other in communication within the device via the bus 350 .

[0095] In addition, an embodiment of the present application further provides an electronic device, including the control device 700 of the above embodiment.

[0096] In addition, an embodiment of the present application further provides a storage medium, which is a computer-readable storage medium and stores a computer program. When the computer program is executed by a processor, the above-mentioned database-based financial budget comparison method is implemented.

[0097] As a non-transient computer-readable storage medium, the memory can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage devices. In some embodiments, the memory may optionally include a memory remotely arranged relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned networks include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and a combination thereof. The device embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and are implemented to be located in one place, or may also be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the present embodiment.

[0098] It will be appreciated by those skilled in the art that all or some of the steps and systems in the methods disclosed above may be implemented as software, firmware, hardware, and appropriate combinations thereof. Some or all physical components may be implemented as software executed by a processor, such as a central processing unit, a digital signal processor, or a microprocessor, or as hardware, or as an integrated circuit, such as an application-specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or non-transitory medium) and a communication medium (or transient medium). As known to those skilled in the art, the term computer storage medium includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information (such as computer-readable instructions, data structures, program modules, or other data). Computer storage media include, but are not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disk (DVD) or other optical disk storage, magnetic cassettes, magnetic tapes, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store desired information and can be accessed by a computer. Furthermore, it is well known to those skilled in the art that communication media typically include computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media.

[0099] The above is a specific description of the preferred implementation of the present invention, but the present invention is not limited to the above-mentioned implementation mode. Technical personnel familiar with the field can also make various equivalent deformations or substitutions under the shared conditions without violating the spirit of the present invention. These equivalent deformations or substitutions are all included in the scope defined by the claims of the present invention.

Claims

1. A financial budget comparison method based on a database, characterized in that: Applied to a target component, the target component is respectively connected to a database and a financial system for communication, the target component has a built-in formula code library, the formula code library includes a plurality of formula codes, and the method includes: receiving a first budget mapping table sent by the financial system, wherein the first budget mapping table is used to indicate a mapping relationship between a financial project, a reference budget, first data description information, and a first budget calculation requirement, the reference budget is a preset budget of the financial project, the first data description information represents reference data for calculating a target budget, and the first budget calculation requirement includes a plurality of first formula identifiers; Matching the first data description information with each reference data description information in a data identifier mapping table, determining the data identifier corresponding to the successfully matched reference data description information as the target data identifier of the first data description information, and acquiring the target data corresponding to the target data identifier from the database, wherein the data identifier mapping table is used to indicate the mapping relationship between the data identifier and the reference data description information; Invoking each first reference code corresponding to each first formula identifier in the formula code library, combining each first reference code to obtain a first target code, and calculating the target budget based on the target data and the first target code; Comparing the target budget with the reference budget to obtain a target comparison result; The financial system displays a visualization interface, which includes a plurality of first fields, a plurality of second fields, and a plurality of input boxes, wherein different first fields are used to uniquely identify different financial items, the second fields include a plurality of different formula identifiers and a plurality of different operators, and each input box is used to receive the first data description information input by a user, and the first budget mapping table is generated according to the following steps: In response to the user's association operation between each of the first fields and multiple target fields and the input box, each of the first fields, the reference budget corresponding to each of the first fields, the first data description information, and the target field are acquired, wherein the target field is selected by the user from the multiple formula identifiers and the multiple operators; Generate the first budget calculation requirement based on the target field corresponding to the first field, establish a mapping relationship between each of the first fields, each of the corresponding reference budgets, each of the first data description information and the first budget calculation requirement, and generate each first record; The first budget mapping table is generated according to all the first records.

2. The database-based financial budget comparison method according to claim 1, characterized in that: The first budget calculation requirement further includes a plurality of operators, each of the operators is arranged alternately with each of the first formula identifiers, each of the first reference codes includes an input statement, an operation statement, and an output statement, the number of the target data is multiple, each of the target data corresponds to a different data type, each of the first reference codes is combined to obtain a first target code, and the target budget is calculated based on the target data and the first target code, including: Merging all the input statements corresponding to the first reference codes to obtain a target input statement, wherein the target input statement corresponds to a plurality of target input parameters, and different target input parameters correspond to target data of different data types; Obtaining sorting information between the operator and the first formula identifier in the first budget calculation requirement, and merging the operation statements corresponding to all the first reference codes based on the sorting information to obtain a target operation statement; Merging the output statements corresponding to all the first reference codes to obtain a target output statement; Combining the target input statement, the target operation statement and the target output statement to obtain the first target code; Substituting each of the target data into each of the target input parameters corresponding to the target input statement, and performing operations on all of the target data through the target operation statement to obtain the target budget; The target budget is outputted through the target output statement.

3. The database-based financial budget comparison method according to claim 1, characterized in that: After comparing the target budget with the reference budget to obtain a target comparison result, the method further includes: When receiving the second budget mapping table sent by the financial system, comparing the second budget mapping table with the first budget mapping table to obtain a comparison result; When the comparison result indicates that the second budget mapping table is inconsistent with the first budget mapping table, obtaining change content from the comparison result, wherein the change content includes a second budget calculation requirement and / or second data description information corresponding to the same financial item; The target comparison result is recalculated based on the changed content.

4. The database-based financial budget comparison method according to claim 3 is characterized in that: Recalculating the target comparison result based on the changed content includes: When the change content is the second budget calculation requirement, multiple second formula identifiers are obtained from the second budget calculation requirement, second reference codes corresponding to each second formula identifier are called again in the formula code library, each second reference code is combined to obtain a second target code, a second target budget is calculated based on the first target data and the second target code, and the second target budget is compared with the reference budget to obtain a new target comparison result; When the changed content is the second data description information, second target data corresponding to the second data description information is obtained in the database, a third target budget is calculated based on the second target data and the first target code, and the third target budget is compared with the reference budget to obtain a new target comparison result; When the change content includes the second data description information and the second budget calculation requirement, the second target data corresponding to the second data description information is re-acquired from the database, multiple second formula identifiers are obtained from the second budget calculation requirement, the second reference code corresponding to each second formula identifier is re-called in the formula code library, each second reference code is combined to obtain a second target code, a fourth target budget is calculated based on the second target data and the second target code, and the fourth target budget is compared with the reference budget to obtain a new target comparison result.

5. The database-based financial budget comparison method according to claim 3, characterized in that: After comparing the target budget with the reference budget to obtain a target comparison result, the method further includes: Acquire a target difference from the target comparison result, wherein the target difference is a difference between the target budget and the reference budget; When the target difference exceeds a preset difference threshold, an alarm message is generated based on the target budget, the reference budget and the target difference, the alarm message is sent to the financial system, and displayed on the visualization interface; When the target difference does not exceed the preset difference threshold, the target comparison result is sent to the financial system and displayed on the visualization interface.

6. A control device, characterized in that: It includes at least one control processor and a memory for communicating with the at least one control processor; the memory stores instructions that can be executed by the at least one control processor, and the instructions are executed by the at least one control processor to enable the at least one control processor to execute the database-based financial budget comparison method as described in any one of claims 1 to 5.

7. An electronic device, characterized in that: Includes the control device as claimed in claim 6.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute the database-based financial budget comparison method according to any one of claims 1 to 5.

Images