Ill maintain 3 sets of Excel files.
1. Shares
2. Business
3. IPs
It take a while to add the accurate data behind those summary sheets but it is a 15 min job to fill the E-tax once the correct information is collected.
Develop a 'system' to fit your own needs. For example, each RE would send...