求用友U8中的资产负责表，损益表等表的公式

急求用友U8中的资产负责表，损益表等表的公式，最好是全部表格，EXECL格式的。如有请发到我的邮箱[email protected] 先谢了！

推荐答案 2010-04-09

资产负债表：
//资产类年初数
//流动资产
LET C6=QC("1001",全年,,"001", 年,,,,)
LET C6=C6+QC("1002",全年,,"001", 年,,,,)
LET C6=C6+QC("1012",全年,,"001", 年,,,,)
LET C7=QC("1101",全年,,"001", 年,,,,)
LET C8=QC("1121",全年,,"001", 年,,,,)
LET C9=QC("1122",全年,,"001", 年,,,,)
LET C9=C9-QC("123101",全年,,"001", 年,,,,)
LET C10=QC("1123",全年,,"001", 年,,,,)
LET C11=QC("1132",全年,,"001", 年,,,,)
LET C12=QC("1131",全年,,"001", 年,,,,)
LET C13=QC("1221",全年,,"001", 年,,,,)
LET C13=C13-QC("123102",全年,,"001", 年,,,,)
LET C14=QC("1401",全年,,"001", 年,,,,)
LET C14=C14+QC("1402",全年,,"001", 年,,,,)
LET C14=C14+QC("1403",全年,,"001", 年,,,,)
LET C14=C14+QC("1404",全年,,"001", 年,,,,)
LET C14=C14+QC("1405",全年,,"001", 年,,,,)
LET C14=C14+QC("1406",全年,,"001", 年,,,,)
LET C14=C14+QC("1408",全年,,"001", 年,,,,)
LET C14=C14+QC("1409",全年,,"001", 年,,,,)
LET C14=C14+QC("1410",全年,,"001", 年,,,,)
LET C14=C14+QC("1411",全年,,"001", 年,,,,)
LET C14=C14+QC("1412",全年,,"001", 年,,,,)
LET C14=C14-QC("1471",全年,,"001", 年,,,,)
LET C14=C14+QC("5001",全年,,"001", 年,,,,)
LET C14=C14+QC("5101",全年,,"001", 年,,,,)
LET C16=QC("1504",全年,,"001", 年,,,,)
LET C17=PTOTAL(C6:C16)
//非流动资产
LET C19=QC("1503",全年,,"001", 年,,,,)
LET C20=QC("1501",全年,,"001", 年,,,,)
LET C20=C20-QC("1502",全年,,"001", 年,,,,)
LET C21=QC("1531",全年,,"001", 年,,,,)
LET C22=QC("1511",全年,,"001", 年,,,,)
LET C22=C22-QC("1512",全年,,"001", 年,,,,)
LET C23=QC("1521",全年,,"001", 年,,,,)
LET C23=C23-QC("1522",全年,,"001", 年,,,,)
LET C24=QC("1601",全年,,"001", 年,,,,)
LET C24=C24-QC("1602",全年,,"001", 年,,,,)
LET C24=C24-QC("1603",全年,,"001", 年,,,,)
LET C25=QC("1604",全年,,"001", 年,,,,)
LET C26=QC("1605",全年,,"001", 年,,,,)
LET C27=QC("1606",全年,,"001", 年,,,,)
LET C30=QC("1701",全年,,"001", 年,,,,)
LET C30=C30-QC("1702",全年,,"001", 年,,,,)
LET C30=C30-QC("1703",全年,,"001", 年,,,,)
LET C32=QC("1711",全年,,"001", 年,,,,)
LET C33=QC("1801",全年,,"001", 年,,,,)
LET C34=QC("1811",全年,,"001", 年,,,,)
LET C35=QC("1902",全年,,"001", 年,,,,)
LET C36=PTOTAL(C19:C35)
//资产类总计
LET C37=C17+C36
//流动负债
LET G6=QC("2001",全年,,"001", 年,,,,)
LET G7=QC("2101",全年,,"001", 年,,,,)
LET G8=QC("2201",全年,,"001", 年,,,,)
LET G9=QC("2202",全年,,"001", 年,,,,)
LET G10=QC("2203",全年,,"001", 年,,,,)
LET G11=QC("2211",全年,,"001", 年,,,,)
LET G12=QC("2221",全年,,"001", 年,,,,)
LET G12=G12+QC("2222",全年,,"001", 年,,,,)
LET G13=QC("2231",全年,,"001", 年,,,,)
LET G14=QC("2232",全年,,"001", 年,,,,)
LET G15=QC("2241",全年,,"001", 年,,,,)
LET G17=QC("2242",全年,,"001", 年,,,,)
LET G18=PTOTAL(G6:G17)
//非流动负债
LET G20=QC("2501",全年,,"001", 年,,,,)
LET G21=QC("2502",全年,,"001", 年,,,,)
LET G22=QC("2701",全年,,"001", 年,,,,)
LET G23=QC("2711",全年,,"001", 年,,,,)
LET G24=QC("2801",全年,,"001", 年,,,,)
LET G25=QC("2901",全年,,"001", 年,,,,)
LET G27=PTOTAL(G20:G26)
//负债合计
LET G28=G18+G27
//股东权益
LET G30=QC("4001",全年,,"001", 年,,,,)
LET G31=QC("4002",全年,,"001", 年,,,,)
LET G33=QC("4101",全年,,"001", 年,,,,)
LET G34=QC("4103",全年,,"001", 年,,,,)
LET G34=G34+QC("4104",全年,,"001", 年,,,,)
LET g36=G30+G31-G32+G33+G34
//负债和股东权益合计
LET G37=G28+g36

