配色: 字号:
合并财务报表模板--带数据(2).xls
2020-08-30 | 阅:  转:  |  分享 
  
Sheet3

Sheet2

Sheet1

资产负债表(一)

编制单位:母公司

单位:万元

资产

期末

期初

负债和所有者权益

货币资金

应付账款

交易性金融资产

其他应付款

应收账款净额

负债合计

其他应收款净额

存货

实收资本

流动资产合计

盈余公积

固定资产净额

未分配利润

无形资产

所有者权益合计

非流动资产合计

资产总计

负债和所有者权益合计

资产负债表(二)

长期股权投资

资产负债表(三)

编制单位:子公司

资产负债表(四)

应收账款

固定资产

资产负债表(五)

合并资产负债表(六)

母公司

子公司

抵销分录

合并数

合并利润表(七)

2018年1-12月

项目

营业收入

营业成本

营业税金及附加

销售费用

管理费用

财务费用

资产减值损失

营业利润

营业外收入

利润总额

所得税费用

净利润

合并资产负债表(八)

减:坏账准备

合并利润表(九)

合并资产负债表(十)

合并利润表(十一)

合并资产负债表(十二)

合并利润表(十三)

合并资产负债表(十四)

其他应收款

合并利润表(十五)

本期数

上期数

资产负债表(十六)

资本公积

资产负债表(十七)

合并资产负债表(十八)

归属于母公司权益

少数股东权益

合并利润表(十九)

少数股东权益=期初少数股东权益+当期少股东净利润

股东权益=期初股东权益+当期股东净利润

归属于母公司净利润

少数股东净利润

合并资产负债表(二十)

合并利润表(二十一)

?2018?/?1?/?1

¥800.00

¥300.00

¥300.00

¥1,000.00

¥95.00

¥1,300.00

¥95.00

¥200.00

¥500.00

¥1,490.00

¥20.00

¥500.00

¥180.00

¥10.00

¥700.00

¥510.00

¥2,000.00

¥2,000.00

?2018?/?1?/?1

¥300.00

800.00

500.00

¥300.00

¥300.00

¥1,000.00

¥95.00

¥1,300.00

¥95.00

¥200.00

¥500.00

¥990.00

¥20.00

¥500.00

¥180.00

¥500.00

¥10.00

¥700.00

¥1,010.00

¥2,000.00

¥2,000.00

?2018?/?1?/?1

¥500.00

¥.00

¥500.00

¥500.00

¥500.00

¥.00

¥500.00

¥500.00

?2018?/?1?/?1

¥200.00

¥500.00

¥50.00

¥200.00

¥50.00

¥250.00

¥100.00

¥.00

¥500.00

¥500.00

¥650.00

¥500.00

¥15.00

¥100.00

¥135.00

¥650.00

¥500.00

¥100.00

¥.00

¥750.00

¥500.00

¥750.00

¥500.00

?2018?/?1?/?1

¥526.25

¥300.00

800.00

500.00

¥300.00

¥300.00

¥300.00

¥300.00

¥1,000.00

¥1,000.00

¥95.00

¥95.00

¥1,300.00

¥1,300.00

¥95.00

¥95.00

¥200.00

¥200.00

¥500.00

¥500.00

¥1,216.25

¥990.00

37.63

¥20.00

¥500.00

¥500.00

338.63

¥180.00

¥450.00

¥500.00

¥10.00

¥10.00

¥876.25

¥700.00

¥960.00

¥1,010.00

¥2,176.25

¥2,000.00

¥2,176.25

¥2,000.00

?2018?/?1?/?1

¥526.25

¥200.00

¥726.25

¥300.00

¥50.00

¥350.00

¥300.00

¥300.00

¥1,000.00

¥50.00

¥1,050.00

¥95.00

¥200.00

¥295.00

¥1,300.00

¥100.00

¥.00

¥1,400.00

¥95.00

¥95.00

¥200.00

¥250.00

¥450.00

¥500.00

¥500.00

¥-500.00

¥500.00

