固定资产增减变动明细表大全（多页）.doc

1528005280015278.6675%2640

13737一次分摊5%1.85

13737一次分摊5%1.85

4100400131.66675%20

1230230118.20835%11.5

1230230118.20835%11.5

11575%36

1105%0

113301330521.05835%66.5

21332.55%210

1105%0

2105%0

1500500139.58335%25

150050057.916675%25

33090一次分摊5%4.5

23060一次分摊5%3

33090一次分摊5%4.5

155一次分摊5%0.25

14040一次分摊5%2

14040一次分摊5%2

1193019301152.7925%96.5

2193038601305.5835%193

1800800163.33335%40

111901190518.84175%59.5

11146.4585%92.5

1105%0

1105%0

1460460136.41675%23

41400164008162.2925%820

240080087.916675%40

44001600815.83335%80固定资产分

购入日期固定资产名称数量单价金额部门摊销方法折旧年数每月折旧额

720720

21004200净残值率净残值

1850185063400252008249.3755%1260

2300600147.55%30

1045450135.6255%22.5

445180114.255%9

1180018001142.55%90

12020一次分摊5%1

1404013.166675%2

1404013.166675%2

1540600147.55%30

166一次分摊5%0.3

116016052.533335%8

316048057.65%24

216032055.066675%16

125000250008247.3965%1250

120002000819.79175%100

固定资产清单表(完整版)

一、引言

此固定资产清单表(完整版)为了便于管理和追溯公司的固定资产，记录了所有固定资产的详细信息。本表包含了每个资产的基本信息，例如资产编号、资产名称、规格型号、购置日期、购置金额等。

二、表格结构

资产编号 资产名称 规格型号 购置日期 购置金额 存放位置

001 电脑 ThinkPad X1

Carbon 2020-01-01 ¥8,000 办公室A

002 打印机 HP LaserJet Pro

M402dne 2020-02-15 ¥1,500 办公室B

003 会议桌 现代简约圆桌 2019-05-10 ¥2,000 会议室A

004 椅子 ERGONOMICDEX2018-09-¥1,200 办公室椅子 03 C

005 投影仪 Epson EH-TW5600 2021-03-20 ¥5,000 会议室B

三、表格说明

1. 资产编号

每个固定资产都有独一无二的资产编号，用于标识和区分不同的资产。

2. 资产名称

资产名称是对固定资产的简要描述，以便于识别和查找。

3. 规格型号

规格型号描述了固定资产的技术参数和特性。

4. 购置日期

购置日期是指资产购买或租赁的具体日期。

5. 购置金额

购置金额是指购买或租赁资产所支付的金额。

6. 存放位置

存放位置描述了资产所放置的地点或部门。

四、使用方法

使用此固定资产清单表，您可以轻松地查找、管理和追溯公司的固定资产。您只需在表格中添加新的资产信息或更新现有资产信息即可。

五、总结

通过使用这份固定资产清单表(完整版)，您可以更加方便地管理和追踪公司的固定资产。请确保定期更新资产信息，以保持表格的准确性和实用性。

单位名称:XXX日期:2010年2月28日折旧方平均年限法固定资产类别：办编号名称入账日期单位数量购进原值使用年限残值率%预计净残值已使用月份本月折旧累计折旧净值 设备合计######### 8,805.05 1,340.32 66,508.04 109,592.9610001HP打印机2006/2/28台1 1,690.0035%84.50481605.5084.5020002联想电脑2006/2/28台2 10,100.0035%505.00489595.00505.0030003冰箱2006/2/28台1 1,790.0035%89.50481700.5089.5040004洗衣机2006/2/28台1 1,750.0035%87.50481662.4887.5250005彩电2006/2/28台2 2,360.0035%118.00482242.00118.0060006空调2006/7/31台2 4,560.0055%228.004372.203104.601455.4070007汽车2007/1/31台1#########105%7500.00371187.5043937.50106062.5080008空调2007/5/17台1 1,990.0055%99.503331.511039.83950.1790009打印机2007/5/17台1 1,861.0035%93.053349.111620.63240.37固定资产折旧计算表

注：绿色部份为带公式不需录入区域单位:元月折旧额实际计算截止日期累计折旧计算值上月累计折旧计算值 1,807.15######## 64,701.2944.602009/2/281605.601561.00266.532009/2/289595.089328.5547.242009/2/281700.641653.4046.182009/2/281662.481616.3062.282009/2/282242.082179.8072.202010/2/283104.603032.401187.502010/2/2843937.5042750.0031.512010/2/281039.831008.3249.112010/2/281620.631571.521900/1/0

