← All articles

Virtual Assistants & Hiring

Mortgage Pipeline Report: A Weekly Template for Loan Teams

Last updated: November 2026•8 min read•JMV Growth Labs

Illustration of a house beside a mortgage pipeline board with stage columns, task cards and a flag marking a file for attention.

The Weekly Mortgage Pipeline Report: What to Track and Who Owns Each Line

Most loan teams have a pipeline. Fewer have a pipeline report that everyone trusts. The loan system holds the data, but the weekly picture often lives in a loan officer's head or in a spreadsheet nobody has updated since Tuesday. When that happens, aging files and missing items surface late, usually when someone is already waiting.

This guide sets out a simple weekly mortgage pipeline report that works in any loan system, CRM or shared sheet. It covers what to track, how to flag files that are stuck, who owns each line, and how to run a short review meeting around it.

A quick note first: the report is an administrative tool. It shows where files are and what they're waiting on. Decisions about the loan itself, such as what a file needs, pricing, eligibility or approval, stay with your licensed team.

Why Pipeline Visibility Breaks Down

The causes are usually the same:

  • Status is spread across the loan system, email, texts and sticky notes.
  • Each loan officer tracks files their own way, so the team has no shared view.
  • "Days in stage" isn't tracked, so a file can sit for a long time before anyone notices.
  • Outstanding items are listed, but nobody's name is next to them.
  • The report gets rebuilt from scratch every week, so it's late or skipped when the team is busy.

None of this needs a new software tool to fix. It needs one agreed format and one person who keeps it current.

The Columns That Matter

Keep the report short enough that people actually read it. These columns cover most teams:

ColumnWhat goes in it
FileBorrower last name or file ID, per your privacy policy
Loan officerWho owns the relationship
StageYour own stage names, used consistently
Days in stageDays since the file entered its current stage
Outstanding itemsWhat the file is waiting on, in plain words
Waiting onBorrower, third party, lender, or internal team
Next stepThe single next action
OwnerThe person responsible for that next step
Next dateWhen the next step is due or the next follow-up happens
FlagBlank, or the reason this line needs attention

Use your own stage names. A typical sequence might be lead, application, documents in progress, submitted, conditions, clear to close, closed, but the important part is that every file uses the same list, so the report can be sorted and compared.

Keep sensitive borrower details out of the report itself unless your policy allows them. A file ID and a last name are usually enough to find the record in the system.

Flag Aging Files With a Rule, Not a Feeling

"Days in stage" is the most useful column, because it shows what's stuck. Decide in advance how long a file can sit in each stage before it gets flagged. Your licensed team sets these limits based on your own timelines and loan types; there's no universal number.

A simple flag rule might look like this:

  1. Watch: the file is close to your limit for its stage.
  2. Flag: the file has passed the limit.
  3. Urgent: a known deadline on the file is at risk.

Admin applies the rule the same way to every file and writes the reason in the Flag column, for example "waiting on borrower for 2nd follow-up" or "no next step recorded". Admin doesn't decide what to do about the flag. That's what the review meeting is for.

Who Owns Each Line

The report only works if every column has a clear owner.

Admin owns:

  • Updating stage, days in stage and outstanding items from the loan system and the document tracker
  • Recording next steps and dates that the team agreed on
  • Applying the flag rule and noting the reason
  • Sending the report out on the agreed day
  • Chasing outstanding items that are administrative, such as documents, signatures or scheduling, under the follow-up process your team already approved

The licensed team owns:

  • Deciding what a file needs and whether it can move to the next stage
  • Anything about rates, pricing, programs, eligibility, conditions or approval
  • Conversations with borrowers about their loan
  • Deciding what to do with flagged files

If a cell needs a judgment about the loan, admin leaves it for the loan officer rather than guessing.

How to Run the Weekly Review

Keep the meeting short and focused on exceptions. A simple agenda:

  1. Flagged and urgent lines first. For each one, agree the next step, the owner and the date.
  2. Lines with no next step. Every open file should leave the meeting with one.
  3. New files since last week. Confirm the stage and owner are right.
  4. Closed or withdrawn files. Move them off the active list.

Admin takes notes directly in the report during the meeting, so the updated version is ready when the meeting ends. Anything that needs a licensed decision gets assigned to the loan officer in the Owner column, not left in the notes.

Keeping the Report Current Between Meetings

A weekly report goes stale quickly if it's only touched once a week. A light routine helps:

  • Daily: update outstanding items as documents arrive, using your document tracker. If you don't have one yet, see our guide to a mortgage document collection system.
  • Daily: check for next dates that have passed and either complete the step or flag it.
  • Weekly: recalculate days in stage, apply the flag rule and send the report before the review.

Some of this can be automated, for example pulling stage data from your loan system into a sheet. Other parts, such as reading an email from a borrower and updating the outstanding items, still need a person. Our article on splitting work between AI tools and a human assistant covers how to decide which is which.

Where a Dedicated Admin Operator Fits

Once the columns, stages and flag rule are agreed, the weekly cycle is steady administrative work: updating lines, applying the rule, preparing the report and keeping notes in the review. That's a good fit for a dedicated operator, so your loan officers spend the meeting deciding rather than gathering status. It's the kind of pipeline tracking and weekly reporting we provide for mortgage and lending teams, working inside the systems you already use. You can read more about how our virtual assistant support works.

Illustrative Scenario (Generic, Not a Client Example)

This is a made-up example to show how the pieces fit. It doesn't describe any real client or result.

A small brokerage has three loan officers, each tracking files differently. On Monday mornings they spend the first part of the team meeting working out where things stand. They agree one stage list, the columns above and a days-in-stage limit for each stage. An admin updates the report daily from the loan system and the document tracker, applies the flag rule each Friday and sends the report before Monday's meeting. In the meeting, the team goes straight to flagged lines. When a flagged file needs a decision about conditions, the admin assigns it to the loan officer and records the date they agreed.

The point isn't the outcome. It's the structure: one format, one owner for upkeep, a written flag rule and a meeting that turns flags into next steps.

Next Step

If your team spends meetings working out where files stand, book a strategy call. We'll look at how you track your pipeline today and whether a dedicated operator would help. You can also see how we support mortgage brokers, loan officers and lenders.

JMV Delegate™

Delegate the work that is slowing your business down.

Build a more efficient operation with a dedicated virtual assistant and AI-powered systems from JMV Growth Labs.

Frequently Asked Questions

What should a mortgage pipeline report include?
At minimum: the file, the loan officer, the stage, days in stage, outstanding items, the next step, who owns it and when it's due. Add a flag column so files that need attention stand out. Keep it short enough that people read it every week.
How do I track pipeline aging?
Record the date each file enters its current stage and calculate days in stage. Set a limit for each stage based on your own timelines, then flag any file that passes it. Your licensed team should set the limits, since they depend on your loan types and lenders.
Do I need special software for a pipeline report?
Not necessarily. The same columns work in a loan system report, a CRM view or a shared spreadsheet. What matters more is that everyone uses the same stage names and that one person keeps it current.
Can an assistant manage our pipeline report?
An assistant can keep the report updated, apply your flag rule, send it on schedule and take notes in the review. Decisions about the loan, such as conditions, eligibility or what a file needs, stay with your licensed team. Requirements for who can do what vary by state and role, so check with your compliance counsel.

Related articles