¥1,216.25

¥650.00

¥.00

¥1,866.25

37.63

¥15.00

¥-15.00

37.63

¥500.00

¥-500.00

¥.00

338.63

¥135.00

¥15.00

488.63

¥450.00

¥100.00

¥550.00

¥.00

¥10.00

¥10.00

¥876.25

¥650.00

¥-500.00

¥1,026.25

¥960.00

¥100.00

¥-500.00

¥560.00

¥2,176.25

¥750.00

¥-500.00

¥2,426.25

¥2,176.25

¥750.00

¥-500.00

¥2,426.25

¥1,000.00

¥500.00

¥1,500.00

¥500.00

¥171.50

¥671.50

¥52.50

¥27.50

¥80.00

¥100.00

¥50.00

¥150.00

¥120.00

¥50.00

¥170.00

¥2.50

¥1.00

¥3.50

¥10.00

¥10.00

¥215.00

¥200.00

¥.00

¥415.00

¥20.00

¥20.00

¥235.00

¥200.00

¥.00

¥435.00

¥58.75

¥50.00

¥108.75

¥176.25

¥150.00

¥.00

¥326.25

?2018?/?1?/?1

¥526.25

¥200.00

¥726.25

¥300.00

¥50.00

¥-50.00

¥300.00

¥300.00

¥300.00

¥1,000.00

¥50.00

¥-50.00

¥1,000.00

¥100.00

¥200.00

¥-50.00

¥250.00

¥1,300.00

¥100.00

¥-100.00

¥1,300.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥200.00

¥-47.50

¥247.50

¥100.00

¥-50.00

¥50.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥.00

¥-47.50

¥47.50

¥200.00

¥250.00

¥450.00

¥500.00

¥500.00

¥-500.00

¥500.00

¥1,216.25

¥650.00

¥-95.00

¥1,771.25

37.63

¥15.00

¥-15.00

37.63

¥500.00

¥-500.00

¥.00

338.63

¥135.00

¥20.00

15.00

5.00

493.63

¥450.00

¥100.00

¥550.00

¥.00

¥10.00

¥10.00

¥876.25

¥650.00

¥-495.00

¥1,031.25

¥960.00

¥100.00

¥-500.00

¥560.00

¥2,176.25

¥750.00

¥-595.00

¥2,331.25

¥2,176.25

¥750.00

¥-595.00

¥2,331.25

¥.00

¥1,000.00

¥500.00

¥1,500.00

¥500.00

¥171.50

¥671.50

¥52.50

¥27.50

¥80.00

¥100.00

¥50.00

¥150.00

¥120.00

¥50.00

¥170.00

¥2.50

¥1.00

¥3.50

¥10.00

¥-5.00

¥5.00

¥215.00

¥200.00

¥5.00

¥420.00

¥20.00

¥20.00

¥235.00

¥200.00

¥5.00

¥440.00

¥58.75

¥50.00

¥108.75

¥176.25

¥150.00

¥5.00

¥331.25

?2018?/?12?/?31

¥526.25

¥200.00

¥726.25

¥300.00

¥50.00

¥-50.00

¥300.00

¥300.00

¥300.00

¥1,000.00

¥50.00

¥-50.00

¥1,000.00

¥100.00

¥200.00

¥-50.00

¥250.00

¥1,300.00

¥100.00

¥-100.00

¥1,300.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥200.00

¥-47.50

¥247.50

¥100.00

¥-50.00

¥50.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥.00

¥-47.50

¥47.50

¥200.00

¥250.00

¥-50.00

¥400.00

¥500.00

¥500.00

¥-500.00

¥500.00

¥1,216.25

¥650.00

¥-145.00

¥1,721.25

37.63

¥15.00

¥-15.00

37.63

¥500.00

¥-500.00

¥.00

338.63

¥135.00

¥-30.00

15.00

5.00

50.00

443.63

¥450.00

¥100.00

¥550.00

¥.00

¥10.00

¥10.00

¥876.25

¥650.00

¥-545.00

