Automatic pre-settlement auditing method, system, equipment and medium

Abstract

The invention discloses an automatic pre-settlement auditing method, system and device and a medium, and relates to the technical field of pre-settlement management, and the method comprises the steps: judging a first prediction reasonable range of each cost in a pre-settlement project and a second prediction reasonable range of a settlement period according to the obtained related information and auditing rules of the pre-settlement project; according to a preset auditing rule, the first prediction reasonable range and the second prediction reasonable range, generating a cost auditing comparison table for contrasting and auditing the pre-settlement project cost; acquiring a cost change reference range representing a pre-settlement project cost change threshold value, and generating a pre-settlement cost auditing control model according to the cost change reference range and the cost auditing comparison table; acquiring actual pre-settlement data, and inputting the actual pre-settlement data into the pre-settlement expense auditing control model to automatically auditing the pre-settlement project expense; according to the invention, the accuracy of the pre-settlement operation of the project and the cost management efficiency are improved.

Description

Technical Field

[0001] The present application relates to the technical field of pre-settlement management, and in particular to an automatic pre-settlement audit method, system, device and medium. Background Art

[0002] In the management process of engineering projects, preliminary settlement is an important financial management activity, which involves many aspects of the project, such as cost control, budget preparation and expense review. Traditional preliminary settlement management usually relies on manual review, that is, the price verification personnel manually calculate and compare various expenses based on the basic information of the project and market material price data to determine whether the quotation of the supplier or construction unit is reasonable. However, this manual review method has the problems of strong subjectivity, low efficiency and low accuracy. In addition, it is difficult for manual review to update data in real time, resulting in poor accuracy of preliminary settlement results.

[0003] At present, some engineering projects have begun to adopt an automated pre-settlement management system, which can realize automatic comparison and analysis between material price files, but it still has the following shortcomings: Data real-time issues: Market material prices and policies and regulations change frequently, and the system is unable to update these data in real time, resulting in inaccurate preliminary settlement results.

[0004] Ability to handle complex projects: For complex engineering projects, it is difficult for the system to fully cover all details and it is easy to miss important information.

[0005] To sum up, the preliminary settlement work of engineering projects still has the problem of poor accuracy, which makes it difficult to meet the high efficiency requirements of cost management of project preliminary settlement, and needs to be improved. Summary of the invention

[0006] In order to improve the accuracy of project pre-settlement operations and cost management efficiency, the present application provides an automatic pre-settlement audit method, system, device and medium.

[0007] In the first aspect, the invention objective of the present application is achieved by adopting the following technical solutions: The audit methods for automatic pre-settlement include: Obtain relevant information and preset audit rules for the pre-settlement project, and determine a first forecast reasonable range for each expense in the pre-settlement project and a second forecast reasonable range for the settlement period based on the relevant information and the preset audit rules for the pre-settlement project; Generate a cost audit comparison table for checking the pre-settlement project costs according to the preset audit rules, the first forecast reasonable range and the second forecast reasonable range; Acquire a cost change reference range representing a cost change threshold for a pre-settlement item, and generate a pre-settlement cost review control model based on the cost change reference range and the cost review comparison table; The actual pre-settlement data is obtained and input into the pre-settlement expense review control model to automatically review the expense of the pre-settlement item.

[0008] By adopting the above technical solution, the basic information of the project includes the project name, project scale, bill of quantities, material list, equipment list, etc. of each stage; the first predicted reasonable range includes material costs, labor costs, machinery costs and management costs, etc., and the second predicted reasonable range includes the settlement time and settlement frequency of each project stage of the pre-settlement project; through the preset audit rules and predicted reasonable range, a cost audit comparison table is generated to ensure the accuracy and scientificity of the cost audit. The automatically generated cost audit comparison table and pre-settlement cost audit control model automatically audit the actual costs, reduce the workload of manual audit, and improve the efficiency of cost management. According to the reference range of cost changes, it can also assist relevant personnel to timely discover and adjust costs that exceed the reasonable range and optimize cost control; through the cost audit comparison table and pre-settlement cost audit control model, the costs and settlement cycles of each stage are clearly displayed, the transparency of the project is improved, and it is convenient for project managers and relevant personnel to supervise and make decisions. Through real-time monitoring and cost adjustment, it is conducive to timely discovering and solving cost overruns, reducing the risk of project overbudget, and ensuring the smooth progress of the project.

[0009] In a preferred example of the present application, the obtaining of relevant information of the pre-settlement project and the preset audit rules, and judging the first predicted reasonable range of each expense in the pre-settlement project and the second predicted reasonable range of the settlement period according to the relevant information of the pre-settlement project and the preset audit rules, specifically include: Obtain relevant information of the pre-settlement project, including project type, project scale, project location, historical cost data of similar projects, and historical settlement cycle data of similar projects; and obtain preset audit rules, including audit standards for various costs of pre-settlement projects, trigger conditions for cost adjustments, and reference ranges for settlement cycles; Based on the project type, project scale and project location, combined with historical cost data of similar projects, a first forecast reasonable range of various costs in the pre-settlement project is predicted through a preset algorithm model; Based on the project type, project scale, historical settlement period data of similar projects and a reference range of settlement periods, a second predicted reasonable range of the settlement period of the pre-settlement project is predicted through a preset algorithm model.

