Financial Summary
| Activity | Achieved / Total | Progress | Status | Action |
|---|
| 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.
% 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 Value = Contract Value × (Milestone % / 100) × (Stage Weight % / 100)
Executed Value = Stage Value × (Physical Progress / 100)
Current Payable = Executed Value − Previously Paid Amount
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
- Create the project.
- Enter the contract value.
- Create Schedule-H milestones.
- Assign stage weightage.
- Enter physical activity quantities.
- Update achieved quantities periodically.
- Review execution percentage.
- Review calculated payable amount.
- Approve certified payment stages.
- Export JSON as a periodic backup.
- 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.
0 Comments
If you have any doubts, suggestions , corrections etc. let me know