Available in Sage 50 Quantum Accounting.
How to Set Up Sage 50 to Handle Retainage
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.
- 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.
Warning! You must use these special Account Types to have the Job Retainage report properly track retainage.
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: 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).