Following are the features you would get.
1. An interface to make data entry
a) A drop down showing asking for 'incoming' or 'outgoing'
b)Entry facility for category, stock code, quantity, trade price and date
Once done click a button to push the data in back-end. If entered values are same with one of the already made entries (same category, same stock code, same date, same status (incoming or outgoing) then it will pop up a message whether operator still want to make the entry replacing the already existing one.
2. A section for report generation. Where you need to select again which status (incoming or outgoing), from which date to which date, and press generate button to see all values with total at the bottom between two dates.
If the above description is something similar to what you are looking for kindly let us know. And of course this can be made a shared document. So everyone in your office can access at the same time.
Regards,
Pal (d2imatrix)