Product Description: A powerful and intelligent real estate project cost calculation tool designed for comprehensive dynamic cost estimation of real estate development projects. It combines the advantages of calculation templates from major developers like Greentown, Sunac, and Country Garden, optimized for practical needs, suitable for both beginners and professionals.

Template Introduction

The “XLCS Real Estate Project Full-Cost Calculation Template” is developed based on the characteristics of Xilu Green City project expansion, incorporating the strengths of full-cost calculation templates from major developers like Greentown, Sunac, Country Garden, Jinke, Zhongliang, and Zhangtai. Combining Green City’s product configuration standards and conventional project presets, it forms a comprehensive, intelligent, and dynamic full-cost calculation template. Simply input key project and local indicators to automatically generate complete sets of engineering, sales, financing, tax, cash flow, and operational tables. What previously required days of work by cost professionals with support from engineering/sales/finance departments can now be completed by beginners in just ten minutes. The complete template contains over 90 worksheets, covering all static/dynamic calculation and analysis charts for real estate project estimation.

Chinese Version English Version Version Logic
XLCS Beginner XLCS Lite Lightweight version, permanently locked to V1.X series
XLCS Core XLCS Core Standard feature version, version number synchronized with brand iteration
XLCS Advanced XLCS Pro Premium extended version, version number synchronized with brand iteration

XLCS Real Estate Full-Cost Calculation System Summary Preview

Basic Features

  1. After entering the city name, the template automatically links to the cloud database to check if the city is included, loading corresponding city data on supporting fees, taxes, planning requirements, etc., and classifying the city level according to Green City’s tier system (if the city isn’t in the database, please enter manually).
  2. Based on city tier classification, the template automatically selects the corresponding 5-12 months presale timeline template (custom timeline templates can also be selected and modified), and automatically determines the timeline based on rough/finished delivery indicators. According to the highest floor number in the first launch area and local presale image progress requirements, it generates the first launch time and timeline plans for all phases.
  3. Based on automatically generated phase timeline plans, the template uses preset proportions for engineering/payment items and selected payment ratio templates to generate monthly payment plans for advance/engineering fees for each phase (supporting up to five phases), which flow into the cash flow statement.
  4. Based on project area indicators, the template automatically classifies project scale and selects corresponding payment ratios according to Green City standards. Manual modifications are automatically validated against Green City standards with suggested values provided (see “Data Validation & Review” sheet).
  5. Based on city tier indicators, the template automatically imports Green City’s standard sales cycles and first launch indicators for different city tiers, validating whether different product types meet Green City sales standards and providing suggested values (see “Data Validation & Review” sheet).
  6. Based on city tier indicators, the template automatically imports Green City’s standard marketing expense indicators, validating marketing rates against standards and outputting default values (see “Data Validation & Review” sheet). The template also automatically calculates monthly marketing expense payment plans based on monthly collection values and marketing rates (collection plans can be adjusted in the “Collection Plan” sheet), which flow into the cash flow statement.
  7. Based on generated launch times, local regulated fund tiers, launch image progress requirements (adjustable for highest floor number in first launch area and local presale image progress requirements), and sales/collection plans (with preset defaults or manual adjustments), the template determines first launch time, automatically calculates and generates annual/quarterly/monthly sales/collection reports and PPT sales reports, which flow into the cash flow statement.
  8. After entering interest rates, loan terms, and interest payment methods for different financing types (development loans/front-end financing/non-standard financing), the template automatically calculates interest and generates monthly financing payment plans. It also calculates monthly shareholder fund interest plans based on entered shareholder fund occupation/return rates, which flow into the cash flow statement.
  9. After selecting whether the project involves rental/car purchase options and project type, the template automatically calculates management fee control indicators and monthly payment plans according to Green City standards, which flow into the cash flow statement. Manually entered management rates are automatically validated against Green City standards with default values suggested (see “Data Validation & Review” sheet).
  10. Based on preset Green City product type configuration standards and entered local prices for main materials (steel/concrete/blocks, etc.) and selected prefabrication rates, data automatically flows into engineering cost calculations for corresponding product types (the template presets detailed civil engineering cost tables and general contracting civil cost calculation tables for different product types).
  11. After entering local tax information indicators (default values are automatically extracted from corresponding city database information), the template automatically calculates and generates VAT, additional taxes, land value increment tax, and income tax reports. Based on selected refund eligibility and refund ratio conditions, it generates tax prepayment data and final tax settlement data, along with monthly payment plans, which flow into the cash flow statement.
  12. Based on preset self-owned property operation templates, the template automatically generates self-owned property economic calculations.
  13. Based on the above engineering/sales/cost/financial monthly payment plans, the template automatically generates monthly/annual cash flow reports and trend charts.
  14. Expanded content for second-hand acquisition projects, adding data collection for pre-acquisition fund expenditures and collected income from sold units into template automatic calculations, which flow into the cash flow statement.
  15. Tables for excess incentive and co-investment calculations.
  16. Automatic allocation of land costs for multi-parcel products. The template automatically summarizes and allocates land areas for each real estate product based on phased product areas for each parcel, calculating allocated land costs.
  17. To meet the needs of WPS users, comprehensive adaptation and optimization for WPS characteristics and JS code, newly launched XLCS Core V7 Full-Cost Calculation Template_WPS Edition (also perfectly compatible with EXCEL), while Office users can choose XLCS Core V7 Full-Cost Calculation Template_Excel Edition. XLCS PRO V1 is suitable for multi-parcel, multi-phase projects, featuring unique one-click generation of land value increment tax settlement values under multiple modes (overall settlement, parcel-by-parcel settlement, phase-by-phase settlement). Different phase combinations can be set for multi-parcel, multi-phase projects to instantly view corresponding phase/parcel tax settlement values, quickly finding optimal phase combinations (each phase represents a tax settlement unit, subject to policy compliance and tax authority acceptance).

