Retainage Calculation Example

In this example, the information in this table is set up in the Retainage Rules Information table (F5204):

Percent Retainage

Percent Complete

10 percent

50 percent

5 percent

95 percent

The billing line types to include are cost billing lines only, and the Cumulative check box is selected.

The total schedule of values is 500,000 and the invoice amount is 485,000.

The invoice amount of 485,000 is 97 percent of the total schedule of values of 500,000.

Because the first line of the table goes through 50 percent complete, 10 percent retainage is calculated on the first 250,000 (the first 50 percent of the schedule of values) of the invoice.

250,000 x 10 percent = 25,000

Because the second line of the table goes through 95 percent complete, 5 percent retainage is calculated on the next 225,000 (the next 45 percent of the schedule of values) of the invoice.

225,000 x 5 percent = 11,250

Because no lines remain in the table, no retainage is calculated on the remaining 10,000 of the invoice.

The total retainage for this invoice is calculated as:

25,000 + 11,250 = 36,250