¥981.25

¥960.00

¥100.00

¥-500.00

¥560.00

¥2,176.25

¥750.00

¥-645.00

¥2,281.25

¥2,176.25

¥750.00

¥-645.00

¥2,281.25

¥.00

¥1,000.00

¥500.00

-250.00

¥1,250.00

¥500.00

¥171.50

-200.00

¥471.50

¥52.50

¥27.50

¥80.00

¥100.00

¥50.00

¥150.00

¥120.00

¥50.00

¥170.00

¥2.50

¥1.00

¥3.50

¥10.00

¥-5.00

¥5.00

¥215.00

¥200.00

¥-45.00

¥370.00

¥20.00

¥20.00

¥235.00

¥200.00

¥-45.00

¥390.00

¥58.75

¥50.00

¥108.75

¥176.25

¥150.00

¥-45.00

¥281.25

?2018?/?12?/?31

¥526.25

¥200.00

¥726.25

¥300.00

¥50.00

¥-50.00

¥300.00

¥300.00

¥300.00

¥1,000.00

¥50.00

¥-50.00

¥1,000.00

¥100.00

¥200.00

¥-50.00

¥250.00

¥1,300.00

¥100.00

¥-100.00

¥1,300.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥200.00

¥-47.50

¥247.50

¥100.00

¥-50.00

¥50.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥.00

¥-47.50

¥47.50

¥200.00

¥250.00

¥-50.00

¥400.00

¥500.00

¥500.00

¥-500.00

¥500.00

¥1,216.25

¥650.00

¥-145.00

¥1,721.25

37.63

¥15.00

¥-15.00

37.63

¥500.00

¥-500.00

¥.00

338.63

¥135.00

¥-50.00

15.00

5.00

50.00

20.00

423.63

¥450.00

¥100.00

¥-20.00

¥530.00

¥.00

¥10.00

¥10.00

¥876.25

¥650.00

¥-565.00

¥961.25

¥960.00

¥100.00

¥-520.00

¥540.00

¥2,176.25

¥750.00

¥-665.00

¥2,261.25

¥2,176.25

¥750.00

¥-665.00

¥2,261.25

¥.00

¥1,000.00

¥500.00

-250.00

¥1,250.00

¥500.00

¥171.50

-200.00

¥471.50

¥52.50

¥27.50

¥80.00

¥100.00

¥50.00

¥150.00

¥120.00

¥50.00

¥170.00

¥2.50

¥1.00

¥3.50

¥10.00

¥-5.00

¥5.00

¥215.00

¥200.00

¥-45.00

¥370.00

¥20.00

-20.00

¥.00

¥235.00

¥200.00

¥-65.00

¥370.00

¥58.75

¥50.00

¥108.75

¥176.25

¥150.00

¥-65.00

¥261.25

?2018?/?12?/?31

¥726.25

¥800.00

800.00

¥300.00

¥300.00

¥300.00

¥300.00

¥1,000.00

¥1,000.00

¥250.00

¥100.00

¥1,300.00

¥1,300.00

¥2.50

¥5.00

¥247.50

¥95.00

¥50.00

¥100.00

¥2.50

¥5.00

¥47.50

¥95.00

¥400.00

¥200.00

¥500.00

¥500.00

¥1,721.25

¥1,490.00

37.63

¥20.00

423.63

¥180.00

¥530.00

¥500.00

¥10.00

¥10.00

¥961.25

¥700.00

¥540.00

¥510.00

¥2,261.25

¥2,000.00

¥2,261.25

¥2,000.00

¥1,250.00

¥1,000.00

¥471.50

¥500.00

¥80.00

¥52.50

¥150.00

¥100.00

¥170.00

¥100.00

¥3.50

¥2.50

¥5.00

¥10.00

¥370.00

¥235.00

¥370.00

¥235.00

¥108.75

¥59.75

¥261.25

¥175.25

?2018?/?1?/?1

¥625.00

¥.00

¥500.00

¥625.00

¥125.00

¥625.00

¥.00

