哪位老師,能寫一下往來科目的重分類公式嗎。

糊涂
于2023-03-06 09:15 發(fā)布 ??835次瀏覽
- 送心意
樸老師
職稱: 會計師
2023-03-06 09:16
應(yīng)收年初:=IF(Acct(,1122,C,,0,1,1)>0,Acct(,1122,C,,0,1,1),0)+IF(Acct(,2203,C,,0,1,1)<0,-Acct(,2203,C,,0,1,1),0)-Acct(,1231,Y,,0,1,1)
應(yīng)收年末:=IF(Acct(,1122,Y,,0,0,0)>0,Acct(,1122,Y,,0,0,0),0)+IF(Acct(,2203,Y,,0,0,0)<0,-Acct(,2203,Y,,0,0,0),0)-Acct(,1231,Y,,0,0,0)
應(yīng)付年初:=IF(Acct(,2202,C,,0,1,1)>0,Acct(,2202,C,,0,1,1),0)+IF(Acct(,1123,C,,0,1,1)<0,-Acct(,1123,C,,0,1,1),0)
應(yīng)付年末:=IF(Acct(,2202,Y,,0,0,0)>0,Acct(,2202,Y,,0,0,0),0)+IF(Acct(,1123,Y,,0,0,0)<0,-Acct(,1123,Y,,0,0,0),0)
預(yù)付年初:=IF(Acct(,2202,C,,0,1,1)<0,-Acct(,2202,C,,0,1,1),0)+IF(Acct(,1123,C,,0,1,1)>0,Acct(,1123,C,,0,1,1),0)
預(yù)付年末:=IF(Acct(,2202,Y,,0,0,0)<0,-Acct(,2202,Y,,0,0,0),0)+IF(Acct(,1123,Y,,0,0,0)>0,Acct(,1123,Y,,0,0,0),0)
預(yù)收年初:=IF(Acct(,1122,C,,0,1,1)<0,-Acct(,1122,C,,0,1,1),0)+IF(Acct(,2203,C,,0,1,1)>0,Acct(,2203,C,,0,1,1),0)
預(yù)收年末:=IF(Acct(,1122,Y,,0,0,0)<0,-Acct(,1122,Y,,0,0,0),0)+IF(Acct(,2203,Y,,0,0,0)>0,Acct(,2203,Y,,0,0,0),0)






粵公網(wǎng)安備 44030502000945號


