EXCEL會計全套表格

1、科科目目目目錄錄表表1 1 現(xiàn)金1 11 1 待攤費用2 21 1 其他應(yīng)交款3 31 12 2 銀行存款1 12 2 固定資產(chǎn)2 22 2 預(yù)提費用3 32 23 3 短期投資1 13 3 累計折舊2 23 3 長期借款3 33 34 4 應(yīng)收票據(jù)1 14 4 固定資產(chǎn)清理2 24 4 實收資本3 34 45 5 應(yīng)收帳款1 15 5 在建工程2 25 5 本年利潤3 35 56 6 壞帳準備1 16 6 應(yīng)付工資2 26 6 利潤分配3 36 67 7 預(yù)付帳款1 17 7 應(yīng)付帳款2 27 7 商品銷售收入3 37 78 8 其他應(yīng)收款1 18 8 應(yīng)付福利費2 28 8 商品銷售成本9

2、 9 原材料1 19 9 其他應(yīng)付款2 29 9 經(jīng)營費用1 10 0 低值易耗品2 20 0 應(yīng)交稅金3 30 0 商品銷售稅金及附加庫存商品遞延資產(chǎn)3 31 1 短期借款在產(chǎn)品資本公積待轉(zhuǎn)資產(chǎn)價值產(chǎn)成品盈余公積應(yīng)付利潤其他業(yè)務(wù)收入其他業(yè)務(wù)支出所得稅管理費用財務(wù)費用營業(yè)外收入營業(yè)外支出生產(chǎn)成本制造費用以前年度損益調(diào)整無形資產(chǎn)產(chǎn)品銷售費用科科目目目目錄錄表表1 1現(xiàn)現(xiàn)金金2 2銀銀行行存存款款3 3短短期期投投資資應(yīng)應(yīng)收收票票據(jù)據(jù)應(yīng)應(yīng)收收帳帳款款壞壞帳帳準準備備60009006000137498.49002604.96126.7260000013800300000202696080000372

3、0120000137498.4200086000137498.413218912200000200473.45180300000505000012116473.61231.4144201000098533500098533200008036.613.5157301000468069.81000500800007647300000285200078985334290000126.73000206.5326006604509600018971552205147752052502300128010002255760200000206.53215047974.69合計118584.8102330.83

4、 5762016.53 2837392.3400137498.40137498.4718398.402604.96低低值值易易耗耗品品待待攤攤費費用用固固定定資資產(chǎn)產(chǎn)累累計計折折舊舊固固定定資資產(chǎn)產(chǎn)清清理理在在建建工工程程8003138009004000018823.7468026001200合計000800361080120090018823.70000其其他他應(yīng)應(yīng)付付款款應(yīng)應(yīng)交交稅稅金金其其他他應(yīng)應(yīng)交交款款預(yù)預(yù)提提費費用用長長期期借借款款實實收收資資本本2003917.27429440540.511596.5935001323.84220002393.614300100113076.922

5、756551111.119978.4327760196.3553219.7353219.73532.263813.366000合計0200 364887.36 473151.654291596.593940220000000商商品品銷銷售售成成本本經(jīng)經(jīng)營營費費用用商商品品銷銷售售稅稅金金及及附附加加其其他他業(yè)業(yè)務(wù)務(wù)收收入入其其他他業(yè)業(yè)務(wù)務(wù)支支出出所所得得稅稅1475849.662128.793179.4963813.361475849.662128.79300063813.366535.912715.39合計1475849.66 1475849.66002128.792128.7912715.

6、3912715.390063813.3663813.36營營業(yè)業(yè)外外支支出出庫庫存存商商品品在在產(chǎn)產(chǎn)品品產(chǎn)產(chǎn)成成品品遞遞延延資資產(chǎn)產(chǎn)生生產(chǎn)產(chǎn)成成本本2300213610.819155.3957539205.82335.7230029412.08782.69196.3523036.46743.933371.351416951.791080253379.0828605518.79976.7106565395.6423985590.615313.7593257.787972.527577.73350.8213610.8139205.8229412.0823036.46合計3371.353371.35

7、0000305265.171475849.6600 217578.23305265.17短短期期借借款款無無形形資資產(chǎn)產(chǎn)產(chǎn)產(chǎn)品品銷銷售售費費用用資資本本公公積積待待轉(zhuǎn)轉(zhuǎn)資資產(chǎn)產(chǎn)價價值值盈盈余余公公積積26000008600017588.16200004000059416.2130000022053400040000200000128017588.1622051280200000290000086000021073.1621073.160540004000040000059416.21預(yù)預(yù)付付帳帳款款其其他他應(yīng)應(yīng)收收款款原原材材料料5000100023042.732000140802000769

