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

樸老師

職稱：會計師

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)

應(yīng)收年初：=IF(Acct(,1122,C,,0,1,1)>0,Acct(,1122,C,,0,1,1),0)%2BIF(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)%2BIF(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)%2BIF(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)%2BIF(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)%2BIF(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)%2BIF(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)%2BIF(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)%2BIF(Acct(,2203,Y,,0,0,0)>0,Acct(,2203,Y,,0,0,0),0)

2023-03-06 09:16:07

?你好；? ??應(yīng)付賬款＝“應(yīng)付賬款”明細期末貸方余額＋“預(yù)付賬款”明細期末貸方余額 ??應(yīng)收賬款＝“應(yīng)收賬款”明細期末借方余額＋“預(yù)收賬款”明細期末借方余額－“壞賬準(zhǔn)備” ??預(yù)收款項＝“預(yù)收賬款”明細期末貸方余額＋“應(yīng)收賬款”明細期末貸方余額 ??預(yù)付款項＝“預(yù)付賬款”明細期末借方余額＋“應(yīng)付賬款”明細期末借方余額（如有壞賬準(zhǔn)備要減去相應(yīng)的壞賬準(zhǔn)備）? ? ??

2022-09-22 11:33:37

您好，有非常大區(qū)別，明細更準(zhǔn)確。軟件可以操作

2022-04-29 17:26:11

你好應(yīng)付賬款＝“應(yīng)付賬款”明細期末貸方余額＋“預(yù)付賬款”明細期末貸方余額　　應(yīng)收賬款＝“應(yīng)收賬款”明細期末借方余額＋“預(yù)收賬款”明細期末借方余額－“壞賬準(zhǔn)備” 　　預(yù)收款項＝“預(yù)收賬款”明細期末貸方余額＋“應(yīng)收賬款”明細期末貸方余額　　預(yù)付款項＝“預(yù)付賬款”明細期末借方余額＋“應(yīng)付賬款”明細期末借方余額（如有壞賬準(zhǔn)備要減去相應(yīng)的壞賬準(zhǔn)備）

2024-05-23 17:15:38

往來科目重分類是指：會計報表的重分類。它調(diào)表不調(diào)賬，即不調(diào)整明細帳和總帳，只調(diào)整報表科目余額，具體說來，它根據(jù)會計明細科目的期末余額而非總帳余額（凈值）而定，當(dāng)資產(chǎn)類往來會計科目期末出現(xiàn)貸方余額時，這時不再是債權(quán)而是一種債務(wù)，應(yīng)重新分類到負債類科目；反之，當(dāng)負債類往來科目期末出現(xiàn)借方余額時，這時不再是一種債務(wù)而是一種債權(quán)，應(yīng)重新分類到資產(chǎn)類科目中去。你說的是抵減是同一個客戶的往來對沖吧就是應(yīng)收和應(yīng)付對沖了

2022-01-27 15:42:20

還沒有符合您的答案？立即在線咨詢老師免費咨詢老師

精選問題