Coal project budget management system

Abstract

The present application provides a coal project budget management system, focuses on the dynamic management and control of the budget of the whole life cycle of the project, covers three core stages of project budget preparation, execution process monitoring and completion final accounts verification, solves the pain points such as "data dispersion, control lag, collection difficulty" in traditional budget management through standardized processes, automated data collection and early warning functions, realizes the closed-loop management of "budget in advance, monitoring in progress, accounting after the event", greatly reduces the manual workload and meets the compliance requirements, and supports precise collection according to the project name for multiple contracts, providing full-process data support for project cost control.

Description

Technical Field

[0001] This invention relates to the field of project construction technology, and in particular to a coal project budget management system. Background Technology

[0002] Currently, the management system is mainly developed for the construction industry, while the coal industry is a relatively niche market. Existing coal project budget management mainly relies on Excel editing and manual input. The core of the system adopts a "fixed template input + manual verification" mode, which supports the input and summary calculation of basic budget indicators (such as engineering quantity and unit price). Some systems integrate simple formula verification functions (such as logical relationship verification). Data storage is mainly based on local databases, and it can only realize the basic process of "input - calculation - report output". However, this system has the following problems: ① Poor dynamic adaptability: Coal mining projects often include industries such as mine shaft engineering, civil engineering, equipment procurement, installation engineering, highway engineering, bridges and tunnels, railways, and power. Fixed templates cannot match the personalized budget indicator systems of different industry projects, requiring a large amount of manual adjustment, resulting in low adaptation efficiency; ② Lagging data collaboration: Data from various participants in coal mining projects (design, cost consulting, construction, and auditing units) is stored in isolation, lacking a real-time synchronization mechanism, easily leading to "information silos," resulting in untimely budget adjustments, inability to share information, and a high error rate; ③ Insufficient intelligence: Data accuracy relies entirely on manual labor, which is not only labor-intensive but also requires manual verification of indicator rationality and risk prediction (such as over-budget warnings). It lacks algorithmic support, easily overlooking potential problems and is inefficient; ④ Weak traceability: Only the final budget result is recorded, without retaining the trajectory of indicator adjustments, the basis, and information on responsible persons, making subsequent auditing and review difficult; thus, budget management suffers from pain points such as "data dispersion, lagging control, and difficulty in collection." Summary of the Invention

[0003] In view of this, the purpose of the present invention is to provide a coal project budget management system to alleviate at least some of the above-mentioned technical problems.

[0004] This invention provides a coal project budget management system, which includes: a project basic information management module, a project budget preparation module, a process management module, a final settlement module, and a data statistics and reporting module. The project basic information management module is used to acquire basic project information, including core project information, project status information, and basic project data. The project budget preparation module is used to generate project budget information. The process management module is used to acquire monitoring data in real time and generate over-cost warning information based on the monitoring data when executing the project budget based on the project basic information and project budget information. The final settlement module is used to acquire final settlement data at the project completion stage and perform project budget write-off and project budget comparison analysis based on the final settlement data. The data statistics and reporting module is used to generate data reports according to data analysis needs.

[0005] Optionally, the core project information includes at least one of the following: project name, project number, project initiating department, project type, construction period, total estimated amount, project leader, and approval process information; the project basic information management module is also used to classify and tag projects according to the core project information, and generate project classification information; among which, the project classification information includes infrastructure projects, technological transformation projects, and R&D projects.

[0006] Optionally, project status information includes: project initiation status, execution status, suspension status, completion status, and final settlement status; the project basic information management module is also used to update the project status information in response to user operations on project status changes.

[0007] Optionally, the project basic information management module is also used to respond to user status query operations on project status information, determine the corresponding target project, and display the target project.

[0008] Optionally, the project basic data includes budget item system data, contract type dictionary data, and department / personnel organizational structure data; among which, the budget item system data includes construction and installation engineering costs and equipment purchase costs, and the contract type dictionary data includes engineering contracts, procurement contracts, and service contracts; the project basic information management module is also used to respond to user extended operations and extend the project basic data so that the extended project basic data can be adapted to project needs.

[0009] Optionally, the project budget preparation module is also used to generate project budget information in response to the user's budget preparation operation.

[0010] Optionally, the project budget preparation module is also used to adjust the project budget information in response to the user's budget adjustment operation and generate the latest version of the project budget information.

[0011] Optionally, the monitoring data includes at least one of the following: estimated amount, amount used, remaining amount, and execution progress value; the process management module is also used to generate overspending warning information based on the monitoring data and preset thresholds, and to display the overspending warning information.

