搜索
=YEAR()+年=MONTH()+“月”资产行次年初数流动资产:货币资金1=J_QCYE(101,1)+J_QCYE(102,1)+J_QCYE(109,1)短期投资2=J_QCYE(111,1)应收票据3=J_QCYE(112,1)应收帐款4=J_QCYE(113,1)减:坏帐准备5=D_QCYE(114,1)应收帐款净额6=C9-C10预付帐款7=J_QCYE(115,1)其它应收款9=J_QCYE(119,1)存货10=J_QCYE(121,1)+J_QCYE(123,1)+J_QCYE(128,1)+J_QCYE(129,1)+J_QCYE(131,1)+J_QCYE(133,1)+J_QCYE(135,1)+C12J_QCYE(138,1)+J_QCYE(401,1)待摊费用12J_QCYE(139,1)待处理流动资产净损失13一年内到期的长期债券投资14其它流动资产15流动资产合计20=C6+C7+C8+C11+C12+C13+C14+C15+C17+C18长期投资:长期投资21=J_QCYE(151,1)固定资产:固定资产原价24=J_QCYE(161,1)减:累计折旧25=D_QCYE(165,1)固定资产净值26=C23-C24固定资产清理27=J_QCYE(166,1)在建工程28=J_QCYE(169,1)待处理固定资产净损失29固定资产合计35=C25+C26+C27无形及递延资产:无形资产36=J_QCYE(171,1)递延资产37=J_QCYE(181,1)无形及递延资产合计40=C31+C32其它资产:其它长期资产41递延税项：递延税款借项资产总计45=C19+C21+C29+C33+D35+C37资产负债表=“编制单位:+DWMC()期末数负债及所有者权益行次流动负债:=J_QMYE(101)+J_QMYE(102)+J_QMYE(109)短期借款46=J_QMYE(111)应付票据47=J_QMYE(112)应付帐款48=J_QMYE(113)预收帐款49=D_QMYE(114)其它应付款50D9-D10应付工资51=J_QMYE(115)应付福利费52=J_QMYE(119)未交税金53=J_QMYE(121)+J_QMYE(123)+J_QMYE(128)+J_QMYE(129)+J_QMYE(131)+J_QMYE(133)+J_QMYE(135)+J_QMYE(138)+J_QMYE(401)未付利润54=J_QMYE(139)其它未交款55预提费用56一年内到期的长期负债58=D6+D7+D8+D11+D12+D13+D14+D15+D17+D18其它流动负债59流动负债合计65=J_QMYE(151)长期负债:=J_QMYE(161)长期借款66=D_QMYE(165)应付债券67=D23-D24长期应付款68=J_QMYE(166)其它长期负债75=J_QMYE(169)长期负债合计76递延税项：=D25+D26+D27递延税款贷项77所有者权益：=J_QMYE(171)实收资本78=J_QMYW(181)资本公积79=D31+D32盈余公积80未分配利润：81所有者权益合计：85=D19+D21+D29+D33+D35+D37负债及所有者权益总计90资产负债表会工01表单位：年初数期末数=D_QCYE(201,1)=D_QMYE(201)=D_QCYE(202,1)=D_QMYE(202)=D_QCYE(203,1)=D_QMYE(203)=D_QCYE(204,1)=D_QMYE(204)=D_QCYE(209,1)=D_QMYE(209)=D_QCYE(211,1)=D_QMYE(211)=D_QCYE(214,1)=D_QMYE(214)=D_QCYE(221,1)=D_QMYE(221)=D_QCYE(223,1)=D_QMYE(223)=D_QCYE(229,1)D_QMYE(229)=D_QCYE(231,1)=D_QMYE(231)=SUM(G6:G19)=SUM(H6:H19)=D_QCYE(241,1)=D_QMYE(241)=SUM(G23:G26)=SUM(H23:H26)=D_QCYE(301,1)=D_QMYE(301)=D_QCYE(311,1)=D_QMYE(311)=D_QCYE(313,1)=D_QMYE(313)=D_QCYE(321,1)-D_QCYE(322,1)=D_QMYE(321)-D_QMYE(322)=SUM(G31:G34)=SUM(H31:H34)=G20+G27+G29+G35=H20+H27+H29+H35制表：资产负债表