金蝶利润表公式设置

项 目行次本月金额

一、营业收入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