金蝶系統(tǒng)生成現(xiàn)金流量表的兩種方式

金蝶系統(tǒng)生成現(xiàn)金流量表的兩種方式金蝶系統(tǒng)生成現(xiàn)金流量表的兩種方式金蝶系統(tǒng)生成現(xiàn)金流量表的兩種方式資料僅供參考文件編號(hào)：2022年4月金蝶系統(tǒng)生成現(xiàn)金流量表的兩種方式版本號(hào)：A修改號(hào)：1頁(yè)次：1.0審核：批準(zhǔn):發(fā)布日期：金蝶系統(tǒng)中生成現(xiàn)金流量表的兩種設(shè)置方式作為一個(gè)資深老會(huì)計(jì),深知財(cái)務(wù)三大報(bào)表做的重要性，但其中以現(xiàn)金流量表的編制難度最大，手工編制現(xiàn)金流量表10個(gè)人會(huì)有10個(gè)不同的結(jié)果，所以如何利用系統(tǒng)來(lái)自動(dòng)生成現(xiàn)金流量表就很關(guān)鍵了.第一種：在建現(xiàn)金科目的時(shí)候，此科目選擇現(xiàn)金流量項(xiàng)目來(lái)核算，在填制憑證的時(shí)候必須錄入現(xiàn)金流量項(xiàng)目，憑證才能保存現(xiàn)金流量表的公式如下：項(xiàng)目本期金額累計(jì)金額一、經(jīng)營(yíng)活動(dòng)產(chǎn)生的現(xiàn)金流量：銷售商品、提供勞務(wù)收到的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","",0,0,0,"")收到的稅費(fèi)返還=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","",0,0,0,"")收到其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","",0,0,0,"")經(jīng)營(yíng)活動(dòng)現(xiàn)金流入小計(jì)=SUM(B3:B5)=SUM(C3:C5)購(gòu)買商品、接受勞務(wù)支付的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")支付給職工以及為職工支付的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")支付的各項(xiàng)稅費(fèi)=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")支付其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")-ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")-ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","",0,0,0,"")經(jīng)營(yíng)活動(dòng)現(xiàn)金流出小計(jì)=SUM(B7:B10)=SUM(C7:C10)經(jīng)營(yíng)活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~=B6-B11=C6-C11二、投資活動(dòng)產(chǎn)生的現(xiàn)金流量：收回投資收到的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","RMB",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","RMB",0,0,0,"")取得投資收益收到的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","RMB",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","RMB",0,0,0,"")處置固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)收回的現(xiàn)金凈額=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","RMB",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","RMB",0,0,0,"")處置子公司及其他營(yíng)業(yè)單位收到的現(xiàn)金凈額=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","RMB",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","RMB",0,0,0,"")收到其他與投資活動(dòng)有關(guān)的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","RMB",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","RMB",0,0,0,"")投資活動(dòng)現(xiàn)金流入小計(jì)=SUM(B14:B18)=SUM(C14:C18)購(gòu)建固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)支付的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")投資支付的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")取得子公司及其他營(yíng)業(yè)單位支付的現(xiàn)金凈額=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")支付其他與投資活動(dòng)有關(guān)的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")投資活動(dòng)現(xiàn)金流出小計(jì)=SUM(B20:B23)=SUM(C20:C23)投資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~=B19-B24=C19-C24三、籌資活動(dòng)產(chǎn)生的現(xiàn)金流量：吸收投資收到的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","",0,0,0,"")取得借款收到的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","",0,0,0,"")收到其他與籌資活動(dòng)有關(guān)的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","JL","",0,0,0,"")籌資活動(dòng)現(xiàn)金流入小計(jì)=SUM(B27:B29)=SUM(C27:C29)償還債務(wù)支付的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")分配股利、利潤(rùn)或償付利息支付的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")支付其他與籌資活動(dòng)有關(guān)的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DF","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目|","DL","",0,0,0,"")籌資活動(dòng)現(xiàn)金流出小計(jì)=SUM(B31:B33)=SUM(C31:C33)籌資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~=B30-B34=C30-C34四、匯率變動(dòng)對(duì)現(xiàn)金及現(xiàn)金等價(jià)物的影響五、現(xiàn)金及現(xiàn)金等價(jià)物凈增加額=B12+B25+B35+B36+=C12+C25+C35+C36加：期初現(xiàn)金及現(xiàn)金等價(jià)物余額=ACCT("1001:1012","JC","",0,0,0,"")=ACCT("1001:1012","JC","",0,1,0,"")六、期末現(xiàn)金及現(xiàn)金等價(jià)物余額=B37+B38=C37+C38第二種：不通過(guò)現(xiàn)金流量項(xiàng)目核算來(lái)生成現(xiàn)金流量表，用指定現(xiàn)金流量項(xiàng)目的方法來(lái)出表，適用于現(xiàn)金科目未設(shè)置核算項(xiàng)目的憑證。項(xiàng)目本年累計(jì)本月金額一、經(jīng)營(yíng)活動(dòng)產(chǎn)生的現(xiàn)金流量：銷售商品、提供勞務(wù)收到的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")收到的稅費(fèi)返還=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")收到其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")經(jīng)營(yíng)活動(dòng)現(xiàn)金流入小計(jì)=SUM(B3:B5)0購(gòu)買商品、接受勞務(wù)支付的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")支付給職工以及為職工支付的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")支付的各項(xiàng)稅費(fèi)=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")支付其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")經(jīng)營(yíng)活動(dòng)現(xiàn)金流出小計(jì)=SUM(B7:B10)=SUM(C7:C10)經(jīng)營(yíng)活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~=B6-B11=C6-C11二、投資活動(dòng)產(chǎn)生的現(xiàn)金流量：收回投資收到的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")取得投資收益收到的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")處置固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)收回的現(xiàn)金凈額=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")處置子公司及其他營(yíng)業(yè)單位收到的現(xiàn)金凈額=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")收到其他與投資活動(dòng)有關(guān)的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")投資活動(dòng)現(xiàn)金流入小計(jì)=SUM(B14:B18)=SUM(C14:C18)購(gòu)建固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)支付的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")投資支付的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")取得子公司及其他營(yíng)業(yè)單位支付的現(xiàn)金凈額=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")支付其他與投資活動(dòng)有關(guān)的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")投資活動(dòng)現(xiàn)金流出小計(jì)=SUM(B20:B23)=SUM(C20:C23)投資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~=B19-B24=C19-C24三、籌資活動(dòng)產(chǎn)生的現(xiàn)金流量：吸收投資收到的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")取得借款收到的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")收到其他與籌資活動(dòng)有關(guān)的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")籌資活動(dòng)現(xiàn)金流入小計(jì)=SUM(B27:B29)=SUM(C27:C29)償還債務(wù)支付的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")分配股利、利潤(rùn)或償付利息支付的現(xiàn)金=ACCTCASH("","S","",0,1,0,"")=ACCTCASH("","S","",0,0,0,"")支付其他與籌資活動(dòng)有關(guān)的現(xiàn)金=ACCTCASH("","S","",0,1