EPC Pro – Progress & Schedule-H Billing
Integrated Physical Progress, EPC Billing and Project Financial Monitoring
PROJECT:
Project Settings

Financial Summary

Total Earned / Paid
₹0
0% Financial Progress
PAID
₹0
BALANCE
₹0
Physical Progress Chart
Physical Progress Tracking
Activity Achieved / Total Progress Status Action
EPC Billing – Schedule-H
Milestone / Activity MS % Weight % Execution % Stage Value Payable Status Action

EPC Project Monitoring & Schedule-H Payment Tracking System

A Digital Solution for Integrated Physical Progress and Financial Billing Control


1. Introduction

This tool is an Engineering, Procurement & Construction project monitoring system designed to integrate physical progress tracking with financial billing under Schedule-H.

The system provides a common digital interface for monitoring executed quantities, physical progress, milestone-wise financial allocation and payment status.

2. Core Concept

The application operates through three interconnected layers:

  • Physical Progress Layer – records actual quantities executed at site.
  • Billing Layer – defines milestones, stages and financial weightages.
  • Financial Layer – calculates executed value, payable value, paid amount and balance.

3. Physical Progress Tracking

Each activity is monitored using its total quantity and achieved quantity.

Physical Progress:
% Progress = (Achieved Quantity / Total Quantity) × 100

The result is automatically capped at 100%.

4. Schedule-H Billing Structure

The billing structure consists of:

  • Milestones
  • Sub-activities / stages
  • Stage weightage
  • Physical execution
  • Payment status

5. Financial Calculation Logic

The maximum financial value of an individual stage is calculated from the contract value, milestone percentage and stage weight.

Stage Maximum Value

Stage Value = Contract Value × (Milestone % / 100) × (Stage Weight % / 100)
Executed Value

Executed Value = Stage Value × (Physical Progress / 100)
Current Payable

Current Payable = Executed Value − Previously Paid Amount
Important: This application is a project-monitoring and calculation aid. Actual payment certification should remain subject to the applicable EPC agreement, Schedule-H, Engineer's certification, measurements, quality records and contractual provisions.

6. Payment Approval

Select one or more Schedule-H stages using the checkboxes and select Approve & Pay.

  • The physical execution percentage is retrieved automatically.
  • Executed financial value is calculated.
  • Previously paid value is protected.
  • The paid value cannot exceed the calculated executed value.

7. Global Physical Milestones

Users can create physical progress targets such as:

  • 25%
  • 50%
  • 75%
  • 100%

The application calculates the overall physical progress using the financial weight of the configured Schedule-H stages.

8. IndexedDB Storage

Project data is stored locally in the browser using IndexedDB.

  • Works without a server database.
  • Supports multiple projects.
  • Data remains in the browser on the same device/browser.
  • JSON export provides an independent backup mechanism.

9. JSON Export and Import

The system supports:

  • Current project export
  • All project export
  • Selected project export
  • Smart project matching during import
  • Activity merging
  • Milestone merging
  • Stage merging
  • Progress preservation

10. Progress Chart

The chart displays activity-wise physical progress and is regenerated whenever project data is updated.

11. Print / PDF Report

The Print / PDF button opens a print-ready project report. From the browser print dialog, select Save as PDF to create a PDF report.

12. Key Advantages

  • ✔ Integrated physical and financial monitoring
  • ✔ Offline browser storage
  • ✔ Multiple project management
  • ✔ Schedule-H stage-wise monitoring
  • ✔ JSON backup and transfer
  • ✔ Activity-wise progress chart
  • ✔ Print-ready project report

13. Recommended Project Workflow

  1. Create the project.
  2. Enter the contract value.
  3. Create Schedule-H milestones.
  4. Assign stage weightage.
  5. Enter physical activity quantities.
  6. Update achieved quantities periodically.
  7. Review execution percentage.
  8. Review calculated payable amount.
  9. Approve certified payment stages.
  10. Export JSON as a periodic backup.
  11. Generate the project report.

14. Important Data-Control Note

Because the application uses browser IndexedDB, clearing browser site data can remove locally stored project information. Regular JSON export is therefore recommended as a backup.

Yogendra Gopal Borse

Yogendra Gopal Borse

Civil Engineer | Assistant Engineer Grade-I, Maharashtra PWD

B.Tech (Civil) from VJTI Mumbai. Experienced in bridge design, road works, estimation, project monitoring and digital engineering tools. Creator of YogiPWD – practical technical resources for civil engineers.

Read full About →