[0010] By adopting the above technical solution, it is possible to more accurately deduce the reasonable range of various expenses in the pre-settlement project and the reasonable range of the settlement period based on the actual situation of the specific project and past experience, effectively solving the problem of inaccurate cost forecasting and settlement period forecasting in the prior art; specifically, by obtaining relevant information of the pre-settlement project, including project type, project scale, project location, historical cost data of similar projects and historical settlement period data of similar projects, the system can fully understand the background information of the project; at the same time, it obtains preset audit rules, including audit standards for various expenses of the pre-settlement project, trigger conditions for cost adjustment and reference range of the settlement period, to ensure that the audit process has clear basis and standards, effectively solving the problems of inconsistent data and unclear audit standards in the prior art; and cost forecasting based on historical data and algorithm models effectively solves the problem of inaccurate cost forecasting in the prior art, and improves the scientificity and reliability of cost forecasting.

[0011] In a preferred example of the present application, the cost audit comparison table for auditing the pre-settlement project costs is generated according to the preset audit rules, the first predicted reasonable range and the second predicted reasonable range, specifically including: According to the reasonable range of the first forecast of material cost, labor cost, machinery cost and management cost at each stage, obtain the total cost forecast of each stage; Acquire settlement cycle forecast information for each stage according to the second forecast reasonable range of the settlement time and settlement frequency for each stage; Generate initial cost review and comparison information based on the total cost forecast and the settlement cycle forecast information, the initial cost review and comparison information including the total cost forecast, settlement cycle forecast information, cost budget value and actual value of each stage; Calculating the ratio of the cost budget value of each stage to the total cost forecast to obtain a cost budget ratio for predicting actual costs; Calculating the difference between the settlement cycle prediction information of each stage and the actual settlement cycle to obtain the settlement cycle difference for determining the actual settlement cycle; A cost audit comparison table for comparing and auditing the pre-settlement project costs is generated based on the cost budget ratio, the settlement cycle difference and the initial cost audit comparison information.

[0012] By adopting the above technical scheme, the system can calculate the total cost forecast for each stage based on the first predicted reasonable range of material costs, labor costs, machinery costs and management costs in each stage, thereby improving the comprehensiveness and accuracy of the cost forecast, and automatically obtaining the settlement cycle forecast information for each stage, effectively solving the problem of inaccurate settlement cycle forecast in the prior art, and effectively solving the problem of lack of comparison information in cost audit in the prior art by generating detailed initial cost audit comparison information, simplifying the audit process, and improving the accuracy and efficiency of the audit. The calculation of the cost-to-budget ratio improves the accuracy of the actual cost forecast, and the actual settlement cycle difference provides a scientific basis for the judgment of the actual settlement cycle.

[0013] In a preferred example of the present application: before predicting the first predicted reasonable range of various expenses in the pre-settlement project by a preset algorithm model based on the project type, project scale and project location, combined with historical cost data of similar projects, the method also includes: Obtaining market material price data of the pre-settlement project, and judging the impact of changes in market material prices on the pre-settlement project costs based on the market material price data and the preset audit rules; According to the influence of the market material price change, obtaining a first coefficient for adjusting the first prediction reasonable range; The first predicted reasonable range of various expenses in the pre-settlement project is predicted by a preset algorithm model based on the project type, project scale and project location, combined with historical cost data of similar projects, specifically including: Based on the first coefficient, the project type, project scale and the region where the project is located, combined with historical cost data of similar projects, a first predicted reasonable range of various costs in the pre-settlement project is predicted through a preset algorithm model.

[0014] By adopting the above technical scheme, the present invention can obtain market material price data in real time and judge its impact on the pre-settlement project costs, which effectively solves the problem of cost forecasting ignoring changes in market material prices in the prior art. At the same time, according to the impact of changes in market material prices, a dynamic adjustment mechanism of the reasonable range of the first prediction is dynamically adjusted, thereby improving the accuracy and flexibility of the cost forecasting function; finally, considering the changes in market material prices and the historical data of the project, cost forecasting is performed through a preset algorithm model, which effectively solves the problem of single and inaccurate cost forecasting in the prior art and improves the scientific nature of cost forecasting.

[0015] In a preferred example of the present application, the step of obtaining a cost change reference range representing a cost change threshold of a pre-settlement item cost, and generating a pre-settlement cost review control model according to the cost change reference range and the cost review comparison table specifically includes: Obtain a cost change reference range for the pre-settlement project, where the cost change reference range includes a material cost change threshold, a labor cost change threshold, a machinery cost change threshold, and a management cost change threshold; Generate a cost change comparison table according to the cost change reference range and the cost review comparison table, wherein the cost change comparison table includes the total cost forecast for each stage, the cost change threshold and the cost adjustment triggering condition; Generate a pre-settlement fee review and control model based on the fee change comparison table, the pre-settlement fee review and control model includes a fee change detection module, a fee adjustment module and a fee review result output module; The cost change detection module is used to detect the difference between the actual cost of each stage and the total cost forecast, the cost adjustment module is used to adjust the cost according to the cost change threshold and the cost adjustment trigger condition, and the cost audit result output module is used to output the cost audit result.

[0016] By adopting the above technical solution, the reference range of cost changes of the pre-settlement project covers the range of changes of various cost items of the pre-settlement project when the project budget is actually carried out. By locking the range of changes that affect the pre-settlement results, the change thresholds of various cost items are clarified, which effectively avoids the situation where the audit results of the pre-settlement project have a decreased accuracy due to manual subjectivity and lack of specific reference standards. Then, through the cost change comparison table, detailed cost comparison change information can be provided throughout the entire project planning, bidding and construction process, simplifying the audit process and improving the accuracy of the audit and the efficiency of cost management. Then, through automated tools such as the cost change detection module, the cost adjustment module and the cost audit result output module, the efficiency of the cost audit process is ensured, the audit efficiency is improved, and the automation and intelligence level of the cost audit is higher.

