资产负债表表格 资产负债表电子版免费下载

老铁们，大家好，相信还有很多朋友对于资产负债表表格和资产负债表电子版免费下载的相关问题不太懂，没关系，今天就由我来为大家分享分享资产负债表表格以及资产负债表电子版免费下载的问题，文章篇幅可能偏长，希望可以帮助到大家，下面一起来看看吧！

最新资产负债表表格

资产负债表

2010年12月31日

编制单位：单位:元

资产"行

次"年初数期末数负债及所有者权益"行

次"年初数期末数

流动资产:流动负债:

货币资金 1短期借款 30

短期投资 2应付票据 31

应收票据 3应付帐款 32

应收帐款 4预收帐款 33

减:坏帐准备 5其他应付款 34

应收帐款净额 6应付工资 35

预付帐款 7应付福利费 36

应收补贴款 8应交税金 37

其他应收款 9应付利润 38

存货 10其他应交款 39

待摊费用 11预提费用 40

待处理流动资产净损失 12一年内到期的长期负债 41

一年内到期的长期债券投资 13其他流动负债 42

其他流动资产 14

流动负债合计 43

流动资产合计 15长期负债:

长期投资:长期借款 44

长期投资 16应付债券 45

固定资产: 46

固定资产原值 17其他长期负债 47

减:累计折旧 18其中:住房周转金 48

固定资产净值 19

固定资产清理 20长期负债合计 49

在建工程 21递延税项:

待处理固定资产净损失 22递延税款贷项 50

固定资产合计 23

无形资产及递延资产:负债合计 51

无形资产 24所有者权益:

递延资产 25实收资本 52

资本公积 53

无形及递延资产合计 26盈余公积 54

其他长期资产:其中:公益金 55

其他长期资产 27未分配利润 56

递延税项:所有者权益合计 57

递延税款借项 28

资产合计 29负债及所有者权益合计 58

单位负责人：财务负责人：制表：

资产负债表的表格

资产负债表“年初数”栏内各数据填写:

资产负债表“年初数”栏内各数据，应根据上年末资产负债表“年末数”栏内所示数字填列。如果本年度该表规定的各个项目的名称和内容与上一年不一致，应对上年末该表各项目的名称和数字按照本年度规定加以调整后，再列入本年度该表“年初数”栏内。

资产负债表是根据总账账户期末余额分析填列的。

(1)根据有关二级账户或明细账户的期末余额直接填列。

1、资产类项目有：待处理流动资产净损失和待处理固定资产净损失，分别根据“待处理财产损溢”账户所属“待处理流动资产损溢”和“待处理固定资产损溢”二级账户的期末借方余额填列，如为贷方余额应以负数填列。

2、负债类项目有：公益金，根据“盈余公积”账户所属“公益金”(或

“法定公益金”)二级账户的期末贷方余额填列。

(2)根据同类的几个总账账户的期末余额合并或抵减填列。

1、资产类的货币资金项目，根据“现金”、“银行存款”、“其他货币资金”等账户的期末余额合并填列。

2、资产类的存货项目，根据“材料采购”(或“在途材料”)、“原材料”、“包装物”、“低值易耗品”、“材料成本差异”、“委托加工材料”、

“自制半成品”、“产成品”、“分期收款发出商品”、“生产成本”等账户的期末余额合并填列(“材料成本差异”账户如出现贷方余额应予抵减)。

3、资产类的固定资产净值项目，根据“固定资产”账户借方余额减去“累计折旧”账户贷方余额后的净额填列。

4、所有者权益类的未分配利润项目，在月(季)报中，根据“本年利润”账户期末余额和“利润分配”账户期末余额合并或相减后的数额填列(如果采用表结法，则实现净利润额应根据损益类账户的期末余额计算确定)；在年报中，则可根据“利润分配”账户的年末余额直接填列，如为未弥补亏损，应以负数填列。

(3)根据总账账户或明细账户的期末余额分析计算填列

1、资产类待摊费用项目和负债类预提费用项目，一般分别根据“待摊费用”账户期末借方余额和“预提费用”账户期末贷方余额填列。但

“预提费用”账户如有借方余额，应并人待摊费用项目。

