Mortgage Broker Loan Pipeline Trackers: Use case and AI Confidentiality
The loan pipeline tracker is the spreadsheet a brokerage runs its week from: one row per client file, with the lender, the loan, the stage, the next deadline and a short note. It is exported from the CRM or kept by hand, and brokers upload it to ChatGPT or Claude to ask which files are at risk, to draft the Monday chase list or to forecast commission. One sheet holds every live client at once, and the notes column is where the awkward facts sit: a complaint, a tax debt, a separation, a privacy incident, a declined top-up. This page marks every cell in a routine loan pipeline tracker that the National Consumer Credit Protection Act and the Privacy Act bear on, and shows how the same sheet is worked on Ermos.
The loan pipeline tracker
Updated every day and reviewed at the weekly pipeline meeting. No provision requires a tracker, but it is how a brokerage keeps to dates the law sets: a preliminary assessment must have been made within the 90 days before the broker suggests or assists with an application (section 115(1) of the National Consumer Credit Protection Act 2009). A licensee must also have adequate arrangements and systems to ensure compliance with its general conduct obligations and a written plan that documents them (section 47(1)(k)). An APP entity must take reasonable steps to protect the personal information it holds (APP 11.1).
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Client | Purpose | Lender | Loan ($) | Stage | Key date | Next step | Est. upfront ($) | File note |
| 2 | Whitlock, D & S1 | Purchase, 9 Tarrant Close | Southgate Bank | 868,000 | Pre-approved | Expires 25 Jan 2027 | Contract; Visa closure letter | 5,642 | Complaint upheld in part 4 Nov. Elena to stay copied on every email2 |
| 3 | Pickering, R & N1 | Refinance from Larch | Tamarind Bank | 498,300 | Lodged 12 Nov | Fixed rate ends 30 Nov | Chase valuation | 3,488 | Larch retention offer of 5.94% lapses 20 Nov; clients have not told Larch they are leaving3 |
| 4 | Ottaway, D & G1 | Purchase, 14 Marri Close | Hartwell Credit Union | 724,000 | Documents outstanding | Chased 11 Nov | 2025-26 draft accounts | 4,706 | ATO debt $9,450 on a payment plan; plan letter still to come4 |
| 5 | Prendergast, W & L1 | Purchase, upgrade | Southgate Bank | 655,000 | Documents received 9 Nov | Lodge by 18 Nov | Serviceability | 4,258 | Pack misdirected 9 Nov, clients told 10 Nov. Secure link only, second person checks the recipient5 |
| 6 | Khoury, P & Jacobsen, L1 | First home, 5% Deposit Scheme | Orrin Building Society | 722,000 | Pre-approved 6 Nov | Contract by 4 Feb 2027 | Exchange 20 Nov | 4,332 | Liam on reduced hours until 30 Nov after shoulder surgery; clearance letter due 24 Nov6 |
| 7 | Plunkett, L1 | Investment purchase | Not selected | 410,000 | Fact find booked | 17 Nov, 10am | Credit guide sent | 0 | |
| 8 | Kilpatrick, S1 | Refinance, buy out ex-partner | Orrin Building Society | 385,000 | Conditionally approved | Valuation 18 Nov | Consent orders to lender | 2,310 | Separated in September. Mobile only; do not ring the home number or post anything to the house7 |
| 9 | Jefferies, M & A1 | Construction loan | Hartwell Credit Union | 540,000 | Formally approved | Settles 27 Nov | Builder’s insurance certificate | 3,510 | |
| 10 | Kitto, B1 | Top-up, renovation | Southgate Bank | 95,000 | Declined 5 Nov | Closed | File review | 0 | Declined on servicing. Betting transactions in the statements; he was embarrassed, so no follow-up email8 |
| 11 | Live pipeline (rows 2 to 9) | 4,802,3009 | 8 files | 28,2469 | Upfront is an estimate before any clawback | ||||
| 12 | Rule | Est. upfront = loan x the lender’s upfront rate. Flag any file whose preliminary assessment is more than 75 days old, because it must be within 90 days before the day we recommend or lodge10 |
An invented pipeline tracker as at Friday 13 November 2026. The clients, lenders, loans, commission rates and notes are invented. Hover or tap any highlighted cell for the analysis; the full list is below.
Loan pipeline tracker updater
An Agent+ that keeps the brokerage's pipeline sheet current from the client records and notes. It records each loan's stage, the next action and the date of the last assessment, and prepares a short list of loans to raise at the weekly meeting. Sensitive personal notes stay on the client file and out of the tracker.
What it does
- Reads each client file and its latest notes
- Updates stage, next action and assessment date
- Lists loans to raise at the weekly meeting
What stays with your people. A broker or the operations manager reviews the sheet and the list, and owns every next action. The agent updates the sheet only.
An Agent+ is built once and anyone in the practice can run it. It works from your own documents and runs on Ermos Dominion, the AI unit in your office, or on Ermos Edge, your own instance in an Australian data centre.
What leaves the brokerage
- 1Nine clients on one sheet
Every live client of the brokerage by name, each tied to a lender, a loan amount and a stage. One upload discloses the client list, which is personal information about each household and the most valuable commercial record the brokerage has. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Your whole live client list transmitted in one upload, generally offshore on personal plans Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 2A complaint and how it is being handled
The outcome of a complaint against the brokerage and an internal instruction about supervision. A licensee must have an internal dispute resolution procedure (section 47(1)(h) of the National Consumer Credit Protection Act), and the note is part of that record.
Frontier Models (ChatGPT, Claude) A complaint against you and your handling of it transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 3A retention offer and what the clients have not said
A rate the current lender offered these clients, its expiry and the fact that they have not yet told the lender they are leaving. Negotiating information that belongs to the clients.
Frontier Models (ChatGPT, Claude) The clients’ negotiating position with their lender transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 4A tax debt
A named sole trader’s debt to the ATO and the payment plan. A liability the broker must count when inquiring into the financial situation under section 117, and a fact the client would not tell a stranger. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A named client’s tax debt transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 5A privacy incident
A misdirected document pack, the date the clients were told and the control introduced afterwards. The same incident the brokerage assessed under Part IIIC of the Privacy Act, summarised in a cell. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A privacy incident described to another outside party Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 6Surgery and reduced hours
A named client’s operation and when a clearance letter is due. Health information is sensitive information under section 6(1) of the Privacy Act (section 6FA includes information about an injury and about a health service provided to an individual), and under APP 3.3 an organisation collects it only with consent and where reasonably necessary for its functions, unless an exception applies. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A named client’s surgery transmitted; on consumer tiers it can train future models Ermos Edge Stays on your instance in Australia; check the client’s consent covers health detail, and who on staff can open the sheet Ermos Dominion Stays on the unit; check the client’s consent covers health detail, and who on staff can open the sheet Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 7A separation and a contact restriction
A client’s separation and an instruction about how she may be contacted. A contact restriction of this kind is often there for the client’s safety or privacy, and it sits in a column anyone with the file can read. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A separation and a contact restriction transmitted Ermos Edge Stays on your instance; the contact restriction still depends on every staff member reading the note Ermos Dominion Stays on the unit; the contact restriction still depends on every staff member reading the note Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 8A decline and the reason behind it
A declined application and a remark about betting transactions in a named client’s statements. Gambling is outside the Privacy Act’s closed list of sensitive information, but it is personal information, and few facts about a person travel worse. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A decline and a remark about betting transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 9The pipeline value and the commission forecast
The brokerage’s live loan book and expected upfront income. Commercial information about the business; under section 6DA of the Privacy Act commission income counts toward the annual turnover that decides whether a business is a small business under section 6D.
Frontier Models (ChatGPT, Claude) Your loan book and income forecast transmitted Ermos Edge Stays on your instance; the forecast is still an estimate the director checks Ermos Dominion Stays on the unit; the forecast is still an estimate the director checks Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case - 10The rule
How the estimate is worked out and the reminder about the 90 days. No client data. An uploaded spreadsheet file can also carry hidden tabs such as Settled and Lost, cell comments and file properties, all of which travel with it.
Frontier Models (ChatGPT, Claude) A method and a public time limit with no client data; the file it sits in can carry the Settled and Lost tabs Ermos Edge Nothing client-specific to keep in Ermos Dominion Nothing client-specific to keep in Use case Loan pipeline tracker updater. Updates the pipeline tracker from each client file, showing stage and next action, and flags loans whose assessment date or next step needs attention at the weekly meeting. See the use case
What happens in Frontier Models (ChatGPT, Claude)
- The whole document is transmitted to the provider’s servers. On personal plans the user cannot choose where it is stored or processed, and for the major providers that has generally meant outside Australia, under that country’s legal process. Some business plans offer storage in Australia, but the provider still receives the content.
- On consumer tiers, prompts can be retained and used to train future models.
- The provider’s staff and systems can reach the content under the provider’s own policies.
- Once sent, the brokerage no longer controls it. Retention and deletion happen on the provider’s terms.
The same document on Ermos
Ermos Dominion
The document is drafted on a unit in your office, from your own templates and the client file. Every marked item stays on the unit, which keeps working with the internet switched off. Nothing in it is transmitted to an AI provider, so there is no disclosure to analyse: the confidentiality work is the same as for your file server.
Ermos Edge
Your documents, the index and your access boundaries stay on your own instance in an Australian data centre. When a staff member asks for this draft, only their question and the excerpts they are permitted to see go to a named Australian provider, who is contractually barred from keeping the content or training any model on it. Nothing is processed outside Australia.
| Frontier Models (ChatGPT, Claude) | Ermos Edge | Ermos Dominion | |
|---|---|---|---|
| Where the document is processed | Provider servers, generally offshore on personal plans | Your instance in an Australian data centre; answers generated in Australia | The unit in your office |
| Who can read it | Provider staff and systems, under policy | Your staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothing | Your staff only |
| Is it kept | On the provider’s terms | Kept on your instance; the provider is barred from retaining it | Stays on the unit |
| Can it train a model | On consumer tiers, yes | No, by contract | Only your own unit learns from it, on your hardware |
Part of Use cases in mortgage brokerages. See how this works in practice: Documentation best practice on Ermos.
Common questions
Do ChatGPT and Claude use the information in a loan pipeline tracker?
Is it safe to paste a loan pipeline tracker into ChatGPT or Claude?
Is uploading a loan pipeline tracker to ChatGPT or Claude different from pasting it?
How can a mortgage brokerage use AI for a loan pipeline tracker without sending it to ChatGPT or Claude?
Does the law require a mortgage broker to keep a pipeline tracker?
Is a client list personal information under the Privacy Act?
Does commission income count toward the Privacy Act small business threshold?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo