What should I do if my Data source for my project is Excel Upload? June 01, 2022 05:58 Updated Follow Select a Project. If the Data source is Excel upload, follow these steps: First, click to Download template for Nett selling price and Progress payment Excel files. Fill in the data columns especially the required* columns for both Excel files in the suggested format. Upload the files by clicking on Import excel. Once the file is uploaded, the system will start processing the data. Data columns Description Required*/ optional Available in Nett selling price Excel file Available in Progress payment Excel file Reference code Reference code is the unique identifier for each unit claim record. It accepts alphanumeric value. It is a necessary step to fill the Reference code field for each unit setting in MHub Showroom. A faster way to do this is by using the bulk import unit feature. Required* ✅ ✅ Unit number The number assigned to a property unit or parcel and is part of the of the postal address. It accepts alphanumeric value. Required* ✅ ✅ Layout type The sub type that differentiate properties by size, layout and selling price. Examples for high rise layout type would be Type A, Type B and so on. For landed, it would be Corner lot, Intermediate lot and End lot. It accepts alphanumeric value. Required* ✅ ✅ Bumi Unit The unit of a property which can only be purchased and owned by Bumiputeras. It accepts Yes or No value. Required* ✅ ✅ Unit Selling Price The price once all discounts and rebates have been applied. It accepts decimal numerical value, for e.g 500000.00 Required* ✅ ✅ SPA Price The price that is used to apply for a home loan. It accepts decimal numerical value, for e.g 500000.00 Required* ✅ ✅ Nett Selling Price The price once all discounts and rebates have been applied. It accepts decimal numerical value, for e.g 500000.00 Required* ✅ ✅ Loan / Cash Buyer Paying the property with cash or with financing. Required* ✅ Purchaser Name The name of the main buyer Required* ✅ Sales Date The date when the booking is confirmed. Either Sales or Approved Date from the MHub Showroom. It accepts dd/mm/yyyy format. Required* ✅ SPA Signed Date The date when the SPA is signed by the purchaser. Required* ✅ SPA Stamped Date The date when the SPA is stamped, usually within 30 days from the SPA signed date. Required* ✅ Progress Billing Date The date when a required payment is billed to either the End Financier or to the Purchaser according to the progressive payment schedules. Required* ✅ Transaction Date The date when the progress billing is settled. Required* ✅ Transacted Amount The amount paid for settlement for the progress billing. Required* ✅ Tax on Transacted Amount (RM) The tax charged on the amount paid for settlement. Required* ✅ Transacted Amount + Tax The sum of settlement and tax. Required* ✅ Outstanding Balance The remaining balance of the progress billing amount after settlement. Required* ✅ Related articles How do I delete a unit and/or layout?