报表.docx
《报表.docx》由会员分享,可在线阅读,更多相关《报表.docx(7页珍藏版)》请在冰豆网上搜索。
报表
现金流量表
经营活动
消售:
FS(1001,全年,“借”,,,“J01”)+FS(1002,全年,”借”,,,“J01”)+FS(1012,全年,”借”,,,“J01”)-FS(1001,全年,”贷”,,,“J01”)-FS(1002,全年,”贷”,,,“J01”)-FS(1012,全年,”贷”,,,“J01”)
收到:
FS(1001,全年,“借”,,,“J02”)+FS(1002,全年,”借”,,,“J02”)+FS(1012,全年,”借”,,,“J02”)-FS(1001,全年,”贷”,,,“J02”)-FS(1002,全年,”贷”,,,“J02”)-FS(1012,全年,”贷”,,,“J02”)
收到其他:
FS(1001,全年,“借”,,,“J03”)+FS(1002,全年,”借”,,,“J03”)+FS(1012,全年,”借”,,,“J03”)-FS(1001,全年,”贷”,,,“J03”)-FS(1002,全年,”贷”,,,“J03”)-FS(1012,全年,”贷”,,,“J03”)
购买:
FS(1001,全年,“借”,,,“J11”)+FS(1002,全年,”借”,,,“J11”)+FS(1012,全年,”借”,,,“J11”)-FS(1001,全年,”贷”,,,“J11”)-FS(1002,全年,”贷”,,,“J11”)-FS(1012,全年,”贷”,,,“J11”)
支付给:
FS(1001,全年,“借”,,,“J12”)+FS(1002,全年,”借”,,,“J12”)+FS(1012,全年,”借”,,,“J12”)-FS(1001,全年,”贷”,,,“J12”)-FS(1002,全年,”贷”,,,“J12”)-FS(1012,全年,”贷”,,,“J12”)
支付的:
FS(1001,全年,“借”,,,“J03”)+FS(1002,全年,”借”,,,“J13”)+FS(1012,全年,”借”,,,“J13”)-FS(1001,全年,”贷”,,,“J13”)-FS(1002,全年,”贷”,,,“J13”)-FS(1012,全年,”贷”,,,“J13”)
支付的其他:
FS(1001,全年,“借”,,,“J14”)+FS(1002,全年,”借”,,,“J14”)+FS(1012,全年,”借”,,,“J14”)-FS(1001,全年,”贷”,,,“J14”)-FS(1002,全年,”贷”,,,“J14”)-FS(1012,全年,”贷”,,,“J14”)
投资活动
收回FS(1001,全年,“借”,,,“T01”)+FS(1002,全年,”借”,,,“T01”)+FS(1012,全年,”借”,,,“T01”)-FS(1001,全年,”贷”,,,“T01”)-FS(1002,全年,”贷”,,,“T01”)-FS(1012,全年,”贷”,,,“T01”)
取得FS(1001,全年,“借”,,,“T02”)+FS(1002,全年,”借”,,,“T02”)+FS(1012,全年,”借”,,,“T02”)-FS(1001,全年,”贷”,,,“T02”)-FS(1002,全年,”贷”,,,“T02”)-FS(1012,全年,”贷”,,,“T02”)
处置FS(1001,全年,“借”,,,“T03”)+FS(1002,全年,”借”,,,“T03”)+FS(1012,全年,”借”,,,“T03”)-FS(1001,全年,”贷”,,,“T03”)-FS(1002,全年,”贷”,,,“T03”)-FS(1012,全年,”贷”,,,“T03”)
收到:
FS(1001,全年,“借”,,,“T04”)+FS(1002,全年,”借”,,,“T04”)+FS(1012,全年,”借”,,,“T04”)-FS(1001,全年,”贷”,,,“T04”)-FS(1002,全年,”贷”,,,“T04”)-FS(1012,全年,”贷”,,,“T04”)
购建FS(1001,全年,“借”,,,“T11”)+FS(1002,全年,”借”,,,“T11”)+FS(1012,全年,”借”,,,“T11”)-FS(1001,全年,”贷”,,,“T11”)-FS(1002,全年,”贷”,,,“T11”)-FS(1012,全年,”贷”,,,“T11”)
投资:
FS(1001,全年,“借”,,,“T12”)+FS(1002,全年,”借”,,,“T12”)+FS(1012,全年,”借”,,,“T12”)-FS(1001,全年,”贷”,,,“T12”)-FS(1002,全年,”贷”,,,“T12”)-FS(1012,全年,”贷”,,,“T12”)
支付的:
FS(1001,全年,“借”,,,“T13”)+FS(1002,全年,”借”,,,“T13”)+FS(1012,全年,”借”,,,“T13”)-FS(1001,全年,”贷”,,,“T13”)-FS(1002,全年,”贷”,,,“T13”)-FS(1012,全年,”贷”,,,“T13”)
筹资:
吸收FS(1001,全年,“借”,,,“C01”)+FS(1002,全年,”借”,,,“C01”)+FS(1012,全年,”借”,,,“C01”)-FS(1001,全年,”贷”,,,“C01”)-FS(1002,全年,”贷”,,,“C01”)-FS(1012,全年,”贷”,,,“C01”)
借款FS(1001,全年,“借”,,,“C02”)+FS(1002,全年,”借”,,,“C02”)+FS(1012,全年,”借”,,,“C02”)-FS(1001,全年,”贷”,,,“C02”)-FS(1002,全年,”贷”,,,“C02”)-FS(1012,全年,”贷”,,,“C02”)
收到FS(1001,全年,“借”,,,“C03”)+FS(1002,全年,”借”,,,“C03”)+FS(1012,全年,”借”,,,“C03”)-FS(1001,全年,”贷”,,,“C03”)-FS(1002,全年,”贷”,,,“C03”)-FS(1012,全年,”贷”,,,“C03”)
偿还FS(1001,全年,“借”,,,“C11”)+FS(1002,全年,”借”,,,“C11”)+FS(1012,全年,”借”,,,“C11”)-FS(1001,全年,”贷”,,,“C11”)-FS(1002,全年,”贷”,,,“C11”)-FS(1012,全年,”贷”,,,“C11”)
分配FS(1001,全年,“借”,,,“C12”)+FS(1002,全年,”借”,,,“C12”)+FS(1012,全年,”借”,,,“C12”)-FS(1001,全年,”贷”,,,“C12”)-FS(1002,全年,”贷”,,,“C12”)-FS(1012,全年,”贷”,,,“C12”)
支付的FS(1001,全年,“借”,,,“C13”)+FS(1002,全年,”借”,,,“C13”)+FS(1012,全年,”借”,,,“C13”)-FS(1001,全年,”贷”,,,“C13”)-FS(1002,全年,”贷”,,,“C13”)-FS(1012,全年,”贷”,,,“C13”)
利润表
1FS(“6001”,月,贷,,,,,)+FS(“6051”,月,贷,,,,,)
LFS(“6001”,全年,贷,,,,,)+LFS(“6051”,全年,贷,,,,,)
FS(“6401”,月,借,,,,,)+FS(“6402”,月,借,,,,,)
LFS(“6401”,全年,借,,,,,)+LFS(“6401”,全年,借,,,,,)
FS(“6403”,月,借,,,,,)
LFS(“6403”,全年,借,,,,,)
FS(“6601”,月,借,,,,,)
LFS(“6601”,全年,借,,,,,)
FS(“6602”,月,借,,,,,)
LFS(“6602”,全年,借,,,,,)
FS(“6603”,月,借,,,,,)
LFS(“6603”,全年,借,,,,,)
FS(“6701”,月,贷,,,,,)
LFS(“6701”,全年,贷,,,,,)
FS(“6101”,月,贷,,,,,)
LFS(“6101”,全年,贷,,,,,)
FS(“6111”,月,贷,,,,,)
LFS(“6111”,全年,贷,,,,,)
B5-PTOTAL(B6:
B11)+B12+B13
C5-PTOTAL(C6:
C11)+C12+C13
FS(“6301”,月,贷,,,,,)
LFS(“6301”,全年,贷,,,,,)
FS(“6711”,月,借,,,,,)
LFS(“6711”,全年,借,,,,,)
FS(“671101”,月,借,,,,,)
LFS(“671101”,全年,借,,,,,)
B15+B16+B17
C15+C16+C17
FS(“6801”,月,借,,,,,)
LFS(“6801”,全年,借,,,,,)
B19-B20
C19-C20
资产负债表
QM(“1001”,月,,,,,)+QM(“1002”,月,,,,,)+QM(“1012”,月,,,,,)
QC(“1001”,全年,,,,,)+QC(“1002”,全年,,,,,)+QC(“1012”,全年,,,,,)
QM(“2001”,月,,,,,)
QC(“2001”,全年,,,,,)
QM(“1101”,月,,,,,)
QC(“1101”,全年,,,,,)
QM(“2101”,月,,,,,)
QC(“2101”,全年,,,,,)
QM(“1121”,月,,,,,)
QC(“1121”,全年,,,,,)
QM(“2201”,月,,,,,)
QC(“2201”,全年,,,,,)
QM(“1122”,月,借,,,,)-QM(“1231”,月,贷,,,,)+QM(“1231”,月,借,,,,)+QM(“2203”,月,借,,,,)
QC(“1122”,全年,借,,,,)-QC(“1231”,全年,贷,,,,)+QC(“1231”,全年,借,,,,)+QC(“2203”,全年,借,,,,)
QM(“2202”,月,贷,,,,)+QM(“1123”,月,贷,,,,)
QC(“2202”,全年,贷,,,,)+QC(“1123”,全年,贷,,,,)
QM(“1123”,月,借,,,,)+QM(“2202”,月,借,,,,)
QC(“1123”,全年,借,,,,)-+QC(“2202”,全年,借,,,,)
QM(“2203”,月,贷,,,,)+QM(“1122”,月,贷,,,,)
QC(“2203”,全年,贷,,,,)+QC(“1122”,全年,贷,,,,)
QM(“1132”,月,,,,,)
QC(“1132”,全年,,,,,)
QM(“2211”,月,,,,,)
QC(“2211”,全年,,,,,)
QM(“1131”,月,,,,,)
QC(“1131”,全年,,,,,)
QM(“2221”,月,,,,,)
QC(“2221”,全年,,,,,)
QM(“1221”,月,,,,,)
QC(“1221”,全年,,,,,)
QM(“2231”,月,,,,,)
QC(“2231”,全年,,,,,)
QM(“1401”,月,,,,,)+QM(“1403”,月,,,,,)+QM(“1404”,月,借,,,,)-QM(“1404”,月,贷,,,,)+QM(“1405”,月,,,,,)+QM(“1406”,月,,,,,)+QM(“1408”,月,,,,,)+QM(“1411”,月,,,,,)-QM(“1471”,月,,,,,)+QM(“5001”,月,,,,,)
QC(“1401”,全年,,,,,)+QC(“1403”,全年,,,,,)+QC(“1404”,全年,借,,,,)-QC(“1404”,全年,贷,,,,)+QC(“1405”,全年,,,,,)+QC(“1406”,全年,,,,,)+QC(“1408”,全年,,,,,)+QC(“1411”,全年,,,,,)-QC(“1471”,全年,,,,,)+QC(“5001”,全年,,,,,)
QM(“2232”,月,,,,,)
QC(“2232”,全年,,,,,)
QM(“2241”,月,,,,,)
QC(“2241”,全年,,,,,)
PTOTAL(B6:
B16)
PTOTAL(C6:
C16)
QM(“2401”,月,,,,,)
QC(“2401”,全年,,,,,)
PTOTAL(E6:
E17)
PTOTAL(F6:
F17)
QM(“1503”,月,,,,,)
QC(“1503”,全年,,,,,)
QM(“1501”,月,,,,,)-QM(“1502”,月,,,,,)
QC(“1501”,全年,,,,,)-QC(“1502”,全年,,,,,)
QM(“2501”,月,,,,,)
QC(“2501”,全年,,,,,)
QM(“1531”,月,,,,,)
QC(“1531”,全年,,,,,)
QM(“2502”,月,,,,,)
QC(“2502”,全年,,,,,)
QM(“1511”,月,,,,,)-QM(“1512”,月,,,,,)
QC(“1511”,全年,,,,,)-QC(“1512”,全年,,,,,)
QM(“2701”,月,,,,,)
QC(“2701”,全年,,,,,)
QM(“1521”,月,,,,,)
QC(“1521”,全年,,,,,)
QM(“1711”,月,,,,,)
QC(“1711”,全年,,,,,)
QM(“1601”,月,,,,,)-QM(“1602”,月,,,,,)-QM(“1603”,月,,,,,)
QC(“1601”,全年,,,,,)-QC(“1602”,全年,,,,,)-QC(“1603”,全年,,,,,)
QM(“2801”,月,,,,,)
QC(“2801”,全年,,,,,)
QM(“1604”,月,,,,,)
QC(“1604”,全年,,,,,)
QM(“2901”,月,贷,,,,)
QC(“2901”,全年,贷,,,,)
QM(“1605”,月,,,,,)
QC(“1605”,全年,,,,,)
QM(“2702”,月,,,,,)
QC(“2702”,全年,,,,,)
QM(“1606”,月,,,,,)
QC(“1606”,全年,,,,,)
PTOTAL(E20:
E26)
PTOTAL(F20:
F26)
E18+E27
F18+F27
QM(“1701”,月,,,,,)-QM(“1702”,月,,,,,)-QM(“1703”,月,,,,,)
QC(“1701”,全年,,,,,)-QC(“1702”,全年,,,,,)-QC(“1703”,全年,,,,,)
QM(“4001”,月,,,,,)
QC(“4001”,全年,,,,,)
QM(“4002”,月,,,,,)
QC(“4002”,全年,,,,,)
QM(“1711”,月,,,,,)
QC(“1711”,全年,,,,,)
QM(“1801”,月,,,,,)
QC(“1801”,全年,,,,,)
QM(“4101”,月,,,,,)
QC(“4101”,全年,,,,,)
QM(“1811”,月,借,,,,)
QC(“1811”,全年,借,,,,)
QM(“410410”,月,,,,,)
QC(“410410”,全年,,,,,)
QM(“1532”,月,,,,,)+QM(“1901”,月,,,,,)
QC(“1532”,全年,,,,,)+QC(“1901”,全年,,,,,)
E30+E31+E32+E33+E34
F30+F31+F32+F33+F34
PTOTAL(B19:
B35)
PTOTAL(C19:
C35)
B17+B36
C17+C36
E28+E35
F28+F35
收到的税费返还:
iS(1001,全年,”借”,,,”J02”)+iS(1002,全年,”借”,,,”J02”)+iS(1009,全年,”借”,,,”J02”