金蝶软件报表公式定义

1、=ACCT(1531,Y,0,0,0)-ACCT(1532,Y,0,0,0)资产负债表：货币资金年初数=ACCT(1001:1012,NC,0,1,1)货币资金期末数=ACCT(1001:1012,Y,0,0,0)交易性金融资产年初数=ACCT(1101,NC,0,1,1)交易性金融资产期末数=ACCT(1101,Y,0,0,0)应收账款年初数=ACCT(1122,JC,0,1,1)-ACCT(1231,NC,0,1,1)+ACCT(220 3,JC,0,1,1)应收账款期末数=ACCT(1122,JY,0,0,0)-ACCT(1231,Y,0,0,0)+ACCT(2203H HI!,JY,0

2、,0,0)预付款项年初数=ACCT(1123,JC,0,1,1)+ACCT(2202,JC,0,1,1) 预付款项期末数=ACCT(1123,JY,0,0,0)+ACCT(2202,JY,0,0,0)持有至到期投资年初数=ACCT(1501,NC,0,1,1)-ACCT(1502,NC,0,1,1)持有至到期投资期末数=ACCT(1501,Y,0,0,0)-ACCT(1502,Y,0,0,0)长期应收款年初数=ACCT(1531,NC,0,1,1)-ACCT(1532,NC,0,1,1)长期应收款期末数长期股权投资年初数=ACCT(1511,NC,0,1,1)-ACCT(1512,NC,0,1

3、,1)长期股权投资期末数=ACCT(1511,Y,0,0,0)-ACCT(1512,Y,0,0,0)固定资产年初据=ACCT(1601,NC,0,1,1)-ACCT(1602,NC,0,1,1)-ACCT(16 03,NC,0,1,1)固定资产期末据=ACCT(1601,Y,0,0,0)-ACCT(1602,Y,0,0,0)-ACCT(1603, ,Y,0,0,0)无形资产年初数=ACCT(1701,NC,0,1,1)-ACCT(1702,NC,0,1,1)-ACCT(17 03,NC,0,1,1)无形资产期末数=ACCT(1701,Y,0,0,0)-ACCT(1702,Y,0,0,0)-AC

4、CT(1703, ,Y,0,0,0)应付账款年初数=ACCT(2202,DC,0,1,1)+ACCT(1123,DC,0,1,1)应付账款期末数=ACCT(2202,DY,0,0,0)+ACCT(1123,DY,0,0,0)预收款项年初=ACCT(2203,DC,0,1,1)+ACCT(1122,DC,0,1,1)预收款项期末=ACCT(2203,DY,0,0,0)+ACCT(1122,DY,0,0,0)长期应付款年初数=ACCT(2701,NC,0,1,1)-ACCT(2702,NC,0,1,1)长期应付款期末数=ACCT(2701,Y,0,0,0)-ACCT(2702,Y,0,0,0)所有

5、者权益年初数=SUM(I30:I31)-I32+I33+I34所有者权益期末数=SUM(H30:H31)-H32+H33+H34未分配利润=ACCT(4104,NC,0,1,1)+ACCT(4103,NC,0,1,1)未分配利润期末数=ACCT(4104,y,0,0,0)+ACCT(4103,y,0,0,0)+ACCT(6001 ,y,0,0,0)+ACCT(6051,y,0,0,0)-ACCT(6401,y,0,0,0 )-ACCT(6402,y,0,0,0)-ACCT(6403,y,0,0,0)-ACCT(6601, ,y,0,0,0)-ACCT(6602,y,0,0,0)-ACCT(66

6、03,y,0,0,0) -ACCT(6701,y,0,0,0)+ACCT(6101,y,0,0,0)+ACCT(6111 ,y,0,0,0)+ACCT(6301,y,0,0,0)-ACCT(6711,y,0,0,0 )-ACCT(6801,y,0,0,0)存货年初数=ACCT(1401:1406,NC,0,1,1)-ACCT(1471,NC,0,1,1)+ACC T(5001,NC,0,1,1)+ACCT(1408,NC,0,1,1)+ACCT(1411,财务费用本期=ACCT(6603,SL,0,0,0)存货期末数=ACCT(1401:1406,Y,0,0,0)-ACCT(1471,Y,0,

7、0,0)+ACCT(5001,Y,0,0,0)+ACCT(1408,Y,0,0,0)+ACCT(1411,Y,0,0,0)-ACCT(1407,Y,0,0,0)利润表营业收入上期数=ACCT(6001,SL,-1.0,0,0)+ACCT(6051,SL,-1.0,0,0)营业收入本期数=ACCT(6001,SL,0,0,0)+ACCT(6051,SL,0,0,0)营业成本上期数=ACCT(6401,SL,-1.0,0,0)+ACCT(6402,SL,-1.0,0,0)营业成本本期数=ACCT(6401,SL,0,0,0)+ACCT(6402,SL,0,0,0)营业税金及附加上期数=ACCT(6

8、403,SL,-1.0,0,0)营业税金及附加本期数= =ACCT(6403,SL,0,0,0)销售费用上期=ACCT(6601,SL,-1.0,0,0)销售费用本期=ACCT(6601,SL,0,0,0)管理费用上期数=ACCT(6602,SL,-1.0,0,0)管理费用本期数=ACCT(6602,SL,0,0,0)资产减值损失=ACCT(6701,SL,-1.0,0,0)资产减值损失=ACCT(6701,SL,0,0,0)公允价值变动收益=ACCT(6101,SL,-1.0,0,0)公允价值变动收益=ACCT(6101,SL,0,0,0)投资收益=ACCT(6111,SL,-1.0,0,0)投资收益=ACCT(6111,SL,0,0,0)营业利润=E4-E5-E6-E7-E8-E9-E10+E11+E12营业利润=D4-D5-D6-D7-D8-D9-D10+D11+D12营业外收入=ACCT(6301,SL,-1.0,0,0)营业外收入=ACCT(6301,SL,0,0,0)营业外支