Available in Sage 50 Quantum Accounting.

How to Set Up Sage 50 to Handle Retainage

Related topics

Setting up Sage 50 to handle retainage is easy and can be accomplished in three steps.

Note: You must have created general ledger accounts with Account Types of Payables Retainage and Receivables Retainage before retainage fields will be visible on various windows throughout Sage 50 Quantum Accounting.

Create General Ledger accounts for Accounts Receivable Retainage and Accounts Payable Retainage.

Select Maintain, Chart of Accounts. This will open the Maintain Chart of Accounts window.
Enter an appropriate Account ID and Account Description.
Select the appropriate Account Type, either Receivable Retainage or Payable Retainage.
Save the new accounts.

Warning! You must use these special Account Types to have the Job Retainage report properly track retainage.

Enter the correct retainage General Ledger accounts in Job Defaults.

Select Maintain, Default Information, Jobs.
Select the Billing & Retainage tab.
Select or enter the appropriate accounts.
You may also enter a company-wide default Retainage % here.
Click OK..

Enter the appropriate percentage for retainage for each job.

Select Maintain, Job Costs, Jobs to open the Maintain Jobs window.
Select the job record
Enter the appropriate percentage in the Retainage Percent field. It will default to the value set in Job Defaults, if any.
Save the record.

Once you have set up these fields, Sage 50 will automatically calculate the correct amounts for retainage on your customer invoices, based on each job, and assign these amounts to the correct general ledger account.

Note that there is no default percentage for retainage on vendors. The percentage or amount of retainage for each job will be entered manually from each purchase invoice (vendor bill).