Track Retainage
Hold back a percentage of each invoice as retainage, see how much the customer still owes you in retainage, and bill it once the job is accepted.Updated Nov 9 2026
Before you start
- Mapping the retainage account needs the Admin role.
- Changing an order needs permission to edit orders.
- Billing the retainage needs the Can Edit Bill Only Invoices function (Accounting, Accounting Admin or Admin by default). Without it the Create Bill Only / Retainage Invoice button doesn't show.
- The invoice's LEDGER link shows only to users with the Accounting role or Admin.
- Ask your accountant which account retainage should post to: usually a retainage receivable account, sometimes a contract asset or liability account.
-
Map the retainage account
Do this once, before the first invoice with retainage.
- Go to Admin > Config Settings > GL Settings. The Configure GL Account Mapping list opens.
- Find the row whose Name is External Invoice - Debit Retainage To (raise Rows per page if it isn't on the first page). Rows ending in a location code, such as - MN, override it for that location.
- Open the row's actions and click Edit. The Edit GL Account Mapping window opens.
- In Account, search for and pick your retainage account.
- Click Save. Cetec shows Updated: External Invoice - Debit Retainage To.
-
Set the retainage on the order
- Open the customer's order.
- Click the pencil at the top right of the order header. The Order Edit window opens.
- Click Billing / Sales Information to open that section.
- Type the percentage to hold back in Retainage Percent (for example 10).
- Click Submit. Cetec shows Updated Ordhead Info. Under the order's lines, the totals now show Retainage (n%) as a deduction.
-
See what's being withheld
- Ship and invoice the order as usual. Each invoice holds back the percentage of its own lines.
- Open the invoice (from Sales > Invoices > Invoice List). Above Total, it shows Retainage (n%): with the amount held back in red. Total, the amount the customer pays now, is already reduced by it. The invoice PDF shows the same deduction.
- To see the total retainage a customer owes, open the customer and click A/R STATEMENT in its left-hand menu. Under Net Balance Due the statement shows Retainage Amount (all retainage not yet billed) and a Total including it.
-
Bill the retainage
- Go to Sales > Invoices > Invoice List and click Create Bill Only / Retainage Invoice.
- In Customer, search for and pick the customer.
- Choose Retainage and click Create. The Create Retainage Invoice page opens. No invoice has been made yet.
- Set the Invoice Date range to cover the invoices whose retainage you're billing (it starts one month back) and click Submit. The list shows the customer's invoices in that range whose retainage hasn't been billed yet. Check their Retainage Amount column: invoices with no retainage are listed too.
- Tick Create? on each invoice to bill and click Submit again. Cetec creates one invoice and opens it for editing, marked Retainage Invoice. It has one line with Qty 1 and a Resale equal to the total retainage of the invoices you ticked.
- On that line, type your retainage charge part (a non-inventory part, such as RETAINAGE) in Prcpart and pick it from the list. The part must already exist.
- In G/L Account, pick the same retainage account you mapped above, so the bill clears the retainage you were holding. Leave Retainage Percent in the header blank.
- Click Update. Cetec shows Invoice Updated. Send it to the customer like any other invoice.
Each original invoice now shows Retainage Billed on with a link to the retainage invoice, and its retainage drops off the customer's statement.
-
Find invoices with retainage
- On the Invoice List, add the Retainage filter and choose Only Withholding Retainage. The list shows invoices that held back retainage.
- To see the amounts, show the Retainage column.
- To find the retainage invoice for an original invoice, open the original and click the link next to Retainage Billed on.
-
Check the ledger
- On the invoice, click LEDGER in the left-hand menu. The ledger opens filtered to this invoice's entries.
- If the page shows a deprecation warning, click its current version link. The new Ledger list opens with the same search.
- On an invoice that withheld retainage, the retainage account is debited with the retainage (note Retainage Debit) and A/R is reduced by the same amount. On the retainage invoice, A/R is debited and the line's G/L Account (your retainage account) is credited.