部门名 称规格型号单位数量单价销售电脑显示器主机台82100.00销售空调台33500.00销售打印机（黑白）台22500.00销售供放机台15000.00销售红木办公桌185*70组21500.00人事摄像机台110500.00总经理沙发1+3套14000.00总经理四门衣柜200*165套21800.00总经理空调台13500.00总经理茶具套12000.00总经理功夫荣茶具套12000.00生产电脑办公桌套5700.00生产空调台14000.00生产电脑显示器主机台52100.00生产打印机SOX台12600.00采购空调台11400.00采购慧普打印机H1005台12000.00采购电脑显示器主机台32100.00工厂摄像头套214000.00财务空调台11400.00财务电脑显示器主机组52400.00财务N510打印机（针式）台12000.00会议室会议 桌个13000.00会议室主机台12500.00会议室摄影机套13000.00会议室空调台14000.00营销电脑办公桌组5700.00营销电脑主机显示器组53200.00营销空调台13500.00营销S270彩喷打印机台12300.00海绵车间挂扇台10230.00海绵车间胶罐个32800.00海绵车间电梯升降机台115000.00海绵车间海绵立切机台115000.00海绵车间海绵立切机LQ型台115000.00海绵车间海绵直切机台115000.00海绵车间带锯机MJ344F2台11200.00海绵车间暖气组32280.00海绵车间大铁架个2500.00海绵车间海绵架个15500.00裁剪车间暖气片个13280.00裁剪车间吊扇台9100.00缝纫车间缝纫机台341000.00缝纫车间锁边机标准2000-3台43500.00缝纫车间铁架子个12400.00缝纫车间格力空调KFR-72LW/ELA-N5台23500.00缝纫车间暖气片组14250.00木架车间精密锯带吸尘器MJ6128(90型)台110000.00木架车间平刨台12000.00木架车间电锯台41500.00木架车间带锯MJ346E型台25000.00木架车间压刨（双面）MB204A型台112000.00木架车间木架车辆17150.00木架车间钉架台台15150.00木架车间手电锯把2500.00木架车间墙挂扇台11230.00木架车间烘干窑座110000.00木架车间取暖窑130000.00实木车间电脑台12100.00实木车间三排钻MZ73213F台152000.00实木车间封边机MF132 45*3台115000.00实木车间精密锯（锯板机）MF6130D台410000.00实木车间镂铣机MX508台14000.00实木车间立刨机MX5116A台13500.00实木车间冷压机台120000.00实木车间热压机Y112M-4台197000.00实木车间烤漆房台233000.00实木车间冰柜海尔台1800.00实木车间木工平刨床MB504E台18000.00实木车间压刨机（单面）MB104H台18000.00实木车间吸尘器MF9030台31000.00实木车间大砂光机带吸尘器2.8*1.9台115000.00实木车间压缩机内压机台110000.00实木车间电梯台115000.00实木车间机动叉车台130000.00实木车间底漆架子、板材架子个6400.00实木车间暖气片组55250.00实木车间茶几库房架子13000.00扪包车间码钉枪把17140.00扪包车间气钻把171150.00公 用气泵9062336台135000.00扪包车间暖气片组22280.00扪包车间扪包架子个17300.00质检车间灯箱个12000.00质检车间气钻把21150.00质检车间电脑组12100.00质检车间打印机组12000.00五金库房台式电脑台12100.00五金库房针式打印机LQ-730K台1800.00五金库房工业电扇台40165.00五金库房计数电子天平BS-30KA台2500.00五金库房计数电子秤TCS台2350.00五金库房货架个38300.00五金库房饰品货架个10200.00成品库房台式电脑台12100.00成品库房铁架车台64500.00成品库房排骨架子组21000.00成品库房简易架子组15000.00面料库房大架子个23500.00面料库房小架子个35300.00面料库房缝纫机台21700.00布艺床车间精密锯Y112A-2台110000.00布艺床车间台锯(样板锯)台13000.00布艺床车间台钻24116B台15000.00布艺床车间充电电钻把6380.00布艺床车间蒸汽熨斗ZFQ台11600.00布艺床车间床品铁架个8500.00布艺床车间床邦铁架个8500.00布艺床车间缝纫机台51000.00厨房餐厅空调台23000.00厨房餐厅餐椅组厨房餐厅储水罐个35000.00厨房餐厅小锅炉、暖气片个厨房餐厅油烟、罩子组工厂大门移动大门个鸭毛房缝纫机GC6-8台2800.00鸭毛房公仔绵分配机ESF005-3A组130000.00鸭毛房碎海绵机ESF007B台15000.00鸭毛房废弃机器台12000.00电焊房切割机台21000.00电焊房CO2保护焊机NBC-270台15000.00电焊房暖气片组8250.00电焊房扳牙机台21500.00扪包车间锁边机台13500.00扪包车间缝纫机台1800.00工厂京Y789Y9辆173000.00工厂京GQ5285辆1170000.00工厂京YF1033辆182000.00工厂京GBD442辆128000.00工厂京AG4922辆1100000.00工厂京NGA619辆1400000.00工厂京GTM523辆130000.00工厂京PRLG86辆149500.00工厂京PR3G33辆160700.00工厂京GKB282辆128000.00工厂京GSA751辆135000.00工厂京GX7925辆1120000.00工厂京GXS618辆11600000.00工厂京GVL417辆150000.00工厂京GHG076辆150000.00工厂京PCD178辆171000.00工厂京Y36330辆147900.00工厂宿舍米22072.6600.00工厂车间米24199.25600.00工厂海绵、订架车间米22330600.00工厂料棚、锅炉房米2198200.00工厂办公室米2283600.00工厂厨房、卫生间米2463600.00工厂库房米24629.25600.00合计金额净残值使用年限年折旧额月折旧已折旧月份16800.0053360.00280.001210500.001050.0033150.00262.50125000.0031666.67138.89125000.0031666.67138.89123000.00300.005540.0045.001210500.001050.0051890.00157.50124000.00400.005720.0060.00123600.00360.004810.0067.50123500.0031166.6797.22122000.0021000.0083.33122000.0021000.0083.33123500.00350.005630.0052.50124000.00400.0031200.00100.001210500.0052100.00175.00122600.00260.005468.0039.00121400.005280.0023.33122000.00200.005360.0030.00126300.0051260.00105.001228000.002800.0055040.00420.00121400.00140.005252.0021.001212000.0052400.00200.00122000.00200.005360.0030.00123000.00300.005540.0045.00122500.005500.0041.67123000.00300.005540.0045.00124000.00400.005720.0060.00123500.005700.0058.331216000.0053200.00266.67123500.00350.0031050.0087.50122300.00230.005414.0034.50122300.003766.6763.89128400.0051680.00140.001215000.001500.00101350.00112.501215000.001500.0052700.00225.001215000.001500.0052700.00225.001215000.001500.0052700.00225.00121200.00120.005216.0018.00128960.00896.0010806.4067.20121000.00100.001090.007.50127500.00750.0010675.0056.25123640.00364.0010327.6027.30123640.00364.0010327.6027.301234000.003400.00310200.00850.001214000.001400.0034200.00350.00124800.0010480.0040.00127000.00700.0051260.00105.00123500.00350.0010315.0026.251210000.001000.0051800.00150.00122000.00200.005360.0030.00126000.00600.0051080.0090.001210000.001000.0051800.00150.001212000.001200.0052160.00180.00122550.00255.0010229.5019.13122250.00225.005405.0033.75121000.005200.0016.67122530.0021265.00105.421210000.001000.0019000.00750.001230000.003000.00213500.001125.00122100.005420.0035.001252000.005200.0085850.00487.501215000.001500.0026750.00562.501240000.004000.0057200.00600.00124000.00400.0031200.00100.00123500.00350.004787.5065.631220000.002000.00101800.00150.001297000.009700.0099700.00808.331266000.00513200.001100.0012800.0080.003240.0020.00128000.00800.0051440.00120.00128000.00800.0051440.00120.00123000.00300.008337.5028.131215000.001500.0052700.00225.001210000.001000.0024500.00375.001215000.001500.0052700.00225.001230000.003000.00102700.00225.00122400.00240.0010216.0018.001213750.001375.00101237.50103.13123000.00300.0010270.0022.50122380.00238.0012142.00178.501219550.00119550.001629.171235000.003500.0056300.00525.00126160.00616.0010554.4046.20125100.00510.005918.0076.50122000.005400.0033.33122300.0012300.00191.67122100.005420.0035.00122000.005400.0033.33122100.005420.0035.0012800.005160.0013.33126600.0023300.00275.00121000.002500.0041.6712700.002350.0029.171211400.001140.00101026.0085.50122000.00200.0010180.0015.00122100.005420.0035.001232000.003200.00102880.00240.00122000.00200.0010180.0015.00125000.00500.0010450.0037.501211500.001150.00101035.0086.251210500.001050.0010945.0078.75123400.00340.005612.0051.001210000.001000.0051800.00150.00123000.00300.005540.0045.00125000.00500.005900.0075.00122280.0012280.00190.00121600.003533.3344.44124000.00400.0010360.0030.00124000.00400.0010360.0030.00125000.00500.005900.0075.0012