eXp Realty Agent Attraction Tracking Spreadsheet
Real estate spreadsheets are a significant help when it comes to keeping you organized so you can reach your business goals faster. The one I wanted to share with you in this post is this Agent Attraction Tracking Spreadsheet. This spreadsheet shows how your revenue share business is doing today and forecasts into the future. You'll be able to identify your personal and total organization growth from month to month and year to year.
Whether you are new or experienced with agent attraction at eXp Realty, tracking will help you improve your revenue share business. This spreadsheet will be an easy way to see what's going on in your organization and forecast what to expect in the coming months and years.
*Note: Agent Attraction Tracking Spreadsheet explanation starts at the 18:26 minute mark.
If you're looking for something similar but for your real estate sales business, check out my post on my real estate sales tracking spreadsheet.
Now the next tool that I want to show that somebody else asked me, they said, "Hey, Kyle, I thought you have a spreadsheet or something where you keep your numbers, where you track your numbers?" And yes, I am like a number junkie. And so as far as the numbers go, this is a spreadsheet that I use, because we're not able to show our numbers and all that kind of stuff.
THE AGENT ATTRACTION TRACKING SPREADSHEET I USE
This is just an example. But it's a pretty realistic example I would say, something that you could probably have yours be looking like over a couple of years. But this is just an example as far as what you would look at for revenue share, as far as your numbers go for your organization. But this is the tool that I use to track everything. I've used this tool since I joined the company back in July of '17.
And I'll make this tool available if you guys need it. I'll clear it up and make sure it's, you know, zeroed out, so you can go ahead and download it. I've shown it in the past, but again, I want to do a kind of a recap. Better here than YouTube, on YouTube, it was further ahead.
BETTER THAN THE ROB FLICK WEALTH CHART
So yeah, so as far as what I use to track my numbers, a lot of people will use the Rob Flick wealth chart. So, you've probably seen a video on that. If you haven't, just Google or go to YouTube and search Rob Flick wealth chart, and I'm sure you can figure out how to set that up. But the only problem for the Rob Flick wealth chart is it's a great tool to, you know, keep you organized as far as what you need to do currently, and what your kind of at a glance organization looks like, but the only problem is that historically, it doesn't really kind of show you the full picture, right? Because you don't know. I mean, you put in there the information from today, but you don't remember what it looked like, you know, months ago or whatnot.
And of course, you know, what I would, what I used to do is I would take my wealth chart, and at the end of the month, I'd always just take a picture of it, and I'd save that picture of my wealth chart, but even still, then you just go back, and it doesn't really make a lot of sense.
And so, I created a spreadsheet. And I've seen a few different people that have spreadsheets similar to this.
PROJECT INTO THE FUTURE
But basically, and again, this is just an example one. But what you can do is, you put in here, you know what I've got in here, what your organization looks like. I have projected, I can project into the future, right? Like what it'll be like. That is my motivation. That's what keeps me going.
SETTING IT UP
And then I've got, of course, the actual, like what it was that month, each year. So if you look at it, right, like you've got, you know, you put your first levels, you know, anybody that you've personally sponsored in here, in your first level. And all you got to do is you go to enterprise, and then you click on the big number, like when you have, say, an organization of 15 people, or 30 people, click that number, and it gives you a deep dive into your organization.
And you can put filters in there by what level they are. So then, whenever you get that open, you see your whole organization, you know, filter it, and then where it says what level they're on for you just put level-one, and it'll tell you which, how many agents you have on your level-one. And then type two, so you can see how many level-two agents you have. And that's just what I put in here.
DO THIS MONTHLY
And I do it every single month, at the end of the month. And so, down here, we just ended October for 2019. So, what you would do is you'd go into it and find out what your numbers are for October 2019. And you'd start, you know, putting those numbers in, right? And you do that every single month that you're with the company.
Now, if you're trying to catch up, and you want to, like maybe you've been with the company for a year, and you know, and you want to get started with this, it's going to be a little harder to go back and find your numbers. But you can do it; it just takes a little bit more work. You have to go in and see precisely when the agents' anniversaries dates were, and just kind of like, you know, if you've got a more prominent organization that quickly grew, you didn't do this from the beginning, it's going to be a lot harder. But if you have a smaller organization, you can usually kind of piece it out and figure out; you know how to catch up. And then at that point, you know, stay consistent with it every month.
And so, what I do as far as the projected numbers, is I only put what my projected numbers are for my front line. And then for my entire organization, that's all that I due for projected, because it's so hard to plan, you know how big your second, third and fourth level is going to grow relative to each other. So I project out what I, you know, want my frontline to be, what I wish to my total to be.
And when I make the projections, it's not just like a guess or anything like that; I'm taking a percentage based on the numbers that I had seen in the past. So, for instance, you know, I use a 7% growth number. That's kind of what my organization has seen. Right? So you can see here, I just projected out 7%.
I think what I've done with this spreadsheet, and you may even, you know, want to change it, is you can change the numbers based on, the years and all that. I think I go up to an 8% growth rate at one point here. And you can play around with that you can put, you know, six and a half percent. All you're doing is, if you look up here in the function like when you come down here, you might change see like 1.08, that's 8%. If you wanted to do six and a half and be more conservative, you could come in here, like when I went from seven; you could go in there and say, you know, oh six, five,
right? Just say Enter.
And then you can draw that out over to the end there. You can see, and it changes everything, right? So that's kind of how that works there. But I'm going to go back, edit that out.
KEEPING UP WITH REV SHARE
And then what I've also got in here is showing me how much revenue share is going to be paid out that month. And so you can see, like, let's use 2019, for example. In this example, it shows here that you know, rev share this month might have been 5400 bucks, and that's the month you get paid in it. So like in October, let's say your rev share for this month, which is yet to be paid. We get paid on the 22nd each month. So, this is just what's showing in your dashboard. You haven't gotten paid this yet. But whatever this is, you'd put that in there as for that month. And then below that is kind of a running total for what you've made so far for the year, right? So it rolls up, and you can see there what you've made for the year. And then on the very bottom is an all-time revenue share. So that rolls up, rolls up, rolls up just like that. So, it's a straightforward kind of spreadsheet to keep up with. Very simple to sort of keep track of it.
And down here as far as the actuals, that's where I put in, you know, everything that's on my first line, second line, third line, fourth line, fifth line, sixth line, seventh line. So, you can see all of that inside of here.
SEE YOUR PROGRESS
And you do that at the end of the month, each month. And then eventually, you can see how your organization is growing, like, which level is growing the fastest, you know, third, fourth level, second level. What is it, right?
USE IT YOURSELF
So, but anyway, I'll make this available to you guys. I'll go ahead and you know, clear out this example and just, you know, share that with you guys. You can put your numbers in it. If you've got any questions, feel free to put that into the comments. And we'll go from there.