3、房地产运营月报表的设计和应用-附件

1、填表指南：1、空白单元格需手动填写，有颜色的单元格不可修改；2、黄色单元格为每月需要填写（更新内容）；3、本表每月2日中午下班前报送集团运营管理中心；4、本表报送数据准确性和及时性纳入项目计划考核,项目概况,项目公司名称,项目地址,设计经济技术指标,项目,指标,单位,项目,指标,单位,项目负责人,联系电话,总用地面积,m2,容积率,总建筑面积,m2,建筑密度,%,拿地时间,股权占比,其中,地上建筑面积,m2,绿地面积,%,其中,住宅,m2,楼幢数量,幢,规划（扩初）批复,开工时间,配套公建面积,m2,建筑层数（n-m）,层,商业经营面积,m2,住宅总套数,套,示范区开放时间,首开时间,地下建筑

2、面积,m2,机动车停车数,辆,其中,机动车库,m2,其中,地下,辆,现金流回正时间,销售周期（月）,地下夹层,m2,地上,辆,储藏,m2,非机动车停车数,辆,竣工备案完成时间,交付时间,设备用房,m2,其中,地下,辆,地下室人防面积,m2,地上,辆,经营计划及完成情况,2020年经营目标计划,指标,全盘启动会目标值（万元）,截止2019年底累计完成值（万元）,截止2019年底累计已还（万元）,2020计划完成目标（万元）,月度计划,2021年计划完成目标（万元）,2022年计划完成目标（万元）,2023年之后计划完成目标（万元）,2020年1月,2020年2月,2020年3月,2020年4月,

3、2020年5月,2020年6月,2020年7月,2020年8月,2020年9月,2020年10月,2020年11月,2020年12月,供货,0.0 ,签约,0.0 ,回款,0.0 ,土地款支出,0.0 ,工程成本支出,0.0 ,管理费用,0.0 ,营销费用,0.0 ,财务费用,0.0 ,税金,0.0 ,开发贷,0.0 ,其他现金流入,0.0 ,完成情况及分析,2020年度实际完成情况,全盘累计完成率,年度累计完成率,各项指标,全年实际完成,月度实际完成情况（万元）,工程进度及证照办理情况,2020年1月,2020年2月,2020年3月,2020年4月,2020年5月,2020年6月,2020年

4、7月,2020年8月,2020年9月,2020年10月,2020年11月,2020年12月,#DIV/0!,#DIV/0!,供货,0.0 ,项目所处阶段,计划完成时间,实际完成时间（如未完成填写当前进度及预计完成时间）,#DIV/0!,#DIV/0!,签约,0.0 ,#DIV/0!,#DIV/0!,回款,0.0 ,用地规划许可证,#DIV/0!,#DIV/0!,土地款支出,0.0 ,国有土地使用权证,#DIV/0!,#DIV/0!,工程成本支出,0.0 ,建设工程规划许可证,#DIV/0!,#DIV/0!,管理费用,0.0 ,建筑工程施工许可证,#DIV/0!,#DIV/0!,营销费用,0.0

5、 ,售楼处,#DIV/0!,#DIV/0!,财务费用,0.0 ,样板房,#DIV/0!,#DIV/0!,税金,0.0 ,示范区景观,#DIV/0!,#DIV/0!,开发贷,0.0 ,首开单体工程形象进度,#DIV/0!,#DIV/0!,其他现金流入,0.0 ,全年累计偏差分析,各项指标,全年实际,月度实际完成情况偏差分析（万元）,2020年1月,2020年2月,2020年3月,2020年4月,2020年5月,2020年6月,2020年7月,2020年8月,2020年9月,2020年10月,2020年11月,2020年12月,供货偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,

6、0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,签约偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,回款偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,各单体工程形象进度,土地款支出偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,工程成本支出偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0

7、 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,管理偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,营销偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,财务费用偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,税金偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0

8、.0 ,0.0 ,0.0 ,开发贷到账偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,前端融资到账偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,签约回款偏差分析,开发贷前端融资偏差分析,三费偏差分析,税金偏差分析,应收账款账龄,0-1月,1月-3月,3月-6月,6月-12月,12月以上,应收账款账龄,补充说明,说明,单体落架进度,投资额完成情况,项目总投资额（万元）,截止2019年底项目累计完成投资额（万元）,指标,年

9、度合计,投资额月度指标（万元）,市政景观形象进度,2020年1月,2020年2月,2020年3月,2020年4月,2020年5月,2020年6月,2020年7月,2020年8月,2020年9月,2020年10月,2020年11月,2020年12月,分户验收,月度投资额计划,0.0 ,消防验收,月度实际完成,0.0 ,规划验收,月度完成偏差,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,0.0 ,绿化验收,风险及其他,风险梳理,经营风险,计划风险,资金风险,其他补充,电梯验收,人防验收,质检验收,竣工备案证明,二改工程形象进度,现金流分析,年初累计值,2020年1月,2020年2月,2020年3月,2020年4月,2020年5月,2020年6月,2020年7月,2020年8月,2020年9月,2020年10月,2020年11月,2020年12月,精装施工形象进度,计划现金