固定資產(chǎn)折舊函數(shù)自動計算表

,固定資產(chǎn)折舊自動計算表,,,,,,,,,,,

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

,類別,購買日期,摘要,購買金額,本月折舊,本年累計折舊,計提月份,合計使用月份,累計折舊額,余額,預(yù)計殘值,使用壽命（月）

,辦公,2016年6月,電腦,"￥38,476.10",￥-,￥-,2020年8月,50,"￥38,476.10",已折舊完,"￥1,923.81",36

,辦公,2016年6月,空調(diào),"￥3,630.00",￥-,￥-,2020年8月,50,"￥3,630.00",已折舊完,￥181.50,36

,辦公,2016年7月,傳真機(jī),"￥2,150.00",￥-,￥-,2020年8月,49,"￥2,150.00",已折舊完,￥107.50,36

,辦公,2016年10月,電腦,"￥6,000.00",￥-,￥-,2020年8月,46,"￥6,000.00",已折舊完,￥300.00,36

,辦公,2016年10月,錄音筆,"￥1,030.00",￥-,￥-,2020年8月,46,"￥1,030.00",已折舊完,￥51.50,36

,銷售,2017年8月,運(yùn)輸工具,"￥165,188.00","￥2,615.48","￥272,009.57",2020年8月,36,"￥94,157.16","￥71,030.84","￥8,259.40",60

,辦公,2017年9月,保險柜,"￥1,000.00",￥26.39,"￥2,744.44",2020年8月,35,￥923.61,￥76.39,￥50.00,36

,辦公,2018年5月,電腦,"￥7,900.00",￥208.47,"￥21,681.11",2020年8月,27,"￥5,628.75","￥2,271.25",￥395.00,36

,辦公,2018年7月,傳真機(jī),￥890.00,￥23.49,"￥2,442.56",2020年8月,25,￥587.15,￥302.85,￥44.50,36

,辦公,2018年10月,手機(jī),"￥4,980.00",￥131.42,"￥13,667.33",2020年8月,22,"￥2,891.17","￥2,088.83",￥249.00,36

,辦公,2018年11月,掃描儀,"￥20,400.00",￥538.33,"￥55,986.67",2020年8月,21,"￥11,305.00","￥9,095.00","￥1,020.00",36

,辦公,2018年11月,傳真機(jī),￥890.00,￥23.49,"￥2,442.56",2020年8月,21,￥493.21,￥396.79,￥44.50,36

,銷售,2018年11月,運(yùn)輸工具,"￥140,975.00","￥2,232.10","￥232,138.83",2020年8月,21,"￥46,874.19","￥94,100.81","￥7,048.75",60

,辦公,2019年1月,服務(wù)器,"￥4,520.00",￥119.28,"￥12,404.89",2020年8月,19,"￥2,266.28","￥2,253.72",￥226.00,36

,辦公,2019年2月,傳真機(jī),"￥2,130.00",￥56.21,"￥5,845.67",2020年8月,18,"￥1,011.75","￥1,118.25",￥106.50,36

,辦公,2019年2月,噴墨一體機(jī),"￥1,099.00",￥29.00,"￥3,016.14",2020年8月,18,￥522.03,￥576.98,￥54.95,36

,辦公,2019年3月,掃描儀,"￥61,800.00","￥1,630.83","￥169,606.67",2020年8月,17,"￥27,724.17","￥34,075.83","￥3,090.00",36

,銷售,2019年3月,運(yùn)輸工具,"￥135,800.00","￥2,150.17","￥223,617.33",2020年8月,17,"￥36,552.83","￥99,247.17","￥6,790.00",60

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

,,,