资产负债表表格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
"主要负责人: 主管会计: 造表: 给出日期: 年 月 日"