Scientific research project fund management method and system, electronic equipment and storage medium

Abstract

The invention provides a scientific research project fund management method and system, electronic equipment and a storage medium, and the method comprises the steps: obtaining a mapping relation between a project fund subject category in a project contract text and an accounting subject category set by a financial software system, determining a real-time mapping relationship between the completion period of the expenditure activity of each accounting subject of the unit and the accounting subject category; based on the mapping relationship and the real-time mapping relationship, determining an expenditure progress plan of each expenditure subject of the project; correcting the expenditure progress plan based on the actual expenditure sequence progress of each fund subject of the project, the progress when the fund execution sequence of the same kind of project is researched and the progress when the fund comparable execution sequence of the same kind of project is settled so as to obtain a corrected expenditure progress plan; and in response to the operation of inputting the project order time arrival value and the stage project funding subject expenditure proportion target value in the revised expenditure progress plan, the expenditure amount target value of each funding subject stage of the project is obtained, and the efficiency and accuracy of scientific research project funding management are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of scientific research project management, and in particular to a scientific research project fund management method, system, electronic equipment and storage medium. Background Art

[0002] The existing scientific research project funding management system generally controls the budget of scientific research projects on an annual basis. The short-term or phased project funding execution plan needs to be determined by human judgment. Some management systems will issue early warning reminders to relevant personnel based on the execution situation. It may happen that the early warning time is too late, resulting in the project leader being unable to adjust the budget in time, affecting the progress of project funding execution. The existing scientific research project funding system mainly adopts the principle of expenditure based on revenue. If the collection is not timely, the progress of project funding execution will also be affected.

[0003] In order to improve the efficiency of scientific research project funding management, it is of great engineering significance and application value to develop a scientific research project funding management system that can correctly describe the expenditure of scientific research project funds, accurately predict the pattern of scientific research project funding expenditure, and propose a phased plan for scientific research project funding expenditure. Summary of the invention

[0004] The present invention provides a scientific research project fund management method, system, electronic equipment and storage medium, which are used to solve the defects of the existing scientific research project fund management system in the prior art that it is difficult to accurately describe the expenditure rules of scientific research project funds and difficult to obtain a reasonable scientific research project phased fund execution plan, so as to achieve the purpose of improving the efficiency of scientific research project fund management.

[0005] The present invention provides a method for managing scientific research project funds, comprising the following steps: Obtaining a first mapping relationship between the project funding category in the project contract text and the accounting category set by the financial software system, and determining a second real-time mapping relationship between the completion cycle of the unit's various accounting category funding expenditure activities and the accounting category; Determine the expenditure schedule of each funding item of the project based on the first mapping relationship and the second real-time mapping relationship; Based on the actual expenditure chronological progress of each funding item of the project, the chronological progress of the funds of similar projects under research, and the comparable chronological progress of the funds of similar completed projects, the expenditure schedule is revised to obtain a revised expenditure schedule for each funding item of the project; In response to the operation of inputting the project sequence payment value and the target value of the expenditure ratio of the stage project funding items in the revised expenditure schedule, the target value of the stage expenditure amount of each funding item of the project is obtained.

[0006] According to a scientific research project funding management method provided by the present invention, the first mapping relationship between the project funding subject category in the project contract text and the accounting subject category set by the financial software system is obtained, including: The account category mapping rules are obtained, and based on the account category mapping rules, the original funding accounts in the project funding estimate table in the contract text are reclassified with the accounting accounts set by the financial software system as the target accounts to obtain the first mapping relationship.

[0007] According to a scientific research project fund management method provided by the present invention, the second real-time mapping relationship between the completion cycle of the fund expenditure activities of each accounting subject of the unit and the accounting subject category includes: Read all process data of the unit in the financial software system; Based on all the process data of the unit, the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting is fitted to obtain the second real-time mapping relationship.

[0008] According to a method for managing scientific research project funds provided by the present invention, based on the entire process data of the unit, the time taken for the expenditure activities of each accounting subject of the unit from initiating the expenditure application to completing the bookkeeping is fitted to obtain the second real-time mapping relationship, including: Based on all the process data of the unit, the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting is fitted using the least squares method to obtain the second real-time mapping relationship.

