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

资产负债表： 货币资金年初数=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,,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(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,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)-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,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+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(6603,,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)+ACCT(5001,,NC,,0,1,1)+ACCT(1408,,NC,,0,1,1)+ACCT(1411,,NC,,0,1,1)-ACCT(1407,,NC,,0,1,1) 存货期末数＝=ACCT(1401:1406,,Y,,0,0,0)-ACCT(1471,,Y,,0,0,0)+ACCT(5001,,Y,,0,0,0)+ACCT