//期末数
//资产类期限末数
//流动资产
LET D6=QM("1001",月,,"001", 年,,,,)
LET D6=D6+QM("1002",月,,"001", 年,,,,)
LET D6=D6+QM("1012",月,,"001", 年,,,,)
LET D7=QM("1101",月,,"001", 年,,,,)
LET D8=QM("1121",月,,"001", 年,,,,)
LET D9=QM("1122",月,,"001", 年,,,,)
LET D9=D9-QM("123101",月,,"001", 年,,,,)
LET D10=QM("1123",月,,"001", 年,,,,)
LET D11=QM("1132",月,,"001", 年,,,,)
LET D12=QM("1131",月,,"001", 年,,,,)
LET D13=QM("1221",月,,"001", 年,,,,)
LET D13=D13-QM("123102",月,,"001", 年,,,,)
LET D14=QM("1401",全年,,"001", 年,,,,)
LET D14=D14+QM("1402",月,,"001", 年,,,,)
LET D14=D14+QM("1403",月,,"001", 年,,,,)
LET D14=D14+QM("1404",月,,"001", 年,,,,)
LET D14=D14+QM("1405",月,,"001", 年,,,,)
LET D14=D14+QM("1406",月,,"001", 年,,,,)
LET D14=D14+QM("1408",月,,"001", 年,,,,)
LET D14=D14+QM("1409",月,,"001", 年,,,,)
LET D14=D14+QM("1410",月,,"001", 年,,,,)
LET D14=D14+QM("1411",月,,"001", 年,,,,)
LET D14=D14+QM("1412",月,,"001", 年,,,,)
LET D14=D14-QM("1471",月,,"001", 年,,,,)
LET D14=D14+QM("5001",月,,"001", 年,,,,)
LET D14=D14+QM("5101",月,,"001", 年,,,,)
LET D16=QM("1504",月,,"001", 年,,,,)
LET D17=PTOTAL(D6:D16)
//非流动资产
LET D19=QM("1503",月,,"001", 年,,,,)
LET D20=QM("1501",月,,"001", 年,,,,)
LET D20=D20-QM("1502",月,,"001", 年,,,,)
LET D21=QM("1531",月,,"001", 年,,,,)
LET D22=QM("1511",月,,"001", 年,,,,)
LET D22=D22-QM("1512",月,,"001", 年,,,,)
LET D23=QM("1521",月,,"001", 年,,,,)
LET D23=D23-QM("1522",月,,"001", 年,,,,)
LET D24=QM("1601",月,,"001", 年,,,,)
LET D24=D24-QM("1602",月,,"001", 年,,,,)
LET D24=D24-QM("1603",月,,"001", 年,,,,)
LET D25=QM("1604",月,,"001", 年,,,,)
LET D26=QM("1605",月,,"001", 年,,,,)
LET D27=QM("1606",月,,"001", 年,,,,)
LET D30=QM("1701",月,,"001", 年,,,,)
LET D30=D30-QM("1702",月,,"001", 年,,,,)
LET D30=D30-QM("1703",月,,"001", 年,,,,)
LET D32=QM("1711",月,,"001", 年,,,,)
LET D33=QM("1801",月,,"001", 年,,,,)
LET D34=QM("1811",月,,"001", 年,,,,)
LET D35=QM("1902",月,,"001", 年,,,,)
LET D36=PTOTAL(D19:D35)
//资产类总计
LET D37=D17+D36
//流动负债
LET H6=QM("2001",月,,"001", 年,,,,)
LET H7=QM("2101",月,,"001", 年,,,,)
LET H8=QM("2201",月,,"001", 年,,,,)
LET H9=QM("2202",月,,"001", 年,,,,)
LET H10=QM("2203",月,,"001", 年,,,,)
LET H11=QM("2211",月,,"001", 年,,,,)
LET H12=QM("2221",月,,"001", 年,,,,)
LET H12=H12+QM("2222",月,,"001", 年,,,,)
LET H13=QM("2231",月,,"001", 年,,,,)
LET H14=QM("2232",月,,"001", 年,,,,)
LET H15=QM("2241",月,,"001", 年,,,,)
LET H17=QM("2242",月,,"001", 年,,,,)
LET H18=PTOTAL(H6:H17)
//非流动负债
LET H20=QM("2501",月,,"001", 年,,,,)
LET H21=QM("2502",月,,"001", 年,,,,)
LET H22=QM("2701",月,,"001", 年,,,,)
LET H23=QM("2711",月,,"001", 年,,,,)
LET H24=QM("2801",月,,"001", 年,,,,)
LET H25=QM("2901",月,,"001", 年,,,,)
LET H27=PTOTAL(H20:H26)
//负债合计
LET H28=H18+H27
//股东权益
LET H30=QM("4001",月,,"001", 年,,,,)
LET H31=QM("4002",月,,"001", 年,,,,)
LET H33=QM("4101",月,,"001", 年,,,,)
LET H34=QM("4103",月,,"001", 年,,,,)
LET H34=H34+QM("4104",月,,"001", 年,,,,)
LET h36=H30+H31-H32+H33+H34
//负债和股东权益合计
LET H37=H28+H36