[0009] According to a method for managing scientific research project funds provided by the present invention, the expenditure schedule is revised based on the actual expenditure chronological progress of each fund item of the project, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for completed similar projects, to obtain a revised expenditure schedule for each fund item of the project, including: The actual expenditure chronological progress of each funding item of the project, the expenditure schedule, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for completed similar projects are input into the four-parameter Prophet model to obtain the revised expenditure schedule output by the four-parameter Prophet model.

[0010] According to a method for managing scientific research project funds provided by the present invention, the chronological progress of funds for similar projects under research is the ratio of the cumulative expenditure of funds for similar projects under research to the total project funds; the comparable chronological progress of funds for completed similar projects is the ratio of the cumulative expenditure of funds for completed similar projects corresponding to the current chronological progress ratio to the total project funds.

[0011] The present invention also provides a scientific research project fund management system, comprising the following units: An acquisition unit is used to acquire a first mapping relationship between the project funding category in the project contract text and the accounting category set by the financial software system, and determine a second real-time mapping relationship between the completion cycle of the unit's various accounting category funding expenditure activities and the accounting category; A determination unit, configured to determine the expenditure schedule of each funding item of the project based on the first mapping relationship and the second real-time mapping relationship; A correction unit is used to correct the expenditure schedule based on the actual expenditure chronological progress of each funding item of the project, the execution chronological progress of funds of similar projects under research, and the comparable execution chronological progress of funds of similar projects that have been completed, so as to obtain a corrected expenditure schedule for each funding item of the project; The response unit is used to respond to the operation of inputting the project sequence payment value and the stage project funding account expenditure ratio target value in the revised expenditure schedule, and obtain the stage expenditure amount target value of each funding account of the project.

[0012] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, a scientific research project funding management method as described above is implemented.

[0013] The present invention also provides a non-transitory computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, it implements any of the above-mentioned scientific research project funding management methods.

[0014] The present invention also provides a computer program product, including a computer program, which, when executed by a processor, implements any of the above-mentioned scientific research project fund management methods.

[0015] The scientific research project fund management method, system, electronic equipment and storage medium provided by the present invention can intelligently correct the expenditure plan progress of each fund item of the project, and obtain the execution time progress of the revised project fund items. When the project time arrival value and the target value of the expenditure ratio of the stage project fund items are certain, the scientific research project fund management system can automatically output the stage expenditure plan of each fund item of the project, so as to correctly describe the expenditure situation of scientific research project funds, accurately predict the expenditure law of scientific research project funds, obtain a reasonable stage-by-stage fund execution plan of the scientific research project, and improve the efficiency and accuracy of scientific research project fund management. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0017] Figure 1 It is a flow chart of the scientific research project fund management method provided by the present invention.

[0018] Figure 2 It is a structural diagram of the scientific research project fund management system provided by the present invention.

[0019] Figure 3 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0020] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with the drawings of the present invention. Obviously, the described embodiments are 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.

[0021] The terms "first", "second", etc. in the present invention are used to distinguish similar objects, rather than to describe a specific order or precedence. It should be understood that the terms used in this way can be interchangeable where appropriate, so that the embodiments of the present application can be implemented in an order other than those illustrated or described herein, and the objects distinguished by "first", "second", etc. are generally of the same type.

[0022] Among the relevant technologies, technologies or service projects with scientific research value obtained by enterprises from functional departments or other funding channels for the development of high-tech projects, high-tech product development, high-tech consulting, etc. are scientific research projects.

[0023] The model adopted by enterprises in the management of scientific research project funds is the budget management model. If the type of scientific research project budget support is used as the basis, the funds can be divided into two types: direct and indirect expenditures. Direct expenditures include equipment costs, material costs, travel expenses and other expenses, while indirect operating expenses are mainly corporate unit management expenses and performance expenses.

[0024] The allocation of research project funds is usually led by the project leader. The research project funds proposed by enterprises during the project establishment stage may not be fully approved, so the specific research project funds obtained will deviate greatly from the budget. However, some enterprises have not yet established a complete fund management plan or have not strictly managed funds in accordance with the plan when carrying out research projects, which will lead to various situations such as budgets without expenditures, expenditures without budgets, and mismatch between fund use and research progress. In the actual implementation process, the most common unreasonable fund expenditure situation is that the research project is nearing completion but there is still a large amount of research funds left, or the preparation work for the research project has been completed, but the research funds have not been allocated, thus affecting the progress of the research project.

