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

1、_金蝶系統(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)金流量：=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目銷售商品、提供勞務(wù)收到的現(xiàn)金|CI1.01.01","JF&quo

2、t;,"",0,0,0,"")|CI1.01.01","JL","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目收到的稅費(fèi)返還|CI1.01.02","JF","",0,0,0,"")|CI1.01.02","JL","",0,0,0,"")=ACCT(&quo

3、t;1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目收到其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金|CI1.01.03","JF","",0,0,0,"")|CI1.01.03","JL","",0,0,0,"")經(jīng)營(yíng)活動(dòng)現(xiàn)金流入小計(jì)=SUM(B3:B5)=SUM(C3:C5)=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目購(gòu)買商品、接受勞務(wù)支付的現(xiàn)金|CI1.02.01

4、","DF","",0,0,0,"")|CI1.02.01","DL","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目支付給職工以及為職工支付的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目支付的各項(xiàng)稅費(fèi)精品資料_=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("100

5、1:1012|現(xiàn)金流量項(xiàng)目|CI1.02.04","DF","",0,0,0,"")-ACCT(|CI1.02.04","DL","",0,0,0,"")-ACCT(支付其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金"1001:1012| 現(xiàn)金流量項(xiàng)目"1001:1012| 現(xiàn)金流量項(xiàng)目|CI1.02.04","JF","",0,0,0,"")|CI1.02.04","

6、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)金流量：=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目收回投資收到的現(xiàn)金|CI2.01.01","JF","RMB",0,0,0,"")|CI2.01.01","JL","RMB",0,0,

7、0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目取得投資收益收到的現(xiàn)金|CI2.01.02","JF","RMB",0,0,0,"")|CI2.01.01","JL","RMB",0,0,0,"")處置固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目收回的現(xiàn)金凈額|CI

8、2.01.03","JF","RMB",0,0,0,"")|CI2.01.03","JL","RMB",0,0,0,"")處置子公司及其他營(yíng)業(yè)單位收到的現(xiàn)金凈=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目額|CI2.01.04","JF","RMB",0,0,0,"")|CI2.01.04","JL&q

9、uot;,"RMB",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目收到其他與投資活動(dòng)有關(guān)的現(xiàn)金投資活動(dòng)現(xiàn)金流入小計(jì)=SUM(B14:B18)=SUM(C14:C18)購(gòu)建固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目支付的現(xiàn)金|CI2.02.01","DF","",0,0,0,"")|CI2.02.01&

10、quot;,"DL","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目投資支付的現(xiàn)金|CI2.02.02","DF","",0,0,0,"")|CI2.02.02","DL","",0,0,0,"")精品資料_取得子公司及其他營(yíng)業(yè)單位支付的現(xiàn)金凈=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT

11、("1001:1012|現(xiàn)金流量項(xiàng)目額|CI2.02.03","DF","",0,0,0,"")|CI2.02.03","DL","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目支付其他與投資活動(dòng)有關(guān)的現(xiàn)金|CI2.02.04","DF","",0,0,0,"")|CI2.02.04&quo

12、t;,"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)金流量：=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目吸收投資收到的現(xiàn)金|CI3.01.01","JF","",0,0,0,"")|CI3.01.01","JL","&quo

13、t;,0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目取得借款收到的現(xiàn)金=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目收到其他與籌資活動(dòng)有關(guān)的現(xiàn)金|CI3.01.03","JF","",0,0,0,"")|CI3.01.03","JL","",0,0,0,"")籌資活動(dòng)現(xiàn)金流入小計(jì)=SUM(

14、B27:B29)=SUM(C27:C29)=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目?jī)斶€債務(wù)支付的現(xiàn)金|CI3.02.01","DF","",0,0,0,"")|CI3.02.01","DL","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目分配股利、利潤(rùn)或償付利息支付的現(xiàn)金|CI3.02.02&qu

15、ot;,"DF","",0,0,0,"")|CI3.02.02","DL","",0,0,0,"")=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目=ACCT("1001:1012|現(xiàn)金流量項(xiàng)目支付其他與籌資活動(dòng)有關(guān)的現(xiàn)金|CI3.02.03","DF","",0,0,0,"")|CI3.02.03","DL","",0,0,0,