Special Features

  1. Cloud Database Built-in cloud database functionality collecting planning fees, taxes, and green building policies for major cities nationwide as calculation references. Uses external cloud database links for real-time data updates. The template extracts corresponding city information from the database to automatically fill key indicator defaults in calculation tables, which can be manually adjusted according to real-time policies.
  2. Cost Indicators The template automatically matches corresponding Green City product configuration standards and quota databases according to five product tiers: Collection (T), Premium (S), Superior (W), Enjoy (J), and Comfort (C). Based on selected tiers, the template automatically adjusts corresponding configuration coefficients and unit indicators in the “Configuration Standards” sheet, which flow into corresponding product civil engineering detail tables for calculation.
  3. Timeline Templates Seven presale timeline templates from 5-12 months. The template automatically selects corresponding presale timeline templates based on city tier (months specifically refer to launch time, i.e., the launch time in Green City’s 596 model - 5 months for commencement, 9 months for launch, and 6 months for cash flow breakeven after launch). Manual selection of presale timeline templates or custom timeline templates is also available, simplifying timeline planning.
  4. Engineering Payment Templates Four engineering payment templates with different payment methods (selectable: a. Monthly progress payments for conventional projects b. Annual lump-sum progress payments c. Contractor financing before launch with normal monthly payments afterward d. Contractor financing before structural topping-out with normal monthly payments afterward). After selecting corresponding engineering payment templates, one-click switching automatically recalculates monthly engineering payment values, with data automatically updating in real-time into the cash flow statement.
  5. Advance Payment Templates Two advance payment templates with different payment methods (selectable: a. Monthly progress payments for conventional projects b. Discounted financing for difficult projects before launch (excluding planning fees and partial design fees), with adjustable payment ratios for design fees, planning fees, and advance engineering fees, transitioning to normal monthly payments after launch). After selecting different advance payment templates, one-click switching automatically recalculates monthly advance payment values, with data automatically updating into cash flow.
  6. Sales Collection Templates After selecting whether the city has purchase restrictions and whether loans are released after structural topping-out, the template automatically corresponds to different sales collection templates. Collection nodes and ratios can also be manually adjusted in the “Collection Assumptions” sheet. The template automatically generates sales collection plans flowing into the “Total Value & Collection Plan” sheet.
  7. Sales Fund Regulation Templates Six sales fund regulation templates (A-D classes). Based on local fund regulation situations, select corresponding regulation templates, or manually select regulation nodes and activated fund ratios. The template automatically corresponds to phase node times and generates monthly regulated fund plans flowing into the cash flow statement (in Sheet 2, choose whether regulated funds enter collections or conventional collections).
  8. Financing Interest Payment Templates For development loans, front-end financing, and non-standard financing, four interest payment templates are available in Sheet 08.1: quarterly interest payments, semi-annual interest payments, annual interest payments, and lump-sum principal-plus-interest repayment. One-click switching automatically generates cash flows for different interest payment methods.
  9. Construction Management Fee Payment Template After entering key indicators and payment nodes of construction management agreements, the template automatically calculates and generates monthly payment plans for three modes: salable properties, non-salable properties, and incentive fees, which flow into the cash flow statement.
  10. Supporting Fee Calculation Template After entering local planning fee indicators (defaults automatically extracted from corresponding city database information) and calculation methods, the template automatically calculates city supporting fees for different product types using two calculation methods: building area-based and total investment-based, with options to include/exclude basements. Under total investment-based calculation, there are two sub-modes: unified standard calculation and different standards for different products (floors). Based on selected calculation methods, the template automatically calculates city supporting fees, which flow into the cash flow statement.
  11. Management/Marketing Fee Calculation Template After entering key project information, the template automatically generates suggested management and marketing fee rates according to Green City standards. Suggested rates for external agreements should not be lower than these values. Manually entered rates in external agreements can override default suggested values, with the template automatically adjusting full-cost calculation tables.
  12. Non-standard Residential Land Value Increment Tax Template After entering local standards for non-standard residential identification, the template automatically distinguishes non-standard residential based on plot ratio, residential unit area requirements, and price indicators, calculating the proportion of standard residential area, automatically flowing into land value increment tax calculation tables for classified tax calculations.
  13. Finished Housing Timeline Template When the template detects finished housing indicators, it automatically adjusts to finished delivery/finished inspection options, simultaneously adjusting corresponding finished housing timeline templates.
  14. Prefabrication Rate Template Based on selected prefabricated building PC rate requirements, the template automatically adds increased structural costs from different prefabrication rates in engineering cost calculation tables.
  15. Presale Image Progress Template Based on height limit indicators in planning conditions, automatically calculates the highest floor number in the first launch area, and based on local presale image progress requirements, automatically calculates corresponding timelines for presale floors, providing suggested first launch dates.
  16. Pre-set Multiple Result Output PPT Pages The template extracts key result data to automatically generate multiple PPT pages for reporting, which can be directly copied into PPT materials, including: economic calculation tables, income statements, annual cash flow statements, annual sales tables, price sensitivity analysis, etc.
  17. Multiple Sensitivity Analysis Reports Price sensitivity analysis, land price sensitivity analysis, front-end financing disbursement sensitivity analysis, covering main sensitivity analysis needs for real estate project calculations, generated with one-click VBA code.
  18. Automatic Adaptation to Major Developers’ Engineering Indicators In addition to automatically selecting Green City’s engineering cost quota indicators for each product series as defaults, the template automatically performs city-tier adjustments for engineering indicators based on downloaded cloud data for the project location, and automatically displays corresponding Country Garden engineering indicator data for reference and adjustment based on project region.
  19. One-click Export of Entire Calculation Template Addressing user confidentiality requirements for result files, the template adds one-click export directory generation, allowing users to select worksheets for export, then click to export selected worksheets as macro-free xlcs files. Exported Excel workbooks only retain data, removing original template formulas, macro programs, and VBA code. Usage: In the “Export Function” sheet, click the button to generate directory, then click to export.
  20. Data Validation & Review Function Automatically checks inter-sheet relationships and validates common errors, analyzing and tracing data sources while providing problem causes and modification suggestions.
  21. VBA Code Automatic Workbook Error Checking Added VBA code in the data validation and review sheet to automatically check workbook link errors, cross-sheet reference errors, and other common sheet errors, executable with one-click (results displayed in cells C100, C102, C104).
  22. Pre-launch Fund Payment Plan Table The template automatically divides and aggregates monthly payment plans and collection plans for land, advance, engineering, period expenses, and taxes based on selected engineering payment templates (pre-launch financing, pre-topping-out financing, normal monthly payments). Based on first launch situations, one-click selection of “Phase I” or “Phase I-Batch I (First Launch Area)” mode is available, providing aggregated data for pre-launch totals, first-year totals, and Nth-year totals. Also provides quick and convenient monthly decomposition solutions for marketing center, show flat, and landscape display area construction costs, outputting monthly cash flow statements.
  23. Quick Sales Template Presets four templates: average sales over default sales period, self-set monthly sales rate, self-set monthly residential unit sales, and self-set sales cycle months. Users can one-click switch templates in Sheet 2, with VBA code automatically regenerating new monthly sales rates based on user selection, and can apply different templates to single products.
  24. Automatic Connection to Fastest Cloud Server If the default cloud database URL connection fails, confirm network connection. When opening files, the template automatically detects all official server speeds and selects the fastest locally accessible server to connect and update cloud data. In Sheet 2, view network connection status and currently connected server URL, with a “One-click Fix Cloud Connection Errors” button.
  25. Non-standard Financing Module Non-standard financing refers to non-standardized financing beyond front-end financing and development loans to cover project funding gaps. Based on monthly cash flow gaps, user-defined annual interest rates and thresholds (triggering non-standard financing when cumulative monthly net cash flow gaps (negative values) exceed this threshold). Single financing terms default to 12 months, with mandatory early repayment upon cash flow breakeven, improving early repayment logic, also triggering early repayment when no funding gaps are detected in the next 6 months. Repayment follows “first-in-first-out” principle. Uses VBA code to automatically trial-calculate optimal disbursement/repayment node times and loan amounts, generating monthly interest. Users can choose whether to include in financing plans and cash flow statements, with one-click trial calculation results and adjustable interest rates/thresholds.
  26. One-click Automatic Directory Generation Uses VBA code to automatically generate homepage directory functionality. VBA-generated workbook directories are more flexible, stable, and automated compared to GET.WORKBOOK macro sheet functions. A button on the homepage allows one-click automatic directory generation, suitable after adding/deleting sheets or renaming operations.
  27. One-click Generation of Land Value Increment Tax Settlement Values Under Multiple Modes (Overall Settlement, Parcel-by-Parcel Settlement, Phase-by-Phase Settlement) XLCS PRO V1.0 is suitable for multi-parcel, multi-phase projects, featuring unique one-click automatic generation of land value increment tax settlement values under multiple modes. Based on selected tax settlement modes, values automatically flow into cash flow statements and full-cost summary tables. Different phase combinations can be set for multi-parcel, multi-phase projects to instantly view corresponding phase/parcel tax settlement values, quickly finding optimal phase combinations (each phase represents a tax settlement unit, subject to policy compliance and tax authority acceptance).

