software 5

HI, In attachment I am sending you two tables which we are using in our company. In first table we put some basic information and we send that table by email to our employee who are waiting a guests near apartments, our housekeeping and owners. The second table we are using just for us and for internal evidence. Some of the owners has more apartments thet we are manage. We are sending to owners (by email) mounthly report. We make a copy of last mounth from internal table and calculate our commision. Commision is not fixed. It is between me and owner agreement. Becouse we are growing we need to find much beter solutins. This is how I magine to do that but I am open for your advice: - On my website (or some other way) we will put a link: employee login - All employee will have they own login and password to access this program - Every employee can have access only to his apartment. Only I will have access to all apartments as administrator - I prefer the similar table like we already use in excell. After the employee stop with online work they need to have availability to safe they work on computer as a beckup - We can give some of employees access (such as housekeeping, owners and employee who is waiting a guests) by other login so they can see a table but they can not change anything. In the box will be one message for housekeeping, other for owners and other for employee who is waiting a guests - If is possible to make a special table where I can see sum of prices (for all apartments) per each employee and second for everybody. Of ourse only I (administrator) can see that table - I need one table where I can see a sum of prices for all apartments together and for each one separately on mountly basis, year and all period from begining untill now. - We have three different commisions that we are calculating from total neto price. Booking (usually 10%), if we are waiting a guest in apartment (usualy addition 5%), and cleaning (usualy addition 15%). So this amount will pay to us a owner for each mounth. I want to monitoring income of each this precentage separately and also a section where I can put a cost of cleaning so I could have and monitor profit of cleaning service - In excel table the box (where we have confirmed transfer) we need availability to mark them so they can be different. So our driver will have access where he can see table with all confirmed transfers and informations for him - This table must be organize for each apartment (if some owner has more apartments they will be in one section) per mounth and per year. I also want to have all informations about apartments per year. If you need some more informations please contact me any time.