一 前期準(zhǔn)備(以小企業(yè)會(huì)計(jì)準(zhǔn)則為例)
1 往來(lái)科目必須掛輔助核算
1122應(yīng)收賬款【客戶】2203預(yù)收賬款【客戶】
2202應(yīng)付賬款【供應(yīng)商】1123預(yù)付賬款【供應(yīng)商】
2 客戶與供應(yīng)商編碼位數(shù)統(tǒng)一,如都用3位,便于設(shè)置公式??
二 往來(lái)憑證示例(以應(yīng)收賬款為例)
1122應(yīng)收賬款001客戶1余額為正100000,002客戶2余額為負(fù)30000
?
?
三 科目余額表往來(lái)數(shù)據(jù)
?
分析:如果不重分類,軟件直接取1122應(yīng)收賬款一級(jí)科目余額70000
如果重分類,1122應(yīng)收賬款001 客戶1科目取借方余額100000
如果重分類,1122應(yīng)收賬款002 客戶2科目貸方余額30000填列至2203預(yù)收賬款貸方余額30000
四 默認(rèn)報(bào)表(未重分類)期末余額取數(shù)效果
?
應(yīng)收賬款公式=ACCT("1122","JQM","",0,0,0)+ACCT("2203","JQM","",0,0,0)
預(yù)收賬款公式:=ACCT("2203","DQM","",0,0,0)+ACCT("1122","DQM","",0,0,0)
五 修改報(bào)表(重分類)期末余額取數(shù)效果
?
應(yīng)收賬款修公式:=ACCT("1122|客戶@001:","JQM","",0,0,0)+ACCT("2203|客戶@001:","JQM","",0,0,0)
預(yù)收賬款修改公式:=ACCT("2203|客戶@001:","DQM","",0,0,0)+ACCT("1122|客戶@001:","DQM","",0,0,0)
同理:其他往來(lái)科目也需要這樣修改。
附重分類全部公式
應(yīng)收賬款期末余額:=ACCT("1122|客戶@001:","JQM","",0,0,0)+ACCT("2203|客戶@001:","JQM","",0,0,0)
預(yù)收賬款期末余額:=ACCT("2203|客戶@001:","DQM","",0,0,0)+ACCT("1122|客戶@001:","DQM","",0,0,0)
應(yīng)付賬款期末余額:=ACCT("2202|供應(yīng)商@001:","DQM","",0,0,0)+ACCT("1123|供應(yīng)商@001:","DQM","",0,0,0)
預(yù)付賬款期末余額:=ACCT("1123|供應(yīng)商@001:","JQM","",0,0,0)+ACCT("2202|供應(yīng)商@001:","JQM","",0,0,0)
應(yīng)收賬款期初余額:=ACCT("1122|客戶@001:","JQC","",0,1,1)+ACCT("2203|客戶@001:","JQC","",0,1,1)
預(yù)收賬款期初余額:=ACCT("2203|客戶@001:","DQC","",0,1,1)+ACCT("1122|客戶@001:","DQC","",0,1,1)
應(yīng)付賬款期初余額:=ACCT("2202|供應(yīng)商@001:","DQC","",0,1,1)+ACCT("1123|供應(yīng)商@001:","DQC","",0,1,1)
預(yù)付賬款期初余額:=ACCT("1123|供應(yīng)商@001:","JQC","",0,1,1)+ACCT("2202|供應(yīng)商@001:","JQC","",0,1,1) 答