6. EXCEL T型賬科目匯總表模板

科目匯總表,,,

,,,,

20**/5/30,,,

憑證起訖號自號至號止,,,

會計科目,,本期發(fā)生額,

,,借方金額,貸方金額

1,現(xiàn)金,"118,584.80","102,330.83"

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

3,短期投資,-,-

4,應(yīng)收票據(jù),"137,498.40",-

5,應(yīng)收帳款,"137,498.40","718,398.40"

6,壞帳準(zhǔn)備,-,"2,604.96"

7,預(yù)付帳款,"5,000.00",-

8,其他應(yīng)收款,"4,080.00","5,000.00"

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

,無形資產(chǎn),"86,000.00",-

,待轉(zhuǎn)資產(chǎn)價值,"40,000.00","40,000.00"

10,低值易耗品,-,-

11,待攤費(fèi)用,-,"8,003.00"

12,庫存商品,-,-

13,在產(chǎn)品,-,-

14,產(chǎn)成品,"305,265.17","1,475,849.66"

15,固定資產(chǎn),"61,080.00","1,200.00"

16,累計折舊,900.00,"18,823.70"

17,固定資產(chǎn)清理,-,-

18,在建工程,-,-

19,遞延資產(chǎn),-,-

20,應(yīng)付工資,"98,533.00","98,533.00"

21,應(yīng)付帳款,"188,375.00",-

22,應(yīng)付福利費(fèi),-,"13,794.63"

23,其他應(yīng)付款,-,200.00

24,應(yīng)交稅金,"364,887.36","473,151.65"

25,其他應(yīng)交款,429.00,"1,596.59"

26,預(yù)提費(fèi)用,"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,主營業(yè)務(wù)收入,"2,045,520.00","2,045,520.00"

32,主營業(yè)務(wù)成本,"1,475,849.66","1,475,849.66"

33,生產(chǎn)成本,"217,578.23","305,265.17"

34,制造費(fèi)用,"112,158.80","112,158.80"

35,經(jīng)營費(fèi)用,-,-

36,商品銷售稅金及附加,"2,128.79","2,128.79"

37,其他業(yè)務(wù)收入,"12,715.39","12,715.39"

38,其他業(yè)務(wù)支出,-,-

39,所得稅,"63,813.36","63,813.36"

40,管理費(fèi)用,"37,353.40","37,353.40"

,產(chǎn)品銷售費(fèi)用,"21,073.16","21,073.16"

41,財務(wù)費(fèi)用,"97,786.60","97,786.60"

42,營業(yè)外收入,"2,600.00","2,600.00"

43,營業(yè)外支出,"3,371.35","3,371.35"

,應(yīng)付利潤,-,"20,000.00"

44,以前年度損益調(diào)整,-,-

,,