金蝶系统生成现金流量表的两种方式_第1页
金蝶系统生成现金流量表的两种方式_第2页
金蝶系统生成现金流量表的两种方式_第3页
金蝶系统生成现金流量表的两种方式_第4页
已阅读5页，还剩3页未读， 继续免费阅读

下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

1、_金蝶系统中生成现金流量表的两种设置方式作为一个资深老会计,深知财务三大报表做的重要性，但其中以现金流量表的编制难度最大，手工编制现金流量表10 个人会有 10个不同的结果，所以如何利用系统来自动生成现金流量表就很关键了.第一种 ：在建现金科目的时候，此科目选择现金流量项目来核算，在填制凭证的时候必须录入现金流量项目，凭证才能保存现金流量表的公式如下：项目本期金额累计金额一、经营活动产生的现金流量：=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目销售商品、提供劳务收到的现金|CI1.01.01","JF&quo

2、t;,"",0,0,0,"")|CI1.01.01","JL","",0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目收到的税费返还|CI1.01.02","JF","",0,0,0,"")|CI1.01.02","JL","",0,0,0,"")=ACCT(&quo

3、t;1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目收到其他与经营活动有关的现金|CI1.01.03","JF","",0,0,0,"")|CI1.01.03","JL","",0,0,0,"")经营活动现金流入小计=SUM(B3:B5)=SUM(C3:C5)=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目购买商品、接受劳务支付的现金|CI1.02.01

4、","DF","",0,0,0,"")|CI1.02.01","DL","",0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目支付给职工以及为职工支付的现金=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目支付的各项税费精品资料_=ACCT("1001:1012|现金流量项目=ACCT("100

5、1:1012|现金流量项目|CI1.02.04","DF","",0,0,0,"")-ACCT(|CI1.02.04","DL","",0,0,0,"")-ACCT(支付其他与经营活动有关的现金"1001:1012| 现金流量项目"1001:1012| 现金流量项目|CI1.02.04","JF","",0,0,0,"")|CI1.02.04","

6、JL","",0,0,0,"")经营活动现金流出小计=SUM(B7:B10)=SUM(C7:C10)经营活动产生的现金流量净额=B6-B11=C6-C11二、投资活动产生的现金流量：=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目收回投资收到的现金|CI2.01.01","JF","RMB",0,0,0,"")|CI2.01.01","JL","RMB",0,0,

7、0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目取得投资收益收到的现金|CI2.01.02","JF","RMB",0,0,0,"")|CI2.01.01","JL","RMB",0,0,0,"")处置固定资产、无形资产和其他长期资产=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目收回的现金净额|CI

8、2.01.03","JF","RMB",0,0,0,"")|CI2.01.03","JL","RMB",0,0,0,"")处置子公司及其他营业单位收到的现金净=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目额|CI2.01.04","JF","RMB",0,0,0,"")|CI2.01.04","JL&q

9、uot;,"RMB",0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目收到其他与投资活动有关的现金投资活动现金流入小计=SUM(B14:B18)=SUM(C14:C18)购建固定资产、无形资产和其他长期资产=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目支付的现金|CI2.02.01","DF","",0,0,0,"")|CI2.02.01&

10、quot;,"DL","",0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目投资支付的现金|CI2.02.02","DF","",0,0,0,"")|CI2.02.02","DL","",0,0,0,"")精品资料_取得子公司及其他营业单位支付的现金净=ACCT("1001:1012|现金流量项目=ACCT

11、("1001:1012|现金流量项目额|CI2.02.03","DF","",0,0,0,"")|CI2.02.03","DL","",0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目支付其他与投资活动有关的现金|CI2.02.04","DF","",0,0,0,"")|CI2.02.04&quo

12、t;,"DL","",0,0,0,"")投资活动现金流出小计=SUM(B20:B23)=SUM(C20:C23)投资活动产生的现金流量净额=B19-B24=C19-C24三、筹资活动产生的现金流量：=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目吸收投资收到的现金|CI3.01.01","JF","",0,0,0,"")|CI3.01.01","JL","&quo

13、t;,0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目取得借款收到的现金=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目收到其他与筹资活动有关的现金|CI3.01.03","JF","",0,0,0,"")|CI3.01.03","JL","",0,0,0,"")筹资活动现金流入小计=SUM(

14、B27:B29)=SUM(C27:C29)=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目偿还债务支付的现金|CI3.02.01","DF","",0,0,0,"")|CI3.02.01","DL","",0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目分配股利、利润或偿付利息支付的现金|CI3.02.02&qu

