金蝶利润表公式设置

项目行次本月金额一、营业收入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