金蝶资产负债表公式设置

息 38 Р应付股利 39 Р其他应付款 40 =ACCT("2241","C","",0,"1",0,"") =ACCT("2241") Р预提费用 41 Р一年内到期的非流动负债 42 Р其他流动负债 43 Р流动负债合计=SUM(G3:G15) =SUM(H3:H15) Р非流动负债: Р长期借款 44 Р应付债券 45 Р长期应付款 46 Р专项应付款 47 =ACCT("2811","C","",0,"1",0,"") =ACCT("2811","Y","",0,0,0,"") Р预计负债 48 Р递延所得税负债 49 Р其他非流动负债 50 Р非流动负债合计=SUM(G18:G24) =SUM(H18:H24) Р负债合计=G16+G25 =H16+H25 Р Р股东权益: Р股本 51 =ACCT("4001","C","",0,"1",0,"") =ACCT("4001","Y","",0,0,0,"") Р资本公积 52 =ACCT("4002","C","",0,"1",0,"") =ACCT("4002","Y","",0,0,0,"") Р减:库存股 53 Р盈余公积 54 =ACCT("4101","C","",0,"1",0,"") =ACCT("4101","Y","",0,0,0,"") Р其中:法定公益金 55 =ACCT("4101.01","C","",0,"1",0,"") =ACCT("4101.01","Y","",0,0,0,"") Р未分配利润 56 =ACCT("4103:4104","C","",0,"1",0,"") =ACCT("4103:4104","Y","",0,0,0,"") Р股东权益合计=G29+G30+G32+G34 =H29+H30+H32+H34 Р负债和股东权益总计=G35+G26 =H35+H26