固定资产折旧明细表(带公式-无保护)

,,,,,,,,,,,,,,,3,,,

固定资产折旧明细表,,,,,,,,,,,,,,,,,,

公司名称：xxxx有限公司,,,,,,,,,,,,,,,,,,单位：元

序号,分类,固定资产名称,入账日期,本期折旧日期,单价,数量,金额,"预计

净残值",预计使用年限,每月折旧额,期初已计提折旧月份,期初已计提累计折旧额,期初余额,本月折旧,本年止累计折旧,期末余额,使用部门,费用分摊会计科目

1,固定资产-生产经营用固定资产（机器设备）,PHILIPS台式电脑,2016/8/31,2018/1/31,"2,013.33",6,"12,080.00",604.00,36,318.78,16,"5,100.48","6,375.52",318.78,"5,419.26","6,056.74",办公室,管理费用

2,固定资产-生产经营用固定资产（机器设备）,得实AR-630K,2016/8/31,2018/1/31,"1,393.00",1,"1,393.00",69.65,36,36.76,16,588.16,735.19,36.76,624.92,698.43,办公室,管理费用

3,固定资产-生产经营用固定资产（机器设备）,联想M7206,2016/8/31,2018/1/31,857.00,1,857.00,42.85,36,22.62,16,361.92,452.23,22.62,384.54,429.61,办公室,管理费用

4,固定资产-生产经营用固定资产（机器设备）,美的冰箱,2016/8/31,2018/1/31,858.00,1,858.00,42.90,60,13.59,16,217.44,597.66,13.59,231.03,584.07,办公室,管理费用

5,固定资产-生产经营用固定资产（机器设备）,格兰仕微波炉,2016/8/31,2018/1/31,299.00,1,299.00,14.95,60,4.73,16,75.68,208.37,4.73,80.41,203.64,办公室,管理费用

6,固定资产-生产经营用固定资产（机器设备）,办公家具,2016/8/31,2018/1/31,"6,258.00",1,"6,258.00",312.90,60,99.09,16,"1,585.44","4,359.66",99.09,"1,684.53","4,260.57",办公室,管理费用

7,固定资产-生产经营用固定资产（机器设备）,办公家具,2016/8/31,2018/1/31,"7,251.00",1,"7,251.00",362.55,60,114.81,16,"1,836.96","5,051.49",114.81,"1,951.77","4,936.68",办公室,管理费用

8,固定资产-生产经营用固定资产（机器设备）,测试手机2台,2016/8/31,2018/1/31,360.00,2,720.00,36.00,36,19.00,16,304.00,380.00,19.00,323.00,361.00,办公室,管理费用

9,固定资产-生产经营用固定资产（机器设备）,台式电脑,2016/11/29,2018/1/31,"2,307.69",4,"9,230.77",461.54,36,243.59,13,"3,166.67","5,602.56",243.59,"3,410.26","5,358.97",办公室,管理费用

10,固定资产-生产经营用固定资产（机器设备）,办公桌,2017/3/31,2018/1/31,"2,077.78",1,"2,077.78",103.89,60,32.90,9,296.10,"1,677.79",32.90,329.00,"1,644.89",办公室,管理费用

11,固定资产-生产经营用固定资产（机器设备）,AOC电脑,2017/4/30,2018/1/31,"4,095.83",3,"12,287.49",614.37,36,324.25,8,"2,594.00","9,079.12",324.25,"2,918.25","8,754.87",办公室,管理费用

12,固定资产-生产经营用固定资产（机器设备）,办公桌绿色4人,2017/4/30,2018/1/31,520.00,4,"2,080.00",104.00,60,32.93,8,263.44,"1,712.56",32.93,296.37,"1,679.63",办公室,管理费用

13,固定资产-生产经营用固定资产（机器设备）,测试手机2台,2017/4/30,2018/1/31,"1,099.00",2,"2,198.00",109.90,36,58.00,8,464.00,"1,624.10",58.00,522.00,"1,566.10",办公室,管理费用

14,,测试机,2017/12/26,2018/1/31,"3,950.00",1,"3,950.00",197.50,36,104.24,0,-,"3,752.50",104.24,104.24,"3,648.26",办公室,管理费用

,,合计,,,,29,61540.04,3077.00,648.00,1425.29,174,16854.29,41608.75,1425.29,18279.58,40183.46,,

,#REF!,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,44685.75,,104.24,,,,

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

,,,,,,,,,,,,,,,,,1,

,,,,,,,,,,,,,"DATEDIF(开始日期,终止日期,比较单位)",,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

无形资产,,,,,,,,,,,,,,,,,,

公司名称：xxxx有限公司,,,,,,,,,,,,,,,,,,单位：元

序号,分类,无形资产名称,入账日期,本期折旧日期,单价,数量,金额,"预计

净残值",预计使用年限,每月折旧额,期初已计提折旧月份,期初已计提累计折旧额,期初余额,本月折旧,本年止累计折旧,期末余额,使用部门,费用分摊会计科目

1,固定资产-生产经营用固定资产（机器设备）,棋牌程序,2017/11/1,2018/1/31,"100,000.00",1,"100,000.00",0.00,24,"4,166.67",2,"8,333.34","91,666.66",4166.67,"12,500.01","87,499.99",办公室,管理费用

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,

,#REF!,,,,,,,,,,,,,,,,,