待摊费用表格
待摊费用自动计算表(带公式)
52河南省大明电缆有限公司电缆53常州鑫鼎物资有限公司镀锌板款54无锡市鑫亿鹏升钢铁有限公司镀锌板55退厂区草帽灯罩及灯泡56付北亚装饰装修费57付王振车间装修费58常州市豪骏弯管 玻璃59五星利康设备搬迁费60办公楼打扫费61付湖塘美之选遮阳伞安装费（江建华）62付办公室安装纱窗费用（沈凤波）63侯林燕 纱窗安装费64美之选窗帘费（沙如玉）65湖塘兴瑞 吸尘通风管道向下添加合计金额11.9专利年费（续费至2017年）2家得利劳务费-潘文人12.131#3农工商劳务费潘文人12.333#4农工商进店费发票已收12.25#56岁宝劳务费唐文霞12.335#7新一佳劳务费唐文霞12.3348京客隆进店费12.321#9京客隆劳务费龙小兵12.331#10苏果进店费冲2014.3.123#凭证11北京物美劳务费朱德青2014.12.336#12乐天玛特合同费用2014.12.338#13付苏州旺益源服务费14深圳岁宝促销服务费及手续费15付唐文霞（深圳致和至美）人人乐劳务费16付武树勋（天兴旺达）北京乐天玛特劳务费17付长春新天地超市开户费及条码费（票未到）18付长春吉祥瑞达超市开户费及条码费（票未到）19付天津津工开户费及条码费（票未到）20付江苏大统华进店费（票未到）21苏州旺益源服务费22上海易初莲花促销费23付北京华联综合超市进场费24成都人人乐商品陈列费25大润发进店费26乐天超市进店费（发票到，1.243#无票已做5万）27苏州旺益源服务费28注：绿色部份为带公式不需录入数据。
待摊费用自动计算表(带公式)
单位名称：常州龙骏天编号费用项目应计科目入账日期开始摊销日期向下添加合计金额15.6科教城装修电线2014/12/12015/1/12科教城装修用电费2014/12/12015/1/1 3科教城装修-电柜+桥架2014/12/12015/1/146.13科教城动力柜+桥架2014/12/12015/1/156.16科教城-通风管道工程费2014/12/12015/1/166.23科教城装修装饰费用结报2014/12/12015/1/176.3科教城装修-GGD柜2014/12/12015/1/185.20科教城装修-电缆2014/12/12015/1/195.20科教城装修-电线2014/12/12015/1/1107-8月科教城新厂装修费用2014/12/12015/1/1 11科教城新厂装修费用2014/12/12015/1/1 129.4付卢爱中水池制作工费（科教城）2014/12/12015/1/1 138.4付卢爱中科教城厂房装修费2014/12/12015/1/1 149.17卢爱中做办公室门（科教城）2014/12/12015/1/1 158.15卢爱中科教城装修费用2014/12/12015/1/1 16油漆2014/12/12015/1/1 179.26卢爱中水电气安装费（科教城）2014/12/12015/1/1 18卢爱中租房水电费、房租等2014/12/12015/1/1 1910.10卢爱中新厂房办公室文件柜2014/12/12015/1/1 20科教城厂区做隔断2014/12/12015/1/1 21卢爱中购卫浴五金件、灯具等2014/12/12015/1/1 22北京嘉利-办公家具2014/12/12015/1/1 23科教城会客室软包、仓间贴壁纸2014/12/12015/1/1 24科教城办公室窗帘2014/12/12015/1/1 25卢爱中-厂区做桥架2014/12/12015/1/1 266.13卢爱中-科教城蓄水池施工费2014/12/12015/1/1 27卢爱中-厂区自动门探头2014/12/12015/1/1 28卢爱中购餐具、安装电视机支架、厂区办公室美2014/12/12015/1/1 2912.19卢爱中-包间沙发2014/12/12015/1/1 30卢爱中-厂区做桥架2014/12/12015/1/1 3112.15天宁雕庄合协-瓷砖承兑货款228815312014/12/12015/1/1 32卢爱中-办公室休闲椅三件套2014/12/12015/1/1 33卢爱中-厂区PVC门2014/12/12015/1/1 3412.15卢爱中-常州天宁仁祥-水电气材料2014/12/12015/1/135支环氧地坪款2014/12/12015/1/136支安泰建材地砖款2014/12/12015/1/1371.20工艺品01记-00142015/1/1 381.14厂区铝合金隔断（卢爱中）01记-01932015/1/1 39电缆01记-02212015/1/1 40河南红革幕墙装修款01记-02322015/1/1 41支环氧地坪款02记-01042015/2/1 422.13支美裕高办公室插座02记-01112015/2/1 43支富幡五金不锈钢款02记-01172015/2/1 44支装修石材费02记-01202015/2/1 45支电动门、玻璃门费用02记-01272015/2/1 46支网络安装款02记-01282015/2/1 47支创顺源暖通设备车间通风安装费02记-01332015/2/1 48支承乾钢结构镀锌管款02记-01442015/2/149支号安电子摄像机款02记-01452015/2/1 50支远大电缆电缆款02记-01462015/2/1 51无锡建能特种线缆电线款03记-02512015/3/1 52河南省大明电缆有限公司电缆03记-02692015/3/1 53常州鑫鼎物资有限公司镀锌板款03记-02922015/3/1 54无锡市鑫亿鹏升钢铁有限公司镀锌板03记-02932015/3/1 55退厂区草帽灯罩及灯泡03记-02962015/3/1 56付北亚装饰装修费04记-00512015/4/1 57付王振车间装修费04记-01232015/4/1 58常州市豪骏弯管 玻璃05记-02412015/5/1 59五星利康设备搬迁费06记-00652015/6/1 60办公楼打扫费06记-00682015/6/1 61付湖塘美之选遮阳伞安装费（江建华）08记-00682015/8/1 62付办公室安装纱窗费用（沈凤波）09记-00182015/9/1 63侯林燕 纱窗安装费10记-01162015/10/1 64美之选窗帘费（沙如玉）11记-00152015/11/1 65湖塘兴瑞 吸尘通风管道11记-01122015/11/1制造费用承担比例60%管理费用承担比例30%销售费用承担比例10%向下添加合计金额11.9专利年费（续费至2017年）管理费用01记-00922015/1/12家得利劳务费-潘文人12.131#营业费用01记-02332015/1/1 3农工商劳务费潘文人12.333#营业费用01记-02342015/1/1 4农工商进店费发票已收12.25#营业费用01记-02352015/1/1 5岁宝劳务费3万，人人乐劳务费12万，唐文霞营业费用01记-02362015/1/1 6岁宝劳务费唐文霞12.335#营业费用01记-02372015/1/1 7新一佳劳务费唐文霞12.334营业费用01记-02382015/1/1 8京客隆进店费12.321#营业费用01记-02392015/1/1 9京客隆劳务费龙小兵12.331#营业费用01记-02402015/1/1 10苏果进店费冲2014.3.123#凭证营业费用01记-02412015/1/1 11北京物美劳务费朱德青2014.12.336#营业费用01记-02422015/1/1 12乐天玛特合同费用2014.12.338#营业费用01记-02432015/1/1 13付苏州旺益源服务费营业费用03记-02992015/3/1 14深圳岁宝促销服务费及手续费营业费用03记-03012015/3/1 15付唐文霞（深圳致和至美）人人乐劳务费营业费用03记-03082015/3/1 16付武树勋（天兴旺达）北京乐天玛特劳务费营业费用03记-03092015/3/1 17付长春新天地超市开户费及条码费（票未到）营业费用03记-03122015/3/1 18付长春吉祥瑞达超市开户费及条码费（票未到）营业费用03记-03132015/3/1 19付天津津工开户费及条码费（票未到）营业费用03记-03142015/3/1 20付江苏大统华进店费（票未到）营业费用03记-03152015/3/1 21苏州旺益源服务费营业费用03记-03162015/3/1 22上海易初莲花促销费营业费用03记-03422015/3/1 23付北京华联综合超市进场费营业费用04记-00492015/4/1 24成都人人乐商品陈列费营业费用07记-00252015/7/1 25大润发进店费营业费用07记-03042015/7/1 26乐天超市进店费（发票到，1.243#无票已做5万）营业费用07记-03072015/7/1 27苏州旺益源服务费营业费用10记-03752015/10/1 28注：绿色部份为带公式不需录入数据费用发生额摊销期限（月）月摊销额本月摊销额本月摊销额本月摊销额本月摊销额2015/1/12015/2/12015/3/12015/4/1总计 58,372.67 62,506.71 73,916.27 79,956.435,136,736.50 - 86,147.83 37,700.45 41,834.48 42,535.34 47,242.17 60,826.71 60 1,013.78 1,013.78 1,013.78 1,013.78 1,013.78 11,000.00 60 183.33 183.33 183.33 183.33 183.33 10,090.00 60 168.17 168.17 168.17 168.17 168.17 3,686.00 60 61.43 61.43 61.43 61.43 61.43 9,700.00 60 161.67 161.67 161.67 161.67 161.67 11,172.00 60 186.20 186.20 186.20 186.20 186.20 32,905.98 60 548.43 548.43 548.43 548.43 548.43 57,878.20 60 964.64 964.64 964.64 964.64 964.64 9,500.00 60 158.33 158.33 158.33 158.33 158.33 66,913.21 60 1,115.22 1,115.22 1,115.22 1,115.22 1,115.22 7,966.00 60 132.77 132.77 132.77 132.77 132.77 128,756.23 60 2,145.94 2,145.94 2,145.94 2,145.94 2,145.94 31,729.25 60 528.82 528.82 528.82 528.82 528.82 44,239.32 60 737.32 737.32 737.32 737.32 737.32 31,393.22 60 523.22 523.22 523.22 523.22 523.22 3,382.05 60 56.37 56.37 56.37 56.37 56.37 15,000.00 60 250.00 250.00 250.00 250.00 250.00 13,317.03 60 221.95 221.95 221.95 221.95 221.95 15,000.00 60 250.00 250.00 250.00 250.00 250.00 16,188.03 60 269.80 269.80 269.80 269.80 269.80 10,963.46 60 182.72 182.72 182.72 182.72 182.72 149,602.57 60 2,493.38 2,493.38 2,493.38 2,493.38 2,493.38 9,720.00 60 162.00 162.00 162.00 162.00 162.00 6,872.00 60 114.53 114.53 114.53 114.53 114.53 9,914.53 60 165.24 165.24 165.24 165.24 165.24 50,000.00 60 833.33 833.33 833.33 833.33 833.33 300.00 60 5.00 5.00 5.00 5.00 5.00 4,150.00 60 69.17 69.17 69.17 69.17 69.17 4,280.00 60 71.33 71.33 71.33 71.33 71.33 1,800.00 60 30.00 30.00 30.00 30.00 30.00 49,356.00 60 822.60 822.60 822.60 822.60 822.60 3,800.00 60 63.33 63.33 63.33 63.33 63.33 15,398.80 60 256.65 256.65 256.65 256.65 256.65 5,967.52 60 99.46 99.46 99.46 99.46 99.46 100,000.00 60 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 100,000.00 60 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 10,000.00 60 166.67 166.67 166.67 166.67 166.67 2,076.92 60 34.62 34.62 34.62 34.62 34.62 33,627.95 60 560.47 560.47 560.47 560.47 560.47 1,113,553.00 60 18,559.22 18,559.22 18,559.22 18,559.22 18,559.22 72,794.00 60 1,213.23 - 1,213.23 1,213.23 1,213.23 3,076.07 60 51.27 - 51.27 51.27 51.27 19,712.62 60 328.54 - 328.54 328.54 328.54 9,200.00 60 153.33 - 153.33 153.33 153.33 51,282.05 60 854.70 - 854.70 854.70 854.70 23,250.43 60 387.51 - 387.51 387.51 387.51 25,837.61 60 430.63 - 430.63 430.63 430.63 6,923.08 60 115.38 - 115.38 115.38 115.3832,478.63 60 541.31 - 541.31 541.31 541.31 3,488.89 60 58.15 - 58.15 58.15 58.15 7,991.45 60 133.19 - - 133.19 133.19 18,145.30 60 302.42 - - 302.42 302.42 2,202.56 60 36.71 - - 36.71 36.71 15,136.55 60 252.28 - - 252.28 252.28 -1,425.00 60 -23.75 - - -23.75 -23.75 279,930.00 60 4,665.50 - - - 4,665.50 2,480.00 60 41.33 - - - 41.33 10,256.41 60 170.94 - - - - 15,000.00 60 250.00 - - - - 10,000.00 60 166.67 - - - - 6,466.00 60 107.77 - - - - 3,492.00 60 58.20 - - - - 2,904.00 60 48.40 - - - - 575.00 60 9.58 - - - - 3,200.00 60 53.33 - - - -60% 22,620.27 25,100.69 25,521.20 28,345.3030% 11,310.14 12,550.34 12,760.60 14,172.6510% 3,770.05 4,183.45 4,253.53 4,724.2220,672.22 20,672.22 31,380.93 32,714.27 12,200.00 36 338.89 338.89 338.89 338.89 338.89 150,000.00 60 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 50,000.00 60 833.33 833.33 833.33 833.33 833.33 450,000.00 60 7,500.00 7,500.00 7,500.00 7,500.00 7,500.00 150,000.00 60 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 30,000.00 60 500.00 500.00 500.00 500.00 500.00 60,000.00 60 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 100,000.00 60 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 30,000.00 60 500.00 500.00 500.00 500.00 500.00 96,000.00 48 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 30,000.00 60 500.00 500.00 500.00 500.00 500.00 50,000.00 60 833.33 833.33 833.33 833.33 833.33 19,850.00 60 330.83 - - 330.83 330.83 30,000.00 60 500.00 - - 500.00 500.00 130,000.00 60 2,166.67 - - 2,166.67 2,166.67 20,000.00 60 333.33 - - 333.33 333.33 70,000.00 60 1,166.67 - - 1,166.67 1,166.67 66,000.00 60 1,100.00 - - 1,100.00 1,100.00 125,000.00 60 2,083.33 - - 2,083.33 2,083.33 80,600.00 60 1,343.33 - - 1,343.33 1,343.33 60,000.00 60 1,000.00 - - 1,000.00 1,000.00 41,072.87 60 684.55 - - 684.55 684.55 80,000.00 60 1,333.33 - - - 1,333.33 9,000.00 60 150.00 - - - - 173,160.00 60 2,886.00 - - - - 4,430.00 60 73.83 - - - - 133,000.00 60 2,216.67 - - - --本月摊销额本月摊销额本月摊销额本月摊销额本月摊销额本月摊销额本月摊销额2015/5/12015/6/12015/7/12015/8/12015/9/12015/10/12015/11/1 80,127.38 80,544.05 83,653.88 83,761.65 83,819.85 86,084.92 86,147.82 47,413.11 47,829.78 47,829.78 47,937.55 47,995.74 48,044.14 48,107.05 1,013.78 1,013.78 1,013.78 1,013.78 1,013.78 1,013.78 1,013.78 183.33 183.33 183.33 183.33 183.33 183.33 183.33 168.17 168.17 168.17 168.17 168.17 168.17 168.17 61.43 61.43 61.43 61.43 61.43 61.43 61.43 161.67 161.67 161.67 161.67 161.67 161.67 161.67 186.20 186.20 186.20 186.20 186.20 186.20 186.20 548.43 548.43 548.43 548.43 548.43 548.43 548.43 964.64 964.64 964.64 964.64 964.64 964.64 964.64 158.33 158.33 158.33 158.33 158.33 158.33 158.33 1,115.22 1,115.22 1,115.22 1,115.22 1,115.22 1,115.22 1,115.22 132.77 132.77 132.77 132.77 132.77 132.77 132.77 2,145.94 2,145.94 2,145.94 2,145.94 2,145.94 2,145.94 2,145.94 528.82 528.82 528.82 528.82 528.82 528.82 528.82 737.32 737.32 737.32 737.32 737.32 737.32 737.32 523.22 523.22 523.22 523.22 523.22 523.22 523.22 56.37 56.37 56.37 56.37 56.37 56.37 56.37 250.00 250.00 250.00 250.00 250.00 250.00 250.00 221.95 221.95 221.95 221.95 221.95 221.95 221.95 250.00 250.00 250.00 250.00 250.00 250.00 250.00 269.80 269.80 269.80 269.80 269.80 269.80 269.80 182.72 182.72 182.72 182.72 182.72 182.72 182.72 2,493.38 2,493.38 2,493.38 2,493.38 2,493.38 2,493.38 2,493.38 162.00 162.00 162.00 162.00 162.00 162.00 162.00 114.53 114.53 114.53 114.53 114.53 114.53 114.53 165.24 165.24 165.24 165.24 165.24 165.24 165.24 833.33 833.33 833.33 833.33 833.33 833.33 833.33 5.00 5.00 5.00 5.00 5.00 5.00 5.00 69.17 69.17 69.17 69.17 69.17 69.17 69.17 71.33 71.33 71.33 71.33 71.33 71.33 71.33 30.00 30.00 30.00 30.00 30.00 30.00 30.00 822.60 822.60 822.60 822.60 822.60 822.60 822.60 63.33 63.33 63.33 63.33 63.33 63.33 63.33 256.65 256.65 256.65 256.65 256.65 256.65 256.65 99.46 99.46 99.46 99.46 99.46 99.46 99.461,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.671,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 166.67 166.67 166.67 166.67 166.67 166.67 166.67 34.62 34.62 34.62 34.62 34.62 34.62 34.62 560.47 560.47 560.47 560.47 560.47 560.47 560.47 18,559.22 18,559.22 18,559.22 18,559.22 18,559.22 18,559.22 18,559.22 1,213.23 1,213.23 1,213.23 1,213.23 1,213.23 1,213.23 1,213.23 51.27 51.27 51.27 51.27 51.27 51.27 51.27 328.54 328.54 328.54 328.54 328.54 328.54 328.54 153.33 153.33 153.33 153.33 153.33 153.33 153.33 854.70 854.70 854.70 854.70 854.70 854.70 854.70 387.51 387.51 387.51 387.51 387.51 387.51 387.51 430.63 430.63 430.63 430.63 430.63 430.63 430.63 115.38 115.38 115.38 115.38 115.38 115.38 115.38541.31 541.31 541.31 541.31 541.31 541.31 541.31 58.15 58.15 58.15 58.15 58.15 58.15 58.15 133.19 133.19 133.19 133.19 133.19 133.19 133.19 302.42 302.42 302.42 302.42 302.42 302.42 302.42 36.71 36.71 36.71 36.71 36.71 36.71 36.71 252.28 252.28 252.28 252.28 252.28 252.28 252.28 -23.75 -23.75 -23.75 -23.75 -23.75 -23.75 -23.75 4,665.50 4,665.50 4,665.50 4,665.50 4,665.50 4,665.50 4,665.50 41.33 41.33 41.33 41.33 41.33 41.33 41.33 170.94 170.94 170.94 170.94 170.94 170.94 170.94 - 250.00 250.00 250.00 250.00 250.00 250.00 - 166.67 166.67 166.67 166.67 166.67 166.67 - - - 107.77 107.77 107.77 107.77 - - - - 58.20 58.20 58.20 - - - - - 48.40 48.40 - - - - - - 9.58 - - - - - - 53.33 28,447.87 28,697.87 28,697.87 28,762.53 28,797.45 28,826.49 28,864.23 14,223.93 14,348.93 14,348.93 14,381.26 14,398.72 14,413.24 14,432.12 4,741.31 4,782.98 4,782.98 4,793.75 4,799.57 4,804.41 4,810.71 32,714.27 32,714.27 35,824.10 35,824.10 35,824.10 38,040.77 38,040.77 338.89 338.89 338.89 338.89 338.89 338.89 338.89 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 833.33 833.33 833.33 833.33 833.33 833.33 833.33 7,500.00 7,500.00 7,500.00 7,500.00 7,500.00 7,500.00 7,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 500.00 500.00 500.00 500.00 500.00 500.00 500.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 833.33 833.33 833.33 833.33 833.33 833.33 833.33 330.83 330.83 330.83 330.83 330.83 330.83 330.83 500.00 500.00 500.00 500.00 500.00 500.00 500.00 2,166.67 2,166.67 2,166.67 2,166.67 2,166.67 2,166.67 2,166.67 333.33 333.33 333.33 333.33 333.33 333.33 333.33 1,166.67 1,166.67 1,166.67 1,166.67 1,166.67 1,166.67 1,166.67 1,100.00 1,100.00 1,100.00 1,100.00 1,100.00 1,100.00 1,100.00 2,083.33 2,083.33 2,083.33 2,083.33 2,083.33 2,083.33 2,083.33 1,343.33 1,343.33 1,343.33 1,343.33 1,343.33 1,343.33 1,343.33 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 684.55 684.55 684.55 684.55 684.55 684.55 684.55 1,333.33 1,333.33 1,333.33 1,333.33 1,333.33 1,333.33 1,333.33 - - 150.00 150.00 150.00 150.00 150.00 - - 2,886.00 2,886.00 2,886.00 2,886.00 2,886.00 - - 73.83 73.83 73.83 73.83 73.83 - - - - - 2,216.67 2,216.67本月摊销额累计总摊销2015/12/186,147.83 945,039.46 48,107.06 945,039.46 1,013.78 12,165.34 183.33 2,200.00 168.17 2,018.00 61.43 737.20 161.67 1,940.00 186.20 2,234.40 548.43 6,581.19 964.64 11,575.64 158.33 1,900.00 1,115.22 13,382.64 132.77 1,593.20 2,145.94 25,751.25 528.82 6,345.85 737.32 8,847.86 523.22 6,278.64 56.37 676.41 250.00 3,000.00 221.95 2,663.41 250.00 3,000.00 269.80 3,237.61 182.72 2,192.69 2,493.38 29,920.52 162.00 1,944.00 114.53 1,374.40 165.24 1,982.90 833.33 10,000.00 5.00 60.00 69.17 830.00 71.33 856.00 30.00 360.00 822.60 9,871.20 63.33 760.00 256.65 3,079.76 99.46 1,193.51 1,666.67 20,000.00 1,666.67 20,000.00 166.67 2,000.00 34.62 415.39 560.47 6,725.59 18,559.22 222,710.60 1,213.23 13,345.56 51.27 563.95 328.54 3,613.98 153.33 1,686.66 854.70 9,401.71 387.51 4,262.58 430.63 4,736.90 115.38 1,269.23541.31 5,954.42 58.15 639.63 133.19 1,331.91 302.42 3,024.22 36.71 367.09 252.28 2,522.76 -23.75 -237.50 4,665.50 41,989.50 41.33 372.00 170.94 1,367.52 250.00 1,750.00 166.67 1,166.67 107.77 538.84 58.20 232.80 48.40 145.20 9.58 19.16 53.33 106.66 28,864.2414,432.124,810.7138,040.77338.89 4,066.67 2,500.00 30,000.00 833.33 10,000.00 7,500.00 90,000.00 2,500.00 30,000.00 500.00 6,000.00 1,000.00 12,000.00 1,666.67 20,000.00 500.00 6,000.00 2,000.00 24,000.00 500.00 6,000.00 833.33 10,000.00 330.83 3,308.33 500.00 5,000.00 2,166.67 21,666.67 333.33 3,333.33 1,166.67 11,666.67 1,100.00 11,000.00 2,083.33 20,833.33 1,343.33 13,433.33 1,000.00 10,000.00 684.55 6,845.48 1,333.33 12,000.00 150.00 900.00 2,886.00 17,316.00 73.83 443.00 2,216.67 6,650.00。