Real Estate Sales Tracking Spreadsheet (Commission Tracker)
Are you looking for a way to track and categorize your real estate sales and commissions? Look no further than today’s post, where I share my real estate sales tracking spreadsheet. In this tool, you can pull gross commission by year, source, lender, agent (if you have a team), look no further!
This spreadsheet is the exact tool that I’ve used to classify my transactions and commissions. It gives me insight into my business and motivates me to be continually improving.
How To Use This Commission Tracker
Downloading my real estate commission tracker is the first step. However, to make sure you get the full benefit from the spreadsheet, continue reading below. I’ll share strategies on how to use this tool best.
The “Backlog” section is where you input all the data from your transactions. If you haven’t been tracking this and you’ve been an agent for many years, I would highly recommend you take the necessary steps to gather the information and input into this spreadsheet. There are not very many things that will provide a higher return on your time than gaining valuable insight into how your business has performed and being able to see at a glance where you are heading.
Regardless of whether you are a team leader, individual agent, or part of a team, you’ll find this real estate sales tracking spreadsheet helpful. Be sure to input your name under the red cell on the right. Inputting your name in this cell will ensure that you classify transactions as “Personal Income.” Any sales marked with a different name under the ‘agent’ column get categorized as “Team Income.”
“GCI” stands for gross commission income.
“COGS” stands for the “cost of goods sold.” COGS is the column where you manually input if there was any deduction to the commission. COGS could be a discount back to the client or a rebate to the team agent that worked the transaction.
There is a couple of example transactions in the spreadsheet.
When filling out the spreadsheet, you’ll need to manually input data into the white cells. The spreadsheet calculates the light green cells for you.
Be sure if the ‘Source’ is a referral to add the referrer to the far right column.
GCI – Year
The “GCI – Year” tab will show you your gross commission income by year, quarter, and month. In addition to this, you can click on the table and select from multiple filters on the right, including type (buyer, seller, rental), agent (if you have various agents), and status (closed or pending).
GCI – Source
The “GCI – Source” tab will show you your income by source. My source data continues to be an eye-opening statistic in my business. Regardless of the money and effort I spent on sources like social media and paid advertisements, I continue to earn over 80% of my business from my sphere of influence and referrals. What is your top source?
Volume – Lender
I created the “Volume – Lender” tab so I can show my lender partner how much business I’ve helped them earn. It’s helpful when you are looking to co-market with a lender and show them your investment return.
I included the “Goals” tab to brain dump any goals that you may want to set for the year. I try and do this before the year starts but find myself in this tab throughout the year, adjusting and adding new goals.
The “P&L Planner” shows me my previous year’s profit and loss and allows me to set goals for the upcoming year. I take my last two years’ numbers and input them into the Actual columns. I then project what I would like to do for each quarter of the upcoming year. These quarters roll up to the total for the entire year.
Be sure to add in your real estate agent salary plus any additional salaries for your real estate business in row 7. Then be sure to add back the salary you pay yourself in row 27.
Adding back your salary and comparing your net income to gross income will help you determine your profit margin. For a single-agent real estate business, I think it’s great to shoot for around an 80% profit margin. I’ve seen a team shoot for anywhere from 25% to 50% profit margin. Note that I wrote, “shoot for.” Many teams fall short of that mark, however.
Business Plan Monthly Tracker
The “Business Plan Monthly Tracker” is your monthly scoreboard. It tracks how well you are doing for units, GCI, expenses, and profit. Be sure to input any numbers manually in white. Green gets calculated automatically. If you beat your projection, it stays green. If you don’t meet your forecast, the over/under cell turns red.
I’ve added a couple of examples in January and February. You can change these when you set your goals.
Regardless of whether you are making a lot or a little money from your real estate business, none of that matters if you can’t save money for the future. Saving money for the future is especially important in real estate, where commission checks are not guaranteed, and the market typically cycles every few years.
Use the “Personal Budget” tab by adding up your yearly expenses and setting goals for the year ahead. Be sure to continually come back and check this to make sure that you are in line with what you projected.
Everyone’s savings is going to be different, but I believe saving 10% of your net income is a good start. Eventually, you’ll want to increase that number over time. As of the time of this writing, I’m aiming for my “Personal Family Budget” to be 50% of my Net Income. This goal leaves 50% to invest in savings.
Personal Net Worth
“Personal Net Worth” is your family’s balance sheet. This balance sheet is where you list out EVERY major asset you own and estimate what its market value is today. As a rule of thumb, I only put in my cars, real estate, investment, checking, and savings accounts.
Also, you are going to list out any liabilities that you have. These liabilities include mortgage loans (both personal and investments), car loans, student loans, credit cards, etc.
Feel free to add rows to this tab as needed. When I pay a liability off or sell off an asset, I zero out the cell for the period I am working on and hide the row, so the table doesn’t get too large. NEVER delete the row because it will affect previous period reporting. I update my net worth quarterly.
I also use this to set goals for what I plan to do to get my net worth up by a specific date. This plan could include paying down debt or increasing assets.
Real Estate Sales Tracker Conclusion
Overall, I hope this real estate sales tracking spreadsheet is helpful for your business. I genuinely believe that if you have this level of clarity in your business and personal finances, you are bound to be a more effective and productive real estate agent.
Let Me Know What You Think
Did I leave anything out of my real estate sales tracking spreadsheet? Are you using something else to track your real estate sales and commissions?
Would You Like To Partner With Me?
I’ve helped hundreds of real estate agents, team leaders, & brokers all over the country increase their sales, online presence, and create scalable systems. I would love the opportunity to work with you. Together, we can make this year your best yet!
Hey Kyle, happy New Year. I’m a nine-year KW agent and have been with EXP for 18 months and love it! I was looking online to see if EXP had a sales tracking spreadsheet and I found your website. However, the tracker doesn’t seem to want to download. Something wrong with the link?
Hey Lois! Thanks for your comment. Are you able to reach the google sheets document? If so, you’ll need to click file -> make a copy OR file -> download to get an editable version.
How can we get the exact sheet as in the video
Hey Kyle, this spreadsheet is exactly what I am looking for! But when I click to download, nothing happens. Are you able to email that to me? I really appreciate it!
Hey Peter, check your promotions or spam folder. You should have received an email from me with a link to the download.
Hey Kyle, how can I access? I submitted my email but have not received anything in my inbox. Thank you!
Just sent you an email Andrew.
I have been waiting to get the gci spreadsheet but it has not come to my email, I keep checking the spam folder and nothing there either.
Hey Angela, Just emailed you a copy manually.
Would you please email me the free spreadsheet Kyle? It would be much appreciated. Please don’t share my email. Thanks!
Breckin, you can download the spreadsheet by clicking the button and filling out your email address. You’ll receive the resource immediately.
I’m also having trouble accessing it. This looks like a fantastic tool to help get me started.
Hi Alex, I’ve tested the resource on my end and everything appears to be working properly. Can you share with me what error you’re receiving? Thanks.
This is exactly what I have been looking for! I downloaded the Google Sheet but the GCI – Year and GCI – Source tabs are empty. The excel shows something there, though. Is there a video or something that teaches me how to make those tabs work? THanks!
Have you input any transactions yet? Those tabs are populated once you add transactions to the report.
Thank you for Real Estate Sale Tracking Spreadsheet video. I wanted to ask you for a copy of your spreadsheet that you use to track all your eXp data. I am with eXp and I find that tracker extremely helpful. Thanks!