固定资产折旧自动计算表模版

固定资产折旧自动计算表,,,,,,,,,,,,,,,,,,

单位名称：,,,,,,,,,,,,,,,,,,

日期:,2016年6月30日,,,,,,,折旧方法：,,平均年限法,,,固定资产类别：办公设备、运输工具类,,,,单位:元,

编号,名称,使用部门,入账日期,单位,数量,原币单价,购进原值,使用年限,"残值

率%",预计净残值,已使用月份,本月折旧,累计折旧,净值,月折旧额,实际计算截止日期,累计折旧计算值,上月累计折旧计算值

,设备合计,,,,,"850,141.87","898,011.87",,,"44,900.59",,"16,715.47","731,841.86","166,170.01","16,968.07",,"731,842.19","714,874.12"

FJSH-A00001,TCL立式空调,总经理办公室,2012年6月30日,台,1,"3,999.00","3,999.00",5,5%,199.95,48,63.32,3039.36,959.64,63.32,2016/6/30,"3,039.36","2,976.04"

FJSH-A00002,海尔冰柜,总经理办公室,2013年1月31日,,1,"2,659.00","2,659.00",5,5%,132.95,41,42.10,1726.10,932.90,42.10,2016/6/30,"1,726.10","1,684.00"

FJSH-A00003,HP电脑,总经理办公室,,,1,"5,000.00","5,000.00",3,5%,250.00,,131.94,4617.90,382.10,131.94,1902/12/31,"4,617.90","4,485.96"

FJSH-A00004,保险柜,总经理办公室,,,1,800.00,800.00,3,5%,40.00,,21.11,738.85,61.15,21.11,1902/12/31,738.85,717.74

FJSH-A00005,美的空调,总经理办公室,,,1,"2,600.00","2,600.00",3,5%,130.00,,68.61,2401.35,198.65,68.61,1902/12/31,"2,401.35","2,332.74"

FJSH-A00006,鱼缸组合,总经理办公室,2013年6月30日,,1,"2,000.00","2,000.00",3,5%,100.00,36,52.70,1900.00,100.00,52.78,2016/6/30,"1,900.08","1,847.30"

FJSH-A00007,原木茶桌,总经理办公室,,,1,"10,000.00","10,000.00",5,5%,500.00,,158.33,9341.47,658.53,158.33,1904/12/31,"9,341.47","9,183.14"

FJSH-A00008,办公椅,总经理办公室,,,1,"10,000.00","10,000.00",5,5%,500.00,,158.33,9341.47,658.53,158.33,1904/12/31,"9,341.47","9,183.14"

FJSH-A00009,太师椅,总经理办公室,,,1,-,,,5%,,,,,,,1899/12/31,-,-

FJSH-A00010,办公桌组合,总经理办公室,,,1,-,,,5%,,,,,,,1899/12/31,-,-

FJSH-A00011,折叠床,总经理办公室,,,1,-,,,5%,,,,,,,1899/12/31,-,-

FJSH-A00012,电脑,财务办公区,2016年5月1日,,3,"1,533.33","4,600.00",3,5%,230.00,1,121.39,121.39,4478.61,121.39,2016/6/30,121.39,-

FJSH-A00013,多动能打印一体机,财务办公区,2012年9月30日,,1,"1,700.00","1,700.00",3,5%,85.00,45,,1614.96,85.04,44.86,2015/9/30,"1,614.96","1,570.10"

FJSH-A00014,办公桌,财务办公区,,,2,500.00,"1,000.00",3,5%,50.00,,26.39,923.65,76.35,26.39,1902/12/31,923.65,897.26

FJSH-A00015,皮质沙发,财务办公区,,,1,"3,000.00","3,000.00",3,5%,150.00,,79.17,2770.95,229.05,79.17,1902/12/31,"2,770.95","2,691.78"

FJSH-A00016,大小茶几,财务办公区,,,3,200.00,600.00,3,5%,30.00,,15.83,554.05,45.95,15.83,1902/12/31,554.05,538.22

FJSH-A00017,铁皮文件柜,财务办公区,2016年5月1日,,1,530.00,530.00,3,5%,26.50,1,13.99,13.99,516.01,13.99,2016/6/30,13.99,-

FJSH-A00018,办公椅,财务办公区,,,5,160.00,800.00,3,5%,40.00,,21.11,738.85,61.15,21.11,1902/12/31,738.85,717.74

FJSH-A00019,美的空调,财务办公区,,,1,"2,600.00","2,600.00",3,5%,130.00,,68.61,2401.35,198.65,68.61,1902/12/31,"2,401.35","2,332.74"

FJSH-A00020,京瓷打印一体机,综合办公区,2013年5月31日,,1,"4,400.00","4,400.00",3,5%,220.00,37,,4179.96,220.04,116.11,2016/5/31,"4,179.96","4,063.85"

FJSH-A00021,美的空调,综合办公区,,,2,"2,600.00","5,200.00",3,5%,260.00,,137.22,4802.70,397.30,137.22,1902/12/31,"4,802.70","4,665.48"

FJSH-A00022,办公桌,综合办公区,,,3,"1,000.00","3,000.00",3,5%,150.00,,79.17,2770.95,229.05,79.17,1902/12/31,"2,770.95","2,691.78"

FJSH-A00023,电脑,综合办公区,,,3,"1,666.67","5,000.00",3,5%,250.00,,131.94,4617.90,382.10,131.94,1902/12/31,"4,617.90","4,485.96"

FJSH-A00024,传真机,综合办公区,,,1,600.00,600.00,3,5%,30.00,,15.83,554.05,45.95,15.83,1902/12/31,554.05,538.22