15、ot;,"DF","",0,0,0,"")|CI3.02.02","DL","",0,0,0,"")=ACCT("1001:1012|现金流量项目=ACCT("1001:1012|现金流量项目支付其他与筹资活动有关的现金|CI3.02.03","DF","",0,0,0,"")|CI3.02.03","DL","",0,0,0,

16、"")筹资活动现金流出小计=SUM(B31:B33)=SUM(C31:C33)筹资活动产生的现金流量净额=B30-B34=C30-C34精品资料_四、汇率变动对现金及现金等价物的影响五、现金及现金等价物净增加额=B12+B25+B35+B36+=C12+C25+C35+C36=ACCT("1001:1012","JC","",0,0,0,"=ACCT("1001:1012","JC","",0,1,0,"加：期初现金及现金等价物余额&q

17、uot;)")六、期末现金及现金等价物余额=B37+B38=C37+C38第二种： 不通过现金流量项目核算来生成现金流量表，用指定现金流量项目的方法来出表，适用于现金科目未设置核算项目的凭证。项目本年累计本月金额一、经营活动产生的现金流量：=ACCTCASH("CI1.01.01","S","",=ACCTCASH("CI1.01.01","S","",销售商品、提供劳务收到的现金0,1,0,"")0,0,0,"")=ACCT

18、CASH("CI1.01.02","S","",=ACCTCASH("CI1.01.02","S","",收到的税费返还0,1,0,"")0,0,0,"")=ACCTCASH("CI1.01.03","S","",=ACCTCASH("CI1.01.03","S","",收到其他与经营活动有关的现金0,1,0,&quo

19、t;")0,0,0,"")经营活动现金流入小计=SUM(B3:B5)0=ACCTCASH("CI1.02.01","S","",=ACCTCASH("CI1.02.01","S","",购买商品、接受劳务支付的现金0,1,0,"")0,0,0,"")=ACCTCASH("CI1.02.02","S","",=ACCTCASH("CI1.0

20、2.02","S","",支付给职工以及为职工支付的现金0,1,0,"")0,0,0,"")支付的各项税费=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","",支付其他与经营活动有关的现金0,1,0,"")0,0,0,"")经营活动现金流出小计=SUM(B7:B10)=SUM(C7:C10)经营活动产生的现金流量净额=B6-B11=C6-C11二、投资活动产生的现金流量：=ACCTCASH("CI2.01.01","S","",=ACCTCASH("CI2.01.01","

22、;S","",收回投资收到的现金0,1,0,"")0,0,0,"")=ACCTCASH("CI2.01.02","S","",=ACCTCASH("CI2.01.02","S","",取得投资收益收到的现金0,1,0,"")0,0,0,"")处置固定资产、无形资产和其他长期资产收回=ACCTCASH("CI2.01.03","S"

23、;,"",=ACCTCASH("CI2.01.03","S","",的现金净额0,1,0,"")0,0,0,"")=ACCTCASH("CI2.01.04","S","",=ACCTCASH("CI2.01.04","S","",处置子公司及其他营业单位收到的现金净额0,1,0,"")0,0,0,"")=ACCTCAS

24、H("CI2.01.05","S","",=ACCTCASH("CI2.01.05","S","",收到其他与投资活动有关的现金0,1,0,"")0,0,0,"")投资活动现金流入小计=SUM(B14:B18)=SUM(C14:C18)购建固定资产、无形资产和其他长期资产支付=ACCTCASH("CI2.02.01","S","",=ACCTCASH("CI2.02.

25、01","S","",的现金0,1,0,"")0,0,0,"")=ACCTCASH("CI2.02.02","S","",=ACCTCASH("CI2.02.02","S","",投资支付的现金0,1,0,"")0,0,0,"")取得子公司及其他营业单位支付的现金净额=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","",支付其他与投资活动有关的现金0,1,0,"")0,0,0,"")投资活动现金流出小计

27、=SUM(B20:B23)=SUM(C20:C23)投资活动产生的现金流量净额=B19-B24=C19-C24三、筹资活动产生的现金流量：=ACCTCASH("CI3.01.01","S","",=ACCTCASH("CI3.01.01","S","",吸收投资收到的现金0,1,0,"")0,0,0,"")=ACCTCASH("CI3.01.02","S","",=ACCTCASH("CI3.01.02","S","",取得借款收到的现金0,1,0,"")0,0,0,"")=ACCTCASH("CI3.01.03","S","",=ACCTCASH("CI3.01.03","S","",收到其他与筹资活动有关的现金0,1,0,"")0,0,

人人文库> 全部分类> 行业资料 > 信息产业

温馨提示

  • 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

最新文档

评论

0/150

提交评论