[0017] In a preferred example of the present application, the actual cost of each stage is judged according to the cost change detection result whether it exceeds the corresponding cost change threshold, and if it exceeds the cost change threshold, a cost adjustment instruction is generated, specifically including: Calculate the difference between the actual cost of each stage and the total cost forecast according to the cost change detection result; Compare the difference value with the cost change threshold to determine whether the actual cost of each stage exceeds the cost change threshold; If the fee change threshold is exceeded, a fee adjustment instruction is generated, the fee adjustment instruction including detailed content of the fee adjustment and adjustment suggestions; The fee adjustment instruction is sent to the fee adjustment module, and the fee adjustment module adjusts the fees of each stage according to the fee adjustment instruction.

[0018] By adopting the above technical solution, the system can obtain actual pre-settlement data in a timely manner, effectively solving the problem of untimely or inaccurate acquisition of actual cost data in the prior art, and by providing timely anomaly detection and anomaly handling mechanisms, timely discovering and handling cost anomalies, and automatically adjusting costs and generating final results, thereby improving the efficiency and quality of pre-settlement audits.

[0019] In the second aspect, the invention objective of the present application is achieved by adopting the following technical solutions: An automatic pre-settlement audit system is applied to the automatic pre-settlement audit method as described above, and the system comprises: An information acquisition module is used to acquire relevant information of the pre-settlement project and preset audit rules, and determine a first forecast reasonable range of each expense in the pre-settlement project and a second forecast reasonable range of the settlement period according to the relevant information of the pre-settlement project and the preset audit rules; A comparison table generation module, used to generate a cost audit comparison table for comparing and auditing the pre-settlement project costs according to the preset audit rules, the first forecast reasonable range and the second forecast reasonable range; A control model generation module, used for obtaining a cost change reference range representing a cost change threshold of a pre-settlement item, and generating a pre-settlement cost review control model according to the cost change reference range and the cost review comparison table; The audit module is used to obtain actual pre-settlement data and input the actual pre-settlement data into the pre-settlement cost audit control model to automatically audit the costs of the pre-settlement items.

[0020] In the third aspect, the invention objective of the present application is achieved by adopting the following technical solutions: A computer device comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above-mentioned automatic pre-settlement audit method when executing the computer program.

[0021] In a fourth aspect, the invention objective of the present application is achieved by adopting the following technical solutions: A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the above-mentioned automatic pre-settlement audit method.

[0022] In summary, the present application includes at least one of the following beneficial technical effects: 1. Generate a cost audit comparison table based on preset audit rules and predicted reasonable range to ensure the accuracy and scientificity of cost audit. Automatically generate a cost audit comparison table and a pre-settlement cost audit control model to automatically audit actual costs, reduce manual audit workload, and improve cost management efficiency. Based on the cost change reference range, it can also assist relevant personnel in timely discovering and adjusting costs that exceed the reasonable range and optimize cost control. Through the cost audit comparison table and pre-settlement cost audit control model, the costs and settlement cycles of each stage are clearly displayed, the transparency of the project is improved, and it is convenient for project managers and relevant personnel to supervise and make decisions. Through real-time monitoring and cost adjustment, it is conducive to timely discovering and solving cost overruns, reducing the risk of project overbudget, and ensuring the smooth progress of the project. 2. The reference range of cost changes for pre-settlement projects covers the range of changes in various cost items of pre-settlement projects when the project budget is actually carried out. By locking the range of changes that affect the pre-settlement results, the change thresholds of various cost items are clarified, effectively avoiding the situation where the audit results of pre-settlement projects are inaccurate due to human subjectivity and lack of specific reference standards. Then, through the cost change comparison table, detailed cost comparison change information can be provided throughout the entire project planning, bidding and construction process, simplifying the audit process and improving the accuracy of the audit and cost management efficiency. Then, through automated tools such as the cost change detection module, the cost adjustment module and the cost audit result output module, the efficiency of the cost audit process is ensured, the audit efficiency is improved, and the automation and intelligence level of the cost audit is higher; 3. Obtain market material price data in real time and determine its impact on the pre-settlement project costs, which effectively solves the problem of cost forecasting ignoring changes in market material prices in existing technologies. At the same time, according to the impact of changes in market material prices, a dynamic adjustment mechanism is established to dynamically adjust the reasonable range of the first forecast, thereby improving the accuracy and flexibility of the cost forecasting function. Finally, considering changes in market material prices and historical data of the project, cost forecasting is performed through a preset algorithm model, which effectively solves the problem of single and inaccurate cost forecasting in existing technologies and improves the scientific nature of cost forecasting. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 is a flow chart of an automatic pre-settlement review method in one embodiment of the present application; Figure 2 This is a flowchart of step S1 in the automatic pre-settlement review method in one embodiment of the present application; Figure 3 This is a flowchart of step S2 in the automatic pre-settlement review method in one embodiment of the present application; Figure 4 This is a flow chart before step S12 in the automatic pre-settlement review method in one embodiment of the present application; Figure 5 It is a schematic diagram of a device in an embodiment of the present application. DETAILED DESCRIPTION

[0024] The present application is further described in detail below in conjunction with the accompanying drawings.

