The data model needs to be designed to handle Agents, their Listings and Sellers attached to those Listings, as well as, the Buyers/tenants interested in the Listings. Also, when closings take place, agents bring the commission checks to then the office needs to be record in its ledger and then paid to agents. Relationship between tables must be great!
o Listing date; expiration date; property address, bedroom, bathrooms, status, agent, mls#
o Name, last, cell, email
o Name, last, cell, email, property listed, mailing address
o Same as sellers
o Name, last, cell, email, address, property purchased
o Same as buyers
• Escrow deposit
o Payment from, amount, date, check# property address, agent, date received by office, date deposited, date refunded, ref#
(This table should have a relationship with listings, tenants, buyers or landlords. If the office is holding escrow funds, it should be recorded and noted for what purpose, a sale, lease, etc)
Finances: These tables need to be for the purpose of receiving the commission checks from every closing as well as linking the sales to the escrow account.
• Money in
o Payment from ; date; check#, amount received, agent, property address, closing date
• Money out
o Pay to agent; date; check#, property, gross comm, deductions, net pay
• Sales per agent, per month, year
• Sales closed per month, year
• Listings status: active, sold, under contract
• Commission paid to each agent
• Total commission received per month, year
We will talk about this later once I decide whom to hire, but you get the idea what I am looking for.
Should be easy to use for staff members.
Below is a sample relationships table.