How to prepare books of a/c ?

Hi all the members,
I am in confusion that how to maintain shares list ie, share purchased - sold-intratrading of my clients.
Because i have seen that a share purshased 5 to 6 yrs ago get easily misplaced in excel sheet due to mistake or confusion and so.

Is there any software or technic available to keep records of share. Tally could be , but for long period it becomes cumbersome.
There is no need to apply AS .