[0025] In one embodiment, if Figure 1 As shown, the present application discloses an automatic pre-settlement review method, which specifically includes the following steps: S1: Obtain relevant information of the pre-settlement project and preset audit rules, and determine the first forecast reasonable range of each expense in the pre-settlement project and the second forecast reasonable range of the settlement period based on the relevant information of the pre-settlement project and the preset audit rules.

[0026] In this embodiment, the relevant information of the project includes: basic information of the project name, project type, project scale, and the area where the project is located, detailed project information on the bill of quantities, material list, equipment list, and human resource allocation at each stage, historical cost data of similar projects and historical settlement cycle data of similar projects, and duration data of current market material prices, labor costs, machinery rental fees, etc.; the preset audit rules include cost audit standards (including reasonable ranges of material costs, labor costs, machinery costs, and administrative costs, etc.), cost adjustment trigger conditions (including thresholds for cost overruns and conditions for cost adjustments), and settlement cycle standards (including reference ranges for settlement time and settlement frequency at each stage).

[0027] S2: Generate a cost audit comparison table for comparing and auditing the pre-settlement project costs based on the preset audit rules, the first forecast reasonable range and the second forecast reasonable range.

[0028] In this embodiment, the first predicted reasonable range and the second predicted reasonable range can be obtained by training using different machine learning models; the cost change comparison table includes the total cost forecast for each stage, the cost change threshold and the cost adjustment trigger conditions.

[0029] Specifically, before calculating the first predicted reasonable range, first select a suitable algorithm model, such as linear regression or neural network model, then clean and preprocess the acquired project information and historical data, and then use the historical data to train the algorithm model to ensure the model's predictive ability, and then predict the first predicted reasonable range of material costs, labor costs, machinery costs and management costs at each stage through the algorithm model based on the project type, project scale, project location and historical data; and the algorithm model for the second predicted reasonable range adopts a time series analysis model or a decision tree model, and similarly cleans and preprocesses the acquired project information and historical data, and uses the historical data to train the algorithm model to ensure the model's predictive ability, and then predicts the second predicted reasonable range of settlement time and settlement frequency at each stage based on the project type, project scale, settlement cycle data of similar historical projects and the reference range of the settlement cycle through the algorithm model.

[0030] S3: Obtain a cost change reference range representing a cost change threshold for the pre-settlement project, and generate a pre-settlement cost review control model based on the cost change reference range and the cost review comparison table.

[0031] In this embodiment, the cost change reference range includes a material cost change threshold range, a labor cost change threshold range, a machinery cost change threshold range, and a management cost change threshold range.

[0032] Specifically, the pre-settlement expense review and control model includes an expense change detection module for detecting the difference between the actual expenses at each stage and the total expense forecast, an expense adjustment module for adjusting the expenses according to the expense change threshold and the expense adjustment trigger conditions, and an expense review result output module for outputting the expense review results.

[0033] S4: Obtain the actual pre-settlement data and input the actual pre-settlement data into the pre-settlement expense review control model to automatically review the expenses of the pre-settlement items.

[0034] In this embodiment, the actual preliminary settlement data includes the actual material costs, actual labor costs, actual machinery costs and actual management costs at each stage.

[0035] Specifically, the actual pre-settlement data is input into the pre-settlement expense review and control model to obtain the expense change detection results, which include the difference between the actual expenses at each stage and the total expense forecast. The difference is then compared with the expense change threshold to determine whether the actual expenses at each stage exceed the expense change threshold. If so, an expense adjustment instruction is generated. The expense adjustment instruction includes the details of the expense adjustment and adjustment suggestions. The expense adjustment instruction is then sent to the expense adjustment module to adjust the expenses at each stage according to the expense adjustment instruction. Finally, the final expense review result is output through the expense review result output module. The final expense review result includes the expense adjustment situation and review conclusion at each stage.

[0036] In one embodiment, if Figure 2 As shown, in step S1, relevant information of the pre-settlement project and preset audit rules are obtained, and the first predicted reasonable range of each expense in the pre-settlement project and the second predicted reasonable range of the settlement period are determined according to the relevant information of the pre-settlement project and the preset audit rules, specifically including: S11: Obtain relevant information of the pre-settlement project, including project type, project scale, project location, historical cost data of similar projects, and historical settlement cycle data of similar projects; and obtain preset audit rules, including audit standards for various types of expenses of the pre-settlement project, trigger conditions for expense adjustment, and reference range of the settlement cycle.

[0037] In this embodiment, project types include construction projects, municipal projects, water conservancy projects, etc.; project scales include building area, road length, reservoir capacity, etc.; project locations include cities, rural areas, mountainous areas, etc.; historical cost data for similar projects include material costs, labor costs, machinery costs, and management costs for similar projects in the past, and historical settlement cycle data for similar projects include the settlement time and settlement frequency for each stage of similar projects in the past.

[0038] S12: Based on the project type, project scale and project location, combined with historical cost data of similar projects, a preset algorithm model is used to predict the first predicted reasonable range of various costs in the pre-settlement project.

[0039] In this embodiment, the relevant information of the pre-settlement project is cleaned and standardized and then input into a preset algorithm model for cost forecasting.

[0040] S13: Based on the project type, project scale, historical settlement cycle data of similar projects and a reference range of the settlement cycle, a second predicted reasonable range of the settlement cycle of the pre-settlement project is predicted through a preset algorithm model.

