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:
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.)
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:
Retainage Amount. (specified for a document detail)
To calculate the retainage amount, the program multiples the document amount (or the document total, if you include taxes in retainage) by the retainage percentage. You can enter a new retainage amount, if necessary. When you enter an amount to replace a calculated amount, the program recalculates the retainage percentage.
The retainage amount is subtracted from the document amount (or the document total) to calculate the amount due.
Retainage Percentage. (specified for a document detail)
The program uses the retainage percentage to calculate the retainage amount.
You can enter a different retainage percentage in the Retainage Percentage (%) field. When you enter a new percentage, the program recalculates the retainage amount.
Retainage Due Date. (specified for a document detail)
The program calculates the retainage due date (the date the outstanding retainage is due for invoicing) by adding the number of days in the retention period to the original document date. You can enter a different due date.
Retention Period. (specified for a document detail)
The program uses the retention period to calculate the due date for the retainage document. When you change the retention period, the program recalculates the retainage due date, and vice versa.
Retainage Rate. (specified for the document on the Retainage tab)
You use this field to specify the method the program will use to determine the exchange rate for the retainage document when you eventually process it.
You can choose one of the following methods:
Retainage Terms. (specified for the document on the Retainage tab)
You can use different terms for retainage documents (used to invoice for outstanding retainage) than you used for the original document from which the retainage was taken.
The program displays the code specified for retainage terms in the customer record, but you can change the retainage terms for a document, if necessary.
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.
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:
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.
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
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.
Tax on retainage is processed according to the Report Tax option selected on the A/R Options screen. The option provides the following alternatives:
If you select this option, the program calculates and reports (posts) tax on retainage when you post an original document that includes retainage.
If you select this option, Accounts Receivable calculates tax when you post an original document, but reports (posts) the tax as required by each tax authority. The tax reporting requirements for each tax authority are specified by the Report Tax On Retainage Document option in Tax Services. The tax authority can specify No Reporting, At Time Of Retainage Document, or At Time Of Original Document.
Some tax authorities require you to report tax when you post a retainage document. Others let you report tax when you post an original document to which retainage applies.
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.
You can view retainage information on the following screen
Select a retainage transaction on a document tab, and then click the Edit button in the Document Number column to display information for the retainage document.
This screen shows:
The Outstanding Retainage field on the Activity tab of the Customers screen displays the amount of retainage outstanding for a selected customer.
For more information, see Printing the A/R Aged Retainage Report.
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.
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.