IF H37=D37 AND C37=G37
DISP "用友软件","报表平衡！！"
ELSE
DISP "用友软件","报表不平衡！！"
END IF

损益表：

//
LET C6=FS("6001",月,"贷","001",年,,,"y")
LET C6=C6+FS("6051",月,"贷","001",年,,,"y")
LET C7=FS("6401",月,"借","001",年,,,"y")
LET C7=C7+FS("6402",月,"借","001",年,,,"y")
LET C8=FS("6403",月,"借","001",年,,,"y")
LET C9=FS("6601",月,"借","001",年,,,"y")
LET C10=FS("6602",月,"借","001",年,,,"y")
LET C11=FS("6603",月,"借","001",年,,,"y")
LET C12=FS("6701",月,"借","001",年,,,"y")
LET C16=C6-C7-C8-C9-C10-C11-C12+C13+C14
LET C17=FS("6301",月,"贷","001",年,,,"y")
LET C17=C17+FS("6112",月,"贷","001",年,,,"y")
LET C18=FS("6711",月,"借","001",年,,,"y")
LET C20=C16+C17-C18
LET C21=FS("6801",月,"借","001",年,,,"y")
LET C22=C20-C21
//累计数
LET D=C+SELECT(D,年@=年 AND 月@=月+1)

温馨提示：答案为网友推荐，仅供参考

当前网址：http://66.wendadaohang.com/zd/UDD2svUsD.html

其他回答

第1个回答 2010-04-01

系统自带就有做好的报表模板。你打开UFO报表点文件-新建-格式-报表模板。选一下你帐套所属的行业和要做的报表就行了本回答被网友采纳

相似回答

用友软件的资产负债表公式?答：1、货币资金=现金+银行存款+他货币资金；2、应收帐款净额＝应收帐款－坏帐准备；3、存货＝库存商品+主要原材料+燃料+辅助材料+低值易耗品+在产品+发出商品等；4、流动资产＝货币资金+短期投资+应收帐款+预付帐款+其他应收款+存货+待摊费用等 5、固定资产净值＝原值-累计折旧 6固定资产合计＝固定资...

请问下用友ERP U8里资产负债表、现金流量表及利润表等报表在里的公式...答：比如利润表里面的公式 如果管理费用公式：本月数公式fs(5502,月,"借",,年) 累计数公式：lfs(5502,月,"借",,年)再不明白，可以加我QQ88231921.

利润分配未分配利润在借方,用友U8里面资产负债表的公式是啥子...答：①年初为公式：QC("3131",全年,,,年,,)+QC("3141",全年,,,年,,)。②、年末为公式：QM("3131",全年,,,年,,)+QM("3141",全年,,,年,,)。1、查看行业性质：打开“系统管理”使用账套主管的身份登录。选择你要建立报表的账套，登录到系统管理之后，点击账套》修改，一直下一步知道找到“核算...

用友软件的资产负债表公式,答：用友软件的资产负债表公式,我想把应收账款项目的公式设置为应收账款明细科目的借方加应付账款明细科目的借方之和,公式怎么表示?问题补充:用友报表中的公式是应收账款期末=QM("1131",全年,,,年,,),这样取出的数是应收账款明细科目借贷方抵消后的数额,即... 展开匿名...

用友财务软件资产负债表公式答：在资产负债表里点击左下角切换到格式里，然后找到存货，双击在公式里添加对应科目编码QM("余额",月,,,年,,)，同时在生产成本里的余额删掉

求用友u8一般企业(新会计准则)模版下资产负债表所有公式答：一般只涉及到年初数据和期末数据。公式很好设置的。我以“货币资金”为例，其他公式只是修改科目年初：QC("1001",全年,,,年,,)+QC("1002",全年,,,年,,)+QC("1012",全年,,,年,,)期末：QM("1001",月,,,年,,)+QM("1002",月,,,年,,)+QM("1012",月,,,年,,)

大家正在搜

损益表和资产负债表的关系资产负债表和损益表的区别损益表和资产负债表资产负债表损益表上报资产负债表损益表下载用友u8报表利润表公式用友u8资产负债表用友u8怎么看资产负债表资产损益表是利润表吗