We don't do the billing. We are the lender, but we track the payments
received through the servicer's website (bank). It's all manual. We need to
check each day to see what payments posted overnight and remove them from our
report. We only track those who have not made their payment. It's very
similar to a mortgage payment - you have so many days grace before your
payment is technically due.

I searched the discussion groups for a receivable report and didn't see any
other posts. Something along those lines will work. I just need to sort
into the appropriate column based on the day the payment was due and today's
date. Several of our loans have different payment dates (2/1, 2/5, 2/9,
2/16) and different grace days (1,5,10,16). It would be helpful to have an
easy way to automatically lump each loan into the approriate category.

We need to track the loans that are currently in grace so we can make sure
there isn't a problem holding it up from being paid on time prior to it
becoming delinquent.

"Fred Smith" wrote:

Your request isn't clear. Don't you just want to do a standard receivables
aging report?

In your example, how do you know when the December amount is paid?

To do an aging report, you will need to keep track of when each amount was
billed (ie, the invoice date), and when each amount was paid. I don't see
that your setup allows for this. In addition, I would forget about the grace
days. Simply say the amount is due on 2/5/09. That should make life easier,
and provide just as much information.

Regards,
Fred.

"Anna Wood" wrote in message
...
I need to add values in different columns of data based on due dates.

Categories of data include:
Current Due Date (say, 2/1/09)
Grace Days (i.e., 5 days)
Current Payment Amount
Jan Due Date (1/1/09)
Jan Payment Amount
Dec Due Date (12/1/08)
Dec Amount

The current payment amount falls into a "Within Grace Days" column if it
is
within 5 days of the current due date. I need to lump amounts due for
"1-30
Days", "31 to 60 Days", etc. based on the amounts and when the payments
were
due.

As today's date changes, the data will need to flow into the respective
delinquency categories as it passes from 30 to 31 days, etc.

I would like to copy this formula down the page and need to use an ISNA or
ISBLANK formula (say they don't owe a Jan or Dec payment) as I don't want
a
$0.00 amount in a cell - it needs to stay blank.

Your help is greatly appreciated.