函数应用演示编制应收账款账龄分析表.xls

开开票票日日期期发发票票号号发发票票金金额额单单位位名名称称回回款款额额欠欠款款额额信信用用期期限限(天天)2008/01/02 12345678920,000.00客户A10,000.0010,000.00602008/12/02 28745216580,000.00客户A30,000.0050,000.00602009/03/16 45958649650,000.00客户C45,000.005,000.00602009/07/15 159875623100,000.00客户B60,000.0040,000.00602008/08/08 69875932150,000.00客户A30,000.0020,000.00302009/12/15 69874226780,000.00客户C-80,000.00302009/09/22 45069949280,000.00客户B60,000.0020,000.00602010/02/20 265874198160,000.00客户B80,000.0080,000.00602009/10/22 32364896695,000.00客户D-95,000.00302010/05/05 43095995960,000.00客户A50,000.0010,000.00452009/11/30 859752364260,000.00客户E150,000.00110,000.00902010/05/01 57895246680,000.00客户C-80,000.00302010/04/22 454350060120,000.00客户D80,000.0040,000.00902010/05/14 68768643360,000.00客户B-60,000.00302010/05/15 87687643380,000.00客户E50,000.0030,000.00452010/06/01 74325434370,000.00客户A-70,000.00302010/06/15459694565250,000.00客户D100,000.00150,000.0045到到期期日日离离到到期期日日天天数数2008/03/01-24392009/01/30-21042009/05/14-20002009/09/12-18792008/09/06-22502010/01/13-17562009/11/20-18102010/04/20-16592009/11/20-18102010/06/18-16002010/02/27-17112010/05/30-16192010/07/20-15682010/06/12-16062010/06/28-15902010/06/30-15882010/07/29-1559客客户户信信用用期期内内超超过过信信用用期期3030天天超超过过信信用用期期31-6031-60天天超超过过信信用用期期61-9061-90天天超超过过信信用用期期91-18091-180天天超超过过信信用用期期181-365181-365天天客户A客户C客户B客户D客户E超超过过信信用用期期1-21-2年年超超过过信信用用期期2-2-3 3年年超超过过信信用用期期3 3年年以以上上160000165000200000285000140000