Skip to content
  • There are no suggestions because the search field is empty.

CREATING RETAINAGE (HOLDBACKS) WITH PURCHASE DOCUMENTS

How to Create the Retainage Entries from Purchase Documents

 How Retainage Works

Releasing Purchase Retainage 

Retainage is a portion of a vendor’s invoice that you hold back until the work is complete or a set date is reached. Retainage Payables handles this in four stages:

 

Stage

What happens

1

Set up

Retainage % and Retainage Terms Code are defined on the vendor (or project).

2

Withhold

Negative retainage lines are added to the purchase invoice or order to deduct the retainage.

3

Post

The vendor ledger entry shows the gross amount and the amount retained. The retainage is tracked separately in Vendor Retainage Entries.

4

Release

When the retainage is due, it is released as a new invoice and paid. See Releasing Purchase Retainage.

 

This article covers stages 1 to 3, plus reversing an invoice that carried retainage.

Example

A vendor invoices 2,097.20 (excluding tax) and the vendor’s Retainage % is 10:

 

Amount (excl. tax)

Invoice lines

2,097.20

Retainage withheld (10%)

–209.72

Payable to the vendor now

1,887.48

Payable later, when the retainage is released

209.72

 

Setup

Where

What to set

Vendor Card

Retainage % and Retainage Terms Code. These are copied to each new purchase document for the vendor.

Project Card

Retainage % and Retainage Terms Code. Used instead of the vendor’s values when a document has a Retainage Project No.

Payment Terms

The payment terms used as the Retainage Terms Code set how long retainage is held. For example, a 3-month term on a January 26 document gives a Retainage Due Date of April 26.

G/L Account, Item and Resource Cards

(Optional) Exclude from Retainage Payables Calculations. Lines using these records are left out of the retainage calculation by default.

Purchases & Payables Setup

(Optional) Allow Manual Retainage Lines. Turn on only if users need to enter retainage lines by hand.

 

Withhold Retainage on a Purchase Invoice 1. Create the invoice and check the header

Create the purchase invoice and enter the Vendor No. The following retainage fields fill in automatically:

Field

Description

Retainage %

The percentage of the invoice to hold back. Copied from the Vendor Card.

Retainage Terms Code

The payment terms that set when the retainage is due. Copied from the Vendor Card.

Retainage Due Date

Document Date + the Retainage Terms Code period. This is the estimated release date. You can change it.

Retainage Project No.

(Optional) Assigns the retainage on this document to a project, whatever project numbers are on the lines. When filled in, Retainage % and Retainage Terms Code are taken from the Project Card instead of the Vendor Card.

 

2. Enter the invoice lines

Enter the lines as normal. To leave a line out of the retainage calculation, select Exclude from Calculations on that line. This field is hidden by default, so add it with Personalize. For G/L account, item and resource lines it is filled in automatically from the card setting described in Setup.

3. Run Create Retainage Lines

Choose Create Retainage Lines from the action bar. The system adds one negative retainage line for each combination of Tax Liable, Tax Area Code and Tax Group Code found on the regular lines. Each retainage line’s tax fields are copied from its combination, and its Direct Unit Cost Excl. Tax is:

–1 × (total Line Amount Excl. Tax for that tax combination) × Retainage % / 100

The amount is negative because retainage reduces what you owe the vendor now.

Tax combination

Regular line amounts

Retainage %

Retainage line

Combination 1

784.00 + 470.40 = 1,254.40

10

–125.44

Combination 2

294.00 + 548.80 = 842.80

10

–84.28

Total

2,097.20

 

–209.72

 

Manual retainage lines

If Allow Manual Retainage Lines is on, you can also enter a retainage line yourself. Enter a negative amount in Direct Unit Cost Excl. Tax and set Retainage to Yes on the line. Remember that tax combinations must match when the retainage is released, so the automatic action is safer.

 

4. Post

Post the invoice as normal. See Review Posted Retainage below for what is created.

Withhold Retainage on a Purchase Order

