Additional Statutory Registers in Excel — SH-2, MBP-2, MBP-4, MGT-2 (Free)

Beyond the core statutory registers, the Companies Act, 2013 requires companies to maintain several additional registers depending on their transactions — duplicate certificates, inter-corporate loans and investments, related-party contracts, and debenture-holders. This free Excel workbook bundles all four into one file; enter your company details once on the cover sheet and they flow into every register.

Additional Statutory Registers — Excel Workbook
Forms SH-2, MBP-2, MBP-4 and MGT-2 in one file • Companies Act, 2013 • free, no sign-up

⬇ Download Excel Workbook

What is inside the workbook

Renewed & Duplicate Share Certificates
Form SH-2 • s.46(3), Rule 6
Record of every renewed or duplicate share certificate issued, with the reason and a cross-reference to the Register of Members.
View format →Share Certificate (SH-1) generator →
Loans, Guarantee, Security & Acquisition
Form MBP-2 • s.186
Inter-corporate loans, guarantees, security and investments with amount, exposure %, and resolution dates.
View format →Board Resolution generator →
Contracts with Interested Directors
Form MBP-4 • s.189
Related-party contracts and arrangements, the interested director, arm’s-length status and Board approval.
View format →Board Resolution generator →
Debenture / Security Holders
Form MGT-2 • s.88
Holder particulars, series and class, distinctive numbers and amount for each debenture or security issue.
View format →Debenture Stamp Duty calculator →
For the core registers — Register of Members, Share Transfers, Directors & KMP, Charges and Allotment — see our main Company Secretarial Registers workbook.

How to use it

  1. Download the workbook and fill the Cover & Instructions sheet with your company particulars.
  2. Record entries in the relevant register as and when a transaction or event occurs — for MBP-2, within seven days.
  3. Generate the supporting documents with the Share Certificate (SH-1) and Board Resolution generators.

Frequently asked questions

Are these registers mandatory for a private company?

Yes, where applicable. Form MBP-2 (loans, guarantee, security and acquisition under Section 186) and Form MBP-4 (contracts in which directors are interested under Section 189) must be maintained by every company that has such transactions; Form SH-2 is required whenever a renewed or duplicate certificate is issued; and Form MGT-2 is required for every company that issues debentures or other securities.

When must entries be made in the MBP-2 register?

Entries in the Register of Loans, Guarantee, Security and Acquisition (Form MBP-2) must be made chronologically within seven days of making the loan, giving the guarantee, providing the security or making the acquisition, and the register is preserved permanently at the registered office.

These add to the core statutory registers, right?

Yes. They complement the core set — Register of Members (MGT-1), Share Transfers, Directors & KMP, Charges (CHG-7) and Allotment — available in our main statutory-registers workbook.

Disclaimer: This workbook 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. Verify all particulars with your company secretary or professional adviser.

Scroll to Top