Subcontractor Payment Schedule Calculator
ANA›Life Services Authority›National Calculator Authority›Subcontractor Payment Schedule Calculator
.calc-container { max-width: 640px; margin: 2rem 0; padding: 1.5rem; background: #fff; border: 1px solid #ddd; border-radius: 8px; box-shadow: 0 1px 3px rgba(0,0,0,0.06); font-family: system-ui, -apple-system, sans-serif; } .calc-container h3 { font-family: Georgia, serif; font-size: 1.15rem; color: #1a1a1a; margin-bottom: 1rem; padding-bottom: 0.5rem; border-bottom: 2px solid var(--ac, #3d5a80); } .calc-row { display: flex; align-items: center; gap: 0.75rem; margin-bottom: 0.75rem; flex-wrap: wrap; } .calc-row label { min-width: 160px; font-size: 0.9rem; color: #333; font-weight: 500; } .calc-row input[type="number"], .calc-row select { flex: 1; min-width: 120px; max-width: 200px; padding: 0.5rem 0.6rem; border: 1px solid #ccc; border-radius: 4px; font-size: 0.9rem; font-family: system-ui, sans-serif; color: #1a1a1a; background: #fafaf8; } .calc-row input:focus, .calc-row select:focus { outline: none; border-color: var(--ac, #3d5a80); box-shadow: 0 0 0 2px rgba(26,74,138,0.12); } .calc-row .unit { font-size: 0.82rem; color: #888; min-width: 30px; } .calc-btn { display: inline-block; margin-top: 0.5rem; padding: 0.55rem 1.5rem; background: var(--ac, #3d5a80); color: #fff; border: none; border-radius: 4px; font-size: 0.9rem; font-weight: 600; cursor: pointer; font-family: system-ui, sans-serif; } .calc-btn:hover { opacity: 0.9; } .calc-result { margin-top: 1.25rem; padding: 1rem 1.25rem; background: #f0f6fc; border-left: 3px solid var(--ac, #3d5a80); border-radius: 0 6px 6px 0; display: none; } .calc-result.visible { display: block; } .calc-result-label { font-size: 0.78rem; text-transform: uppercase; letter-spacing: 0.06em; color: #666; margin-bottom: 0.25rem; } .calc-result-value { font-size: 1.6rem; font-weight: 700; color: var(--ac, #3d5a80); } .calc-result-detail { font-size: 0.85rem; color: #555; margin-top: 0.5rem; line-height: 1.5; } .calc-note { margin-top: 1rem; font-size: 0.8rem; color: #888; font-style: italic; } .calc-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 0.75rem; margin-top: 0.75rem; } .calc-grid-item { padding: 0.6rem 0.8rem; background: #f8f9fa; border-radius: 4px; border: 1px solid #eee; } .calc-grid-item .label { font-size: 0.75rem; color: #888; text-transform: uppercase; letter-spacing: 0.04em; } .calc-grid-item .value { font-size: 1.1rem; font-weight: 600; color: #1a1a1a; } @media (max-width: 720px) { .calc-row { flex-direction: column; align-items: flex-start; gap: 0.3rem; } .calc-row label { min-width: auto; } .calc-row input[type="number"], .calc-row select { max-width: 100%; width: 100%; } .calc-grid { grid-template-columns: 1fr; } } .calc-chart { margin: 1rem 0; text-align: center; } .calc-chart svg { max-width: 100%; height: auto; } .calc-chart-legend { display: flex; flex-wrap: wrap; justify-content: center; gap: 0.6rem 1.2rem; margin-top: 0.6rem; font-size: 0.8rem; color: #555; } .calc-chart-legend span { display: inline-flex; align-items: center; gap: 0.3rem; } .calc-chart-legend i { display: inline-block; width: 10px; height: 10px; border-radius: 2px; font-style: normal; } .calc-related { max-width: 640px; margin: 2rem 0 1rem; padding: 1.25rem 1.5rem; background: #f8f9fa; border: 1px solid #e8e8e8; border-radius: 8px; } .calc-related h3 { font-family: Georgia, serif; font-size: 1rem; color: #1a1a1a; margin: 0 0 0.75rem; padding-bottom: 0.4rem; border-bottom: 2px solid var(--ac, #3d5a80); } .calc-related-list { list-style: none; padding: 0; margin: 0 0 0.75rem; display: grid; grid-template-columns: 1fr 1fr; gap: 0.4rem 1.5rem; } .calc-related-list li a { font-size: 0.88rem; color: var(--ac, #3d5a80); text-decoration: none; } .calc-related-list li a:hover { text-decoration: underline; } .calc-browse-all { margin: 0.5rem 0 0; font-size: 0.9rem; font-weight: 600; } .calc-browse-all a { color: var(--ac, #3d5a80); text-decoration: none; } .calc-browse-all a:hover { text-decoration: underline; } @media (max-width: 720px) { .calc-related-list { grid-template-columns: 1fr; } }
Subcontractor Payment Schedule Calculator
Calculate progress payment schedules for subcontractors including retainage withholding, milestone-based payments, and final release amounts.
Total Contract Value ($)
Retainage Percentage (%)
Number of Progress Payment Milestones
Mobilization Payment (% of Contract)
Materials Stored on Site (% of Contract)
Current Work Completed (%)
Previously Paid Amount ($)
Calculate Payment Schedule
function subCalc() { var contractValue = parseFloat(document.getElementById('sub_contract_value').value); var retainagePct = parseFloat(document.getElementById('sub_retainage_pct').value); var numMilestones = parseInt(document.getElementById('sub_num_milestones').value); var mobilizationPct = parseFloat(document.getElementById('sub_mobilization_pct').value); var materialsStoredPct= parseFloat(document.getElementById('sub_materials_stored_pct').value); var workCompletedPct = parseFloat(document.getElementById('sub_work_completed_pct').value); var prevPaid = parseFloat(document.getElementById('sub_prev_paid').value) || 0;
var errors = []; if (isNaN(contractValue) || contractValue 50) errors.push("Retainage Percentage must be between 0% and 50%."); if (isNaN(numMilestones) || numMilestones 12) errors.push("Number of milestones must be between 1 and 12."); if (isNaN(mobilizationPct) || mobilizationPct 30) errors.push("Mobilization Payment must be between 0% and 30%."); if (isNaN(materialsStoredPct) || materialsStoredPct 100) errors.push("Materials Stored percentage must be between 0% and 100%."); if (isNaN(workCompletedPct) || workCompletedPct 100) errors.push("Work Completed percentage must be between 0% and 100%."); if (prevPaid contractValue) errors.push("Previously Paid Amount cannot exceed the Total Contract Value."); if ((mobilizationPct + materialsStoredPct) > 100) errors.push("Mobilization % + Materials Stored % cannot exceed 100%.");
var resultDiv = document.getElementById('sub_result'); if (errors.length > 0) { resultDiv.style.display = 'block'; resultDiv.innerHTML = 'Please fix the following:' + errors.map(function(e){ return ''; }).join('') + ''; return; }
/ ── Core Calculations ── /
// Scheduled Value breakdown var mobilizationAmt = contractValue * (mobilizationPct / 100); var materialsStoredAmt= contractValue * (materialsStoredPct / 100); var remainingWorkAmt = contractValue - mobilizationAmt - materialsStoredAmt;
// Work completed value (applied to remaining work portion) var workCompletedAmt = remainingWorkAmt * (workCompletedPct / 100);
// Total earned to date // Earned = Mobilization + Materials Stored + Work Completed on remaining scope var totalEarned = mobilizationAmt + materialsStoredAmt + workCompletedAmt;
// Retainage withheld on work completed and materials stored (not on mobilization) var retainageBase = workCompletedAmt + materialsStoredAmt; var retainageHeld = retainageBase * (retainagePct / 100);
// Net earned after retainage var netEarned = totalEarned - retainageHeld;
// Current payment due = Net Earned - Previously Paid var currentPaymentDue = netEarned - prevPaid; if (currentPaymentDue ' + '' + (isFinal ? 'Final / Closeout' : 'Milestone ' + i) + '' + '' + milestonePct.toFixed(0) + '%' + '$' + fmt(milestoneWorkAmt) + '' + '$' + fmt(milestoneRetainage) + '' + '$' + fmt(isFinal ? milestoneRetainage : 0) + '' + '$' + fmt(displayPmt) + '' + ''; }
function fmt(n) { return n.toLocaleString('en-US', {minimumFractionDigits:2, maximumFractionDigits:2}); }
var overallPct = (totalEarned / contractValue * 100).toFixed(1);
resultDiv.style.display = 'block'; resultDiv.innerHTML = '### Payment Schedule Summary ' + '' + 'ItemAmount' + 'Total Contract Value$' + fmt(contractValue) + '' + 'Mobilization Payment$' + fmt(mobilizationAmt) + ' (' + mobilizationPct.toFixed(1) + '%)' + 'Materials Stored on Site$' + fmt(materialsStoredAmt) + '' + 'Work Completed Value$' + fmt(workCompletedAmt) + ' (' + workCompletedPct.toFixed(1) + '% of scope)' + 'Total Earned to Date$' + fmt(totalEarned) + ' (' + overallPct + '% complete)' + 'Retainage Withheld (' + retainagePct.toFixed(1) + '%)-$' + fmt(retainageHeld) + '' + 'Net Earned (After Retainage)$' + fmt(netEarned) + '' + 'Previously Paid-$' + fmt(prevPaid) + '' + 'Current Payment Due$' + fmt(currentPaymentDue) + '' + 'Balance to Finish (Excl. Retainage)$' + fmt(balanceToFinish) + '' + 'Total Retainage at Completion$' + fmt(totalRetainageIfComplete) + '' + 'Estimated Final Payment (Balance + Retainage Release)$' + fmt(finalPayment) + '' + ''
- '### Milestone Payment Schedule '
- 'Equal-interval milestones based on ' + numMilestones + ' progress payments after mobilization.
' + '' + '' + 'Milestone% CompleteWork ValueRetainage HeldRetainage ReleasedPayment Due' + milestoneRows + ''
- ''
- 'Note: Retainage is fully released at the final milestone/closeout. '
- 'Mobilization is excluded from retainage calculations per standard AIA practice.'
- ''; }
#### 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.
More Calculators
- Humidity and Cooling Load Calculator
- Oregon Fuel Cost Comparison Calculator — compare natural gas, electric, oil, and heat pump costs using Oregon utility rates
- Ventilation Rate Calculator — calculate required fresh air exchange rates per Oregon mechanical code and ASHRAE 62.2
- Oregon Rebate Savings Estimator — estimate Energy Trust of Oregon and utility rebates for qualifying HVAC equipment upgrades
- Energy Savings Calculator (Old vs New HVAC System)
- AC Unit Size Calculator (BTU for Phoenix Climate)
Read Next
Study Time Planner ANA › Life Services Authority › National Calculator Authority › Study Time Planner .calc-container { max-width: 640px; margin:...