Important Notes

1. All data in the template have preset conventional conditions and indicators. Unless there are special corresponding indicators for this project, no modification is needed - defaults can be used. Only green boxes in the sheets can be modified with manual input; other cells contain formulas and cannot be modified.

  1. Using Green City’s new five-tier product configuration classification (Collection (T), Premium (S), Superior (W), Enjoy (J), Comfort (C)), default engineering cost indicators in the template correspond to lower construction costs for Enjoy (J) tier configurations. If configuration standards or city tiers are increased, the template automatically adjusts corresponding cost coefficients and unit prices in the “Configuration Standards” sheet, flowing into corresponding product civil engineering detail tables. You can also manually modify differences in the “Engineering Indicators” sheet’s “Add-on Package” section based on benchmarking materials for unified adjustment of product engineering indicators.

  2. To ensure real-time updates of database data, the template uses externally linked “cloud database” methods. If the current server is temporarily unavailable, modify HTTP URLs in “Name Manager” to other available official website URLs: fckcs.cn fccs.cc fckcs.com.

  3. Typically, you only need to open Sheet 2 for basic indicator entry, inputting key project indicators. For data unavailable during calculation, template defaults can be maintained. Note that only green input cells can be modified - other cells usually contain formula links with interrelationships. After entering key indicators, the template file will generate all static/dynamic full-cost calculation reports in real-time.

  4. If your calculation conditions are more detailed, you can fine-tune all other secondary indicator entry sheets, such as construction management agreements, local tax policies, engineering indicators, configuration standards, etc.

  5. Operational Experience:
    6.1. Overall: First rough (framework), then detailed (cost adjustment), then review (validation sheet);
    6.2. Specific steps: 02 Basic Indicator Entry → 04.2 Tax Policy → 08.2 Advance Engineering Payment Sheet (adjust payment ratios) → 09.2 Collection Assumptions (adjust collection ratios) → Generate 06 Full-Cost Summary Sheet (first according to Green City default cost values and schedule) and 06.1 Full-Cost Expense Sheet → If there are objections to unit costs, modify adjustments through: 04.3 Configuration Standards + 04.1 Engineering Indicators → Review: 04 Overview Sheet + 07 Operations Sheet, identifying abnormal indicator descriptions → 05 Panoramic Plan + 05.1 Standard Timeline (generally unchanged, default Green City standard timeline) → Review: 08.1 Financing Plan + 09.4 Pre-launch Funds + 09 Total Value & Collection Plan + 09.1 Sales Plan
    6.3. Review 10 Cash Flow + 11.1 Profit Situation + 11.4 Price Sensitivity Analysis; other remaining sheets are basically supplementary and can be briefly reviewed.

