自動計算資產(chǎn)負(fù)債表模板

資產(chǎn)負(fù)債表,,,,,,,

微機(jī)編碼：,,,,,,,

所屬時期：,,,,,,,

資產(chǎn),行次,年初數(shù),期末數(shù),負(fù)債和所有者權(quán)益（或股東權(quán)益）,行次,年初數(shù),期末數(shù)

流動資產(chǎn)：,,,,流動負(fù)債：,,,

貨幣資金,1,,,短期借款,68,,

短期投資,2,,,應(yīng)付票據(jù),69,,

應(yīng)收票據(jù),3,,,應(yīng)付賬款,70,,

應(yīng)收股利,4,,,預(yù)收賬款,71,,

應(yīng)收利息,5,,,應(yīng)付工資,72,,

應(yīng)收賬款,6,,,應(yīng)付福利費(fèi),73,,

其他應(yīng)收款,7,,,應(yīng)付股利,74,,

預(yù)付賬款,8,,,應(yīng)交稅金,75,,

應(yīng)收補(bǔ)貼款,9,,,其他應(yīng)交款,80,,

存貨,10,,,其他應(yīng)付款,81,,

待攤費(fèi)用,11,,,預(yù)提費(fèi)用,82,,

一年內(nèi)到期的長期債券投資,21,,,預(yù)計負(fù)債,83,,

其他流動資產(chǎn),24,,,一年內(nèi)到期的長期負(fù)債,86,,

流動資產(chǎn)合計,31,0.00,0.00,其他流動負(fù)債,90,,

長期資產(chǎn)：,,,,,,,

長期股權(quán)投資,32,,,流動負(fù)債合計,100,0.00,0.00

長期債權(quán)投資,34,,,長期負(fù)債：,,,

長期投資合計,38,0.00,0.00,長期借款,101,,

固定資產(chǎn)：,,,,應(yīng)付債券,102,,

固定資產(chǎn)原價,39,,,長期應(yīng)付款,103,,

減：累計折舊,40,,,專項應(yīng)付款,106,,

固定資產(chǎn)凈值,41,0.00,0.00,其他長期負(fù)債,108,,

減：固定資產(chǎn)減值準(zhǔn)備,42,,,長期負(fù)債合計,110,0.00,0.00

固定資產(chǎn)凈額,43,0.00,0.00,遞延稅項：,,,

工程物資,44,,,遞延稅款貸項,111,,

在建工程,45,,,負(fù)債合計,114,0.00,0.00

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

固定資產(chǎn)合計,50,0.00,0.00,所有者權(quán)益（或股東權(quán)益）：,,,

無形資產(chǎn)及其他資產(chǎn)：,,,,實收資本（或股本）,115,,

無形資產(chǎn),51,,,減：已歸還投資,116,,

長期待攤費(fèi)用,52,,,實收資本（或股本）凈額,117,0.00,0.00

其他長期資產(chǎn),53,,,資本公積,118,,

無形資產(chǎn)及其他資產(chǎn)合計,60,0.00,0.00,盈余公積,119,,

,,,,其中：法定公益金,120,,

遞延稅款：,,,,未分配利潤,121,,

遞延稅款借項,61,,,所有者權(quán)益（或股東權(quán)益）合計,122,0.00,0.00

資產(chǎn)合計,67,0.00,0.00,負(fù)債和所有者權(quán)益（或股東權(quán)益）總計,135,0.00,0.00

注：1.綠色區(qū)域為可輸入部分，灰色區(qū)域為不可修改部分,,,,,,,

2.B2欄需填入本單位的15位地稅微機(jī)編碼（文本格式）,,,,,,,

3.月報需在B3、C3欄填入所屬月份的起始日期，如2005年6月月報即填入2005-6-1、2005-6-30（日期格式、注意每個月的大小月）,,,,,,,

4.年報需在B3、C