金蝶资产负债表公式大全

金蝶资产负债表公式大全

1、例如金蝶K3会计科目1122-应收账款,下设有明细科目1122.01-内销和1122.02-外销,两个明细科目都挂有核算项目类别"客户",本期在总账中科目余额表的数据显示如图所示:金蝶K3中,公式ACCT("1122","JY","",0,0,0,"")=1122-应收账款科目中各明细科目的借方期末余额之和,明细科目中1122.01-内销的期末借方余额10,所以公式ACCT("1122","JY","",0,0,0,"")=102、金蝶K3中,公式ACCT("1122","DY","",0,0,0,"")=1122-应收账款科目中各明细科目的期末贷方余额之和,明细科目中1122.02-外销的期末贷方余额50,所以公式ACCT("1122","DY","",0,0,0,"")=50.

2、3、金蝶K3中,公式ACCT("1122|客户|","JY","",0,0,0,"")=1122-应收账款科目下各个核算项目客户的期末借方余额之和(参照图-2).

3、客户A 在明细科目1122.01-内销下的期末借方余额是60,在明细科目1122.02-外销下的期末贷方余额是30,借贷相抵,客户A 的期末借方余额为30.

4、所以公式ACCT("1122|客户|","JY","",0,0,0,"")=客户A 的期末借方余额30 +客户C 的期末借方余额80,即公式ACCT("1122|客户|","JY","",0,0,0,"")=110.

5、4、金蝶K3中,公式ACCT("1122.01:1122.02","JY","",0,0,0,"")=ACCT("1122.01","JY","",0,0,0,"")+ACCT("1122.02","JY","",0,0,0,"").

6、5、金蝶K3中,公式ACCT("1122.01:1122.02","DY","",0,0,0,"")=ACCT("1122.01","DY","",0,0,0,"")+ACCT("1122.02","DY","",0,0,0,"").

7、6、金蝶K3中,公式ACCT("1122.01:1122.02| 客户|","JY","",0,0,0,"")=ACCT("1122.01| 客户|","JY","",0,0,0,"") +ACCT("1122.02| 客户|","JY","",0,0,0,"") (参照图-2).

8、在明细科目1122.01-内销下,客户A期末借方余额为60.

9、在明细科目1122.02-外销下,客户C 期末借方余额为80.

10、所以ACCT("1122.01:1122.02|客户|","JY","",0,0,0,"")=60+80=140.

11、7、ACCT("1122.01:1122.02| 客户|","DY","",0,0,0,"") 表示为ACCT("1122.01| 客户|","DY","",0,0,0,"") +ACCT("1122.02| 客户|","DY","",0,0,0,"") 之和(参照图-2).

12、在明细科目1122.01-内销下,客户B期末贷方余额为50.

13、在明细科目1122.02-外销下,客户A 期末借方余额为30.

14、客户D 期末贷方余额为100,所以ACCT("1122.01:1122.02|客户|","JY","",0,0,0,"")=50+30+100=180.

15、扩展资料:金蝶K3报表取数公式详解C表示期初余额.

16、JC表示借方期初余额.

17、DC表示贷方期初余额.

18、AC表示期初绝对余额.

19、Y期末余额.

20、JY表示借方期末余额.

21、DY表示贷方期末余额.

22、AY表示期末绝对余额.

23、JF表示借方发生额.

24、DF表示贷方发生额.

25、JL表示借方本年累计发生额.

26、DL表示贷方本年累计发生额.

27、SY表示损益本期实际发生额.

本文介绍了金蝶资产负债表公式大全是怎样的.作为一名单位的财务人员,首先需要搞清楚自己单位使用的是哪种财务软件,之后就需要熟练的掌握这款财务软件的操作,具体的金蝶资产负债表的公式本文已经给出了介绍,希望你能够认真的掌握一下,这样可以让你的操作事半功倍.