[0041] Specifically, the relevant information of the current pre-settlement project is used as input, and the first predicted reasonable range of various types of expenses is predicted through the trained model. The algorithm model should be able to output the confidence interval or probability distribution of the predicted value to reflect the uncertainty of the prediction; before calculating the second predicted reasonable range, the settlement cycle data of similar historical projects is analyzed to identify the key factors affecting the settlement cycle, such as project complexity, contract terms, payment process, etc., and then the data is layered or segmented according to these factors (when constructing an algorithm model suitable for settlement cycle prediction, time series analysis, survival analysis and other methods can be considered), and then the second predicted reasonable range of the settlement cycle of the current pre-settlement project is predicted through the algorithm model based on the project type, scale, historical settlement cycle data and the reference range of the settlement cycle.

[0042] In one embodiment, if Figure 3 As shown, in step S2, according to the preset audit rules, the first forecast reasonable range and the second forecast reasonable range, a cost audit comparison table for comparing and auditing the pre-settlement project costs is generated, specifically including: S21: Obtain the total cost forecast for each stage based on the first forecast reasonable range of material costs, labor costs, machinery costs and management costs for each stage.

[0043] Specifically, add up the material cost forecast data of each stage to obtain the total material cost forecast of each stage; add up the labor cost forecast data of each stage to obtain the total labor cost forecast of each stage; add up the machinery cost forecast data of each stage to obtain the total machinery cost forecast of each stage; add up the management cost forecast data of each stage to obtain the total management cost forecast of each stage; then add up the total material cost forecast, total labor cost forecast, total machinery cost forecast and total management cost forecast of each stage to obtain the total cost forecast of each stage.

[0044] S22: Acquire settlement cycle prediction information of each stage according to the second predicted reasonable range of settlement time and settlement frequency of each stage.

[0045] Specifically, the settlement cycle prediction information includes settlement time prediction data and settlement frequency prediction data. The settlement time prediction information and settlement frequency prediction information of the lake area within the second prediction reasonable range will be merged to obtain the settlement cycle prediction information of each stage.

[0046] S23: Generate initial expense review and comparison information based on the total expense forecast and settlement cycle forecast information. The initial expense review and comparison information includes the total expense forecast for each stage, settlement cycle forecast information, expense budget value and actual value.

[0047] In this embodiment, the actual value includes actual cost data of each stage.

[0048] S24: Calculate the ratio of the cost budget value of each stage to the total cost forecast, and obtain the cost budget ratio for predicting the actual cost.

[0049] In this embodiment, the cost budget ratio = cost budget value / total cost forecast; the cost budget ratio of each stage is recorded in the initial cost review comparison information.

[0050] S25: Calculate the difference between the settlement cycle prediction information of each stage and the actual settlement cycle, and obtain the settlement cycle difference for determining the actual settlement cycle.

[0051] In this embodiment, the actual settlement cycle includes the actual stage time of each stage and the actual settlement frequency of each stage.

[0052] Specifically, first obtain the actual stage cycle from the actual project, and then calculate the settlement cycle difference. For each stage, the calculation formula for the settlement time difference in the settlement cycle difference is: settlement time difference = actual settlement time - settlement time forecast information; the calculation formula for the settlement frequency difference in the settlement cycle difference is: settlement frequency difference = actual settlement frequency - settlement frequency forecast information; the settlement time difference and the settlement frequency difference are combined to generate the settlement cycle difference for each stage.

[0053] S26: Generate a cost review comparison table for reviewing the pre-settlement project costs based on the cost budget ratio, the settlement cycle difference and the initial cost review comparison information.

[0054] In this embodiment, the contents of the expense audit comparison table include the total expense forecast for each stage, settlement cycle forecast information, expense budget value, actual value, expense budget ratio, settlement cycle difference, and information on changes in expense difference over time series.

[0055] In one embodiment, if Figure 4 As shown, before step S12, the automatic pre-settlement review method further includes: S1201: Obtain market material price data for the pre-settlement project, and determine the impact of changes in market material prices on the pre-settlement project costs based on the market material price data and preset audit rules.

[0056] In this embodiment, the market material price data includes the prices of main building materials (such as steel, cement, wood, etc.), the prices of auxiliary materials (such as sand, gravel, concrete, etc.), and the prices of special materials (such as waterproof materials, thermal insulation materials, etc.).

[0057] Specifically, obtain the current market material price data from market research, supplier quotations, open market data and other channels; set the threshold for material price changes, such as 5% and 10%, and set the standard for evaluating the impact of market material price changes on the pre-settlement project costs, such as the impact of each 1% increase in material prices on the total costs; calculate the difference between the current market material price and the historical average price to obtain the price change percentage, and evaluate the impact of market material price changes on the pre-settlement project costs according to the preset audit rules. For example, if the price of a certain material rises by more than 5%, it is considered to have a significant impact on the project costs.

[0058] S1202: Obtain a first coefficient for adjusting a first prediction reasonable range according to the impact of changes in market material prices.

[0059] In this embodiment, the first coefficient is an adjustment coefficient of the first predicted reasonable range.

[0060] Specifically, the first coefficient is determined based on the impact of changes in market material prices on the pre-settlement project costs. For example, if the material price rises by 10%, the adjustment coefficient may be 1.10. Then, the first coefficient is calculated based on the percentage of change in market material prices and preset audit rules. For example, adjustment coefficient = 1 + (percentage of market price change × impact weight).

