15應(yīng)收賬款賬齡分析

上傳人：恒*** IP屬地：湖南上傳時(shí)間：2025-03-20 格式：XLSX 頁數(shù)：111 大?。?29.56KB 積分：15 舉報(bào) 版權(quán)申訴

已閱讀5頁，還剩106頁未讀，繼續(xù)免費(fèi)閱讀

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡介

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

,,,,,應(yīng)收賬款賬齡分析表,,2022,1-3個(gè)月,,金山辦公軟件有限公司,,,,,,統(tǒng)計(jì)查詢,,

,,,,,Agingofaccountsreceivable,,設(shè)置訂單年度,查詢賬齡,,2022年07月27日星期三,,,,,,Statisticalinquiry,,

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

,,,?訂單信息,,,,,,?賬齡分布,,,,,,,,,

,,,訂單編號(hào),,訂單日期,訂單內(nèi)容,客戶單位,訂單金額,1月以內(nèi),1-3個(gè)月,3-6個(gè)月,6個(gè)月+,,,,?匯總統(tǒng)計(jì),,

,,,?,LK023845,2022/01/01,XXX訂單,A_001客戶單位,14121.00,7060.50,4236.30,,2824.20,,,,684811.00,621807.30,63003.7

,,,?,LK023846,2022/01/04,XXX訂單,A_002客戶單位,10534.00,5267.00,5267.00,,,,,,應(yīng)收總額,已收總額,待收總額

,,,?,LK023847,2022/01/07,XXX訂單,A_003客戶單位,13977.00,6988.50,4193.10,,2795.40,,,,69,54,15

,,,?,LK023848,2022/01/10,XXX訂單,A_004客戶單位,3503.00,1751.50,1751.50,,,,,,訂單總數(shù),收款完成,未完成

,,,?,LK023849,2022/01/13,XXX訂單,A_005客戶單位,2574.00,2574.00,,,,,,,,,

,,,?,LK023850,2022/01/16,XXX訂單,A_006客戶單位,3809.00,1904.50,1904.50,,,,,,?賬齡統(tǒng)計(jì),,

,,,?,LK023851,2022/01/19,XXX訂單,A_007客戶單位,17274.00,8637.00,5182.20,,3454.80,,,,賬齡,金額,占比

,,,?,LK023852,2022/01/22,XXX訂單,A_001客戶單位,6910.00,3455.00,3455.00,,,,,,1月以內(nèi),346896.00,55.8%

,,,?,LK023853,2022/01/25,XXX訂單,A_002客戶單位,4303.00,2151.50,2151.50,,,,,,1-3個(gè)月,221044.10,35.5%

,,,?,LK023854,2022/01/28,XXX訂單,A_003客戶單位,4618.00,2309.00,2309.00,,,,,,3-6個(gè)月,44792.80,7.2%

,,,?,LK023855,2022/01/31,XXX訂單,A_004客戶單位,6058.00,3029.00,3029.00,,,,,,6個(gè)月+,9074.40,1.5%

,,,?,LK023856,2022/02/03,XXX訂單,A_005客戶單位,16993.00,8496.50,5097.90,3398.60,,,,,合計(jì),621807.3,100.0%

,,,?,LK023857,2022/02/06,XXX訂單,A_003客戶單位,3461.00,1730.50,1730.50,,,,,,,,

,,,?,LK023858,2022/02/09,XXX訂單,A_004客戶單位,3099.00,1549.50,1549.50,,,,,,?客戶查詢,,

,,,?,LK023859,2022/02/12,XXX訂單,A_005客戶單位,13611.00,6805.50,4083.30,2722.20,,,,,查詢客戶單位:,A_005客戶單位,

,,,?,LK023860,2022/02/15,XXX訂單,A_006客戶單位,12498.00,6249.00,3749.40,2499.60,,,,,110960.00,95811.60,15148.4

,,,?,LK023861,2022/02/18,XXX訂單,A_007客戶單位,17429.00,8714.50,5228.70,3485.80,,,,,查詢應(yīng)收,查詢已收,查詢待收

