应收账款账龄分析表

应收账款账龄分析表,,,,,,,,,,,,,,,

**年**月**日,,,,,,,,,,,,,,,

序号,客户名称,日期,应收账款,未逾期,已逾期,,,,,,,,合计,信用期,备注

,,,,,1个月,2个月,3个月,3个月～半年,半年～1年,1年～2年,2年～3年,3年以上,,,

1,A,2012/1/31,"456,258.00",0.00,0.00,0.00,0.00,"456,258.00",0.00,0.00,0.00,0.00,"456,258.00",30,

2,A,2010/5/20,"338,125.00",0.00,0.00,0.00,0.00,0.00,0.00,0.00,"338,125.00",0.00,"338,125.00",30,

3,A,2011/4/25,"485,365.00",0.00,0.00,0.00,0.00,0.00,0.00,"485,365.00",0.00,0.00,"485,365.00",30,

4,B,2012/1/25,"358,147.00",0.00,0.00,0.00,0.00,"358,147.00",0.00,0.00,0.00,0.00,"358,147.00",60,

5,B,2010/6/30,"36,945.00",0.00,0.00,0.00,0.00,0.00,0.00,"36,945.00",0.00,0.00,"36,945.00",60,

6,C,2011/8/31,"36,912.00",0.00,0.00,0.00,0.00,0.00,"36,912.00",0.00,0.00,0.00,"36,912.00",90,

7,C,2010/9/30,"963,584.00",0.00,0.00,0.00,0.00,0.00,0.00,"963,584.00",0.00,0.00,"963,584.00",90,

8,C,2011/12/31,"158,321.00",0.00,0.00,0.00,0.00,"158,321.00",0.00,0.00,0.00,0.00,"158,321.00",90,

9,D,2012/2/29,"147,236.00",0.00,0.00,0.00,0.00,"147,236.00",0.00,0.00,0.00,0.00,"147,236.00",30,

10,E,2012/2/25,"258,369.00",0.00,0.00,0.00,0.00,"258,369.00",0.00,0.00,0.00,0.00,"258,369.00",30,

11,F,2012/2/20,"332,169.00",0.00,0.00,"332,169.00",0.00,0.00,0.00,0.00,0.00,0.00,"332,169.00",90,

12,G,2012/3/31,"25,331.00",0.00,0.00,0.00,"25,331.00",0.00,0.00,0.00,0.00,0.00,"25,331.00",30,

13,H,2012/3/25,"554,481.00","554,481.00",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"554,481.00",120,

14,I,2012/3/20,"69,158.00",0.00,0.00,"69,158.00",0.00,0.00,0.00,0.00,0.00,0.00,"69,158.00",60,

15,J,2012/4/30,"55,698.00",0.00,0.00,"55,698.00",0.00,0.00,0.00,0.00,0.00,0.00,"55,698.00",30,

16,K,2012/4/25,"66,147.00","66,147.00",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"66,147.00",90,

17,L,2012/4/20,"99,158.00","99,158.00",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"99,158.00",120,

18,M,2012/5/31,"258,147.00","258,147.00",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"258,147.00",120,

19,N,2012/5/25,"69,351.00","69,351.00",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"69,351.00",60,

20,O,2012/5/20,"77,456.00",0.00,"77,456.00",0.00,0.00,0.00,0.00,0.00,0.00,0.00,"77,456.00",30,

,,,,,,,,,,,,,,,,

合计,,,"4,846,358.00","1,047,284.00","77,456.00","457,025.00","25,331.00","1,378,331.00","36,912.00","1,485,894.00","338,125.00",0.00,"4,846,358.00",,

比重,,,100.00%,21.61%,1.60%,9.43%,0.52%,28.44%,0.76%,30.66%,6.98%,0.00%,100.00%,,

,,,,,,,,,,,,,0.00,,

说明:,,,,,,,,,,,,,,,

1、表公式中的日期可根据需要选择确定;,,,,,,,,,,,,,,,

"2、信用期为""0""代表现款,月结分30天、60天、90天、120天等;",,,,,,,,,,,,,,,

3、应收账款金额为账龄分析时的时点余额。,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

格式：,,,,,,,,,,,,,,,

,2012年06月21日,,2011-01-0106:25:22,,,,,,,,,,,,

,2012-06-21,,,,,,,,