财务培训-v13.0报表系统

©1993-2012金蝶（中国）④公开外传金蝶 （中国）客户服务中心金蝶K/3V13.0报表系统培训假如你是你最关心什么？课前P*P*报表概述提供了多个行业的报表模板提供了丰富的取数公式快速进行自定义报表的编制P*报表常用功能单元属性

行、列属性表属性表页管理公式取数参数批量填充表页汇总报表权限控制报表删除和更名报表常用功能单元属性字体颜色锁定单元格对齐方式数字格式边框设置P*报表常用功能行、列属性行高、列宽行隐藏对齐方式数字格式P*报表常用功能表属性行列外观页眉页脚P*报表常用功能表页管理表页管理表页锁定思考：某表页锁定后，其他表页修改公式，锁定的表页是否会相应改变P*报表常用功能公式取数参数缺省年度、开始期间、结束期间开始日期、结束日期核算项目ACCT函数包括未过账凭证数值转换P*报表常用功能P*报表常用功能表页汇总锁定单元格汇总表页数据P*报表常用功能报表权限控制对每张报表进行明细权限分为：

、、打印、修改、更改权限、完全控制P*报表常用功能报表删除和更名–

菜单【文件】→【打开】P*报表常用功能多账套管理报表审核

舍位平衡

报表报表联查报表打印引入引出P*报表常用功能多账套管理实现从其他账套中取数配置账套设置公式P*报表常用功能报表审核审核报表数据设置审核条件审核报表P*报表常用功能舍位平衡用于报表的数值转换设置舍位平衡公式进行舍位平衡思考：舍位平衡与数值转换功能的区别？P*报表常用功能报表–

后报表不能编辑P*P*报表常用功能报表联查–

联查总账、明细账、数量金额总账和数量金额明细账思考：联查各账簿的按钮灰显是什么原因？P*报表常用功能报表打印缩放比例批量打印选定区域打印P*报表常用功能引入引出引出表页引出报表引入文件P*常用报表函数常用报表函数ACCTACCTCASHACCTEXTREF_FIFRPTDATESYSINFO学完了就上场练练：1、请新建一个资产负债表以后删除该报表2、请在资产负债表“存货”中添加“生产成本”科目的年初余额和期末余额的取数公式3、请在资产负债表中添加一个表页，将表页名改成1月和2月，将表页“1月”锁定4、设置第3题的两个表页分别取账套上一期和本期的数据5、将报表的所有的数字格式都改成为0不显示，并且将报表设置成一张万元表6、请新建一个用户给用户授予报表的所

限7、请将报表取数期间的日期打印在纸张的右上角8、需要在报表中将公司名称打印在纸张的左上角9、请将资产负债表打印到一张A4纸上P*P*利润表编制使用预设模板

本期金额的填列–

ACCT取数公式上期金额的填列利润表编制本期金额栏取本期实际损益发生额用本期金额=ACCT("6602",“SY","",0,0,0,"")P*ACCT取数公式上期金额栏取上年同期的实际损益发生额用上期金额–

填列方法：设置取数公式取数=ACCT("6602","SY","",-1,0,0,"")P*ACCT取数公式大部分的客户都需要添加本年累计损益发生额这一列：用本年累计金额设置取数公式取数

=ACCT("6602","SL","",0,0,0,"")P*P*资产负债表编制应收账款等往来项目公式设置存货项目公式设置未分配利润项目公式设置–

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|客户|","JY","",0,0,0,"")+ACCT("2203|客户|","JY","",0,0,0,"")年初余额=ACCT("1122|客户|","JC","",0,1,1,"")+ACCT("2203|客户|","JC","",0,1,1,"")P*资产负债表编制预收账款项目编制账簿报表预收账款期末余额=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|客户|","DY","",0,0,0,"")+ACCT("1122|客户|","DY","",0,0,0,"")年初余额=ACCT("2203|客户|","DC","",0,1,1,"")+ACCT("1122|客户|","DC","",0,1,1,"")P*资产负债表编制应付账款项目编制账簿报表应付账款期末余额=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|供应商|","DY","",0,0,0,"")+ACCT("1123|供应商|","DY","",0,0,0,"")年初余额=ACCT("2202|供应商|","DC","",0,1,1,"")+ACCT("1123|供应商|","DC","",0,1,1,"")P*资产负债表编制预付账款项目编制账簿报表预付账款期末余额=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|供应商|",“JY","",0,0,0,"")+ACCT(“2202|供应商|",“JY","",0,0,0,"")年初余额=ACCT(“1123|供应商|",“JC","",0,1,1,"")+ACCT(“2202|供应商|",“JC","",0,1,1,"")P*P*资产负债表编制存货项目编制如果企业有在产品，则需要将科目“5001-生产成本”的期末余额归集到存货的期末余额中P*资产负债表编制未分配利润项目账结法未分配利润项目期末余额=利润分配科目余额+本年利润科目余额未分配利润期末余额=ACCT("4104","Y","",0,0,0,"")+ACCT("4103","Y","",0,0,0,"")表结法未分配利润项目期末余额=利润分配科目余额+利润表净利润的累积发生额未分配利润期末余额=ACCT("4104","Y","",0,0,0,"")+REF_F("利润表","B18","","")三大报表的勾稽关系表内勾稽关系：资产负债表=负债+权益利润=收入-成本费用表外勾稽关系：损益表及利润分配表中的未分配利润=资产负债表中的未分配利润资产负债表中现金及其等价物期末余额与期初余额之差=现金流量表中现金