[0012] Optionally, the process management module is also used to obtain basic contract information and classify contracts according to the basic contract information; wherein, the basic contract information includes at least one of the following: contract name, contract number, partner, contract amount, signing date and contract type.

[0013] Optionally, the process management module is also used to obtain contract payment information and update the contract payment progress information based on the contract payment information; wherein, the contract payment progress information includes: advance payment, progress payment and final payment.

[0014] The embodiments of the present invention bring the following beneficial effects: This invention provides a coal project budget management system. The project basic information management module is used to acquire basic project information, including core project information, project status information, and basic project data. The project budget preparation module generates project budget information. The process management module acquires monitoring data in real time and generates over-cost warning information based on the monitoring data when executing the project budget based on the basic project information and the project budget information. The final settlement module acquires final settlement data at the project completion stage and performs project budget verification and comparative analysis based on the final settlement data. Data statistics are also included. The reporting module is used to generate data reports based on data analysis needs, thereby focusing on the dynamic management of the project's entire lifecycle budget. It covers three core stages: budget preparation for project initiation, monitoring of the execution process, and final settlement verification. Through standardized processes, automated data collection, and early warning functions, it solves the pain points of traditional budget management such as "data dispersion, lagging management, and difficulty in collection," and realizes closed-loop management of "budget before, monitoring during, and accounting after." It significantly reduces manual workload and meets compliance requirements. At the same time, it supports accurate collection of multiple contracts by project name, providing full-process data support for project cost control.

[0015] Other features and advantages of the invention will be set forth in the following description, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention are realized and obtained through the structures particularly pointed out in the description and the drawings.

[0016] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, preferred embodiments are described below in detail with reference to the accompanying drawings. Attached Figure Description

[0017] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0018] Figure 1 This is a schematic diagram of the structure of a coal project budget management system provided in an embodiment of the present invention. Detailed Implementation

[0019] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0020] To facilitate understanding of this embodiment, the embodiments of the present invention will be described in detail below.

[0021] This invention provides a coal project budget management system, such as... Figure 1 As shown, the system includes: a project basic information management module 10, a project budget preparation module 20, a process management module 30, a final settlement module 40, and a data statistics and reporting module 50. The project basic information management module 10 is used to acquire basic project information, including core project information, project status information, and basic project data. The project budget preparation module 20 is used to generate project budget information. The process management module 30 is used to acquire monitoring data in real time when executing the project budget based on the project basic information and project budget information, and to generate over-cost warning information based on the monitoring data. The final settlement module 40 is used to acquire final settlement data at the project completion stage, and to perform project budget verification and project budget comparison analysis based on the final settlement data. The data statistics and reporting module 50 is used to generate data reports according to data analysis needs.

[0022] The coal project budget management system provided in this invention focuses on the dynamic control of budgets throughout the entire project lifecycle, covering three core stages: budget preparation for project initiation, monitoring of the execution process, and final settlement verification. Through standardized processes, automated data collection, and early warning functions, it solves the pain points of traditional budget management such as "dispersed data, lagging control, and difficulty in collection," and achieves closed-loop management of "budgeting before, monitoring during, and accounting after," significantly reducing manual workload and meeting compliance requirements. At the same time, it supports the accurate collection of multiple contracts by project name, providing full-process data support for project cost control.

[0023] To facilitate understanding, each module will be explained in detail here.

[0024] (1) Project basic information management module 10; as the system data base, it supports the entire process of business association and ensures the accuracy of contract collection.

[0025] ① Project Information Filing: Users enter core project information, which includes, but is not limited to: project name (unique project identifier), project number, initiating department, project type, construction period, total estimated cost, project leader, and approval process information. The project basic information management module 10 is also used to classify and tag projects based on the core project information, generating project classification information. Among them, project classification information includes infrastructure projects, technological transformation projects, and R&D projects, such as configuring tag 1 for infrastructure projects, tag 2 for technological transformation projects, and tag 3 for R&D projects. This not only classifies projects based on tags but also provides dimensional basis for subsequent contract collection and budget analysis.

[0026] ② Project Status Management; Users can set project status information, including: project initiation status, execution status, paused status, completion status, and final settlement status. Furthermore, the project basic information management module 10 is also used to update the project status information in response to user actions regarding project status changes. Specifically, project status changes require associated approval processes. Once the approval process is completed, the project basic information management module 10 updates the project status information based on the user's actions regarding the project status change and automatically records the status change log.

[0027] In addition, the project basic information management module 10 also supports filtering and querying projects by project status information. Specifically, the project basic information management module 10 is also used to respond to the user's status query operation on project status information, determine the corresponding target project, and display the target project. Thus, users can not only query and filter projects based on project core information, but also filter and query projects based on project status information, thereby meeting the user's various project query needs.