[0025] In the information age, the management of scientific research project funds also needs to adapt to the development of the times. Relying on the current endless information technology advantages and information-based financial management platforms, a professional scientific research project fund information management platform and system is constructed, so that the time, flow, progress of scientific research projects, fund balances, etc. of each fund expenditure involved in the scientific research project can be queried in the corresponding system, ensuring the transparency of scientific research project fund management; it can also use powerful Internet, big data and other advanced technologies to efficiently coordinate and store scientific research project fund management and various scientific research project data, providing guarantees for the smooth development of scientific research project work; at the same time, it can also refer to historical data in the management system or summarize experience from the management system data when carrying out scientific research projects in the later stage, providing important basis for the company's subsequent scientific research project work.

[0026] At present, many scientific research project undertaking units have established scientific research project funding information management systems, which mainly control funding expenditures based on financial software system data such as project budgets and chronological expenditures. Each unit has set up funding accounts according to the accounting system implemented by the unit. When the funding sources are different, the funding management methods for project budget execution are also different. The funding accounts set up in the financial software system cannot correspond one to one with the funding accounts in the project contract funding budget, resulting in serious deviations from the original budget for some funding accounts, affecting the quality of project funding execution.

[0027] The existing scientific research project funding management system generally controls the budget of scientific research projects on an annual basis. The short-term or phased project funding execution plan needs to be determined by human judgment. Some management systems will issue early warning reminders to relevant personnel based on the execution situation. It may happen that the early warning time is too late, resulting in the project leader being unable to adjust the budget in time, affecting the progress of project funding execution. The existing scientific research project funding system mainly adopts the principle of expenditure based on revenue. If the collection is not timely, the progress of project funding execution will also be affected.

[0028] Based on the above problems, in order to improve the efficiency of scientific research project fund management, the present invention provides a scientific research project fund management method. Figure 1 It is a flow chart of the scientific research project fund management method provided by the present invention, such as Figure 1 As shown, the method includes step 110, step 120, step 130 and step 140.

[0029] Step 110, obtaining a first mapping relationship between the project funding category in the project contract text and the accounting category set by the financial software system, and determining a second real-time mapping relationship between the completion cycle of each accounting category funding expenditure activity of the unit and the accounting category.

[0030] Specifically, the first mapping relationship between the project funding account category in the project contract text and the accounting account category set by the financial software system can be obtained, and the second real-time mapping relationship between the completion cycle of the unit's accounting account funding expenditure activities and the accounting account category can be determined.

[0031] Among them, the project funding account categories in the project contract text may include material costs, labor costs, equipment purchase costs, etc., and the embodiment of the present invention does not specifically limit this.

[0032] The accounting subject categories set by the financial software system may include asset categories, liability categories, cost categories, expense categories, etc., which are not specifically limited in the embodiment of the present invention.

[0033] Furthermore, a mapping relationship between project funding accounts and financial software accounting accounts can be established based on their accounting content and scope.

[0034] For example, "material costs" in the project funding account category in the project contract text can be mapped to cost accounts such as "raw materials" or "inventory" in the accounting account category of the financial software system; "labor costs" can be mapped to expense accounts such as "employee wages payable" or "labor costs".

[0035] Here, the completion cycle of the expenditure activities of each accounting account of the unit is defined according to the actual situation of the unit, such as monthly, quarterly, annual, etc.

[0036] Consider the characteristics and patterns of expenditure activities in different accounting items. For example, daily expenses may be settled on a monthly basis, while purchases of large equipment may be settled on a project cycle.

[0037] For example, for the "Employee Salaries Payable" account, you can track the monthly salary payments in real time and establish a mapping relationship between the monthly expenditure activity completion cycle and the account; for the "Equipment Purchase Expenses" account, you can track the equipment purchases for each project and establish a mapping relationship between the project cycle and the accounting account.

[0038] It can be understood that obtaining the first mapping relationship between the project funding account categories in the project contract text and the accounting account categories set up in the financial software system, and determining the second real-time mapping relationship between the completion cycle of the unit's accounting account expenditure activities and the accounting account categories, can help the unit better manage project funds and improve the efficiency and accuracy of scientific research project funding management.

