当前位置：文档之家 › 金蝶财务报表公式设置

金蝶财务报表公式设置

  • 格式：xls
  • 大小：29.50 KB
  • 文档页数：3

项目本期金额一、营业收入 =ACCT("6001","SY","",0,0,0,"")+ 减：营业成本 =ACCT("6401","SY","",0,0,0,"")+ 营业税金及附加 =ACCT("6403","SY","",0,0,0,"") 销售费用 =ACCT("6601","SY","",0,0,0,"") 管理费用 =ACCT("6602","SY","",0,0,0,"") 财务费用 =ACCT("6603","SY","",0,0,0,"") 资产减值损失 =ACCT("6701","SY","",0,0,0,"") 加：公允价值变动收益（损失以“-”号填列） =ACCT("6101","SY","",0,0,0,"") 投资收益（损失以“-”号填列） =ACCT("6111","SY","",0,0,0,"") 其中：对联营企业和合营企业的投资收益二、营业利润（亏损以“-”号填列） =B2-SUM(B3:B8)+B9+B10 加：营业外收入 =ACCT("6301","SY","",0,0,0,"") 减：营业外支出 =ACCT("6711","SY","",0,0,0,"") 其中：非流动资产处置损失三、利润总额（亏损总额以“-”号填列） =B12+B13-B14 减：所得税费用 =ACCT("6801","SY","",0,0,0,"")四、净利润（净亏损以“-”号填列） =B16-B17五、每股收益：（一）基本每股收益（二）稀释每股收益

公式含义：各个字母含义：ACCT6001SYSLCYJCJYDCDY""0，0，0-1,0,00,1,1ACCT(科目范围，取数类型，币别，本年累计上年本期 =ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"") =ACCT("6001","SY","",-1,0,0,"")+ACCT(" =ACCT("6401","SL","",0,0,0,"")+ACCT("6402","SL","",0,0,0,"") =ACCT("6401","SY","",-1,0,0,"")+ACCT(" =ACCT("6403","SL","",0,0,0,"") =ACCT("6403","SY","",-1,0,0,"") =ACCT("6601","SL","",0,0,0,"") =ACCT("6601","SY","",-1,0,0,"") =ACCT("6602","SL","",0,0,0,"") =ACCT("6602","SY","",-1,0,0,"") =ACCT("6603","SL","",0,0,0,"") =ACCT("6603","SY","",-1,0,0,"") =ACCT("6701","SL","",0,0,0,"") =ACCT("6701","SY","",-1,0,0,"") =ACCT("6101","SL","",0,0,0,"") =ACCT("6101","SY","",-1,0,0,"") =ACCT("6111","SL","",0,0,0,"") =ACCT("6111","SY","",-1,0,0,"") =B2-SUM(B3:B8)+B9+B10 =B2-SUM(B3:B8)+B9+B10 =ACCT("6301","SL","",0,0,0,"") =ACCT("6301","SY","",-1,0,0,"") =ACCT("6711","SL","",0,0,0,"") =ACCT("6711","SY","",-1,0,0,"")

=B12+B13-B14 =B12+B13-B14 =ACCT("6801","SL","",0,0,0,"") =ACCT("6801","SY","",-1,0,0,"") =B16-B17 =B16-B17

财务报表从总账科目取数公式科目代码，营业收入=主营业务收入+其他业务收入利润表 本期发生额利润表 本年发生额资产负债表 总账科目 期初余额资产负债表 总账科目 期末余额资产负债表 总账科目 借方期初余额资产负债表 总账科目 借方期末余额资产负债表 总账科目 贷方期初余额资产负债表 总账科目 贷方期末余额综合本位币本年本期，0意默认上年本期（上年的同一月份）本年年初，本年1月币别，年度，起始期间，结束期间，账套配置名）CCT("6051","SY","",-1,0,0,"")0,0,"")+ACCT("6402","SY","",-1,0,0,"")

合集下载

金蝶软件报表公式设置

金蝶软件报表公式设置

博学笃行 自强不息

1

金蝶软件报表公式设置

引言：随着企业规模的扩大和业务复杂度的提高，金蝶软件成为了众多企业首选的管理软件之一。在财务报表的生成过程中，设置正确的公式是确保数据准确性和报表可靠性的关键。本文将介绍金蝶软件中报表公式的设置方法和技巧，帮助您更好地应用金蝶软件进行财务数据分析和报表生成。

一、公式的基本概念

在金蝶软件中，报表公式是由特定的函数和操作符组成的，用于在报表中计算和展示数据。这些公式可以基于其他报表数据、计算结果或固定值进行运算，并生成最终的报表结果。公式可以用于计算财务指标、比率、增长率等各种重要的指标，帮助企业管理者更好地理解业务情况和进行决策。

二、公式的设置步骤

1. 打开金蝶软件并选择相应的报表模板。在报表设计界面中，可以看到各种报表元素和布局。