,,,?,LK023862,2022/02/21,XXX訂單,A_001客戶單位,2365.00,2365.00,,,,,,,11,7,4

,,,?,LK023863,2022/02/24,XXX訂單,A_002客戶單位,9404.00,4702.00,4702.00,,,,,,訂單總數(shù),收款完成,未完成

,,,?,LK023864,2022/02/27,XXX訂單,A_001客戶單位,15955.00,7977.50,4786.50,3191.00,,,,,,,

,,,?,LK023865,2022/03/02,XXX訂單,A_002客戶單位,14253.00,7126.50,4275.90,2850.60,,,,,?月份訂單,?選擇賬齡,

,,,?,LK023866,2022/03/05,XXX訂單,A_003客戶單位,17171.00,8585.50,5151.30,3434.20,,,,,訂單月份,賬齡金額,占比

,,,?,LK023867,2022/03/08,XXX訂單,A_004客戶單位,11521.00,5760.50,5760.50,,,,,,1月,33479.10,38.2%

,,,?,LK023868,2022/03/11,XXX訂單,A_005客戶單位,8861.00,4430.50,4430.50,,,,,,2月,30927.80,32.6%

,,,?,LK023869,2022/03/14,XXX訂單,A_006客戶單位,11371.00,5685.50,5685.50,,,,,,3月,49420.80,35.8%

,,,?,LK023870,2022/03/17,XXX訂單,A_007客戶單位,8552.00,4276.00,4276.00,,,,,,4月,39908.60,40.0%

,,,?,LK023871,2022/03/20,XXX訂單,A_001客戶單位,18162.00,9081.00,5448.60,3632.40,,,,,5月,40192.20,43.0%

,,,?,LK023872,2022/03/23,XXX訂單,A_002客戶單位,14517.00,7258.50,4355.10,2903.40,,,,,6月,27115.60,27.4%

,,,?,LK023873,2022/03/26,XXX訂單,A_003客戶單位,13927.00,6963.50,4178.10,2785.40,,,,,7月,0.00,0.0%

,,,?,LK023874,2022/03/29,XXX訂單,A_004客戶單位,19531.00,9765.50,5859.30,3906.20,,,,,8月,0.00,-

,,,?,LK023875,2022/04/01,XXX訂單,A_005客戶單位,4105.00,2052.50,2052.50,,,,,,9月,0.00,-

,,,?,LK023876,2022/04/04,XXX訂單,A_003客戶單位,9950.00,4975.00,4975.00,,,,,,10月,0.00,-

,,,?,LK023877,2022/04/07,XXX訂單,A_004客戶單位,13694.00,6847.00,4108.20,2738.80,,,,,11月,0.00,-

,,,?,LK023878,2022/04/10,XXX訂單,A_005客戶單位,6592.00,3296.00,3296.00,,,,,,12月,0.00,-

,,,?,LK023879,2022/04/13,XXX訂單,A_006客戶單位,7638.00,3819.00,3819.00,,,,,,,,

,,,?,LK023880,2022/04/16,XXX訂單,A_007客戶單位,9960.00,4980.00,4980.00,,,,,,,,

,,,?,LK023881,2022/04/19,XXX訂單,A_001客戶單位,19552.00,9776.00,5865.60,3910.40,,,,,,,

,,,?,LK023882,2022/04/22,XXX訂單,A_002客戶單位,16671.00,8335.50,5001.30,3334.20,,,,,,,

,,,?,LK023883,2022/04/25,XXX訂單,A_001客戶單位,7630.00,3815.00,3815.00,,,,,,,,

,,,?,LK023884,2022/04/28,XXX訂單,A_002客戶單位,3992.00,1996.00,1996.00,,,,,,,,

,,,?,LK023885,2022/05/01,XXX訂單,A_003客戶單位,5312.00,2656.00,2656.00,,,,,,,,

,,,?,LK023886,2022/05/04,XXX訂單,A_004客戶單位,4163.00,2081.50,2081.50,,,,,,,,

,,,?,LK023887,2022/05/07,XXX訂單,A_005客戶單位,8435.00,4217.50,4217.50,,,,,,,,

