金蝶财务报表公式设置

项目本期金额一、营业收入=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,)其中：对联营企业和合营企业的投资收益二、营业利润（亏损以“-”号填列）=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五、每股收益：（一）基本每股收益（二）稀释每股收益公式含义：各个字母含义：ACCT6001SYSLCYJCJYDCDY0，0，0-1,0,00,1,1ACCT(科目范围，取数类型，币别，年度，起始期间，结束期间，账套配置名）本年累计上年本期=ACCT(6001,SL,,0,0,0,)+ACCT(6051,SL,,0,0,0,)=ACCT(6001,SY,,-1,0,0,)+ACCT(6051,SY,,-1,0,0,)=ACCT(6401,SL,,0,0,0,)+ACCT(6402,SL,,0,0,0,)=ACCT(6401,SY,,-1,0,0,)+ACCT(6402,SY,,-1,0,0,)=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=B2-SUM(B3:B8)+B9+B10=ACCT(6301,SL,,0,0,0,)=ACCT(6301,SY,,-1,0,0,)=ACCT(6711,SL,,0,0,0,)=ACCT(6711,SY,,-1,0,0,)=B12+B13-B14=B12+B13-B14=ACCT(6801,SL,,0,0,0,)=ACCT(6801,SY,,-1,0,0,)=B16-B17=B16-B17财务报表从总账科目取数公式科目代码，营业收入=主营业务收入+其他业务收入利润表本期发生额利润表本年发生额资产负债表总账科目期初余额资产负债表总账科目期末余额资产负债表总账科目借方期初余额资产负债表总账科目借方期末余额资产负债表总账科目贷方期初余额资产负债表总账科目贷方期末余额综合本位币本年本期，0意默认上年本期（上年的同一月份）本年年初，本年1月ACCT(科目范围，取数类型，币别，年度，起始期间，结束期间，账套配置名）=ACCT(6001,SY,,-1,0,0,)+ACCT(6051,SY,,-1,0,0,)=ACCT(6401,SY,,-1,0,0,)+ACCT(6402,SY,,-1,0,0,)