固定资产折旧自动计算表(全公式)

固定资产折旧明细表----2010年11月,,,,,,,,,,,,,,2010/11/30,,,,,,,,,,2010,年,,,,

单位:,南郑益丰房地产开发有限责任公司,,,,,,,,,,,,,,,,,,,,,,,,,,,,

编号,类别,名称,规格,入账日期,单位,数量,单价,原值,折旧年限,应折旧月数,"残值

率","预计

净残值","月折

旧额",本月折旧,"累计

月份",累计折旧,账面净值,,净残值验证,内部分类,使用部门,科目,,"折旧

月数",本年折旧,会计分录：,,借方,贷方

合计,,,,,,,,993022.39,,,,49651.12,,17671.44,,171283.78,821738.61,,,,,,,,,,,,

1,运输工具,电动车,,2009/9/30,台,3,"3,333.33",10000.00,4,48,5%,500.00,197.92,197.92,14,2770.88,7229.12,,,,医技科室,生产成本,,12,2375.04,借：,管理费用,9300.63,

2,运输工具,面包车+税,,2010/3/30,台,1,"88,171.69",88171.69,4,48,5%,4408.58,1745.06,1745.06,8,13960.48,74211.21,,,,医技科室,生产成本,,9,15705.54,,营业费用,,

3,机器机械,发电机,,2009/9/30,台,1,"38,000.00",38000.00,10,120,5%,1900.00,300.83,300.83,14,4211.62,33788.38,,,,医技科室,生产成本,,12,3609.96,,财务费用,,

4,机器机械,水泥泵,,2010/3/30,台,1,"306,830.00",306830.00,10,120,5%,15341.50,2429.07,2429.07,8,19432.56,287397.44,,,,医技科室,生产成本,,9,21861.63,,销售费用,98.27,

5,机器机械,整流桥,,2010/6/30,台,1,"1,885.00",1885.00,10,120,5%,94.25,14.92,14.92,5,74.60,1810.40,,,,医技科室,生产成本,,6,89.52,,制造费用,,

6,电子设备,组装电脑,,2009/9/30,台,5,"2,370.00",11850.00,3,36,5%,592.50,312.71,312.71,14,4377.94,7472.06,,,,医技科室,管理费用,,12,3752.52,,生产成本,8272.54,

7,电子设备,松下传真机,,2009/9/30,台,1,930.00,930.00,3,36,5%,46.50,24.54,24.54,14,343.56,586.44,,,,医技科室,管理费用,,12,294.48,贷：,累计折旧—房屋建筑物,,

8,电子设备,打印机,,2009/9/30,台,1,597.00,597.00,3,36,5%,29.85,15.75,15.75,14,220.50,376.50,,,,医技科室,管理费用,,12,189,,累计折旧—飞机火车轮船,,

9,电子设备,吸尘器,,2009/9/30,台,1,370.00,370.00,3,36,5%,18.50,9.76,9.76,14,136.64,233.36,,,,,管理费用,,12,117.12,,累计折旧—机器机械,,2744.82

10,电子设备,步步高,,2009/9/30,台,1,698.00,698.00,3,36,5%,34.90,18.42,18.42,14,257.88,440.12,,,,,管理费用,,12,221.04,,累计折旧—器具工具家具,,1733.84

11,电子设备,联想笔记本,,2009/9/30,台,1,"7,200.00",7200.00,3,36,5%,360.00,190.00,190.00,14,2660.00,4540.00,,,,,管理费用,,12,2280,,累计折旧—运输工具,,1942.98

12,电子设备,手机,,2009/9/30,部,2,"8,190.00",16380.00,3,36,5%,819.00,432.25,432.25,14,6051.50,10328.50,,,,,管理费用,,12,5187,,累计折旧—电子设备,,11249.80

13,电子设备,饮水机,,2009/9/30,台,2,553.00,1106.00,3,36,5%,55.30,29.19,29.19,14,408.66,697.34,,,,,管理费用,,12,350.28,合计,,17671.44,17671.44

14,电子设备,歌谣照相机,,2009/9/30,台,1,"13,997.70",13997.70,3,36,5%,699.89,369.38,369.38,14,5171.32,8826.38,,,,,管理费用,,12,4432.56,,,,

