速达软件现金流量表中的附表公式

             不知什么原因，速达财务软件的现金流量表附表并没有预置公式，这是本人摸索得到的公式：

             1.净利润 =("ZWA,3131,期末余额,0,0")

             2.计提的资产减值准备

=(ASC("ZWA,1102,本年贷方累计,0,0")-ASC("ZWA,1102,本年借方累计,0,0"))+(ASC("ZWA,1141,本年贷方累计,0,0")-ASC("ZWA,1141,本年借方累计,0,0"))+(ASC("ZWA,1281,本年贷方累计,0,0")-ASC("ZWA,1281,本年借方累计,0,0"))+(ASC("ZWA,1421,本年贷方累计,0,0")-ASC("ZWA,1421,本年借方累计,0,0"))+(ASC("ZWA,1505,本年贷方累计,0,0")-ASC("ZWA,1505,本年借方累计,0,0"))+ASC("ZWA,1605,本年贷方累计,0,0")-ASC("ZWA,1605,本年借方累计,0,0")+(ASC("ZWA,1805,本年贷方累计,0,0")-ASC("ZWA,1805,本年借方累计,0,0"))

             3.固定资产折旧   =("ZWA,1502,本年贷方累计,0,0")

             4.无形资产摊销   =("ZWA,1801,本年贷方累计,0,0")

             5.长期待摊费用的摊销 =("ZWA,1901,本年贷方累计,0,0")

             6.待摊费用减少(减：增加) =ASC("ZWA,1301,本年贷方累计,0,0")-ASC("ZWA,1301,本年借方累计,0,0")

             7.预提费用增加（减：减少）   =ASC("ZWA,2191,本年贷方累计,0,0")-ASC("ZWA,2191,本年借方累计,0,0")

             8.处置固定资产、无形资产和其他长期资产损失（减：收益）

             9.固定资产报废损失

             10.财务费用

             11.投资损失（减：收益）=ASC("SY,5201,本年借方累计")-ASC("SY,5201,本年贷方累计")

             12.递延税款贷项（减：借项）

             13.存货的减少（减：增加）    =ASC("ZWA,1243,期末余额,0,0")-ASC("ZWA,1243,年初余额,0,0")

             14.经营性应收项目的减少（减：增加） =(ASC("ZWA,1111,期末余额,0,0")-ASC("ZWA,1111,年初余额,0,0"))+(ASC("ZWA,1121,期末余额,0,0")-ASC("ZWA,1121,年初余额,0,0"))+(ASC("ZWA,1122,期末余额,0,0")-ASC("ZWA,1122,年初余额,0,0"))+(ASC("ZWA,1131,期末余额,0,0")-ASC("ZWA,1131,年初余额,0,0"))+(ASC("ZWA,1133,期末余额,0,0")-ASC("ZWA,1133,年初余额,0,0"))+(ASC("ZWA,1151,期末余额,0,0")-ASC("ZWA,1151,年初余额,0,0"))+(ASC("ZWA,1161,期末余额,0,0")-ASC("ZWA,1161,年初余额,0,0"))

             15.经营性应付项目的增加（减:减少）    =(ASC("ZWB,2101,2181,期末余额,0,0")-ASC("ZWB,2101,2181,年初余额,0,0"))-ASC("ZWA,2191,本年借方累计,0,0")+(ASC("ZWB,2211,2331,期末余额,0,0")-ASC("ZWB,2211,2331,年初余额,0,0"))

             16.其他

             17.经营活动产生现金流量净额 =SUM(C43,C57)