blog post

This pipeline report template will help you stay on top of your business and cash flow all year

by on

visibilityDid you meet your income goals for 2019?

Commercial real estate brokerage is an inherently risky industry, and it can be difficult to get transparency into your business when you’re working through complex deals that can take years to close. Sometimes it probably seems like deals can fall through at the drop of a hat.

It might seem difficult to predict when a deal will come through, but the truth is that you can and should track your pipeline. It is possible to better manage the risk involved and get some level of visibility into your cash flow. After all, if you ran a retail store or restaurant franchise and didn’t have any reporting on the business, how long do you think you’d last?

Try this template to keep track of your pipeline

The good news is there are lots of tools out there that provide reporting capabilities. The only bad news is that you’re out of excuses to not track every deal!

You can get as fancy or as simple as you want with it. If you’re opting for simple, try downloading this Excel-based Pipeline Reporting Template, inspired by Blaine Strickland’s tips in Thrive: Ten Prescriptions for Exceptional Performance as a Commercial Real Estate Agent. Once you have all your deals in there, it takes 10-20 minutes a week to update. Give it a look on Sunday night or Monday morning and start the week right.

A few notes on how to use it effectively

At first glance, you’ll notice a few different colors. Every deal should be color coded based on probability to close. You can choose your preference, but you should group deals into three buckets. We break it down this way:

  • Green ≥ 75%
  • Yellow = 51-74%
  • Blue ≤ 50%

This simple system lets you see at a glance where to focus your efforts. Green deals have momentum, so if things are feeling a bit chaotic, focus on what it takes to get those across the finish line. When you have a little more time, ask yourself what you need to do to turn the yellow deals green.

When you’re ready to level up, do this

If you’re ready for fully organized data and a system that puts it to work for you, get a quick demo of Apto today. Our CRM and sales tools give brokers what they need to keep track of their business, better serve clients, and close deals faster.