Ben-3 Register Format In Excel File

: Since this file contains sensitive PAN and Passport data, ensure the Excel file is password-protected and accessible only to authorized personnel like the Company Secretary.

The is more than a list of names and dates. It is a compliance tool, a risk mitigator, and an efficiency driver. By following the structure, formulas, and conditional formatting techniques outlined above, you will:

Instead of manually updating status, let Excel decide based on expiration: ben-3 register format in excel

When setting up your Excel sheet, you should include the following columns as prescribed by the Ministry of Corporate Affairs (MCA): Column No. Column Header Description Sl. No. Sequential entry number for each beneficial owner. 2 Name of Beneficial Owner Full legal name of the individual SBO. 3 Address and Email ID Permanent residential address and active email. 4 Date of Birth / Age Essential for identity verification. 5 Father’s/Mother’s/Spouse’s Name Parent or spouse details for identification. 6 Occupation Professional status (e.g., Business, Professional). 7 Nationality Country of citizenship. 8 PAN / UIN / CIN Permanent Account Number (for Indians) or Unique ID. 9 Passport Number Required specifically for foreign nationals. 10 Status The nature of the SBO (e.g., individual, trust). 11 Date of Declaration (u/s 90) Date the company received the BEN-1 declaration . 12 Date of Cessation Date the person ceased to be an SBO (if applicable). 13 Date of Entry in Register Date the company officially recorded the entry. 14 Date of Filing BEN-2 (SRN) The SRN of the BEN-2 filed with the RoC for this SBO. 15 Any Other Interest Details of any other rights or interests held. 16 Instructions from Member Any specific instructions provided by the shareholder. Key Compliance Requirements

Without a register, your organization risks: : Since this file contains sensitive PAN and

This will override manual input. Use only if you trust the logic.

While specialized compliance software exists, Microsoft Excel remains the undisputed king for managing these registers due to its flexibility, accessibility, and powerful formula capabilities. However, an Excel sheet is only as good as its structure. A poorly formatted register can lead to compliance penalties, data errors, and audit nightmares. Sequential entry number for each beneficial owner

To fill MCA Form BEN-3: