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

资产负债表：

//资产类年初数

//流动资产

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)