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).

fx=SUM(H2:H9)
ABCDEFGHI
1ClientPurposeLenderLoan ($)StageKey dateNext stepEst. upfront ($)File note
2Purchase, 9 Tarrant CloseSouthgate Bank868,000Pre-approvedExpires 25 Jan 2027Contract; Visa closure letter5,642
3Refinance from LarchTamarind Bank498,300Lodged 12 NovFixed rate ends 30 NovChase valuation3,488
4Purchase, 14 Marri CloseHartwell Credit Union724,000Documents outstandingChased 11 Nov2025-26 draft accounts4,706
5Purchase, upgradeSouthgate Bank655,000Documents received 9 NovLodge by 18 NovServiceability4,258
6First home, 5% Deposit SchemeOrrin Building Society722,000Pre-approved 6 NovContract by 4 Feb 2027Exchange 20 Nov4,332
7Investment purchaseNot selected410,000Fact find booked17 Nov, 10amCredit guide sent0
8Refinance, buy out ex-partnerOrrin Building Society385,000Conditionally approvedValuation 18 NovConsent orders to lender2,310
9Construction loanHartwell Credit Union540,000Formally approvedSettles 27 NovBuilder’s insurance certificate3,510
10Top-up, renovationSouthgate Bank95,000Declined 5 NovClosedFile review0
11Live pipeline (rows 2 to 9)8 filesUpfront is an estimate before any clawback
12Rule
PipelineSettledLost

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

  1. Reads each client file and its latest notes
  2. Updates stage, next action and assessment date
  3. 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

  1. 1
    Nine 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.

  2. 2
    A 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.

  3. 3
    A 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.

  4. 4
    A 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.

  5. 5
    A 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.

  6. 6
    Surgery 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.

  7. 7
    A 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.

  8. 8
    A 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.

  9. 9
    The 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.

  10. 10
    The 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.

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 EdgeErmos Dominion
Where the document is processedProvider servers, generally offshore on personal plansYour instance in an Australian data centre; answers generated in AustraliaThe unit in your office
Who can read itProvider staff and systems, under policyYour staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothingYour staff only
Is it keptOn the provider’s termsKept on your instance; the provider is barred from retaining itStays on the unit
Can it train a modelOn consumer tiers, yesNo, by contractOnly 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?
Whatever is uploaded or pasted from the tracker goes to the AI company's servers and is processed there to produce a reply. As at October 2026, whether a conversation on a personal plan (ChatGPT Free, Plus or Pro; Claude Free, Pro or Max) can be used to train the models depends on a setting each user controls. Business plans (ChatGPT Business and Enterprise, Claude Team and Enterprise) and the developer APIs sit under commercial terms, and OpenAI and Anthropic each say they do not train on that content by default (OpenAI, Anthropic). On either product, the thumbs up and thumbs down buttons can send a whole conversation back for training. One sheet names nine clients and carries a $9,450 ATO debt, a client's shoulder surgery and a declined top-up with betting transactions in the statements.
Is it safe to paste a loan pipeline tracker into ChatGPT or Claude?
No, because one paste hands over the brokerage's whole live client list together with the notes column. The Office of the Australian Information Commissioner (OAIC) recommends in its guidance on commercially available AI products that organisations do not enter personal information, and particularly sensitive information, into publicly available generative AI tools, because of the significant and complex privacy risks. Deleting the client column still leaves 9 Tarrant Close, 14 Marri Close, a separation in September with a contact restriction and a misdirected document pack. Removing names rarely makes a document anonymous. Information stays personal information while the person is reasonably identifiable, and the OAIC warns that information can be at risk of re-identification even when it has been de-identified or anonymised. The list is also the brokerage's most valuable commercial record, and its notes include a complaint upheld in part.
Is uploading a loan pipeline tracker to ChatGPT or Claude different from pasting it?
Yes, because an uploaded tracker leaves the brokerage as a whole file. A spreadsheet can carry other sheets, hidden columns, comments, tracked changes and file properties as well as the rows on screen. The OAIC's guidance also tells organisations to review carefully the terms and settings that will apply to their use of any AI product. A question about one file at risk would send all nine rows, the Settled and Lost tabs and the formula behind the $28,246 commission forecast.
How can a mortgage brokerage use AI for a loan pipeline tracker without sending it to ChatGPT or Claude?
Ermos is built so the document stays under your control. On the Dominion AI unit it is drafted inside your office and none of it is sent to an AI provider. On Ermos Edge your documents and index stay on your own instance in an Australian data centre, and only the question and the excerpts the user is permitted to see go to a named Australian provider that is contractually barred from keeping them or training any model on them. The chase list and the commission forecast are produced from the brokerage's own pipeline records. The broker checks every key date, including the age of each preliminary assessment, and the director checks the forecast before anyone relies on it.
Does the law require a mortgage broker to keep a pipeline tracker?
No provision names one. Section 47(1) of the National Consumer Credit Protection Act requires a licensee to comply with the credit legislation, to have adequate arrangements and systems to ensure compliance with its general conduct obligations with a written plan that documents them, and, unless regulated by APRA, to have adequate risk management systems. A tracker is one common way a brokerage keeps to statutory dates such as the 90 days in section 115.
Is a client list personal information under the Privacy Act?
A list that names individuals and ties each to a loan is information about identified individuals, so it is personal information. An APP entity that holds it must take reasonable steps to protect it from misuse, interference and loss and from unauthorised access, modification or disclosure under APP 11.1, and under APP 11.2 must take reasonable steps to destroy or de-identify information it no longer needs for a permitted purpose, unless a law requires it to be kept.
Does commission income count toward the Privacy Act small business threshold?
Yes. Section 6DA lists commission income among the amounts that make up a business's annual turnover. Under section 6D a business is a small business if its annual turnover for the previous financial year was $3,000,000 or less, and a small business operator is generally outside the Act unless an exception in section 6D(4) applies, such as disclosing personal information about another individual for a benefit, service or advantage without consent.

See Dominion answering from your own documents.

A demonstration takes 30 minutes, uses no client data, and comes with no obligation.

Book a demo