Mortgage Broker Refinance Comparison Spreadsheets: Use case and AI Confidentiality

A refinance comparison sheet sets the clients’ current loan against the alternatives: each rate, the fees, any cashback, what the brokerage is paid and the cost over five years. Brokers paste it or upload the file to ChatGPT or Claude to check the arithmetic, to rank the options and to draft the explanation for the clients. The sheet carries the clients’ names and balance, a retention offer their own lender gave only to them, and the brokerage’s commission on every option. This page marks every cell in a routine refinance comparison that the National Consumer Credit Protection Act and the Privacy Act bear on, and shows how the same sheet is checked on Ermos inside the brokerage.

The refinance comparison spreadsheet

Built when a fixed rate is about to end or a better rate is advertised, and kept on the file with the recommendation. A licensee that suggests a consumer apply for a loan, or remain in their current one, must first give a quote the consumer has accepted (section 114), unless regulation 28C, applied through regulation 28M and Schedule 4 to the Regulations, excuses the quote because it charges consumers no fee and says so as that regulation sets out, have made the inquiries and a preliminary assessment within the previous 90 days (sections 115 to 117) and give a credit proposal disclosure document, at the same time as the assistance, with its estimates of fees and indirect remuneration (section 121). ASIC’s Report 840 of 13 October 2026 reviewed how licensees show that a recommended loan is in the consumer’s best interests when another loan costs less.

fx=D4+E4+F4-G4
ABCDEFGHIJ
1OptionRate p.a.Repayment / monthInterest, 60 monthsFees, 5 yearsSwitching costsCashback5-year costGap to lowestBrokerage upfront
2Larch Credit Union: stay, 6.34%3,505148,9080000
3Larch Credit Union: retention offer (phoned 10 Nov, valid to 20 Nov)3,386139,1100000
4Tamarind Bank5.74%3,328134,22708550
5Southgate Bank5.89%3,371137,8881,975855
6Orrin Building Society5.99%3,401140,3331,7508550
7Clients and loan
8Recommended
9Conflict check
10Method
RefinanceOffersNotes

An invented refinance comparison. The clients, lenders, rates, offers and fees are invented. Hover or tap any highlighted cell for the analysis; the full list is below.

Refinance comparison builder

An Agent+ that sets up the switching comparison for a refinance from the current loan statement and the offers the broker has gathered. It calculates the cost of each option across the period you choose, shows what the brokerage earns on each beside the client's cost, and flags any lower-cost option so the broker can record why it was or was not chosen.

What it does

  1. Reads the current loan statement and the offers gathered
  2. Builds the cost grid across the chosen period
  3. Flags lower-cost options the broker must address in the file

What stays with your people. A broker checks the sums, makes the recommendation and records the reasons. The agent lays out the options 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
    The clients

    Two named people on a sheet that also carries their balance and term. The key that ties every figure to a household. Privacy Act guide.

  2. 2
    The current loan and when the fixed rate ends

    The lender, the fixed rate and the day it reverts. A suggestion that the consumer remain in a particular credit contract needs a preliminary assessment under sections 115(2) and 116(2) and, unless regulation 28C, applied through regulation 28M and Schedule 4 to the Regulations, excuses the quote because the brokerage charges no fee and says so as that regulation sets out, an accepted quote under section 114(1)(c), so this row is part of the broker’s own assessment of staying. Privacy Act guide.

  3. 3
    A retention offer made to these clients only

    A discounted rate the lender offered by phone, with an expiry date. Not published, so it is commercial information about the lender’s relationship with these clients, and the lender would expect it to stay between the lender, the broker and the clients.

  4. 4
    The cashback and its conditions

    A promotion and the condition that repays it. ASIC’s Report 840 says licensees should make sure their systems capture lender discounts, promotional offers and cashbacks accurately, and found that systems did not always pick them up without the broker entering them by hand.

  5. 5
    What the brokerage earns on each option

    Upfront commission by lender. Commercial information about the brokerage, and the evidence for the conflict check: a licensee that is a mortgage broker and knows or ought to know of a conflict must give priority to the consumer’s interests (section 158LB, and 158LF for a credit representative). Section 121(2)(b) requires a reasonable estimate of the indirect remuneration in the credit proposal disclosure document.

  6. 6
    The five-year cost and the gap to the lowest

    The sum the recommendation rests on. Report 840 says licensees should expect brokers to give additional evidence when recommending a loan that costs more than other available options, and that the greater the extra cost, the greater the risk the broker cannot show the consumer will get more value from it. A figure a tool has recomputed is only as good as the inputs, so the broker checks every total.

  7. 7
    The balance and the remaining term

    The amount owed, the months left and what the clients want from the loan. The financial situation and objectives the broker must inquire into under section 117, written in one cell. Privacy Act guide.

  8. 8
    The recommendation and the clients’ reaction

    The broker’s conclusion and a remark about the clients’ comfort. The decision the clients are paying the broker to reach, and the heart of the record of why this loan.

  9. 9
    The conflict check

    A statement about the brokerage’s own pay and why it did not drive the advice. Whether a conflict exists is the licensee’s judgment under section 158LB, and the conclusion is only as good as the figures above it.

  10. 10
    The method

    A standard repayment formula and the cost definition. No client figures. Spreadsheet files can also carry hidden sheets and columns, cell comments, formulas that pull from other sheets and file properties, all of which travel with an uploaded file.

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: Best interests notes on Ermos.

