XLCS Multi-Parcel Enhanced Edition (XLCS PRO V1) is officially launched! XLCS PRO Edition is suitable for multi-parcel, multi-phase projects, featuring unique one-click generation of land value-added tax liquidation values under multiple modes, and automatically entering cash flow statements and full-cost summary tables based on the selected land value-added tax liquidation mode.

Template Introduction:

“The XLCS Real Estate Project Full-Cost Calculation Template” is based on the characteristics of Southwest Greentown’s project expansion, drawing on the strengths and features of full-cost calculation templates from major developers like Greentown, Sunac, Country Garden, Jinke, Zhongliang, and Zhangtai. It combines Greentown’s product type configuration standards and preset conditions for conventional projects to create a fully intelligent dynamic full-cost calculation template. Simply input the project’s key and local indicators to automatically generate complete sets of engineering, sales, financing, tax, cash flow, and operation tables. What would normally require cost professionals working with engineering/sales/finance departments for several days to complete - the dynamic full-cost calculation tables for real estate projects - can now be done by even beginners in just tens of minutes. The complete template contains over 90 worksheets, covering all static/dynamic calculation analysis charts for real estate project calculations.

Template Features

*One-click automatic generation of land value-added tax liquidation values under three modes (overall liquidation, parcel-by-parcel liquidation, phase-by-phase liquidation)
*Automatically enters cash flow statements and full-cost summary tables based on the selected land value-added tax liquidation mode.
*By setting different phase combinations for multi-parcel, multi-phase projects, you can view corresponding phase-by-parcel land value-added tax liquidation values in real time, thereby quickly finding the optimal tax planning combination. Reasonably plan tax liquidation units during early development stages while ensuring phase combinations comply with national and local tax policies and are accepted by tax authorities.

XLCS PRO V1.0 Update 2025-04-20

① XLCS PRO V1.0 Edition, completely new core, suitable for land value-added tax and VAT calculations for multi-parcel, multi-phase projects.
② Added different fee standards for supporting facilities based on whether they are civil air defense basements or non-civil air defense basements.
③ Added toggle for whether supporting properties include parking spaces, allowing optional planning conditions for whether supporting properties include parking spaces.
④ Improved city database inclusion logic.
⑤ Fixed bug in engineering cost calculation logic for finished products.

XLCS PRO V1.1 Update 2025-06-10

① XLCS PRO cumulative bug fixes and updates.
② Improved cell settings for land transfer fees that can enter output VAT calculations in the VAT calculation table.
③ Fixed commercial supporting parking space calculation bug.
④ Fixed deed tax calculation logic, adding other land fees as calculation base.
⑤ Fixed VAT and land value-added tax calculation logic for donated matching product types.
⑥ Optimized VBA code for city name cleaning.

XLCS PRO V1.2 Update 2025-06-28

① Optimized validation and review table settings.
② Added option in Sheet 02 for number of months to pay after reaching capital advance node, defaulting to starting payment one month after reaching node.
③ Fixed bug in price sensitivity analysis.
④ Fixed bug in construction period template definition range.

XLCS PRO V1.3 Update 2025-08-01

① Optimized VBA code for capital supervision table, increased supervision nodes to 12 to accommodate projects with more complex supervision requirements. Supervision levels adjusted to: total presale amount, engineering cost standard, ending fund balance, and none, with added supervision quota based on local engineering cost calculations as supervision standard.
② Optimized standard construction period table, added custom settings for PC prefabricated structure standard floor period, non-prefabricated structure standard floor period, period from main structure completion to rough completion, additional period for fine completion compared to rough completion, period from rough completion to rough delivery, and period from rough completion to fine delivery.
③ Added automatic detection and display of official server response time in Sheet 02.
④ Added two custom payment nodes in Sheet 08.2 advance engineering payment table’s progress payment node table, allowing users to set node timing and payment percentages.
⑤ Fixed logic and formulas related to land value-added tax calculations for government-donated matching products in land value-added tax calculation table.
⑥ Fixed bug in land value-added tax calculation table and full-cost expense table where advance and engineering expenses’ VAT amounts didn’t consider invoice collection rate and conversion rate, aligning with VAT calculation table standards.
⑦ Optimized VBA code for monthly progress payment allocation in advance engineering payment table for faster and more accurate progress payment allocation.
⑧ Added time logic checks for the two custom payment nodes added in Sheet 08.2 advance engineering payment table’s progress payment node table to prevent situations where later node payment percentages are less than earlier nodes.
⑨ Fixed calculation logic for VAT and deemed sales value when holding properties exist.
⑩ Optimized VBA code for monitoring key indicators that trigger automatic recalculation of monthly progress payments to avoid frequent automatic recalculations.

XLCS PRO V1.4 Update 2025-08-15

① Fixed formula errors in pre-opening capital plan table.

Template File Update Time:

Complete “XLCS Real Estate Project Full-Cost Calculation Template” Package Contents:

  1. XLCS Full-Cost Calculation Template_Core V8 Edition.xlsm
  2. XLCS PRO V1 Full-Cost Calculation Template_Multi-Parcel Edition.xlsm (for multi-parcel projects)
  3. Single-Page Simple Calculation Template simple-template.xlsm
  4. XLCS Real Estate Project Full-Cost Calculation Template User Manual.docx
  5. XLCS Core WPS Quick Start Guide.docx
  6. deepseek Analysis of XLCS Full-Cost Calculation Template.docx
  7. Version Update Notes.txt
  8. City Database User Guide.txt
  9. Version Selection Guide.txt
  10. XLCS Real Estate Project Full-Cost Calculation Template Quick Start.txt
  11. wps.vba.rar (Essential free personal edition VBA plugin for WPS)
  12. Beginner Edition (XLCS Lite V1 Full-Cost Calculation Beginner Edition.xlsm, XLCS Lite Beginner Edition Quick Start Guide.docx)

Official Websites:
http://fccs.cc
http://fckcs.cn
http://fckcs.com
http://fdc.sd
http://fccsz.com
http://cskits.com

Support & Suggestions:
http://xlcs.de/
Please leave comments or contact via email: mailto:admin@fdc.sd

Important! Before refreshing template files, ensure stable network connection, otherwise you won’t be able to use all template functions, which may lead to calculation errors!