General contractors face an unspoken financial liability in all projects - the retained balance that lies dormant in someone else's bank account until closeout. The problem is not in the retained balance itself. The problem is in its poor management. Change orders affect the basis for payments, payment applications accumulate month after month, and lien waiver requirements establish a chain of documents that can be easily broken. Once a release threshold is reached, chances are high that the numbers on your Excel spread sheets no longer match your contract.

This blog provides you with a practical process. You will understand the mathematical nature of the retained balance, its calculation on change orders, and the configuration of Dock 365 (based on Microsoft 365) to save retainage terms, enforce waiver gating, send notifications about release of retained balance and report on it.

Who this is for: general contractors, project finance leads, and legal operations managers who track retainage across multiple subcontracts.

Prerequisites: basic familiarity with contract records in Dock 365; edit access to contract metadata fields and obligation/milestone configuration.

Difficulty: intermediate.

Estimated setup time: 2 to 4 hours for initial configuration per contract template.

What is retainage, and why does tracking it cost you money when it fails

Retainage, which may also be known as retention, is financial leverage used by project owners or general

contractors. As stated in the definition of retainage given by Levelset, retainage is a certain percentage of funds that are withheld per every progress payment, generally ranging from 5% to 10% and that serves as a buffer against any defect or unfinished punch list items.

The concept is simple: every time there is an approval of a payment application, there is always some money that will be held back. This becomes part of the retained amount, which becomes bigger per every cycle of pay. Portions of the retained amount will then be freed up during designated milestones, generally substantial completion and final acceptance, as long as the necessary paperwork is complete.

The challenge for a team comes with the difference between "planned retainage" and "actual released retainage". Once there are approved changes orders during the middle of the project, the payment base will now be different. The calculation of the retainage held back will have to be redone; otherwise, dispute resolution becomes difficult without any traceable documentation.

The retainage lifecycle has five checkpoints you need to manage:

• Start of withholding - retainage rate and release schedule are defined in the contract
• Progress application withholding - each pay app generates a withheld amount
• Retainage accumulation - withheld amounts build a running retained balance
• Release milestones - substantial completion and final acceptance trigger partial or full release
• Final closeout - all retainage is released, all waivers are collected, and contract obligations closed

Configuring retainage terms in Dock 365

While Dock 365 does not include an out-of-the-box "retainage module," all retainage functionality can be configured through its custom contract metadata fields, obligation milestones, and hierarchical contract relationships. This will allow us to put retainage information on the contract record, record retainage as obligation milestone values each time money is withheld on the pay applications, and control release based on documentation.

Here's the minimum data model you'll set up:

• Contract record (the subcontract or owner contract)
• Retainage term set stored as custom metadata fields
• Pay application obligations (one per pay cycle)
• Release milestones (Substantial Completion Release, Final Acceptance Release)

Automating retainage release notifications and approval routing

Large-scale manual tracking simply won’t work. Trying to juggle 12 different subcontracts at once, your spreadsheet

will not remind you that a significant completion release is coming up in two weeks, or that you need a waiver.

Dock 365 features automated milestones and expiration alerts, customizable to trigger at certain intervals before the milestone date of the release.

Step 1: Set up milestone reminders

For each of your retainage release milestones (Substantial Completion Release, Final Acceptance Release), configure automated alerts:

• 30 days before milestone due date: notify project manager and finance contact
• 14 days before: escalate to contract owner if documentation is still incomplete
• On milestone due date: notify all stakeholders

Use Dock 365's Teams and Outlook integrations to route these alerts into the channels your team already monitors, rather than a separate inbox no one checks.

Step 2: Configure approval routing for release

If a release milestone is transitioned into "In Progress" status, trigger an approval process by sending a request to the appropriate approvers (e.g., PM for completing field, Finance for completing payment application, and Legal for completing waiver). The approval process in Dock 365 allows you to set the order of the workflow and the evidence needed from each approver.

