Problem: How to create retention purchasing?

Solution: Enable settings for retention purchasing and create documents as shown below.


Retention refers to a portion of the payment withheld from a contractor or supplier to ensure that all contractual obligations are fulfilled satisfactorily.

This practice is a financial safeguard, ensuring that any defects or incomplete work can be addressed before the final payment is released.


1. Settings

To work with retention- go to Administration > General Settings > enable the option Enable Retention Purchasing.


2. Configuration per contract

After settings, make sure to enable the option per contract under the terms tab

  • Enable the option- Apply Retention
  • Retention %- add the default percentage for the amount to be retained
  • Retention- add the Retention days, for how many days the amount will be retained


3. Record Document

 Record Invoice received document

Once the settings are done, the contract can be used in the Invoice received document to record the transaction.
Create a new invoice received document, make sure to choose the right contract. With selection, the options will be enabled automatically.

In the inventory tab, the retention % and period will be filled automatically

Once the data is entered, post the document. The below entry will be created:

Dr Goods

Cr Current Trade Payables


4. Settings in General Ledger

Before generating the Retention document, set up a new GL account under the Trade Payable section to track retention purchases.

Navigate to Chart of Accounts > Create a new GL Retention Purchasing. Use the copy feature to duplicate the existing GL account, then modify the code and include a description.

 


5. Retention Transaction

To transfer the trade payable balance to retention, generate a Retention Transaction (Purchasing) using the Generate option.

In the main tab, set the transaction type to Accrual, and the remaining details will populate automatically. Select the appropriate Retention Payable GL Account, ensuring it is the same GL account created above.

The retention amount will be calculated automatically based on the Retention %.

The entry will be Dr Current Trade Payable

                            Cr Retention Purchasing


6. Payments

Both balances are categorized under Trade Payables. However, when a Retention Document is created, a portion of the payable is withheld and will not be paid until the agreed period ends.

When processing the Bank Payment, the invoice received is split into two sections, post the document, excluding the retained amount from the payment.


Once the agreed period ends, the retained amount can be released by using the Transaction Type as a reverse option in the Retention Purchase Document. To do this, create a Reversal Document by using the Generate Retention Transaction (Purchasing).

The details will be filled automatically, check the details and post the document. 

The below entry will be created:

DR Retention purchasing

CR Current Trade Payables


Create a Bank/Cash Payment Document using the Generate option from Invoice Received to process the final payment and close the invoice.


Thank you  for being a FirstBIT customer!                           

#Retention Purchasing #Retention                                  

  • No labels