2. 在需要设置公式的单元格中双击，并选中“设置公式”选项。在公式编辑器中，可以输入公式表达式和相关参数。

博学笃行 自强不息

2

3. 根据具体的报表需求和计算逻辑，选择合适的函数和操作符，并填写相应的参数。金蝶软件提供了丰富的函数库，包括数学函数、逻辑函数、文本函数等，可以满足不同的计算需求。

4. 在公式编辑器中，可以通过点击工具栏上的按钮来插入字段、运算符和函数。也可以直接手动输入相应的表达式和参数。

5. 添加公式后，可以使用预览功能来验证公式的正确性。点击“预览”按钮，系统将根据当前的数据和报表设计，计算出公式的结果，并在预览窗口中展示。

6. 如果公式设置正确，可以点击“确认”按钮保存设置。系统将根据公式的定义，自动计算并更新报表数据。

三、公式设置的技巧

1. 使用合适的函数：金蝶软件提供了丰富的函数库，可以满足不同的计算需求。在设置公式时，应根据具体的计算逻辑选择合适的函数，以确保计算结果准确。

2. 引用正确的单元格：在设置公式时，应确保引用的单元格和数据区域是正确的。错误的单元格引用可能导致计算错误或显示不准确的报表结果。 博学笃行 自强不息

金蝶报表公式

金蝶报表公式

精品文档

C 期初余额

JC 借方期初余额

DC 贷方期初余额

AC 期初绝对余额

Y 期末余额

JY 借方期末余额

DY 贷方期末余额

AY 期末绝对余额

JF 借方发生额

DF 贷方发生额

JL 借方本年累计发生额

DL 贷方本年累计发生额

SY 损益表本期实际发生额

SL 损益表本年实际发生额

B 取科目预算数据

处理方法：

1、 打开报表与分析中的资产负债表，选择菜单中的属性T报表属性；

2、 打开“报表属性”7“页眉页脚” T选择需要编辑的栏目T点击“编辑页眉页脚”，

如下图；

3、在“单位名称：”后输入“长沙某软件有限公司” ,在分段符“ | ”后输入取数公式：

“ &［会计年度 ］ 年&［报表期间 ］月&［最大日期 ］ 日”，完成后点击“确定”即可保存。如下图 所示：

日期取数公式：

年： &［会计年度 ］

月： &［报表期间 ］

日： &［最大日期 ］

在对应的公式后加入对应的单位即可。

完整的公式为：“ &［［ 会计年度 ］ 年&［报表期间 ］月&［最大日期 ］日

“ | ”为分段符，可以将一行分成 N 段。

4、最后，退出报表时记得点击保存。

金蝶财务报表公式设置

金蝶财务报表公式设置

项目本期金额一、营业收入 =ACCT("6001","SY","",0,0,0,"")+ 减：营业成本 =ACCT("6401","SY","",0,0,0,"")+ 营业税金及附加 =ACCT("6403","SY","",0,0,0,"") 销售费用 =ACCT("6601","SY","",0,0,0,"") 管理费用 =ACCT("6602","SY","",0,0,0,"") 财务费用 =ACCT("6603","SY","",0,0,0,"") 资产减值损失 =ACCT("6701","SY","",0,0,0,"") 加：公允价值变动收益（损失以“-”号填列） =ACCT("6101","SY","",0,0,0,"") 投资收益（损失以“-”号填列） =ACCT("6111","SY","",0,0,0,"") 其中：对联营企业和合营企业的投资收益二、营业利润（亏损以“-”号填列） =B2-SUM(B3:B8)+B9+B10 加：营业外收入 =ACCT("6301","SY","",0,0,0,"") 减：营业外支出 =ACCT("6711","SY","",0,0,0,"") 其中：非流动资产处置损失三、利润总额（亏损总额以“-”号填列） =B12+B13-B14 减：所得税费用 =ACCT("6801","SY","",0,0,0,"")四、净利润（净亏损以“-”号填列） =B16-B17五、每股收益：（一）基本每股收益（二）稀释每股收益