Purchase orders work the same way as invoices, with two differences, because an order can be invoiced in several stages.

Retainage is calculated on Qty. to Invoice only

Run Create Retainage Lines before every posting with Invoice or Receive and Invoice. Only the quantities being invoiced in that posting are included:

–1 × SUM(Direct Unit Cost × Qty. to Invoice × (100 – Line Discount %) / 100) × Retainage % / 100

Tax combination

Calculation (Retainage 10%, Line Discount 2%)

Retainage line

Combination 1

(100.00 × 2 × 98% + 120.00 × 2 × 98%) × 10%

–43.12

Combination 2

(60.00 × 2 × 98% + 80.00 × 2 × 98%) × 10%

–27.44

 

Each posting creates its own retainage entry

Every invoicing of the order creates a separate vendor ledger entry and a separate Vendor Retainage Entry, each with its own due date. Each one can be released on its own.

Important – check the Retainage Due Date before each posting

The Retainage Due Date in the order header at the moment you post is the date saved on that posting’s retainage entry. Update it before every posting.

 

Steps for the second and later postings

  1. If the order is Released, choose Reopen.
  2. Update Vendor Invoice No. to the vendor’s invoice for this delivery, and update Retainage Due Date.
  3. Enter Qty. to Receive and Qty. to Invoice on each line.
  4. Choose Create Retainage Lines. The retainage lines from the last posting were used up, so new ones are needed.
  5. Post with Receive and Invoice or Invoice.

Create Retainage Lines for Many Documents

To process documents in bulk, open the Purchase Invoices, Purchase Orders, Purchase Credit Memos or Purchase Return Orders list. Select the documents and choose Create Retainage Lines. The Retainage Amount column (excluding tax) shows which documents already have retainage lines.

A document is skipped if:

  • it has no amount to invoice;
  • it already has retainage lines (existing lines are never recalculated or duplicated);
  • Retainage % is blank; or
  • Retainage Terms Code is blank (invoices and orders only).
  • Detail Entries – shows one line per tax combination on the original document.
  • Change Due Date – updates the Retainage Due Date after posting. Enter the new date and choose OK.

Review Posted Retainage

Posting a document with retainage lines updates two places.

Vendor Ledger Entries

Open the vendor and choose Ledger Entries. The entry for the posted invoice has these extra fields:

Field

Meaning

Gross Amount Inc. Ret.

Full invoice amount before retainage is deducted.

Ret. Amount / Ret. Amount Incl. Tax

Total retainage withheld, excluding / including tax.

Remaining Ret. Amount / Remaining Ret. Amount Incl. Tax

Retainage not yet released, excluding / including tax.

Project No. / Project Description

Filled in when the invoice had a Retainage Project No.

 

Vendor Retainage Entries

Open the vendor and choose Vendor Retainage Entries. This sub-ledger tracks retainage separately from accounts payable, with one entry per posted document that carried retainage, showing the remaining amount and whether it is open or closed.

 

Important – tax combinations must match

When retainage is released or reversed, the Tax Liable / Tax Area Code / Tax Group Code combinations on the new document must match the detail entries of the original. Don’t change tax fields on retainage lines.

 

Reverse an Invoice That Carried Retainage

To reverse a posted invoice with retainage, use a purchase credit memo filled by Copy Document. This carries the retainage lines across exactly.

  1. Create a new purchase credit memo.
  2. Choose Copy Document. Set Document Type to Posted Invoice and select the invoice.
  3. Check that the retainage lines were copied, then post.

On posting, the credit memo’s retainage is applied to the original invoice’s retainage. Both entries show as closed in Vendor Retainage Entries, with Remaining Ret. Amount of zero.

If you create a credit memo manually instead, Retainage % and Retainage Terms Code are copied from the vendor in the same way. Create Retainage Lines adds the retainage lines, which are negative here too. Because a credit memo reverses a liability, these lines reduce the retained amount that was originally withheld. The Retainage Due Date is hidden on credit memos and equals the Document Date.