固定资产计提折旧模板11版xls

1、1、基本资料不要输错2、计提折旧时只需将年份和月份输入即可3、有公式的栏你需要时将公式拖下来，以便自动计算4、如果使用，为以防万一，建议每月作次备份最好打印装订5、学习使用过程中有什么问题欢迎探讨1、基本资料不要输错2、计提折旧时只需将年份和月份输入即可3、有公式的栏你需要时将公式拖下来，以便自动计算4、如果使用，为以防万一，建议每月作次备份最好打印装订5、学习使用过程中有什么问题欢迎探讨有有限限公公司司固固定定资资产产报报表表计计提提折折旧旧日日期期：20052005年年第第2 2期期单位：元固固定定资资产产报报表表1 1：按按物物理理类类别别分分类类汇汇总总类别原值本月折旧累计折旧净值房屋

2、建筑物-机器设备3,491,927.6428,469.39592,265.602,899,662.04运输设备14,740.00221.108,180.706,559.30电子设备95,700.001,143.0042,291.0053,409.00其他设备-合合计计：3,602,367.6429,833.49642,737.302,959,630.34-固固定定资资产产报报表表2 2：按按费费用用科科目目分分类类汇汇总总类别原值本月折旧累计折旧净值制造费用24,000.00180.006,660.0017,340.00管理费用121,300.001,290.0047,730.0073,570

3、.00销售费用357,641.602,747.8796,396.57261,245.03应付福利费2,741.0041.121,521.441,219.56-合合计计：505,682.604,258.99152,308.01353,374.59-固固定定资资产产报报表表3 3：按按使使用用部部门门分分类类汇汇总总类别原值本月折旧累计折旧净值行政部154,041.001,601.1259,241.4494,799.56总经理-财务部-销售部-生产部-合合计计：154,041.001,601.1259,241.4494,799.56-折折旧旧期期间间2,005.00年年2.00月月编编号号形形态态

4、类类别别名名称称原原值值入入帐帐时时间间年年入入帐帐时时间间月月预预计计使使用用期期限限年年预预计计使使用用期期限限月月预预计计残残值值应应提提折折旧旧月月数数合合计计应应提提折折旧旧总总额额提提折折旧旧总总额额本本年年电子设备双辊破碎机24,000.002,002.001.0010.00120.000.1037.0021,600.00360.00电子设备颚破机15,000.002,002.001.0010.00120.000.1037.0013,500.00225.00电子设备冷却水槽10,700.002,002.001.005.0060.000.1037.009,630.00321.00电

5、子设备激光粒度机40,000.002,002.001.005.0060.000.1037.0036,000.001,200.00机器设备高速混合机55,600.002,002.001.0010.00120.000.1037.0050,040.00834.00电子设备摄影显微镜6,000.002,002.001.005.0060.000.1037.005,400.00180.00机器设备恒温干燥箱2,741.002,002.001.005.0060.000.1037.002,466.9082.24机器设备离心泵2,073.002,002.001.005.0060.000.1037.001,865

6、.7062.20机器设备格兰仕空调3,169.002,002.001.005.0060.000.1037.002,852.1095.08机器设备佳能复印机3,199.002,002.001.005.0060.000.1037.002,879.1095.98运输设备电脑14,740.002,002.001.005.0060.000.1037.0013,266.00442.20机器设备长安汽车35,288.802,002.001.005.0060.000.1037.0031,759.921,058.66机器设备水份测定仪2,741.602,002.002.005.0060.000.1036.002

7、,467.4482.24机器设备全自动白度仪5,980.002,002.002.005.0060.000.1036.005,382.00179.40机器设备电动双隔膜泵5,378.002,002.003.005.0060.000.1035.004,840.20161.34机器设备格兰仕空调6,340.002,002.003.005.0060.000.1035.005,706.00190.20机器设备研磨设备348,900.002,002.003.0010.00120.000.1035.00314,010.005,233.50机器设备电子天平4,140.002,002.004.005.0060.

8、000.1034.003,726.00124.20机器设备甲醛分析仪26,500.002,002.004.005.0060.000.1034.0023,850.00795.00机器设备分离桶4,105.002,002.004.005.0060.000.1034.003,694.50123.16机器设备搅拌桶3,300.002,002.004.005.0060.000.1034.002,970.0099.00机器设备40升研磨筒9,400.002,002.004.005.0060.000.1034.008,460.00282.00机器设备数位相机27,062.502,002.005.005.00

