金蝶K3现金流量表公式

项目本期金额一、经营活动产生的现金流量：销售商品、提供劳务收到的现金=ACCTCASH(CI1.01.01,S,,0,0,0,)收到的税费返还=ACCTCASH(CI1.01.02,S,,0,0,0,)收到其他与经营活动有关的现金=ACCTCASH(CI1.01.03,S,,0,0,0,)经营活动现金流入小计=SUM(B3:B5)购买商品、接受劳务支付的现金=ACCTCASH(CI1.02.01,S,,0,0,0,)支付给职工以及为职工支付的现金=ACCTCASH(CI1.02.02,S,,0,0,0,)支付的各项税费=ACCTCASH(CI1.02.03,S,,0,0,0,)支付其他与经营活动有关的现金=ACCTCASH(CI1.02.04,S,,0,0,0,)经营活动现金流出小计=SUM(B7:B10)经营活动产生的现金流量净额=B6-B11二、投资活动产生的现金流量：收回投资收到的现金=ACCTCASH(CI2.01.01,S,,0,0,0,)取得投资收益收到的现金=ACCTCASH(CI2.01.02,S,,0,0,0,)处置固定资产、无形资产和其他长期资产收回的现金净额=ACCTCASH(CI2.01.03,S,,0,0,0,)处置子公司及其他营业单位收到的现金净额=ACCTCASH(CI2.01.04,S,,0,0,0,)收到其他与投资活动有关的现金=ACCTCASH(CI2.01.05,S,,0,0,0,)投资活动现金流入小计=SUM(B14:B18)购建固定资产、无形资产和其他长期资产支付的现金=ACCTCASH(CI2.02.01,S,,0,0,0,)投资支付的现金=ACCTCASH(CI2.02.02,S,,0,0,0,)取得子公司及其他营业单位支付的现金净额=ACCTCASH(CI2.02.03,S,,0,0,0,)支付其他与投资活动有关的现金=ACCTCASH(CI2.02.04,S,,0,0,0,)投资活动现金流出小计=SUM(B20:B23)投资活动产生的现金流量净额=B19-B24三、筹资活动产生的现金流量：吸收投资收到的现金=ACCTCASH(CI3.01.01,S,,0,0,0,)取得借款收到的现金=ACCTCASH(CI3.01.02,S,,0,0,0,)收到其他与筹资活动有关的现金=ACCTCASH(CI3.01.03,S,,0,0,0,)筹资活动现金流入小计=SUM(B27:B29)偿还债务支付的现金=ACCTCASH(CI3.02.01,S,,0,0,0,)分配股利、利润或偿付利息支付的现金=ACCTCASH(CI3.02.02,S,,0,0,0,)支付其他与筹资活动有关的现金=ACCTCASH(CI3.02.03,S,,0,0,0,)筹资活动现金流出小计=SUM(B31:B33)筹资活动产生的现金流量净额=B30-B34四、汇率变动对现金及现金等价物的影响=ACCTCASH(CI4.01,S,,0,0,0,)-ACCTCASH(CI4.02,S,,0,0,0,)五、现金及现金等价物净增加额=B12+B25+B35+B36加：期初现金及现金等价物余额=ACCT(1001:1002,C,,0,0,0,)六、期末现金及现金等价物余额=B37+B38上期金额本年累计=ACCTCASH(CI1.01.01,S,,0,-1,-1,)=ACCTCASH(CI1.01.01,S,,0,1,0,)=ACCTCASH(CI1.01.02,S,,0,-1,-1,)=ACCTCASH(CI1.01.02,S,,0,1,0,)=ACCTCASH(CI1.01.03,S,,0,-1,-1,)=ACCTCASH(CI1.01.03,S,,0,1,0,)=SUM(C3:C5)=SUM(D3:D5)=ACCTCASH(CI1.02.01,S,,0,-1,-1,)=ACCTCASH(CI1.02.01,S,,0,1,0,)=ACCTCASH(CI1.02.02,S,,0,-1,-1,)=ACCTCASH(CI1.02.02,S,,0,1,0,)=ACCTCASH(CI1.02.03,S,,0,-1,-1,)=ACCTCASH(CI1.02.03,S,,0,1,0,)=ACCTCASH(CI1.02.04,S,,0,-1,-1,)=ACCTCASH(CI1.02.04,S,,0,1,0,)=SUM(C7:C10)=SUM(D7:D10)=C6-C11=D6-D11=ACCTCASH(CI2.01.01,S,,0,-1,-1,)=ACCTCASH(CI2.01.01,S,,0,1,0,)=ACCTCASH(CI2.01.02,S,,0,-1,-1,)=ACCTCASH(CI2.01.02,S,,0,1,0,)=ACCTCASH(CI2.01.03,S,,0,-1,-1,)=ACCTCASH(CI2.01.03,S,,0,1,0,)=ACCTCASH(CI2.01.04,S,,0,-1,-1,)=ACCTCASH(CI2.01.04,S,,0,1,0,)=ACCTCASH(CI2.01.05,S,,0,-1,-1,)=ACCTCASH(CI2.01.05,S,,0,1,0,)=SUM(C14:C18)=SUM(D14:D18)=ACCTCASH(CI2.02.01,S,,0,-1,-1,)=ACCTCASH(CI2.02.01,S,,0,1,0,)=ACCTCASH(CI2.02.02,S,,0,-1,-1,)=ACCTCASH(CI2.02.02,S,,0,1,0,)=ACCTCASH(CI2.02.03,S,,0,-1,-1,)=ACCTCASH(CI2.02.03,S,,0,1,0,)=ACCTCASH(CI2.02.04,S,,0,-1,-1,)=ACCTCASH(CI2.02.04,S,,0,1,0,)=SUM(C20:C23)=SUM(D20:D23)=C19-C24=D19-D24=ACCTCASH(CI3.01.01,S,,0,-1,-1,)=ACCTCASH(CI3.01.01,S,,0,1,0,)=ACCTCASH(CI3.01.02,S,,0,-1,-1,)=ACCTCASH(CI3.01.02,S,,0,1,0,)=ACCTCASH(CI3.01.03,S,,0,-1,-1,)=ACCTCASH(CI3.01.03,S,,0,1,0,)=SUM(C27:C29)=SUM(D27:D29)=ACCTCASH(CI3.02.01,S,,0,-1,-1,)=ACCTCASH(CI3.02.01,S,,0,1,0,)=ACCTCASH(CI3.02.02,S,,0,-1,-1,)=ACCTCASH(CI3.02.02,S,,0,1,0,)=ACCTCASH(CI3.02.03,S,,0,-1,-1,)=ACCTCASH(CI3.02.03,S,,0,1,0,)=SUM(C31:C33)=SUM(D31:D33)=C30-C34=D30-D34=ACCTCASH(CI4.01,S,,0,-1,-1,)-ACCTCASH(CI4.02,S,,0,-1,-1,)=ACCTCASH(CI4.01,S,,0,-1,-1,)-ACCTCASH(CI4.02,S,,0,1,0,)=C12+C25+C35+C36=D12+D25+D35+D36=ACCT(1001:1002,C,,0,-1,-1,)=ACCT(1001:1002,C,,0,1,1,)=C37+C38=D37+D38=ACCTCASH(CI4.01,S,,0,-1,-1,)-ACCTCASH(CI4.02,S,,0,1,0,)