Step 3: Define release readiness checkpoints

Before any release milestone can be marked complete, the following should be confirmed in the milestone record:

• Conditional lien waiver received (for substantial completion partial release)
• Unconditional lien waiver received (for final acceptance release)
• Payment application for the period has been approved
• Punch-list status confirmed (for substantial completion)
• Release amount calculated and recorded in Actual Released Amount field

Warning: don't configure alerts for every field update or you'll generate noise that causes teams to ignore notifications entirely. Reserve automated escalation for the two scenarios that actually matter: an approaching milestone date when documentation is incomplete, and a milestone that has passed its due date without being closed.

Reports and dashboards for retained balances across your portfolio

The perspectives required by finance and project management on retainage are unique. The field team requires information on the issues holding back the release while the leaders require knowledge on the locations of tied up funds as well as any retainage that is held beyond the milestone date.

Step 1: Build a retained-balance report view

In Dock 365's reporting module, create a filtered contract report with these columns:

• Project / Contract name
• Retainage rate
• Current retained balance
• Planned release date (from milestone record)
• Milestone status (Planned / In Progress / Complete / Blocked)
• Conditional waiver received (yes/no)
• Unconditional waiver received (yes/no)
• Days until / since milestone due date

Filter this report by milestone status to quickly surface contracts where a release is approaching or overdue.

Step 2: Build targeted dashboard views

Three quick-check dashboards cover most operational needs:

• Retainage nearing release - contracts with a release milestone due within 30 days, grouped by project and milestone status
• Release completed but waiver pending - contracts where Actual Released Amount is populated but Unconditional Lien Waiver Received = No
• Retained balance stuck past milestone date - contracts where the milestone due date has passed but status is not "Complete"

The third dashboard is your early warning system for disputes. If a retained balance is sitting past its contractual release date, you need to know before the subcontractor raises a claim.

Troubleshooting report mismatches

If a retained balance figure in your report doesn't match the contract record, check these in order:

• Effective dates / through dates on pay application obligation entries (a missing or wrong through date can exclude amounts from the running balance calculation)
• Parent-child linkages for change orders (if a change order child record isn't linked to the correct parent, its payment base adjustment won't roll up)
• Amendment versions (confirm you're reporting against the current approved contract version, not a superseded draft)

As the software executes in your own tenant in Microsoft 365, the contract information, its history, and its obligations will be always confined to the secure perimeter of your company. The SOC 2 Type II compliance and SharePoint-based storage make it possible to have your disputes resolved without transferring any information to a third-party application.

Common bottlenecks and how to resolve them

• "My retained balance doesn't match the contract total" - check whether all change order child records are

• linked to the parent and whether each pay application obligation entry has the correct through date.
• "The waiver is attached but the milestone won't close" - confirm the waiver is attached to the milestone record, not just the pay application entry. They're separate records in Dock 365.
• "The change order isn't showing in the retained balance rollup" - verify the child record type is set correctly (Change Order, not just a note) and that the parent-child link is established.
• "Milestone alert fired but the milestone was already complete" - check whether the milestone status was updated before the alert rule was adjusted. Update the rule to exclude milestones with status "Complete" to avoid repeat notifications.

The initial setup process will take the most work to get right in the first two to three contracts. After that, the contract template will carry over the field and obligations structure. Dock 365's onboarding process typically takes around 6 to 8 weeks, giving you enough time to work with the implementation team and develop retainage metadata fields and milestone structures right into your standard construction contract templates.

When the workflow is live, the following steps are easy to perform—modify the metadata fields to fit your contract language (mainly the step-down rate threshold and lien waivers, which differ depending on your state and contract type), do a dry-run with your approvers, and create the three retainage balance dashboards.

Retainage management solutions do not have to be a separate software for the construction teams. The right setup will allow the contract management solution for the general contractors dealing with change orders and retainage management to work seamlessly in the tools used daily.

Schedule a free demo with Dock 365

‍