How Construction Retention Works
Retention is usually calculated as a percentage of eligible work billed during a payment period. The contract determines the percentage, whether it applies to stored materials, whether the rate changes after a milestone, and what documentation is required before release. The retained balance should be tracked separately from the amount currently payable so the business can see both near-term receipts and amounts expected later.
For example, a contractor submits an approved progress invoice for $40,000, with a contractual retention rate of 10%. The customer withholds $4,000 and pays $36,000, subject to other contract adjustments. The $4,000 remains outstanding under the retention terms until the agreed release conditions are met.
Finance staff should maintain a record of the original invoice, retained amount, release conditions, expected release date, and any subsequent adjustment. This makes it easier to distinguish ordinary overdue receivables from amounts that are not yet contractually payable.
Calculating and Tracking Retention
A basic calculation for retention on eligible billings is:
Retention withheld = Eligible progress billing × Retention percentage
Suppose eligible progress billing is $75,000 and the contract specifies 5% retention. The amount withheld is $75,000 × 5% = $3,750. The amount before other adjustments that remains payable for that billing is $75,000 − $3,750 = $71,250.
Where a project has multiple billing periods, the retained balance generally accumulates across approved applications and decreases when retention is released or adjusted. A useful reconciliation compares the retention recorded on each invoice with the cumulative amount withheld, amounts previously released, and remaining contractual balance. Contract-specific rules may change the calculation, so the agreement and approved billing documents remain the controlling references.
Records and Internal Controls
Accurate retention tracking relies on consistent customer, job, contract, and invoice data. Finance teams should confirm the applicable rate, eligible billing base, prior withheld amounts, approved change orders, and release conditions. They should also document whether retention is held by the customer, owed to a subcontractor, or tracked in another contractual relationship, since these situations affect accounting treatment and cash planning.
Retention reporting should show the project-level balance, the party responsible for payment, the release milestone, and any supporting evidence required. A review before month-end helps reconcile job records with accounts receivable and identify amounts approaching their contractual release dates.
Retention in construction billing is distinct from Statement Retention, which concerns keeping financial statements or related records for reference and compliance. It is also different from a Retention Ratio, a financial measure of the share of earnings retained in a business rather than distributed to shareholders. Distinguishing these terms prevents construction balances from being confused with document-retention policies or corporate finance metrics.
Improving Finance Workflows
Businesses can standardize retention reviews by defining who validates contract terms, who approves progress billing, and who confirms release eligibility. Human in the Loop review practices are useful when an invoice contains unusual deductions, a contract amendment changes the rate, or supporting evidence needs additional approval.
Finance automation tools may support these processes when configured to the organization's requirements. Hyperbots Platform offers company-specific workflow and ERP configuration options, while Process Specific Capabilities focus automation on defined finance activities. Ready to Deploy Capabilities provide preconfigured workflow components, and Self Learning Capabilities can use human feedback to refine supported processing decisions. The relevant controls and integrations should be validated for the specific Sage 100 environment.
For teams comparing finance automation across Sage products, the article AI Copilots for Sage 300 discusses potential productivity and accuracy improvements in Sage 300 workflows. It is a separate product context, so its capabilities should not be assumed to apply directly to Sage 100.
Likewise, a Sage Intacct Integration connects workflows with Sage Intacct rather than Sage 100; the product and integration requirements should be confirmed before selecting a solution.
Summary
Sage 100 Retention generally concerns monitoring amounts withheld from construction payments until contractual release conditions are met. Accurate calculations, clear supporting records, and regular reconciliation help finance teams track outstanding retainage, plan expected receipts, and maintain reliable project reporting. Because Sage 100 configurations differ, confirm how retention is represented and reconciled in the specific system and follow the applicable contract terms.