AR Due Dates

SOLVED

Hello,

I wanted to see if anyone had a work around for this issue related to retention and invoice due dates.

Example: We have progress billing for November outstanding that has not been paid. In December, we are 100% complete with the job and bill retention to the owner. This triggers me to release all the retention on the job which moves it from "Retention" to "Net Due". When doing this, I have to select a new due date for the invoices which is generally 30 days from when we send the retainage pay application to the owner. 

The issue: The November progress billing invoice due date is now incorrect. Technically the bulk of it is due in December and is past due, and the retention is not yet past due. The due date is showing the due date for the retention piece, but not the progress billing piece. I have a report that shows past due AR and this would cause the November invoice to be left out of the report.

Any suggestions on this?

  • 0
    verified answer

    Hi Ralls

    I like to create one invoice for the total amount of retention I am billing for to send to client.  A second invoice as a credit for the same amount, and apply that credit against the retention amount of the prior invoices.  Both invoices are coded to a cash clearing account so that you can tell when someone forgets the credit (they always do and then that job is over-billed).  Just remember for invoices that had a balance due beyond the retention, you will have to zero out the retention on that invoice so that  the net due returns to its original net due.  When you apply credits to invoices, you cannot specify it to apply to retention unless retention is the only thing left on that invoice.  Now the unpaid portion of the original invoice still has the original due date and is reflected properly on the aging.  I do not use the Sage "release retention" because it messes with the aging dates and unpaid balances besides retention (which is pretty common in construction).

  • 0 in reply to Char DeLange

    Char,

    Thank you for the response. I think I am with you here and understand how this works. But how exactly do you apply the credit invoice to the prior invoices? 

  • 0 in reply to Char DeLange

    The only way I know to do this is a $0 cash receipt. Is this the correct way? and if so, does it matter if i use the clearing account or our actual cash account?

  • 0 in reply to Ralls Pennington
    verified answer

    Yes, a zero cash receipt in 3-3-1.  all values in the paid column, positives on the original invoices, negative on the credit.