¥625.00

¥625.00

?2018?/?12?/?31

¥325.00

200.00

125.00

¥625.00

¥50.00

¥200.00

¥50.00

¥250.00

¥100.00

¥.00

¥500.00

¥500.00

¥775.00

¥625.00

¥125.00

¥125.00

¥100.00

¥15.00

¥135.00

¥775.00

¥625.00

¥100.00

¥.00

¥875.00

¥625.00

¥875.00

¥625.00

?2018?/?12?/?31

¥526.25

¥325.00

¥851.25

¥300.00

¥50.00

¥-50.00

¥300.00

¥300.00

¥300.00

¥1,000.00

¥50.00

¥-50.00

¥1,000.00

¥100.00

¥200.00

¥-50.00

¥250.00

¥1,300.00

¥100.00

¥-100.00

¥1,300.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥200.00

¥-47.50

¥247.50

¥100.00

¥-50.00

¥50.00

¥5.00

¥-2.50

¥2.50

¥95.00

¥.00

¥-47.50

¥47.50

¥500.00

¥500.00

¥-500.00

¥500.00

¥200.00

¥250.00

¥-50.00

¥400.00

¥125.00

¥-125.00

¥.00

¥1,216.25

¥775.00

¥-145.00

¥1,846.25

37.63

¥15.00

¥-15.00

37.63

¥500.00

¥-500.00

¥.00

338.63

¥135.00

¥-80.00

15.00

5.00

50.00

20.00

150.00

20.00

393.63

¥450.00

¥100.00

¥-20.00

¥530.00

¥876.25

¥775.00

¥-720.00

931.25

¥10.00

¥10.00

¥155.00

20.00

155.00

¥960.00

¥100.00

¥-520.00

¥540.00

¥876.25

¥775.00

¥-565.00

¥1,086.25

¥2,176.25

¥875.00

¥-665.00

¥2,386.25

¥2,176.25

¥875.00

¥-665.00

¥2,386.25

¥.00

125.00

¥1,000.00

¥500.00

-250.00

¥1,250.00

150.00

¥500.00

¥171.50

-200.00

¥471.50

.20

¥52.50

¥27.50

¥80.00

155.00

¥100.00

¥50.00

¥150.00

¥120.00

¥50.00

¥170.00

¥180.00

876.25

¥2.50

¥1.00

¥3.50

231.25

150.00

¥10.00

¥-5.00

¥5.00

-17.63

.80

¥215.00

¥200.00

¥-45.00

¥370.00

393.63

.00

996.25

65.00

¥20.00

-20.00

¥.00

¥235.00

¥200.00

¥-65.00

¥370.00

¥58.75

¥50.00

¥108.75

¥176.25

¥150.00

¥-65.00

¥261.25

¥231.25

¥30.00

20.00

?2018?/?12?/?31

¥851.25

¥800.00

800.00

¥300.00

¥300.00

¥300.00

¥300.00

¥1,000.00

¥1,000.00

¥250.00

¥100.00

¥1,300.00

¥1,300.00

¥2.50

¥5.00

¥247.50

¥95.00

¥50.00

¥100.00

¥2.50

¥5.00

¥500.00

¥500.00

¥47.50

¥95.00

¥400.00

¥200.00

37.63

¥20.00

¥1,846.25

¥1,490.00

393.63

¥180.00

¥931.25

¥700.00

¥530.00

¥500.00

155.00

¥10.00

¥10.00

¥1,086.25

¥700.00

¥540.00

¥510.00

¥2,386.25

¥2,000.00

¥2,386.25

¥2,000.00

¥1,250.00

¥1,000.00

¥471.50

¥500.00

¥80.00

¥52.50

¥150.00

¥100.00

¥170.00

¥100.00

¥3.50

¥2.50

¥5.00

¥10.00

¥370.00

¥235.00

¥370.00

¥235.00

¥108.75

¥59.75

¥261.25

¥175.25

¥231.25

¥30.00

献花(0)
+1
(本文系李玉民_图书...首藏)