金蝶KIS商贸版、专业版、K3公式取数参数说明:
函数定义:
Y 期末余额
DY 贷方期末余额
JY 借方期末余额
C 期初余额
JC 借方期初余额
DC 贷方期初余额
例如:其他应收款(科目代码为1133)
年初余额公式的格式为: =ACCT("1133","C","",0,1,1,"")
期末余额公式的格式为: =ACCT("1133","Y","",0,0,0,"")
(最后三个数字 分别代表年度,开始期间,结束期间。数字0代表本年或本期。例如:0,0,0代表本年本期;0,1,1则代表本年的1月)
例如:预收账款(科目代码为2203)
年初余额公式的格式为:
=ACCT("2203","DC","",0,1,1,"")+ACCT("1122","DC","",0,1,1,"")
(预收账款贷方年初余额+应收账款贷方年初余额) 年初余额即1月的期初余额
期末余额公式的格式为: =ACCT("2203","DY","",0,0,0,"")+ACCT("1122","DY","",0,0,0,"")
(预收账款贷方期末余额+应收账款贷方期末余额)
如果修改公式为,预收只取本科目的期末余额、年初余额,则公司调整为:
年初数公式的格式为: =ACCT("2203","C","",0,1,1,"")
期末数公式的格式为: =ACCT("2203","Y","",0,0,0,"")
追问我是新增设了会计科目递延所得税资产后,结帐后资产负债表就不平了,不知道该如何修改公式?
追答在对应位置插入单元格,然后输入好公式
本回答被网友采纳