Subcontractor Payment Schedule Calculator
Calculate progress payment schedules for subcontractors including retainage withholding, milestone-based payments, and final release amounts.
Formulas Used
Total Earned to Date:
Earned = Mobilization Amount + Materials Stored Amount + (Remaining Work Value × Work Completed %)
Retainage Withheld:
Retainage = (Work Completed Amount + Materials Stored Amount) × Retainage %
Net Earned (After Retainage):
Net Earned = Total Earned − Retainage Withheld
Current Payment Due:
Payment Due = Net Earned − Previously Paid Amount
Milestone Payment (per interval):
Milestone Work Value = (Contract Value − Mobilization) ÷ Number of Milestones
Milestone Payment = Cumulative Net Earned at Milestone − Cumulative Previously Paid
Final Payment:
Final Payment = Balance to Finish + Total Retainage Held
Assumptions & References
- Retainage is withheld on work completed and materials stored, but not on mobilization payments, consistent with AIA Document A401 and A201 standards.