Balance by Aging
 

I am trying to create a template that will return the total balance of
transactions according to their aging. I receive reports showing invoice
number, balance due, due date in xls format, these are often several thousand
lines depending on the account. I want to create a template that will (with
minimal editing/preparation) show the balance due of transactions according
to past due age (over 90 days, 60-90, 30-60, 0-30).

Balance by Aging
 

Hi J91co, I have a similar sheet set up. In colunm D5 I entered the following
formula which I then copied down.

=IF(TODAY()-C590,"90
Days",IF(TODAY()-C560,"60-90",IF(TODAY()-C530,"30-60","0-30")))

Then in cell A2 I entered the formula the following formula which I copied
across A2:D2

=SUMIF($D5:$D12,A1,$B5:$B12)

My sheet is set up as follows so that the running balance by Aging is always
on top.

I hope this helps.

A B C D
1 0-30 30-60 60-90 90 Days
2 $5,257.00 $65.00 03/18/08 $399.00
3
4 Invoice Balance Due Aging
5 A123 199.00 09/01/06 90 Days
6 567 3000.00 11/05/06 60-90
7 1023C 10.00 12/01/06 30-60
8 569 253.00 02/28/07 0-30
9 B11-12 1.00 03/01/07 0-30
10 1234 5003.00 12/28/06 0-30
11 89901 55.00 11/28/06 30-60
12 89902 200.00 10/13/06 90 Days



--
molinaram


"j91co" wrote:

I am trying to create a template that will return the total balance of
transactions according to their aging. I receive reports showing invoice
number, balance due, due date in xls format, these are often several thousand
lines depending on the account. I want to create a template that will (with
minimal editing/preparation) show the balance due of transactions according
to past due age (over 90 days, 60-90, 30-60, 0-30).