9、60.000.1033.0024,356.25811.88机器设备电脑26,000.002,002.006.005.0060.000.1032.0023,400.00780.00机器设备特种过滤器26,850.002,002.006.005.0060.000.1032.0024,165.00805.50机器设备搅拌球磨机20,000.002,002.007.0010.00120.000.1031.0018,000.00300.00机器设备海信空调2,678.002,002.007.005.0060.000.1031.002,410.2080.34机器设备双槽真空成型机250,000.002,0

10、02.007.0010.00120.000.1031.00225,000.003,750.00机器设备空净器2,200.002,002.007.005.0060.000.1031.001,980.0066.00机器设备空净器6,600.002,002.008.005.0060.000.1030.005,940.00198.00机器设备单头成型机130,000.002,002.008.0010.00120.000.1030.00117,000.001,950.00机器设备粉剂包装机22,200.002,002.009.0010.00120.000.1029.0019,980.00333.00机器

11、设备粉碎机280,000.002,002.009.0010.00120.000.1029.00252,000.004,200.00机器设备不锈钢微粉机225,000.002,002.009.0010.00120.000.1029.00202,500.003,375.00机器设备厢式实验电炉4,000.002,002.0011.005.0060.000.1027.003,600.00120.00机器设备玻璃屋实验室94,241.742,002.0011.005.0060.000.1027.0084,817.572,827.26机器设备喷雾干燥机(小型)74,000.002,002.0012.00

12、10.00120.000.1026.0066,600.001,110.00机器设备喷雾干燥机(大型)183,200.002,003.001.0010.00120.000.1025.00164,880.002,748.00机器设备小CK机180,000.002,003.0012.0010.00120.000.1014.00162,000.002,700.00机器设备油压裁断机124,000.002,003.0012.0010.00120.000.1014.00111,600.001,860.00机器设备多功能反应釜65,000.002,003.0012.0010.00120.000.1014.0

13、058,500.00975.00机器设备吸塑三边折边机14,000.002,004.007.0010.00120.000.107.0012,600.00210.00机器设备真空泵（SZ-360）11,960.002,004.007.0010.00120.000.107.0010,764.00179.40机器设备片材机1,200,000.002,004.009.0010.00120.000.105.001,080,000.0018,000.00机器设备4,080.002,005.001.0010.00120.000.101.003,672.0030.60月月折折旧旧额额折折旧旧提提足足前前一一月

14、月止止累累计计折折旧旧年年初初累累计计折折旧旧累累计计折折旧旧本本月月应应提提折折旧旧额额费费用用科科目目使使用用部部门门180.0021,420.006,300.006,660.00180.00制造费用行政部112.5013,387.503,937.504,162.50112.50管理费用行政部160.509,469.505,617.505,938.50160.50管理费用行政部600.0035,400.0021,000.0022,200.00600.00管理费用行政部417.0049,623.0014,595.0015,429.00417.00管理费用行政部90.005,310.003,1

15、50.003,330.0090.00销售费用行政部41.122,426.081,439.201,521.4441.12应付福利费行政部31.101,834.901,088.501,150.7031.1047.542,804.861,663.901,758.9847.5447.992,831.411,679.651,775.6347.99221.1013,044.907,738.508,180.70221.10529.3331,230.4718,526.5519,585.21529.3341.122,426.081,398.081,480.3241.12销售费用89.705,292.303,04

16、9.803,229.2089.7080.674,759.532,662.112,823.4580.6795.105,610.903,138.303,328.5095.102,616.75311,393.2586,352.7591,586.252,616.75销售费用62.103,663.901,987.202,111.4062.10397.5023,452.5012,720.0013,515.00397.5061.583,633.221,970.562,093.7261.5849.502,920.501,584.001,683.0049.50141.008,319.004,512.004,79

17、4.00141.00405.9423,950.4612,584.1413,396.02405.94390.0023,010.0011,700.0012,480.00390.00402.7523,762.2512,082.5012,888.00402.75150.0017,850.004,350.004,650.00150.0040.172,370.031,164.931,245.2740.171,875.00223,125.0054,375.0058,125.001,875.0033.001,947.00957.001,023.0033.0099.005,841.002,772.002,970

18、.0099.00975.00116,025.0027,300.0029,250.00975.00166.5019,813.504,495.504,828.50166.502,100.00249,900.0056,700.0060,900.002,100.001,687.50200,812.5045,562.5048,937.501,687.5060.003,540.001,500.001,620.0060.001,413.6383,404.1735,340.7538,168.011,413.63555.0066,045.0013,320.0014,430.00555.001,374.00163,506.0031,602.0034,350.001,374.001,350.00160,650.0016,200.0018,900.001,35