[0061] Further, in step S12, according to the project type, project scale and project location, combined with historical cost data of similar projects, a first predicted reasonable range of various costs in the pre-settlement project is predicted through a preset algorithm model, specifically including: S121: Based on the first coefficient, project type, project scale and project location, combined with historical cost data of similar projects, a first predicted reasonable range of various costs in the pre-settlement project is predicted through a preset algorithm model.

[0062] In this embodiment, the first predicted reasonable range of the costs at each stage is determined based on the model prediction results in combination with the preset audit rules and adjustment coefficient (referring to the first coefficient).

[0063] In one embodiment, in step S3, a cost change reference range representing a cost change threshold of a pre-settlement item cost is obtained, and a pre-settlement cost review control model is generated according to the cost change reference range and a cost review comparison table, specifically including: S31: Obtain a cost change reference range for the pre-settlement project, where the cost change reference range includes a material cost change threshold, a labor cost change threshold, a machinery cost change threshold, and a management cost change threshold.

[0064] In this embodiment, the cost change reference range defines the maximum change range allowed for each cost item during the preliminary settlement process, which is used to determine whether the actual costs exceed expectations; the material cost change threshold refers to the maximum change percentage allowed for material costs, the labor cost change threshold refers to the maximum change percentage allowed for labor costs, the machinery cost change threshold refers to the maximum change percentage allowed for machinery costs, and the management cost change threshold refers to the maximum change percentage allowed for management costs.

[0065] Specifically, according to the preset audit rules, the change threshold of each expense item is obtained, and the expense change threshold is determined by referring to the expense change data of historical projects, industry standards and specifications.

[0066] S32: Generate a cost change comparison table based on the cost change reference range and the cost review comparison table. The cost change comparison table includes the total cost forecast for each stage, the cost change threshold and the cost adjustment trigger conditions.

[0067] Specifically, when the actual cost exceeds the cost change threshold, the cost adjustment condition is triggered, and when the actual cost exceeds the predicted total by 5%, the cost adjustment is triggered.

[0068] S33: Generate a pre-settlement expense review and control model based on the expense change comparison table. The pre-settlement expense review and control model includes an expense change detection module, an expense adjustment module and an expense review result output module.

[0069] Specifically, the expense adjustment module calculates the specific amount of expense adjustment according to preset adjustment rules; for example, when the actual expense exceeds the predicted total by 10%, the adjustment amount = (actual expense - predicted total) × adjustment coefficient.

[0070] S34: The cost change detection module is used to detect the difference between the actual cost of each stage and the total cost forecast. The cost adjustment module is used to adjust the cost according to the cost change threshold and the cost adjustment trigger condition. The cost review result output module is used to output the cost review result.

[0071] Specifically, the cost change detection module detects the difference between the actual costs of each stage and the total cost forecast; the cost adjustment module adjusts the costs according to the cost change threshold and the cost adjustment trigger conditions; the cost audit result output module outputs the cost audit results (such as generating charts and reports to the user interface terminal), including the cost adjustment situation and audit conclusions of each stage.

[0072] In one embodiment, in step S4, actual pre-settlement data is obtained, and the actual pre-settlement data is input into the pre-settlement expense review control model to automatically review the expense of the pre-settlement item, specifically including: S41: Acquire actual preliminary settlement data, which includes actual material costs, actual labor costs, actual machinery costs and actual management costs at each stage.

[0073] Specifically, the actual material cost of each stage is obtained from the material procurement records of the project management system, the actual labor cost of each stage is obtained from the wage payment records of the project management system, the actual machinery cost of each stage is obtained from the machinery rental records of the project management system, and the actual management expenses of each stage are obtained from the management expense records of the project management system. In actual application, the actual material cost, actual labor cost, actual machinery cost and actual management expenses of each stage need to be recorded in the project management system to form actual preliminary settlement data.

[0074] S42: Input the actual pre-settlement data into the pre-settlement expense review and control model to obtain expense change detection results, which include the difference between the actual expenses of each stage and the total amount of expense forecast.

[0075] Specifically, the pre-settlement expense audit control model is an automated intelligent AI system that is used to detect expense changes, adjust expenses, and output audit results.

[0076] S43: Based on the cost change detection result, determine whether the actual cost of each stage exceeds the corresponding cost change threshold. If it exceeds the cost change threshold, generate a cost adjustment instruction.

[0077] In this embodiment, the cost change threshold of each stage is obtained from the cost change comparison table, and the difference value in the cost change detection result is compared with the cost change threshold to determine whether the actual cost exceeds the cost change threshold. If it is determined that the actual cost exceeds the cost change threshold, the generation of a cost adjustment instruction is triggered, and according to the preset adjustment rules, the detailed content of the cost adjustment is generated, including the specific amount of the adjustment and the adjustment item, and the generated cost adjustment instruction is recorded in the project management system, including the detailed content of the adjustment and the adjustment suggestion.

[0078] S44: Adjust the expenses at each stage according to the expense adjustment instructions and generate the final expense review results.

[0079] In this embodiment, the final cost audit result includes the cost adjustment status of each stage and the audit conclusion. The audit conclusion refers to the summary of the cost adjustment status of each stage, such as whether the cost is reasonable, whether there is any overspending, etc.

[0080] In one embodiment, in step S43, based on the cost change detection result, it is determined whether the actual cost of each stage exceeds the corresponding cost change threshold. If it exceeds the cost change threshold, a cost adjustment instruction is generated, specifically including: S431: Calculate the difference between the actual cost of each stage and the total cost forecast according to the cost change detection result.