15,电子设备,手机,,2009/9/30,台,1,"7,600.00",7600.00,3,36,5%,380.00,200.56,200.56,14,2807.84,4792.16,,,,,管理费用,,12,2406.72,,,,

16,电子设备,空调柜机,,2009/9/30,台,9,"8,250.00",74250.00,3,36,5%,3712.50,1959.38,1959.38,14,27431.32,46818.68,,,,,管理费用,,12,23512.56,,,,

17,电子设备,空调挂机,,2009/9/30,台,16,"1,600.00",25600.00,3,36,5%,1280.00,675.56,675.56,14,9457.84,16142.16,,,,,管理费用,,12,8106.72,,,,

18,电子设备,洗衣机,,2009/9/30,台,2,"1,400.00",2800.00,3,36,5%,140.00,73.89,73.89,14,1034.46,1765.54,,,,,管理费用,,12,886.68,,,,

19,电子设备,组装电脑,,2009/9/30,台,3,"3,160.00",9480.00,3,36,5%,474.00,250.17,250.17,14,3502.38,5977.62,,,,,生产成本,,12,3002.04,,,,

20,电子设备,饮水机电饼铛,,2009/9/30,台,2,355.00,710.00,3,36,5%,35.50,18.74,18.74,14,262.36,447.64,,,,,管理费用,,12,224.88,,,,

21,电子设备,软件,,2009/9/30,个,1,"2,000.00",2000.00,3,36,5%,100.00,52.78,52.78,14,738.92,1261.08,,,,,管理费用,,12,633.36,,,,

22,电子设备,手机,,2009/9/30,台,1,"8,380.00",8380.00,3,36,5%,419.00,221.14,221.14,14,3095.96,5284.04,,,,,管理费用,,12,2653.68,,,,

23,电子设备,风扇,,2009/9/30,台,1,130.00,130.00,3,36,5%,6.50,3.43,3.43,14,48.02,81.98,,,,,销售费用,,12,41.16,,,,

24,电子设备,组装电脑,,2009/9/30,台,2,"2,697.50",5395.00,3,36,5%,269.75,142.37,142.37,14,1993.18,3401.82,,,,,管理费用,,12,1708.44,,,,

25,电子设备,复印件,,2009/9/30,台,1,"4,500.00",4500.00,3,36,5%,225.00,118.75,118.75,14,1662.50,2837.50,,,,,生产成本,,12,1425,,,,

26,电子设备,手机,,2009/9/30,部,1,"5,600.00",5600.00,3,36,5%,280.00,147.78,147.78,14,2068.92,3531.08,,,,,管理费用,,12,1773.36,,,,

27,电子设备,手机,,2009/10/31,部,1,"12,000.00",12000.00,3,36,5%,600.00,316.67,316.67,12,3800.04,8199.96,,,,,管理费用,,12,3800.04,,,,

28,电子设备,点钞机,,2009/11/30,台,1,"1,000.00",1000.00,3,36,5%,50.00,26.39,26.39,12,316.68,683.32,,,,,管理费用,,12,316.68,,,,

29,电子设备,夏普复印件,,2009/11/30,台,1,"9,500.00",9500.00,3,36,5%,475.00,250.69,250.69,12,3008.28,6491.72,,,,,管理费用,,12,3008.28,,,,

30,电子设备,打印机饮水机,,2010/3/31,台,1,790.00,790.00,3,36,5%,39.50,20.85,20.85,7,145.95,644.05,,,,,管理费用,,9,187.65,,,,

31,电子设备,指挥部电器,,2010/3/31,台,1,"91,557.00",91557.00,3,36,5%,4577.85,2416.09,2416.09,7,16912.63,74644.37,,,,,生产成本,,9,21744.81,,,,

32,电子设备,电器一批,,2010/3/31,批,1,"73,375.00",73375.00,3,36,5%,3668.75,1936.28,1936.28,7,13553.96,59821.04,,,,,管理费用,,9,17426.52,,,,