Template Directory

XLCS Real Estate Full-Cost Calculation System Directory

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

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

Version Update History

XLCS Core Version History

  1. V5.1 Update 2024-01-12
    Added sheet “11.2 Front-end Financing Disbursement Sensitivity Analysis”
    Added sheet “11.3 Land Price Sensitivity Analysis”
    Added sheet “11.4 Price Sensitivity Analysis”

  2. V5.2 Update 2024-03-18
    Improved land value increment tax template, calculating taxes for parking spaces and storage rooms according to corresponding product types

  3. V5.3 Update 2024-07-12
    Fixed multiple bugs

  4. V6.0 Update 2024-07-27
    Expanded content for second-hand acquisition projects, adding data collection for pre-acquisition fund expenditures and collected income from sold units into template automatic calculations
    Added co-investment and incentive-related tables

  5. V6.1 Update 2024-08-03
    ① Updated product types, adding stacked villas (Chinese/French style), courtyard houses (Chinese/French style), Chinese sky villas, Song-style courtyard houses, etc.
    ② Updated product configuration standards, changing from traditional A-D four tiers to five new standards: Collection (T), Premium (S), Superior (W), Enjoy (J), Comfort (C), simultaneously establishing Green City product configuration standards and quota database. Default engineering cost indicators correspond to lower construction costs for Enjoy (J) tier configurations. If configuration standards or city tiers are increased, the template automatically adjusts corresponding cost coefficients and unit prices in the “Configuration Standards” sheet, flowing into corresponding product civil engineering detail tables.
    ③ Added various financing interest payment templates, offering three interest payment modes: end-of-quarter interest payments, annual interest payments, and lump-sum principal-plus-interest repayment. One-click switching automatically generates cash flows for different interest payment methods.
    ④ Optimized and improved pre-launch funds sheet, fully automatically extracting and aggregating data, allowing one-click selection of “Phase I” or “Phase I-Batch I (First Launch Area)” modes to generate pre-launch payment cash flow statements based on project first launch situations.

  6. V6.2 Update 2024-10-08
    ① Adjusted deemed sales value settings for held properties and related taxes, modifying land value increment tax settings.
    ② Adjusted standard residential identification criteria and improved non-standard residential land value increment tax template.
    ③ Adjusted other income/expense settings.
    ④ Adjusted sales plan module settings.

  7. V6.3 Update 2024-12-01
    ① Added prefabricated structure incentive area settings, correspondingly adjusting gross floor area-related formula settings.
    ② Added automatic land cost allocation settings for multi-parcel conditions. The template automatically summarizes and allocates land areas for each product type in corresponding parcels based on phased product areas for each parcel, calculating allocated land costs.
    ③ Fixed inaccuracies in tax settlement time/amount in cash flow statements under specific conditions.
    ④ Fixed area reference errors in current public supporting expense sheets.
    ⑤ Fixed unsegmented advance/engineering/urban construction supporting fees for current public supporting projects in full-cost summary sheets.
    ⑥ Fixed setting errors for pre-topping-out engineering payment plans in advance engineering payment sheets.
    ⑦ Fixed formula errors for average selling prices in overview sheets.
    ⑧ Added townhouses and related calculation tables, fixing formula settings for unforeseen expenses.
    ⑨ Added parcel-specific statistics for advance/engineering fees in overview sheets.

  8. V6.4 Update 2025-02-15
    ① Fixed errors in calculating unforeseen expenses for finished housing products.
    ② Fixed inability of expenses earlier than sheet start time to enter cash flow in total cost payment sheets, simultaneously adding initial time setting error judgments in validation sheets.
    ③ Fixed reference errors for engineering and sales data in operations indicator sheets under specific conditions.
    ④ Fixed potential errors when manually adjusting engineering node payment ratios in advance engineering payment sheets.
    ⑤ Fixed possible ambiguities in cumulative collection names in regulated funds sheets.
    ⑥ Adjusted clearance time to 12 months after project delivery, with customizable settings in Sheet 2.
    ⑦ Added validation judgments for potential errors in land cost payment plan entries.
    ⑧ Added NPV indicator calculations in cash flow statements, with NPV-related data in operations sheets.
    ⑨ Fixed formula setting errors for current net cash flow in cash flow statements, and fixed allocated income tax formula errors in full-cost expense summary sheets.
    ⑩ Fixed issues with IRR formula validation judgments in cash flow statements.
    ⑪ Improved regulated fund node settings, allowing custom selection of key regulated fund nodes with automatic adaptation to corresponding node times. Added parcel-specific regulated fund functionality for more precise monthly regulated fund dynamic data.
    ⑫ Added functionality for whether regulated funds enter cash flow statements affecting collection data, with one-click selection in Sheet 2 for using monthly regulated fund dynamics or conventional collection plans in cash flow statements.
    ⑬ Fixed monthly allocation errors for unforeseen expenses in advance engineering plan sheets.
    ⑭ Fixed allocation errors for VAT, VAT additions, and land value increment tax under specific phase conditions.
    ⑮ Fixed key node annotations in monthly sheets, adding key nodes for five phases.
    ⑯ Improved reference accuracy for corresponding nodes in timeline plans, overview sheets, and panoramic plans at various stages.
    ⑰ Fixed multiple reference errors in sales cycle validation, collection assumptions, and management expense progress control in data validation and review sheets, while adding multiple validation items.
    ⑱ Added multiple prompt messages in basic indicator entry sheets for user convenience. Added current cloud database reference URL display and connection status prompts.
    ⑲ Hidden non-project unit advance engineering indicators in engineering indicator sheets, only displaying template-automatically calculated unit advance engineering indicators for current project products to avoid misjudgment.

  9. V6.5 Update 2025-02-16
    ① Added VBA code in data validation and review sheets to automatically check workbook link errors, cross-sheet reference errors, and other common sheet errors, executable with one-click (results displayed in cells C89, C91).
    VBA Code Automatic Workbook Error Checking
    ② Addressing user confidentiality requirements, added one-click export directory generation, allowing users to select worksheets for export, then click to export entire calculation templates as macro-free xlcs files. Exported Excel workbooks only copy data, removing original template formulas, macro programs, and VBA code. Usage: In “Export Function” sheet, click button to generate directory, then click to export).
    Export xlcs Files
    ③ Added VBA code to automatically check local template version numbers and update times, comparing with official website latest versions and update times, with update suggestions prominently displayed in Sheet 2.
    ④ Added VBA code in data validation and review sheets to analyze error sources based on validation results, tracing back to original data, analyzing error causes, and providing modification suggestions for quick user fixes (double-click error prompt cells to pop up floating windows).
    Automatic Sheet Validation Analysis Function
    ⑤ Fixed display issues for area proportions of various product types in overview sheets.
    ⑥ Fixed multiple default date settings in financing plan sheets, adding interest rate input judgments in validation sheets for various financing methods in Sheet 2. For unused financing methods in the project, mandatory interest rate zeroing ensures data accuracy in financing plan sheets.

  10. V7.0 Update 2025-02-26
    ① Automatic connection to fastest cloud server. If default cloud database URL connection fails, confirm network connection. When opening files, automatically detects all official server speeds and selects fastest locally accessible server to connect and update cloud data. View network connection status and currently connected server URL at the top of Sheet 2.
    ② Optimized worksheet checking and repair VBA code when opening files, with speed optimization and robustness improvements.
    ③ Optimized VBA code for price sensitivity analysis sheets, adding custom price functionality for quick sensitivity analysis directly on this page.
    ④ Added output PPT sensitivity analysis tables for easy user preparation of PPT reporting materials.
    ⑤ Switched to VBA code for automatic homepage directory generation. VBA-generated workbook directories are more flexible, stable, and automated compared to GET.WORKBOOK macro sheet functions. A button on the homepage allows one-click automatic directory regeneration.
    ⑥ Added quick sales template settings with three preset templates: average sales over default sales period, self-set monthly residential unit sales, and self-set sales cycle months. Users can one-click switch templates in Sheet 2, with VBA code automatically regenerating new monthly sales rates based on user selection, and can apply different templates to single products.
    ⑦ Fixed issues with above-ground non-gross floor areas not entering current public allocation expense distribution.
    ⑧ Fixed formula issues for conventional monthly advance payments in advance engineering payment sheets.
    ⑨ Fully integrated XLCS Beginner Edition (XLCS Lite V1), suitable for beginners’ one-click calculations and feature trials. For more calculation conditions, use XLCS Core Edition. Faced with Core Edition’s dazzling features and settings, many beginners may feel overwhelmed, so trying the lightweight Lite version first is recommended. Extracting only conventional project economic/technical indicator sheets and key calculation elements (land price, three fee rates, etc.) can output reports identical to Core Edition.
    ⑩ Optimized cloud database search logic after user city input. When users input county/district names not in the database, previously directly prompted “Not included.” Modified to automatically match superior cities and output corresponding data, increasing cloud data usability.

  11. V7.1 Update 2025-03-03
    ① Rewrote VBA code for engineering monthly payment plans, completely eliminating previously unsolvable issues with complex function formulas for engineering monthly node time/ratio allocation. Set to automatically refresh when opening files and every 3 minutes, with manual update buttons available in advance engineering payment sheets.
    ② Optimized official website URL detection when opening files, divided into three levels: domestic core nodes, domestic edge nodes, and international nodes. Only proceeds to next level if core nodes are unavailable, always ensuring accessible servers, significantly speeding up file opening.
    ③ Added non-standard financing module, referring to non-standardized financing beyond front-end financing and development loans to cover project funding gaps. Based on monthly cash flow gaps, user-defined annual interest rates and thresholds (triggering non-standard financing when cumulative monthly net cash flow gaps (negative values) exceed this threshold). Single financing terms default to 12 months, with early repayment upon cash flow breakeven, following “first-in-first-out” principle. Uses VBA code to automatically trial-calculate optimal disbursement/repayment node times and loan amounts, generating monthly interest. Users can choose whether to include in financing plans and cash flow statements, with one-click trial calculation results and adjustable interest rates/thresholds.
    ④ Changed front-end financing sensitivity analysis sheets to financing method sensitivity analysis, completely rewriting VBA code to perform sensitivity analysis under two financing methods (development loans and front-end financing) with customizable financing amount, interest rate, and term variation ranges, providing investment analysis and forecasting.
    ⑤ Automatically added non-standard financing disbursement dates, repayment dates, and amounts in L35:P44 area of financing plan sheets based on generation results.

  12. V7.2 Update 2025-03-07
    ① Meeting needs of WPS users, comprehensive adaptation and optimization for WPS characteristics and JS code, newly launched XLCS Core V7.2 Full-Cost Calculation Template_WPS Edition (also perfectly compatible with EXCEL), while Office users can choose XLCS Core V7.2 Full-Cost Calculation Template_Excel Edition.
    ② Fixed product reading errors in overview sheets and land fee reading errors in full-cost expense sheets.

  13. V7.3 Update 2025-03-16
    ① Rewrote VBA code for regulated fund monthly plan sheets, fixing previous logic errors to ensure normal data entry into cash flow. One-click selection in Sheet 2 for whether to enter cash flow statements.
    ② For some users experiencing network connection errors when opening files causing custom name reference errors in Name Manager, added “One-click Fix Cloud Connection Exceptions” buttons at the top of basic indicator entry and data validation/review sheets.
    ③ Fixed land fee reference errors in land value increment tax calculation sheets and multiple small bugs in land fee allocation in overview sheets.
    ④ Improved construction management agreements regarding non-salable portion management fee calculations.
    ⑤ Improved non-standard financing plan logic, adding mandatory zeroing of principal and interest in settlement months.

  14. V7.4 Update 2025-03-21
    ① Added automatic checking of key names in Name Manager when opening/closing files to ensure normal cloud service usage.
    ② Fixed management fee allocation errors in VAT calculation sheets and storage room advance engineering cost allocation errors in land value increment tax calculation sheets.
    ③ Fixed reduction logic for non-standard residential and non-residential properties in land value increment tax calculation sheets.
    ④ Fixed profit rate allocation and phased profit allocation errors in full-cost expense sheets.
    ⑤ Fixed unrecorded storage room sales income in regulated fund sheets.
    ⑥ Improved logic for various projects entering costs in cross-phase allocation sheets.
    ⑦ Rewrote price sensitivity analysis code, directly modifying prices in data sources to ensure analysis result accuracy.
    ⑧ Added a standard timeline template - 12-month presale template.

  15. V7.5 Update 2025-04-01
    ① Fixed construction management fee calculation logic errors, adding multiple custom settings for construction management fee calculations.
    ② Improved non-standard financing early repayment logic, adding 6-month no-gap early repayment triggering when no funding gaps are detected in the next 6 months.

  16. V7.6 Update 2025-05-02
    ① Increased commercial property input boxes from 4 to 10, facilitating multi-commercial property project entries.
    ② Fixed land price sensitivity analysis bugs.
    ③ Improved cell settings for land transfer fees included in output VAT calculations in VAT calculation sheets.
    ④ Fixed price reference bugs in land value increment tax sheets, optimizing calculation logic in price sensitivity analysis sheets.
    ⑤ Fixed deed tax calculation logic, adding other land fees as calculation base.
    ⑥ Fixed VAT and land value increment tax calculation logic for free-constructed product types.

  17. V8.0 Update 2025-06-27
    ① Optimized VBA code for city name cleaning.
    ② Optimized validation and review sheet settings.
    ③ Added option in Sheet 2 for payment months after reaching capital advance node, defaulting to starting one month after reaching node.
    ④ Fixed definition scope bugs in timeline templates.

  18. V8.1 Update 2025-08-01
    ① Optimized VBA code for regulated funds sheets, increasing regulated nodes to 10 for projects with complex regulatory requirements. Regulatory levels adjusted to: total presale amount, engineering cost standard, ending fund balance, or none. Added local engineering cost estimation as regulatory standard.
    ② Optimized standard timeline sheets, adding custom timeline settings: PC prefabricated structure standard floor period, non-prefabricated structure standard floor period, main structure completion to rough completion period, finished housing completion period extension compared to rough completion, rough completion to rough delivery period, rough completion to finished housing delivery period.
    ③ Added display of automatically detected and connected official server response time in Sheet 2.
    ④ Added two custom payment nodes in progress payment node tables in Sheet 08.2 advance engineering payment sheets, with customizable node times and payment ratios.
    ⑤ Fixed land value increment tax calculation logic for government-required free-constructed products.
    ⑥ Fixed bugs in land value increment tax and full-cost sheets where VAT amounts for advance/engineering costs didn’t consider invoice rate and conversion rate, now aligned with VAT calculation table standards.
    ① Optimized VBA code for monthly advance payment allocation in advance engineering payment sheets for faster and more accurate allocation.

  19. V8.2 Update 2025-08-11
    ① To reduce version complexity and update workload, the distinction between EXCEL and WPS versions has been removed. Starting from version 8.2, full compatibility is achieved.
    ② Added the option to customize the allocated land area for each product in the summary table, and introduced error detection and prompts for manually entered product land allocation data in the validation table.
    ③ Added two customizable payment milestones in the progress payment schedule of the 08.2 preliminary works payment table, with time logic checks to prevent later milestones from having a lower payment ratio than earlier ones.
    ④ Fixed the calculation logic for value-added tax and deemed sales value when holding properties.
    ⑤ Added a toggle option for whether commercial supporting properties include parking spaces, which affects the parking space calculation formula.
    ⑥ Optimized the VBA code for monitoring key indicators that trigger automatic recalculation of monthly progress payments to avoid frequent recalculations.
    ⑦ Fixed formula errors in the pre-opening capital planning table.

