应收账款跟踪监控工具（可视化灵活设置账期提示）

1、, 财务管理工具应收款管理,应收账款跟踪监控工具（明细表，可视化监控）,今天是,2020年11月27日,颜色管理说明：逾期至今尚未到账的，其公司名称自动显示为红色。,说明：本工具主要用于有效监控应收账款回收情况，具备醒目的可视化提示功能。本表格为应收账款明细表，用于记录某一时间周期内应收款的应收明细以及汇款明细。其中的逾期天数（逾期至今未到账款项的逾期天数是指截止当日的逾期天数，若逾期天数为负数，则表示提前还款）、回款率为自动生成。注：一份合同分期付款的，请分批逐一填入。另：本表格设置的是50行数据。,部门： , 统计周期：,应收款总额：,￥1,055,000.00,到款总额:,￥746,00

2、0.00,总回款率:,70.71%辅助列,序号,订单号/合同号,客户名称,合同总额,本期应收金额,该笔款支付期限,发票号码,发票开具日期,到款日期,目前逾期天数,到款金额,支付方式,回款率,票据号码,经办人,备注1A,1,ZX2016001,DK网,￥150,000.00,￥50,000.00,2016/5/3,FP00012,2016/5/1,2016/5/6,3.0天,￥50,000.00,银行汇款,100.00%,ss00098,孙大圣,合同首付款2A,2,ZX2016002,A科技公司,￥20,000.00,2016/4/4,2016/5/14,40.0天,￥20,000.00,现金,

3、100.00%,3A,3,ZX2016003,B科技公司,￥25,000.00,￥25,000.00,2016/2/5,FP00034,2016/2/2,1757.0天,0.00%,合同全款4A,4,ZX2016004,NG004,￥30,000.00,2016/5/6,2016/5/6,0.0天,￥28,000.00,银行汇款,93.33%,5A,5,ZX2016005,DK网,￥35,000.00,2016/4/7,2016/5/7,30.0天,￥35,000.00,银行汇款,100.00%,6A,6,ZX2016006,DK网,￥40,000.00,2016/3/8,2016/5/28,

4、81.0天,￥40,000.00,银行汇款,100.00%,7A,7,ZX2016007,C科技公司,￥45,000.00,2016/5/9,1663.0天,0.00%,8A,8,ZX2016008,公司1,￥50,000.00,2016/5/10,2016/5/8,-2.0天,￥50,000.00,银行汇款,100.00%,9A,9,ZX2016009,公司2,￥55,000.00,2016/4/11,2016/5/19,38.0天,￥55,000.00,银行汇款,100.00%,10A,10,ZX2016010,公司3,￥60,000.00,2016/5/12,2016/5/12,0.0天

5、,￥60,000.00,银行汇款,100.00%,11A,11,ZX2016011,公司4,￥65,000.00,2016/3/13,1720.0天,0.00%,12A,12,ZX2016012,公司5,￥70,000.00,2016/5/14,2016/5/14,0.0天,￥70,000.00,银行汇款,100.00%,13A,13,ZX2016013,公司6,￥75,000.00,2016/5/15,1657.0天,0.00%,14A,14,ZX2016014,公司7,￥80,000.00,2016/5/16,2016/5/16,0.0天,￥80,000.00,银行汇款,100.00%,1

6、5A,15,ZX2016015,公司8,￥85,000.00,2016/5/17,2016/5/17,0.0天,￥85,000.00,银行汇款,100.00%,16A,16,ZX2016016,公司9,￥90,000.00,2016/5/18,2016/5/10,-8.0天,￥80,000.00,银行汇款,88.89%,17A,17,ZX2016001,DK网,￥150,000.00,￥50,000.00,2016/4/19,1683.0天,0.00%,18A,18,ZX2016018,公司11,￥20,000.00,2016/5/20,2016/5/20,0.0天,￥20,000.00,银行

7、汇款,100.00%,19A,19,ZX2016019,公司12,￥10,000.00,2016/5/21,2016/5/21,0.0天,￥10,000.00,银行汇款,100.00%,20A,20,ZX2016020,公司13,￥5,000.00,2016/5/22,2016/5/31,9.0天,￥5,000.00,银行汇款,100.00%,21A,21,ZX2016021,公司14,￥5,000.00,2016/5/23,1649.0天,0.00%,22A,22,ZX2016022,公司15,￥10,000.00,2016/5/24,2016/5/29,5.0天,￥8,000.00,银行汇

8、款,80.00%,23A,23,ZX2016001,DK网,￥150,000.00,￥50,000.00,2016/5/25,2016/6/2,8.0天,￥50,000.00,银行汇款,100.00%,24A,24,ZX2016024,公司17,￥20,000.00,2016/5/26,1646.0天,0.00%,25A,25,ZX2016019,公司12,￥10,000.00,2016/6/5,1636.0天,0.00%,26A,26,0.0天,#DIV/0!,27A,27,0.0天,#DIV/0!,28A,28,0.0天,#DIV/0!,29A,29,0.0天,#DIV/0!,30A,30

9、,0.0天,#DIV/0!,31A,31,0.0天,#DIV/0!,32A,32,0.0天,#DIV/0!,33A,33,0.0天,#DIV/0!,34A,34,0.0天,#DIV/0!,35A,35,0.0天,#DIV/0!,36A,36,0.0天,#DIV/0!,37A,37,0.0天,#DIV/0!,38A,38,0.0天,#DIV/0!,39A,39,0.0天,#DIV/0!,40A,40,0.0天,#DIV/0!,41A,41,0.0天,#DIV/0!,42A,42,0.0天,#DIV/0!,43A,43,0.0天,#DIV/0!,44A,44,0.0天,#DIV/0!,45A,45,0.0天,#DIV/0!,46A,46,0.0天,#DIV/0!,47A,47,0.0天,#DIV