资产负债表--带公式

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