The e-Memorial Form is an electronic template of the memorial form provided by the Land Registry. Lodging solicitors and government departments can download the forms below free of charge and save into their computer for preparing memorials for registration.

Please refer to the Workstation Requirements and the Disclaimer for using the e-Memorial Form.

You can click here [Demo file for e-Memorial Form] and [Demo file for e-Memorial Form (Data Import) ] to view online demonstration on how to use the e-Memorial Form.

Sample of a printed copy of the completed e-Memorial Form can be viewed here.

e-Memorial Form
# Form/File Name Form No. Download Form
  For Lodging Solicitors    
1. e-Memorial Form L.R. 152A The form file is in PDF format. To open it, you need to have the Adobe Reader installed.
2. e-Memorial Form (Data Import) L.R. 152A The form file is in PDF format. To open it, you need to have the Adobe Reader installed.
3. Template for e-Memorial Form (Data Import) - The form file is in Microsoft Excel format. To open it, you need to have the Microsoft Excel installed.
 
  For Government Departments    
1. e-Memorial Form L.R. 152B The form file is in PDF format. To open it, you need to have the Adobe Reader installed.
2. e-Memorial Form (Data Import) L.R. 152B The form file is in PDF format. To open it, you need to have the Adobe Reader installed.
3. Template for e-Memorial Form (Data Import) - The form file is in Microsoft Excel format. To open it, you need to have the Microsoft Excel installed.

Frequently Asked Questions:

Auto-fill Function of Address, Undivided Shares (of Subdivision Registers only) and Lot Number (Internet Connection Required)

Data Import Function





General

Q1: What is e-Memorial Form?

A:

It is an electronic template of the memorial form for registration of instrument with the Land Registry. The e-Memorial Form, which is available for downloading on the Land Registry's website free-of-charge, can be saved into one's computer for direct input of memorial particulars. The following two versions of e-Memorial Form equipped with different functions are available for use:

(a)

Enhanced e-Memorial Form with Auto-fill Function (Internet Connection Required)

After user enters a Property Reference Number and clicks a button, the program will retrieve the corresponding address, undivided shares (of subdivision registers only) and lot number(s) from Integrated Registration Information System (IRIS) Online Services and auto-fill the information in the e-Memorial Form for user’s reference.

(b)

Enhanced e-Memorial Form (Data Import) with Auto-fill Function (Internet Connection Required if user opts to use the Auto-fill Function)

The e-Memorial Form (Data Import) is specifically designed to support Excel worksheets. Multiple memorial forms can be prepared in one go by importing memorial data from an Excel worksheet. To facilitate user in preparing the memorial data, an Excel file containing a blank template (embedded with simple checking function) and guidance notes, is also available for free downloading and use. User may opt to retrieve the corresponding address, undivided shares (of subdivision registers only) and lot number(s) from IRIS Online Services and auto-fill the information in the e-Memorial Form for reference when the memorial data in the Excel file are imported to respective memorial forms.

After filling up the particulars, the memorial form has to be printed out and certified for lodging with the Land Registry. Like the printed form, each printed copy of the e-Memorial Form has a unique serial number and a corresponding barcode at the lower part of the form for identification purpose. Blank memorial forms should not be printed out and then photocopied since such copies will all contain the same serial number.

 
The recommended configuration of computer
Operating System Windows 7 or above
RAM 2GB or above
Software

Adobe Reader (Traditional Chinese) DC or above, and the corresponding Adobe Reader Font Pack.

Adobe Reader and the Font Pack are available for free downloading at the following respective locations:

Adobe Reader for Windows
http://get.adobe.com/tw/reader/

Adobe Reader DC Font Pack
http://supportdownloads.adobe.com/detail.jsp?ftpID=5877

The e-Memorial Form program has to be added to the trusted list of Adobe Reader before you can use the e-Memorial Form the first time. Please click here to view the step-by-step procedure for adding the e-Memorial Form to the trusted list.

Additional Software for e-Memorial Form (Data Import)

Microsoft Office 2010 or above to facilitate transfer of data between Excel file and Adobe Reader.

Also, please click here to view the points-to-note for preparing the source Excel file.

Accessory Laser printer with at least 600 x 600 dpi resolution
Others Internet connection is required for using the auto-fill function of the enhanced e-Memorial Form / e-Memorial Form (Data Import).
 




Auto-fill Function of Address, Undivided Shares (of Subdivision Registers only) and Lot Number (Internet Connection Required)