[0028] ③ Basic data maintenance; The project basic information management module 10 is also used to maintain project basic data, which includes budget item system data, contract type dictionary data, and department / personnel organizational structure data. Among them, the budget item system data includes construction and installation engineering costs, equipment purchase costs, and other expenses, etc., and the contract type dictionary data includes engineering contracts, procurement contracts, service contracts, and other expense items, etc.

[0029] Furthermore, the project basic information management module 10 is also used to respond to user extension operations by expanding the project basic data to adapt the expanded project basic data to project requirements. That is, the project basic information management module 10 supports custom extension fields. Based on the project requirements of different industries, users can perform extension operations to expand the project basic data, thereby adapting the expanded project basic data to the project requirements of different industries. This allows the coal project budget management system to be extended to other industries and adapted accordingly, expanding the system's application scenarios.

[0030] (2) Project budget preparation module 20; used for pre-planning to ensure the standardization and feasibility of budget preparation.

[0031] Specifically, the project budget preparation module 20 is also used to respond to users' budget preparation operations and generate project budget information. The budget preparation process is as follows: ① First, initiate the preparation; the project leader selects the corresponding budget items according to the project approval document, enters the budget amount for each item, the basis for preparation (such as quota standards, market quotations, historical data), and supports uploading attachments (project approval documents, quotation sheets, etc.); ② Multi-level review; after the preparation is completed, it is submitted for approval, and supports customized approval processes (such as preliminary review by the project department → review by the relevant management department → final review by the management). Comments can be added and revisions can be returned during the approval process, and the system records the approval process; ③ Budget becomes effective; after approval, a formal project budget document (i.e., project budget information) is generated, and the basic budget data is automatically locked as the benchmark for subsequent execution monitoring. It also supports exporting to Excel / PDF / Word and printing for archiving, meeting various user needs.

[0032] In addition, the project budget preparation module 20 is also used to respond to the user's budget adjustment operation, adjust the project budget information, and generate the latest version of the project budget information. When the project budget information adjustment process is in progress, such as when the budget needs to be modified due to design changes or policy adjustments, the project budget preparation module 20 adjusts the project budget information according to the user's budget adjustment operation, generates a new budget version after adjustment, and retains historical version records to compare changes in items and differences in amounts between different versions, ensuring that changes are traceable, thereby enhancing the traceability of the budget.

[0033] (3) Process management module 30; used to realize dynamic monitoring of the budget execution process, and simultaneously complete contract collection and overspending warning.

[0034] ① Contract collection and management; the process management module 30 is also used to obtain basic contract information and classify contracts according to the basic contract information; among which, the basic contract information includes at least one of the following: contract name, contract number, partner, contract amount, signing date and contract type.

[0035] Specifically, users enter basic contract information. The core function is to associate contracts by project name. That is, by selecting the corresponding project name from the drop-down menu, the contract is automatically assigned to that project. It supports batch import of contract data (Excel template) and associating it with the corresponding budget item (such as associating an equipment purchase contract with the "Equipment Purchase Cost" item), thereby realizing contract entry and the association between contracts and projects.

[0036] After obtaining the basic contract information, the process management module 30 further classifies the contracts based on this information. For example, it filters and queries the contracts by multiple dimensions such as "project name + contract type", "project name + budget item" and "project name + execution stage", and automatically calculates the total number of contracts, total amount, paid amount and unpaid amount under a single project. This achieves a one-to-one / one-to-many precise association between projects and contracts, thereby classifying the contracts and realizing the classification and collection of contracts.

[0037] In addition, the process management module 30 is also used to acquire contract payment information and update the contract payment progress information based on it; the contract payment progress information includes: advance payment, progress payment, and final payment. Specifically, the system records contract payment progress information (advance payment, progress payment, and final payment), automatically associates each payment with the corresponding budget item, and deducts the remaining budget amount of that budget item in real time. It also supports uploading payment vouchers (acceptance slips, settlement slips, invoices, transfer records, etc. in PDF format), ensuring not only the consistency between payment and budget but also enabling the tracking of contract execution.

[0038] ② Budget execution monitoring; wherein, the monitoring data includes at least one of the following: budget amount, amount used, remaining amount and execution progress value; the process management module 30 is also used to generate overspending warning information based on the monitoring data and preset thresholds, and to display the overspending warning information.