[0039] Step 120: Determine the expenditure schedule for each funding item of the project based on the first mapping relationship and the second real-time mapping relationship.

[0040] Specifically, after the first mapping relationship and the second real-time mapping relationship are obtained, the expenditure schedule of each funding item of the project can be determined based on the first mapping relationship and the second real-time mapping relationship.

[0041] For example, if the total budget for "equipment purchase costs" is 1.2 million yuan, the planned expenditure for each expenditure cycle (6 months) in the expenditure schedule is 200,000 yuan.

[0042] For example, if the total budget for "staff salaries" is 2.4 million yuan (annual salary system), then the planned expenditure for each expenditure cycle (1 month) in the expenditure schedule is 200,000 yuan.

[0043] Step 130, based on the actual expenditure chronological progress of each funding item of the project, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for similar projects that have been completed, the expenditure schedule is revised to obtain a revised expenditure schedule for each funding item of the project.

[0044] Specifically, the data in the financial software system is read to obtain the chronological progress of actual expenditures of each funding item of the project, the chronological progress of funding execution of similar projects under research, and the comparable chronological progress of funding execution of completed similar projects.

[0045] After obtaining the actual expenditure chronological progress of each funding item of the project, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for completed similar projects, the expenditure schedule can be revised based on the actual expenditure chronological progress of each funding item of the project, and the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for completed similar projects to obtain the revised expenditure schedule for each funding item of the project.

[0046] Here, based on the actual expenditure chronological progress of each funding item of the project, the chronological progress of the execution of funds for similar projects under research, and the comparable chronological progress of the execution of funds for similar projects that have been completed, the expenditure schedule is revised to obtain a revised expenditure schedule for each funding item of the project. A four-parameter Prophet model may be used, or an ARIMA (Autoregressive Integrated Moving Average Model), or an LSTM (Long Short-Term Memory) may be used, and this is not specifically limited in the embodiment of the present invention.

[0047] The Prophet model is a time series forecasting model that uses a flexible framework to achieve accurate forecasts of different time series through simple parameter adjustments. The Prophet model decomposes the time series into four main components: trend, seasonality, holiday effect, and noise. Among them, the trend represents the long-term trend of the time series, seasonality represents the pattern of periodic changes, the holiday effect refers to the impact on special dates or time periods, and noise is a random change that cannot be predicted.

[0048] Step 140, in response to the operation of inputting the project sequence payment value and the stage project funding account expenditure ratio target value in the revised expenditure schedule, obtains the stage expenditure amount target value of each funding account of the project.

[0049] Specifically, since the revised expenditure schedule covers the information of each project funding item, expenditure amount, and expenditure time, after the expenditure schedule is revised to obtain the revised expenditure schedule, the target value of the stage expenditure amount of each project funding item can be obtained in response to the operation of inputting the project sequence time payment value and the stage project funding item expenditure ratio target value in the revised expenditure schedule.

[0050] It is understandable that when the project sequence and the target value of the expenditure ratio of the project funding items are certain, the scientific research project funding management system can automatically output the phase expenditure plan of each funding item of the project. It is used to solve the problem that the existing scientific research project funding management system is difficult to accurately understand the expenditure rules of scientific research project funds and difficult to obtain a reasonable phased funding execution plan for scientific research projects, so as to achieve the purpose of improving the efficiency of scientific research project funding management.

[0051] The method provided by the embodiment of the present invention obtains a first mapping relationship between the project funding account category in the project contract text and the accounting account category set by the financial software system, and determines a second real-time mapping relationship between the completion cycle of the unit's funding expenditure activities and the accounting account category, and then determines the expenditure schedule of each funding account of the project based on the first mapping relationship and the second real-time mapping relationship; based on the actual expenditure chronological progress of each funding account of the project, the chronological progress of the execution of funds for similar projects under research, and the comparable chronological progress of the execution of funds for similar projects that have been completed, the expenditure schedule is revised to obtain a revised expenditure schedule for each funding account of the project; finally, in response to the operation of inputting the project chronological payment value and the target value of the expenditure ratio of the stage project funding account in the revised expenditure schedule, the target value of the stage expenditure amount of each funding account of the project is obtained. This process intelligently corrects the expenditure plan progress of each funding item of the project to obtain the revised chronological progress of each funding item of the project. When the project chronological payment value and the target value of the expenditure ratio of the stage project funding items are certain, the scientific research project funding management system can automatically output the stage expenditure plan of each funding item of the project, so as to correctly describe the expenditure situation of scientific research project funds, accurately predict the expenditure pattern of scientific research project funds, obtain a reasonable stage-by-stage funding execution plan for scientific research projects, and improve the efficiency and accuracy of scientific research project funding management.

