HOW-TO

How to record retention on a subcontractor payable invoice in Sage 100 Contractor

Short answer

Work out the retention under the contract, record the payable invoice for the full claim and the amount held back and track the retention balance for the vendor until you release it.

Last checked

Retention is an amount held back from a subcontractor's progress claim until the work is finished or defects are fixed.

The Sage 100 Contractor way

Where to find it: 4-2 Payable Invoices/Credits with 6-7-1 Subcontracts

  1. Set the retention rate on the subcontract record.
  2. Enter the subcontract invoice with the Subcontract# box.
  3. Retention is withheld at the subcontract rate.
  4. Release retention on one invoice or for the whole subcontract when due.

Limits in Sage 100 Contractor

  • Retention is excluded from invoice aging.
  • US construction rules are used.

Good to know in Sage 100 Contractor

  • No new invoice is needed to pay retention.

Words Sage 100 Contractor uses

  • Retention. Money held back from a subcontractor invoice until the job milestone is met.
  • Subcontract. A contract record with a subcontractor that invoices are checked against.

Example in Sage 100 Contractor

Example Concrete Subcontractors sends a progress claim for $20,000 on a subcontract with a 10% retention rate.

LineAmountTagged to
Payable now$18,000.00Job: Example Job A
Retention withheld$2,000.00Held on subcontract

Retention of $2,000.00 is withheld at the subcontract rate and $18,000.00 is payable now. It stays out of aging until released.

Common mistakes

  • Entering a subcontract invoice before the retention rate is set on the subcontract.
  • Expecting retention in the aging report.

More help

Sources

Last checked 2026-10-19. Confidence: confirmed.

Common questions

Where is the retention rate set?

On the subcontract record. Retention is withheld at that rate when you enter the invoice with the Subcontract# box.

Do I need a new invoice to pay retention?

No. You release retention on one invoice or for the whole subcontract when due.

Does retention show in aging?

No. Retention is excluded from invoice aging.

Does Pulsify track retention?

No. Track retention in your accounting system or a schedule.

Want this done for you?

Book a call to see how Pulsify handles supplier bills in Sage 100 Contractor.