首页 > 专利学习

2021年金蝶系统生成现金流量表的两种方式

金蝶系统中生成现金流量表的两种设置方法
欧阳光明（2021.03.07）
作为一个资深老会计,深知财务三年夜报表做的重要性，但其中以现金流量表的编制难度最年夜，手工编制现金流量表10个人会有10个不合的结果，所以如何利用系统来自动生成现金流量表就很关键了.
第一种：在建现金科目的时候，此科目选择现金流量项目来核算，在填制凭证的时候必须录入现金流量项目，凭证才干保管
现金流量表的公式如下：
半导体除湿
项    目
本期金额
累计金额
一、经营活动产生的现金流量：
    销售商品、提供劳务收到的现金
=ACCT("1001:1012|现金流量项目|CI1.01.01","JF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI1.01.01","JL","",0,0,0,"")
    收到的税费返还
=ACCT("1001:1012|现金流量项目|CI1.01.02","JF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI1.01.02","JL","",0,0,0,"")
    收到其他与经营活动有关的现金
=ACCT("1001:1012|现金流量项目|CI1.01.03","JF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI1.01.03","JL","",0,0,0,"")
经营活动现金流入小计
=SUM(B3:B5)
=SUM(C3:C5)
    购买商品、接受劳务支付的现金
=ACCT("1001:1012|现金流量项目|CI1.02.01","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI1.02.01","DL","",0,0,0,"")
    支付给职工以及为职工支付的现金
=ACCT("1001:1012|现金流量项目|CI1.02.02","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI1.02.02","DL","",0,0,0,"")
    支付的各项税费
=ACCT("1001:1012|现金流量项目|CI1.02.03","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI1.02.03","DL","",0,0,0,"")
    支付其他与经营活动有关的现金
=ACCT("1001:1012|现金流量项目|CI1.02.04","DF","",0,0,0,"")ACCT("1001:1012|现金流量项目|CI1.02.04","JF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI1.02.04","DL","",0,0,0,"")ACCT("1001:1012|现金流量项目|CI1.02.04","JL","",0,0,0,"")
经营活动现金流出小计
=SUM(B7:B10)
=SUM(C7:C10)
经营活动产生的现金流量净额
=B6B11
=C6C11
二、投资活动产生的现金流量：
    收回投资收到的现金
