6. EXCEL T型账科目汇总表模板

科目汇总表,,,

,,,,

20**/5/30,,,

凭证起讫号自号至号止,,,

会计科目,,本期发生额,

,,借方金额,贷方金额

1,现金,"118,584.80","102,330.83"

2,银行存款,"5,762,016.53","2,837,392.34"

3,短期投资,-,-

4,应收票据,"137,498.40",-

5,应收帐款,"137,498.40","718,398.40"

6,坏帐准备,-,"2,604.96"

7,预付帐款,"5,000.00",-

8,其他应收款,"4,080.00","5,000.00"

9,原材料,"1,735,545.81","27,458.70"

,无形资产,"86,000.00",-

,待转资产价值,"40,000.00","40,000.00"

10,低值易耗品,-,-

11,待摊费用,-,"8,003.00"

12,库存商品,-,-

13,在产品,-,-

14,产成品,"305,265.17","1,475,849.66"

15,固定资产,"61,080.00","1,200.00"

16,累计折旧,900.00,"18,823.70"

17,固定资产清理,-,-

18,在建工程,-,-

19,递延资产,-,-

20,应付工资,"98,533.00","98,533.00"

21,应付帐款,"188,375.00",-

22,应付福利费,-,"13,794.63"

23,其他应付款,-,200.00

24,应交税金,"364,887.36","473,151.65"

25,其他应交款,429.00,"1,596.59"

26,预提费用,"3,940.00","22,000.00"

,短期借款,"200,000.00","2,900,000.00"

27,长期借款,-,-

28,实收资本,-,-

,盈余公积,-,"59,416.21"

,资本公积,-,"54,000.00"

29,本年利润,"2,293,388.43","2,060,835.39"

30,利润分配,"79,416.21","594,162.11"

31,主营业务收入,"2,045,520.00","2,045,520.00"

32,主营业务成本,"1,475,849.66","1,475,849.66"

33,生产成本,"217,578.23","305,265.17"

34,制造费用,"112,158.80","112,158.80"

35,经营费用,-,-

36,商品销售税金及附加,"2,128.79","2,128.79"

37,其他业务收入,"12,715.39","12,715.39"

38,其他业务支出,-,-

39,所得税,"63,813.36","63,813.36"

40,管理费用,"37,353.40","37,353.40"

,产品销售费用,"21,073.16","21,073.16"

41,财务费用,"97,786.60","97,786.60"

42,营业外收入,"2,600.00","2,600.00"

43,营业外支出,"3,371.35","3,371.35"

,应付利润,-,"20,000.00"

44,以前年度损益调整,-,-

,,