金蝶软件报表公式定义

金蝶软件报公式定义 资产负债表： 货币资金年初数=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("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("6403","","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("6603","","SL","",-1.0,0,0) 财务费用本期=ACCT("6603","","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) 营业外支出=ACCT("6711","","SL","",-1.0,0,0) 营业外支出=ACCT("6711","","SL","",0,0,0) 利润总额=E14+E15-E16 利润总额=D14+D15-D16 所得税费用=ACCT("6801","","SL","",-1.0,0,0) 所得税费用=ACCT("6801","","SL","",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("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("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("6403","","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("6603","","SL","",-1.0,0,0) 财务费用本期=ACCT("6603","","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) 营业外支出=ACCT("6711","","SL","",-1.0,0,0) 营业外支出=ACCT("6711","","SL","",0,0,0) 利润总额=E14+E15-E16 利润总额=D14+D15-D16 所得税费用=ACCT("6801","","SL","",-1.0,0,0) 所得税费用=ACCT("6801","","SL","",0,0,0)