The Problem
An active mortgage broker has 15 to 30 applications open at any given time, spread across five to ten lenders. Each lender has its own portal, its own email format, its own timeline. Bank lenders take three to seven days. Non bank lenders respond in one to three. Specialist lenders can take two weeks. And none of them talk to each other.
So the tracking system becomes your memory. Or a spreadsheet you update when you remember. Or a colour coded inbox with 400 unread messages.
That works until it doesn't. One application sits unactioned for six days at a lender with a three day turnaround. Turns out a document was missing. Nobody flagged it. The client calls asking for an update, and you're scrambling to figure out what happened. A single dropped residential loan is $3,000 to $5,000 in lost commission. Do that twice a quarter and you've lost $20,000 to $40,000 a year because you forgot to check a portal.
The mortgage specific CRMs and loan origination platforms promise to fix this, but most of them only track what goes through their system. Applications submitted directly through lender portals? Those are still on you. And the platforms that do try to aggregate everything cost $100 to $500 per user per month, which is hard to justify for a two person brokerage.
How It Works
The tracker creates a single source of truth for every application you submit, regardless of which lender or portal you used. Here's the step by step.
1. Log the submission
When you submit an application to a lender, the workflow creates a tracking record in your database (such as Airtable or your existing CRM). Each record captures the client name, lender, loan product, amount, and submission date. Status is set to "submitted" automatically. If you submit to four lenders for one client, that's four records, all linked to the same deal.
2. Monitor for lender responses
The automation watches your email inbox for notifications from each lender. Using sender addresses and subject line patterns, it identifies which emails are application decisions versus marketing or general correspondence. Where lender APIs are available, it polls those directly for status changes.
3. Parse the outcome
When a lender notification arrives, the workflow extracts the decision: approved, declined, conditional approval, or more information required. Different lenders use different terminology ("approval in principle" versus "conditional approval" versus "indicative approval"), so the parser is configured to recognise each lender's language and normalise it into a consistent status.
4. Update the tracker
The parsed result updates the corresponding record in your database. Timestamps, decision details, and any conditions are captured automatically. Your dashboard refreshes in real time, giving you a single view of every pending application across every lender.
5. Escalate stale applications
A scheduled check runs every few hours. Any application that has been sitting without a status change for more than 48 hours triggers an alert to you via Slack, SMS, or email. The alert includes the client name, lender, days since submission, and expected turnaround for that lender type.
6. Notify on approvals
When an application is approved, the workflow sends you a task to review conditions. Optionally, it sends the client a notification that good news is in. If multiple approvals come in for the same deal, you get a side by side comparison of rates, fees, and features so you can advise your client quickly.
Why Spreadsheets Break at Scale
Three active deals across three lenders each is nine applications to track. Most brokers can hold that in their head. But a busy month pushes you to ten active deals. Suddenly you're juggling 30 applications across eight or nine lenders, and the spreadsheet that "works fine" starts to crack.
The failure mode is always the same. It's not the application that gets declined (you'll hear about that). It's the one that goes quiet. The lender is waiting on a document you didn't realise was missing. Or the application landed in a queue behind a processing backlog. There's no notification because nothing happened. And nothing will happen until you chase it.
A broker gets an automated alert on day six: an application to a lender with a typical three day turnaround has had no movement. She calls the lender. The application was stuck because a payslip was illegible. She resends it within the hour. Without that alert, the client would have waited another week, growing more anxious with every passing day.
That's the gap no spreadsheet fills. A spreadsheet records what you tell it. It doesn't know that six days is unusual for that lender. It doesn't flag silence. An automated tracker does both.
What About Mortgage CRM Platforms?
Platforms like Oscar CRM, Creatio, and Salestrekker all position multi lender tracking as a core feature. And they do it well, within their own walls. The catch is that they only track applications routed through their system.
In practice, brokers still submit directly through lender portals. Sometimes because the CRM integration with that lender doesn't exist. Sometimes because it's faster. Sometimes out of habit. Those applications live outside the CRM's visibility, and that's exactly where deals get lost.
A purpose built tracker sits alongside your existing tools rather than replacing them. It doesn't care whether the application went through a CRM, a lender portal, or a manual submission. It watches for the outcome and keeps your dashboard current regardless of source. And at $30 to $50 a month for an Airtable plus automation setup, it costs a fraction of a full mortgage CRM.
The Business Impact
Take a broker handling 15 active deals at any time, submitting to an average of four lenders per deal. That's 60 live applications. Manually checking portals and scanning emails for updates takes roughly 45 minutes a day. With an automated tracker, that drops to five minutes reviewing the dashboard each morning.
That's over three hours reclaimed per week. At a broker's effective hourly rate of $150 (based on average commission earnings), that's $450 a week or $23,400 a year in recovered productive time. Time you can spend on client conversations, referral relationships, or simply not working evenings.
But the bigger number is loss prevention. If automated escalation catches just two dropped applications per quarter that would have otherwise gone cold, that's $6,000 to $10,000 in saved commission. Over a year, $24,000 to $40,000. For a two person brokerage, the maths is hard to argue with.
- 40 minutes saved daily on manual portal checks and email scanning
- Single dashboard view across all lenders, updated automatically
- 48 hour escalation alerts catch stale applications before clients notice
- $24,000 to $40,000 in annual commission protected from dropped deals
- Automatic approval comparison when multiple lenders approve the same deal
- Full audit trail of every application status change for compliance records
Frequently Asked Questions
What tools does this integrate with?
The tracker is built on tools like Airtable (or your existing CRM) combined with an automation platform such as Make or n8n. It connects to Gmail or Outlook for email monitoring, and can integrate with lender APIs where they're available. If you already use a mortgage CRM like Salestrekker or MyCRM, the tracker works alongside it to catch applications submitted outside that system.
What happens when a lender changes their email format?
This is a real risk. Lender notification emails change without warning, and a parsing rule that worked yesterday can break today. The system is designed with fallback logic: if an email from a known lender doesn't match any expected pattern, it flags it for manual review rather than silently ignoring it. Updating a parsing rule for a new format typically takes 10 to 15 minutes.
Can it handle conditional approvals with multiple conditions to track?
Yes. When a conditional approval is parsed, the system creates sub tasks for each condition (such as "provide updated payslip" or "obtain valuation"). Each condition is tracked independently, and the application status only moves to "fully approved" when all conditions are marked complete.
Do I really need this if I only submit to two or three lenders per deal?
Multiply those two or three lenders by your active deal count. At 10 active deals, you're tracking 20 to 30 applications. The value isn't in tracking a single deal across a few lenders. It's in making sure nothing slips when you're managing a full pipeline across a busy month. One saved deal pays for the entire setup many times over.
Is client data secure in this setup?
Airtable and major CRM platforms offer encryption at rest and in transit. The email parsing only extracts status information (approved, declined, conditions), not sensitive financial data. You control access permissions, and all data stays within your existing tool accounts. For brokerages with strict compliance requirements, the tracker also provides a complete audit trail of every status change.
How long does this take to set up?
A basic version with manual submission logging and 48 hour escalation alerts can be running within a day. Adding email parsing for your most common lenders takes another two to three days of configuration and testing. Most brokers start with the simple version and layer on email parsing over time. Want to see what this would look like for your brokerage? Book your free audit and we'll map it out together.
Sources
Automations we’ve already built
Thirty days after onboarding begins, an automated workflow surveys your client, pulls milestone data from your project tools, generates an AI written retrospective, and flags anyone who needs a recovery call. Every onboarding teaches the next one.
When a new client lands in your practice management software, this automation generates a tailored engagement letter with the right services, fees, and deadlines, sends it for electronic signature, then builds the client folder and kicks off your onboarding checklist. No chasing. No waiting.
A project manager fills out a short form after a discovery call. Within minutes, AI drafts a full Statement of Work into your branded template, routes it through Slack for internal approval, and sends it to the client for signature.
When a project closes in your PM tool, this automation collects every contract, deliverable, and sign off from across your systems, organises them into a standardised archive folder, and generates a summary PDF. No manual cleanup required.
When a contact is tagged in your CRM as needing an NDA, the agreement is generated from a template with their details prefilled, sent for signature, and tracked automatically. Overdue NDAs trigger reminders so nothing slips through.
Automatically converts raw meeting notes or recordings into structured, branded board minutes with tracked resolutions and action items, so your admin staff can stop spending full days on documentation that nobody reads until it's too late.
Capture scope changes on site, generate costed PDFs, route them through internal approval and client e signature, and log everything automatically. No verbal agreements, no lost paperwork, no payment disputes.
When a new contract lands in your cloud folder, an AI agent extracts the text, checks every clause against a risk framework, and sends your team a structured memo flagging the problems that actually matter. Preliminary review drops from hours to minutes.
When a new contractor lands in your HR system or Airtable base, this automation generates a complete document bundle, sends it as a single signing package through PandaDoc, and updates your records the moment everything is signed.
When a deal hits the proposal stage in your CRM, this automation pulls the client name, scope, pricing, and line items, then merges everything into a branded template. The finished PDF lands back on the deal record and in the prospect's inbox without anyone touching a document.
When every party signs a document in DocuSign or PandaDoc, this automation downloads the completed PDF, renames it to your filing convention, stores it in the right client folder, and notifies the account manager. No manual downloading, no misfiled contracts.
A scheduled workflow scans your contracts database daily, flags renewals at 30, 14, and 7 day intervals, and sends tiered alerts to account managers and leadership so nothing expires unnoticed.
When a new client is created in your CRM, this automation builds their billing profile, generates the first invoice, sets up recurring payments, and sends a secure link to collect their payment method. No manual data entry between systems, no forgotten first invoices.
When a project is marked complete in your project management tool, this automation pulls billable hours and rates, generates a branded PDF invoice, and emails it to the client with payment instructions. A copy lands in the client folder without anyone lifting a finger.
When a new patient books an appointment, this automation sends digital intake forms, collects consent and insurance details, converts everything to PDF, files it in the patient folder, and notifies your front desk. No clipboards. No data entry.
An AI agent that turns your meeting recordings into structured summaries, assigned action items, and tracked tasks across Slack, Asana, and Notion. No more post meeting admin, no more forgotten decisions.
An automated workflow pulls client KPIs from your data sources on the first business day of each month, populates branded report templates, converts them to PDF, and emails every client their personalised report before your team starts work.
Automatically classify incoming contracts by type, route each one to the right reviewer, and track every document through the review pipeline so nothing stalls in someone's inbox.
When a new B2B client submits their intake form, this automation reads every team member's role and sends each person the exact onboarding content they need. Billing contacts get payment setup. Project sponsors get the timeline. Day to day operators get tool access and kickoff details. Every stakeholder's progress is tracked independently until all are ready.
When a new client record lands in your CRM with a signed engagement letter, a prefilled contract is automatically generated and sent for e signature. No copying, no delays, no forgotten clauses.
When a prospect opens your proposal, this automation logs the view in your CRM, pings the assigned salesperson on Slack, and sends a templated follow up email if the document stays unsigned after 48 hours.
When a real estate agent fills out a short form with property details and buyer information, the automation generates a complete contract of sale, attaches the correct disclosure forms, and sends the full package to DocuSign with the right signing order.
Automatically converts approved quotes into signed service contracts with warranty terms, payment schedules, and scope definitions. No manual paperwork, no verbal agreements, no disputes three months later.
When a vendor sends a contract, AI extracts payment terms, liability caps, termination clauses and auto renewal dates into a structured row. Your procurement team can then compare every vendor agreement side by side, spotting bad deals before anyone signs.
Not ready to talk yet? Start here.
Everything we've learned building 300+ automations for small businesses, in one practical guide. Written for business owners, not engineers.
- Where your team's hours are actually disappearing
- The five automations worth setting up first and why
- How to calculate what manual work is actually costing you
- A step by step checklist to get your first automation live this week
Completely free.