用友T 资产负债表及公式

第1页 资产负债 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf #公式以单元格名称加“=”号开始，以英文分号“;”结束 会企01表 #每独立行设置一个公式，公式中涉及到的数字、英文、符号均为英文半角格式 单位： 2013年4月 单位：元 #例如设置B6请在单独一行中输入:B6=QueryAYear()+QueryAMonth()+B4; 资产 期末余额 年初余额 负债及所有者权益（或股东权益） 期末余额 年初余额 流动资产： 流动负债： A3="单位："+QueryCom(); 货币资金 1,432,649.46 35,000.00 短期借款 0 0 B3=QueryAYear()+"年"+QueryAMonth()+"月"; 交易性金融资产 0 0 交易性金融负债 0 0 B6=QM("1001","","年","月")+QM("1002","","年","月")+QM("1012","","年","月"); 应收票据 0 0 应付票据 0 0 B7=QM("1101","","年","月"); 应收账款 131,937.05 0 应付账款 316,566.00 0 B8=QM("1121","","年","月"); 预付款项 8,000.00 0 预收款项 96,100.00 0 B9=QM("1122","","年","月")-QM("1231","","年","月"); 应收利息 0 0 应付职工薪酬 0 0 B10=QM("1123","","年","月"); 应收股利 0 0 应交税费 61,576.08 0 B11=QM("1132","","年","月"); 其他应收款 227,430.00 0 应付利息 0 0 B12=QM("1131","","年","月"); 存货 936,217.70 0 应付股利 0 0 B13=QM("1221","","年","月"); 一年内到期的非流动资产 0 0 其他应付款 1,000.00 0 B14=QM("1401","","年","月")+QM("1402","","年","月")+QM("1403","","年","月")+QM("1404","","年","月")+QM("1405","","年","月")+QM("1406","","年","月")+QM("1407","","年","月")+QM("1408","","年","月")+QM("1411","","年","月")+QM("1421","","年","月")+QM("1431","","年","月")+QM("1441","","年","月")+QM("1451","","年","月")+QM("1461","","年","月")-QM("1471","","年","月")+QM("1321","","年","月")-QM("2314","","年","月")+QM("5001","","年","月"); 其他流动资产 一年内到期的非流动负债 B15=QM("1901","","年","月"); 流动资产合计 2,736,234.21 35,000.00 其他流动负债 0 0 B17=sum(B6:B16); 非流动资产： 流动负债合计 475,242.08 0 B19=QM("1503","","年","月"); 可供出售金融资产 0 0 非流动负债： B20=QM("1501","","年","月")-QM("1502","","年","月"); 持有至到期投资 0 0 长期借款 0 0 B21=QM("1531","","年","月")-QM("1541","","年","月"); 长期应收款 1,000,000.00 0 应付债券 0 0 B22=QM("1511","","年","月")-QM("1512","","年","月"); 长期股权投资 0 0 长期应付款 0 0 B23=QM("1521","","年","月"); 投资性房地产 80,000.00 0 专项应付款 0 0 B24=QM("1601","","年","月")-QM("1602","","年","月")-QM("1603","","年","月"); 固定资产 441,180.60 1,200.00 预计负债 0 0 B25=QM("1604","","年","月"); 在建工程 0 0 递延所得税负债 0 0 B26=QM("1605","","年","月"); 工程物资 0 0 其他非流动负债 B27=QM("1606","","年","月"); 固定资产清理 0 0 非流动负债合计 0 0 B28=QM("1621","","年","月")-QM("1622","","年","月"); 生产性生物资产 0 0 负债合计 475,242.08 0 B29=QM("1631","","年","月")-QM("1632","","年","月"); 油气资产 0 0 所有者权益（或股东权益）： B30=QM("1701","","年","月")-QM("1702","","年","月")-QM("1703","","年","月"); 无形资产 0 0 实收资本（或股本） 200,000.00 0 B32=QM("1711","","年","月"); 开发支出 资本公积 0 0 B33=QM("1801","","年","月"); 商誉 0 0 减：库存股 0 0 B34=QM("1811","","年","月"); 长期待摊费用 0 0 盈余公积 0 0 B36=sum(B19:B35); 递延所得税资产 0 0 未分配利润 0 0 B37=B17+B36; 其他非流动资产 所有者权益（或股东权益）合计 200,000.00 0 C6=QC("1001","","年")+QC("1002","","年")+QC("1012","","年"); 非流动资产合计 1,521,180.60 1,200.00 　 C7=QC("1101","","年"); 资产总计 4,257,414.81 36,200.00 负债和所有者权益（或股东权益）总计 675,242.08 0 C8=QC("1121","","年"); 单位负责人： 会计主管： 制表人： C9=QC("1122","","年")-QC("1231","","年"); C10=QC("1123","","年"); C11=QC("1132","","年"); C12=QC("1131","","年"); C13=QC("1221","","年"); C14=QC("1401","","年")+QC("1402","","年")+QC("1403","","年")+QC("1404","","年")+QC("1405","","年")+QC("1406","","年")+QC("1407","","年")+QC("1408","","年")+QC("1411","","年")+QC("1421","","年")+QC("1431","","年")+QC("1441","","年")+QC("1451","","年")+QC("1461","","年")-QC("1471","","年")+QC("1321","","年")-QC("2314","","年")+QC("5001","","年"); C15=QC("1901","","年"); C17=sum(C6:C16); C19=QC("1503","","年"); C20=QC("1501","","年")-QC("1502","","年"); C21=QC("1531","","年")-QC("1541","","年"); C22=QC("1511","","年")-QC("1512","","年"); C23=QC("1521","","年"); C24=QC("1601","","年")-QC("1602","","年")-QC("1603","","年"); C25=QC("1604","","年"); C26=QC("1605","","年"); C27=QC("1606","","年"); C28=QC("1621","","年")-QC("1622","","年"); C29=QC("1631","","年")-QC("1632","","年"); C30=QC("1701","","年")-QC("1702","","年")-QC("1703","","年"); C32=QC("1711","","年"); C33=QC("1801","","年"); C34=QC("1811","","年"); C36=sum(C19:C35); C37=C17+C36; E6=QM("2001","","年","月"); E7=QM("2101","","年","月"); E8=QM("2201","","年","月"); E9=QM("2202","","年","月"); E10=QM("2203","","年","月"); E11=QM("2211","","年","月"); E12=QM("2221","","年","月"); E13=QM("2231","","年","月"); E14=QM("2232","","年","月"); E15=QM("2241","","年","月"); E17=QM("2401","","年","月"); E18=sum(E6:E17); E20=QM("2501","","年","月"); E21=QM("2502","","年","月"); E22=QM("2701","","年","月"); E23=QM("2711","","年","月"); E24=QM("2801","","年","月"); E25=QM("2901","","年","月"); E27=sum(E20:E26); E28=E18+E27; E30=QM("4001","","年","月"); E31=QM("4002","","年","月"); E32=QM("4201","","年","月"); E33=QM("4101","","年","月"); E34=QM("4103","","年","月")+QM("4104","","年","月"); E35=E30+E31-E32+E33+E34; E37=E28+E35; F6=QC("2001","","年"); F7=QC("2101","","年"); F8=QC("2201","","年"); F9=QC("2202","","年"); F10=QC("2203","","年"); F11=QC("2211","","年"); F12=QC("2221","","年"); F13=QC("2231","","年"); F14=QC("2232","","年"); F15=QC("2241","","年"); F17=QC("2401","","年"); F18=sum(F6:F17); F20=QC("2501","","年"); F21=QC("2502","","年"); F22=QC("2701","","年"); F23=QC("2711","","年"); F24=QC("2801","","年"); F25=QC("2901","","年"); F27=sum(F20:F26); F28=F18+F27; F30=QC("4001","","年"); F31=QC("4002","","年"); F32=QC("4201","","年"); F33=QC("4101","","年"); F34=QC("4103","","年")+QC("4104","","年"); F35=F30+F31-F32+F33+F34; F37=F28+F35;