Q4 Agent Pipeline Aging: 90-Day Reset

Q4 agent pipeline aging starts with the date a client entered the current stage, then asks what has changed since. A message sent yesterday does not show that a buyer resolved financing or a seller approved a listing plan. Record the client's last substantive action, unresolved constraint, next agreed step, and review date before deciding whether to act, defer, or close the opportunity.

Use the October–December reset to reassess the conversations competing for your time. The worksheet, stage definitions, and review intervals below are editorial planning suggestions, not conversion benchmarks or predictions of closings.

Measure stage age separately from contact activity

For this real estate pipeline audit, keep three dates:

• Stage entry: When the opportunity entered its current stage. Stage age equals the date of your review minus that entry date, measured in elapsed calendar days.
• Last outbound contact: When you most recently sent a message or attempted a call. This measures your activity.
• Last substantive client action: When the client completed something or made a decision relevant to moving forward. Record what happened alongside the date.

Realtor.com's April 13, 2026 email-audit guidance encourages agents to look beyond email opens to replies and conversations. For this worksheet, identify what the conversation established. A friendly reply can leave the next step unresolved.

Define each stage's entry and exit conditions before sorting records by age. For example, a buyer might enter “financing review” when they agree to consult a lender, and leave it when the lender's assessment is available and the buyer agrees on a search budget and next action. For a seller, “listing preparation” might end when the agreed preparation work is complete and the seller authorizes the launch plan.

Keep the entry date unchanged when sending reminders. If a prospect returns to an earlier stage, record that new entry while preserving the previous history. Mark missing dates “unknown” until you can establish them from records; do not substitute the last email date.

Copy the Q4 agent pipeline aging worksheet

Create one record per buying or selling opportunity. Link the records when one client is doing both, so a blocked sale remains visible in the purchase plan.

Hypothetical example: On October 1, a buyer who entered financing review on August 20 has spent 42 days in that stage. The agent emailed September 30, but the buyer's last substantive action was submitting lender-requested documents on September 9. The constraint remains the pending assessment. If the buyer has agreed to request an update October 2 and discuss it October 5, record those actions and review October 5. The recent email does not reset the 42-day stage age.

Record what readiness depends on

For stalled buyer leads, assess readiness for the next relevant step. A buyer can be ready for a lender consultation without being ready to make an offer. Use the constraint field to identify what must happen next.

Financing: capture the remaining question

Ask what the lender has reviewed, what remains outstanding, and when an update is expected. Record the letter's date and any stated conditions or validity period rather than treating “preapproved” as a complete status.

The Consumer Financial Protection Bureau's guidance reviewed December 5, 2023 explains that lenders use “prequalification” and “preapproval” differently and that neither letter guarantees a loan. Specify the next action: the buyer supplies requested information, or the lender clarifies an unresolved condition.

Sale dependency: distinguish a plan from a contract term

Record whether the client needs proceeds from an existing home, where that sale stands, and the event the purchase depends on. Replace “needs to sell” with the current status: being prepared, listed, under contract, or awaiting closing.

The National Association of Realtors' consumer guide to contract contingencies distinguishes a home-sale contingency from a home-close contingency, where a buyer already has a contract offer and needs time to complete that sale. In the worksheet, distinguish the client's intended sequence from an actual signed contingency. Record applicable contract dates separately and have a broker or real estate attorney address contract-specific obligations.

Timing: name the event that changes the plan

Replace “after the holidays” with the client's stated event and an agreed review date. That might be a relocation decision, completion of listing preparation, or a preferred moving window. Label a desired date as a preference unless a documented obligation establishes a deadline.

Decide which conversations stay active

Review the oldest records within each stage, but prioritize overdue agreed actions. A long, client-chosen wait and a missed commitment call for different responses.

Use the evidence in each row to assign a status:

• Active: A concrete next step has been accepted, someone owns it, and it has a date. An unresolved constraint can remain if there is an agreed action to address it.
• Deferred: The client has identified a later window or dependency and there is no immediate agreed work. Record a reactivation trigger and the client's preferred follow-up timing.
• Closed: The client has abandoned this opportunity, completed it elsewhere, or no actionable next step can be established after your documented follow-up process. Record the reason.

When someone stops replying, mark readiness “unconfirmed.” Do not infer that they bought elsewhere. At the review date, move the record out of active work if you still cannot establish a next step. Preserve its history and any contact restrictions. CRM closure is an internal planning decision; handle signed agreements separately.

Review progress after 30, 60, and 90 days

Save an October 1 snapshot before changing statuses. Starting from that date, use these suggested checkpoints; individual commitments and transaction deadlines take priority.

Day 30 — October 31: Check whether agreed actions happened. Separate tasks the agent missed from tasks awaiting the client or another party. Correct missing evidence and unsupported stage labels.

Day 60 — November 30: Revisit recurring constraints. If a review date keeps moving, identify what remains unresolved and whether anyone has agreed to act. Defer opportunities without current work; retain dated history when genuine progress changes a stage.

Day 90 — December 30: Build January's active list from current evidence. Give deferred records a review date or reactivation event. Count the original records that advanced, stayed in stage, were deferred, or closed, and show new opportunities separately. Removing records alone should not count as client progress.

Keep this worksheet with your agent business planning. Once opportunities have been reviewed, translate qualified opportunities into a separate cash forecast, using its assumptions rather than assigning revenue from stage age.