,財(cái)務(wù)管理工具——應(yīng)收款管理,,,,,,,,,,,,,,,

,應(yīng)收賬款跟蹤監(jiān)控工具（明細(xì)表，可視化監(jiān)控）,,,,,,,,,,,今天是,2023年9月1日,,,

,顏色管理說(shuō)明：逾期至今尚未到賬的，其公司名稱自動(dòng)顯示為紅色。,,,,,,,,,,,,,,,

,說(shuō)明：本工具主要用于有效監(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ù)。,,,,,,,,,,,,,,,

,部門(mén)：,,統(tǒng)計(jì)周期：,,,,應(yīng)收款總額：,"￥1,055,000.00",,,到款總額:,"￥746,000.00",,,總回款率:,70.71%

輔助列,序號(hào),訂單號(hào)/合同號(hào),客戶名稱,合同總額,本期應(yīng)收金額,該筆款支付期限,發(fā)票號(hào)碼,發(fā)票開(kāi)具日期,到款日期,目前逾期天數(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)金,100.00%,,,

3A,3,ZX2016003,B科技公司,"￥25,000.00","￥25,000.00",2016/2/5,FP00034,2016/2/2,,2765.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,81.0天,"￥40,000.00",銀行匯款,100.00%,,,

7A,7,ZX2016007,C科技公司,,"￥45,000.00",2016/5/9,,,,2671.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天,"￥60,000.00",銀行匯款,100.00%,,,

11A,11,ZX2016011,公司4,,"￥65,000.00",2016/3/13,,,,2728.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,,,,2665.0天,,,0.00%,,,

14A,14,ZX2016014,公司7,,"￥80,000.00",2016/5/16,,,2016/5/16,0.0天,"￥80,000.00",銀行匯款,100.00%,,,

15A,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,,,,2691.0天,,,0.00%,,,

18A,18,ZX2016018,公司11,,"￥20,000.00",2016/5/20,,,2016/5/20,0.0天,"￥20,000.00",銀行匯款,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,,,,2657.0天,,,0.00%,,,

22A,22,ZX2016022,公司15,,"￥10,000.00",2016/5/24,,,2016/5/29,5.0天,"￥8,000.00",銀行匯款,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,,,,2654.0天,,,0.00%,,,

25A,25,ZX2016019,公司12,,"￥10,000.00",2016/6/5,,,,2644.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,,,,,,,,,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/0!,,,

48A,48,,,,,,,,,0.0天,,,#DIV/0!,,,

49A,49,,,,,,,,,0.0天,,,#DIV/0!,,,

50A,50,,,,,,,,,0.0天,,,#DIV/0!,,,

,核準(zhǔn)人：審批人：部門(mén)負(fù)責(zé)人：制表人：,,,,,,,,,,,,,,,

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

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