Register of Members Format in Excel — Form MGT-1 (Free Download)

The Register of Members is the foundational statutory register that every company must maintain in Form MGT-1 under Section 88 of the Companies Act, 2013. It records, folio-wise, the particulars of every shareholder and the shares held by them, and must be kept permanently at the registered office.

Free Excel Template — ready to use
Part of the Company Secretarial Registers workbook (6 registers, one file)

⬇ Download Excel Workbook

What this register records

  • Folio number
  • Name of member
  • Father’s / mother’s / spouse name
  • Address and email
  • Occupation and nationality
  • PAN
  • Date of becoming a member
  • Number of shares and class
  • Distinctive numbers (from–to)
  • Certificate number
  • Nominal value and amount paid
  • Dates of allotment, transfer and cessation
Related CalcGuru tool

After recording a member, issue the share certificate with our Share Certificate (SH-1) generator →

Frequently asked questions

Is the Register of Members mandatory for a private company?

Yes. Under Section 88, every company — including a private limited company — must maintain a Register of Members in Form MGT-1 from the date of its registration and keep it at the registered office.

When must entries be made in the Register of Members?

Entries for an allotment or transfer of shares must be made within seven days of the Board (or its committee) approving the allotment or registering the transfer.

← See all statutory registers in one Excel workbook

Disclaimer: This template is provided free for general record-keeping convenience and does not constitute legal or professional advice. Maintain statutory registers in the formats and within the timelines prescribed under the Companies Act, 2013 and the rules made thereunder, and verify particulars with your company secretary or professional adviser.

Scroll to Top