金蝶利润表公式设置

项目行次本月金额一、营业收入1=ACCT(6001,SY,,0,0,0,)+ACCT(6051,SY,,0,0,0,)二、营业总成本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,JF,,0,0,0,)管理费用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