金蝶软件报表公式定义.doc

《金蝶软件报表公式定义.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、资产负债表：货币资金年初数=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("2203","","JC","",0,1,1)应收账款期末数=ACCT("1122","","JY

2、","",0,0,0)-ACCT("1231","","Y","",0,0,0)+ACCT("2203","","JY","",0,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("

3、1501","","Y","",0,0,0)-ACCT("1502","","Y","",0,0,0)长期应收款年初数=ACCT("1531","","NC","",0,1,1)-ACCT("1532","","NC","",0,1,1)长期应收款期末数=ACCT("1531","","Y","",0,0,0)-ACCT("1532","","Y","",0,0,0)长期股权投资年初数=ACCT("1511","","NC","",0,1,1)-ACCT("1512","","NC","",0,1,1)长期股权投资期末数==ACCT("1511","","Y","",0,0,

4、0)-ACCT("1512","","Y","",0,0,0)固定资产年初据=ACCT("1601","","NC","",0,1,1)-ACCT("1602","","NC","",0,1,1)-ACCT("1603","","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)-

5、ACCT("1703","","NC","",0,1,1) 无形资产期末数=ACCT("1701","","Y","",0,0,0)-ACCT("1702","","Y","",0,0,0)-ACCT("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

6、,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)所有者权益年初数=SUM(I30:I31)-I32+I33+I34所有者权益期末数=SUM(H30:H31)-H32

7、+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