16、"")籌資活動(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=ACCT("1001:1012","JC","",0,0,0,"=ACCT("1001:1012","JC","",0,1,0,"加：期初現(xiàn)金及現(xiàn)金等價(jià)物余額&q

17、uot;)")六、期末現(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)金流量：=ACCTCASH("CI1.01.01","S","",=ACCTCASH("CI1.01.01","S","",銷售商品、提供勞務(wù)收到的現(xiàn)金0,1,0,"")0,0,0,"")=ACCT

18、CASH("CI1.01.02","S","",=ACCTCASH("CI1.01.02","S","",收到的稅費(fèi)返還0,1,0,"")0,0,0,"")=ACCTCASH("CI1.01.03","S","",=ACCTCASH("CI1.01.03","S","",收到其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金0,1,0,&quo

19、t;")0,0,0,"")經(jīng)營(yíng)活動(dòng)現(xiàn)金流入小計(jì)=SUM(B3:B5)0=ACCTCASH("CI1.02.01","S","",=ACCTCASH("CI1.02.01","S","",購(gòu)買商品、接受勞務(wù)支付的現(xiàn)金0,1,0,"")0,0,0,"")=ACCTCASH("CI1.02.02","S","",=ACCTCASH("CI1.0

20、2.02","S","",支付給職工以及為職工支付的現(xiàn)金0,1,0,"")0,0,0,"")支付的各項(xiàng)稅費(fèi)=ACCTCASH("CI1.02.03","S","",=ACCTCASH("CI1.02.03","S","",精品資料_0,1,0,"")0,0,0,"")=ACCTCASH("CI1.02.04","S&q

21、uot;,"",=ACCTCASH("CI1.02.04","S","",支付其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金0,1,0,"")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)金流量：=ACCTCASH("CI2.01.01","S","",=ACCTCASH("CI2.01.01","

22、;S","",收回投資收到的現(xiàn)金0,1,0,"")0,0,0,"")=ACCTCASH("CI2.01.02","S","",=ACCTCASH("CI2.01.02","S","",取得投資收益收到的現(xiàn)金0,1,0,"")0,0,0,"")處置固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)收回=ACCTCASH("CI2.01.03","S"

23、;,"",=ACCTCASH("CI2.01.03","S","",的現(xiàn)金凈額0,1,0,"")0,0,0,"")=ACCTCASH("CI2.01.04","S","",=ACCTCASH("CI2.01.04","S","",處置子公司及其他營(yíng)業(yè)單位收到的現(xiàn)金凈額0,1,0,"")0,0,0,"")=ACCTCAS

24、H("CI2.01.05","S","",=ACCTCASH("CI2.01.05","S","",收到其他與投資活動(dòng)有關(guān)的現(xiàn)金0,1,0,"")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)支付=ACCTCASH("CI2.02.01","S","",=ACCTCASH("CI2.02.

25、01","S","",的現(xiàn)金0,1,0,"")0,0,0,"")=ACCTCASH("CI2.02.02","S","",=ACCTCASH("CI2.02.02","S","",投資支付的現(xiàn)金0,1,0,"")0,0,0,"")取得子公司及其他營(yíng)業(yè)單位支付的現(xiàn)金凈額=ACCTCASH("CI2.02.03","S&q

26、uot;,"",=ACCTCASH("CI2.02.03","S","",精品資料_0,1,0,"")0,0,0,"")=ACCTCASH("CI2.02.04","S","",=ACCTCASH("CI2.02.04","S","",支付其他與投資活動(dòng)有關(guān)的現(xiàn)金0,1,0,"")0,0,0,"")投資活動(dòng)現(xiàn)金流出小計(jì)

27、=SUM(B20:B23)=SUM(C20:C23)投資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~=B19-B24=C19-C24三、籌資活動(dòng)產(chǎn)生的現(xiàn)金流量：=ACCTCASH("CI3.01.01","S","",=ACCTCASH("CI3.01.01","S","",吸收投資收到的現(xiàn)金0,1,0,"")0,0,0,"")=ACCTCASH("CI3.01.02","S","",=ACCTCASH("CI3.01.02","S","",取得借款收到的現(xiàn)金0,1,0,"")0,0,0,"")=ACCTCASH("CI3.01.03","S","",=ACCTCASH("CI3.01.03","S","",收到其他與籌資活動(dòng)有關(guān)的現(xiàn)金0,1,0,"")0,0,