[0081] S432: Compare the difference value with the cost change threshold to determine whether the actual cost of each stage exceeds the cost change threshold.

[0082] Specifically, the cost change threshold refers to the maximum change percentage allowed for each cost item. If the difference value is greater than the cost change threshold, it is determined that the actual cost exceeds the cost change threshold.

[0083] S433: If the fee change threshold is exceeded, a fee adjustment instruction is generated, which includes detailed content of the fee adjustment and adjustment suggestions.

[0084] In this embodiment, the adjustment content refers to the detailed content of the cost adjustment generated according to the preset adjustment rules, which includes the specific amount of adjustment and the adjustment items; for example, when the actual cost exceeds the forecast total by 10%, the adjustment amount = (actual cost - forecast total) × adjustment coefficient; the adjustment suggestion refers to making specific adjustment suggestions, such as increasing the budget, optimizing resource allocation, renegotiating contract terms, etc.

[0085] S434: Send the fee adjustment instruction to the fee adjustment module, and the fee adjustment module adjusts the fees of each stage according to the fee adjustment instruction.

[0086] In this embodiment, after receiving the fee adjustment instruction, the fee adjustment module calculates the fee adjustment amount for each stage according to the adjustment content in the fee adjustment instruction, and applies the calculated adjustment amount to the corresponding fee item to generate adjusted fee data.

[0087] It should be understood that the serial numbers of the steps in the above embodiments do not imply a sequence of execution. The execution sequence of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0088] In one embodiment, a system for reviewing automatic pre-settlement is provided, and the system for reviewing automatic pre-settlement corresponds to the method for reviewing automatic pre-settlement in the above embodiment.

[0089] An automatic pre-settlement audit system includes an information acquisition module, a comparison table generation module, a control model generation module and an audit module. The detailed description of each functional module is as follows: An information acquisition module is used to acquire relevant information of the pre-settlement project and preset audit rules, and determine the first forecast reasonable range of each expense in the pre-settlement project and the second forecast reasonable range of the settlement period according to the relevant information of the pre-settlement project and the preset audit rules; A comparison table generation module, used to generate a cost audit comparison table for comparing and auditing the pre-settlement project costs according to preset audit rules, the first forecast reasonable range and the second forecast reasonable range; A control model generation module is used to obtain a cost change reference range representing a cost change threshold for a pre-settlement project, and generate a pre-settlement cost review control model based on the cost change reference range and a cost review comparison table; The audit module is used to obtain the actual pre-settlement data and input the actual pre-settlement data into the pre-settlement cost audit control model to automatically audit the costs of the pre-settlement items.

[0090] For the specific limitations of the automatic pre-settlement audit system, please refer to the limitations of the automatic pre-settlement audit method above, which will not be repeated here; the various modules in the above-mentioned automatic pre-settlement audit system can be implemented in whole or in part through software, hardware and their combination; the above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the corresponding operations of the above-mentioned modules.

[0091] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 5 As shown. The computer device includes a processor, a memory, a network interface and a database connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store relevant information of the pre-settlement project and preset audit rules, etc. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, an automatic pre-settlement audit method is implemented.

[0092] In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of an automatic pre-settlement audit method when executing the computer program.

[0093] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps of an automatic pre-settlement audit method are implemented.

[0094] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application may include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0095] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

[0096] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, it should be understood by those skilled in the art that the technical solutions described in the aforementioned embodiments may still be modified, or some of the features thereof may be replaced by equivalents. Such 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 application, and should all be included in the protection scope of the present application.

Claims

1. The automatic preliminary settlement audit method is characterized by: include: Obtain relevant information and preset audit rules for the pre-settlement project, and determine a first forecast reasonable range for each expense in the pre-settlement project and a second forecast reasonable range for the settlement period based on the relevant information and the preset audit rules for the pre-settlement project; Generate a cost audit comparison table for checking the pre-settlement project costs according to the preset audit rules, the first forecast reasonable range and the second forecast reasonable range; Acquire a cost change reference range representing a cost change threshold for a pre-settlement item, and generate a pre-settlement cost review control model based on the cost change reference range and the cost review comparison table; The actual pre-settlement data is obtained and input into the pre-settlement expense review control model to automatically review the expense of the pre-settlement item.

2. The automatic pre-settlement audit method according to claim 1 is characterized in that: The obtaining of relevant information of the pre-settlement project and the preset audit rules, and judging the first forecast reasonable range of each expense in the pre-settlement project and the second forecast reasonable range of the settlement period according to the relevant information of the pre-settlement project and the preset audit rules, specifically includes: Obtain relevant information of the pre-settlement project, including project type, project scale, project location, historical cost data of similar projects, and historical settlement cycle data of similar projects; and obtain preset audit rules, including audit standards for various costs of pre-settlement projects, trigger conditions for cost adjustments, and reference ranges for settlement cycles; Based on the project type, project scale and project location, combined with historical cost data of similar projects, a first forecast reasonable range of various costs in the pre-settlement project is predicted through a preset algorithm model; Based on the project type, project scale, historical settlement period data of similar projects and a reference range of settlement periods, a second predicted reasonable range of the settlement period of the pre-settlement project is predicted through a preset algorithm model.