Common questions

Do ChatGPT and Claude use the information in a refinance comparison spreadsheet?
Everything pasted or uploaded from the sheet is sent to the AI company's servers and 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. This sheet holds the 5.94 percent retention offer Larch Credit Union phoned through on 10 November, the brokerage's upfront commission on each lender and a $498,300 balance for Ross and Nerida Pickering.
Is it safe to paste a refinance comparison spreadsheet into ChatGPT or Claude?
No, because the sheet ties a household's loan to a private offer and to what the brokerage earns. 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. Taking out the names still leaves the $498,300 balance, the 264 months remaining and a fixed rate of 4.19 percent that ends on 30 November 2026. The commission figures and the Larch offer are commercial information about the brokerage and the lender as well. 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.
Can ChatGPT or Claude be trusted to check the arithmetic in a refinance comparison spreadsheet?
Not without a check. Language models can produce fluent text with wrong figures, mis-copied rows and formulas that look right but are not. A qualified person should check every total against the sheet and the lender's offer. In this sheet the five-year cost, the gap to the lowest option, the cashback condition and the commission figures would do the most harm if wrong, because the recommendation of Tamarind Bank and the conflict check rest on them.
How can a mortgage brokerage use AI for a refinance comparison spreadsheet 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 comparison is produced from the client file and the brokerage's own comparison template. The broker recomputes every total, checks the conflict reasoning and signs the recommendation.
Does a broker need a quote before suggesting a client stay with their current lender?
Under section 114(1)(c) of the National Consumer Credit Protection Act, a licensee must not provide credit assistance by suggesting a consumer remain in a particular credit contract unless it has given the consumer a written quote, the consumer has signed or otherwise accepted it, and the licensee has given a copy. Under section 164(d) of the Act, regulation 28M and Schedule 4 to the Regulations apply section 114 as if it excused a quote in the circumstances the Regulations prescribe, and regulation 28C prescribes them: the licensee's credit guide says it does not impose fees or charges on consumers for credit assistance and other services, or the licensee does not intend to charge before it provides the assistance and its credit proposal disclosure document says no fee or charge has been imposed. That modification sits in the Regulations, so the text of section 114 in the Act does not show it. A licensee that gives no quote must not request or demand payment for its credit assistance (subsection 114(4A), as modified by Schedule 4). Section 115(2) also requires an assessment within the previous 90 days of whether staying would be unsuitable.
What did ASIC's October 2026 report say about comparing loan costs?
Report 840, published on 13 October 2026, reviewed 13 licensees in eight aggregator groups. It found licensees could do better at showing why a loan that costs more than another available option is in the consumer's best interests, and at capturing lender discounts and cashbacks in their systems. It noted that licensees measured cost over the full term or a shorter period such as five years. The report is not law and points to RG 273.
What must a credit proposal disclosure document contain?
Section 121(2) lists the total fees or charges the consumer will pay the licensee and how that is worked out, a reasonable estimate of the indirect remuneration the licensee or its people are likely to receive and the method, estimates of fees the consumer will pay the credit provider and anyone else for applying, and, where credit pays those amounts, the likely credit left after they are paid.

See Dominion answering from your own documents.

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

Book a demo