Ben-3 Register Format In Excel -
| Column | Header Name | Description | Example | |--------|-------------|-------------|---------| | L | Treaty Country | Country claiming treaty | Spain | | M | Treaty Article | e.g., 11 (Interest), 10 (Dividends) | 11 | | N | Withholding Rate Claimed | Reduced rate (0%, 5%, 10%, etc.) | 5% | | O | Default Withholding Rate | 30% without treaty | 30% | | P | Income Type | Interest, Dividends, Royalties | Interest |
While the official format is prescribed by law, many professionals use an Excel-based BEN-3 register for ease of sorting and record-keeping. A standard Excel structure includes the following columns: Column Header Description The full legal name of the individual. Address & Email ID Contact details for the SBO. Date of Birth / Age Essential identification data. Father’s / Spouse’s Name Parentage or marital details for legal verification. PAN / Passport No. ben-3 register format in excel
Highlight rows approaching expiration.
To prevent errors, restrict input values. | Column | Header Name | Description |
| Column | Header Name | Description | |--------|-------------|-------------| | A | Sl. No. | Serial number | | B | Date of entry | DD-MMM-YYYY | | C | Folio No. | SBO folio reference | | D | Name of SBO | Full name as per PAN | | E | PAN | Permanent Account Number | | F | DIN (if any) | Director Identification Number | | G | Citizenship | Indian / Foreign | | H | Date of becoming SBO | DD-MMM-YYYY | | I | Nature of significant beneficial ownership | % held / voting rights / control | | J | % of shares held directly | Numeric (0-100) | | K | % of shares held indirectly | Numeric (0-100) | | L | Total beneficial interest (%) | J+K | | M | Date of cessation (if any) | DD-MMM-YYYY | | N | Reason for cessation | Sold/transferred/ceased to be SBO | | O | Address line 1 | Registered address | | P | Address line 2 | | | Q | City | | | R | State | | | S | PIN Code | | | T | Country | | | U | Email of SBO | | | V | Contact number | | | W | Remarks | Any additional info | Date of Birth / Age Essential identification data