24應(yīng)收賬款明細(xì)表-可視化賬齡分析表

上傳人：大*** IP屬地：浙江上傳時間：2023-09-16 格式：XLSX 頁數(shù)：2208 大?。?.41MB 積分：1.2 舉報 版權(quán)申訴

已閱讀5頁，還剩2203頁未讀，繼續(xù)免費閱讀

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

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

,可視化賬齡分析表,,,,,,,,,,,,,,,

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

,,累計發(fā)生金額,累計收款金額,本年發(fā)生金額,本年收款金額,超期金額,,,,,,,,,,

,,"73,000.00","30,900.00","48,000.00","27,000.00","42,100.00",,,,,,,,,,

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

,序號,合同編碼,發(fā)生日期,客戶名稱,,發(fā)生金額,收款金額,應(yīng)收金額,截止日期,是否超期,賬齡,備注,,帳齡統(tǒng)計表,,未收款金額

,1,H10101,2020/3/5,單位1,,"5,000.00","1,000.00","4,000.00",2020/12/31,已超期,91以上,,,1,30以內(nèi),-

,2,H10102,2020/6/5,單位2,,"3,000.00","1,500.00","1,500.00",2020/12/31,已超期,91以上,,,31,31-60,-

,3,H10103,2020/9/5,單位3,,"2,500.00","1,200.00","1,300.00",2020/12/31,已超期,91以上,,,61,61-90,-

,4,H10104,2021/4/5,單位4,,"3,500.00","1,700.00","1,800.00",2021/12/31,已超期,91以上,,,91,91以上,"42,100.00"

,5,H10105,2021/6/8,單位5,,"4,000.00","1,000.00","3,000.00",2021/12/31,已超期,91以上,,,,,

,6,H10106,2021/9/8,單位6,,"2,000.00","1,000.00","1,000.00",2021/12/31,已超期,91以上,,,,當(dāng)前年份,2022

,7,H10107,2021/10/6,單位7,,"1,500.00",500.00,"1,000.00",2021/12/31,已超期,91以上,,,月份,發(fā)生金額,收款金額

,8,H10108,2021/12/7,單位8,,"3,500.00","2,000.00","1,500.00",2021/12/31,已超期,91以上,,,1月,"4,500.00","3,500.00"

,9,H10109,2022/1/2,單位9,,"4,500.00","1,000.00","3,500.00",2022/3/31,已超期,91以上,,,2月,"8,500.00","6,000.00"

,10,H10110,2022/2/1,單位10,,"5,000.00","1,500.00","3,500.00",2022/3/31,已超期,91以上,,,3月,"4,000.00","3,000.00"

,11,H10111,2022/3/16,單位11,,"4,000.00","1,000.00","3,000.00",2022/3/31,已超期,91以上,,,4月,"3,500.00","2,500.00"

,12,H10112,2022/4/25,單位12,,"3,500.00","1,000.00","2,500.00",2022/3/31,已超期,91以上,,,5月,"3,000.00","1,000.00"

,13,H10113,2022/6/4,單位13,,"4,500.00","2,000.00","2,500.00",2022/12/31,已超期,91以上,,,6月,"4,500.00","2,500.00"

,14,H10114,2022/7/14,單位14,,"4,000.00","3,000.00","1,000.00",2022/12/31,已超期,91以上,,,7月,"4,000.00","1,000.00"

,15,H10115,2022/8/23,單位15,,"3,500.00","1,500.00","2,000.00",2022/12/31,已超期,91以上,,,8月,"3,500.00","2,000.00"

,16,H10116,2022/5/2,單位16,,"3,000.00","2,000.00","1,000.00",2022/12/31,已超期,91以上,,,9月,"2,500.00","1,000.00"

,17,H10117,2022/9/11,單位17,,"2,500.00","1,500.00","1,000.00",2022/12/31,已超期,91以上,,,10月,"4,000.00","2,000.00"

,18,H10118,2022/10/21,單位18,,"4,000.00","2,000.00","2,000.00",2022/12/31,已超期,91以上,,,11月,"2,500.00","1,000.00"

,19,H10119,2022/2/25,單位19,,"3,500.00","1,000.00","2,500.00",2022/12/31,已超期,91以上,,,12月,"3,500.00","1,500.00"

,20,H10120,2022/11/21,單位20,,"2,500.00","1,500.00","1,000.00",2022/12/31,已超期,91以上,,,合計,"48,000.00","27,000.00"

,21,H10121,2022/12/22,單位21,,"3,500.00","2,000.00","1,500.00",2022/12/31,已超期,91以上,,,,,

,,,,,,,,-,,,,,,,,

,,,,,,,,-,,,,,,

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