- 阿啵呲嘚
-
问题中提到两个大步骤:
第一,设置取数公式
第二,生成报表数据
以下为详细解析步骤:
一、设置取数公式也就是设置报表公式
1、首先,打开一张报表。
在这里,以一张资产负债表为例。
将报表的状态换成“格式”状态,如下图
2、选中要设置的科目,在这里演示“短期借款”这个科目期末余额的设置,
先选中D4这个单元格,然后点击上面的“fx”按钮,如下图所示:
3、这时,就会弹出“定义公式”对话框,如下图所示:
4、输入公式,要取的值是短期借款的期末余额,所以要用期末函数
QM(),短期借款科目编号是2001,所以公式的输入为QM("2001",月),如下图所示:
5、输完公式,点击“确认”之后,如果公式输入成功,就单元格就会显示“公式单元”四个字,如下图
6、这时,我们如果要看短期借款的期末余额是多少,就要点击左下角“格式”,
变回“数据”状态,会弹出提示框“是否整表重算”,如下图所示:
7、点击“是”,就会变回“数据”状态,短期借款的期末余额数也会出来。
由于只是演示,所以账套是没有数据的,如果大家对账套进行日常操作,是会有数据出来的。
其他科目的期末余额都是同样的设置方法,大家根据企业自身需要进行设置就好了。
二、生成报表数据
1、先打开UFO报表--新建
2、点击格式--报表模板
3、选择相应的行业(会计科目)
4、编辑会计科目,本月数fs(501,月,"贷",,年),按照模板套用即可,双击即可弹出来公式编辑的界面,fs代表发生数。
501代表会计科目,根据实际的会计科目可以对公式进行调整。
5、第一种编辑本年累计数。这里有两种编辑方式。
一种的公式为:?C6+select(?D6,年@=年 and 月@=月+1),这种公式如果计算出正确的本年累计数就需要做表页的追加。
切换到数据状态,点击编辑--追加--表页,追加12月的即可。
6、第二种编辑本年累计数。公式为:LFS("5001",月,"借",,,"","","y"),LFS代表累计发生数。
这种公式不用做表页的追加,直接单独的表页即可计算出来,当然这种公式也可以做表页的追加喔。
扩展资料:
改革开放40年百名杰出民营企业家名单
(按姓氏笔画为序排列)
丁佐宏 月星集团有限公司董事长
万 隆 双汇集团董事长
马 云 阿里巴巴集团董事局主席
马化腾 腾讯公司董事会主席兼首席执行官
马有福 青海雪舟三绒集团董事长
王 伟 贵州兴伟集团公司董事长
王 填 步步高集团董事长
王文京 用友软件股份有限公司董事长兼总裁
参考资料:百度百科-用友软件
百度百科-王文京(用友总裁)
人民网-改革开放40年百名杰出民营企业家名单发布!
- CarieVinne
-
倾情奉献:
资产负债表公式如下
C7=QC("1001",全年,,,,,,,"y",,)+QC("1002",全年,,,,,,,"y",,)+QC("1012",全年,,,,,,,"y",,)
D7=QM("1001",月,,,,,,,"y",,)+QM("1002",月,,,,,,,"y",,)+QM("1012",月,,,,,,,"y",,)
G7=QC("2001",全年,,,,,,,"y",,)
H7=QM("2001",月,,,,,,,"y",,)
C8=QC("1101",全年,,,,,,,"y",,)
D8=QM("1101",月,,,,,,,"y",,)
G8=QC("2101",全年,,,,,,,"y",,)
H8=QM("2101",月,,,,,,,"y",,)
C9=QC("1121",全年,,,,,,,"y",,)
D9=QM("1121",月,,,,,,,"y",,)
G9=QC("2201",全年,,,,,,,"y",,)
H9=QM("2201",月,,,,,,,"y",,)
C10=QCEX("112201",全年,"借",,,"",,,,"y",,,)+QCEX("112202",全年,"借",,,"",,,,"y",,,)+QCEX("112203",全年,"借",,,"",,,,"y",,,)+QCEX("112204",全年,"借",,,"",,,,"y",,,)+QCEX("112205",全年,"借",,,"",,,,"y",,,)+QCEX("112206",全年,"借",,,"",,,,"y",,,)-QC("1231",全年,,,,,,,"y",,)+QCEX("2203",全年,"借",,,"",,,,"y",,,)
D10=QMEX("112201",月,"借",,,"",,,,"y",,,)+QMEX("112202",月,"借",,,"",,,,"y",,,)+QMEX("112203",月,"借",,,"",,,,"y",,,)+QMEX("112204",月,"借",,,"",,,,"y",,,)+QMEX("112205",月,"借",,,"",,,,"y",,,)+QMEX("112206",月,"借",,,"",,,,"y",,,)-QM("1231",月,,,,,,,"y",,)+QMEX("2203",月,"借",,,"",,,,"y",,,)
G10=QCEX("2202",全年,"贷",,,,,,,"y",,)+QCEX("1123",全年,"贷",,,"",,,,"y",,,)
H10=QMEX("2202",月,"贷",,,,,,,"y",,)+QMEX("1123",月,"贷",,,"",,,,"y",,,)
C11=QCEX("1123",全年,"借",,,"",,,,"y",,,)+QCEX("2202",全年,"借",,,"",,,,"y",,,)
D11=QMEX("1123",月,"借",,,"",,,,"y",,,)+QMEX("2202",月,"借",,,"",,,,"y",,,)
G11=QCEX("112201",全年,"贷",,,"",,,,"y",,,)+QCEX("112202",全年,"贷",,,"",,,,"y",,,)+QCEX("112203",全年,"贷",,,"",,,,"y",,,)+QCEX("112204",全年,"贷",,,"",,,,"y",,,)+QCEX("112205",全年,"贷",,,"",,,,"y",,,)+QCEX("112206",全年,"贷",,,"",,,,"y",,,)+QCEX("2203",全年,"贷",,,"",,,,"y",,,)
H11=QMEX("112201",月,"贷",,,"",,,,"y",,,)+QMEX("112202",月,"贷",,,"",,,,"y",,,)+QMEX("112203",月,"贷",,,"",,,,"y",,,)+QMEX("112204",月,"贷",,,"",,,,"y",,,)+QMEX("112205",月,"贷",,,"",,,,"y",,,)+QMEX("112206",月,"贷",,,"",,,,"y",,,)+QMEX("2203",月,"贷",,,"",,,,"y",,,)
C12=QC("1132",全年,,,,,,,"y",,)
D12=QM("1132",月,,,,,,,"y",,)
G12=QC("2211",全年,,,,,,,"y",,)
H12=QM("2211",月,,,,,,,"y",,)
C13=QC("1131",全年,,,,,,,"y",,)
D13=QM("1131",月,,,,,,,"y",,)
G13=QC("2221",全年,,,,,,,"y",,)
H13=QM("2221",月,,,,,,,"y",,)
C14=QCEX("122101",全年,"借",,,"",,,,"y",,,)+QCEX("122102",全年,"借",,,"",,,,"y",,,)+QCEX("122103",全年,"借",,,"",,,,"y",,,)+QCEX("2241",全年,"借",,,"",,,,"y",,,)
D14=QMEX("122101",月,"借",,,"",,,,"y",,,)+QMEX("122102",月,"借",,,"",,,,"y",,,)+QMEX("122103",月,"借",,,"",,,,"y",,,)+QMEX("2241",月,"借",,,"",,,,"y",,,)
G14=QC("2231",全年,,,,,,,"y",,)
H14=QM("2231",月,,,,,,,"y",,)
C15=QC("1401",全年,,,,,,,"y",,)+QC("1402",全年,,,,,,,"y",,)+QC("1403",全年,,,,,,,"y",,)+QC("1404",全年,,,,,,,"y",,)+QC("1405",全年,,,,,,,"y",,)+QC("1406",全年,,,,,,,"y",,)+QC("1407",全年,,,,,,,"y",,)+QC("1408",全年,,,,,,,"y",,)+QC("1411",全年,,,,,,,"y",,)+QC("1421",全年,,,,,,,"y",,)+QC("5001",全年,,,,,,,"y",,)+QC("5201",全年,,,,,,,"y",,)-QC("1471",全年,,,,,,,"y",,)
D15=QM("1401",月,,,,,,,"y",,)+QM("1402",月,,,,,,,"y",,)+QM("1403",月,,,,,,,"y",,)+QM("1404",月,,,,,,,"y",,)+QM("1405",月,,,,,,,"y",,)+QM("1406",月,,,,,,,"y",,)+QM("1407",月,,,,,,,"y",,)+QM("1408",月,,,,,,,"y",,)+QM("1411",月,,,,,,,"y",,)+QM("1421",月,,,,,,,"y",,)+QM("5001",月,,,,,,,"y",,)+QM("5201",月,,,,,,,"y",,)-QM("1471",月,,,,,,,"y",,)
G15=QC("2232",全年,,,,,,,"y",,)
H15=QM("2232",月,,,,,,,"y",,)
G16=QCEX("122101",全年,"贷",,,"",,,,"y",,,)+QCEX("122102",全年,"贷",,,"",,,,"y",,,)+QCEX("122103",全年,"贷",,,"",,,,"y",,,)+QCEX("2241",全年,"贷",,,"",,,,"y",,,)
H16=QMEX("122101",月,"贷",,,"",,,,"y",,,)+QMEX("122102",月,"贷",,,"",,,,"y",,,)+QMEX("122103",月,"贷",,,"",,,,"y",,,)+QMEX("2241",月,"贷",,,"",,,,"y",,,)
C17=QC("1472",全年,,,,,,,"y",,)
D17=QM("1472",月,,,,,,,"y",,)
C18=ptotal(?C7:?C17)
D18=ptotal(?D7:?D17)
G19=ptotal(?G7:?G18)
H19=ptotal(?H7:?H18)
C20=QC("1503",全年,,,,,,,"y",,)
D20=QM("1503",月,,,,,,,"y",,)
C21=QC("1501",全年,,,,,,,"y",,)-QC("1502",全年,,,,,,,"y",,)
D21=QM("1501",月,,,,,,,"y",,)-QM("1502",月,,,,,,,"y",,)
G21=QC("2501",全年,,,,,,,"y",,)
H21=QM("2501",月,,,,,,,"y",,)
C22=QC("153101",全年,,,,,,,"y",,)
D22=QM("153101",月,,,,,,,"y",,)
G22=QC("2502",全年,,,,,,,"y",,)
H22=QM("2502",月,,,,,,,"y",,)
C23=QC("1511",全年,,,,,,,"y",,)-QC("1512",全年,,,,,,,"y",,)
D23=QM("1511",月,,,,,,,"y",,)-QM("1512",月,,,,,,,"y",,)
G23=QC("2701",全年,,,,,,,"y",,)-QC("2702",全年,,,,,,,"y",,)
H23=QM("2701",月,,,,,,,"y",,)-QM("2702",月,,,,,,,"y",,)
C24=QC("1521",全年,,,,,,,"y",,)
D24=QM("1521",月,,,,,,,"y",,)
G24=QC("271101",全年,,,,,,,"y",,)+QC("271102",全年,,,,,,,"y",,)
H24=QM("271101",月,,,,,,,"y",,)+QM("271102",月,,,,,,,"y",,)
C25=QC("1601",全年,,,,,,,"y",,)-QC("1602",全年,,,,,,,"y",,)-QC("1603",全年,,,,,,,"y",,)
D25=QM("1601",月,,,,,,,"y",,)-QM("1602",月,,,,,,,"y",,)-QM("1603",月,,,,,,,"y",,)
G25=QC("2801",全年,,,,,,,"y",,)
H25=QM("2801",月,,,,,,,"y",,)
C26=QC("1604",全年,,,,,,,"y",,)
D26=QM("1604",月,,,,,,,"y",,)
G26=QC("2901",全年,,,,,,,"y",,)
H26=QM("2901",月,,,,,,,"y",,)
C27=QC("1605",全年,,,,,,,"y",,)
D27=QM("1605",月,,,,,,,"y",,)
C28=QC("1606",全年,,,,,,,"y",,)
D28=QM("1606",月,,,,,,,"y",,)
G28=ptotal(?G21:?G27)
H28=ptotal(?H21:?H27)
C29=QC("162101",全年,,,,,,,"y",,)+QC("162102",全年,,,,,,,"y",,)-QC("1622",全年,,,,,,,"y",,)
D29=QM("162101",月,,,,,,,"y",,)+QM("162102",月,,,,,,,"y",,)-QM("1622",月,,,,,,,"y",,)
G29=?G19+?G28
H29=?H19+?H28
C30=QC("1631",全年,,,,,,,"y",,)-QC("1632",全年,,,,,,,"y",,)
D30=QM("1631",月,,,,,,,"y",,)-QM("1632",月,,,,,,,"y",,)
C31=QC("1701",全年,,,,,,,"y",,)-QC("1702",全年,,,,,,,"y",,)-QC("1703",全年,,,,,,,"y",,)
D31=QM("1701",月,,,,,,,"y",,)-QM("1702",月,,,,,,,"y",,)-QM("1703",月,,,,,,,"y",,)
G31=QC("4001",全年,,,,,,,"y",,)
H31=QM("4001",月,,,,,,,"y",,)
C32=QC("5301",全年,,,,,,,"y",,)
D32=QM("5301",月,,,,,,,"y",,)
G32=QC("4002",全年,,,,,,,"y",,)
H32=QM("4002",月,,,,,,,"y",,)
C33=QC("1711",全年,,,,,,,"y",,)
D33=QM("1711",月,,,,,,,"y",,)
G33=QC("4201",全年,,,,,,,"y",,)
H33=QM("4201",月,,,,,,,"y",,)
C34=QC("1801",全年,,,,,,,"y",,)
D34=QM("1801",月,,,,,,,"y",,)
G34=QC("4101",全年,,,,,,,"y",,)
H34=QM("4101",月,,,,,,,"y",,)
C35=QC("1811",全年,,,,,,,"y",,)
D35=QM("1811",月,,,,,,,"y",,)
G35=QC("4103",全年,,,,,,,"y",,)+QC("4104",全年,,,,,,,"y",,)
H35=QM("4103",月,,,,,,,"y",,)+QM("4104",月,,,,,,,"y",,)
G36=?G31+?G32-?G33+?G34+?G35
H36=?H31+?H32-?H33+?H34+?H35
C37=ptotal(?C20:?C36)
D37=ptotal(?D20:?D36)
C38=C18+C37
D38=D18+D37
G38=G29+G36
H38=H29+H36
利润表公式如下
C5=fs(6001,月,"贷",,,,,"y")+fs(6051,月,"贷",,,,,"y")
D5=lfs(6001,月,"贷",,,,,"y")+lfs(6051,月,"贷",,,,,"y")
C6=fs(6401,月,"借",,,,,"y")+fs(6402,月,"借",,,,,"y")
D6=lfs(6401,月,"借",,,,,"y")+lfs(6402,月,"借",,,,,"y")
C7=fs(6403,月,"借",,,,,"y")
D7=lfs(6403,月,"借",,,,,"y")
C8=fs(6601,月,"借",,,,,"y")
D8=lfs(6601,月,"借",,,,,"y")
C9=fs(6602,月,"借",,,,,"y")
D9=lfs(6602,月,"借",,,,,"y")
C10=fs(6603,月,"借",,,,,"y")
D10=lfs(6603,月,"借",,,,,"y")
C11=fs(6701,月,"借",,,,,"y")
D11=lfs(6701,月,"借",,,,,"y")
C12=fs(6101,月,"贷",,,,,"y")
D12=lfs(6101,月,"贷",,,,,"y")
C13=fs(6111,月,"借",,,,,"y")*-1
D13=lfs(6111,月,"借",,,,,"y")*-1
C15=?C5-?C6-?C7-?C8-?C9-?C10-?C11+?C12+?C13
D15=?D5-?D6-?D7-?D8-?D9-?D10-?D11+?D12+?D13
C16=fs(6301,月,"贷",,,,,"y")
D16=lfs(6301,月,"贷",,,,,"y")
C17=fs(6711,月,"借",,,,,"y")
D17=lfs(6711,月,"借",,,,,"y")
C19=?C15+?C16-?C17
D19=?D15+?D16-?D17
C20=fs(6801,月,"借",,,,,"y")
D20=lfs(6801,月,"借",,,,,"y")
C22=?C19-?C20
D22=?D19-?D20
把以上两表的公式复制下来,分别粘贴为两个文本文件(资产负债表.txt 利润表.txt),打开用友,进入UFO,打开相应的报表模板,在“格式”状态下,在公式列表窗口,导入对应的公式文本文件即可。
我这个报表公式是按实际工作设置的,非常实用,特别是应收应付按明细余额分析法自动确定报表方向,另一个就是可以不记账也能产生报表。
具体格式请自行调整,单元格的编号也要随之变动。
- 好投
-
用友的资产负债表及利润表公式都是设定好的。打开UFO报表--文件--打开---安装目录--UFO--相对应的会计准则,报表名以中文表示
- 苏萦
-
你好,我用的T3当时购买的软件,安装人员直接给设置好的,你是想问如何导入数据生成报表吗?