應(yīng)收賬款跟蹤監(jiān)控工具（可視化靈活設(shè)置賬期提示）

1、, 財(cái)務(wù)管理工具應(yīng)收款管理,應(yīng)收賬款跟蹤監(jiān)控工具（明細(xì)表，可視化監(jiān)控）,今天是,2020年11月27日,顏色管理說明：逾期至今尚未到賬的，其公司名稱自動(dòng)顯示為紅色。,說明：本工具主要用于有效監(jiān)控應(yīng)收賬款回收情況，具備醒目的可視化提示功能。本表格為應(yīng)收賬款明細(xì)表，用于記錄某一時(shí)間周期內(nèi)應(yīng)收款的應(yīng)收明細(xì)以及匯款明細(xì)。其中的逾期天數(shù)（逾期至今未到賬款項(xiàng)的逾期天數(shù)是指截止當(dāng)日的逾期天數(shù)，若逾期天數(shù)為負(fù)數(shù)，則表示提前還款）、回款率為自動(dòng)生成。注：一份合同分期付款的，請(qǐng)分批逐一填入。另：本表格設(shè)置的是50行數(shù)據(jù)。,部門： , 統(tǒng)計(jì)周期：,應(yīng)收款總額：,￥1,055,000.00,到款總額:,￥746,00

2、0.00,總回款率:,70.71%輔助列,序號(hào),訂單號(hào)/合同號(hào),客戶名稱,合同總額,本期應(yīng)收金額,該筆款支付期限,發(fā)票號(hào)碼,發(fā)票開具日期,到款日期,目前逾期天數(shù),到款金額,支付方式,回款率,票據(jù)號(hào)碼,經(jīng)辦人,備注1A,1,ZX2016001,DK網(wǎng),￥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,現(xiàn)金,

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網(wǎng),￥35,000.00,2016/4/7,2016/5/7,30.0天,￥35,000.00,銀行匯款,100.00%,6A,6,ZX2016006,DK網(wǎng),￥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網(wǎng),￥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網(wǎng),￥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