Mortgage Broker Pipeline

Redcedar Home Loans · Mortgage broker · Charlotte, NC

Concetta Ruiz processes loan files for a small mortgage brokerage and uses this to see which files close this month, which conditions are still open, which locks end soon and which referral partners to call. Tracking only; it holds no rates or financial advice.

Real estateSales pipelineLinked tables5 tables · 20 views · 1 form · 7 row actions · 1 agent
Use this template

By status

Loans
Pre-approval2
Adebayo purchaseOluwaseun AdebayoAiyana Redwood
Peacock purchaseRosalind PeacockDesmond Achterberg
Application1
Moreau refinanceCassius and Odette MoreauCormac Bellweather
Processing1
Tanaka new constructionBeatrix TanakaThaddeus Ingram
Underwriting1
Lindqvist purchaseMarisol and Anders LindqvistValentina Brooks-Ndlovu
Clear to close1
Abara cash-out refinanceThelonius AbaraPhilippa Osei
Funded1
Castellano purchaseImelda CastellanoValentina Brooks-Ndlovu
Lost1
Volkov-Hale purchaseDmitri Volkov-HaleAiyana Redwood

Tables

Loans

8 sample rows · 17 columns

Each file from pre-approval to funding, with lock and closing dates.

LoanBorrowerReferred byPurposeLoan typeLoan amountStage
Lindqvist purchaseMarisol and Anders LindqvistValentina Brooks-NdlovuPurchaseConventional$412,000Underwriting
Adebayo purchaseOluwaseun AdebayoAiyana RedwoodPurchaseFHA$286,000Pre-approval
Tanaka new constructionBeatrix TanakaThaddeus IngramPurchaseConventional$545,000Processing
Moreau refinanceCassius and Odette MoreauCormac BellweatherRefinanceConventional$338,000Application
Castellano purchaseImelda CastellanoValentina Brooks-NdlovuPurchaseVA$364,000Funded
Abara cash-out refinanceThelonius AbaraPhilippa OseiCash-out refinanceConventional$295,000Clear to close
Peacock purchaseRosalind PeacockDesmond AchterbergPurchaseJumbo$910,000Pre-approval
Volkov-Hale purchaseDmitri Volkov-HaleAiyana RedwoodPurchaseConventional$378,000Lost

Conditions

10 sample rows · 9 columns

Items underwriting or the processor needs before a file can close.

ConditionLoanKindStatusNeeded byOwnerMark requested
Updated pay stubs - LindqvistLindqvist purchaseIncomeRequestedOct 18, 2026@installer—
Bank statements - LindqvistLindqvist purchaseAssetsOpenOct 14, 2026@installer—
Homeowner insurance binder - LindqvistLindqvist purchaseInsuranceOpenOct 27, 2026——
Appraisal review - TanakaTanaka new constructionPropertyRequestedOct 16, 2026@installer—
Explanation letter - TanakaTanaka new constructionCreditReceivedOct 16, 2026——
Title commitment - AbaraAbara cash-out refinanceTitleOpenOct 17, 2026@installer—
Employment verification - AbaraAbara cash-out refinanceIncomeClearedOct 12, 2026——
Gift letter - AdebayoAdebayo purchaseAssetsOpenNov 1, 2026——
Payoff statement - MoreauMoreau refinanceCreditRequestedOct 22, 2026——
Bank statements - CastellanoCastellano purchaseAssetsClearedAug 29, 2026——

Borrowers

8 sample rows · 8 columns

People and households in the pipeline or past clients.

BorrowerStatusPhoneEmailSourceLoan officerStart loan file
Marisol and Anders LindqvistIn process(704) 555-0141lindqvists@mailbox-demo.netAgent referralGeraldine Fairweather—
Oluwaseun AdebayoPre-approved(704) 555-0142seun.a@mailbox-demo.netWebsiteRavi Subramanian—
Beatrix TanakaIn process(704) 555-0143beatrix.t@mailbox-demo.netBuilderRavi Subramanian—
Cassius and Odette MoreauLead(704) 555-0144moreaus@mailbox-demo.netSocial mediaGeraldine Fairweather—
Imelda CastellanoClosed(704) 555-0145imelda.c@mailbox-demo.netAgent referralGeraldine Fairweather—
Thelonius AbaraIn process(704) 555-0146theo.a@mailbox-demo.netPast clientRavi Subramanian—
Rosalind PeacockLead(704) 555-0147rosalind.p@mailbox-demo.netWebsiteRavi Subramanian—
Dmitri Volkov-HalePast client(704) 555-0148dmitri.vh@mailbox-demo.netPast clientGeraldine Fairweather—

Referral partners

6 sample rows · 9 columns

Agents and advisers who send borrowers.

Referral partnerCompanyKindPhoneEmailLast contactNext touch
Valentina Brooks-NdlovuHarborstone RealtyReal estate agent(704) 555-0131valentina@harborstonerealty.netOct 8, 2026Oct 15, 2026
Desmond AchterbergKeystone Title CounselAttorney(704) 555-0132desmond@keystonetitle.netSep 13, 2026Oct 15, 2026
Aiyana RedwoodLakeview RealtyReal estate agent(704) 555-0133aiyana@lakeviewrealty.netSep 28, 2026Oct 26, 2026
Thaddeus IngramIngram Custom HomesBuilder(704) 555-0134thad@ingramcustomhomes.netSep 3, 2026Oct 8, 2026
Philippa OseiClearwater PlanningFinancial planner(704) 555-0135philippa@clearwaterplanning.netOct 4, 2026Nov 3, 2026
Cormac BellweatherRedbud Realty GroupReal estate agent(704) 555-0136cormac@redbudrealty.netOct 13, 2026Nov 11, 2026

Also included

  • Move to processingRow action
  • Move to underwritingRow action
  • Clear to closeRow action
  • Mark fundedRow action
  • Mark requestedRow action
  • Mark receivedRow action
  • Mark clearedRow action