'项 目 '行次 '本 月 数 '本年累计数
'一,产品销售收入 1 =ACCT("501","SY","",0,0,0) =ACCT("501","SL","",0,0,0)
' 减:产品销售成本 2 =ACCT("502","SY","",0,0,0) =ACCT("502","SL","",0,0,0)
' 产品销售费用 3 =ACCT("503","SY","",0,0,0) =ACCT("503","SL","",0,0,0)
' 产品销售税金及附加 4 =ACCT("504","SY","",0,0,0) =ACCT("504","SL","",0,0,0)
'二,产品销售利润 7 =C2-C3-C4-C5 =D2-D3-D4-D5
' 加:其他业务利润 9 =ACCT("511","SY","",0,0,0)-ACCT("512","SY","",0,0,0) =ACCT("511","SL","",0,0,0)-ACCT("512","SL","",0,0,0)
' 减:管理费用 10 =ACCT("521","SY","",0,0,0) =ACCT("521","SL","",0,0,0)
' 财务费用 11 =ACCT("522","SY","",0,0,0) =ACCT("522","SL","",0,0,0)
'三,营业利润 14 =C6+C7-C8-C9 =D6+D7-D8-D9
' 加:投资收益 15 =ACCT("531","SY","",0,0,0) =ACCT("531","SL","",0,0,0)
' 补贴收入 16 =ACCT("532","SY","",0,0,0) =ACCT("532","SL","",0,0,0)
' 营业外收入 17 =ACCT("541","SY","",0,0,0) =ACCT("541","SL","",0,0,0)
' 减:营业外支出 18 =ACCT("542","SY","",0,0,0) =ACCT("542","SL","",0,0,0)
' 加:以前年度损益调整 20 =ACCT("560","SY","",0,0,0) =ACCT("560","SL","",0,0,0)
'四,利润总额 25 =SUM(C10:C15)-2*C14 =SUM(D10:D15)-2*D14
' 减:所得税 26 =ACCT("550","SY","",0,0,0) =ACCT("550","SL","",0,0,0)
'五,净利润 30 =C16-C17 =D16-D17