金蝶软件报表公式定义

金蝶软件公式定义 资产负债表: 货币资金年初数=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) 长期应收款期末数 colors, graphics, and text that represents the type of terminal equipment. Installation of cabinets, racks, wiring devices shields and metal pipes, wire grounding should comply with the design requirements for tank use, grounding and should maintain a good electrical connection. Completion of the project completion and acceptance of information according to the following requirements for the preparation of technical documents. After the project is completed, construction unit should prior to project acceptance, completion of technical information to the unit. Integrated wiring system for completion of technical information should include the following: installation work; Equipment, equipment list; Changes in drawings for construction after the completion of construction plans; Test records (the Chinese should be used); Engineering changes, inspection records and during the construction, design or related measures of change, by between building, design and construction of units on both sides of the negotiations; Checked and recorded; Concealed work record; The budget of the project. Complete technical documentation to ensure quality, neat in appearance and content is complete, accurate data. Unqualified items found in the acceptance, by the inspection body should be identified, responsibility, and to propose solutions. Project completion acceptance, acceptance steps preparations prior to acceptance, acceptance of the preparatory work should be carried out, including: ? collecting engineering data, classification filing these technical materials including: System =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) 预收款项年初 colors, graphics, and text that represents the type of terminal equipment. Installation of cabinets, racks, wiring devices shields and metal pipes, wire grounding should comply with the design requirements for tank use, grounding and should maintain a good electrical connection. Completion of the project completion and acceptance of information according to the following requirements for the preparation of technical documents. After the project is completed, construction unit should prior to project acceptance, completion of technical information to the unit. Integrated wiring system for completion of technical information should include the following: installation work; Equipment, equipment list; Changes in drawings for construction after the completion of construction plans; Test records (the Chinese should be used); Engineering changes, inspection records and during the construction, design or related measures of change, by between building, design and construction of units on both sides of the negotiations; Checked and recorded; Concealed work record; The budget of the project. Complete technical documentation to ensure quality, neat in appearance and content is complete, accurate data. Unqualified items found in the acceptance, by the inspection body should be identified, responsibility, and to propose solutions. Project completion acceptance, acceptance steps preparations prior to acceptance, acceptance of the preparatory work should be carried out, including: ? collecting engineering data, classification filing these technical materials including: System =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","colors, graphics, and text that represents the type of terminal equipment. Installation of cabinets, racks, wiring devices shields and metal pipes, wire grounding should comply with the design requirements for tank use, grounding and should maintain a good electrical connection. Completion of the project completion and acceptance of information according to the following requirements for the preparation of technical documents. After the project is completed, construction unit should prior to project acceptance, completion of technical information to the unit. Integrated wiring system for completion of technical information should include the following: installation work; Equipment, equipment list; Changes in drawings for construction after the completion of construction plans; Test records (the Chinese should be used); Engineering changes, inspection records and during the construction, design or related measures of change, by between building, design and construction of units on both sides of the negotiations; Checked and recorded; Concealed work record; The budget of the project. Complete technical documentation to ensure quality, neat in appearance and content is complete, accurate data. Unqualified items found in the acceptance, by the inspection body should be identified, responsibility, and to propose solutions. Project completion acceptance, acceptance steps preparations prior to acceptance, acceptance of the preparatory work should be carried out, including: ? collecting engineering data, classification filing these technical materials including: System ","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) colors, graphics, and text that represents the type of terminal equipment. Installation of cabinets, racks, wiring devices shields and metal pipes, wire grounding should comply with the design requirements for tank use, grounding and should maintain a good electrical connection. Completion of the project completion and acceptance of information according to the following requirements for the preparation of technical documents. After the project is completed, construction unit should prior to project acceptance, completion of technical information to the unit. Integrated wiring system for completion of technical information should include the following: installation work; Equipment, equipment list; Changes in drawings for construction after the completion of construction plans; Test records (the Chinese should be used); Engineering changes, inspection records and during the construction, design or related measures of change, by between building, design and construction of units on both sides of the negotiations; Checked and recorded; Concealed work record; The budget of the project. Complete technical documentation to ensure quality, neat in appearance and content is complete, accurate data. Unqualified items found in the acceptance, by the inspection body should be identified, responsibility, and to propose solutions. Project completion acceptance, acceptance steps preparations prior to acceptance, acceptance of the preparatory work should be carried out, including: ? collecting engineering data, classification filing these technical materials including: System 财务费用本期=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) colors, graphics, and text that represents the type of terminal equipment. Installation of cabinets, racks, wiring devices shields and metal pipes, wire grounding should comply with the design requirements for tank use, grounding and should maintain a good electrical connection. Completion of the project completion and acceptance of information according to the following requirements for the preparation of technical documents. After the project is completed, construction unit should prior to project acceptance, completion of technical information to the unit. Integrated wiring system for completion of technical information should include the following: installation work; Equipment, equipment list; Changes in drawings for construction after the completion of construction plans; Test records (the Chinese should be used); Engineering changes, inspection records and during the construction, design or related measures of change, by between building, design and construction of units on both sides of the negotiations; Checked and recorded; Concealed work record; The budget of the project. Complete technical documentation to ensure quality, neat in appearance and content is complete, accurate data. Unqualified items found in the acceptance, by the inspection body should be identified, responsibility, and to propose solutions. Project completion acceptance, acceptance steps preparations prior to acceptance, acceptance of the preparatory work should be carried out, including: ? collecting engineering data, classification filing these technical materials including: System