用友软件中资产负债表公式定义表资产负债表编制单位:2010年12月31日资产期末余额年初余额负债和所有者权益(或股东权益)期末余额年初余额流动资产:流动负债:货币资金=QM(1001,月,,,年,,)+QM(1002,月,,,年,,)+QM(1012,月,,,年,,)=QM(1001,全年,,,年,,)+QM(1002,全年,,,年,,)+QM(1012,全年,,,年,,)短期借款=QM(2001,月,,,年,,)=QC(2001,全年,,,年,,)交易性金融资产=QM(1101,月,,,年,,)=QM(1101,全年,,,年,,)交易性金融负债=QM(2101,月,,,年,,)=QM(2101,全年,,,年,,)应收票据=QM(1121,月,,,年,,)=QM(1121,全年,,,年,,)应付票据=QM(2201,月,,,年,,)=QM(2201,全年,,,年,,)应收账款=QM(1122,月,,,年,,)-QM(1231,月,,,年,,)=QM(1122,全年,,,年,,)-QM(1231,全年,,,年,,)应付账款=QM(2202,月,,,年,,)=QM(2202,全年,,,年,,)预付款项=QM(1123,月,,,年,,)=QM(1123,全年,,,年,,)预收款项=QM(2203,月,,,年,,)=QM(2203,全年,,,年,,)应收利息=QM(1132,月,,,年,,)=QM(1132,全年,,,年,,)应付职工薪酬=QM(2211,月,,,年,,)=QM(2211,全年,,,年,,)应收股利=QM(1131,月,,,年,,)=QM(1131,全年,,,年,,)应交税费=QM(2221,月,,,年,,)=QM(2221,全年,,,年,,)其他应收款=QM(1221,月,,,年,,)=QM(1221,全年,,,年,,)应付利息=QM(2231,月,,,年,,)=QM(2231,全年,,,年,,)存货=QM(1401,月,,,年,,)+QM(1402,月,,,年,,)+...+QM(1405,月,,,年,,)=QM(1401,全年,,,年,,)+QM(1402,全年,,,年,,)+...+QM(1405,全年,,,年,,)应付股利=QM(2232,月,,,年,,)=QM(2232,全年,,,年,,)一年内到期的非流动资产=QM(1901,月,,,年,,)=QM(1901,全年,,,年,,)其他应付款=QM(2241,月,,,年,,)=QM(2241,全年,,,年,,)其他流动资产一年内到期的非流动负债流动资产合计=ptotal(B6:B16)=ptotal(C6:C16)其他流动负债=QM(2401,月,,,年,,)=QM(2401,全年,,,年,,)非流动资产:流动负债合计=ptotal(E6:E17)=ptotal(F6:F17)可供出售金融资产=QM(1503,月,,,年,,)=QM(1503,全年,,,年,,)非流动负债:持有至到期投资=QM(1501,月,,,年,,)-QM(1502,月,,,年,,)=QM(1501,全年,,,年,,)-QM(1502,全年,,,年,,)长期借款=QM(2501,月,,,年,,)=QM(2501,全年,,,年,,)长期应收款=QM(1531,月,,,年,,)-QM(1541,月,,,年,,)=QM(1531,全年,,,年,,)-QM(1541,全年,,,年,,)应付债券=QM(2502,月,,,年,,)=QM(2502,全年,,,年,,)长期股权投资=QM(1511,月,,,年,,)-QM(1512,月,,,年,,)=QM(1511,全年,,,年,,)-QM(1512,全年,,,年,,)长期应付款=QM(2701,月,,,年,,)=QM(2701,全年,,,年,,)投资性房地产=QM(1521,月,,,年,,)=QM(1521,全年,,,年,,)专项应付款=QM(2711,月,,,年,,)=QM(2711,全年,,,年,,)固定资产=QM(1601,月,,,年,,)-QM(1602,月,,,年,,)--QM(1603,月,,,年,,)=QM(1601,全年,,,年,,)-QM(1602,全年,,,年,,)--QM(1603,全年,,,年,,)预计负债=QM(2801,月,,,年,,)=QM(2801,全年,,,年,,)在建工程=QM(1604,月,,,年,,)=QM(1604,全年,,,年,,)递延所得税负债=QM(2901,月,,,年,,)=QM(2901,全年,,,年,,)工程物资=QM(1605,月,,,年,,)=QM(1605,全年,,,年,,)其他非流动负债固定资产清理=QM(1606,月,,,年,,)=QM(1606,全年,,,年,,)非流动负债合计=ptotal(E20:E26)=ptotal(F20:F26)生产性生物资产=QM(1621,月,,,年,,)-QM(1622,月,,,年,,)=QM(1621,全年,,,年,,)-QM(1622,全年,,,年,,)负债合计=E18+E27=F18+F27油气资产=QM(1631,月,,,年,,)-QM(1632,月,,,年,,)=QM(1631,全年,,,年,,)-QM(1632,全年,,,年,,)所有者权益(或股东权益):无形资产=QM(1701,月,,,年,,)-QM(1702,月,,,年,,)--QM(1703,月,,,年,,)=QM(1701,全年,,,年,,)-QM(1702,全年,,,年,,)--QM(1703,全年,,,年,,)实收资本(或股本)=QM(4001,月,,,年,,)=QM(4001,全年,,,年,,)开发支出资本公积=QM(4002,月,,,年,,)=QM(4002,全年,,,年,,)商誉=QM(1711,月,,,年,,)=QM(1711,全年,,,年,,)减:库存股=QM(4201,月,,,年,,)=QM(4201,全年,,,年,,)长期待摊费用=QM(1801,月,,,年,,)=QM(1801,全年,,,年,,)盈余公积=QM(4101,月,,,年,,)=QM(4101,全年,,,年,,)递延所得税资产=QM(1811,月,,,年,,)=QM(1811,全年,,,年,,)未分配利润=QM(4101,月,,,年,,)=QM(4101,全年,,,年,,)其他非流动资产所有者权益(或股东权益)合计=E30+E31-E32+E33+E34=F30+F31-F32+F33+F34非流动资产合计=ptotal(B19:B35)=ptotal(C19:C35)资产总计=B17+B36=C17+C36负债和所有者权益(或股东权益)总计=E28+E35=F28+F35