我使用的是用友畅捷通T+财务管理软件,在操作T+T-UFO模块的时候碰到了个问题:
应交税费资产负债表的金额与余额表的金额不一致
请教用友财务软件工程师如何解决?具体的情况如下:
QC("222101","","年","","贷")+QC("222102","","年","","贷")+QC("222108","","年","","贷")+QC("222109","","年","","贷")+QC("222110","","年","","贷")+QC("222111","","年","","贷")+QC("222112","","年","","贷")+QC("222113","","年","","贷")+QC("222114","","年","","贷")+QC("222115","","年","","贷")+QC("222116","","年","","贷")+QC("222117","","年","","贷")+QC("222118","","年","","贷")+QC("222119","","年","","贷")+QC("222120","","年","","贷")+QC("222121","","年","","贷")+QC("222122","","年","","贷")+QC("222123","","年","","贷"),这是应交税费的系统里的计算公式,但是计算出来的数据与余额表上的数据不一致。请问是公式错误还是什么问题?谢谢
科目编码改成应交税费的科目编码 ,参考这个方法试试
我发现他并没有用负数表示,他是用其他流动资产(应交税费借方合计)-应交税费(应交税费贷方合计)=应交税费的余额。这个余额表上并没有直接反应。但是这样表示之后,资产总额增加了
借方有数据,公式是取贷方,因此会负数显示的,您需要检查每一个公式的值,以及余额表中的数
这上面的科目贷方都是没有数字,只有借方有,但是加和出来表上就有数字了
公式没有问题,这样试试,您依次将这公式中 的每一项科目单独计算,然后加和,看下是否能和公式计算出的一致。
你可以把上面科目的公式复制,粘贴下来,然后把科目编码改成应交税费的科目编码,然后保存,重新计算报表,数据就一样了