FJSH-A00025,办公椅,综合办公区,,,3,200.00,600.00,3,5%,30.00,,15.83,554.05,45.95,15.83,1902/12/31,554.05,538.22

FJSH-A00026,会议桌,综合办公区,,,1,"2,000.00","2,000.00",3,5%,100.00,,52.78,1847.30,152.70,52.78,1902/12/31,"1,847.30","1,794.52"

FJSH-A00027,铁皮柜,综合办公区,,,2,400.00,800.00,3,5%,40.00,,21.11,738.85,61.15,21.11,1902/12/31,738.85,717.74

FJSH-A00028,玻璃茶几,综合办公区,,,1,300.00,300.00,3,5%,15.00,,7.92,277.20,22.80,7.92,1902/12/31,277.20,269.28

FJSH-A00029,热水器,宿舍,2013年1月31日,,1,"1,269.00","1,269.00",3,5%,63.45,41,,1205.55,63.45,33.49,2016/1/31,"1,205.64","1,172.15"

FJSH-A00030,空调,宿舍,,,1,"2,600.00","2,600.00",3,5%,130.00,,68.61,2401.35,198.65,68.61,1902/12/31,"2,401.35","2,332.74"

FJSH-B00001,闽AQP292,,2012年12月31日,,1,"300,000.00","300,000.00",4,5%,15000.00,42,5937.50,249375.00,50625.00,5937.50,2016/6/30,"249,375.00","243,437.50"

FJSH-B00002,闽AF297M,,,,1,"36,000.00","36,000.00",4,5%,1800.00,,712.50,33487.50,2512.50,712.50,1903/12/31,"33,487.50","32,775.00"

FJSH-B00003,闽A0292Y,,2014年1月31日,,1,"71,794.87","71,794.87",4,5%,3589.74,29,1420.94,41207.26,30587.61,1420.94,2016/6/30,"41,207.26","39,786.32"

FJSH-B00004,闽AHB396,,,,1,"80,000.00","80,000.00",4,5%,4000.00,,1583.33,74416.51,5583.49,1583.33,1903/12/31,"74,416.51","72,833.18"

FJSH-C00001,手电钻,车间,2013年10月31日,,12,130.00,"1,560.00",3,5%,78.00,32,41.17,1317.44,242.56,41.17,2016/6/30,"1,317.44","1,276.27"

FJSH-C00002,电锤,车间,2013年10月31日,,3,250.00,750.00,3,5%,37.50,32,19.79,633.28,116.72,19.79,2016/6/30,633.28,613.49

FJSH-C00003,电焊机,车间,,,3,500.00,"1,500.00",3,5%,75.00,,39.58,1385.30,114.70,39.58,1902/12/31,"1,385.30","1,345.72"

FJSH-C00004,手动切割机,车间,,,4,500.00,"2,000.00",3,5%,100.00,,52.78,1847.30,152.70,52.78,1902/12/31,"1,847.30","1,794.52"

FJSH-C00005,角磨机,车间,2013年10月31日,,3,150.00,450.00,3,5%,22.50,32,11.88,380.16,69.84,11.88,2016/6/30,380.16,368.28

FJSH-C00006,三相切割机,车间,,,1,"1,200.00","1,200.00",3,5%,60.00,,31.67,1108.45,91.55,31.67,1902/12/31,"1,108.45","1,076.78"

FJSH-C00007,双头切割锯,车间,2012年12月31日,,1,"68,000.00","68,000.00",5,5%,3400.00,42,1076.67,45220.14,22779.86,1076.67,2016/6/30,"45,220.14","44,143.47"

FJSH-C00008,角码自动切割机,车间,2012年12月31日,,1,"15,000.00","15,000.00",5,5%,750.00,42,237.50,9975.00,5025.00,237.50,2016/6/30,"9,975.00","9,737.50"

FJSH-C00009,单头切割机,车间,,,1,"23,000.00","23,000.00",5,5%,1150.00,,364.17,21486.03,1513.97,364.17,1904/12/31,"21,486.03","21,121.86"

FJSH-C00010,五刀端面铣床,车间,2012年12月31日,,1,"32,000.00","32,000.00",5,5%,1600.00,42,506.67,21280.14,10719.86,506.67,2016/6/30,"21,280.14","20,773.47"

FJSH-C00011,V型切割机,车间,,,1,"28,000.00","28,000.00",5,5%,1400.00,,443.33,26156.47,1843.53,443.33,1904/12/31,"26,156.47","25,713.14"

FJSH-C00012,手动锯条,车间,,,1,"9,000.00","9,000.00",5,5%,450.00,,142.50,8407.50,592.50,142.50,1904/12/31,"8,407.50","8,265.00"

FJSH-C00013,垂型组角机,车间,,,1,"56,000.00","56,000.00",5,5%,2800.00,,886.67,52313.53,3686.47,886.67,1904/12/31,"52,313.53","51,426.86"

FJSH-C00014,重型高精度仿型铣床,车间,2012年12月31日,,1,"34,000.00","34,000.00",5,5%,1700.00,42,538.33,22609.86,11390.14,538.33,2016/6/30,"22,609.86","22,071.53"

FJSH-C00015,同步组角机,车间,2012年12月31日,,1,"11,000.00","11,000.00",5,5%,550.00,42,174.17,7315.14,3684.86,174.17,2016/6/30,"7,315.14","7,140.97"

FJSH-C00016,冲床,车间,,,3,"9,000.00","27,000.00",5,5%,1350.00,,427.50,25222.50,1777.50,427.50,1904/12/31,"25,222.50","24,795.00"

FJSH-C00017,台钻,车间,,,2,"2,000.00","4,000.00",3