Commission Tracking Website

Cpanel access to website. Full FTP&MySQL PHP MySQL a must Website where a company can manage their sales team and their Commissions. This is going to be specific to Real Estate Property sales and a 6 tier commission structure. Like pyramid commission. No limit admin configuration screen. Includes building of the website to allow logins and produce the code and databases to make a fully functional website that tracks commissions for a sales team Levels of authority 1. Super admin -Reports all companies, add companies, login to companies a. Company (login &view agents and produce reports can see all agents and reports can add agents and manage them i. Agents ii. ... At company level the admin to that company can login and Add Agents. Agent AgentID -internal First name Last Name MLSID Date added Referred by agent ID -internal ID Username -viewing only own info password Each agent will have a "Referred by" agent. The only non referred by Agent can be the "Company" At company level you would have a Commission Tiers setup. Commission Type Percentage of Sales Or Flat commission on transaction Level 1 - commission on closed Transaction Level 2 ""?-no limit Commission Change Table History -commission table changes :store what it was,who changed to have history of the commission tier Transactions -Track closed transactions Here you would enter a closed transaction Tran ID Entry date Dt of Trans Trans Descrip Sales Agent Trans Amt Commissions Paid ID In Transaction catalog have the ability click Pay commissions would show the Tiers of agents that will be paid and how much :print report showing the summary of who is being paid / print a single page receipt for every agent showing them what they are being paid for and what tier they are being paid. Commission Payment History table -track payment history Trans ID AgentID -internal ID Tier Level Amt Paid Commission Paid Dt Reports Trans rpt Filterable by AgentID , date range and agent name Agent report showing transactions they have been paid on Filterable by date range, trans ID, tier level Agent rpt - Their Teir Agents one page per agent Agent rpt - their info along with how many sub agents they have Reprint of agent receipts Reprint of Commission paid summaries Filterable by date range, agentid, agent name