Company Secretarial Registers in Excel (Companies Act 2013) — Free Template

Maintaining statutory registers is a basic compliance requirement for every company under the Companies Act, 2013. This free Excel workbook bundles the registers a private or small company needs most into a single, pre-formatted file — enter your company details once on the cover sheet and they flow into every register.

Company Secretarial Registers — Excel Workbook
6 ready-to-use registers in one file • Companies Act, 2013 • free, no sign-up

⬇ Download Excel Workbook

What is inside the workbook

Register of Members
Form MGT-1 • Section 88
Folio-wise record of every shareholder, shares held, distinctive numbers and certificate details. To be kept permanently.
Register of Share Transfers
Section 56
Every transfer / transmission with transferor, transferee, SH-4 date, stamp duty and Board approval.
Register of Directors & KMP
Section 170
Directors and key managerial personnel, DIN, designation, dates of appointment / cessation and shareholding.
Register of Charges
Form CHG-7 • Section 85
Charges created, modified and satisfied, charge-holder, amount secured and CHG-1 / CHG-4 filing details.
Register of Allotment
Section 39 / 42 / 62
Each allotment of shares with issue type, consideration, distinctive numbers and PAS-3 filing date.
Enter your company name, CIN and capital once on the Cover & Instructions sheet; they auto-fill the header of every register. Yellow cells are for your data; green cells are filled automatically.

How to use it

  1. Download the workbook and open it in Excel or any spreadsheet app.
  2. Fill the Cover & Instructions sheet with your company particulars.
  3. Record entries in the relevant register as and when an event occurs — within the timelines prescribed by the Act (for example, the Register of Members is updated within 7 days of allotment or transfer).
  4. Generate the supporting documents with our matching tools — the Share Certificate (SH-1), Share Transfer (SH-4) and Board Resolution generators.

Frequently asked questions

Which statutory registers must a private limited company maintain?

Every company must maintain the Register of Members (Form MGT-1, Section 88), Register of Directors and KMP (Section 170), Register of Charges (Form CHG-7, Section 85), and records of share transfers (Section 56) and allotments. They must be kept at the registered office.

Are these Excel registers legally valid?

Companies may keep statutory registers in electronic form. These templates follow the particulars prescribed under the Companies Act, 2013 and its rules, but you should have entries reviewed by your company secretary or professional before relying on them.

How long must statutory registers be preserved?

The Register of Members is kept permanently. The Register of Charges must be preserved for eight years from the date of satisfaction of the charge. Other registers are retained as long as the company is in existence.

Disclaimer: This workbook is provided free for general record-keeping convenience and does not constitute legal or professional advice. Statutory registers must be maintained in the formats and within the timelines prescribed under the Companies Act, 2013 and the rules made thereunder. Verify all particulars with your company secretary or professional adviser.

Need the additional registers too?
SH-2, MBP-2, MBP-4 and MGT-2 are available as a companion Excel workbook.

Get the additional registers →

Scroll to Top