8、23.08100016215001000115550010802580286010003576.7906550000408050001735545.8127458.7應(yīng)應(yīng)付付工工資資應(yīng)應(yīng)付付帳帳款款應(yīng)應(yīng)付付福福利利費費9853312000013794.639853350000260014775100098533985331883750013794.63本本年年利利潤潤利利潤潤分分配配商商品品銷銷售售收收入入1635412.96594162.1111752063813.362060835.3959416.211928000594162.112000020455202293388.43206083

9、5.3979416.21 594162.1120455202045520管管理理費費用用財財務(wù)務(wù)費費用用營營業(yè)業(yè)外外收收入入873.3473.4536.6260020121960002600473.452000175013269.8215014422036.6180470956005012027.251211929.5768.61706.74202604.96801219113.518069.8559.52202800.24502857842873.312027.251929.51706.741219120002604.9637353.437353.497786.697786.62600260

10、0制制造造費費用用以以前前年年度度損損益益調(diào)調(diào)整整1000022000800335947.4416894.21070.161060076441000022000800335947.4416894.21070.16106007644112158.8112158.800應(yīng)應(yīng)付付利利潤潤20000020000科科 目目 匯匯 總總 表表2006年5月30日憑證起訖號自 號至 號止會計科目本期發(fā)生額借方金額貸方金額1 現(xiàn)金118,584.80102,330.832 銀行存款5,762,016.532,837,392.343 短期投資-4 應(yīng)收票據(jù)137,498.40-5 應(yīng)收帳款137,498.407

11、18,398.406 壞帳準備-2,604.967 預(yù)付帳款5,000.00-8 其他應(yīng)收款4,080.005,000.009 原材料1,735,545.8127,458.70無形資產(chǎn)86,000.00-待轉(zhuǎn)資產(chǎn)價值40,000.0040,000.0010 低值易耗品-11 待攤費用-8,003.0012 庫存商品-13 在產(chǎn)品-14 產(chǎn)成品305,265.171,475,849.6615 固定資產(chǎn)61,080.001,200.0016 累計折舊900.0018,823.7017 固定資產(chǎn)清理-18 在建工程-19 遞延資產(chǎn)-20 應(yīng)付工資98,533.0098,533.0021 應(yīng)付帳款18

12、8,375.00-22 應(yīng)付福利費-13,794.6323 其他應(yīng)付款-200.0024 應(yīng)交稅金364,887.36473,151.6525 其他應(yīng)交款429.001,596.5926 預(yù)提費用3,940.0022,000.00短期借款200,000.002,900,000.0027 長期借款-28 實收資本-盈余公積-59,416.21資本公積-54,000.0029 本年利潤2,293,388.432,060,835.3930 利潤分配79,416.21594,162.1131 主營業(yè)務(wù)收入2,045,520.002,045,520.0032 主營業(yè)務(wù)成本1,475,849.661,47

13、5,849.6633 生產(chǎn)成本217,578.23305,265.1734 制造費用112,158.80112,158.8035 經(jīng)營費用-36 商品銷售稅金及附加2,128.792,128.7937 其他業(yè)務(wù)收入12,715.3912,715.3938 其他業(yè)務(wù)支出-39 所得稅63,813.3663,813.3640 管理費用37,353.4037,353.40產(chǎn)品銷售費用21,073.1621,073.1641 財務(wù)費用97,786.6097,786.6042 營業(yè)外收入2,600.002,600.0043 營業(yè)外支出3,371.353,371.35應(yīng)付利潤-20,000.0044 以前

14、年度損益調(diào)整-45 合計15,714,386.8515,714,386.85制表:科科 目目 匯匯 總總 表表憑證起訖號自 號至 號止會計科目上期余額本期發(fā)生額期未余額借方金額貸方金額借方金額貸方金額借方金額1 現(xiàn)金441.50118,584.80102,330.8316,695.472 銀行存款16,915.195,762,016.532,837,392.342,941,539.383 貨幣資金17,356.695,880,601.332,939,723.172,958,234.854 短期投資-5 應(yīng)收票據(jù)137,498.40-137,498.406 應(yīng)收帳款137,498.40718,3

