Question

工程施工和工程结算在金蝶资产负债表中公式如何

在资产负债表中的“存货”项目下，增加“其中：已完工尚未结算款”项目，反映施工企业在建施工合同已完工部分但尚未办理结算的价款。本项目根据有关在建筑工合同的“工程施工”科目余额减“工程结算”科目余额后的差额填列。
在资产负债表中的“预收账款”项目下，增加“其中：已结算尚未完工工程”项目，反映施工企业在建施工合同未完工部分已办理了结算的价款。
那么在金蝶软件资产负债表中应该如何设置公式？

Answer 1

工程施工减工程结算  如果是正数 在存货反映，

工程施工减工程结算   如果是负数 在预收账款反映

首先 设置在成本科目下

金蝶KIS专业版 资产负债表设置公式

存货期末余额

=ACCT("1321","Y","",0,0,0,"")-ACCT("2314","Y","",0,0,0,"")+ACCT("1401:1406","Y","",0,0,0,"")+ACCT("1408","Y","",0,0,0,"")-ACCT("1407","Y","",0,0,0,"")+ACCT("1411","Y","",0,0,0,"")+ACCT("5001","Y","",0,0,0,"")+ACCT("5201","Y","",0,0,0,"")-ACCT("1471","Y","",0,0,0,"")+ACCT("5401","JY","",0,0,0,"")-ACCT("5402","JY","",0,0,0,"")

存货年初余额

=ACCT("1321","C","",0,1,1,"")-ACCT("2314","C","",0,1,1,"")+ACCT("1401:1406","C","",0,1,1,"")+ACCT("1408","C","",0,1,1,"")-ACCT("1407","C","",0,1,1,"")+ACCT("1411","C","",0,1,1,"")+ACCT("5001","C","",0,1,1,"")+ACCT("5201","C","",0,1,1,"")-ACCT("1471","C","",0,1,1,"")+ACCT("5401","JY","",0,1,1,"")-ACCT("5402","JY","",0,1,1,"")

预收账款期末余额

=ACCT("2203","DY","",0,0,0,"")+ACCT("1122","DY","",0,0,0,"")+ACCT("5401","DY","",0,0,0,"")-ACCT("5402","DY","",0,0,0,"")

预收账款年初余额

=ACCT("2203","DC","",0,1,1,"")+ACCT("1122","DC","",0,1,1,"")+ACCT("5401","DY","",0,1,1,"")-ACCT("5402","DY","",0,1,1,"")

以上是基本思路，可以根据自己的需要进行调整。

追问

似乎不对啊，
例如：借：工程施工50
贷：银行50
借：银行100
贷：工程结算100
像ACCT("5401","JY","",0,0,0,"")-ACCT("5402","JY","",0,0,0,"")
=工程施工借方余额50-工程结算借方余额0=50（存货50？似乎不对啊）

Answer 2

这个就复杂了