Using Retainage (Holdback) Accounting

If you use retainage accounting in Accounts Payable, Purchase Orders lets you account for retainage (or a holdback) that occurs when you withhold a percentage of an invoiced amount, usually by mutual agreement or according to a statute (such as a Builders Lien Act).

Note that you can only specify retainage if you are using Sage ERP Accpac's Project and Job Costing module, and the transaction is job-related.

There are three steps in processing retainage:

1. First, you process a receipt, invoice, debit note or credit note that specifies a holdback (retainage) for the document.

2. The invoice or debit note with the retainage is transferred to Accounts Payable and posted in that program.

3. Later, you post a separate retainage invoice, debit note, or credit note to invoice the outstanding retainage amount.

Before Using Retainage Accounting

Before you can process retainage in Purchase Orders, you must:

• Set the option to use retainage accounting on the Processing tab of the A/P Options form.

• Specify default retainage settings for vendors on the Retainage tab of the A/P Options form.

• Specify a retainage control account for each account set in your Accounts Payable system.

• Set up contracts in Project and Job Costing.

Entering Original Documents with Retainage

An invoice, debit note, or credit note from which retainage is taken is called an original document in Sage ERP Accpac Advantage Series.

You enter the receipt, invoice, debit note, or credit note using the standard P/O entry forms. To indicate that retainage applies to the document, however, you select the Job-Related Option and the Retainage option. (Note that this option appears only if you selected the Retainage Accounting option for your Accounts Payable system.)

The program then displays the Retainage tab for the entry form, where you can specify the retainage rate and the retainage terms. You then specify the retainage percentage and the retention period on each detail line.

• Retainage Percentage

  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.

• Retention Period

  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

  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:

  • Use Original Document Exchange Rate - to use the same rate as the document you are processing.

  • Use Current Exchange Rate - to use the rate in effect when you process the retainage document to clear the outstanding retainage.

• Retainage Terms

  You can use different terms for retainage documents (used to process invoices 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 vendor record, but you can change the retainage terms for a document, if you wish.

Taxes on Retainage

Note that all tax amounts are included on the original retainage document. No tax amounts are included on the retainage invoice, debit note, or credit note that you process to clear the outstanding retainage amount.

Posting original invoices, debit notes, and credit notes

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

For example, if you enter an invoice for $10,000 with 10% retainage, an 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:

• The retention period or retainage due date specified for the invoice.

• The number of days in advance specified on the A/P Options form for generating retainage documents.

Adjusting Original Documents

Use Adjustment Entry in Accounts Payable to change retainage related to existing invoices, debit notes, and credit notes. When you post the adjustment, the program adjusts the outstanding retainage account.

Note that Accounts Payable 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.