1金蝶资产负债表公式知识讲解

金蝶资产负债表公式大全的计算公式(二)

金蝶资产负债表公式大全的计算公式(二)金蝶资产负债表公式大全的计算公式本文将列举金蝶资产负债表相关的计算公式，并且配以具体的例子进行解释说明。

1. 总资产计算公式总资产 = 资产合计计算公司的总资产时，只需将所有资产合计即可。

例如，一家公司的资产合计为1000万元，则总资产也为1000万元。

2. 总负债计算公式总负债 = 负债合计计算公司的总负债时，只需将所有负债合计即可。

例如，一家公司的负债合计为800万元，则总负债也为800万元。

3. 净资产计算公式净资产 = 总资产 - 总负债计算公司的净资产时，需要用总资产减去总负债。

例如，一家公司的总资产为1000万元，总负债为800万元，则净资产为200万元。

4. 总资产周转率计算公式总资产周转率 = 销售收入 / 总资产总资产周转率可以反映公司利用资产的效率。

例如，一家公司的销售收入为100万元，总资产为200万元，则总资产周转率为倍。

5. 资产负债率计算公式资产负债率 = 总负债 / 总资产资产负债率可以衡量公司的负债风险。

例如，一家公司的总负债为800万元，总资产为1000万元，则资产负债率为80%。

6. 净资产收益率计算公式净资产收益率 = 净利润 / 净资产净资产收益率可以反映公司对净资产的盈利能力。

例如，一家公司的净利润为20万元，净资产为200万元，则净资产收益率为10%。

7. 总资产收益率计算公式总资产收益率 = 净利润 / 总资产总资产收益率可以反映公司对总资产的盈利能力。

例如，一家公司的净利润为20万元，总资产为1000万元，则总资产收益率为2%。

8. 负债比率计算公式负债比率 = 总负债 / 净资产负债比率可以反映公司负债的比例。

例如，一家公司的总负债为500万元，净资产为200万元，则负债比率为倍。

9. 长期负债比率计算公式长期负债比率 = 长期负债 / 净资产长期负债比率可以衡量公司长期负债的比例。

例如，一家公司的长期负债为300万元，净资产为200万元，则长期负债比率为倍。

金蝶软件报表公式定义

资产负债表：货币资金年初数=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("220 3","","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("16 03","","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("17 03","","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("4104","","y","",0,0,0)+ACCT("4103","","y","",0,0,0)+ACCT("6001" ,"","y","",0,0,0)+ACCT("6051","","y","",0,0,0)-ACCT("6401","","y","",0,0,0 )-ACCT("6402","","y","",0,0,0)-ACCT("6403","","y","",0,0,0)-ACCT("6601", "","y","",0,0,0)-ACCT("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)+ACC T("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)利润表营业收入上期数＝=ACCT("6001","","SL","",-1.0,0,0)+ACCT("6051","","SL","",-1.0,0,0)营业收入本期数=ACCT("6001","","SL","",0,0,0)+ACCT("6051","","SL","",0,0,0)营业成本上期数=ACCT("6401","","SL","",-1.0,0,0)+ACCT("6402","","SL","",-1.0,0,0)营业成本本期数=ACCT("6401","","SL","",0,0,0)+ACCT("6402","","SL","",0,0,0)营业税金及附加上期数=ACCT("6403","","SL","",-1.0,0,0)营业税金及附加本期数= =ACCT("6403","","SL","",0,0,0)销售费用上期=ACCT("6601","","SL","",-1.0,0,0)销售费用本期=ACCT("6601","","SL","",0,0,0)管理费用上期数=ACCT("6602","","SL","",-1.0,0,0)管理费用本期数=ACCT("6602","","SL","",0,0,0)财务费用上期=ACCT("6603","","SL","",-1.0,0,0)精选文库财务费用本期=ACCT("6603","","SL","",0,0,0)资产减值损失=ACCT("6701","","SL","",-1.0,0,0)资产减值损失＝=ACCT("6701","","SL","",0,0,0)公允价值变动收益=ACCT("6101","","SL","",-1.0,0,0)公允价值变动收益=ACCT("6101","","SL","",0,0,0)投资收益=ACCT("6111","","SL","",-1.0,0,0)投资收益=ACCT("6111","","SL","",0,0,0)营业利润=E4-E5-E6-E7-E8-E9-E10+E11+E12营业利润=D4-D5-D6-D7-D8-D9-D10+D11+D12营业外收入=ACCT("6301","","SL","",-1.0,0,0)营业外收入＝ACCT("6301","","SL","",0,0,0)营业外支出=ACCT("6711","","SL","",-1.0,0,0)营业外支出=ACCT("6711","","SL","",0,0,0)利润总额=E14+E15-E16利润总额=D14+D15-D16所得税费用=ACCT("6801","","SL","",-1.0,0,0)所得税费用=ACCT("6801","","SL","",0,0,0)。

金蝶财务软件中资产负债表的应收应付,预付预收公式是怎么设置的？

金蝶财务软件中资产负债表的应收应付,预付预收公式是怎么设置的？一、金蝶财务软件中资产负债表的应收、应付、预付、预收账款项目公式为1、应收账款项目取应收账款的借方金额加上预收账款的借方金额；公式为ACCT（'1122','JY','',0,0,0,'')+ACCT（'2203','JY','',0,0,0,'')2、预付账款项目取预付账款的借方金额加上应付账款的借方金额；公式为ACCT（'1123','JY','',0,0,0,'')+ACCT（'2202','JY','',0,0,0,'') 有计提坏账准备的，上述公式中还应当减去相应的坏账准备金额。

