- 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*
|
|