金蝶财务软件中资产负债表的应收应付,预付预收公式是怎么设置的? ...
一、金蝶财务软件中资产负债表的应收、应付、预付、预收账款项目公式为1、应收账款项目取应收账款的借方金额加上预收账款的借方金额;公式为ACCT("1122","JY","",0,0,0,"")+ACCT("2203","JY","",0,0,0,"")2、预付账款项目取预付账款的借方金额加上应付账款的借方金额;公式为ACCT("1123","JY","",0,0,0,"")+ACCT("2202","JY","",0,0,0,"")有计提坏账准备的,上述公式中还应当减去相应的坏账准备金额。
3、应付账款项目取应付账款的贷方金额加上预付账款的贷方金额;(ACCT("1123","DY","",0,0,0,"")+ACCT("2202","DY","",0,0,0,"")4、预收账款项目取预收账款的贷方金额加上应收账款的贷方金额;公式为(ACCT("1122","DY","",0,0,0,"")+ACCT("2