金蝶利润表公式设置
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
项 目行次本月金额
一、营业收入1=ACCT("6001","SY","",0,0,0,"")+ACCT("6051",
二、营业总成本2=SUM(C4:C9)
其中：营业成本3=ACCT("6401:6402","JF","",0,0,0,"")
营业税金及附加4=ACCT("6403","JF","",0,0,0,"")
销售费用5=ACCT("6601","JF","",0,0,0,"")+ACCT("6600", 管理费用6=ACCT("6602","JF","",0,0,0,"")
财务费用（收益以“-”号填列）7=ACCT("6603","JF","",0,0,0,"")
资产减值损失8=ACCT("6701","JF","",0,0,0,"")
加：公允价值变动净收益(净损失以“-”号填列)9
投资净收益10=ACCT("6111","JF","",0,0,0,"")
其中：对联营企业和合营企业的投资收益11
汇兑收益（净损失以“-”号填列）12
三、营业利润（亏损以“-”号填列）13=C2-C3+C10+C11+C13
加：营业外收入14=ACCT("6301","DF","",0,0,0,"")
减：营业外支出15=ACCT("6711","JF","",0,0,0,"")
其中：非流动资产处置交损失16
四、利润总额（亏损总额以“-”号填列）17=C14+C15-C16
减：所得税费用18=ACCT("6801","JF","",0,0,0,"")
五、净利润（净亏损以“-”号填列）19=C18-C19
六、其他综合收益20
七、综合收益总额21=C20+C21
八、每股收益：22
(一)基本每股收益23
(三)稀释每股收益24
本年累计金额
=ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"") =SUM(D4:D9)
=ACCT("6401:6402","JL","",0,0,0,"")
=ACCT("6403","JL","",0,0,0,"")
=ACCT("6601","JL","",0,0,0,"")+ACCT("6600","JL","",0,0,0,"") =ACCT("6602","JL","",0,0,0,"")
=ACCT("6603","JL","",0,0,0,"")
=ACCT("6701","JL","",0,0,0,"")
=ACCT("6111","DL","",0,0,0,"")
=D2-D3+D10+D11+D13
=ACCT("6301","DL","",0,0,0,"")
=ACCT("6711","JL","",0,0,0,"")
=D14+D15-D16
=ACCT("6801","JL","",0,0,0,"")
=D18-D19
=D20+D21。