XLCS PRO Version History

  1. XLCS PRO V1.0 Update 2025-04-20
    ① XLCS PRO V1.0 with completely new core, suitable for multi-parcel, multi-phase land value increment tax and VAT calculation.
    ② Added differentiated fee standards for supporting facilities based on civil air defense basements vs. non-civil air defense basements.
    ③ Added option to include/exclude parking spaces for supporting properties based on planning conditions.
    ④ Improved city database inclusion logic.
    ⑤ Fixed bugs in engineering cost calculation logic for finished housing products.

  2. XLCS PRO V1.1 Update 2025-06-10
    ① Cumulative bug fixes and updates for XLCS PRO.
    ② Improved cell settings for land transfer fees included in output VAT calculations in VAT calculation sheets.
    ③ Fixed commercial supporting parking space calculation bugs.
    ④ Fixed deed tax calculation logic, adding other land fees as calculation base.
    ⑤ Fixed VAT and land value increment tax calculation logic for free-constructed product types.
    ⑥ Optimized VBA code for city name cleaning.

  3. XLCS PRO V1.2 Update 2025-06-28
    ① Optimized validation and review sheet settings.
    ② Added option in Sheet 2 for payment months after reaching capital advance node, defaulting to starting one month after reaching node.
    ③ Fixed price sensitivity analysis bugs.
    ④ Fixed definition scope bugs in timeline templates.

  4. XLCS PRO V1.3 Update 2025-08-01
    ① Optimized VBA code for regulated funds sheets, increasing regulated nodes to 12 for projects with complex regulatory requirements. Regulatory levels adjusted to: total presale amount, engineering cost standard, ending fund balance, or none. Added local engineering cost estimation as regulatory standard.
    ② Optimized standard timeline sheets, adding custom timeline settings: PC prefabricated structure standard floor period, non-prefabricated structure standard floor period, main structure completion to rough completion period, finished housing completion period extension compared to rough completion, rough completion to rough delivery period, rough completion to finished housing delivery period.
    ③ Added display of automatically detected and connected official server response time in Sheet 2.
    ④ Added two custom payment nodes in progress payment node tables in Sheet 08.2 advance engineering payment sheets, with customizable node times and payment ratios.
    ⑤ Fixed land value increment tax calculation logic for government-required free-constructed products.
    ⑥ Fixed bugs in land value increment tax and full-cost sheets where VAT amounts for advance/engineering costs didn’t consider invoice rate and conversion rate, now aligned with VAT calculation table standards.
    ① Optimized VBA code for monthly advance payment allocation in advance engineering payment sheets for faster and more accurate allocation.
    ⑧ Added time-logic validation for the two new customizable payment milestones in 08.2 Preliminary Works Payment Table, preventing later milestones from having a lower payment ratio than earlier ones.
    ⑨ Fixed the VAT and deemed sales value calculation logic when holding properties.
    ⑩ Optimized the VBA monitoring code for key indicators that trigger automatic monthly progress payment recalculations, reducing unnecessary recalculations.