[0052] Based on the above embodiment, the step of obtaining the first mapping relationship between the project fund account category in the project contract text and the accounting account category set by the financial software system in step 110 includes: Step 111, obtain the account category mapping rules, and based on the account category mapping rules, reclassify the original funding accounts in the project funding estimate table in the contract text with the accounting accounts set by the financial software system as the target accounts to obtain the first mapping relationship.

[0053] Specifically, the account category mapping rules refer to the rules for matching and associating the project funding account categories in the project contract text with the accounting accounts in the financial software system. These rules ensure that the project funding account category data can be accurately recorded and classified into the financial software system, thereby supporting the company's financial management and decision-making.

[0054] Therefore, based on the account category mapping rules, the original funding accounts in the project funding estimate table in the contract text are reclassified with the accounting accounts set by the financial software system as the target accounts to obtain the first mapping relationship.

[0055] Based on the above embodiment, the second real-time mapping relationship between the completion period of the expenditure activities of each accounting subject of the unit and the accounting subject category in step 110 includes: Step 210, reading all process data of the unit in the financial software system; Step 220, based on all the process data of the unit, fit the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting, and obtain the second real-time mapping relationship.

[0056] Specifically, first, read all the unit's process data in the financial software system. It can be understood that all the unit's process data covers the unit's various accounting items' expenditure activity completion cycle and accounting item categories and other data.

[0057] Therefore, based on all the process data of the unit, the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting can be fitted to obtain the second real-time mapping relationship.

[0058] Here, based on all the process data of the unit, the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting is fitted using the least squares method to obtain the second real-time mapping relationship.

[0059] Here, the least squares method is a classic method for data fitting and parameter estimation, and is often used to find an optimal curve or straight line so that the sum of the squares of the distances from the points on the curve or straight line to the actual data points is minimized.

[0060] For example, each accounting account can be uniquely coded to facilitate identification and classification in the financial software system. The coding can be designed based on the hierarchical structure of accounting accounts (such as primary accounts, secondary accounts, etc.).

[0061] The specific fitting process can be to construct a linear regression model based on the unit's entire process data and then use the least squares method to solve the regression coefficient, or to construct a polynomial regression model based on the unit's entire process data and then use the least squares method to solve the regression coefficient. It can also be based on the unit's entire process data. The logarithmic regression model is constructed and then the least squares method is used to solve the regression coefficient, etc., and the selection is made according to the specific actual scenario, and the embodiments of the present invention do not make specific limitations on this.

[0062] Then, the obtained regression coefficients are used to calculate the model's fitting results for the data, i.e., the predicted completion cycle.

[0063] In addition, statistical indicators such as R-squared and mean squared error (MSE) can be used to evaluate the model fitting effect, and residual analysis can be performed to check whether there are obvious deviations or outliers in the model.

[0064] Here, spline interpolation, multi-layer perceptron, convolutional neural network and other methods may also be used to fit the time taken for the unit's various accounting items' expenditure activities from initiating expenditure application to completing bookkeeping, which is not specifically limited in this embodiment of the present invention.

[0065] Based on the above embodiment, step 130 includes: Step 131, input the actual expenditure chronological progress of each funding item of the project, the expenditure schedule, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for similar projects that have been completed into the four-parameter Prophet model to obtain the revised expenditure schedule output by the four-parameter Prophet model.

[0066] Specifically, in order to better intelligently correct the expenditure schedule, the expenditure schedule can be corrected with the help of a model. The actual expenditure chronological progress of each funding item of the project, the expenditure schedule, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for completed similar projects can be input into the four-parameter Prophet model to obtain the corrected expenditure schedule output by the four-parameter Prophet model.

