资产负债表表格excel

我前两年在银行职员,近期依据几个网民体现必须资产负债表,在网上下的都不太好,因此我今日把全新的资产负债表和本年利润，空缺的excel版给予出去，永久免费！

"资产负债表"

"资 产 负 债 表"

"会企01表"

"定编企业: 年 月 单位:元"

"资 产","行次","今年初数","期末数","债务和所有者权益","行次","今年初数","期末数"

,,,,"(或股东权益)"

"速动资产:",,,,"营业利润:"

" 流动资产",1,,," 短期贷款",68

" 短期投资",2,,," 应付票据",69

" 应收票据",3,,," 应付款",70

" 应收股利",4,,," 应收帐款",71

" 应收利息",5,,," 应付工资",72

" 应收账款",6,,," 应付福利费",73

" 其他应收款",7,,," 应付股利",74

" 预收账款",8,,," 应交税费",75

" 应收款补贴款",9,,," 其他应收款",80

" 库存商品",10,,," 其他应收款",81

" 摊销费",11,,," 预提费用",82

" 一年内过期的长期性债权投资",21,,," 预计负债",83

" 其他流动资产",24,,," 一年内过期的长期负债",86

" 流动资产合计",31,,," 别的营业利润",90

"长线投资:"

" 长期股权投资",32,,," 流动负债合计",100

" 长期性债权投资",34,,,"长期负债:"

" 长线投资累计",38,,," 长期贷款",101

"固资:",,,," 应付债券",102

" 固定资产售价",39,,," 长期应付款",103

" 减:固定资产折旧",40,,," 专项应付款",106

" 固定资产净值",41,,," 别的长期负债",108

" 减:固定不动资产减值损失",42,,," 长期负债累计",110

" 固资净收益",43,,,"延递税费:"

" 工程物资",44,,," 递延税款贷项",111

" 在建项目",45,,," 负债合计",114

" 固定资产清理",46

" 固定资产合计",50,,,"所有者权益(或股东权益):"

"无形资产以及他财产:",,,," 资本公积(或总股本)",115

" 无形资产",51,,," 减:已偿还项目投资",116

" 长期待摊费用",52,,," 资本公积(或总股本)净收益",117

" 别的长期资产",53,,," 资本公积",118

" 无形资产以及他资产合计",60,,," 法定盈余公积",119

,,,," 在其中:法定公益金",120

"延递税费:",,,," 未分配利润",121

" 递延税款借项",61,,," 所有者权益(或股东权益)累计",122

" 财产累计",67,,," 债务和所有者权益(或股东权益)累计",135

"主要负责人: 主管会计: 造表: 给出日期: 年 月 日"