金蝶K3现金流量表公式

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