=ACCT("1001:1012|现金流量项目|CI2.01.01","JF","RMB",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.01.01","JL","RMB",0,0,0,"")
    取得投资收益收到的现金
=ACCT("1001:1012|现金流量项目|CI2.01.02","JF","RMB",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.01.01","JL","RMB",0,0,0,"")
    处理固定资产、无形资产和其他长期资产收回的现金净额
=ACCT("1001:1012|现金流量项目|CI2.01.03","JF","RMB",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.01.03","JL","RMB",0,0,0,"")
    处理子公司及其他营业单位收到的现金净额
=ACCT("1001:1012|现金流量项目|CI2.01.04","JF","RMB",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.01.04","JL","RMB",0,0,0,"")
    收到其他与投资活动有关的现金
=ACCT("1001:1012|现金流量项目|CI2.01.05","JF","RMB",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.01.05","JL","RMB",0,0,0,"")
投资活动现金流入小计
=SUM(B14:B18)
=SUM(C14:C18)
    购建固定资产、无形资产和其他长期资产支付的现金
=ACCT("1001:1012|现金流量项目|CI2.02.01","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.02.01","DL","",0,0,0,"")
简易过滤器金融查询
    投资支付的现金
=ACCT("1001:1012|现金流量项目|CI2.02.02","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.02.02","DL","",0,0,0,"")
    取得子公司及其他营业单位支付的现金净额
=ACCT("1001:1012|现金流量项目|CI2.02.03","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.02.03","DL","",0,0,0,"")
    支付其他与投资活动有关的现金
=ACCT("1001:1012|现金流量项目|CI2.02.04","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI2.02.04","DL","",0,0,0,"")
投资活动现金流出小计
=SUM(B20:B23)
=SUM(C20:C23)
投资活动产生的现金流量净额
=B19B24
=C19C24
三、筹资活动产生的现金流量：
    吸收投资收到的现金
=ACCT("1001:1012|现金流量项目|CI3.01.01","JF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI3.01.01","JL","",0,0,0,"")
    取得借款收到的现金
=ACCT("1001:1012|现金流量项目|CI3.01.02","JF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI3.01.02","JL","",0,0,0,"")
    收到其他与筹资活动有关的现金
=ACCT("1001:1012|现金流量项目|CI3.01.03","JF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI3.01.03","JL","",0,0,0,"")
筹资活动现金流入小计
=SUM(B27:B29)
=SUM(C27:C29)
    归还债务支付的现金
=ACCT("1001:1012|现金流量项目|CI3.02.01","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI3.02.01","DL","",0,0,0,"")
    分派股利、利润或偿付利息支付的现金
=ACCT("1001:1012|现金流量项目|CI3.02.02","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI3.02.02","DL","",0,0,0,"")
    支付其他与筹资活动有关的现金
=ACCT("1001:1012|现金流量项目|CI3.02.03","DF","",0,0,0,"")
=ACCT("1001:1012|现金流量项目|CI3.02.03","DL","",0,0,0,"")
筹资活动现金流出小计
=SUM(B31:B33)
=SUM(C31:C33)
筹资活动产生的现金流量净额
=B30B34
=C30C34
四、汇率变动对现金及现金等价物的影响
五、现金及现金等价物净增加额
=B12+B25+B35+B36+
=C12+C25+C35+C36
加：期初现金及现金等价物余额
=ACCT("1001:1012","JC","",0,0,0,"")
=ACCT("1001:1012","JC","",0,1,0,"")
六、期末现金及现金等价物余额
=B37+B38
=C37+C38
第二种：欠亨过现金流量项目核算来生成现金流量表，用指定现金流量项目的办法来出表，适用于现金科目未设置核算项目的凭证。
项    目
今年累计
本月金额
一、经营活动产生的现金流量：
    销售商品、提供劳务收到的现金
=ACCTCASH("CI1.01.01","S","",0,1,0,"")
=ACCTCASH("CI1.01.01","S","",0,0,0,"")
    收到的税费返还
=ACCTCASH("CI1.01.02","S","",0,1,0,"")
=ACCTCASH("CI1.01.02","S","",0,0,0,"")
    收到其他与经营活动有关的现金
=ACCTCASH("CI1.01.03","S","",0,1,0,"")
=ACCTCASH("CI1.01.03","S","",0,0,0,"")
经营活动现金流入小计
=SUM(B3:B5)
0
    购买商品、接受劳务支付的现金
=ACCTCASH("CI1.02.01","S","",0,1,0,"")
=ACCTCASH("CI1.02.01","S","",0,0,0,"")
    支付给职工以及为职工支付的现金
=ACCTCASH("CI1.02.02","S","",0,1,0,"")
=ACCTCASH("CI1.02.02","S","",0,0,0,"")
    支付的各项税费
=ACCTCASH("CI1.02.03","S","",0,1,0,"")
=ACCTCASH("CI1.02.03","S","",0,0,0,"")
    支付其他与经营活动有关的现金
=ACCTCASH("CI1.02.04","S","",0,1,0,"")
=ACCTCASH("CI1.02.04","S","",0,0,0,"")
经营活动现金流出小计
=SUM(B7:B10)
5b5b5b5b
=SUM(C7:C10)
经营活动产生的现金流量净额
=B6B11
=C6C11
二、投资活动产生的现金流量：
    收回投资收到的现金
=ACCTCASH("CI2.01.01","S","",0,1,0,"")
=ACCTCASH("CI2.01.01","S","",0,0,0,"")
    取得投资收益收到的现金
=ACCTCASH("CI2.01.02","S","",0,1,0,"")
=ACCTCASH("CI2.01.02","S","",0,0,0,"")
    处理固定资产、无形资产和其他长期资产收回的现金净额
=ACCTCASH("CI2.01.03","S","",0,1,0,"")
静压实验=ACCTCASH("CI2.01.03","S","",0,0,0,"")
    处理子公司及其他营业单位收到的现金净额
=ACCTCASH("CI2.01.04","S","",0,1,0,"")
=ACCTCASH("CI2.01.04","S","",0,0,0,"")
    收到其他与投资活动有关的现金
=ACCTCASH("CI2.01.05","S","",0,1,0,"")
=ACCTCASH("CI2.01.05","S","",0,0,0,"")
投资活动现金流入小计
=SUM(B14:B18)
=SUM(C14:C18)
    购建固定资产、无形资产和其他长期资产支付的现金
=ACCTCASH("CI2.02.01","S","",0,1,0,"")
=ACCTCASH("CI2.02.01","S","",0,0,0,"")
    投资支付的现金
=ACCTCASH("CI2.02.02","S","",0,1,0,"")
=ACCTCASH("CI2.02.02","S","",0,0,0,"")
    取得子公司及其他营业单位支付的现金净额
=ACCTCASH("CI2.02.03","S","",0,1,0,"")
=ACCTCASH("CI2.02.03","S","",0,0,0,"")
    支付其他与投资活动有关的现金
=ACCTCASH("CI2.02.04","S","",0,1,0,"")
=ACCTCASH("CI2.02.04","S","",0,0,0,"")
投资活动现金流出小计
=SUM(B20:B23)
=SUM(C20:C23)
投资活动产生的现金流量净额
=B19B24
=C19C24
三、筹资活动产生的现金流量：
    吸收投资收到的现金
=ACCTCASH("CI3.01.01","S","",0,1,0,"")
汤杯
=ACCTCASH("CI3.01.01","S","",0,0,0,"")
    取得借款收到的现金
=ACCTCASH("CI3.01.02","S","",0,1,0,"")
=ACCTCASH("CI3.01.02","S","",0,0,0,"")
    收到其他与筹资活动有关的现金
=ACCTCASH("CI3.01.03","S","",0,1,0,"")
=ACCTCASH("CI3.01.03","S","",0,0,0,"")
筹资活动现金流入小计
=SUM(B27:B29)
=SUM(C27:C29)
    归还债务支付的现金
=ACCTCASH("CI3.02.01","S","",0,1,0,"")
=ACCTCASH("CI3.02.01","S","",0,0,0,"")
    分派股利、利润或偿付利息支付的现金
=ACCTCASH("CI3.02.02","S","",0,1,0,"")
=ACCTCASH("CI3.02.02","S","",0,0,0,"")
    支付其他与筹资活动有关的现金
=ACCTCASH("CI3.02.03","S","",0,1,0,"")
=ACCTCASH("CI3.02.03","S","",0,0,0,"")
筹资活动现金流出小计
=SUM(B31:B33)
=SUM(C31:C33)
筹资活动产生的现金流量净额
=B30B34
=C30C34
四、汇率变动对现金及现金等价物的影响
五、现金及现金等价物净增加额
=B12+B25+B35+B36
=C12+C25+C35+C36
加：期初现金及现金等价物余额
=ACCT("1001:1002","C","",0,1,1,"")
=ACCT("1001:1012","C","",0,0,0,"")
六、期末现金及现金等价物余额
=B37+B38
=C37+C38

本文发布于:2024-09-21 23:32:30，感谢您对本站的认可！

本文链接：https://www.17tex.com/tex/1/107368.html

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系，我们将在24小时内删除。

上一篇：常见的后整理工艺
下一篇：现金流量表自动生成模板(最新)
标签：现金   现金流量   活动   项目   支付   收到   投资   产生
留言与评论（共有 0 条评论）
   
验证码：
推荐文章
排行榜
热门标签
Copyright ©2019-2024 Comsenz Inc.Powered by © 易纺专利技术学习网 豫ICP备2022007602号 豫公网安备41160202000603 站长QQ:729038198 关于我们 投诉建议