5、XLCS PRO V1.4 Update 2025-08-15
① Fixed formula errors in the Pre-Opening Capital Plan Table.

Frequently Asked Questions

  1. Recommended to use EXCEL2016 to open template files, as this template was developed using EXCEL2016 with multiple VBA codes. WPS using JS language may fail to load or execute, so you must use XLCS Core Full-Cost Calculation Template_WPS Edition. There are many WPS versions, but only professional editions support VBA (consider downloading a professional WPS installation, e.g., WPS2019 State Grid Professional Edition, WPS2019 Wuhan Government Professional Edition, WPS2019 Postal Enterprise Professional Edition. If downloading free personal edition from WPS official website, download and install the following WPS plugin:

    After downloading the compressed package, click to install and wait for automatic completion. Then reopen WPS to see the following interface, click "Continue" and "Enable Macros." ![XLCS v6 Xilu Project Full-Cost Calculation Template FAQ](img/wps3.png "WPS VBA Plugin Program")

  2. When opening xlsm files, if prompted: “Security Risk Microsoft has blocked macros,” right-click the file → Properties → Unblock in security options.

  3. Macro Security: If Office has macro security enabled by default, macro sheet functions may not work properly if macros are disabled (homepage not displaying text but #name). You need to set macro security to medium or low (not recommended for long-term low security).
    Setting method: Click “Tools” → “Macros” → “Security,” select “Medium” or “Low.”
    XLCS Core Xilu Project Full-Cost Calculation Official Release

  4. After opening template files, EXCEL may prompt “This workbook contains links to one or more external sources that may be unsafe,” click “Update” button, and the template file will automatically link to online city database files to update data. You can also go to: Data → Connections → Edit Links → Update Values to update city database files, and Data → Connections → Refresh All to update all cloud data, ensuring normal template file usage.
    PS: If city database reference paths are incorrect, check and modify HTTP-named paths in: Formulas → Name Manager, or download city database files and save them in the same folder as template files.

  5. XLSM suffix files are Excel files with macros enabled, so you must enable macros to fully use this calculation template. Adding VBA editor in Excel (File → More → Options → Customize Ribbon → Main Tabs → Developer Tools → Add to right-side custom ribbon); Adding project references: In Excel: Select → Developer Tools → Visual Basic → Tools → References, after opening load file selection box, select these items and confirm.
    XLCS Core Xilu Project Full-Cost Calculation Official Release

  6. Typically, you only need to open Sheet 2 for basic indicator entry, inputting key project indicators. For data unavailable during calculation, template defaults can be maintained. Note that only green input cells can be modified - other cells usually contain formula links with interrelationships. After entering key indicators, the template file will generate all static/dynamic full-cost calculation reports in real-time.

  7. If your calculation conditions are more detailed, you can fine-tune all other secondary indicator entry sheets, such as construction management agreements, local tax policies, engineering indicators, configuration standards, etc.

  8. Addressing user confidentiality requirements, added one-click export directory generation, allowing users to select worksheets for export, then click to export entire calculation templates as macro-free xlcs files. Exported Excel workbooks only copy data, removing original template formulas, macro programs, and VBA code. Usage: In “Export Function” sheet, click button to generate directory, then click to export.

Latest Version Download Links (Select any fastest download link, enter Access password, click “Download” in top right corner of download page):

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/
Leave comments or contact via email: mailto:admin@fdc.sd

Important! Ensure stable internet connection before refreshing template files to access all features and prevent calculation errors!

XLCS Xilu Project Full-Cost Calculation Official Preview