2、资产类的应收账款项目和负债类的预收账款项目，分别根据“应收账款”账户所属有关明细账户的借方余额合计和“预收账款”账户所属有关明细账户的贷方余额合计填列。如前者有贷方余额或后者有借方余额，则应分别并人预收账款项目或应收账款项目。应收账款项目填列后，减去坏账准备的差额，可据以填列应收账款净额项目。

3、资产类预付账款项目和负债类应付账款项目，分别根据“预付账款”账户所属有关明细账户的借方余额合计和“应付账款”账户所属有关明细账户的贷方余额合计填列。如前者有贷方余额或后者有借方余额，则应分别并入应付账款项目或预付账款项目。

4、资产类的“一年内到期的长期债券投资”项目和长期投资项目，前者根据“长期投资——债券投资”账户所属明细账户期末余额中存续期已不足一年的部分计算填列；后者根据“长期投资”账户期末余额减去前者的差额填列。

5、负债类的“一年内到期的长期负债”项目和长期借款、应付债券、长期应付款、其他长期负债等项目，前者根据“长期借款”等各个长期负债账户所属明细账户期末余额中偿还期已不足一年的部分计算填列；后者(长期借款等项目)根据“长期借款”等各账户期末余额减去将于一年内到期偿还的各该项负债的差额填列。

满意请采纳。

求用友U8中的资产负责表,损益表等表的公式

资产负债表：

//资产类年初数

//流动资产

LET C6=QC("1001",全年,,"001",年,,,,)

LET C6=C6+QC("1002",全年,,"001",年,,,,)

LET C6=C6+QC("1012",全年,,"001",年,,,,)

LET C7=QC("1101",全年,,"001",年,,,,)

LET C8=QC("1121",全年,,"001",年,,,,)

LET C9=QC("1122",全年,,"001",年,,,,)

LET C9=C9-QC("123101",全年,,"001",年,,,,)

LET C10=QC("1123",全年,,"001",年,,,,)

LET C11=QC("1132",全年,,"001",年,,,,)

LET C12=QC("1131",全年,,"001",年,,,,)

LET C13=QC("1221",全年,,"001",年,,,,)

LET C13=C13-QC("123102",全年,,"001",年,,,,)

LET C14=QC("1401",全年,,"001",年,,,,)

LET C14=C14+QC("1402",全年,,"001",年,,,,)

LET C14=C14+QC("1403",全年,,"001",年,,,,)

LET C14=C14+QC("1404",全年,,"001",年,,,,)

LET C14=C14+QC("1405",全年,,"001",年,,,,)

LET C14=C14+QC("1406",全年,,"001",年,,,,)

LET C14=C14+QC("1408",全年,,"001",年,,,,)

LET C14=C14+QC("1409",全年,,"001",年,,,,)

LET C14=C14+QC("1410",全年,,"001",年,,,,)

LET C14=C14+QC("1411",全年,,"001",年,,,,)

LET C14=C14+QC("1412",全年,,"001",年,,,,)

LET C14=C14-QC("1471",全年,,"001",年,,,,)

LET C14=C14+QC("5001",全年,,"001",年,,,,)

LET C14=C14+QC("5101",全年,,"001",年,,,,)

LET C16=QC("1504",全年,,"001",年,,,,)

LET C17=PTOTAL(C6:C16)

//非流动资产

LET C19=QC("1503",全年,,"001",年,,,,)

LET C20=QC("1501",全年,,"001",年,,,,)

LET C20=C20-QC("1502",全年,,"001",年,,,,)

LET C21=QC("1531",全年,,"001",年,,,,)

LET C22=QC("1511",全年,,"001",年,,,,)

LET C22=C22-QC("1512",全年,,"001",年,,,,)

LET C23=QC("1521",全年,,"001",年,,,,)

LET C23=C23-QC("1522",全年,,"001",年,,,,)

LET C24=QC("1601",全年,,"001",年,,,,)

LET C24=C24-QC("1602",全年,,"001",年,,,,)

LET C24=C24-QC("1603",全年,,"001",年,,,,)

LET C25=QC("1604",全年,,"001",年,,,,)

LET C26=QC("1605",全年,,"001",年,,,,)

LET C27=QC("1606",全年,,"001",年,,,,)

LET C30=QC("1701",全年,,"001",年,,,,)

