Hi, I attached three sample excel spread sheets with most of the formulas for you to copy and customize this excel spread sheet.
This is a Real Estate office accounting spreadsheet for;
*Inputting what property was sold or leased and for how much along with linking which agent closed the deal.
*Computing commissions for agents and agency. 90%/10% commission split.
*Automatically calculating a tier commission profit sharing of 2% (a recruiter get 2% of all the commission from the agents he or she recruited) so the recruited need to be linked to their recruiter so the recruiter will automatically show 2% revenue along with the 8% for the broker and 90% for the recruited when the recruited makes a sale.
*Calculating all monthly expenses (list will be provided)
*Generate Annual Reports for each agent at any day.
*Show breakdown of annual property sales/leases
I have 7 agents now, 2 of them have each recruited one, I need to be able to add other agents and the (recruiter/recruited link) and all the data that goes along with it and do the calculation again.
I also have about 10 property listings and need to be able to add and remove and link the properties with their selling agents.
You can use VB or you can use nested formulas, either way is fine with me. It doesn't need to be elaborate, it just needs to work.
Let me know if you have any questions! Thanks.
34 freelancers are bidding on average $44 for this job
We have served our clients across the world. We are very professional and flexible in our approach. Accuracy of work is 100% guaranteed and we ensure that you will be satisfied with our work. Please see pmb:)
Hello Sir, We can do this just give a chance we will surely full fill ur need. We just need some review to grow up. :) I am ready to start the project now. Thanks, Regrads, Twins Technologies.
Well u can trustedly give me this work.i assure u that i can make the difference. for further information u can contact me at: shamoon555 at [url removed, login to view] or u can call me at 92-333-4712662 [url removed, login to view] Bhatti