用友U8资产负债表公式

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=QC("1131",全年,,,,,,,"y",,)

D10=QM("1131",月,,,,,,,"y",,)

G10=QCEX("2202",全年,"贷",,,,,,,"y",,)+QCEX("1123",全年,"贷",,,"",,,,"y",,,)

H10=QMEX("2202",月,"贷",,,,,,,"y",,)+QMEX("1123",月,"贷",,,"",,,,"y",,,)

C11=QC("1132",全年,,,,,,,"y",,)

D11=QM("1132",月,,,,,,,"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=QCEX("112201",全年,"借",,,"",,,,"y",,,)+QCEX("112202",全年,"借",,,"",,,,"y",,,)+QCEX("112203",全年,"借",,,"",,,,"y",,,)+QCEX("112204",全年,"借",,,"",,,,"y",,,)+QCEX("112205",全年,"借",,,"",,,,"y",,,)+QCEX("112206",全年,"借",,,"",,,,"y",,,)-QC("1231",全年,,,,,,,"y",,)+QCEX("2203",全年,"借",,,"",,,,"y",,,)

D12=QMEX("112201",月,"借",,,"",,,,"y",,,)+QMEX("112202",月,"借",,,"",,,,"y",,,)+QMEX("112203",月,"借",,,"",,,,"y",,,)+QMEX("112204",月,"借",,,"",,,,"y",,,)+QMEX("112205",月,"借",,,"",,,,"y",,,)+QMEX("112206",月,"借",,,"",,,,"y",,,)-QM("1231",月,,,,,,,"y",,)+QMEX("2203",月,"借",,,"",,,,"y",,,)

G12=QC("2211",全年,,,,,,,"y",,)

H12=QM("2211",月,,,,,,,"y",,)

C13=QCEX("122101",全年,"借",,,"",,,,"y",,,)+QCEX("122102",全年,"借",,,"",,,,"y",,,)+QCEX("122103",全年,"借",,,"",,,,"y",,,)+QCEX("2241",全年,"借",,,"",,,,"y",,,)

D13=QMEX("122101",月,"借",,,"",,,,"y",,,)+QMEX("122102",月,"借",,,"",,,,"y",,,)+QMEX("122103",月,"借",,,"",,,,"y",,,)+QMEX("2241",月,"借",,,"",,,,"y",,,)

G13=QC("2221",全年,,,,,,,"y",,)

H13=QM("2221",月,,,,,,,"y",,)

C14=QCEX("1123",全年,"借",,,"",,,,"y",,,)+QCEX("2202",全年,"借",,,"",,,,"y",,,)

D14=QMEX("1123",月,"借",,,"",,,,"y",,,)+QMEX("2202",月,"借",,,"",,,,"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("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("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",,,)

C20=ptotal(?C7:?C17)

D20=ptotal(?D7:?D17)

G20=ptotal(?G7:?G18)

H20=ptotal(?H7:?H18)

C22=QC("1503",全年,,,,,,,"y",,)

D22=QM("1503",月,,,,,,,"y",,)

G22=QC("2501",全年,,,,,,,"y",,)

H22=QM("2501",月,,,,,,,"y",,)

C23=QC("1501",全年,,,,,,,"y",,)-QC("1502",全年,,,,,,,"y",,)

D23=QM("1501",月,,,,,,,"y",,)-QM("1502",月,,,,,,,"y",,)

G23=QC("2502",全年,,,,,,,"y",,)

H23=QM("2502",月,,,,,,,"y",,)

C24=QC("1521",全年,,,,,,,"y",,)

D24=QM("1521",月,,,,,,,"y",,)

G24=QC("2701",全年,,,,,,,"y",,)

H24=QM("2701",月,,,,,,,"y",,)

C25=QC("1511",全年,,,,,,,"y",,)-QC("1512",全年,,,,,,,"y",,)

D25=QM("1511",月,,,,,,,"y",,)-QM("1512",月,,,,,,,"y",,)

G25=QC("271101",全年,,,,,,,"y",,)+QC("271102",全年,,,,,,,"y",,)

H25=QM("271101",月,,,,,,,"y",,)+QM("271102",月,,,,,,,"y",,)

C26=QC("153101",全年,,,,,,,"y",,)

D26=QM("153101",月,,,,,,,"y",,)

G26=QC("2801",全年,,,,,,,"y",,)

H26=QM("2801",月,,,,,,,"y",,)

C27=QC("1601",全年,,,,,,,"y",,)

D27=QM("1601",月,,,,,,,"y",,)

G27=QC("2901",全年,,,,,,,"y",,)

H27=QM("2901",月,,,,,,,"y",,)

C28=QC("1602",全年,,,,,,,"y",,)

D28=QM("1602",月,,,,,,,"y",,)

G28=QC("2702",全年,,,,,,,"y",,)

H28=QM("2702",月,,,,,,,"y",,)

C29=?C27-?C28

D29=?D27-?D28

G29=ptotal(?G22:?G28)

H29=ptotal(?H22:?H28)

C30=QC("1603",全年,,,,,,,"y",,)

D30=QM("1603",月,,,,,,,"y",,)

G30=?G20+?G29

H30=?H20+?H29

C31=?C29-?C30

D31=?D29-?D30

C32=QC("1621",全年,,,,,,,"y",,)-QC("1622",全年,,,,,,,"y",,)

D32=QM("1621",月,,,,,,,"y",,)-QM("1622",月,,,,,,,"y",,)

C33=QC("1605",全年,,,,,,,"y",,)

D33=QM("1605",月,,,,,,,"y",,)

G33=QC("4001",全年,,,,,,,"y",,)

H33=QM("4001",月,,,,,,,"y",,)

C34=QC("1604",全年,,,,,,,"y",,)

D34=QM("1604",月,,,,,,,"y",,)

G34=QC("4002",全年,,,,,,,"y",,)

H34=QM("4002",月,,,,,,,"y",,)

C35=QC("1606",全年,,,,,,,"y",,)

D35=QM("1606",月,,,,,,,"y",,)

G35=QC("4201",全年,,,,,,,"y",,)

H35=QM("4201",月,,,,,,,"y",,)

C36=QC("1701",全年,,,,,,,"y",,)-QC("1702",全年,,,,,,,"y",,)-QC("1703",全年,,,,,,,"y",,)

D36=QM("1701",月,,,,,,,"y",,)-QM("1702",月,,,,,,,"y",,)-QM("1703",月,,,,,,,"y",,)

G36=QC("4101",全年,,,,,,,"y",,)

H36=QM("4101",月,,,,,,,"y",,)

C37=QC("1711",全年,,,,,,,"y",,)

D37=QM("1711",月,,,,,,,"y",,)

G37=QC("4103",全年,,,,,,,"y",,)+QC("4104",全年,,,,,,,"y",,)

H37=QM("4103",月,,,,,,,"y",,)+QM("4104",月,,,,,,,"y",,)

C38=QC("1801",全年,,,,,,,"y",,)

D38=QM("1801",月,,,,,,,"y",,)

G38=?G33+?G34-?G35+?G36+?G37

H38=?H33+?H34-?H35+?H36+?H37

C39=QC("1811",全年,,,,,,,"y",,)

D39=QM("1811",月,,,,,,,"y",,)

C41=ptotal(?C22:?C26)+ptotal(?C31:?C40)

D41=ptotal(?D22:?D26)+ptotal(?D31:?D40)

C42=?C20+?C41

D42=?D20+?D41

G42=G30+G38

H42=H30+H38