33,电子设备,广联达鲁班软件,,2010/3/31,个,1,"7,000.00",7000.00,3,36,5%,350.00,184.72,184.72,7,1293.04,5706.96,,,,,生产成本,,9,1662.48,,,,

34,电子设备,电脑,,2010/6/30,台,3,"2,800.00",8400.00,3,36,5%,420.00,221.67,221.67,5,1108.35,7291.65,,,,,生产成本,,6,1330.02,,,,

35,电子设备,冰箱电视洗衣机,,2010/6/30,台,3,"1,906.00",5718.00,3,36,5%,285.90,150.89,150.89,5,754.45,4963.55,,,,,生产成本,,6,905.34,,,,

36,电子设备,电脑,,2010/6/30,台,2,"2,900.00",5800.00,3,36,5%,290.00,153.06,153.06,5,765.30,5034.70,,,,,管理费用,,6,918.36,,,,

37,器具工具家具,两门保险柜,,2009/9/30,个,1,"1,050.00",1050.00,5,60,5%,52.50,16.63,16.63,14,232.82,817.18,,,,,管理费用,,12,199.56,,,,

38,器具工具家具,单门保险柜,,2009/9/30,个,1,650.00,650.00,5,60,5%,32.50,10.29,10.29,14,144.06,505.94,,,,,管理费用,,12,123.48,,,,

39,器具工具家具,铁皮文件柜,,2009/9/30,个,2,550.00,1100.00,5,60,5%,55.00,17.42,17.42,14,243.88,856.12,,,,,管理费用,,12,209.04,,,,

40,器具工具家具,自动麻将桌,,2009/9/30,个,1,"2,000.00",2000.00,5,60,5%,100.00,31.67,31.67,14,443.38,1556.62,,,,,管理费用,,12,380.04,,,,

41,器具工具家具,竹藤家具,,2009/9/30,个,9,470.00,4230.00,5,60,5%,211.50,66.98,66.98,14,937.72,3292.28,,,,,管理费用,,12,803.76,,,,

42,器具工具家具,办公椅,,2009/9/30,个,16,150.00,2400.00,5,60,5%,120.00,38.00,38.00,14,532.00,1868.00,,,,,管理费用,,12,456,,,,

43,器具工具家具,铁架子床,,2009/9/30,副,8,220.00,1760.00,5,60,5%,88.00,27.87,27.87,14,390.18,1369.82,,,,,管理费用,,12,334.44,,,,

44,器具工具家具,钢管皮长椅,,2009/9/30,个,5,300.00,1500.00,5,60,5%,75.00,23.75,23.75,14,332.50,1167.50,,,,,管理费用,,12,285,,,,

45,器具工具家具,茶水柜,,2009/9/30,个,1,300.00,300.00,5,60,5%,15.00,4.75,4.75,14,66.50,233.50,,,,,管理费用,,12,57,,,,

46,器具工具家具,办公椅,,2009/9/30,个,1,"3,000.00",3000.00,5,60,5%,150.00,47.50,47.50,14,665.00,2335.00,,,,,管理费用,,12,570,,,,

47,器具工具家具,家具,,2009/11/30,个,1,"3,490.00",3490.00,5,60,5%,174.50,55.26,55.26,12,663.12,2826.88,,,,,销售费用,,12,663.12,,,,

48,器具工具家具,沙发,,2009/11/30,个,1,"2,500.00",2500.00,5,60,5%,125.00,39.58,39.58,12,474.96,2025.04,,,,,销售费用,,12,474.96,,,,

49,器具工具家具,家具,,2010/3/31,个,1,"3,160.00",3160.00,5,60,5%,158.00,50.03,50.03,7,350.21,2809.79,,,,,管理费用,,9,450.27,,,,

50,器具工具家具,指挥部家具,,2010/3/31,批,1,"11,380.00",11380.00,5,60,5%,569.00,180.18,180.18,7,1261.26,10118.74,,,,,生产成本,,9,1621.62,,,,

51,器具工具家具,家具,,2010/3/31,个,1,"69,385.00",69385.00,5,60,5%,3469.25,1098.60,1098.60,7,7690.20,61694.80,,,,,管理费用,,9,9887.4,,,,

52,器具工具家具,床保险柜,,2010/6/30,个,2,800