Technology
"What’s the current progress percentage?" A call comes in from headquarters. The site manager opens an Excel file and realizes it was last updated three days ago. Things get even more complicated when it’s time to submit a progress invoice. By the time he’s pulled out the contract, the progress invoice, and the construction ledger to reconcile the numbers, half a day has already passed.
Progress and funding—two critical aspects of site operations—have long been managed separately. In this technical update, we’ll explore how RenameDP’s project document management, progress charts, and funding dashboards are seamlessly integrated into a single workflow.
As in previous articles, we’ll address structural issues before introducing new features. This time, we’ve chosen a problem that both on-site workers and managers can relate to.
The schedule is managed on-site. The person in charge directly updates when each work item starts and ends, as well as the current progress rate. The problem is that these updates depend on human input. The busier the site gets, the more the schedule updates get pushed back. This creates a time lag between the schedule viewed by headquarters and the actual progress on-site.
The financial status is even more complex. Contract amounts, progress payment claims, and actual disbursements are scattered across different documents. Every time a progress payment is claimed, the person in charge must gather the documents and manually enter and reconcile the figures. Errors can occur during this process, and the time required to grasp the current status is significant.
Managing these two sets of data separately creates another problem. When the project schedule is delayed, the timing of progress claims is also pushed back, yet there is no screen that shows this correlation in real time. Since the schedule and financial status have never been linked, the relationship between them is calculated only in the staff member’s head.
Explains how the automation of the financial status works. Explaining it in terms of the flow of “what data comes from which document” is more convincing than simply saying “AI analyzes it.”
RenameDP’s project document management goes beyond simply saving files. When documents such as construction logs or progress invoices are uploaded, VLM analyzes the content and automatically populates the necessary fields. Data that previously had to be manually copied—such as project name, client, contract amount, and progress invoice amount—is extracted directly from the documents.
This data flows into the financial dashboard. Key metrics—such as the ratio of progress invoices to the total contract amount, actual expenditure, and the funding execution rate relative to construction progress—are visualized as intuitive indicators. The process of manually entering numbers is eliminated, and the status is updated the moment a document is uploaded.
A key feature here is that document history is also managed. When a contract is amended, both the previous and current versions are preserved, allowing you to verify later which document served as the basis for the funding status calculation. The origin of the numbers is recorded in a traceable format.
The work schedule feature connects to the construction records and daily work logs discussed in the previous two articles. If the reader has already read those, this serves as a natural extension; even for first-time readers, it is written to be understood independently.
The progress chart is organized into a hierarchical structure of work categories, processes, and tasks. It consists of work categories as the top-level classification, with processes beneath them, and individual tasks arranged under those processes. The clearer this hierarchy is, the easier it becomes to grasp at a glance “which stage of the entire project is currently underway.”
As construction records and daily work logs accumulate on-site, that data is reflected in the progress status of the construction schedule. Even without the manager manually updating the schedule, the work performed on-site automatically updates the schedule. This structure ensures the construction schedule is perfectly synchronized with the site in real time.
The dashboard displays tasks due today, delayed processes, and items scheduled for the next phase at a glance. You can keep track of everything from important announcements to remaining tasks without missing a beat. When a site manager is asked, “What percentage of the process is complete right now?” they can answer with just a single glance at the dashboard screen, without needing to open Excel.
Following the same pattern as the previous two articles, this section demonstrates the value created by the integration of each feature. I’ll use the “ask a question” pattern once.
Let me pose a question here.
What do you see when project progress and fund disbursement rates are displayed on the same screen?
If construction is 80% complete but fund disbursement is only at 60%, you can detect delayed billing or missed settlements early on. Conversely, if fund disbursement is ahead of schedule but construction is lagging behind, it’s time to review cost management. When the relationship between these two numbers becomes visible, signals emerge that were not apparent when looking at the individual figures alone.
This is why we integrate the project schedule and funding status into a single dashboard rather than keeping them separate. It’s a structure that goes beyond simply displaying each status; it allows you to interpret the relationship between the two.
Of course, this single screen does not replace all on-site decision-making. However, there is a practical difference between a structure where “the construction schedule is on the site manager’s computer and the funding status is in an Excel spreadsheet in the office” and a structure where you view data from the same point in time on a single screen.
Although progress and funding are two aspects of site operations that must always be viewed together, they have long been managed separately. A system that automatically pulls data from documents, links field records to the progress chart, and brings both statuses together on a single screen represents an approach that transforms the flow of information in site operations.
If you’d like to see how the financial dashboard and production schedule features work in the field, you can check them out via RenameDP.