LET C30=C30-QC("1702",全年,,"001",年,,,,)

LET C30=C30-QC("1703",全年,,"001",年,,,,)

LET C32=QC("1711",全年,,"001",年,,,,)

LET C33=QC("1801",全年,,"001",年,,,,)

LET C34=QC("1811",全年,,"001",年,,,,)

LET C35=QC("1902",全年,,"001",年,,,,)

LET C36=PTOTAL(C19:C35)

//资产类总计

LET C37=C17+C36

//流动负债

LET G6=QC("2001",全年,,"001",年,,,,)

LET G7=QC("2101",全年,,"001",年,,,,)

LET G8=QC("2201",全年,,"001",年,,,,)

LET G9=QC("2202",全年,,"001",年,,,,)

LET G10=QC("2203",全年,,"001",年,,,,)

LET G11=QC("2211",全年,,"001",年,,,,)

LET G12=QC("2221",全年,,"001",年,,,,)

LET G12=G12+QC("2222",全年,,"001",年,,,,)

LET G13=QC("2231",全年,,"001",年,,,,)

LET G14=QC("2232",全年,,"001",年,,,,)

LET G15=QC("2241",全年,,"001",年,,,,)

LET G17=QC("2242",全年,,"001",年,,,,)

LET G18=PTOTAL(G6:G17)

//非流动负债

LET G20=QC("2501",全年,,"001",年,,,,)

LET G21=QC("2502",全年,,"001",年,,,,)

LET G22=QC("2701",全年,,"001",年,,,,)

LET G23=QC("2711",全年,,"001",年,,,,)

LET G24=QC("2801",全年,,"001",年,,,,)

LET G25=QC("2901",全年,,"001",年,,,,)

LET G27=PTOTAL(G20:G26)

//负债合计

LET G28=G18+G27

//股东权益

LET G30=QC("4001",全年,,"001",年,,,,)

LET G31=QC("4002",全年,,"001",年,,,,)

LET G33=QC("4101",全年,,"001",年,,,,)

LET G34=QC("4103",全年,,"001",年,,,,)

LET G34=G34+QC("4104",全年,,"001",年,,,,)

LET g36=G30+G31-G32+G33+G34

//负债和股东权益合计

LET G37=G28+g36

//期末数

//资产类期限末数

//流动资产

LET D6=QM("1001",月,,"001",年,,,,)

LET D6=D6+QM("1002",月,,"001",年,,,,)

LET D6=D6+QM("1012",月,,"001",年,,,,)

LET D7=QM("1101",月,,"001",年,,,,)

LET D8=QM("1121",月,,"001",年,,,,)

LET D9=QM("1122",月,,"001",年,,,,)

LET D9=D9-QM("123101",月,,"001",年,,,,)

LET D10=QM("1123",月,,"001",年,,,,)

LET D11=QM("1132",月,,"001",年,,,,)

LET D12=QM("1131",月,,"001",年,,,,)

LET D13=QM("1221",月,,"001",年,,,,)

LET D13=D13-QM("123102",月,,"001",年,,,,)

LET D14=QM("1401",全年,,"001",年,,,,)

LET D14=D14+QM("1402",月,,"001",年,,,,)

LET D14=D14+QM("1403",月,,"001",年,,,,)

LET D14=D14+QM("1404",月,,"001",年,,,,)

LET D14=D14+QM("1405",月,,"001",年,,,,)

LET D14=D14+QM("1406",月,,"001",年,,,,)

LET D14=D14+QM("1408",月,,"001",年,,,,)

LET D14=D14+QM("1409",月,,"001",年,,,,)

LET D14=D14+QM("1410",月,,"001",年,,,,)

LET D14=D14+QM("1411",月,,"001",年,,,,)

LET D14=D14+QM("1412",月,,"001",年,,,,)

LET D14=D14-QM("1471",月,,"001",年,,,,)

LET D14=D14+QM("5001",月,,"001",年,,,,)

LET D14=D14+QM("5101",月,,"001",年,,,,)

LET D16=QM("1504",月,,"001",年,,,,)

LET D17=PTOTAL(D6:D16)

//非流动资产

LET D19=QM("1503",月,,"001",年,,,,)

LET D20=QM("1501",月,,"001",年,,,,)

