Past Due Table


The past due table is one of the calculated reports inside of a loan. It gives a more in-depth look at the amount past due.  It breaks the amount down by dates when amounts came due, so you can see a breakdown of when payments came due by date and what portion of those payments is still due on the loan.

The table gives five pieces of information in each row.  These include:

  • Due Date – This is the date when the amount in the New Due Amount column came due.  This date is most likely the date of a payment, but could also be the date of a charge.
  • Past Due Amount Carried Forward – This is the past-due amount that is carried forward from the previous row.  There will be rows for payoff charges, which means no amount has come due yet.  If you have a  fees paid by setting of period and multiple fees have come due in a single period, the Amount Due column will show the sum of the fee amounts that came due in the period on the first date in that period.  There will still be a row for each date a fee was assessed on, but the New Due Amount column for other fees in the same period will be $0.00.
  • New Due Amount – This is the amount that came due on the date listed in the Due Date column.
  • Amount Due – This is the total amount that has come due on the loan through the date in the Due Date column.
  • # of days past due – This is the number of days the amount found in the New Due Amount column is past due.
Within the software, click  Understanding days past due calculation for more information on how days past due is calculated.

How did we do?

Powered by HelpDocs (opens in a new tab)