Help Pls! Aging Debtor Spreadsheet

[TANIAGOOK]

Hi,

I am super new to this and was wondering if there is someone that could help me.

I have a spreadsheet which I need to create Current, 30+. 60+. 90+. 120+ days.

I have individual tabs for each customer which links to a summary page.

Is there any one out there that I could email this to and you could have a look and tell me what to do!

Big ask I know - I would be forever grateful for any help.

Thanks Again

 

[Michael M]

most people will not normally accept E-Mailed workbooks.
However, if you look at the 2nd line of my tag, you can download a HTML maker, which will allow you to post scrren samples of your data.

 

[Dave Patton]

consider the following; edit as required for your information

Excel Workbook
	A	B	C	D	E	F	G	H
1	Ref Date	Mar 14, 2011						Aged AR AP
2	Name	Date	Amount	0 - 30	30 - 60	60 - 90	90 - 120	120+
3		Jun 06, 2010	2,400.00					2,400.00
4		Jan 09, 2011	2,800.00			2,800.00
5		Jan 29, 2011	3,200.00		3,200.00
6		Feb 18, 2011	3,600.00	3,600.00
7		Mar 10, 2011	4,000.00	4,000.00
5d

Excel 2003

Cell Formulas
Range	Formula
D3	=($B$1-B3<30)*$C3
E3	=AND($B$1-B3>=30,$B$1-B3<60)*C3
F3	=AND($B$1-B3>=60,$B$1-B3<90)*C3
G3	=AND($B$1-B3>=90,$B$1-B3<120)*D3
H3	=($B$1-B3>=120)*C3
C4	=C3+400
C5	=C4+400
C6	=C5+400
C7	=C6+400