[0067] That is, the revised expenditure schedule = p(parameter 1, parameter 2, parameter 3, parameter 4)

[0068] Among them, parameter 1, parameter 2, parameter 3, and parameter 4 respectively represent the actual expenditure chronological progress of each funding item of the project, the expenditure progress plan, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for similar projects that have been completed, and p represents the four-parameter Prophet model.

[0069] It should be noted that before these data are input into the four-parameter Prophet model, data cleaning can be performed to ensure the accuracy, completeness and consistency of the data, handle missing values, outliers or duplicate data, and format the data, that is, organize the data into a format suitable for Prophet model input, usually including a timestamp (date) and the corresponding expenditure value.

[0070] Among them, the chronological progress of actual expenditure of each funding item of the project reflects the consumption of project funds in the actual implementation process and is a true reflection of the current status of the project.

[0071] An expenditure schedule is a funding plan developed before a project starts or during its execution to guide the allocation and use of funds.

[0072] By comparing the actual expenditure sequence with the expenditure schedule, we can promptly discover deviations in the project execution process, evaluate whether the project is proceeding according to the predetermined plan, and take appropriate adjustment measures.

[0073] Among them, the chronological progress of funds for similar projects under research is the ratio of the cumulative expenditure of funds for similar projects under research to the total project funds, and the comparable chronological progress of funds for completed similar projects is the ratio of the cumulative expenditure of funds for completed similar projects at the current chronological progress ratio to the total project funds.

[0074] The chronological progress of the funds for similar projects under development provides the use of funds for other projects similar to the current project during their implementation.

[0075] The comparable execution schedule of funds for completed similar projects reflects the use of funds and the final results of the completed projects.

[0076] These two data provide valuable reference experience for the current project. Through comparison and analysis, we can understand the funding usage rules, possible problems and solutions of similar projects, and provide useful reference for the funding management of the current project.

[0077] In summary, the use of these four data is of great significance for project funding management. They not only help to evaluate the consistency between the current status of the project and the plan, but also provide the project with experience reference of similar projects, improve the accuracy of the forecasting model, and ultimately optimize project funding management.

[0078] The scientific research project funding management system provided by the present invention is described below. The scientific research project funding management system described below and the scientific research project funding management method described above can be referenced to each other.

[0079] Based on any of the above embodiments, the present invention provides a scientific research project funding management system. Figure 2 It is a structural diagram of the scientific research project funding management system provided by the present invention. Figure 2 As shown, the system includes: The acquisition unit 210 is used to acquire a first mapping relationship between the project funding category in the project contract text and the accounting category set by the financial software system, and determine a second real-time mapping relationship between the completion period of the unit's various accounting category funding expenditure activities and the accounting category; A determination unit 220, configured to determine a spending schedule for each funding item of a project based on the first mapping relationship and the second real-time mapping relationship; The correction unit 230 is used to correct the expenditure schedule based on the actual expenditure chronological progress of each funding item of the project, the execution chronological progress of funds of similar projects under research, and the comparable execution chronological progress of funds of similar projects that have been completed, so as to obtain a corrected expenditure schedule of each funding item of the project; The response unit 240 is used to respond to the operation of inputting the project sequence payment value and the stage project funding account expenditure ratio target value in the revised expenditure schedule, and obtain the stage expenditure amount target value of each funding account of the project.

[0080] The system provided by the embodiment of the present invention can intelligently correct the expenditure plan progress of each funding item of the project, and obtain the revised chronological progress of each funding item of the project. When the project chronological payment value and the target value of the expenditure ratio of the stage project funding items are certain, the scientific research project funding management system can automatically output the stage expenditure plan of each funding item of the project, so as to correctly describe the expenditure situation of scientific research project funds, accurately predict the expenditure rules of scientific research project funds, obtain a reasonable stage-by-stage funding execution plan for scientific research projects, and improve the efficiency and accuracy of scientific research project funding management.

[0081] Based on any of the above embodiments, the acquisition unit 210 is specifically configured to: The account category mapping rules are obtained, and based on the account category mapping rules, the original funding accounts in the project funding estimate table in the contract text are reclassified with the accounting accounts set by the financial software system as the target accounts to obtain the first mapping relationship.