,,,?,LK023888,2022/05/10,XXX訂單,A_006客戶單位,15603.00,7801.50,4680.90,,,,,,,,

,,,?,LK023889,2022/05/13,XXX訂單,A_007客戶單位,5277.00,2638.50,2638.50,,,,,,,,

,,,?,LK023890,2022/05/16,XXX訂單,A_001客戶單位,10835.00,5417.50,5417.50,,,,,,,,

,,,?,LK023891,2022/05/19,XXX訂單,A_002客戶單位,4400.00,2200.00,2200.00,,,,,,,,

,,,?,LK023892,2022/05/22,XXX訂單,A_003客戶單位,7625.00,3812.50,3812.50,,,,,,,,

,,,?,LK023893,2022/05/25,XXX訂單,A_004客戶單位,10665.00,5332.50,5332.50,,,,,,,,

,,,?,LK023894,2022/05/28,XXX訂單,A_005客戶單位,17361.00,8680.50,5208.30,,,,,,,,

,,,?,LK023895,2022/05/31,XXX訂單,A_003客戶單位,3894.00,1947.00,1947.00,,,,,,,,

,,,?,LK023896,2022/06/03,XXX訂單,A_004客戶單位,18812.00,9406.00,5643.60,,,,,,,,

,,,?,LK023897,2022/06/06,XXX訂單,A_005客戶單位,15126.00,7563.00,4537.80,,,,,,,,

,,,?,LK023898,2022/06/09,XXX訂單,A_006客戶單位,2577.00,2577.00,,,,,,,,,

,,,?,LK023899,2022/06/12,XXX訂單,A_007客戶單位,19939.00,9969.50,5981.70,,,,,,,,

,,,?,LK023900,2022/06/15,XXX訂單,A_001客戶單位,8862.00,4431.00,4431.00,,,,,,,,

,,,?,LK023901,2022/06/18,XXX訂單,A_002客戶單位,9001.00,4500.50,4500.50,,,,,,,,

,,,?,LK023902,2022/06/21,XXX訂單,A_001客戶單位,1465.00,1465.00,,,,,,,,,

,,,?,LK023903,2022/06/24,XXX訂單,A_002客戶單位,4042.00,2021.00,2021.00,,,,,,,,

,,,?,LK023904,2022/06/27,XXX訂單,A_003客戶單位,6790.00,3395.00,,,,,,,,,

,,,?,LK023905,2022/06/30,XXX訂單,A_004客戶單位,12233.00,6116.50,,,,,,,,,

,,,?,LK023906,2022/07/03,XXX訂單,A_005客戶單位,13950.00,6975.00,,,,,,,,,

,,,?,LK023907,2022/07/06,XXX訂單,A_006客戶單位,7822.00,3911.00,,,,,,,,,

,,,?,LK023908,2022/07/09,XXX訂單,A_007客戶單位,4231.00,2115.50,,,,,,,,,

,,,?,LK023909,2022/07/12,XXX訂單,A_001客戶單位,16430.00,8215.00,,,,,,,,,

,,,?,LK023910,2022/07/15,XXX訂單,A_002客戶單位,10583.00,5291.50,,,,,,,,,

,,,?,LK023911,2022/07/18,XXX訂單,A_003客戶單位,8153.00,4076.50,,,,,,,,,

,,,?,LK023912,2022/07/21,XXX訂單,A_004客戶單位,7727.00,3863.50,,,,,,,,,

,,,?,LK023913,2022/07/24,XXX訂單,A_005客戶單位,3352.00,1676.00,,,,,,,,,

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

人人文庫> 全部分類> 應(yīng)用文書 > 辦公表格

溫馨提示

1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 人人文庫網(wǎng)僅提供信息存儲(chǔ)空間，僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請(qǐng)與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

15應(yīng)收賬款賬齡分析

文檔簡介

溫馨提示

最新文檔

評(píng)論

15應(yīng)收賬款賬齡分析

文檔簡介

溫馨提示

最新文檔

評(píng)論

相關(guān)文檔