{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Template","Note","Scheme Registration No","Examples","Version","Country Code"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Template","index":1,"n_rows":10,"n_cols":49,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,5,0],[2,1,3,12],[2,13,3,29],[2,30,3,44],[2,45,3,47]]}
["Version 版本 1.5"]
[]
["Description\n描述","General Information (Mandatory) 一般資訊（必填項目）一般资讯（必填项目）",null,null,null,null,null,null,null,null,null,null,null,"Member Contribution data (Fill in only when members have contributions to submit)（僅在成員有供款要提交時填寫）成员供款资料（仅在成员有供款要提交时填写）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New member data (Fill in only for the new member status (N), leave blank for other member status （僅填寫新成員狀態為（N），其他成員狀態則留空）新成员资料（仅填写新成员状态为（N），其他成员状态则留空）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Termination data (Fill in only for terminated member status (T), leave blank for other member statuses) 終止受僱資料（僅填寫終止受僱成員狀態為（T），其他成員狀態則留空  终止受雇资料（仅填写终止受雇成员状态为（T），其他成员状态则留空)"]
[]
[null,"Mandatory 必填項目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Mandatory 必填項目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Mandatory 必填項目","Mandatory 必填項目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目"]
[null,"Select from the dropdown list \n(Please refer to the scheme name & scheme code conversion table in \"Scheme Registration No\" tab)\n從下拉清單中選擇 （請參閱“備註”工作表中的計劃註冊編號轉換表）\n从下拉清单中选择（请参阅“备注”工作表中的计划注册编号转换表）","Maximun 15 numeric characters with no decimal places\n最多15個數字字符，不帶小數位\n最多15个数字字符，不带小数位","Maximun 20 English, numeric or special Characters \n最多20個英文字母、數字或特殊字符\n最多20个英文字母、数字或特殊字符","Maximun 50 English or numeric characters with no decimal places\n最多50個英文或數字字符，不帶小數位\n最多50个英文或数字字符，不带小数位","YYYYMMDD","YYYYMMDD","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择","For HKID, please include the check digit, without brackets.\n對於香港身份證號碼，請包括全部數字，不含括號。\n对于香港身份证号码，请包括全部数字，不含括号。","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择","Maximun 15 numeric characters with no decimal places\n最多15個數字字符，不含小數位\n最多15个数字字符，不含小数位","Maximun 20 English or numeric characters with no decimal places\n最多20個英文字母或數字字符，不含小數位\n最多20个英文字母或数字字符，不含小数位","YYYYMMDD","YYYYMMDD","Maximun 3 numeric characters with no decimal places\n最多3個數字字符，不含小數位\n最多3个数字字符，不含小数位"," YYYYMMDD"," YYYYMMDD","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择 ","Maximum 100 English characters\n最多100個英文字符\n最多100个英文字符","Maximum 100 English characters\n最多100個英文字符\n最多100个英文字符","Maximum 50 Chinese characters\n最多50個中文字符\n最多50个中文字符","Maximum 50 Chinese characters\n最多50個中文字符\n最多50个中文字符","YYYYMMDD","YYYYMMDD","Maximum 50 English characters\n最多50個英文字符\n最多50个英文字符","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择 ","YYYYMMDD","YYYYMMDD","Maximum 100 English, numeric or special characters\n最多100個英文字母、數字或特殊字符\n最多100个英文字母、数字或特殊字符","Maximum 10 numeric or special characters\n最多10個數字或特殊字符\n最多10个数字或特殊字符","Maximum 15 numeric characters with no decimal places\n最多15個數字字符，不含小數位\n最多15个数字字符，不含小数位","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择 ","Select from the dropdown list / Blank\n從下拉清單中選擇 / 留空\n从下拉清单中选择 / 留空"]
["Data Example 例子","-",3777463656273,"MLY","HRD",20221201,20221231,20230110,"-","-","E3649125",20121231,"-",22983883092,"AG55446576",20220201,20220228,3,20121201,20121231,23000.5,23000.5,1150.03,1150.03,2000,2000,0,57.75,57.75,6415.56,"-","Lee","Chee Hynn Aiden","李","子軒",20121231,"For member who can provide the date of birth: 19710212\nFor member who can only provide the year and month of birth: 197102\nFor member who can only provide the year of birth: 1971","Manager",20121231,"-",20121231,20121231,"suzanchan@webdoc.com",852,99999999,20121231,"-","-"]
["Data Field\n資料欄位\n资料栏位\nUser Remarks: Enter any comments or notes related to the row in column A. This information is for user reference only and will not be used for system validation or upload purposes.\n使用者備註：在A列中輸入與該行相關的任何評論或備註。此資訊僅供使用者參考，不會用於系統驗證或上傳目的。\n使用者备注：在A列中输入与该行相关的任何评论或备注。此资讯仅供使用者参考，不会用于系统验证或上传目的。","Scheme Registration No.\n(Please refer to Scheme Registration No. Conversion Table in \"Scheme Registration No\" tab)\n計劃註冊編號（請參閱“備註”工作表中的計劃註冊編號轉換表）\n计划注册编号（请参阅“备注”工作表中的计划注册编号转换表）","Employer Account No.\n僱主帳戶號碼\n雇主帐户号码","Payroll Group ID\n工資組別編號\n工资组别编号","Department Code\n部門編號\n部门编号","Payroll Contribution Period Start Date\n工資供款期開始日期\n工资供款期开始日期","Payroll Contribution Period End Date\n工資供款期完結日期\n工资供款期完结日期","Contribution Day\n(For Casual Employee of Industry Scheme only)\n供款日（僅適用於行業計劃的臨時雇員）\n供款日（仅适用于行业计划的临时雇员）","Employee Account Type \n(For details, please refer to General information table in \"Note\" tab)\n受僱類型（詳情請參閱“備註”工作表中的一般資訊表）\n受雇类型（详情请参阅“备注”工作表中的一般资讯表）","ID Type\n身分證明類別\n身分证明类别","ID No.\n身分證明號碼\n身分证明号码","Date of Employment\n受僱日期\n受雇日期","Member's Status \n(For details, please refer to General information table in \"Note\" tab)\n成員狀態（詳情請參閱“備註”工作表中的一般資訊表）\n成员状态（详情请参阅“备注”工作表中的一般资讯表）","Member Account No.\n成員帳戶號碼 \n成员帐户号码","Staff No.\n職員編號\n职员编号","Member Contribution Period Start Date\n成員供款期開始日期\n成员供款期开始日期","Member Contribution Period End Date\n成員供款期完結日期\n成员供款期完结日期","No. of Working Days \n(For Casual Employee of Industry Scheme only)\n工作日數 （僅適用於行業計劃的臨時雇員）\n工作日数 （仅适用于行业计划的临时雇员）","Working Period Start Date\n(For Casual Employee of Industry Scheme only)\n工作期開始日期\n（僅適用於行業計劃的臨時雇員）\n工作期开始日期\n（仅适用于行业计划的临时雇员）","Working Period End Date\n(For Casual Employee of Industry Scheme only)\n工作期完結日期\n（僅適用於行業計劃的臨時雇員）\n工作期完结日期\n（仅适用于行业计划的临时雇员）","Relevant Income\n有關入息\n有关入息","Basic Salary\n基本薪金\n基本薪金","Employer's Mandatory Contributions\n僱主強制性供款\n雇主强制性供款","Employee's Mandatory Contributions\n僱員強制性供款\n雇员强制性供款","Employer's Voluntary Contributions\n僱主自願性供款\n雇主自愿性供款","Employer's Voluntary Contributions 2\n僱主自願性供款2\n雇主自愿性供款2","Employee's Voluntary Contributions\n僱員自願性供款 \n雇员自愿性供款","Employer's Surcharges\n僱主附加費\n雇主附加费","Employee's Surcharges\n僱員附加費\n雇员附加费","Total Amount\n總額\n总额","Gender\n(For details, please refer to New member information table in \"Note\" tab)\n性別（詳情請參閱“備註”工作表中的新成員資訊表）\n性别（详情请参阅“备注”工作表中的新成员资讯表）","Surname (English)\n姓氏（英文）","Given Name (English)\n名字（英文）","Surname (Chinese)\n姓氏（中文）","Given Name (Chinese)\n名字（中文）","Date of Joining the Scheme\n參加計劃日期\n参加计划日期","Date of Birth\n出生日期","Member Class\n成員組別\n成员组别","Commencement Date for Vesting Entitlement\n享有歸屬權益生效日期\n享有归属权益生效日期","Employee Type\n(For details, please refer to New member information table in \"Note\" tab)\n受僱類型（詳情請參閱「備註」工作表中的新成員資訊表）\n受雇类型（详情请参阅「备注」工作表中的新成员资讯表）","Previous Date of Employment\n前一次受僱日期\n前一次受雇日期","Visa Issue Date\n簽證簽發日期\n签证签发日期","Email Address\n電郵地址\n电邮地址","Mobile No. (Country Code)\n手機號碼（國家代碼）\n手机号码（国家代码）","Mobile No.\n手機號碼\n手机号码","Last Date of Employment\n最後受僱日期\n最后受雇日期","Reason of Termination\n(For details, please refer to Termination of member table in \"Note\" tab)\n離職理由（詳細資訊請參閱「備註」工作表中的終止受僱成員表）\n离职理由（详细资讯请参阅「备注」工作表中的终止受雇成员表）","Long Service Payment/Severance Payment\n(For details, please refer to Termination of member table in \"Note\" tab)\n長期服務金／遣散費（詳細資訊請參閱「備註」工作表中的終止受僱成員表）\n长期服务金／遣散费（详细资讯请参阅「备注」工作表中的终止受雇成员表）"]
["(Example of ordinary contribution scenario, this row is not being used. Please fill in your data in row 10)\n（普通供款情境範例，此行未使用。請在第10行填入你的資料）","MT00288",123456789012,"MLY","HRD",20211201,20211231,20230110,"REE","HKID","Z9881329",20110102,"E",1111111,"AG55446576",20211201,20211231,111,20121201,20121231,21500,23000.5,1075,1075,0,0,0,null,null,4265.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Note","index":2,"n_rows":112,"n_cols":5,"rows_kept":112,"cut":false,"hidden":false,"merged":[[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,4,12,4],[26,0,27,0],[26,1,27,1],[26,2,27,2],[26,4,27,4],[14,0,15,0],[16,0,18,0],[16,1,18,1],[16,2,18,2],[16,4,18,4],[23,0,24,0],[23,1,24,1],[23,2,24,2],[6,3,7,3],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,4,10,4],[14,1,15,1],[14,2,15,2],[14,4,15,4],[30,2,31,2],[30,3,31,3],[23,4,24,4],[33,4,35,4],[54,0,57,0],[54,1,57,1],[54,2,57,2],[54,4,57,4],[40,0,42,0],[40,1,42,1],[40,2,42,2],[40,4,42,4],[33,0,35,0],[33,1,35,1],[33,2,35,2],[38,0,39,0],[38,1,39,1],[38,2,39,2],[49,1,49,4],[58,0,59,0],[58,1,59,1],[58,2,60,2],[58,4,59,4],[38,3,39,3],[38,4,39,4],[50,1,50,4],[70,4,73,4],[65,4,69,4],[61,0,62,0],[61,1,62,1],[61,2,63,2],[61,4,62,4],[87,4,88,4],[65,0,69,0],[65,1,69,1],[65,2,69,2],[65,3,69,3],[77,0,85,0],[77,1,85,1],[77,2,85,2],[77,4,85,4],[74,0,76,0],[74,1,76,1],[74,2,76,2],[74,4,76,4],[70,0,73,0],[70,1,73,1],[70,2,73,2],[108,4,111,4],[97,0,107,0],[97,1,107,1],[97,2,107,2],[97,4,107,4],[90,2,91,2],[87,0,88,0],[87,1,88,1],[87,2,88,2],[108,0,111,0],[108,1,111,1],[108,2,111,2]]}
["General information 一般資訊"]
["Data Field 資料欄位","Format 格式","Conditions 條件","Definition 定義","Example 例子"]
["Scheme Registration No.\n計劃註冊號碼","Letters and Numbers Only (10)","Mandatory\n必填項目","Each trustee scheme in the eMPF Platform is assigned a unique Scheme Registration No. when the scheme is migrated or newly added to the platform.\n每個在電子強積金平台上的受託計劃在轉移或新增到平台時，都會被分配一個唯一的計劃註冊號碼。","MT12345"]
["Employer Account No.\n僱主帳戶號碼","Numeric (15,0)","Mandatory\n必填項目","This is the number that is assigned to an employer with a scheme in the eMPF Platform, it must be the same as the contribution records being submitted. You can only find your Employer Account No. when your scheme has been migrated to the eMPF Platform, and your employer has registered to the platform.\n這個編號是分配給在電子強積金平台上具有計劃的僱主，它必須與提交的供款記錄相同。只有當你的計劃轉移到電子強積金平台平台並且僱主已在平台上註冊時，你才能找到你的僱主帳號。","3777463656273"]
["Payroll Group ID\n工資組別編號","Letters With Special Characters (20)","Conditional Mandatory\n有條件下為必填項目","This is one of the values employers use to define/ classify specific group(s) of employees, for example, contribution frequency, departments, payroll group and more. The Payroll Group ID for each employee must be accurate. If employers have more than one payroll groups, this field must be provided.  For employers who all along only use single payroll group (e.g. monthly contribution), this field is optional.\n\n這是僱主用來定義/分類特定的員工群組的值之一，例如供款頻率、部門、薪資組別等。每位員工的工資組別編號必須準確無誤。如果僱主有多個工資組別，則必須提供此欄位。對於一直只使用單一工資組別（例如每月供款）的僱主，此欄位是可不填的。\n\nAllow only English characters, numbers and symbols \"-\" & \"_\".  \n僅允許英文字母、數字 和 符號「-」及「_」。","MLY"]
["Department Code\n部門編號","Free Text (50)","Optional\n選填項目","The department that the employee works in. This is for employer's reference only, and for employer to identify which department the employee is belonging to. This is not used to calculate the contribution. This can be blank if the employer does not use this information.\n這是員工所在部門的資訊。這僅供僱主參考，用於確定員工所屬的部門。這不用於計算供款金額。如果僱主不使用此資訊，可以留空。","HRD"]
["Payroll Contribution Period Start Date\n工資供款期開始日期","YYYYMMDD","Mandatory\n必填項目","This is the period for which the employer pays relevant income to employees. This period must be the same as the contribution records being submitted.\n這是僱主支付相關收入給員工的期間。該期間必須與提交的供款記錄相同。",20221201]
["Payroll Contribution Period End Date\n工資供款期完結日期","YYYYMMDD","Mandatory\n必填項目",null,20221231]
["Contribution Day (for Casual Employee of Industry Scheme only)\n供款日\n（僅適用於行業計劃的臨時僱員）","YYYYMMDD","Conditional Mandatory for Casual Employee of Industry Scheme (\"ISCEE\") whose mandatory contributions will be made on the next working day following the pay day, otherwise, leave it blank\n有條件下為必填項目\n對於行業計劃臨時僱員（\"ISCEE\"）的臨時僱員，其強制供款將在支付日的下一個工作日進行，否則請留空。","If an employer chooses the next working day following the pay day as the contribution day for this employee who is an ISCEE, this is the date of the next working day following the pay day of the payroll contribution period for making mandatory contribution.\n如果僱主選擇在薪資發放日的下一個工作日作為對於該員工（作為行業計劃臨時僱員）的供款日，這是在薪資供款期間的強制供款所使用的下一個工作日的日期。",20230110]
["Employee Account Type \n受僱類型","Letters Only (3)","Mandatory\n必填項目","“REE”: Regular Employees 一般僱員","REE"]
[null,null,null,"“CEE”: Causal Employees 臨時僱員"]
["ID Type\n身分證明類別","Letters Only (20)","Mandatory\n必填項目","“HKID” or “PASSPORT”","HKID"]
[null,null,null,"Use “PASSPORT” only if the member does not possess a HKID\n僅在成員沒有香港身份證的情況下使用“PASSPORT”。"]
["ID No.\n身分證明號碼","Letters With Special Characters (50)","Mandatory\n必填項目","For HKID, please include the check digit, without brackets.\n對於香港身份證號碼，請包括檢查數字，不要使用括號。","E3649125"]
["Date of Employment\n受僱日期","YYYYMMDD","Conditional Mandatory\n有條件下為必填項目\n\nThis field is mandatory only if member's status is \"N\" or \"T\". \n\nFor Contribution-only records for existing member, where member's status is 'E',  this field is optional. If the Date of Employment is not provided, the platform will identify the Active (including Temporary) employment record based on the ID Type and ID No. within the specified scheme and payroll group. If multiple Active records share the same ID Type and ID No., the submission will be rejected, and you should enter the Member Account No. to identify the specific Active (or Temporary) employment account. \n\nIf the ID Type, ID No., and Date of Employment are all provided, the system will identify the corresponding employment account, and the contribution will be submitted to that account even if it has already been terminated.\n\n若成員狀態為「N」或「T」時，此欄位為必填。\n\n對於「僅供款」的記錄（適用於現有成員，且成員狀態為「E」），此欄位為選填。若為僅供款記錄且未提供「受僱日期」，平台將會根據該計劃及薪酬組別內的「身分證明類別」與「身分證明號碼」來識別「在職」（包括「臨時」）的受僱記錄。若在相同身分證明類別與身分證明號碼下存在多筆在職記錄，系統將駁回該提交，你應輸入「成員帳戶號碼」以識別特定的在職（或臨時）受僱帳戶。\n\n如已提供身分證明類別、身分證明號碼及僱用日期，系統將據此辨識對應的受僱帳戶，且即使該帳戶已被終止，供款仍會提交至該帳戶。\n","Date of employment of the employee\n員工的僱用日期\n\nPlease note that when the Member's Status is 'N' and the Employee Type is 'Intra-Group,' this date refers to the date the employee started at the new company, not the date they joined the group or their previous company. For an Employee Type of 'Exist' (Existing Employee transferring to the Scheme), this date represents the employee's original joining date at the company, not the scheme transfer date, the scheme transfer date should be entered in the 'Date of Joining the Scheme' field.\n\n請注意，當成員狀態為「N」且受僱類型為「Intra-Group」時，此日期指的是僱員在新公司開始工作的日期，而非加入集團或前公司之日期。若受僱類型為「Exist」（現有僱員轉入本計劃），此日期表示僱員最初加入公司的日期，而非計劃轉移日期。計劃轉移日期應填寫在「參加計劃日期」欄位中。",20121231]
[null,null,null,"For an Employee changes MPF schemes only, i.e. by using Type of 'Exist' (Existing Employee transferring to the Scheme), this date represents the employee's original joining date at the company, not the scheme transfer date, the scheme transfer date should be entered in the 'Date of Joining the Scheme' field.\n\n對於員工僅更改強積金計劃，即使用“現有僱員轉入本計劃”受僱類型（現有員工轉移到該計劃），該日期代表員工在公司原始的入職日期，而不是計劃轉移日期。計劃轉移日期應輸入在“參加計劃日期”字段中。"]
["Member's Status\n成員狀態","Letters Only (1)","Mandatory\n必填項目","“N”: New 新僱員","E"]
[null,null,null,"“E”: Existing 現有僱員"]
[null,null,null,"“T”: Terminated Member 終止受僱僱員"]
[]
[]
["Member contribution information 成員供款資料"]
["Data Field 資料欄位","Format 格式","Conditions 條件","Definition 定義","Example 例子"]
["Member Account No.\n成員帳戶號碼 ","Numeric (15,0)","Conditional Mandatory only if the employees have more than one active MPF member accounts under the same employer and same Payroll Group\n有條件下為必填項目\n只有當員工在同一僱主和同一薪酬組下擁有多個有效的強積金成員帳戶時。","Employee's account number that is assigned by the eMPF Platform. The Member Account No. of the employee can only be found when the scheme has been migrated to the eMPF Platform, and the employer has registered to the eMPF Platform.\n\nIf you do not know the Member Account No., you might leave it blank and the platform will use the ID No to identify your employee. \nLeave it blank for new members.",22983883092]
[null,null,null,"\n由電子強積金平台分配的員工帳號。員工的成員帳號只有在計劃轉移到電子強積金平台並且僱主已在電子強積金平台上註冊之後才能找到。\n\n如果你不知道成員帳號，你可以將其留空，平台將使用身份證號碼來識別你的成員。\n對於新成員，請將其留空。"]
["Staff No.\n職員編號","Letters and Numbers Only (20)","Optional (can be used to enter Staff No. when the Member's Status is 'N')\n選填項目 (可用於在成員狀態為'N'時輸入職員編號)","\nIf a Staff No. is provided during member enrollment—whatever submitting an enrollment-only record or enrolling a member while submitting a contribution—the Staff No. will be saved to the employee details once the member is enrolled. If a Staff No. is entered on a contribution-only submission, it is treated as reference information only; it will not be used to locate a member or for any type of validation. \n\nThe field accepts only letters and numbers (no symbols). If not required, it may be left blank.\n\n如果在登記成員時提供了職員編號——無論是只提交登記紀錄，或是在登記成員的同時一併提交供款——該職員編號會在成員完成登記後保存至僱員資料。若在僅提交供款的紀錄中填寫職員編號，該編號僅作參考之用；不會用於查找成員，也不會用於任何形式的驗證。\n\n此欄位僅接受英文字母與數字（不允許符號）。如無需要，可留空不填。","AG55446576\n\nNot accept symbol, 不接受符號\ne.g.: AG_55446576"]
["Member Contribution Period Start Date\n成員供款期開始日期","YYYYMMDD","Conditional Mandatory only if there is MPF contribution or surcharge required\n有條件下為必填項目 \n只有在需要強積金供款或附加費時。","It is the contribution period that the employer makes MPF contribution or surcharge for the employee. If an employer makes contributions for a new employee for more than one contribution period, the employer should enter one record for each contribution period.",20220201]
[null,null,null,"這是僱主為員工進行強積金供款或附加費的供款期間。如果僱主為新員工進行多個供款期間的供款，則僱主應為每個供款期間輸入一條記錄。"]
["Member Contribution Period End Date\n成員供款期完結日期","YYYYMMDD","Conditional Mandatory only if there is MPF contribution or surcharge required\n有條件下為必填項目\n只有在需要強積金供款或附加費時提供。","In addition, if the employer has to settle contribution surcharge, the employer can input the amount of contribution surcharge for each corresponding contribution period.  One record for each contribution period.\n\n另外，如果僱主需要支付供款附加費，僱主可以為每個相應的供款期間輸入供款附加費金額。每個供款期間輸入一條記錄。",20220228]
["No. of Working Days (for Casual Employee of Industry Scheme only)\n工作日數 \n（僅適用於行業計劃的臨時僱員）","Numeric (3,0)","Conditional Mandatory only for ISCEE, otherwise, leave it blank\n有條件下為必填項目 \n只有對於行業計劃的臨時僱員，否則請留空。","This is the number of working days of the ISCEE within the contribution period.\n這是供款期間內的行業計劃臨時僱員工作天數。",3]
["Working Period Start Date (for Casual Employee of Industry Scheme only)\n\n工作期開始日期\n（僅適用於行業計劃的臨時雇員）"," YYYYMMDD","Conditional Mandatory only for ISCEE, otherwise, leave it blank.\n有條件下為必填項目 \n只有對於行業計劃的臨時僱員，否則請留空。","This is the reference working period in which the relevant income is earned by the ISCEE within the contribution period.\n這是供款期間內行業計劃臨時僱員所獲得相關收入的參考工作期間。",20121201]
["Working Period End Date\n(For Casual Employee of Industry Scheme only)\n\n工作期完結日期\n（僅適用於行業計劃的臨時雇員）"," YYYYMMDD",null,null,20121231]
["Relevant Income\n有關入息","Numeric (18,2)","Conditional Mandatory for all employees (except ISCEE whose mandatory contribution will be made on the next working day following the pay day) if contribution is required for the contribution period, otherwise, leave it blank \n有條件下為必填項目 \n對於所有員工（除了行業計劃的臨時僱員，其強制供款將在支付日的下一個工作日進行），如果在供款期間需要供款，則提供該信息；否則，請留空。","Relevant income refers to all monetary payments paid or payable by an employer to an employee for calculation of MPF contributions.\n有關入息是指僱主支付或應支付給員工的所有金錢支付，用於計算強積金供款。",23000.5]
["Basic Salary\n基本薪金","Numeric (18,2)","Optional\n選填項目","This will be used to calculate voluntary contributions when the voluntary contribution is setup using Basic Salary in voluntary contribution calculation method.",23000.5]
[]
[null,null,null,"If voluntary contribution is calculated on employee's basic salary, please provide the relevant employee's Basic Salary in each contribution period for calculation of voluntary contributions.\n\n當使用基本薪金作為自願供款計算方法進行自願供款設定時，這將用於計算自願供款。\n\n如果自願供款是根據僱員的基本工資計算，請提供每個供款期間相應僱員的基本薪金，以便計算自願供款。"]
["Employer's Mandatory Contribution\n僱主強制性供款","Numeric (18,2)","Conditional Mandatory only if the employer has to make MPF contribution\n有條件下為必填項目 \n只有在僱主需要進行強積金供款時提供該信息。否則，請留空。","Amount of mandatory contribution to be paid for the employee, rounding off to the nearest 2 decimal places.\n僱主應支付的強制供款金額，四捨五入至小數點後兩位。",1150.03]
["Employee's Mandatory Contribution\n僱員強制性供款","Numeric (18,2)","Conditional Mandatory only if the employee has to make MPF contribution\n有條件下為必填項目 \n只有當員工需要進行強積金供款時提供該信息。否則，請留空。","If the uploaded amount is less than or equal to the system-calculated amount, the uploaded amount will be accepted. If the uploaded amount exceeds the system-calculated amount, the system-calculated amount (include the maximum MPF mandatory contribution e.g. $1500 monthly, or $18,000 yearly etc.) will be used to prevent overpayment.\n\n如果上傳的金額小於或等於系統計算的金額，則將接受上傳的金額。如果上傳的金額超過系統計算的金額（包括最高的強制供款，例如每月 $1500 或每年 $18,000 等），將使用系統計算的金額以防止支付過多的金額。",1150.03]
["Employer's Voluntary Contribution\n僱主自願性供款","Numeric (18,2)","Optional\n選填項目","Amount of voluntary contribution to be paid by employer, rounding off to the nearest 2 decimal places.\n僱主應支付的自願供款金額，四捨五入至小數點後兩位。\n\nIf the employee is not entitled to the employer’s voluntary contribution, do not input any value including 0, just leave it blank.\n如果員工沒有加入僱主的自願性供款，請勿輸入任何數值，包括0，直接留空即可。\n\nOtherwise, the uploaded amount will be used for this voluntary contribution.\n否則，上傳的金額將用於此自願性供款。",2000]
[]
["Employer's Voluntary Contribution 2\n僱主自願性供款 2","Numeric (18,2)","Optional\n選填項目","Numerous MPF schemes provide employers with the adaptability to establish multiple voluntary contribution rules. These rules are aimed at different employee groups by utilizing different voluntary accounts. In such scenarios, the contribution amount can be allocated to Voluntary Contribution 2. If a scheme does not establish an additional voluntary contribution rule, it can simply be ignored.",2000]
[null,null,null,"許多強積金計劃為僱主提供了建立多個自願供款規則的靈活性。這些規則針對不同的僱員群體，利用不同的自願性供款帳戶。在這種情況下，供款金額可以分配到自願性供款2中。如果一個計劃沒有建立額外的自願性供款規則，可以忽略它。"]
[null,null,null,"However, if an employer has more sub-accounts for voluntary contributions than these provided fields ERVC, ERVC2, and EEVC, they will not be able to use this excel template or the API. Instead, employers will need to manage these extra sub-accounts directly through the eMPF Employer Portal.\n\n然而，如果僱主具有更多的自願性供款子帳戶，而超出了僱主自願性供款、僱主自願性供款2和僱員自願性供款這些提供的欄位，他們將無法使用此Excel模板或API。相反，僱主需要直接通過積金易僱主平台來管理這些額外的自願性供款子帳戶。\n\nIf the employee is not entitled to the employer’s voluntary contribution, do not input any value including 0, just leave it blank.\n如果員工沒有加入僱主的自願性供款，請勿輸入任何數值，包括0，直接留空即可。\n\nOtherwise, the uploaded amount will be used for this voluntary contribution, rounding off to the nearest 2 decimal places.\n否則，上傳的金額將用於此自願性供款，四捨五入至小數點後兩位。"]
["Employee's Voluntary Contribution\n僱員自願性供款","Numeric (18,2)","Optional\n選填項目","Amount of voluntary contribution to be paid by employee, rounding off to the nearest 2 decimal places.\n僱員應支付的自願性供款金額，四捨五入至小數點後兩位。\n\nIf the employee is not entitled to the employee’s voluntary contribution, do not input any value including 0, just leave it blank.\n如果員工沒有加入僱員的自願性供款，請勿輸入任何數值，包括0，直接留空即可。\n\nOtherwise, the uploaded amount will be used for this voluntary contribution.\n否則，上傳的金額將用於此自願性供款。",0]
["Employer's Surcharge\n僱主附加費","Numeric (18,2)","Optional\n選填項目","Amount of contribution surcharge (Employer portion)\n供款附加費金額（僱主部分）。",57.75]
["Employee's Surcharge\n僱員附加費","Numeric (18,2)","Optional\n選填項目","Amount of contributions surcharge (Employee portion)\n供款附加費金額（僱員部分）。",57.75]
["Total Amount\n總額","Numeric (18,2)","Conditional Mandatory only if there is MPF contribution or surcharge required\n有條件下為必填項目 \n只有在需要強積金供款或附加費時提供該信息。否則，請留空。","Total Amount = all contributions + all surcharges\n總額 = 所有的供款金額 + 所有的附加費金額",6415.56]
[]
[]
["Important Notes 1:","If the employee's birthday does not fall on the first day of the relevant contribution period ( i.e. the relevant income used to calculate contributions, after reaching 18-year-old OR before turning 65-year-old, is not for a complete contribution period ), the employer is still required to input the total income earned for the relevant contribution period as relevant income. If the employee's employment is terminated during the contribution period when the employee reaches 65-year-old, please also report the notice of termination. The system will calculate the pro-rated contribution amount based on the provided information."]
["重要事項 1:","如僱員的生日不是相關供款期的第 1 天 ( 即僱員年滿 18 歲後或滿 65 歲 前用於計算供款的有關入息並非完整供款期 ) ，僱主仍需要輸入相關供款期內的總收入作為有關入息。若僱員於年滿 65 歲之供款期內終止受僱，請同時滙報該僱員的離職通知。系統將會根據提供資料按比例計算供款金額。"]
[]
["New member information 新成員資料"]
["Data Field 資料欄位","Format 格式","Conditions 條件","Definition 定義","Example 例子"]
["Gender\n性別","Letters Only (1)","Conditional Mandatory only if member's status is \"N\"\n有條件下為必填項目 \n只有在成員狀態為「N」時提供該信息。否則，請留空。","\"M\": Male 男性","M"]
[null,null,null,"\"F\": Female 女性"]
[null,null,null,"\"U\": Unisex 中性"]
[null,null,null,"\"O\": No Such Information 無相關資訊"]
["Surname (English)\n姓氏（英文）","Letters With Special Characters (100)","Conditional Mandatory if member's status is \"N\", and Chinese name is not provided.\n有條件下為必填項目 \n如果成員狀態為「N」且未提供中文名字，請提供英文姓名。","English name of the member 成員的英文名稱。"," Lee "]
[null,null,null,"Allow English characters and symbols \"-\", “'“, “.”.  允許使用英文字母和符號 \"-\", “'“, “.”。Number is not allowed. 不允許使用數字。"]
["Given Name (English)\n名字（英文）","Letters With Special Characters (100)",null,"If the English name of the member has only one word, put the word into Member’s Surname, and leave the Given Name blank.\n如果成員的英文名只有一個單詞，將該單詞放入成員的姓氏中，並將名字留空。","Chee Hynn Aiden"]
["Surname (Chinese)\n姓氏（中文）","Chinese Characters Only (50)","Conditional Mandatory if member's status is \"N\", and English name is not provided.\n有條件下為必填項目 \n如果成員狀態為「N」且未提供英文名字，請提供中文姓名。","Chinese name of the member 成員的中文名稱。","李"]
[null,null,null,"Chinese character only. 僅限中文字符。"]
["Given Name (Chinese)\n名字（中文）","Chinese Characters Only (50)",null,"If the Chinese name of the member has only one word, put the word into Member’s Surname, and leave the Given Name blank.\n如果成員的中文名只有一個單詞，將該單詞放入成員的姓氏中，並將名字留空。","子軒"]
["Date of Joining the Scheme\n參加計劃日期","YYYYMMDD","Conditional Mandatory if member's status is \"N\"\n有條件下為必填項目 \n如果成員的狀態是「N」。","The date that the member joined the scheme\n成員加入計劃的日期。",20121231]
["Date of Birth\n出生日期","YYYYMMDD","Conditional Mandatory if member's status is \"N\"\n有條件下為必填項目\n如果成員的狀態是「N」。","This is the member's date of birth and must be provided as a complete date in the format YYYYMMDD.\n這是成員的出生日期，必須以完整日期格式提供 (YYYYMMDD)。",20021231]
[]
[]
[]
[]
["Member Class\n成員組別","Free Text (50)","Conditional Mandatory for member's status is “N\" and the new member is joining the voluntary contribution\n有條件下為必填項目\n如果成員的狀態為 \"N\"，並且新成員正在加入自願供款計劃。","This is the Member Class that is used when the voluntary contribution is setup. This code would be used to define the Vesting Scale which derive the vested benefits for terminated member where applicable. This Member Class is also to determine the amount of voluntary contribution.","Manager"]
[]
[null,null,null,"If an employer newly enrolls in a scheme via the eMPF Platform, the employer can set the code themselves. If the employer has enrolled in a scheme before the scheme is migrated to the eMPF Platform, it is likely that the value remains consistent with the one currently used by the trustee. The code can be retrieved from the eMPF Platform once the scheme has been fully migrated."]
[null,null,null,"If no voluntary contribution has been setup, leave it blank.\n\n這是在設置自願性供款時使用的成員類別。該代碼將用於定義資產歸屬比例，以確定相應的已離職成員的已歸屬利益。此成員類別還用於確定自願供款的金額。\n\n如果僱主通過電子強積金平台新登記計劃，僱主可以自行設定該代碼。如果僱主在計劃轉移到電子強積金平台之前已經登記了計劃，那麼該代碼很可能與受託人當前使用的代碼保持一致。一旦計劃完全遷移到積金易平台，可以從積金易平台檢索該代碼。\n\n如果沒有設置自願供款，請將其留空。"]
["Commencement Date for Vesting Entitlement\n享有歸屬權益生效日期","YYYYMMDD","Conditional Mandatory if the member is joining the voluntary contribution and service definition is determined by employer\n有條件下為必填項目 \n如果成員正在加入自願供款計劃，且服務定義由僱主確定。","This is the start date provided by employer that is used in the determination of vesting of voluntary contributions on termination of employment if the date is used in the setup of the voluntary contribution.",20121231]
[]
[null,null,null,"For example, suppose an employee joins on January 1, 2022, setting the 'Commencement Date for Vesting Entitlement' to the same date. By January 1, 2023, a year's service will count towards the entitlement calculation via the vesting scale. \n\n這是僱主提供的開始日期，用於確定在離職時自願供款的歸屬比例，如果該日期用於自願供款的設置。\n\n例如，假設一名員工於2022年1月1日加入，並將「歸屬權開始日期」設定為同一日期。到2023年1月1日，一年的服務將通過歸屬比例計算納入歸屬權的計算中。"]
["Employee Type\n受僱類型","Letters With Special Characters (11)","Conditional Mandatory only if member's status is \"N\"\n有條件下為必填項目\n如果成員的狀態為「N」。","\"NEW\": New Employee 新僱員","NEW"]
[null,null,null,"\"INTRA_GROUP\": Intra-group Transfer 集團內部轉移"]
[null,null,null,"\"EXEMPT\": Exempt Person 獲豁免人士"]
[null,null,null,"(An Exempted employee is only listed in the 'New Member Information' if he joins a scheme.)"]
[null,null,null,"Exempted employees can also participate in a scheme for Voluntary Contribution. "]
[null,null,null,"（獲豁免人士 僅在「新成員資料」中列出，如果他加入了計劃。）"]
[null,null,null,"獲豁免僱員也可以參與自願供款計劃"]
[null,null,null,"\"EXPATRIATE\": Expatriate Employee 外籍員工"]
[null,null,null,"\"EXIST\": Existing Employee transfers to the Scheme (without changing company)     現有僱員轉入本計劃(在不更換公司的情況下)"]
["Previous Date of Employment\n前一次受僱日期","YYYYMMDD","Conditional Mandatory if member's status is \"N\" and \"Type of Employee\" is Intra-group transfer, including ORSO transfer\n有條件下為必填項目\n如果成員的狀態為「N」且「受僱類型」為集團內部轉移，包括職業退休計劃轉移。","This is the date the employee first joined the group in the case of an intra-group transfer.\n僱員在集團內部轉移情況下，指其首次加入該集團的日期。",20121231]
["Visa Issue date\n簽證簽發日期","YYYYMMDD","Conditional Mandatory if member’s status is \"N\" and the member is an expatriate employee.\n有條件下為必填項目\n如果成員的狀態為「N」且該成員是外籍員工。","Date of Expatriate Visa issuance",20121231]
[null,null,null,"This is the date when the Hong Kong Immigration Department approved and provided the Expatriate Visa to the person, allowing them to temporarily live and work in Hong Kong.\n外籍簽證簽發日期\n這是香港入境事務處批准並提供外籍簽證給該人的日期，允許他們在香港暫時居住和工作。"]
["Email Address\n電郵地址","Letters With Special Characters (100)","Optional\n選填項目。","Email Address of the new employee\n新僱員的電子郵件地址。","suzanchan@webdoc.com"]
["Mobile No. (Country Code)\n手機號碼（國家代碼）","Letters With Special Characters (10)","Conditional Mandatory if member's status is \"N\", full mobile number including the  country code must be provided.\n有條件下為必填項目 \n如果成員的狀態為「N」。請確保提供完整的手機號碼，包括國家代碼。","Country code of the mobile number\n手機號碼的國家代碼。\n\nIf there is no Country Code, enter \"N/A\".\n如果沒有國家代碼，請輸入「N/A」。","852\nN/A"]
["Mobile No.\n手機號碼","Numeric (15,0)",null,"Mobile number of the new employee. If it is a Hong Kong mobile no, it must not start with '2' or '3'.\n新員工的手機號碼。如果是香港手機號碼，則不得以「2」或「3」開頭。",99180102]
[" "]
[]
["Termination of member 終止受僱資料"]
["Data Field 資料欄位","Format 格式","Conditions 條件","Definition 定義","Example 例子"]
["Last Date of Employment\n最後受僱日期","YYYYMMDD","Conditional Mandatory only for member's status is \"T\"\n有條件下為必填項目\n只有在成員的狀態為「T」。","The last working day of the employee\n員工的最後工作日。",20121231]
["Reason of Termination\n離職理由","Letters With Special Characters (15)","Conditional Mandatory only for member’s status is \"T\"\n有條件下為必填項目 \n只有在成員的狀態為「T」。","\"RESIGN\": Resignation 辭職","RESIGN"]
[null,null,null,"\"RETIRE\": Retirement 退休"]
[null,null,null,"\"EARLY_RETIRE\": Early Retirement 提早退休"]
[null,null,null,"\"DEATH\": Death 身故"]
[null,null,null,"\"ILL_HEALTH\": Ill Health 健康問題"]
[null,null,null,"\"TOTAL_INCAP\": Total Incapacity 完全喪失行為能力"]
[null,null,null,"\"REDUNDANCY\": Redundancy 裁員"]
[null,null,null,"\"LAID_OFF\": Laid Off 遣散"]
[null,null,null,"\"DISMIS\": Dismissal 解僱"]
[null,null,null,"\"SUM_DISMISS\": Summary Dismissal 因故革職"]
[null,null,null,"\"CONTRACT_END\": End of Contract 合約完結"]
["Long Service Payment/Severance Payment\n長期服務金／遣散費","Letters Only (1)","Conditional Mandatory only for member's status is \"T\" and employer requests for LSP/SP offsetting, otherwise, leave it blank.\n有條件下為必填項目 \n只有在成員的狀態為「T」且僱主要求進行長期服務金/ 遣散費抵銷時才提供該信息，否則請留空。","\"L\" is for Long Service Payment’s request and “S” is for Severance Payment’s request.","L"]
[]
[null,null,null,"\"L\" is only allowed if termination reason is \"DEATH\", \"DISMIS\", \"CONTRACT_END\", \"ILL_HEALTH\", \"RETIRE\" or \"TOTAL_INCAP\" and year of service is at least 5 years "]
[null,null,null,"\"S\" is only allowed if termination reason is \"REDUNDANCY\" or \"LAID_OFF\" and year of service is at least 2 years \n\n\"L\"代表長期服務金的申請，\"S\"代表遣散費的申請。\n\n只有在終止原因為「DEATH」、「DISMIS」、「CONTRACT_END」、「ILL_HEALTH」、「RETIRE」或「TOTAL_INCAP」，且服務年限超過5年時，才允許使用長期服務金的申請「L」。\n\n只有在終止原因為「REDUNDANCY」或「LAID_OFF」，且服務年限超過2年時，才允許使用遣散費的申請「S」。\n\nPlease remember that if you are applying for an LSP/SP offset, you must complete the LSP/SP offset process to provide further details, either through the eMPF Platform or by submitting a paper form.\n\n請注意，如果你申請 LSP/SP 抵消，必須完成 LSP/SP 抵消流程以提供更多詳細資訊，可以通過 eMPF 平台或提交紙本表格來進行。"]

{"sheet":"Scheme Registration No","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Scheme Registration No. Conversion Table 計劃註冊編號轉換表"]
["Scheme Registration No. 計劃註冊編號","Scheme Name 計劃名稱"]
["MT00172","AIA MPF - Prime Value Choice\n友邦強積金優選計劃"]
["MT00539","AMTD MPF Scheme\nAMTD 強積金計劃"]
["MT00393","BCOM Joyful Retirement MPF Scheme\n交通銀行愉盈退休強積金計劃"]
["IS00017","BCT (MPF) Industry Choice\nBCT(強積金)行業計劃"]
["MT00016","BCT (MPF) Pro Choice\nBCT 積金之選"]
["MT00075","BCT Strategic MPF Scheme\nBCT強積金策略計劃"]
["IS00025","BEA (MPF) Industry Scheme\n東亞(強積金)行業計劃"]
["MT00202","BEA (MPF) Master Trust Scheme\n東亞(強積金)集成信託計劃"]
["MT00571","BEA (MPF) Value Scheme\n東亞(強積金)享惠計劃"]
["MT00091","BOC-Prudential Easy-Choice Mandatory Provident Fund Scheme\n中銀保誠簡易強積金計劃"]
["MT00083","China Life MPF Master Trust Scheme\n中國人壽強積金集成信託計劃"]
["MT00288","Fidelity Retirement Master Trust\n富達退休集成信託"]
["MT00121","Haitong MPF Retirement Fund\n海通 MPF 退休金"]
["MT00253","Hang Seng Mandatory Provident Fund - SuperTrust Plus\n恒生強積金智選計劃"]
["MT00245","HSBC Mandatory Provident Fund - SuperTrust Plus\n滙豐強積金智選計劃"]
["MT00482","Manulife Global Select (MPF) Scheme\n宏利環球精選(強積金)計劃"]
["MT00490","Manulife RetireChoice (MPF) Scheme\n宏利退休精選(強積金)計劃"]
["MT00350","MASS Mandatory Provident Fund Scheme\n萬全強制性公積金計劃"]
["MT00547","My Choice Mandatory Provident Fund Scheme\n我的強積金計劃"]
["MT00504","Principal MPF - Simple Plan\n信安強積金 - 易富之選"]
["MT00180","Principal MPF - Smart Plan\n信安強積金 - 明智之選"]
["MT00059","Principal MPF Scheme Series 800\n信安強積金計劃800系列"]
["ES00020","SHKP MPF Employer Sponsored Scheme\n新地強積金僱主營辦計劃"]
["MT00067","Sun Life Rainbow MPF Scheme\n永明彩虹強積金計劃"]

{"sheet":"Examples","index":4,"n_rows":110,"n_cols":48,"rows_kept":110,"cut":false,"hidden":false,"merged":[[2,45,3,47],[9,0,10,11],[30,23,31,26],[2,0,5,0],[2,1,3,12],[2,13,3,29],[2,30,3,44],[13,0,14,11],[17,0,18,11],[22,0,23,11],[26,0,27,11],[30,0,31,22],[78,0,79,15],[58,0,59,11],[58,12,59,15],[58,22,59,26],[34,0,35,11],[38,0,39,11],[42,0,43,21],[42,22,43,22],[42,23,43,23],[44,0,44,21],[47,0,48,21],[47,22,48,22],[47,23,48,23],[49,0,49,21],[52,0,53,11],[62,0,63,16],[62,22,63,26],[66,0,67,15],[70,0,71,15],[74,0,75,15],[103,0,104,18],[107,0,108,18],[82,0,83,16],[86,0,87,18],[90,0,91,18],[93,0,94,18]]}
[]
[]
["Description\n描述","General Information (Mandatory) 一般資訊（必填項目）一般资讯（必填项目）",null,null,null,null,null,null,null,null,null,null,null,"Member Contribution data (Fill in only when members have contributions to submit)（僅在成員有供款要提交時填寫）成员供款资料（仅在成员有供款要提交时填写）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New member data (Fill in only for the new member status (N), leave blank for other member status （僅填寫新成員狀態為（N），其他成員狀態則留空）新成员资料（仅填写新成员状态为（N），其他成员状态则留空）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Termination data (Fill in only for terminated member status (T), leave blank for other member statuses) 終止受僱資料（僅填寫終止受僱成員狀態為（T），其他成員狀態則留空  终止受雇资料（仅填写终止受雇成员状态为（T），其他成员状态则留空)"]
[]
[null,"Mandatory 必填項目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Mandatory 必填項目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Mandatory 必填項目","Mandatory 必填項目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Mandatory 必填項目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Optional 選填項目 \n选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Optional 選填項目 选填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目","Conditional Mandatory 有條件下為必填項目 有条件下为必填项目"]
[null,"Select from the dropdown list \n(Please refer to the scheme name & scheme code conversion table in \"Scheme Registration No\" tab)\n從下拉清單中選擇 （請參閱“備註”工作表中的計劃註冊編號轉換表）\n从下拉清单中选择（请参阅“备注”工作表中的计划注册编号转换表）","Maximun 15 numeric characters with no decimal places\n最多15個數字字符，不帶小數位\n最多15个数字字符，不带小数位","Maximun 20 English, numeric or special Characters \n最多20個英文字母、數字或特殊字符\n最多20个英文字母、数字或特殊字符","Maximun 50 English or numeric characters with no decimal places\n最多50個英文或數字字符，不帶小數位\n最多50个英文或数字字符，不带小数位","YYYYMMDD","YYYYMMDD","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择","For HKID, please include the check digit, without brackets.\n對於香港身份證號碼，請包括全部數字，不含括號。\n对于香港身份证号码，请包括全部数字，不含括号。","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择","Maximun 15 numeric characters with no decimal places\n最多15個數字字符，不含小數位\n最多15个数字字符，不含小数位","Maximun 20 English or numeric characters with no decimal places\n最多20個英文字母或數字字符，不含小數位\n最多20个英文字母或数字字符，不含小数位","YYYYMMDD","YYYYMMDD","Maximun 3 numeric characters with no decimal places\n最多3個數字字符，不含小數位\n最多3个数字字符，不含小数位"," YYYYMMDD"," YYYYMMDD","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Maximum 18 Numeric characters with 2 decimal places\n最多18個數字字符，保留2位小數位\n最多18个数字字符，保留2位小数位","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择 ","Maximum 100 English characters\n最多100個英文字符\n最多100个英文字符","Maximum 100 English characters\n最多100個英文字符\n最多100个英文字符","Maximum 50 Chinese characters\n最多50個中文字符\n最多50个中文字符","Maximum 50 Chinese characters\n最多50個中文字符\n最多50个中文字符","YYYYMMDD","YYYYMMDD","Maximum 50 English characters\n最多50個英文字符\n最多50个英文字符","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择 ","YYYYMMDD","YYYYMMDD","Maximum 100 English, numeric or special characters\n最多100個英文字母、數字或特殊字符\n最多100个英文字母、数字或特殊字符","Maximum 10 numeric or special characters\n最多10個數字或特殊字符\n最多10个数字或特殊字符","Maximum 15 numeric characters with no decimal places\n最多15個數字字符，不含小數位\n最多15个数字字符，不含小数位","YYYYMMDD","Select from the dropdown list \n從下拉清單中選擇\n从下拉清单中选择 ","Select from the dropdown list / Blank\n從下拉清單中選擇 / 留空\n从下拉清单中选择 / 留空"]
["Data Example 例子","-",3777463656273,"MLY","HRD",20221201,20221231,20230110,"-","-","E3649125",20121231,"-",22983883092,"AG55446576",20220201,20220228,3,20121201,20121231,23000.5,23000.5,1150.03,1150.03,2000,2000,0,57.75,57.75,6415.56,"-","Lee","Chee Hynn Aiden","李","子軒",20121231,"For member who can provide the date of birth: 19710212\nFor member who can only provide the year and month of birth: 197102\nFor member who can only provide the year of birth: 1971","Manager",20121231,"-",20121231,20121231,"suzanchan@webdoc.com",852,99999999,20121231,"-","-"]
["Data Field\n資料欄位\n资料栏位\nUser Remarks: Enter any comments or notes related to the row in column A. This information is for user reference only and will not be used for system validation or upload purposes.\n使用者備註：在A列中輸入與該行相關的任何評論或備註。此資訊僅供使用者參考，不會用於系統驗證或上傳目的。\n使用者备注：在A列中输入与该行相关的任何评论或备注。此资讯仅供使用者参考，不会用于系统验证或上传目的。","Scheme Registration No.\n(Please refer to Scheme Registration No. Conversion Table in \"Scheme Registration No\" tab)\n計劃註冊編號（請參閱“備註”工作表中的計劃註冊編號轉換表）\n计划注册编号（请参阅“备注”工作表中的计划注册编号转换表）","Employer Account No.\n僱主帳戶號碼\n雇主帐户号码","Payroll Group ID\n工資組別編號\n工资组别编号","Department Code\n部門編號\n部门编号","Payroll Contribution Period Start Date\n工資供款期開始日期\n工资供款期开始日期","Payroll Contribution Period End Date\n工資供款期完結日期\n工资供款期完结日期","Contribution Day\n(For Casual Employee of Industry Scheme only)\n供款日（僅適用於行業計劃的臨時雇員）\n供款日（仅适用于行业计划的临时雇员）","Employee Account Type \n(For details, please refer to General information table in \"Note\" tab)\n受僱類型（詳情請參閱“備註”工作表中的一般資訊表）\n受雇类型（详情请参阅“备注”工作表中的一般资讯表）","ID Type\n身分證明類別\n身分证明类别","ID No.\n身分證明號碼\n身分证明号码","Date of Employment\n受僱日期\n受雇日期","Member's Status \n(For details, please refer to General information table in \"Note\" tab)\n成員狀態（詳情請參閱“備註”工作表中的一般資訊表）\n成员状态（详情请参阅“备注”工作表中的一般资讯表）","Member Account No.\n成員帳戶號碼 \n成员帐户号码","Staff No.\n職員編號\n职员编号","Member Contribution Period Start Date\n成員供款期開始日期\n成员供款期开始日期","Member Contribution Period End Date\n成員供款期完結日期\n成员供款期完结日期","No. of Working Days \n(For Casual Employee of Industry Scheme only)\n工作日數 （僅適用於行業計劃的臨時雇員）\n工作日数 （仅适用于行业计划的临时雇员）","Working Period Start Date\n(For Casual Employee of Industry Scheme only)\n工作期開始日期\n（僅適用於行業計劃的臨時雇員）\n工作期开始日期\n（仅适用于行业计划的临时雇员）","Working Period End Date\n(For Casual Employee of Industry Scheme only)\n工作期完結日期\n（僅適用於行業計劃的臨時雇員）\n工作期完结日期\n（仅适用于行业计划的临时雇员）","Relevant Income\n有關入息\n有关入息","Basic Salary\n基本薪金\n基本薪金","Employer's Mandatory Contributions\n僱主強制性供款\n雇主强制性供款","Employee's Mandatory Contributions\n僱員強制性供款\n雇员强制性供款","Employer's Voluntary Contributions\n僱主自願性供款\n雇主自愿性供款","Employer's Voluntary Contributions 2\n僱主自願性供款2\n雇主自愿性供款2","Employee's Voluntary Contributions\n僱員自願性供款 \n雇员自愿性供款","Employer's Surcharges\n僱主附加費\n雇主附加费","Employee's Surcharges\n僱員附加費\n雇员附加费","Total Amount\n總額\n总额","Gender\n(For details, please refer to New member information table in \"Note\" tab)\n性別（詳情請參閱“備註”工作表中的新成員資訊表）\n性别（详情请参阅“备注”工作表中的新成员资讯表）","Surname (English)\n姓氏（英文）","Given Name (English)\n名字（英文）","Surname (Chinese)\n姓氏（中文）","Given Name (Chinese)\n名字（中文）","Date of Joining the Scheme\n參加計劃日期\n参加计划日期","Date of Birth\n出生日期","Member Class\n成員組別\n成员组别","Commencement Date for Vesting Entitlement\n享有歸屬權益生效日期\n享有归属权益生效日期","Employee Type\n(For details, please refer to New member information table in \"Note\" tab)\n受僱類型（詳情請參閱「備註」工作表中的新成員資訊表）\n受雇类型（详情请参阅「备注」工作表中的新成员资讯表）","Previous Date of Employment\n前一次受僱日期\n前一次受雇日期","Visa Issue Date\n簽證簽發日期\n签证签发日期","Email Address\n電郵地址\n电邮地址","Mobile No. (Country Code)\n手機號碼（國家代碼）\n手机号码（国家代码）","Mobile No.\n手機號碼\n手机号码","Last Date of Employment\n最後受僱日期\n最后受雇日期","Reason of Termination\n(For details, please refer to Termination of member table in \"Note\" tab)\n離職理由（詳細資訊請參閱「備註」工作表中的終止受僱成員表）\n离职理由（详细资讯请参阅「备注」工作表中的终止受雇成员表）","Long Service Payment/Severance Payment\n(For details, please refer to Termination of member table in \"Note\" tab)\n長期服務金／遣散費（詳細資訊請參閱「備註」工作表中的終止受僱成員表）\n长期服务金／遣散费（详细资讯请参阅「备注」工作表中的终止受雇成员表）"]
["(Example of ordinary contribution scenario, this row is not being used. Please fill in your data in row 10)\n（普通供款情境範例，此行未使用。請在第10行填入你的資料）","MT00288",123456789012,"MLY","HRD",20211201,20211231,20230110,"REE","HKID","Z9881329",20110102,"E",1111111,"AG55446576",20211201,20211231,111,20121201,20121231,21500,23000.5,1075,1075,0,0,0,null,null,4265.5]
["Scenario 1 - Report of new member who just joined the company within a month, no contribution will be made, not joining the voluntary contribution"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z683365A",20211201,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","AU-YEUNG","FUNG","歐陽","峰",20211201,20020202,null,null,"NEW",null,null,"defghi@address.ik",852,87654321]
[]
["Scenario 2 - Report of new member who just joined the company within a month, no contribution will be made, joining the voluntary contribution"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z936829A",20211201,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,"張","梓浩",20211201,19990401,"GT1",20211201,"NEW",null,null,"chi_cheung@mem.com.an",852,93882733]
[]
["Scenario 3 - Report of new member who has joined the company for 60 days, and contribution for the employee is made, not joining the voluntary contribution"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","C6686689",20211101,"N",null,null,20211101,20211130,null,null,null,28000,null,1400,null,null,null,null,null,null,1400,"F","Chan","Suzan",null,null,20211101,19810527,null,null,"NEW",null,null,"suzanchan@webdoc.com"]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","C6686689",20211101,"N",null,null,20211201,20211231,null,null,null,28000,null,1400,1400,null,null,null,null,null,2800,"F","Chan","Suzan",null,null,20211101,19810527,null,null,"NEW",null,null,"suzanchan@webdoc.com"]
[]
["Scenario 4 - Make contribution to existing members without voluntary contribution"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z3882978",20130112,"E",2958473832,"S399384",20211201,20211231,null,null,null,18000,null,900,900,null,null,null,null,null,1800]
[]
["Scenario 5 - Make contribution to existing members with voluntary contribution"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z9881329",20110102,"E",null,null,20211201,20211231,null,null,null,21500,null,1075,1075,1000,1000,0,null,null,4150]
[]
["Scenario 6 - An employee has terminated with Contract Ends in last contribution period with LSP/SP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Because the Monthly Relevant Income is less than $7100, no Employee Mandatory Contribution is required (As of 2023/01/16)"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","G9088333",20110102,"T",null,null,20211201,20211231,null,null,null,5000,null,250,0,null,null,null,null,null,250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20211214,"CONTRACT_END","L"]
[]
["Scenario 7 - An employee has terminated with resignation in last contribution period without LSP/SP"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z6833676",20110102,"T",null,null,20211201,20211231,null,null,null,11000,null,550,550,200,200,0,null,null,1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20211216,"RESIGN"]
[]
["Scenario 8 - An employee who took unpaid leave (doesn't have any relevant income) during the contribution period, not joining Voluntary Contribution"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","C6686689",20140801,"E",null,null,20211201,20211231,null,null,null,0,null,0,0,null,null,null,null,null,0]
[]
["Scenario 9 - An employer who makes contribution for a casual employee of Industry Scheme on the next working day following the pay day, paid on a weekly basis from 2021/08/11 to 2021/08/17, no. of working days is 4, and daily income is $1200",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$50 x 4","$50 x 4"]
[]
["(Please note that each file can only handle one scheme, so the value in column B should be the same for every row. The example provided is just for demonstrating the formatting for the ISCEE)"]
[null,"IS01038",229382034092,"WKLY",null,20210811,20210817,20210818,"CEE","HKID","Z683365A",20210811,"E",null,null,20210811,20210817,4,20210811,20210817,null,null,200,200,null,null,null,null,null,400]
[]
["Scenario 10 - An employer who makes contribution for a casual employee of Industry Scheme chooses to pay mandatory contribution within 10 days after the end of contribution period, contribution period from 2021/11/01 to 2021/11/15 (15 days), work for 6 days, total relevant income is $3,300, so daily income is $3300/6 = $550",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$30 x 6","$30 x 6"]
[]
["(Please note that each file can only handle one scheme, so the value in column B should be the same for every row. The example provided is just for demonstrating the formatting for the ISCEE)"]
[null,"IS01038",229382034092,"BIWKLY",null,20211101,20211115,null,"CEE","HKID","Z3882978",20211102,"E",null,null,20211101,20211115,6,20211101,20211115,3300,null,180,180,null,null,null,null,null,360]
[]
["Scenario 11 - An employer who makes contributions for two existing normal employees, and one of these members (A5270734) has incurred a surcharge from the contribution period of the previous month."]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","X7623491",20090402,"E",null,null,20211201,20211231,null,null,null,21500,null,1075,1075,null,null,null,null,null,2150]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","A5270734",20081004,"E",null,null,20211201,20211231,null,null,null,11000,null,550,550,null,null,null,null,null,1100]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","A5270734",20081004,"E",null,null,20211101,20211130,null,null,null,null,null,null,null,null,null,null,100,100,200]
[]
["Scenario 12 - Make contribution to existing members without voluntary contribution, and Relevant Income is more than $30,000, so the Employer and Employee Mandatory Contribution is capped at $1,500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Because the Monthly Relevant Income of the employee is more than $30,000, Employer and Employee Mandatory contribution is capped at $1,500 (As of 2023/01/16)"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","N4895574",20191203,"E",null,null,20211201,20211231,null,null,null,55000,null,1500,1500,null,null,null,null,null,3000]
[]
["Scenario 13 - Make contribution to existing members without voluntary contribution, and Relevant Income is less than $7,100, so the Employer Mandatory Contribution is calculated as Relevant income x 5%, no Employee's Mandatory Contribution is required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Because the Monthly Relevant Income of the employee is less than $7,100, Employee Mandatory contribution is not needed and set to $0 (As of 2023/01/16)"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z3882978",20130112,"E",2958473832,"S399384",20211201,20211231,null,null,null,6500,null,325,0,null,null,null,null,null,325]
[]
["Scenario 14 - Enrol an exempt person who enrols to a MPF scheme in order to join the voluntary contribution"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","PASSPORT","AP9929922C",20211214,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F","Cheung","Mei Na","張","美娜",20211214,19850412,"MT1",20211214,"EXEMPT",null,null,"random123@example.com",852,51234567]
[]
["Scenario 15 - An exempt person who has enrolled to a MPF scheme to make voluntary contribution based on monthly salary "]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","PASSPORT","IND033234443",20190825,"E",null,null,20211201,20211231,null,null,null,4000,28000,null,null,840,0,840,null,null,1680]
[]
["Scenario 16 - An employee who retired within the contribution period of 2021/12/01 - 2021/12/31, last employment date on 2021/12/01 with no pay leave, so no Relevant Income in that period, with Long Service Payment’s request "]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","H9644190",20161013,"T",null,null,20211201,20211231,null,null,null,0,null,0,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20211201,"RETIRE","L"]
[]
["Scenario 17 - An employer enrols and makes contribution to an employee who has employed less than 60 days, so both the 'Member Contribution' and 'New Member' sections need to be filled, not joining VC"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","F435122A",20211207,"N",null,null,20211201,20211231,null,null,null,18000,null,900,null,null,null,null,null,null,900,"F","Li","Wei","李","偉",20211207,19890917,null,null,"NEW",null,null,"mail1234@bmail.com",852,53566432]
[]
["Scenario 18 - An employee who has been employed more than 2 years, and redundent within the contribution period of 2021/12/01 - 2021/12/31 on 2021/12/18, the employee has relevant income and contribution within the period, and request for Severance Payment"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","H8977285",20170714,"T",null,null,20211201,20211231,null,null,null,9700,null,485,485,null,null,null,null,null,970,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20211218,"REDUNDANCY","S"]
[]
["Scenario 19 - An employee who has been employed less than 2 years, and redundent within the contribution period of 2021/12/01 - 2021/12/31 on 2021/12/18, the employee has relevant income and contribution within the period, but the employee is not entitled to Severance Payment"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","R4349961",20201123,"T",null,null,20211201,20211231,null,null,null,8600,null,430,430,null,null,null,null,null,860,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20211218,"REDUNDANCY"]
[]
["Scenario 20 - An employer has setup two separate voluntary rules on the Employer Voluntary Contribution, so the employer can make Employer Voluntary Contribution in two separate accounts"]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20211201,20211231,null,null,null,32000,null,1500,1500,800,400,200,null,null,4400]
["Scenario 21 - An employer needs to use the current standardized contribution upload file to report employee contributions for the past six months."]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20211201,20211231,null,null,null,23000,null,1150,1150,null,null,null,null,null,2300]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20211101,20211130,null,null,null,23000,null,1150,1150,null,null,null,null,null,2300]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20210901,20210930,null,null,null,23000,null,1150,1150,null,null,null,null,null,2300]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20210801,20210831,null,null,null,23000,null,1150,1150,null,null,null,null,null,2300]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20210701,20210731,null,null,null,21000,null,1050,1050,null,null,null,null,null,2100]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20210601,20210630,null,null,null,21000,null,1050,1050,null,null,null,null,null,2100]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","D6242589",20141027,"E",null,null,20210501,20210531,null,null,null,21000,null,1050,1050,null,null,null,null,null,2100]
[]
["Scenario 22 - When an employer submits a contribution for an employee with only one 'Active' employment account, there is no need to enter the Date of Employment."]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z3882978",null,"E",2958473832,"S399384",20211201,20211231,null,null,null,18000,null,900,900,null,null,null,null,null,1800]
[]
["Scenario 23 - An employee has left the company and the employment has been terminated, but a commission was paid after his/her departure. The employer would submit a contribution for this terminated employee. The employer should provide the ID Type, ID No., and Date of Employment for system to identify the record, and the Member's Status must be 'T' or 'E', recommend using 'T' for clear indication."]
[]
[null,"MT00298",123456789012,"MLY",null,20211201,20211231,null,"REE","HKID","Z3882978",20211201,"E",2958473832,"S399384",20211201,20211231]

{"sheet":"Version","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Amendment"]
["1.0","31/5/2024","Initial Release.",null,"As of 2023/01/16, MPF contributions are calculated according\nto the following tables for \"Regular Employee\":"]
["1.1","26/6/2024","Add checking to make sure the Employer Account No. is numeric\nMinor fix"]
["1.2","2024-12-09","Fixed an issue from HKID number checking.\nFixed rounding issue for the Total Amount.\nMaking both the Mobile no. and Email are mandatory in the \"New Member\" section.\nAdd validation to not allow mobile number start with 2 or 3.\n\nIn Note spreadsheet\n\nMaking both the Mobile no. and Email are mandatory in the \"\"New Member\"\" section."]
["1.3","2024-12-04","Remove two Termination Reason\n- \"WRONG_ENROL\": Wrong Enrolment 錯誤的登記\n- \"INTRA_GROUP_TRF\": Intra-group transfer 轉職至有聯繫公司\n\nFor Long Service Payment/Severance Payment, update the allowed Reason for Termination for \"L\" to DEATH, DISMIS, CONTRACT_END, ILL_HEALTH, or RETIRE, provided that the year of service exceeds 5 years.\n\nFix the Chinese Description of Reason of Termination\n\nMore note on the Contributions.\n\nMinor fixes on the macro."]
["1.3.1","2025-01-18","Resolved the rounding issue for RI and contributions when exporting the template as a CSV file.\n\nIn Note spreadsheet\n\nAlign the terminology of \"Reason of Termination\" between the template and eMPF Platform."]
["1.4","2025-07-11","In Note spreadsheet\n\nDate of Employment, Staff No. - provide more detail definition and the way to use them.\n\nSurname (English) and Given Name (English) do not accept \",\".\n\nDate of Birth only support YYYYMMDD.\n\nEmployee Type, added a new type \"Exist\" for member that switch scheme.\n\nEmail Address becomes 'Optional'.\n\nAdd 'Total Incapacity' to the termination reason\n\nRevise the format of Mobile No. Country Code from Numeric(3,0) to Letters With Special Characters (10)\n\n\nScheme Registration No. Conversion Table\nFor Scheme Registration no., MT00075, changed scheme name from \"Invesco Strategic MPF Scheme\" to \"BCT Strategic MPF Scheme\", from 「景順強積金策略計劃」 to 「BCT強積金策略計劃」."]
["1.4.1","2025-09-05","In Template Spreadsheet\n\nFix the first few lines on the 'Template' which has incorrect format.\n\nFix the macro to allow 'TOTAL_INCAP' for termination reason using 'L'.\n\nFix the macro so that when exporting to CSV, values in column D (Payroll Group ID) retain leading zeros and aren’t trimmed when the value is numeric.\n\nIn Note spreadsheet\n\nEmployer's Mandatory Contribution, Employee's Mandatory Contribution, Employer's Voluntary Contribution, Employer's Voluntary Contribution and Employer's Voluntary Contribution 2 — each rounding off to the nearest 2 decimal places based on calculations from Relevant Income and / or Basic Salary.\n\nAdded Important Notes 1 under the section \"Member contribution information\"."]
["1.4.2","2025-11-14","\nIn Template Spreadsheet\n\nThe CSV export function is incorrectly trimming leading zeros from the IDNo field. These zeros must be preserved in the output."]
[1.5,"19/1/2025","In Template and Note spreadsheets\n\nThe 'Date of Employment' become optional for submitting contribution.\n\nThe 'Staff No.' will not be used for validation or to identify an employment account when submitting contributions.\n\nSupports submitting contributions for terminated employees.\n\nIn Examples spreadsheet\n\nAdd Scenario 22 and 23."]

{"sheet":"Country Code","index":6,"n_rows":508,"n_cols":1,"rows_kept":508,"cut":false,"hidden":true,"merged":[]}
["Country Code"]
["+852"]
["+853"]
["+86"]
["+011"]
["+1"]
["+1"]
["+1-242"]
["+1-246"]
["+1-264"]
["+1-268"]
["+1-284"]
["+1-340"]
["+1-345"]
["+1-441"]
["+1-473"]
["+1-649"]
["+1-664"]
["+1-670"]
["+1-671"]
["+1-684"]
["+1-721"]
["+1-758"]
["+1-767"]
["+1-784"]
["+1-787"]
["+1-809"]
["+1-829"]
["+1-849"]
["+1-868"]
["+1-869"]
["+1-876"]
["+1-939"]
["+20"]
["+211"]
["+212"]
["+212"]
["+213"]
["+216"]
["+218"]
["+220"]
["+221"]
["+222"]
["+223"]
["+224"]
["+225"]
["+226"]
["+227"]
["+228"]
["+229"]
["+230"]
["+231"]
["+232"]
["+233"]
["+234"]
["+235"]
["+236"]
["+237"]
["+238"]
["+239"]
["+240"]
["+241"]
["+242"]
["+243"]
["+244"]
["+245"]
["+246"]
["+248"]
["+249"]
["+250"]
["+251"]
["+252"]
["+253"]
["+254"]
["+255"]
["+256"]
["+257"]
["+258"]
["+260"]
["+261"]
["+262"]
["+262"]
["+262"]
["+263"]
["+264"]
["+265"]
["+266"]
["+267"]
["+268"]
["+269"]
["+27"]
["+290"]
["+291"]
["+297"]
["+298"]
["+299"]
["+30"]
["+31"]
["+32"]
["+33"]
["+34"]
["+350"]
["+351"]
["+352"]
["+353"]
["+354"]
["+355"]
["+356"]
["+357"]
["+358"]
["+358"]
["+359"]
["+36"]
["+370"]
["+371"]
["+372"]
["+373"]
["+374"]
["+375"]
["+376"]
["+377"]
["+378"]
["+379"]
["+380"]
["+381"]
["+382"]
["+385"]
["+386"]
["+387"]
["+389"]
["+39"]
["+40"]
["+41"]
["+420"]
["+421"]
["+423"]
["+43"]
["+44"]
["+44-1481"]
["+44-1534"]
["+44-1624"]
["+45"]
["+46"]
["+47"]
["+47"]
["+48"]
["+49"]
["+500"]
["+500"]
["+501"]
["+502"]
["+503"]
["+504"]
["+505"]
["+506"]
["+507"]
["+508"]
["+509"]
["+51"]
["+52"]
["+53"]
["+54"]
["+55"]
["+55"]
["+56"]
["+57"]
["+58"]
["+590"]
["+590"]
["+590"]
["+591"]
["+592"]
["+593"]
["+594"]
["+595"]
["+596"]
["+597"]
["+598"]
["+599"]
["+599"]
["+599-7"]
["+60"]
["+61"]
["+61"]
["+61"]
["+62"]
["+63"]
["+64"]
["+64"]
["+65"]
["+66"]
["+670"]
["+672"]
["+672"]
["+672-3"]
["+673"]
["+674"]
["+675"]
["+676"]
["+677"]
["+678"]
["+679"]
["+680"]
["+681"]
["+682"]
["+683"]
["+685"]
["+686"]
["+687"]
["+688"]
["+689"]
["+690"]
["+691"]
["+692"]
["+7"]
["+7"]
["+81"]
["+82"]
["+84"]
["+850"]
["+855"]
["+856"]
["+880"]
["+886"]
["+90"]
["+91"]
["+92"]
["+93"]
["+94"]
["+95"]
["+960"]
["+961"]
["+962"]
["+963"]
["+964"]
["+965"]
["+966"]
["+967"]
["+968"]
["+970"]
["+971"]
["+972"]
["+973"]
["+974"]
["+975"]
["+976"]
["+977"]
["+98"]
["+992"]
["+993"]
["+994"]
["+995"]
["+996"]
["+998"]
["N/A"]
[852]
[853]
[86]
[11]
[1]
[1]
["1-242"]
["1-246"]
["1-264"]
["1-268"]
["1-284"]
["1-340"]
["1-345"]
["1-441"]
["1-473"]
["1-649"]
["1-664"]
["1-670"]
["1-671"]
["1-684"]
["1-721"]
["1-758"]
["1-767"]
["1-784"]
["1-787"]
["1-809"]
["1-829"]
["1-849"]
["1-868"]
["1-869"]
["1-876"]
["1-939"]
[20]
[211]
[212]
[212]
[213]
[216]
[218]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[260]
[261]
[262]
[262]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[27]
[290]
[291]
[297]
[298]
[299]
[30]
[31]
[32]
[33]
[34]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[358]
[359]
[36]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[385]
[386]
[387]
[389]
[39]
[40]
[41]
[420]
[421]
[423]
[43]
[44]
["44-1481"]
["44-1534"]
["44-1624"]
[45]
[46]
[47]
[47]
[48]
[49]
[500]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[51]
[52]
[53]
[54]
[55]
[55]
[56]
[57]
[58]
[590]
[590]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[599]
["599-7"]
[60]
[61]
[61]
[61]
[62]
[63]
[64]
[64]
[65]
[66]
[670]
[672]
[672]
["672-3"]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[7]
[7]
[81]
[82]
[84]
[850]
[855]
[856]
[880]
[886]
[90]
[91]
[92]
[93]
[94]
[95]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[98]
[992]
[993]
[994]
[995]
[996]
[998]