Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can I See My Mortgage Brokerage's Pipeline, Expected Completions and Income in One Place?
Problems We Solve

How Can I See My Mortgage Brokerage's Pipeline, Expected Completions and Income in One Place?

Mortgage brokerage owners build spreadsheets to see cases by stage, expected completions and proc fee income. We build a live pipeline and forecast view.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Owners of mortgage brokerages want to know how many cases are at each stage, which will complete this month, what fees are expected and which brokers are stretched. The CRM holds the data but not in a form that answers those questions quickly. We build a pipeline view from your CRM and case tracking: cases by stage and age, expected completions, expected proc fees and client fees, and broker workload, with definitions you agree once.

Monday meeting, and the numbers do not agree

The owner asks each broker for their pipeline. One lists cases on a whiteboard. Another exports from the CRM and filters by hand. A third says "about fifteen, a few should complete this month". The owner adds it up in a spreadsheet, adjusts for the ones that always slip, and makes a guess at the month's income.

At month end, the actual figure is different, sometimes by a lot. Cases thought to be completing were waiting on a chain. Others completed that nobody had marked as close. Planning, whether for hiring or cash flow, is built on sand.

Why the pipeline is hard to see

The CRM knows about cases, but only as well as it is updated. Stages are recorded differently by different brokers, and some cases stay "submitted" for weeks after an offer is issued because nobody changed the status. Completion dates depend on conveyancers, and the CRM rarely has the latest.

Income is spread too: proc fees from lenders, client fees, protection commission. Forecasting it means combining CRM stages with fee expectations, which is spreadsheet work.

  • Case stages updated inconsistently.
  • Completion dates not current in the CRM.
  • Proc fees, client fees and protection income tracked separately.
  • Each broker reports their pipeline differently.
  • No agreed definition of what counts as likely to complete.

Self-employed brokers working within a brokerage may keep their own lists, and some cases never make it into the CRM until late. The owner's picture is only as complete as the least organised broker's records.

What an unclear pipeline costs

DecisionMade on
Whether to hire another brokerA guess at future workload
Cash flow for the coming monthsOptimistic spreadsheet figures
Which broker needs supportWho complains loudest
Where new leads should goRota rather than capacity

Brokerages are sensitive to timing: cases can slip a month because of a chain, and income moves with them. A pipeline view that reflects real case status is what lets an owner plan rather than react.

The pipeline view we build

  1. We agree a set of stages and definitions with you, such as enquiry, fact find, DIP, submitted, offered, exchanged, completed, and what moves a case between them.
  2. Stages are taken from your CRM and, where available, updated automatically from lender and conveyancer milestones, so they are less dependent on manual updates.
  3. Each case carries its expected fees: proc fee, client fee and protection where relevant, based on rates your team maintains.
  4. The view shows cases by stage and age, by broker, with expected completions by month.
  5. Expected income by month is calculated from cases at each stage, and compared with what actually completed.
  6. Cases that have been at one stage too long are flagged, which often shows which cases are slipping before anyone mentions it.

What the owner gets

The Monday meeting starts from the same screen for everyone. Expected completions reflect actual case progress. The comparison between expected and actual improves over time, because the brokerage learns how its own cases behave. And broker workload is visible, which helps with lead allocation and hiring decisions.

Brokers can see their own pipeline in the same view, which saves them building their own lists.

It also changes conversations with brokers. Instead of asking for a list, the owner can look at a broker's cases that have sat at one stage for weeks and ask what is holding them up, which is a more useful conversation for both of them.

Is this how you see your pipeline?

  • Pipeline figures come from asking each broker.
  • Expected completions often turn out wrong.
  • Income forecasts are built in a spreadsheet.
  • Case stages in the CRM are frequently out of date.
  • You cannot see which broker is overloaded.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does this need a new CRM?

No. It reads from your existing CRM and case tracking. If data is missing, we show where.

How accurate will the forecast be?

It depends on how current your case data is. The view shows expected against actual so you can see how reliable it is and improve it.

Can brokers see each other's pipelines?

Only if you choose. Access can be set per person.

What affects the cost?

Your CRM, how many data sources feed the view and how detailed the income forecasting needs to be.

Keep reading

More on Problems We Solve

Start here

Tell us where your mortgage cases get stuck

Describe how a case moves from enquiry to completion today, the CRM and sourcing tools you use and where it stalls. We will tell you what we would build. Advice and lending decisions stay with you and the lender, and if a smaller change would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →