These are the metadata fields worth capturing on each retainage record. You type them in; the goal is that any withheld slice can be found, totaled, and traced back to its invoice and its release proof.
- Invoice number and date
- The progress invoice this holdback was withheld from, so the record ties back to a specific billing. Attach the invoice PDF itself.
- Job / contract reference
- The project or contract name and number, so all of one job's withheld slices group together (for example, Job 2026-014 Maple St Renovation).
- Gross invoiced amount
- The full amount billed on that invoice before the holdback was deducted, giving the base the percentage was taken from.
- Retainage percentage
- The withholding rate that applied to this invoice (commonly 5% or 10%), since it can differ from job to job.
- Held-back amount
- The dollar value withheld on this invoice, the figure that matters most. This is what you total to see outstanding retainage.
- Release trigger
- The contractual event that makes the holdback payable, such as substantial completion, final inspection, or punch-list sign-off.
- Scheduled release date
- The date you currently expect the held-back amount to be released. Flag it as estimated if the triggering event has not yet occurred.
- Status
- Where the slice stands: Held, Release due, or Released. The status field is what turns the folder into an at-a-glance outstanding-retainage view.
- Release proof and date received
- Once paid, the remittance or receipt for the release payment and the date it landed, attached to close the record.