[0039] Specifically, when executing the project budget based on the project's basic information and the project's initial budget information, the process management module 30 also automatically summarizes the payment data of all contracts under the project and other expense data (such as miscellaneous expenses) in real time, and compares them with the approved project budget in real time. It calculates the budget amount, used amount, remaining amount, execution progress percentage and other monitoring data for each budget item, thereby achieving real-time data synchronization and avoiding data collaboration delays.

[0040] In addition, the process management module 30 generates overspending warning information based on monitoring data and preset thresholds. These preset thresholds include execution progress thresholds and overspending warning thresholds. When the execution progress value reaches the execution progress threshold, or when the total budget for a certain item or project reaches the overspending warning threshold, the process management module 30 generates overspending warning information and notifies the project manager, budget manager, finance personnel, and relevant management personnel via pop-ups, SMS, and in-system messages. It should be noted that the preset thresholds and the notification scope of the overspending warning information can be set according to actual circumstances.

[0041] Furthermore, the process management module 30 can also display overspending warning information, such as through a display screen, to facilitate users' timely understanding of overspending situations. In addition, the process management module 30 can also display the budget execution overview of a single project (total budget, total expenditure, overspending / savings amount) through views, bar charts of execution progress for each budget item, pie charts of contract aggregated amounts, etc., and supports drill-down queries (such as clicking on a certain item to view all related contracts and payment details), thereby realizing a visual query of the project's budget execution overview.

[0042] ③ Change and Adjustment Management: If it is necessary to add or adjust amounts or budget items during project execution, a change request must be initiated, linking the original project and information, and explaining the reason for the change. After approval, the process management module 30 automatically updates the budget data and aggregated information; without approval, the change will not take effect. In addition, when submitting a change request, the process management module 30 also automatically calculates the impact of the change on the total project budget (such as the added amount causing an overspending in a certain item), providing data support for approval decisions.

[0043] (4) Final settlement module 40; used to realize the preliminary budget verification and summary analysis in the final stage of the project.

[0044] Specifically, the final settlement module 40 first obtains the final settlement data of the project's closing stage, that is, automatically summarizes all expenditure data (contract payments, miscellaneous expenses, taxes, etc.) throughout the project's entire life cycle, verifies it with the project budget and process change records, generates a detailed settlement table, supports manual supplementation of expenditure data that has not been entered, and uploads the final settlement report and related attachments (acceptance report, audit report).

[0045] Then, a comparative analysis of the preliminary budget is performed. The final settlement module 40 automatically generates a comparison report of "Project Budget and Actual Expenditure," displaying the budgeted amount, actual amount, difference amount, and difference rate for each budget item. It analyzes the reasons for overspending / savings (such as overspending in a budget item due to changes, or savings in a budget item due to a decrease in market prices). It supports exporting the final settlement comparison report by project name. Finally, the project budget is reconciled. After the final settlement report is submitted, the final settlement module 40 initiates the final review process (such as project department → relevant management department → finance → audit → management, etc.). After approval, the project budget reconciliation is completed, the system marks the project status as "final settlement completed," and archives all relevant data (budget, contract, payment voucher, final settlement report, etc.), supporting subsequent query and retrieval functions.

[0046] (5) Data statistics and reporting module 50; used to meet the needs of multi-dimensional data analysis and support management decision-making.

[0047] On one hand, it can generate fixed reports. The Data Statistics and Reporting Module 50 automatically generates several fixed reports, such as the "Overall Report on Project Budget Execution," the "Detailed Report on Individual Project Contract Collection," the "Budget Overrun Warning List," the "Completion Settlement Comparison Report," and the "Ranking Report on Multi-Project Budget Execution," supporting export to Excel / PDF / Word formats. On the other hand, it supports custom reports. The Data Statistics and Reporting Module 50 provides a report customization tool, allowing users to filter by dimensions such as "project type, time range, budget item, and contract type," set statistical indicators (such as total amount, execution rate, and discrepancy rate), and generate personalized reports to meet various reporting needs. In addition, the Data Statistics and Reporting Module 50 also supports batch export of project, contract, and budget execution data, connecting with enterprise ERP (Enterprise Resource Planning) and financial systems to achieve data interoperability and sharing (such as synchronizing payment data to the financial system for accounting), avoiding duplicate data entry.

