人人范文网 范文大全

金蝶软件报表公式定义

发布时间:2020-03-03 23:23:46 来源:范文大全 收藏本文 下载本文 手机版

资产负债表:

货币资金年初数=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)+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)

金蝶软件如何定义报表的单位名称和报表日期

金蝶软件介绍

金蝶软件实验报告

三亚金蝶软件

金蝶软件怎样在报表里面设置单位名称和日期?

金蝶软件安装方法

金蝶软件操作流程

会计软件(金蝶、管家婆)

学习金蝶软件心得

金蝶软件系列简介

金蝶软件报表公式定义
《金蝶软件报表公式定义.doc》
将本文的Word文档下载到电脑,方便编辑。
推荐度:
点击下载文档
点击下载本文文档