金蝶财务报表公式设置
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
其中：对联营企业和合营企业的投资收益
二、营业利润（亏损以“-”号填列） 加：营业外收入 减：营业外支出 其中：非流动资产处置损失 三、利润总额（亏损总额以“-”号填列） 减：所得税费用 四、净利润（净亏损以“-”号填列） 五、每股收益： （一）基本每股收益 （二）稀释每股收益
=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
0,0,"")+ACCT("6051","SY","",-1,0,0,"") 0,0,"")+ACCT("6402","SY","",-1,0,0,"")
项目
本期金额
一、营业收入 =ACCT("6001","SY","",0,0,0,"")+ACCT("6051","SY","",0,0,0,"") 减：营业成本 =ACCT("6401","SY","",0,0,0,"")+ACCT("6402","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,"")
数类型，币别，年度，起始期间，结束期间，账套配置名） 财务报表从总账科目取数公式 科目代码，营业收入=主营业务收入+其他业务收入 利润表 本期发生额 利润表 本年发生额 资产负债表 总账科目 期初余额 资产负债表 总账科目 期末余额 资产负债表 总账科目 借方期初余额 资产负债表 总账科目 借方期末余额 资产负债表 总账科目 贷方期初余额 资产负债表 总账科目 贷方期末余额 综合本位币 本年本期，0意默认 上年本期（上年的同一月份） 本年年初，本年1月
公式含义： 各个字母含义：
ACCT(科目范围，取数类型，币别，年度，起始期间，结束期间，账套配 ACCT 6001 SY SL C Y JC JY DC DY "" 0，0，0 -1,0,0 0,1,1
本Hale Waihona Puke Baidu累计
上年本期
=ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"") =ACCT("6001","SY","",-1,0,0,"")+ACCT("6051","SY =ACCT("6401","SL","",0,0,0,"")+ACCT("6402","SL","",0,0,0,"") =ACCT("6401","SY","",-1,0,0,"")+ACCT("6402","SY =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 =ACCT("6301","SL","",0,0,0,"") =ACCT("6711","SL","",0,0,0,"") =B12+B13-B14 =ACCT("6801","SL","",0,0,0,"") =B16-B17 =B2-SUM(B3:B8)+B9+B10 =ACCT("6301","SY","",-1,0,0,"") =ACCT("6711","SY","",-1,0,0,"") =B12+B13-B14 =ACCT("6801","SY","",-1,0,0,"") =B16-B17
二、营业利润（亏损以“-”号填列） 加：营业外收入 减：营业外支出 其中：非流动资产处置损失 三、利润总额（亏损总额以“-”号填列） 减：所得税费用 四、净利润（净亏损以“-”号填列） 五、每股收益： （一）基本每股收益 （二）稀释每股收益
=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
0,0,"")+ACCT("6051","SY","",-1,0,0,"") 0,0,"")+ACCT("6402","SY","",-1,0,0,"")
项目
本期金额
一、营业收入 =ACCT("6001","SY","",0,0,0,"")+ACCT("6051","SY","",0,0,0,"") 减：营业成本 =ACCT("6401","SY","",0,0,0,"")+ACCT("6402","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,"")
数类型，币别，年度，起始期间，结束期间，账套配置名） 财务报表从总账科目取数公式 科目代码，营业收入=主营业务收入+其他业务收入 利润表 本期发生额 利润表 本年发生额 资产负债表 总账科目 期初余额 资产负债表 总账科目 期末余额 资产负债表 总账科目 借方期初余额 资产负债表 总账科目 借方期末余额 资产负债表 总账科目 贷方期初余额 资产负债表 总账科目 贷方期末余额 综合本位币 本年本期，0意默认 上年本期（上年的同一月份） 本年年初，本年1月
公式含义： 各个字母含义：
ACCT(科目范围，取数类型，币别，年度，起始期间，结束期间，账套配 ACCT 6001 SY SL C Y JC JY DC DY "" 0，0，0 -1,0,0 0,1,1
本Hale Waihona Puke Baidu累计
上年本期
=ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"") =ACCT("6001","SY","",-1,0,0,"")+ACCT("6051","SY =ACCT("6401","SL","",0,0,0,"")+ACCT("6402","SL","",0,0,0,"") =ACCT("6401","SY","",-1,0,0,"")+ACCT("6402","SY =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 =ACCT("6301","SL","",0,0,0,"") =ACCT("6711","SL","",0,0,0,"") =B12+B13-B14 =ACCT("6801","SL","",0,0,0,"") =B16-B17 =B2-SUM(B3:B8)+B9+B10 =ACCT("6301","SY","",-1,0,0,"") =ACCT("6711","SY","",-1,0,0,"") =B12+B13-B14 =ACCT("6801","SY","",-1,0,0,"") =B16-B17