[0048] In summary, the coal project cost estimate management system provided in this embodiment of the invention, compared with traditional Excel spreadsheets, reduces the risk of exceeding the project cost estimate and improves the efficiency of fund utilization through real-time monitoring and overspending warnings. Regarding efficiency improvement, automated data collection and report generation reduce manual statistical workload and shorten the time for cost estimate preparation and final account summary. In terms of management standardization, standardized processes and data management ensure the compliance of cost estimate preparation, contract execution, and final account verification, avoiding loopholes caused by human error. Regarding decision support, multi-dimensional data statistics and analysis provide data references for project approval, process adjustments, and subsequent project budget formulation. Through the coal project cost estimate management system, the transformation of project cost estimates from "static preparation" to "dynamic control" can be realized, while simultaneously addressing the core need to group multiple contracts by project name, making project cost management more accurate, efficient, and controllable. It is suitable for large enterprises or data-sensitive coal enterprises and coal mine project management, and data is stored on a local server, ensuring high security.

[0049] The computer program product of the coal project budget management system provided in this embodiment of the invention includes a computer-readable storage medium storing program code. The instructions included in the program code can be used to execute the management process in the previous embodiments. For specific implementation, please refer to the foregoing embodiments, which will not be repeated here.

[0050] Furthermore, in the description of the embodiments of the present invention, unless otherwise explicitly specified and limited, the terms "installation," "connection," and "linking" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; and they can refer to the internal connection of two components. Those skilled in the art can understand the specific meaning of the above terms in the present invention based on the specific circumstances.

[0051] If the aforementioned functions are implemented as software functional units and sold or used as independent products, they can be stored in a processor-executable, non-volatile, computer-readable storage medium. Based on this understanding, the technical solution of this invention, essentially, or the part that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0052] In the description of this invention, it should be noted that the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," and "outer," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are used only for the convenience of describing the invention and for simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on the invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0053] Finally, it should be noted that the above-described embodiments are merely specific implementations of the present invention, used to illustrate the technical solutions of the present invention, and not to limit it. The scope of protection of the present invention is not limited thereto. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that any person skilled in the art can still modify or easily conceive of changes to the technical solutions described in the foregoing embodiments within the technical scope disclosed in the present invention, or make equivalent substitutions for some of the technical features; and these modifications, changes, or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be covered within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A coal project budget management system, characterized in that, The system includes: a project basic information management module, a project budget preparation module, a process management module, a final settlement module, and a data statistics and reporting module; The project basic information management module is used to acquire project basic information; wherein, the project basic information includes project core information, project status information, and project basic data; The project budget preparation module is used to generate project budget information; The process management module is used to acquire monitoring data in real time and generate overspending warning information based on the monitoring data when executing the project budget according to the project basic information and the project budget information. The final settlement module is used to obtain the final settlement data of the project in the final stage, and to perform project budget verification and project budget comparison analysis based on the final settlement data. The data statistics and reporting module is used to generate data reports according to data analysis needs.

2. The system according to claim 1, characterized in that, The core information of the project includes at least one of the following: project name, project number, department that initiated the project, project type, construction period, total estimated amount, project leader, and approval process information; The project basic information management module is also used to classify and tag projects according to the project core information, and generate project classification information; wherein, the project classification information includes infrastructure projects, technological transformation projects and R&D projects.

3. The system according to claim 1, characterized in that, The project status information includes: project initiation status, execution status, suspension status, completion status, and final settlement status; The project basic information management module is also used to update the project status information in response to user operations on project status changes.

4. The system according to claim 1, characterized in that, The project basic information management module is also used to respond to the user's status query operation on the project status information, determine the corresponding target project, and display the target project.

5. The system according to claim 1, characterized in that, The project's basic data includes budget item system data, contract type dictionary data, and department / personnel organizational structure data; wherein, the budget item system data includes construction and installation engineering costs and equipment purchase costs, and the contract type dictionary data includes engineering contracts, procurement contracts, and service contracts; The project basic information management module is also used to respond to user extension operations by extending the project basic data so that the extended project basic data can be adapted to project requirements.

6. The system according to claim 1, characterized in that, The project budget preparation module is also used to generate the project budget information in response to the user's budget preparation operation.

7. The system according to claim 1, characterized in that, The project budget preparation module is also used to respond to the user's budget adjustment operation, adjust the project budget information, and generate the latest version of the project budget information.

8. The system according to claim 1, characterized in that, The monitoring data includes at least one of the following: estimated amount, amount used, remaining amount, and execution progress value; The process management module is also used to generate the overspending warning information based on the monitoring data and preset thresholds, and to display the overspending warning information.

9. The system according to claim 1, characterized in that, The process management module is also used to obtain basic contract information and classify contracts according to the basic contract information; wherein, the basic contract information includes at least one of the following: contract name, contract number, partner, contract amount, signing date and contract type.

10. The system according to claim 9, characterized in that, The process management module is also used to obtain contract payment information and update the contract payment progress information according to the contract payment information; wherein, the contract payment progress information includes: advance payment, progress payment and final payment.

Images