LET D20=D20-QM("1502",月,,"001",年,,,,)

LET D21=QM("1531",月,,"001",年,,,,)

LET D22=QM("1511",月,,"001",年,,,,)

LET D22=D22-QM("1512",月,,"001",年,,,,)

LET D23=QM("1521",月,,"001",年,,,,)

LET D23=D23-QM("1522",月,,"001",年,,,,)

LET D24=QM("1601",月,,"001",年,,,,)

LET D24=D24-QM("1602",月,,"001",年,,,,)

LET D24=D24-QM("1603",月,,"001",年,,,,)

LET D25=QM("1604",月,,"001",年,,,,)

LET D26=QM("1605",月,,"001",年,,,,)

LET D27=QM("1606",月,,"001",年,,,,)

LET D30=QM("1701",月,,"001",年,,,,)

LET D30=D30-QM("1702",月,,"001",年,,,,)

LET D30=D30-QM("1703",月,,"001",年,,,,)

LET D32=QM("1711",月,,"001",年,,,,)

LET D33=QM("1801",月,,"001",年,,,,)

LET D34=QM("1811",月,,"001",年,,,,)

LET D35=QM("1902",月,,"001",年,,,,)

LET D36=PTOTAL(D19:D35)

//资产类总计

LET D37=D17+D36

//流动负债

LET H6=QM("2001",月,,"001",年,,,,)

LET H7=QM("2101",月,,"001",年,,,,)

LET H8=QM("2201",月,,"001",年,,,,)

LET H9=QM("2202",月,,"001",年,,,,)

LET H10=QM("2203",月,,"001",年,,,,)

LET H11=QM("2211",月,,"001",年,,,,)

LET H12=QM("2221",月,,"001",年,,,,)

LET H12=H12+QM("2222",月,,"001",年,,,,)

LET H13=QM("2231",月,,"001",年,,,,)

LET H14=QM("2232",月,,"001",年,,,,)

LET H15=QM("2241",月,,"001",年,,,,)

LET H17=QM("2242",月,,"001",年,,,,)

LET H18=PTOTAL(H6:H17)

//非流动负债

LET H20=QM("2501",月,,"001",年,,,,)

LET H21=QM("2502",月,,"001",年,,,,)

LET H22=QM("2701",月,,"001",年,,,,)

LET H23=QM("2711",月,,"001",年,,,,)

LET H24=QM("2801",月,,"001",年,,,,)

LET H25=QM("2901",月,,"001",年,,,,)

LET H27=PTOTAL(H20:H26)

//负债合计

LET H28=H18+H27

//股东权益

LET H30=QM("4001",月,,"001",年,,,,)

LET H31=QM("4002",月,,"001",年,,,,)

LET H33=QM("4101",月,,"001",年,,,,)

LET H34=QM("4103",月,,"001",年,,,,)

LET H34=H34+QM("4104",月,,"001",年,,,,)

LET h36=H30+H31-H32+H33+H34

//负债和股东权益合计

LET H37=H28+H36

IF H37=D37 AND C37=G37

DISP"用友软件","报表平衡！！"

ELSE

DISP"用友软件","报表不平衡！！"

END IF

损益表：

//

LET C6=FS("6001",月,"贷","001",年,,,"y")

LET C6=C6+FS("6051",月,"贷","001",年,,,"y")

LET C7=FS("6401",月,"借","001",年,,,"y")

LET C7=C7+FS("6402",月,"借","001",年,,,"y")

LET C8=FS("6403",月,"借","001",年,,,"y")

LET C9=FS("6601",月,"借","001",年,,,"y")

LET C10=FS("6602",月,"借","001",年,,,"y")

LET C11=FS("6603",月,"借","001",年,,,"y")

LET C12=FS("6701",月,"借","001",年,,,"y")

LET C16=C6-C7-C8-C9-C10-C11-C12+C13+C14

LET C17=FS("6301",月,"贷","001",年,,,"y")

LET C17=C17+FS("6112",月,"贷","001",年,,,"y")

LET C18=FS("6711",月,"借","001",年,,,"y")

LET C20=C16+C17-C18

LET C21=FS("6801",月,"借","001",年,,,"y")

LET C22=C20-C21

//累计数

LET D=C+SELECT(D,年@=年 AND月@=月+1)