资产负债表Excel表格模板2023最新版

这是一款资产负债表Excel表格模板，资产负债表（the Balance Sheet）亦称财务状况表，表示企业在一定日期（通常为各会计期末）的财务状况（即资产、负债和业主权益的状况）的主要会计报表。资产负债表利用会计平衡原则，将合乎会计原则的资产、负债、股东权益等交易科目分为“资产”和“负债及股东权益”两大区块，在经过分录、转账、分类账、试算、调整等等会计程序后，以特定日期的静态企业情况为基准，浓缩成一张报表。其报表功用除了企业内部除错、经营方向、防止弊端外，也可让所有阅读者于最短时间了解企业经营状况。

"资产负债表"
"资 产 负 债 表"
"会企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
"企业负责人: 主管会计: 制表: 报出日期: 年 月 日"