3. The automatic pre-settlement audit method according to claim 2 is characterized in that: Generating a cost audit comparison table for auditing the pre-settlement project costs according to the preset audit rules, the first forecast reasonable range and the second forecast reasonable range specifically includes: According to the reasonable range of the first forecast of material cost, labor cost, machinery cost and management cost at each stage, obtain the total cost forecast of each stage; Acquire settlement cycle forecast information for each stage according to the second forecast reasonable range of the settlement time and settlement frequency for each stage; Generate initial cost review and comparison information based on the total cost forecast and the settlement cycle forecast information, the initial cost review and comparison information including the total cost forecast, settlement cycle forecast information, cost budget value and actual value of each stage; Calculating the ratio of the cost budget value of each stage to the total cost forecast to obtain a cost budget ratio for predicting actual costs; Calculating the difference between the settlement cycle prediction information of each stage and the actual settlement cycle to obtain the settlement cycle difference for determining the actual settlement cycle; A cost audit comparison table for comparing and auditing the pre-settlement project costs is generated based on the cost budget ratio, the settlement cycle difference and the initial cost audit comparison information.

4. The automatic pre-settlement audit method according to claim 2 is characterized in that: Before predicting the first predicted reasonable range of various expenses in the pre-settlement project by a preset algorithm model based on the project type, project scale and project location, combined with historical cost data of similar projects, the method further includes: Obtaining market material price data of the pre-settlement project, and judging the impact of changes in market material prices on the pre-settlement project costs based on the market material price data and the preset audit rules; According to the influence of the market material price change, obtaining a first coefficient for adjusting the first prediction reasonable range; The first predicted reasonable range of various expenses in the pre-settlement project is predicted by a preset algorithm model based on the project type, project scale and project location, combined with historical cost data of similar projects, specifically including: Based on the first coefficient, the project type, project scale and the region where the project is located, combined with historical cost data of similar projects, a first predicted reasonable range of various costs in the pre-settlement project is predicted through a preset algorithm model.

5. The automatic pre-settlement audit method according to claim 1 is characterized in that: The step of obtaining a cost change reference range representing a cost change threshold of a pre-settlement item cost, and generating a pre-settlement cost review control model according to the cost change reference range and the cost review comparison table specifically includes: Obtain a cost change reference range for the pre-settlement project, where the cost change reference range includes a material cost change threshold, a labor cost change threshold, a machinery cost change threshold, and a management cost change threshold; Generate a cost change comparison table according to the cost change reference range and the cost review comparison table, wherein the cost change comparison table includes the total cost forecast for each stage, the cost change threshold and the cost adjustment triggering condition; Generate a pre-settlement fee review and control model based on the fee change comparison table, the pre-settlement fee review and control model includes a fee change detection module, a fee adjustment module and a fee review result output module; The cost change detection module is used to detect the difference between the actual cost of each stage and the total cost forecast, the cost adjustment module is used to adjust the cost according to the cost change threshold and the cost adjustment trigger condition, and the cost audit result output module is used to output the cost audit result.

6. The automatic pre-settlement audit method according to claim 5 is characterized in that: The obtaining of actual pre-settlement data and inputting the actual pre-settlement data into the pre-settlement expense review control model to automatically review the expense of the pre-settlement item specifically includes: Acquiring actual preliminary settlement data, wherein the actual preliminary settlement data includes actual material costs, actual labor costs, actual machinery costs, and actual management costs at each stage; Inputting the actual pre-settlement data into the pre-settlement fee review and control model to obtain fee change detection results, wherein the fee change detection results include the difference between the actual fee of each stage and the total fee forecast; According to the cost change detection result, determining whether the actual cost of each stage exceeds the corresponding cost change threshold, and if it exceeds the cost change threshold, generating a cost adjustment instruction; According to the fee adjustment instructions, the fees at each stage are adjusted and the final fee review results are generated.

7. The automatic preliminary settlement audit method according to claim 6 is characterized in that: According to the cost change detection result, it is determined whether the actual cost of each stage exceeds the corresponding cost change threshold. If the actual cost exceeds the cost change threshold, a cost adjustment instruction is generated, which specifically includes: Calculate the difference between the actual cost of each stage and the total cost forecast according to the cost change detection result; Compare the difference value with the cost change threshold to determine whether the actual cost of each stage exceeds the cost change threshold; If the fee change threshold is exceeded, a fee adjustment instruction is generated, the fee adjustment instruction including detailed content of the fee adjustment and adjustment suggestions; The fee adjustment instruction is sent to the fee adjustment module, and the fee adjustment module adjusts the fees of each stage according to the fee adjustment instruction.

8. Automatic pre-settlement audit system, characterized by: The automatic pre-settlement audit method according to any one of claims 1 to 7, wherein the system comprises: An information acquisition module is used to acquire relevant information of the pre-settlement project and preset audit rules, and determine a first forecast reasonable range of each expense in the pre-settlement project and a second forecast reasonable range of the settlement period according to the relevant information of the pre-settlement project and the preset audit rules; A comparison table generation module, used to generate a cost audit comparison table for comparing and auditing the pre-settlement project costs according to the preset audit rules, the first forecast reasonable range and the second forecast reasonable range; A control model generation module, used for obtaining a cost change reference range representing a cost change threshold of a pre-settlement item, and generating a pre-settlement cost review control model according to the cost change reference range and the cost review comparison table; The audit module is used to obtain actual pre-settlement data and input the actual pre-settlement data into the pre-settlement cost audit control model to automatically audit the costs of the pre-settlement items.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the automatic pre-settlement audit method as described in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the automatic pre-settlement audit method as claimed in any one of claims 1 to 7 are implemented.

Images