急!资产负债表里的其他应收和其他应付同时缺少同一个...

栏目:k3wise知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

急!资产负债表里的其他应收和其他应付同时缺少同一个...

如题,我把科目余额表的其他应收和其他应付明细导出来,自己做重分类后,发现资产负债表里的其他应收期末余额和其他应付期末余额同时缺少同一个金额5000元,我应如何查找这个差异?
月初出报表,求大神版主支招。

其中2241.03这个科目是6月才新增加的,直接在公式里复制黏贴改数字的,也不知道加的对不对。
其他应收款的报表公式
=ACCT("1231.01|职员|","JY","",0,0,0,"")+ACCT("1231.02.01:1231.02.04|客户|","JY","",0,0,0,"")+ACCT("1231.03|客户|","JY","",0,0,0,"")+ACCT("1231.04|关联公司|","JY","",0,0,0,"")+ACCT("1231.05|客户|","JY","",0,0,0,"")+ACCT("1231.99","JY","",0,0,0,"")+ACCT("2241.01|供应商|","JY","",0,0,0,"")+ACCT("2241.02|关联公司|","JY","",0,0,0,"")+ACCT("2241.03|职员|","JY","",0,0,0,"")+ACCT("2241.99.01:2241.99.99","JY","",0,0,0,"")-ACCT("1242.02","Y","",0,0,0,"")
其他应付款的报表公式
=ACCT("2241.01|供应商|","DY","",0,0,0,"")+ACCT("2241.02|关联公司|","DY","",0,0,0,"")+ACCT("2241.03|职员|","Y","",0,0,0,"")+ACCT("2241.99.01:2241.99.99","DY","",0,0,0,"")+ACCT("1231.01|职员|","DY","",0,0,0,"")+ACCT("1231.02.01:1231.02.04|客户|","DY","",0,0,0,"")+ACCT("1231.03|客户|","DY","",0,0,0,"")+ACCT("1231.04|关联公司|","DY","",0,0,0,"")+ACCT("1231.05|客户|","DY","",0,0,0,"")+ACCT("1231.99","DY","",0,0,0,"")

急!资产负债表里的其他应收和其他应付同时缺少同一个...

如题,我把科目余额表的其他应收和其他应付明细导出来,自己做重分类后,发现资产负债表里的其他应收期末余额和其他应付期末余额同时缺少同...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息