[0082] Based on any of the above embodiments, the acquisition unit 210 is specifically configured to: A reading unit, used to read all process data of the unit in the financial software system; The fitting unit is used to fit the time taken for the expenditure activities of each accounting subject of the unit from initiating the expenditure application to completing the accounting based on all the process data of the unit, so as to obtain the second real-time mapping relationship.

[0083] Based on any of the above embodiments, the fitting unit is specifically used for: Based on all the process data of the unit, the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting is fitted using the least squares method to obtain the second real-time mapping relationship.

[0084] Based on any of the above embodiments, the correction unit 230 is specifically configured to: The actual expenditure chronological progress of each funding item of the project, the expenditure schedule, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for completed similar projects are input into the four-parameter Prophet model to obtain the revised expenditure schedule output by the four-parameter Prophet model.

[0085] Based on any of the above embodiments, the chronological progress of funds for similar projects under research is the ratio of the cumulative expenditure of funds for similar projects under research to the total project funds; the comparable chronological progress of funds for completed similar projects is the ratio of the cumulative expenditure of funds for completed similar projects corresponding to the current chronological progress ratio to the total project funds.

[0086] Figure 3 is a schematic diagram of the structure of the electronic device provided by the present invention, such as Figure 3 As shown, the electronic device may include: a processor 310 , a communications interface 320 , a memory 330 and a communication bus 340 , wherein the processor 310 , the communications interface 320 , and the memory 330 communicate with each other via the communication bus 340 . The processor 310 can call the logic instructions in the memory 330 to execute the scientific research project funding management method, which includes: obtaining a first mapping relationship between the project funding account category in the project contract text and the accounting account category set by the financial software system, and determining a second real-time mapping relationship between the completion cycle of the unit's accounting account expenditure activities and the accounting account category; based on the first mapping relationship and the second real-time mapping relationship, determining the expenditure schedule for each funding account of the project; based on the actual expenditure chronological progress of each funding account of the project, the chronological progress of the execution of funds for similar projects under research, and the comparable chronological progress of the execution of funds for similar projects that have been completed, revising the expenditure schedule to obtain a revised expenditure schedule for each funding account of the project; in response to the operation of inputting the project chronological payment value and the stage project funding account expenditure ratio target value in the revised expenditure schedule, obtaining the stage expenditure amount target value for each funding account of the project.

[0087] In addition, the logic instructions in the above-mentioned memory 330 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is 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, and the computer software product is stored in a storage medium, including a number of 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: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0088] On the other hand, the present invention also provides a computer program product, which includes a computer program, which can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute the scientific research project funding management method provided by the above-mentioned methods, which includes: obtaining a first mapping relationship between the project funding account category in the project contract text and the accounting account category set by the financial software system, and determining a second real-time mapping relationship between the completion cycle of the unit's accounting account expenditure activities and the accounting account category; based on the first mapping relationship and the second real-time mapping relationship, determining the expenditure schedule for each funding account of the project; based on the actual expenditure chronological progress of each funding account of the project, the chronological progress of the execution of funds for similar projects under research, and the comparable chronological progress of the execution of funds for similar projects that have been completed, revising the expenditure schedule to obtain a revised expenditure schedule for each funding account of the project; in response to the operation of inputting the project chronological payment value and the stage project funding account expenditure ratio target value in the revised expenditure schedule, obtaining the stage expenditure amount target value for each funding account of the project.

[0089] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to execute the scientific research project funding management method provided by the above-mentioned methods, the method comprising: obtaining a first mapping relationship between the project funding account category in the project contract text and the accounting account category set by the financial software system, and determining a second real-time mapping relationship between the completion cycle of the unit's accounting account expenditure activities and the accounting account category; determining an expenditure schedule for each funding account of the project based on the first mapping relationship and the second real-time mapping relationship; revising the expenditure schedule based on the actual expenditure chronological progress of each funding account of the project, the chronological progress of the execution of funds for similar projects under research, and the comparable chronological progress of the execution of funds for similar projects that have been completed, to obtain a revised expenditure schedule for each funding account of the project; in response to the operation of inputting the project chronological payment value and the target value of the expenditure ratio of the stage project funding account in the revised expenditure schedule, obtaining the target value of the stage expenditure amount of each funding account of the project.

