Reporting Automation for Mortgage Brokers

Four Numbers Run a Brokerage

Units funded, dollar volume, pull-through, and days from application to funding. Everything else is commentary. Mortgage pipeline reporting that shows the first two and omits the second two is a vanity exercise, because units and volume describe what already happened while pull-through and cycle time describe what is about to.

The reason brokerages get this wrong is that units and volume are easy to pull and the other two require the pipeline to have been maintained honestly. Which is precisely why they are worth more.

Pull-Through Is the Number That Tells the Truth

The loan pull-through rate, measured as funded loans against locked loans or against completed applications, is the closest thing this business has to an honest scoreboard. Everything upstream of it can be gamed by optimism. A pipeline stuffed with applications that will never fund looks identical to a healthy one right up until month end.

What makes the metric useful is segmentation by fallout reason. A file that fell out because the borrower was rate shopping is a lead quality problem. A file that fell out at underwriting is a pre-qualification problem, and somebody should have caught it before the appraisal was paid for. A file that fell out because the appraisal came in low is a market problem you can occasionally fix with a reconsideration of value. A file that fell out because the borrower bought a truck three weeks before closing and wrecked their debt-to-income ratio is an expectation-setting problem that lives in your onboarding sequence. The aggregate loan pull-through rate tells you something is wrong. The reason codes tell you what.

Cycle Time, Broken Down by Where It Actually Goes

A typical residential file runs forty to forty-five days from application to funding, and a brokerage that only measures the total learns nothing it can act on. Segment it: days to submission, days in underwriting, days with conditions open, days from clear-to-close to funding.

Run that report honestly and the conditions-open bucket will be the largest one, usually by a wide margin. That is not a scheduling curiosity. It is the entire operational argument for automating document follow-up, and it is visible only to a brokerage whose reporting is granular enough to show it.

Cost to Originate Against What You Actually Charge

The fully loaded cost to originate a loan runs between $3,822 and $9,000. Broker compensation at 1% to 2% on a $250,000 loan produces $2,500 to $5,000. Those ranges overlap, and any brokerage that has not put both numbers on the same report is operating on faith.

Raising the fee is not available as a strategy. Direct lenders originate at 0.5% to 1.2%, big banks average 0.9% to 1%, and credit unions run 0.5% to 0.7%, so the market has set a ceiling and it is not moving. The levers that remain are cycle time, pull-through, and the number of files a processor can carry without the quality dropping. Every one of those is a reporting problem before it is an operations problem, because you cannot shorten what you have not measured.

Referral Partner Scorecards

Attribution stamped at record creation, never overwritten by a later touch, carried through to funded status. Then rank agents and builders by funded units rather than by referral count, because those lists diverge sharply and the divergence is the whole point.

Bring the scorecard to the partner conversation. An agent who is sending you buyers who cannot qualify is not a bad partner, they are an uninformed one, and showing them the funded rate alongside the reason codes usually changes what they send. Mortgage pipeline reporting that stops at the brokerage's own walls misses the cheapest available improvement in lead quality.

Lock Exposure Belongs on a Report, Not in Someone's Head

Every active lock has an expiration date and an extension cost measured in basis points on the loan amount. A daily report listing locks expiring inside ten business days, sorted by days remaining and annotated with each file's open conditions, converts a category of surprise expense into a category of managed one.

Extensions are the most avoidable cost in the pipeline because the information required to avoid them is already sitting in the loan origination system. It just is not on anybody's screen at the time it would have mattered.

Reports That Arrive Without Being Asked For

The report nobody has to remember to run is the report that changes behavior. Conditions aging every morning at seven, sorted oldest first. Lock expirations every morning alongside it. A weekly pull-through and fallout summary on Monday. A monthly partner scorecard.

Push them into the channel the recipient already lives in rather than a portal they have to log into, because a dashboard that requires a login is a dashboard that gets checked during a good month and ignored during a busy one, which is exactly backwards.

Frequently Asked Questions

What is a healthy pull-through rate for a brokerage?

The number matters less than the trend and the reason codes behind it. What is diagnostic is why the missing files fell out: rate shoppers who never intended to close, denials that should have been caught at pre-qualification, appraisals that came in short, and borrowers who financed a car mid-process and blew up their debt-to-income ratio. Each of those has a different fix, and only one of them is a marketing problem.

Which single report should a broker automate first?

Conditions aging, sorted oldest first, delivered every morning. It is the earliest reliable signal that a file will miss its closing date, it is actionable within minutes, and it costs nothing to act on. Volume dashboards are interesting at month end. Conditions aging changes what somebody does before lunch.

How do I know whether a referral partner is actually worth the coffee?

Count funded units by source, never leads by source. An agent who sends twelve referrals of which two fund is worth less than an agent who sends four of which three fund, and a leaderboard built on lead volume will rank them backwards. Attribution stamped at record creation and carried through to funding is the only way to see it.

Related Reading

The stage data every one of these reports depends on is produced by the machinery described in the funding-day review sequence and, upstream of it, by a clean pipeline. Production numbers explain what the pipeline converted, while rank tracking and reporting explains whether purchase borrowers and refinance shoppers ever found the brokerage in the first place. Advisory firms measure a similarly long conversion cycle against a similarly fixed cost base, which is unpacked in reporting workflows built for financial advisors.