金蝶软件报表公式定义
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
资产负债表：
货币资金年初数=ACCT("1001:1012","","NC","",0,1,1)
货币资金期末数=ACCT("1001:1012","","Y","",0,0,0)
交易性金融资产年初数=ACCT("1101","","NC","",0,1,1)
交易性金融资产期末数=ACCT("1101","","Y","",0,0,0)
应收账款年初数
=ACCT("1122","","JC","",0,1,1)-ACCT("1231","","NC","",0,1,1 )+ACCT("2203","","JC","",0,1,1)
应收账款期末数
=ACCT("1122","","JY","",0,0,0)-ACCT("1231","","Y","",0,0,0) +ACCT("2203","","JY","",0,0,0)
预付款项年初数
=ACCT("1123","","JC","",0,1,1)+ACCT("2202","","JC","",0,1,1 )
预付款项期末数
=ACCT("1123","","JY","",0,0,0)+ACCT("2202","","JY","",0,0,0 )
持有至到期投资年初数
=ACCT("1501","","NC","",0,1,1)-ACCT("1502","","NC","",0,1,1 )
持有至到期投资期末数
=ACCT("1501","","Y","",0,0,0)-ACCT("1502","","Y","",0,0,0)
=ACCT("1531","","NC","",0,1,1)-ACCT("1532","","NC","",0,1,1 )
长期应收款期末数
=ACCT("1531","","Y","",0,0,0)-ACCT("1532","","Y","",0,0,0)长期股权投资年初数
=ACCT("1511","","NC","",0,1,1)-ACCT("1512","","NC","",0,1,1 )
长期股权投资期末数
==ACCT("1511","","Y","",0,0,0)-ACCT("1512","","Y","",0,0,0)固定资产年初据
=ACCT("1601","","NC","",0,1,1)-ACCT("1602","","NC","",0,1,1 )-ACCT("1603","","NC","",0,1,1)
固定资产期末据
=ACCT("1601","","Y","",0,0,0)-ACCT("1602","","Y","",0,0,0)-ACCT("1603","","Y","",0,0,0)
无形资产年初数
=ACCT("1701","","NC","",0,1,1)-ACCT("1702","","NC","",0,1,1 )-ACCT("1703","","NC","",0,1,1)
无形资产期末数
=ACCT("1701","","Y","",0,0,0)-ACCT("1702","","Y","",0,0,0)-ACCT("1703","","Y","",0,0,0)
=ACCT("2202","","DC","",0,1,1)+ACCT("1123","","DC","",0,1,1 )
应付账款期末数
=ACCT("2202","","DY","",0,0,0)+ACCT("1123","","DY","",0,0,0 )
预收款项年初
=ACCT("2203","","DC","",0,1,1)+ACCT("1122","","DC","",0,1,1 )
预收款项期末
=ACCT("2203","","DY","",0,0,0)+ACCT("1122","","DY","",0,0,0 )
长期应付款年初数
=ACCT("2701","","NC","",0,1,1)-ACCT("2702","","NC","",0,1,1 )
长期应付款期末数
=ACCT("2701","","Y","",0,0,0)-ACCT("2702","","Y","",0,0,0)所有者权益年初数=SUM(I30:I31)-I32+I33+I34
所有者权益期末数=SUM(H30:H31)-H32+H33+H34未分配利润=ACCT("4104","","NC","",0,1,1)+ACCT("4103","","NC","",0,1,1 )
未分配利润期末数
ACCT("6001","","y","",0,0,0)+ACCT("6051","","y","",0,0,0)-A CCT("6401","","y","",0,0,0)-ACCT("6402","","y","",0,0,0)-AC CT("6403","","y","",0,0,0)-ACCT("6601","","y","",0,0,0)-ACC T("6602","","y","",0,0,0)-ACCT("6603","","y","",0,0,0)-ACCT ("6701","","y","",0,0,0)+ACCT("6101","","y","",0,0,0)+ACCT( "6111","","y","",0,0,0)+ACCT("6301","","y","",0,0,0)-ACCT(" 6711","","y","",0,0,0)-ACCT("6801","","y","",0,0,0)
存货年初数
=ACCT("1401:1406","","NC","",0,1,1)-ACCT("1471","","NC","", 0,1,1)+ACCT("5001","","NC","",0,1,1)+ACCT("1408","","NC","" ,0,1,1)+ACCT("1411","","NC","",0,1,1)-ACCT("1407","","NC"," ",0,1,1)
存货期末数＝
=ACCT("1401:1406","","Y","",0,0,0)-ACCT("1471","","Y","",0, 0,0)+ACCT("5001","","Y","",0,0,0)+ACCT("1408","","Y","",0,0 ,0)+ACCT("1411","","Y","",0,0,0)-ACCT("1407","","Y","",0,0, 0)
利润表
营业收入上期数＝