How do I reduce retainage held on an Accounts Payable invoice?
Description
Cause
Resolution
  • If you decide to not pay a vendor the open retainage amount of a previously paid Accounts Payable invoice, follow Option 1.
  • If you want to remove retainage held from an invoice and keep the invoice amount unchanged, follow Option 2.
  • If you have retainage for multiple invoices from the same vendor that you don’t wish to pay, follow Option 3.
Note: Before you begin, decide if you want any invoice changes to affect a prior accounting period in General Ledger. If you don’t want the changes to affect a prior period, see DocLink: How do I change an Accounts Payable invoice without affecting a prior period? before proceeding with the solution.

 

Option 1: Reduce the open retainage and balance of a previously paid Accounts Payable invoice, write off the invoice balance
Note:
When reducing a partially paid invoice by the amount of open retainage, create negative lines of distribution to reverse the retainage. If you reduce the existing retainage amounts directly instead of creating negative lines of distribution, the retainage won’t remove correctly.

  1. In Accounts Payable, go to Tasks, Change Invoices.
  2. Enter the Vendor and Invoice to change.
  3. Reduce the invoice Amount to reflect the new invoice amount (the new amount should be the original amount less retainage).
  4. Press the Tab key until the cursor moves to the distribution grid.
  5. Create a new distribution line.
    1. Enter the commitment and/or job information.
    2. For the Amount, enter a negative amount equal to the amount that you reduced the invoice by (the retainage amount).
    3. Enter the same negative amount in the Retainage column.
  6. If the invoice has distribution lines for several jobs with open retainage amounts to remove, repeat step 5.
  7. Accept distributions and invoice changes.
    Tip: If you track tax amounts on each distribution, error messages may appear. Change the tax tracking setting (File, Company Settings, AP Settings, Invoice Settings, Tax Settings), make corrections to the invoice, and return the AP Settings to their original state.
  8. Click Finish and Start to print your journal.
  9. Pay the invoice.
    1. Paying the invoice is necessary for the invoice and all distribution lines to have a Status of Fully Paid.
    2. If you pay the invoice by itself, the check amount is zero.
    3. When using Select invoices to pay (SITP), be sure to select the Retainage invoices only box for the retainage to be paid instead of being held.
    4. If you use Record Manual Checks to pay this invoice, type 0.00 in Retainage Held for each distribution that is retainage only.
      Note: If you don't zero out Retainage Held amounts you will get an error about the amounts.

Option 2: Remove retainage held from an invoice and keep the invoice as Open and unpaid

  1. In Accounts Payable, go to Tasks, Change Invoices.
  2. Enter the Vendor and Invoice to change.
  3. Press the Tab key until the cursor moves to the distribution grid.
  4. Create a new line of distribution to remove the retainage amount.
    1. Enter the commitment and/or job information.
    2. For the Amount, enter a negative amount equal to the amount of unpaid retainage.
    3. Enter the same negative amount in the Retainage column. This reduces the retainage portion of the invoice.
  5. Create a new line of distribution to add back the retainage that was removed. This will recreate the non-retainage portion of the invoice.
    1. Enter the commitment and/or job information.
    2. For the Amount, enter a positive amount.
    3. Don’t enter an amount in the Retainage column.
  6. If the invoice has several distribution lines for several jobs with open retainage amounts you would like to remove, repeat steps 4 and 5.
  7. Accept distributions and invoice changes.
    Tip: If you track tax amounts on each distribution, error messages may appear. Change the tax tracking setting (File, Company Settings, AP Settings, Invoice Settings, Tax Settings), make corrections to the invoice, and return the AP Settings to their original state.
  8. Click Finish then Start to print your journal.
  9. Pay the invoice.
    1. Paying the invoice is necessary for the invoice to correctly show the amount of retainage.
    2. If you pay the invoice by itself, the check amount is zero.
    3. When using Select invoices to pay (SITP), be sure to select the Retainage invoices only box for the retainage to be paid instead of being held.
    4. If you use Record Manual Checks to pay this invoice, type 0.00 in Retainage Held for each distribution that is retainage only.

Option 3: Have retainage left to pay for multiple invoices for the same vendor that you don’t wish to pay

  1. In Accounts Payable, go to Tasks, Enter Invoices to enter a credit invoice
  2. Select the Vendor and enter an Invoice number.
  3. Enter a negative Amount (the total of all the invoice amounts that are to be reduced or removed).
  4. Add a line of distribution with the commitment and/or job information and enter a negative amount in the Amount and the Retainage columns.
  5. If there are multiple accounts, commitments or jobs affected, add a negative line of distribution for each. This should total to the Invoice negative amount.
  6. Accept your distributions and Accept your invoice.
  7. Click Finish and Start to print your journal.
  8. Pay the invoice.
    • Paying the invoice is necessary for the invoices and distribution lines to have a Status of Fully Paid.
    • If you pay the credit invoice and the outstanding invoices together, the check amount is zero.
    • When using Select invoices to pay (SITP), select the Retainage invoices only box for the retainage to be paid instead of being held. The message, "There is more than just retainage to be paid on this item. Pay retainage along with remaining amount?" may appear. Click Yes.
    • If you use Record Manual Checks to pay this invoice, type 0.00 in Retainage Held for each distribution that is retainage only.

Notes: Invoice changes post to the accounting date of the invoice. If that period is closed and you don’t want to post any entries to the original accounting date of the invoice, change the accounting date of the invoice to your current period. After you accept your invoice changes in Change Invoices, you can select the accounting date of the reversing entries. Select the Revised accounting date.

Need more help?

Chat now

 



Steps to duplicate
Related Solutions

How do I change an Accounts Payable invoice without affecting a prior period?