资源描述:
《报表制作与财务分析ppt课件.ppt》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、K/3V14.2WISE培训大纲—报表金蝶软件(中国)有限公司客户服务中心目录报表概述利润表编制资产负债表编制报表常用功能报表概述提供了多个行业的报表模板提供了丰富的取数公式快速进行自定义报表的编制利润表编制使用预设模板本期金额的填列ACCT取数公式上期金额的填列利润表编制本期金额栏取损益表本期实际发生额管理费用损益表本年实际发生额=ACCT("6602","SL","",0,0,0,"")ACCT取数公式上期金额栏取上年同期的累积发生额管理费用上期金额填列方法一:手工填列上期金额填列方法二:设置取数公式取数=ACCT("6602","SL","",-1,0,0,"")资产负债表编
2、制应收账款等往来项目公式设置存货项目公式设置未分配利润项目公式设置REF_F表间取数公式表页管理和公式取数参数资产负债表编制应收账款项目编制账簿报表应收账款期末余额=ACCT("1122","JY","",0,0,0,"")+ACCT("2203","JY","",0,0,0,"")年初余额=ACCT("1122","JC","",0,1,1,"")+ACCT("2203","JC","",0,1,1,"")应收账款挂客户核算项目期末余额=ACCT("1122
3、客户
4、","JY","",0,0,0,"")+ACCT("2203
5、客户
6、","JY","",0,0,0,"")年初余额=
7、ACCT("1122
8、客户
9、","JC","",0,1,1,"")+ACCT("2203
10、客户
11、","JC","",0,1,1,"")资产负债表编制预收账款项目编制账簿报表预收账款期末余额=ACCT("2203","DY","",0,0,0,"")+ACCT("1122","DY","",0,0,0,"")年初余额=ACCT("2203","DC","",0,1,1,"")+ACCT("1122","DC","",0,1,1,"")预收账款挂客户核算项目期末余额=ACCT("2203
12、客户
13、","DY","",0,0,0,"")+ACCT("1122
14、客户
15、","DY","",0,
16、0,0,"")年初余额=ACCT("2203
17、客户
18、","DC","",0,1,1,"")+ACCT("1122
19、客户
20、","DC","",0,1,1,"")资产负债表编制应付账款项目编制账簿报表应付账款期末余额=ACCT("2202","DY","",0,0,0,"")+ACCT("1123","DY","",0,0,0,"")年初余额=ACCT("2202","DC","",0,1,1,"")+ACCT("1123","DC","",0,1,1,"")应付账款挂供应商核算项目期末余额=ACCT("2202
21、供应商
22、","DY","",0,0,0,"")+ACCT("1123
23、供
24、应商
25、","DY","",0,0,0,"")年初余额=ACCT("2202
26、供应商
27、","DC","",0,1,1,"")+ACCT("1123
28、供应商
29、","DC","",0,1,1,"")资产负债表编制预付账款项目编制账簿报表预付账款期末余额=ACCT("1123","JY","",0,0,0,"")+ACCT("2202","JY","",0,0,0,"")年初余额=ACCT("1123","JC","",0,1,1,"")+ACCT("2202","JC","",0,1,1,"")预付账款挂供应商核算项目期末余额=ACCT(“1123
30、供应商
31、",“JY","",0,0,0
32、,"")+ACCT(“2202
33、供应商
34、",“JY","",0,0,0,"")年初余额=ACCT(“1123
35、供应商
36、",“JC","",0,1,1,"")+ACCT(“2202
37、供应商
38、",“JC","",0,1,1,"")资产负债表编制存货项目编制如果企业有在产品,则需要将科目“5001-生产成本”的期末余额归集到存货的期末余额中资产负债表编制未分配利润项目账结法未分配利润项目期末余额=利润分配科目余额+本年利润科目余额未分配利润期末余额=ACCT("4104","Y","",0,0,0,"")+ACCT("4103","Y","",0,0,0,"")表结法未分配利润项目期末余
39、额=利润分配科目余额+利润表净利润的累积发生额未分配利润期末余额=ACCT("4104","Y","",0,0,0,"")+REF_F("利润表","B18","","")资产负债表编制新建多个表页表页管理公式取数参数报表常用功能单元属性行、列属性表属性表页管理公式取数参数批量填充表页汇总报表权限控制报表删除和更名报表常用功能单元属性字体颜色锁定单元格对齐方式数字格式边框设置报表常用功能行、列属性行高、列宽行隐藏对齐方式数字格式报表常用功能表属性行列外观页眉页脚报表常