文档介绍：K/
金蝶软件(中国)有限公司
客户服务中心
目录
报表概述
利润表编制
资产负债表编制
报表常用功能
报表概述
提供了多个行业的报表模板
提供了丰富的取数公式
快速进行自定义报表的编制
利润表编制
使用预设模板
本期金额的填列
ACCT取数公式
上期金额的填列
利润表编制
本期金额栏取本年累积发生额
管理费用本期金额
=ACCT("6602","SL","",0,0,0,"")
ACCT取数公式
上期金额栏取上年同期的累积发生额
管理费用上期金额
填列方法一:手工填列上期金额
填列方法二:设置取数公式取数=ACCT("6602","SL","",-1,0,0,"")
资产负债表编制
应收账款等往来项目公式设置
存货项目公式设置
未分配利润项目公式设置
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,"")
资产负债表编制
预收账款项目编制
账簿
报表
预收账款
期末余额=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,"")
资产负债表编制
应付账款项目编制
账簿
报表
应付账款
期末余额=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,"")