公式含义：各个字母含义：ACCT6001SYSLCYJCJYDCDY""0，0，0-1,0,00,1,1ACCT(科目范围，取数类型，币别，本年累计上年本期 =ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"") =ACCT("6001","SY","",-1,0,0,"")+ACCT(" =ACCT("6401","SL","",0,0,0,"")+ACCT("6402","SL","",0,0,0,"") =ACCT("6401","SY","",-1,0,0,"")+ACCT(" =ACCT("6403","SL","",0,0,0,"") =ACCT("6403","SY","",-1,0,0,"") =ACCT("6601","SL","",0,0,0,"") =ACCT("6601","SY","",-1,0,0,"") =ACCT("6602","SL","",0,0,0,"") =ACCT("6602","SY","",-1,0,0,"") =ACCT("6603","SL","",0,0,0,"") =ACCT("6603","SY","",-1,0,0,"") =ACCT("6701","SL","",0,0,0,"") =ACCT("6701","SY","",-1,0,0,"") =ACCT("6101","SL","",0,0,0,"") =ACCT("6101","SY","",-1,0,0,"") =ACCT("6111","SL","",0,0,0,"") =ACCT("6111","SY","",-1,0,0,"") =B2-SUM(B3:B8)+B9+B10 =B2-SUM(B3:B8)+B9+B10 =ACCT("6301","SL","",0,0,0,"") =ACCT("6301","SY","",-1,0,0,"") =ACCT("6711","SL","",0,0,0,"") =ACCT("6711","SY","",-1,0,0,"")

金蝶资产负债表公式设置

金蝶资产负债表公式设置

资 产行次年初数期末数流动资产： 货币资金1=ACCT("1001:1012","C","",0,"1",0,"")=ACCT("1001:1012","Y" 交易性金融资产2=ACCT("1101","C","",0,"1",0,"")=ACCT("1101","Y","",0 应收票据3=ACCT("1121","C","",0,"1",0,"")=ACCT("1121","Y","",0 应收账款4=ACCT("1122","C","",0,"1",0,"")-ACCT=ACCT("1122","Y","",0 预付款项5 应收利息6=ACCT("1132","C","",0,"1",0,"")=ACCT("1132","Y","",0 应收股利7=ACCT("1131","C","",0,"1",0,"")=ACCT("1131","Y","",0 其他应收款8=ACCT("1221","C","",0,"1",0,"")=ACCT("1221","Y","",0 存货9=ACCT("1405:1412","C","",0,"1",0,"")=ACCT("1405:1412","Y" 其中：库存商品10 待摊费用11 一年内到期的非流动资产12 其他流动资产13流动资产合计=SUM(C3:C11)+SUM(C13:C15)=SUM(D3:D11)+SUM(D13:非流动资产： 可供出售金融资产14 持有至到期投资15=ACCT("1501","C","",0,"1",0,"")-ACCT=ACCT("1501","Y","",0 长期应收款16 长期股权投资17 投资性房地产18 固定资产19=ACCT("1601","C","",0,"1",0,"")-ACCT=ACCT("1601","Y","",0 在建工程20=ACCT("1604","C","",0,"1",0,"")=ACCT("1604","Y","",0 工程物资21 固定资产清理22=ACCT("1606","C","",0,"1",0,"")=ACCT("1606","Y","",0 生产性生物资产23 油气资产24 无形资产25=ACCT("1701","C","",0,"1",0,"")+ACCT=ACCT("1701")+ACCT("1 开发支出26 商誉27 长期待摊费用28 递延所得税资产29 其他非流动资产30非流动资产合计=SUM(C18:C34)=SUM(D18:D34)资产总计=C16+C35=D16+D35负债和股东权益行次年初数期末数流动负债： 短期借款31 交易性金融负债 32 应付票据 33=ACCT("2201","C","",0,"1",0,"")=ACCT("2201","Y","",0,0,0,"") 应付账款 34=ACCT("2202","C","",0,"1",0,"")=ACCT("2202","Y","",0,0,0,"") 预收款项 35 应付职工薪酬 36=ACCT("2211","C","",0,"1",0,"")=ACCT("2211","Y","",0,0,0,"") 应交税费 37=ACCT("2221","C","",0,"1",0,"")=ACCT("2221","Y","",0,0,0,"") 应付利息 38 应付股利 39 其他应付款40=ACCT("2241","C","",0,"1",0,"")=ACCT("2241") 预提费用 41 一年内到期的非流动负债42 其他流动负债 43流动负债合计 =SUM(G3:G15)=SUM(H3:H15)非流动负债： 长期借款 44 应付债券45 长期应付款46 专项应付款47=ACCT("2811","C","",0,"1",0,"")=ACCT("2811","Y","",0,0,0,"") 预计负债48 递延所得税负债49 其他非流动负债50非流动负债合计 =SUM(G18:G24)=SUM(H18:H24)负债合计=G16+G25=H16+H25股东权益： 股本51=ACCT("4001","C","",0,"1",0,"")=ACCT("4001","Y","",0,0,0,"") 资本公积 52=ACCT("4002","C","",0,"1",0,"")=ACCT("4002","Y","",0,0,0,"") 减：库存股53 盈余公积54=ACCT("4101","C","",0,"1",0,"")=ACCT("4101","Y","",0,0,0,"") 其中：法定公益金 55=ACCT("4101.01","C","",0,"1",0,=ACCT("4101.01","Y","",0,0,0,"") 未分配利润56=ACCT("4103:4104","C","",0,"1",=ACCT("4103:4104","Y","",0,0,0,"") 股东权益合计=G29+G30+G32+G34=H29+H30+H32+H34负债和股东权益总计 =G35+G26=H35+H26