15、98.40-580,900.007 壞帳準備-2,604.96-2,604.968 預(yù)付帳款5,000.00-5,000.009 其他應(yīng)收款4,080.005,000.00-920.0010 原材料1,735,545.8127,458.701,708,087.1111 低值易耗品-12 待攤費用-8,003.00-8,003.0013 庫存商品-14 在產(chǎn)品-15 產(chǎn)成品305,265.171,475,849.66-1,170,584.4916 固定資產(chǎn)61,080.001,200.0059,880.0017 累計折舊900.0018,823.7018 固定資產(chǎn)清理-19 在建工程-20 遞延

16、資產(chǎn)-21 應(yīng)付工資98,533.0098,533.0022 應(yīng)付帳款188,375.00-23 應(yīng)付福利費-13,794.6324 其他應(yīng)付款-200.0025 應(yīng)交稅金364,887.36473,151.6526 其他應(yīng)交款429.001,596.5927 預(yù)提費用3,940.0022,000.0028 長期借款-29 實收資本-30 本年利潤2,293,388.432,060,835.3931 利潤分配79,416.21594,162.1132 主營業(yè)務(wù)收入2,045,520.002,045,520.0033 主營業(yè)務(wù)成本1,475,849.661,475,849.6634 生產(chǎn)成本21

17、7,578.23305,265.1735 制造費用112,158.80112,158.8036 經(jīng)營費用-37 商品銷售稅金及附加2,128.792,128.7938 其他業(yè)務(wù)收入12,715.3912,715.3939 其他業(yè)務(wù)支出-40 所得稅63,813.3663,813.3641 管理費用37,353.4037,353.4042 財務(wù)費用97,786.6097,786.6043 營業(yè)外收入2,600.002,600.0044 營業(yè)外支出3,371.353,371.3545 以前年度損益調(diào)整-46 合計15,367,313.6912,619,897.483,105,687.91會計主管

18、: 記帳: 審核: 制表:貸方金額17,923.70-科科 目目 匯匯 總總 表表憑證起訖號自 號至 號止期未余額-188,375.0013,794.63200.00108,264.291,167.5918,060.00-232,553.04514,745.90253,228.07資資產(chǎn)產(chǎn)負負債債表表單位：日期范圍：2006.05.01-2006.05.30資產(chǎn)年初數(shù)期未數(shù)負債及所有者權(quán)益年初數(shù)期未數(shù)流動資產(chǎn)：流動負債：貨幣資金12,958,234.85短期借款32短期投資2-應(yīng)付票據(jù)33應(yīng)收票據(jù)3137,498.40應(yīng)付帳款34-188,375.00應(yīng)收帳款4-580,900.00預(yù)收帳款3

19、5減：壞帳準備5-2,604.96其它應(yīng)付款36200.00應(yīng)收帳款凈額6-578,295.04應(yīng)付工資37-預(yù)付帳款75,000.00應(yīng)付福利費3813,794.63應(yīng)收補貼款8未交稅金39108,264.29應(yīng)彌補虧損9未交利潤40其它應(yīng)收款10-920.00其它未交款411,167.59存貨11537,502.62預(yù)提費用4218,060.00其中：庫存商品11.1-一年內(nèi)到期的長期負債43待轉(zhuǎn)其它業(yè)務(wù)支出12其它流動負債44待攤費用13-8,003.00流動負債合計45-46,888.49待處理流動資產(chǎn)凈損失14長期負債一年內(nèi)到期的長期債券投資15長期借款46-其它流動資產(chǎn)16其中：地

20、方資金借款47流動資產(chǎn)合計17-3,051,017.83應(yīng)付債券48長期投資：長期應(yīng)付款49長期投資18其它長期負債50固定資產(chǎn)：其中：住房周轉(zhuǎn)金51固定資產(chǎn)原價1959,880.00專項應(yīng)付款52減：累計折舊2017,923.70長期負債合計53-固定資產(chǎn)凈值21-41,956.30遞延稅項固定資產(chǎn)清理22-遞延稅款貸項54在建工程23-負債合計55-46,888.49待處理固定資產(chǎn)凈損失24所有者權(quán)益固定資產(chǎn)合計25-41,956.30實收資本56-無形資產(chǎn)及遞延資產(chǎn)：資本公積57無形資產(chǎn)26其中：補充流動資金58遞延資產(chǎn)27-盈余公積59無形資產(chǎn)及遞延資產(chǎn)合計28-其中：公益金60其它資產(chǎn)：補充流動資本61其它長期資產(chǎn)29未分配利潤62282,192.86遞延稅項