3、应付账款项目取应付账款的贷方金额加上预付账款的贷方金额；(ACCT('1123','DY','',0,0,0,'')+ACCT('2202','DY','',0,0,0,'')4、预收账款项目取预收账款的贷方金额加上应收账款的贷方金额；公式为(ACCT('1122','DY','',0,0,0,'')+ACCT('2203','DY','',0,0,0,'')二、按照《企业会计准则-应用指南》（财务报表列报）规定，资产负债表中的1、“应收账款”项目，应根据“应收账款”和“预收账款”科目所属各明细科目的期末借方余额合计数，减去“坏账准备”科目中有关应收账款计提的坏账准备期末余额后的金额填列；2、“预付款项”项目，应根据“预付账款”和“应付账款”科目所属各明细科目的期末借方余额合计数，减去“坏账准备”科目中有关预付款职计提的坏账准备期末余额后的金额填列；3、“应付账款”项目，应根据“应付账款”和“预付账款”科目所属各明细科目的期末贷方余额合计数填列；4、“预收款项”项目，应根据“预收账款”和“应收账款”科目所属各明细科目的期末贷方余额合计数填列。

金蝶报表公式

精品文档
C 期初余额
JC 借方期初余额
DC 贷方期初余额
AC 期初绝对余额
Y 期末余额
JY 借方期末余额
DY 贷方期末余额
AY 期末绝对余额
JF 借方发生额
DF 贷方发生额
JL 借方本年累计发生额
DL 贷方本年累计发生额
SY 损益表本期实际发生额
SL 损益表本年实际发生额
B 取科目预算数据
处理方法：
1、打开报表与分析中的资产负债表，选择菜单中的属性T报表属性；
2、打开“报表属性”7“页眉页脚” T选择需要编辑的栏目T点击“编辑页眉页脚”，
如下图；
3、在“单位名称：”后输入“长沙某软件有限公司”,在分段符“ | ”后输入取数公式：
“ &［会计年度］年&［报表期间］月&［最大日期］日”，完成后点击“确定”即可保存。

如下图所示：日期取数公式：
年：&［会计年度］
月：&［报表期间］
日：&［最大日期］
在对应的公式后加入对应的单位即可。

完整的公式为：“ &［［会计年度］年&［报表期间］月&［最大日期］日
“ | ”为分段符，可以将一行分成N 段。

4、最后，退出报表时记得点击保存。

金蝶资产负债表公式大全的计算公式(一)

金蝶资产负债表公式大全的计算公式(一)金蝶资产负债表公式大全的计算公式1. 总资产（Total Assets）•总资产 = 资产负债表中资产项目的总和例如：公司A的资产负债表中，固定资产（Fixed Assets）为100万，流动资产（Current Assets）为200万，总资产 = 100万 + 200万 = 300万。

2. 总负债（Total Liabilities）•总负债 = 资产负债表中负债项目的总和例如：公司A的资产负债表中，短期负债（Short-term Liabilities）为50万，长期负债（Long-termLiabilities）为150万，总负债 = 50万 +150万 = 200万。

3. 权益（Equity）•权益 = 总资产 - 总负债例如：公司A的总资产为300万，总负债为200万，权益 = 300万 - 200万 = 100万。

4. 总营业收入（Total Revenue）•总营业收入 = 资产负债表中营业收入（Operating Revenue）的总和例如：公司A的资产负债表中，销售收入（Sales Revenue）为80万，其他营业收入（Other Operating Revenue）为20万，总营业收入 = 80万 + 20万 = 100万。

5. 总营业成本（Total Expenses）•总营业成本 = 资产负债表中营业成本（Cost of Goods Sold）的总和例如：公司A的资产负债表中，原材料成本（Raw Material Cost）为30万，人工成本（Labor Cost）为20万，总营业成本 = 30万 + 20万 = 50万。

6. 净利润（Net Profit）•净利润 = 总营业收入 - 总营业成本例如：公司A的总营业收入为100万，总营业成本为50万，净利润 = 100万 - 50万 = 50万。

7. 总资产周转率（Total Asset Turnover）•总资产周转率 = 总营业收入 / 总资产例如：公司A的总营业收入为100万，总资产为300万，总资产周转率 = 100万 / 300万 = 。

金蝶软件资产负债表计算公式(二)

金蝶软件资产负债表计算公式(二)金蝶软件资产负债表计算公式在金蝶软件财务报表中，资产负债表是企业财务状况的重要指标之一。

以下是金蝶软件资产负债表中的一些常用计算公式：1. 总资产计算公式总资产 = 货币资金 + 交易性金融资产 + 应收票据 + 应收账款+ 预付账款 + 其他应收款 + 存货 + 待摊费用 + 一年内到期的非流动资产 + 其他流动资产 + 可供出售金融资产 + 持有至到期投资 +长期应收款 + 长期股权投资 + 投资性房地产 + 固定资产 + 在建工程 + 工程物资 + 固定资产清理 + 生产性生物资产 + 油气资产 + 无形资产 + 开发支出 + 商誉 + 长期待摊费用 + 递延所得税资产 + 其他非流动资产举例说明：假设某企业的资产负债表中，货币资金为500,000元，应收账款为300,000元，存货为200,000元，固定资产为600,000元，其他流动资产为100,000元，递延所得税资产为50,000元。

那么，该企业的总资产计算如下：总资产 = 500,000 + 300,000 + 200,000 + 600,000 + 100,000 + 50,000 = 1,750,000元2. 总负债计算公式总负债 = 短期借款 + 应付票据 + 应付账款 + 预收账款 + 其他应付款 + 实收资本（或股本） + 资本公积 + 盈余公积 + 未分配利润 + 长期借款 + 一年内到期的非流动负债 + 其他流动负债 + 长期应付款 + 长期应付职工薪酬 + 专项应付款 + 预计负债 + 递延所得税负债 + 其他非流动负债举例说明：假设某企业的资产负债表中，短期借款为200,000元，应付账款为100,000元，预收账款为50,000元，未分配利润为300,000元，长期借款为500,000元。

那么，该企业的总负债计算如下：总负债 = 200,000 + 100,000 + 50,000 + 300,000 + 500,000 = 1,150,000元3. 净资产计算公式净资产 = 总资产 - 总负债举例说明：继续以上例子，该企业的净资产计算如下：净资产 = 1,750,000 - 1,150,000 = 600,000元4. 负债率计算公式负债率 = （总负债 / 总资产） * 100举例说明：继续以上例子，该企业的负债率计算如下：负债率 = （1,150,000 / 1,750,000）* 100 ≈ %5. 资产负债表期末的总额应等于资产负债表期初的总额资产负债表期末总额 = 资产负债表期初总额举例说明：若某企业在年初的资产负债表总额为1,500,000元，那么在年末的资产负债表总额也应为1,500,000元。

金蝶软件报表公式定义

资产负债表: 货币资金年初数二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("220 3","","JC","",0,1,1)应收账款期末数=ACCT("1122","","J Y","",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","","J Y","",0,0,0)+ACCT("2202","","J Y","",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("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("16 03","","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("2203","","D Y","",0,0,0)+ACCT("1122","","D Y","",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(I3O:I31)-I32+I33+I34所有者权益期末数二SUM(H30:H31)-H32+H33+H34未分配利润二ACCT("4104","","NC","",0,1,1)+ACCT("4103","","NC","",0,1,1)未分配利润期末数二ACCT("4104","","y","",0,0,0)+ACCT("4103","","y","",0,0,0)+ACCT("6001","","y","",0,0,0)+ACCT("6051","","y","",0,0,0)-ACCT("6401","","y","",0,0 ,0)-ACCT("6402","","y","",0,0,0)-ACCT("6403","","y","",0,0,0)-ACCT("6601","”,"y","",0,0,0)-ACCT("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)+ACC"，”NC","",0,1,1)-ACCT("1407","","NC","",0,1,1)存货期末数=二ACCT("1401:1406",""," Y","",0,0,0)-ACCT("1471","","Y","",O,O,O)+ACCT(”5001",""," Y","",0,0,0)+ACCT("1408",""," Y","",0,0,0)+ACCT("1411","","Y "，”",0,0,0)-ACCT("1407","","Y ","",0,0,0)利润表营业收入上期数=二ACCT("6001","","SL","",-1.0,0,0)+ACCT("6051","","SL","",-1.0,0,0)营业收入本期数=ACCT("6001","","SL","",0,0,0)+ACCT("6051","","SL","",0,0,0)营业成本上期数=ACCT("6401","","SL","",-1.0,0,0)+ACCT("6402","","SL","",-1.0,0,0)营业成本本期数=ACCT("6401","","SL","",0,0,0)+ACCT("6402","","SL","",0,0,0)营业税金及附加上期数二ACCT("6403","","SL","",-1.0,0,0)营业税金及附加本期数二=ACCT("6403","","SL","",0,0,0)销售费用上期=ACCT("6601","","SL","",-1.0,0,0)销售费用本期=ACCT("6601","","SL","",0,0,0)管理费用上期数=ACCT("6602","","SL","",-1.0,0,0)管理费用本期数=ACCT("6602","","SL","",0,0,0)财务费用上期=ACCT("6603","","SL","",-1.0,0,0)财务费用本期二ACCT("6603","","SL","",0,0,0)资产减值损失二ACCT("6701","","SL","",-1.0,0,0)资产减值损失=二ACCT("6701","","SL","",0,0,0)公允价值变动收益二ACCT("6101","","SL","",-1.0,0,0) 公允价值变动收益二ACCT("6101","","SL","",0,0,0) 投资收益二ACCT("6111","","SL","",-1.0,0,0)投资收益二ACCT("6111","","SL","",0,0,0)营业利润二E4-E5-E6-E7-E8-E9-E10+E11+E12营业利润二D4-D5-D6-D7-D8-D9-D10+D11+D12营业外收入二ACCT("6301","","SL","",-1.0,0,0)营业外收入=ACCT("6301","","SL","",0,0,0)营业外支出二ACCT("6711","","SL","",-1.0,0,0)营业外支出二ACCT("6711","","SL","",0,0,0)利润总额二E14+E15-E16利润总额二D14+D15-D16所得税费用二ACCT("6801","","SL","",-1.0,0,0)所得税费用二ACCT("6801","","SL","",0,0,0)。

金蝶资产负债表公式设置

应付利息
38
应付股利
39
其他应付款
40 =ACCT("2241","C","",0,"1",0,"="A)CCT("2241")
预提费用
41
一年内到期的非流动负债 42
其他流动负债
43
流动负债合计
=SUM(G3:G15)
=SUM(H3:H15)
非流动负债：
长期借款
44
应付债券
45
长期应付款
46
专项应付款
负债和股东权益总计
51 =ACCT("4001","C","",0,"1",0,"="A)CCT("4001","Y","",0,0,0,"")
52 =ACCT("4002","C","",0,"1",0,"="A)CCT("4002","Y","",0,0,0,"")
53
54 =ACCT("4101","C","",0,"1",0,"="A)CCT("4101","Y","",0,0,0,"")
资
产
行次
年初数
期末数
流动资产：
货币资金
1 =ACCT("1001:1012","C","",0,"1",0,"="A)CCT("1001:1012","Y","",0,0,0,"")

金蝶资产负债表利润表取数详细说明

（一）科目取数公式=<科目代码1：科目代码2>[＄币别][.SS][@n]或=<科目代码1：科目代码2>[＄币别][.SS][@(y，p)]参数说明：科目代码1：科目代码2：会计科目代码范围。

“：科目代码2”可以省略。

币别：币别代码，如RMB。

省略为综合本位币。

SS：取数标志，省略为本期期末余额。

C 期初余额JC 借方期初余额DC 贷方期初余额AC 期初绝对余额Y 期末余额JY 借方期末余额DY 贷方期末余额AY 期末绝对余额JF 借方发生额DF 贷方发生额JL 借方本年累计发生额DL 贷方本年累计发生额SY 损益表本期实际发生额SL 损益表本年实际发生额B 取科目预算数据TC 折合本位币期初余额TJC 折合本位币借方期初余额TDC 折合本位币贷方期初余额TAC 折合本位币期初绝对余额TY 折合本位币期末余额TJY 折合本位币借方期末余额TDY 折合本位币贷方期末余额TAY 折合本位币期初绝对余额TJF 折合本位币借方发生额TDF 折合本位币贷方发生额TJL 折合本位币借方本年累计发生额TDL 折合本位币贷方本年累计发生额TSY 折合本位币损益表本期实际发生额TSL 折合本位币损益表本年实际发生额n：会计期间。

(若0：本期，-1：上一期，-2：上两期，...)，省略为本期。

y：会计年份。

(若0：本年，-1：前一年，-2：前两年，...)p：指定年份的会计期间。

（二）核算项目取数核算项目取数，与科目取数公式兼容。

公式描述如下：=<科目代码1：科目代码2|项目类别|项目代码1：项目代码2>＄币别.ss@n或=<科目代码1：科目代码2|项目类别|项目代码1：项目代码2>＄币别.ss@(y，p)取数公式中除“<>”内有所区别，其余与科目取数中的描述完全相同。

下面只针对“<>”中的内容进行补充说明：“<>”中内容用于选择科目和核算项目，公式中的科目代码，项目类别和项目代码，在字符“|”和“：”的分隔下可以进行20种组合，得到不同范围的科目和核算项目。

金蝶软件资产负债表

资产负债表：货币资金年初数=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("4104","","y","",0,0,0)+ACCT("4103","","y","",0,0,0)+ACCT("6001","","y","",0,0,0)+ACCT("6051","","y","",0 ,0,0)-ACCT("6401","","y","",0,0,0)-ACCT("6402","","y","",0,0,0)-ACCT("6403","","y","",0,0,0)-ACCT("6601","","y"," ",0,0,0)-ACCT("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)+A CCT("1408","","Y","",0,0,0)+ACCT("1411","","Y","",0,0,0)-ACCT("1407","","Y","",0,0,0)。

金蝶标准版资产负债表公式

金蝶标准版资产负债表公式在金蝶标准版财务软件中，资产负债表是财务报表中的重要组成部分，它反映了企业在特定日期的资产、负债和所有者权益的情况。

编制资产负债表需要按照一定的公式和规定进行，下面我们就来详细介绍金蝶标准版资产负债表的公式及相关内容。

首先，资产负债表的基本公式为：资产总额 = 负债总额 + 所有者权益。

这是资产负债表的基本平衡公式，表明了资产总额等于负债总额加上所有者权益。

在金蝶标准版财务软件中，资产负债表还包括了许多具体的项目和公式，比如流动资产、非流动资产、流动负债、非流动负债等。

下面我们将分别介绍这些项目的公式和相关内容。

流动资产的公式为：流动资产 = 现金及现金等价物 + 应收账款 + 存货 + 其他流动资产。

流动资产是指企业在一年内能够变现或消耗的资产，包括现金、应收账款、存货等。

这些资产的公式可以通过金蝶标准版财务软件进行填写和计算，以便及时了解企业的流动资金状况。

非流动资产的公式为：非流动资产 = 长期投资 + 固定资产 + 无形资产 + 其他非流动资产。

非流动资产是指企业在一年以上能够变现或消耗的资产，包括长期投资、固定资产、无形资产等。

这些资产的公式同样可以通过金蝶标准版财务软件进行填写和计算，以便全面了解企业的非流动资产情况。

流动负债的公式为：流动负债 = 短期借款 + 应付账款 + 应付职工薪酬 + 其他流动负债。

流动负债是指企业在一年内需要偿还的债务，包括短期借款、应付账款、应付职工薪酬等。

这些负债的公式同样可以通过金蝶标准版财务软件进行填写和计算，以便及时了解企业的流动负债状况。

非流动负债的公式为：非流动负债 = 长期借款 + 应付债券 + 递延所得税负债 + 其他非流动负债。

非流动负债是指企业在一年以上需要偿还的债务，包括长期借款、应付债券、递延所得税负债等。

这些负债的公式同样可以通过金蝶标准版财务软件进行填写和计算，以便全面了解企业的非流动负债情况。

通过金蝶标准版财务软件编制资产负债表，可以更加方便快捷地计算和填写各项公式，及时了解企业的资产、负债和所有者权益情况。

金蝶资产负债表公式设置

开发支出
商誉
长期待摊费用
递延所得税资产
其他非流动资产
非流动资产合计
资产总计
行次
年初数
期末数
1 2 3 4
=ACCT("1001:1012","C","",0,"1",0 =ACCT("1001:1012",
,"") =ACCT("1101","C","",0,"1",0,"") ==AACCCCTT((""11112212"",,""CC"",,"""",,00,,""11"",,00,,""""))-
资
产
流动资产：
货币资金
交易性金融资产
应收票据
应收账款
预付款项
应收利息
应收股利
其他应收款
存货
其中：库存商品
待摊费用一年内到期的非流动资
产其他流动资产
流动资产合计
非流动资产：
可供出售金融资产
持有至到期投资
长期应收款
长期股权投资
投资性房地产
固定资产
在建工程
工程物资
固定资产清理
生产性生物资产
油气资产
无形资产
53
54 55 56
=ACCT("4101","C","",0,"1",0, "="A)CCT("4101.01","C","",0,"1"

金蝶资产负债表公式设置

17投资性房地产18 Nhomakorabea固定资产
19 =ACCT("1601","C","",0,"1",0,"")-AC=CATC(C"T1(6"0126"0,1""C,"",Y""",,"0",,"01,"0,,00,,""""))--AACCCCTT((""11660032"",,""CY"",,"""",,00,,"01,"0,
30
非流动资产合计
=SUM(C18:C34)
=SUM(D18:D34)
资产总计
=C16+C35
=D16+D35
负债和股东权益
行次
年初数
期末数
流动负债：
短期借款
31
交易性金融负债
32
应付票据
33 =ACCT("2201","C","",0,"1",0,"="A)CCT("2201","Y","",0,0,0,"")
55 =ACCT("4101.01","C","",0,"1",=0A,C"C"T)("4101.01","Y","",0,0,0,"")

金蝶软件应交税费资产负债表公式设置

金蝶软件应交税费资产负债表公式设置
分别双击该单元格，输入以下公式后，出车!
▲(以下用3位科目代码举例，自可复制，粘贴过去，或修改为4位科目代码后，再回车!)
期初数(列)公式。

如：1)货币资金取数;2)单个科目取数公式，自行修改科目代码
=<101:102>.C@1
=<120>.C@1
期末数(列)公式。

如：1)货币资金取数;2)通常单个科目取数公式
=<101:102>
=<120>
金蝶软件应交税费资产负债表公式相关阅读延伸：
金蝶软件资产负债表公式怎么设置?
报表上方有个“向导”，点向导
1、选取科目
2、选好数据(选期初余额、期末余额、本期损益实际发生额)。

金蝶资产负债表其他流动资产公式(一)

金蝶资产负债表其他流动资产公式(一)金蝶资产负债表其他流动资产公式1. 前言在金蝶资产负债表中，其他流动资产是指公司在经营过程中所拥有的除现金、银行存款、短期投资和应收账款以外的流动资产。

这些资产包括但不限于存货、预付款项、应收票据、其他应收款等。

其他流动资产能够反映出公司在短期内可变现的资产情况，对公司的资金流动和经营能力有着重要的影响。

2. 公式1: 其他流动资产总额其他流动资产总额是指公司所有其他流动资产的累计总额。

计算公式如下：其他流动资产总额 = 存货 + 预付款项 + 应收票据 + 其他应收款 + ...举例说明：假设公司A的存货价值为1000万元，预付款项为200万元，应收票据为300万元，其他应收款为150万元。

那么公司A的其他流动资产总额为1000+200+300+150=1650万元。

3. 公式2: 存货存货是指公司在经营过程中为了销售或者生产商品而持有的物品。

存货可以分为原材料、在产品、产成品等多种类型。

计算公式如下：存货 = 原材料 + 在产品 + 产成品 + ...举例说明：假设公司B的原材料价值为500万元，在产品的价值为200万元，产成品的价值为800万元。

那么公司B的存货价值为500+200+800=1500万元。

4. 公式3: 预付款项预付款项是指公司在交易中提前支付的款项，以便获取商品或服务。

预付款项通常是由于采购或合作等原因而预付给供应商或合作伙伴的款项。

计算公式如下：预付款项 = 付款1 + 付款2 + 付款3 + ...举例说明：假设公司C在购买原材料时，提前向供应商支付了300万元，还向合作伙伴支付了100万元的费用。

那么公司C的预付款项为300+100=400万元。

5. 公式4: 应收票据应收票据是指公司因销售商品或提供服务而产生的应收账款，以票据形式表现。

应收票据通常包括银行承兑汇票、商业承兑汇票等形式。

计算公式如下：应收票据 = 票据1 + 票据2 + 票据3 + ...举例说明：假设公司D因销售商品而形成的应收票据有100万元和200万元两张。

金蝶软件报表公式定义

金蝶软件报表公式定义资产负债表：货币资金年初数=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("4104","","y","",0,0,0)+ACCT("4103","","y","",0,0,0)+ ACCT("6001","","y","",0,0,0)+ACCT("6051","","y","",0,0,0)-ACCT("6401","","y","",0,0,0)-ACCT("6402","","y","",0,0,0)-ACCT("6403","","y","",0,0,0)-ACCT("6601","","y","",0,0,0)-ACCT("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)+A CCT("1411","","Y","",0,0,0)-ACCT("1407","","Y","",0,0, 0) 利润表营业收入上期数＝=ACCT("6001","","SL","",-1.0,0,0)+ACCT("6051","","SL","",-1 .0,0,0)营业收入本期数=ACCT("6001","","SL","",0,0,0)+ACCT("6051","","SL","",0,0,0 ) 营业成本上期数=ACCT("6401","","SL","",-1.0,0,0)+ACCT("6402","","SL","",-1 .0,0,0)营业成本本期数=ACCT("6401","","SL","",0,0,0)+ACCT("6402","","SL","",0,0,0 ) 营业税金及附加上期数=ACCT("6403","","SL","",-1.0,0,0)营业税金及附加本期数= =ACCT("6403","","SL","",0,0,0)销售费用上期=ACCT("6601","","SL","",-1.0,0,0)销售费用本期=ACCT("6601","","SL","",0,0,0)管理费用上期数=ACCT("6602","","SL","",-1.0,0,0)管理费用本期数=ACCT("6602","","SL","",0,0,0)财务费用上期=ACCT("6603","","SL","",-1.0,0,0)财务费用本期=ACCT("6603","","SL","",0,0,0)资产减值损失=ACCT("6701","","SL","",-1.0,0,0)资产减值损失＝=ACCT("6701","","SL","",0,0,0)公允价值变动收益=ACCT("6101","","SL","",-1.0,0,0)公允价值变动收益=ACCT("6101","","SL","",0,0,0) 投资收益=ACCT("6111","","SL","",-1.0,0,0)投资收益=ACCT("6111","","SL","",0,0,0)营业利润=E4-E5-E6-E7-E8-E9-E10+E11+E12营业利润=D4-D5-D6-D7-D8-D9-D10+D11+D12营业外收入=ACCT("6301","","SL","",-1.0,0,0)营业外收入＝ACCT("6301","","SL","",0,0,0)营业外支出=ACCT("6711","","SL","",-1.0,0,0)营业外支出=ACCT("6711","","SL","",0,0,0)利润总额=E14+E15-E16利润总额=D14+D15-D16所得税费用=ACCT("6801","","SL","",-1.0,0,0)所得税费用=ACCT("6801","","SL","",0,0,0)。