Register of members and share ledger for Irish companies
A company keeps its own register of members – the CRO does not hold it – and it has to be updated within 28 days of every change. The workbook builds the register from a share ledger, so every allotment, transfer or buy-back updates each member's holding and the issued share capital checks itself.
- 60 members and 300 ledger lines
- Up to 4 share classes
- 150 share certificates
- Register printed at any date

Every movement in the share ledger
- Subscriber shares on incorporation
- Allotments and bonus issues
- Transfers and transmissions on death
- Buy-backs
Share numbers are assigned automatically. SHARE CAPITAL compares the shares issued with the register per class, showing nominal value, paid up and share premium, and says whether they balance.
Deadlines that are easy to miss
The workbook flags when Form B5 and Form H5, stamp duty returns on transfers, share certificates and register entries are due or overdue. OFFICERS keeps the register of directors and secretaries with the dates for Form B10.
Questions and answers
Is the register filed with the CRO?
How fast must changes be entered?
Can statutory registers be kept in Excel?
A look at the sheets




What is in the file
- START
- SETTINGS
- MEMBERS
- SHARE LEDGER
- SHARE CAPITAL
- CERTIFICATES
- OFFICERS
- BENEFICIAL OWNERS
- REGISTER PRINT
- DASHBOARD
- File format
- .xlsx
- Tabs
- 10
- Capacity
- 60 members · 300 ledger lines · 150 certificates · 4 share classes · 12 officers · 30 interests · 15 beneficial owners
- Requires
- Excel 2016+ / Microsoft 365
- Macros
- None
Beneficial owners
BENEFICIAL OWNERS picks up members above the threshold automatically and lets you add others who control the company in another way, so the list matches what is filed with the RBO. REGISTER PRINT produces the register of members at any date and a folio per member in A4 landscape.