Error Message / Solution
# Error Message Solution
(a) The workstation is unable to connect to IRIS.
  • Check the Internet connection or use a workstation that is connected to IRIS.
  • Ensure that the "Transport Layer Security" (TLS) option in the workstation is enabled. To enable TLS, go to "Control Panel" and select "Internet Options". Under the "Advanced" tab, tick the checkbox of "Use TLS 1.0".
(b) The security certificate of IRIS has not been properly installed on the workstation. You should install the security certificates of the IRIS Online Services in your workstation before retrieving the address/undivided shares/lot information from the IRIS Online Services. Normally, the certificates will be automatically installed by Microsoft Windows when you access IRIS. You can check if the security certificates have been installed by accessing the IRIS Online Services website (www.iris.gov.hk). If you see a blocking page warning you about a problem with the security certificates, please run Windows Update so as to install the certificates to the Internet Explorer.
(c) You have refused to trust the connection to IRIS in the "Security Warning" message box of Adobe Reader. Trust the connection to IRIS Online Services by selecting "Allow (A)" in the security warning message box. You may also remember this action by ticking the relevant box so that the message will not be prompted again the next time.
(d) Enhanced security is enabled in your Adobe Reader and you have not yet added the e-Memorial Form to the trusted list. The enhanced security feature in Adobe Reader may block your workstation from retrieving the address/undivided shares/lot information from IRIS. To enable access to IRIS Online Services and use the auto-fill function, please follow the procedure here to add the e-Memorial Form to the trusted list of Adobe Reader.
(e) System problems of IRIS Due to system problems of IRIS Online Services, the address/undivided shares/lot information cannot be retrieved at the moment. Please view up-to-date position postings at the IRIS Online Services website (www.iris.gov.hk) and try again after resumption of IRIS. For any enquiries on IRIS Online Services, please either call our Customer Service Hotline (Tel. No. 3105 0000) or send email to csa@landreg.gov.hk.
 




Data Import Function

# Error Message Solution
(a) There is no worksheet named "Sheet1" in the Excel file. Set the name of the worksheet containing data to be imported as "Sheet1" and try again.
(b) The required column heading name(s) (e.g., "Solicitors_Code") cannot be found in Row 1 at Sheet1 of the Excel file, or the name(s) do/does not match with the template at Sheet1 of the Land Registry Excel file ("LR File"). Check and ensure that Row 1 of Sheet1 contains each and every column heading name as specified in the provided template. Please refer to Sheet2 of the LR file here [for lodging solicitors] or [for government departments] for a complete list of column heading names.
(c) The required control data cannot be found in the control row (Row 2) at Sheet1 of the Excel file, or the data do not match with the template provided in the LR File. Check and ensure that Row 2 of Sheet1 contain all the control data as specified in the provided template. Please refer to Sheet3 of the LR file here[for lodging solicitors] or [for government departments] for a complete list of control data.
(d) Data in the data row(s) (starting from Row 3) for specific column heading(s) (e.g., "Registration_Fee") are in invalid/incorrect data format.

Check and ensure that the data in the data row(s) are in valid/correct data format. Please refer to Sheet2 of the LR file here [for lodging solicitors] or [for government departments] for a list of points-to-note on data format.

You may also use the "Check Data Format" function in the template at Sheet1 of LR file to find out the source of the problem(s).

(e) The Excel file to be imported is open or in use. Close the Excel file and try data import again.
(f) You have not yet added the e-Memorial Form (Data Import) to the trusted list of Adobe Reader. Please follow the procedure here to add the e-Memorial Form (Data Import) to the trusted list of Adobe Reader and try data import again.
(g) Microsoft Office 2010 or above or the Microsoft Access Database Engine (applicable to workstations installed with Microsoft Office 2016) has not yet been installed on your workstation.

Install Microsoft Office 2010 or above, or the Microsoft Access Database Engine (applicable to workstations installed with Microsoft Office 2016) to your workstation before importing of data from the Excel file.

Microsoft Access Database Engine:
http://www.microsoft.com/download/en/details.aspx?id=13255

(h) The Excel file cannot be located from the location and name entered in the "Import Data from Excel File" dialogue box of the e-Memorial Form (Data Import) program. Enter the full location and name of the Excel file in the dialogue box, including names of drive and folder(s), for example, "C:\Data_File_LR152A.xls" , "F:\e-Memorial Form\Excel File.xlsm"
 

If you wish to receive the latest version/information of e-Memorial Form, you may provide your contact information through email (lre@landreg.gov.hk).