金蝶资产负债表公式设置

资产行次年初数期末数流动资产：货币资金1=ACCT(1001:1012,C,,0,1,0,)=ACCT(1001:1012,Y,,0,0,0,)交易性金融资产2=ACCT(1101,C,,0,1,0,)=ACCT(1101,Y,,0,0,0,)应收票据3=ACCT(1121,C,,0,1,0,)=ACCT(1121,Y,,0,0,0,)应收账款4=ACCT(1122,C,,0,1,0,)-ACCT(1231,C,,0,1,0,)=ACCT(1122,Y,,0,0,0,)-ACCT(1231,Y,,0,0,0,)预付款项5应收利息6=ACCT(1132,C,,0,1,0,)=ACCT(1132,Y,,0,0,0,)应收股利7=ACCT(1131,C,,0,1,0,)=ACCT(1131,Y,,0,0,0,)其他应收款8=ACCT(1221,C,,0,1,0,)=ACCT(1221,Y,,0,0,0,)存货9=ACCT(1405:1412,C,,0,1,0,)=ACCT(1405:1412,Y,,0,0,0,)其中：库存商品10待摊费用11一年内到期的非流动资产12其他流动资产13流动资产合计=SUM(C3:C11)+SUM(C13:C15)=SUM(D3:D11)+SUM(D13:D15)非流动资产：可供出售金融资产14持有至到期投资15=ACCT(1501,C,,0,1,0,)-ACCT(1502,C,,0,1,0,)=ACCT(1501,Y,,0,0,0,)-ACCT(1502,Y,,0,0,0,)长期应收款16长期股权投资17投资性房地产18固定资产19=ACCT(1601,C,,0,1,0,)-ACCT(1602,C,,0,1,0,)-ACCT(1603,C,,0,1,0,)=ACCT(1601,Y,,0,0,0,)-ACCT(1602,Y,,0,0,0,)-ACCT(1603,Y,,0,0,0,)在建工程20=ACCT(1604,C,,0,1,0,)=ACCT(1604,Y,,0,0,0,)工程物资21固定资产清理22=ACCT(1606,C,,0,1,0,)=ACCT(1606,Y,,0,0,0,)生产性生物资产23油气资产24无形资产25=ACCT(1701,C,,0,1,0,)+ACCT(1702,C,,0,1,0,)=ACCT(1701)+ACCT(1702,Y,,0,0,0,)开发支出26商誉27长期待摊费用28递延所得税资产29其他非流动资产30非流动资产合计=SUM(C18:C34)=SUM(D18:D34)资产总计=C16+C35=D16+D35负债和股东权益行次年初数期末数流动负债：短期借款31交易性金融负债32应付票据33=ACCT(2201,C,,0,1,0,)=ACCT(2201,Y,,0,0,0,)应付账款34=ACCT(2202,C,,0,1,0,)=ACCT(2202,Y,,0,0,0,)预收款项35应付职工薪酬36=ACCT(2211,C,,0,1,0,)=ACCT(2211,Y,,0,0,0,)应交税费37=ACCT(2221,C,,0,1,0,)=ACCT(2221,Y,,0,0,0,)应付利息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