About Processing Retainage

You can use Accounts Receivable to account for retainage (or a "holdback") that occurs when your customer withholds a percentage of an invoiced amount, usually by mutual agreement or according to a statute (such as a Builders Lien Act).

Before you can process retainage in Accounts Receivable, you must:

There are two steps in processing retainage:

  1. First, you post an original invoice, debit note or credit note that specifies a holdback (retainage) for the document.
  2. Later, you post a separate retainage invoice, debit note, or credit note to invoice the outstanding retainage amount.

Entering Original Documents with Retainage

An invoice, debit note, or credit note from which retainage is taken is called an "original document" in Sage 300.

You enter the original invoice, debit note, or credit note using the A/R Invoice Entry screen, as usual. To indicate that retainage applies to the document, you select the Retainage option. (This option appears only if the Retainage Accounting option is selected for your Accounts Receivable system.)

When you post a prepayment, Accounts Receivable applies it automatically to a matching invoice only if both the prepayment and the invoice are not job-related. If either the prepayment or the invoice is job-related, the program does not apply the prepayment.

The program then displays the retainage percentage, retention period, retainage rate, and the retainage terms from the customer record. You can change these retainage factors for a particular detail or for the document, as follows:

Apply Document Transactions

When you apply original debit notes or credit notes that include retainage using the A/R Invoice Entry screen, or when you apply credit notes using the A/R Receipt Entry screen, only the original document balances are affected.

Outstanding retainage amounts remain with original documents until you post retainage documents or adjustments to clear the outstanding retainage.

Posting Original Invoices, Debit Notes, and Credit Notes

When you post the original retainage document, the program deducts the retainage from the document total, and posts the amount to the retainage control account.

Example: You enter an invoice for $10,000 with 10% retainage. The invoice is posted for $9,000 with retainage outstanding of $1,000.

The retainage amount remains in the control account until you invoice it in accordance with:

Adjusting Original Documents

You can adjust retainage for existing invoices, debit notes, and credit notes using the A/R Adjustment Entry screen, as follows:

  • To change the retainage amount for an original document, you use the detail-entry table to adjust each detail or to add a new detail that includes retainage. Enter the amount by which to adjust retainage in the retainage debit or retainage credit fields on the table.

    You can also add retainage to a document that did not include retainage. You enter the retainage due date, as well as the retainage amount, for each detail on the detail-entry table. You also enter retainage terms and the retainage exchange rate for the document, if you are adding retainage to a document for the first time.

  • You specify retainage terms and the retainage exchange rate option for the whole document on the Retainage tab.

    Note: If retainage was included on the original document, the program uses the retainage exchange rate setting from the original document.

  • If you add a new detail to which retainage applies, the retainage document detail inherits the Discountable status from the distribution code used in the adjustment detail.

    If you do not use a distribution code in the adjustment detail, the retainage detail is discountable by default.

  • You can change both the retainage amount and add or change document details. The program then creates two entries: one for the detail adjustment, and the other for the retainage adjustment. It does not create a compound entry.

When you post the adjustment, the program adjusts the outstanding retainage account.

No Retainage Calculation for Adjustments

Accounts Receivable does not calculate any retainage on adjustment transactions. You must enter the retainage manually, whether you are adding it for the first time, or adjusting existing retainage debits or credits from original documents.

When you adjust retainage invoices, debit notes, and credit notes that you processed to clear outstanding retainage amounts, the Retainage Debit and Retainage Credit fields do not appear. You can change the distribution code, general ledger account, and debit or credit amount using the detail entry table, as you do for any adjustment that does not include retainage.

Note: Because outstanding retainage amounts have already been cleared, no adjustment to outstanding retainage is made. The adjustment is to the receivables control account and another account, such as an expense account, that you specify.

Invoicing Outstanding Retainage

You invoice for outstanding retainage amounts, or holdbacks, either manually, using the A/R Invoice Entry screen, or automatically, using the A/R Create Retainage Batch screen. For more information, see A/R Create Retainage Batch Screen.

If you have posted debit notes and credit notes to which retainage applied, you also create retainage debit notes and credit notes using the A/R Invoice Entry screen and the A/R Create Retainage Batch screen.

Note: Accounts Receivable uses the Summary detail type for processing outstanding retainage.

Invoicing Manually for Retainage

Normally, you would use the A/R Create Retainage Batch screen to invoice periodically for retainage. However, Accounts Receivable also lets you process outstanding retainage manually, as you require.

To invoice manually for outstanding retainage, or to manually process a credit note or debit note to clear an outstanding retainage amount, you use the A/R Invoice Entry screen.

You enter information for the retainage invoice, credit note, or debit note, as usual. However, to invoice for retainage, you must select Retainage Invoice, Retainage Credit Note, or Retainage Debit Note as the document type, consistent with the original retainage document for which you are now processing outstanding retainage.

Because outstanding retainage remains associated with the original retainage document, you must use a retainage invoice if the original document was an invoice, a retainage debit note if the original document was a credit note, and a retainage debit note if the original document was a debit note.

Use the Original Document field to specify the original retainage document for which you are processing the outstanding retainage.

When you post the retainage invoices, credit notes, or debit notes, the program transfers outstanding retainage amounts from the retainage control account to the receivables control account.

Taxes on Retainage

Tax on retainage is processed according to the Report Tax option selected on the A/R Options screen. The option provides the following alternatives:

Note: To report tax, the program posts tax amounts to a tax liability account and updates the tax tracking reports. The timing of the tax liability on retainage documents depends on the tax authority.

Viewing Retainage Information

You can view retainage information on the following screens and report:

Writing Off Outstanding Retainage Amounts

You use the A/R Create Write-Off Batch Screen to write off small or uncollectible outstanding retainage amounts from original retainage invoices, debit notes, or credit notes. For more information, see A/R Create Write-Off Batch Screen.

When you write off outstanding retainage, the program creates adjustments to remove balances from the retainage control account. A corresponding debit (or credit) to balance the entry is entered to the write-off account specified for the customer's account set.

Revaluing Outstanding Retainage Amounts

If you use multicurrency, when you run Revaluation, the program also revalues outstanding retainage amounts.

For revalued outstanding retainage, the program creates general ledger entries to adjust the retainage control account rather than the receivables control account.

The Revaluation Posting Journal includes a separate section for retainage after the current revaluation for each customer.

If you include job-related details on the posting journal, a new retainage section appears on the Summary page after the current job details.