[0090] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.

[0091] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0092] 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 it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for managing scientific research project funds, characterized in that: include: Obtaining a first mapping relationship between the project funding category in the project contract text and the accounting category set by the financial software system, and determining a second real-time mapping relationship between the completion cycle of the unit's various accounting category funding expenditure activities and the accounting category; Determine the expenditure schedule of each funding item of the project based on the first mapping relationship and the second real-time mapping relationship; Based on the actual expenditure chronological progress of each funding item of the project, the chronological progress of the funds of similar projects under research, and the comparable chronological progress of the funds of similar completed projects, the expenditure schedule is revised to obtain a revised expenditure schedule for each funding item of the project; In response to the operation of inputting the project sequence payment value and the target value of the expenditure ratio of the stage project funding items in the revised expenditure schedule, the target value of the stage expenditure amount of each funding item of the project is obtained.

2. The scientific research project fund management method according to claim 1, characterized in that: The obtaining of a first mapping relationship between a project funding category in the project contract text and an accounting category set by the financial software system includes: The account category mapping rules are obtained, and based on the account category mapping rules, the original funding accounts in the project funding estimate table in the contract text are reclassified with the accounting accounts set by the financial software system as the target accounts to obtain the first mapping relationship.

3. The scientific research project fund management method according to claim 1, characterized in that: The second real-time mapping relationship between the completion period of the expenditure activities of each accounting subject of the determination unit and the accounting subject category includes: Read all process data of the unit in the financial software system; Based on all the process data of the unit, the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting is fitted to obtain the second real-time mapping relationship.

4. The scientific research project fund management method according to claim 3, characterized in that: The method of fitting the time taken for the expenditure activities of each accounting subject of the unit from initiating the expenditure application to completing the bookkeeping based on the entire process data of the unit to obtain the second real-time mapping relationship includes: Based on all the process data of the unit, the time taken for the expenditure activities of each accounting item of the unit from initiating the expenditure application to completing the accounting is fitted using the least squares method to obtain the second real-time mapping relationship.

5. The method for managing scientific research project funds according to any one of claims 1 to 4, characterized in that: Based on the actual expenditure chronological progress of each funding item of the project, the chronological progress of the funds of similar projects under research, and the comparable chronological progress of the funds of similar completed projects, the expenditure schedule is revised to obtain a revised expenditure schedule for each funding item of the project, including: The actual expenditure chronological progress of each funding item of the project, the expenditure schedule, the chronological progress of funds for similar projects under research, and the comparable chronological progress of funds for completed similar projects are input into the four-parameter Prophet model to obtain the revised expenditure schedule output by the four-parameter Prophet model.

6. The method for managing scientific research project funds according to any one of claims 1 to 4, characterized in that: The execution schedule of the funds for similar projects under research is the ratio of the cumulative expenditure of the funds for similar projects under research to the total funds of the projects; The comparable execution sequence progress of funds for completed similar projects is the ratio of the cumulative expenditure of project funds corresponding to the current sequence progress ratio of funds for completed similar projects to the total project funds.

7. A scientific research project fund management system, characterized in that: include: An acquisition unit is used to acquire a first mapping relationship between the project funding category in the project contract text and the accounting category set by the financial software system, and determine a second real-time mapping relationship between the completion cycle of the unit's various accounting category funding expenditure activities and the accounting category; A determination unit, configured to determine the expenditure schedule of each funding item of the project based on the first mapping relationship and the second real-time mapping relationship; A correction unit is used to correct the expenditure schedule based on the actual expenditure chronological progress of each funding item of the project, the execution chronological progress of funds of similar projects under research, and the comparable execution chronological progress of funds of similar projects that have been completed, so as to obtain a corrected expenditure schedule for each funding item of the project; The response unit is used to respond to the operation of inputting the project sequence payment value and the stage project funding account expenditure ratio target value in the revised expenditure schedule, and obtain the stage expenditure amount target value of each funding account of the project.

8. An electronic device comprising 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 scientific research project funding management method as described in any one of claims 1 to 6 is implemented.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by the processor, it implements the scientific research project funding management method as described in 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, it implements the scientific research project funding management method as described in any one of claims 1 to 6.

Images