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.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Option | Rate p.a. | Repayment / month | Interest, 60 months | Fees, 5 years | Switching costs | Cashback | 5-year cost | Gap to lowest | Brokerage upfront |
| 2 | Larch Credit Union: stay, fixed 4.19% ends 30 Nov 2026 and reverts2 | 6.34% | 3,505 | 148,908 | 0 | 0 | 0 | 148,9086 | 13,8266 | 0 |
| 3 | Larch Credit Union: retention offer | 5.94%3 (phoned 10 Nov, valid to 20 Nov) | 3,386 | 139,110 | 0 | 0 | 0 | 139,1106 | 4,0286 | 0 |
| 4 | Tamarind Bank | 5.74% | 3,328 | 134,227 | 0 | 855 | 0 | 135,0826 | lowest6 | 3,4885 |
| 5 | Southgate Bank | 5.89% | 3,371 | 137,888 | 1,975 | 855 | 3,000 (repayable if closed within 2 years)4 | 137,7186 | 2,6366 | 3,2395 |
| 6 | Orrin Building Society | 5.99% | 3,401 | 140,333 | 1,750 | 855 | 0 | 142,9386 | 7,8566 | 2,9905 |
| 7 | Clients and loan | Pickering, Ross & Nerida1 | Balance $498,300 at 9 Nov 2026, 264 months left, variable, owner-occupied, offset wanted7 | |||||||
| 8 | Recommended | Tamarind Bank: lowest five-year cost, $4,028 below the retention offer. Ross and Nerida are comfortable switching8 | ||||||||
| 9 | Conflict check | Staying earns the brokerage nothing and each switching option pays upfront commission, so the brokerage’s interests differ from the clients’. Tamarind pays the most and is also the cheapest, so giving priority to the clients’ interests does not change the recommendation9 | ||||||||
| 10 | Method | Payment = PMT(rate/12, months left, -balance); interest = sum of balance x rate/12 over 60 months; cost = interest + fees + switching - cashback10 |
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
- Reads the current loan statement and the offers gathered
- Builds the cost grid across the chosen period
- 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
- 1The 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.
Frontier Models (ChatGPT, Claude) Two names tied to every figure, 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 Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 2The 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.
Frontier Models (ChatGPT, Claude) Your clients’ current loan and fixed rate expiry 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 Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 3A 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.
Frontier Models (ChatGPT, Claude) A private offer from a named lender transmitted; on consumer tiers it can train future models 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 Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 4The 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.
Frontier Models (ChatGPT, Claude) Usually a published lender offer; low risk alone, but it sits beside the clients’ names Ermos Edge Stays on your instance; the promotion terms still need checking against the lender’s page Ermos Dominion Stays on the unit; the promotion terms still need checking against the lender’s page Use case Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 5What 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.
Frontier Models (ChatGPT, Claude) Your commission on every 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 Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 6The 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.
Frontier Models (ChatGPT, Claude) Your cost analysis and the basis of the advice transmitted Ermos Edge Stays on your instance; the model can still add up wrongly, so the broker recomputes every total Ermos Dominion Stays on the unit; the model can still add up wrongly, so the broker recomputes every total Use case Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 7The 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.
Frontier Models (ChatGPT, Claude) A household balance and goals 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 Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 8The 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.
Frontier Models (ChatGPT, Claude) The recommendation transmitted before the clients have it in writing 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 Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 9The 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.
Frontier Models (ChatGPT, Claude) Your reasoning about your own conflict transmitted Ermos Edge Stays on your instance; whether a conflict exists is the licensee’s judgment Ermos Dominion Stays on the unit; whether a conflict exists is the licensee’s judgment Use case Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. See the use case - 10The 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.
Frontier Models (ChatGPT, Claude) A standard formula with no client data Ermos Edge Nothing to keep in; the method is public Ermos Dominion Nothing to keep in; the method is public Use case Refinance comparison builder. Builds the refinance comparison grid from the current loan and the options on file, laying out rates, cashback, remuneration and total cost over the chosen period for the broker. 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: Best interests notes on Ermos.
Common questions
Do ChatGPT and Claude use the information in a refinance comparison spreadsheet?
Is it safe to paste a refinance comparison spreadsheet into ChatGPT or Claude?
Can ChatGPT or Claude be trusted to check the arithmetic in a refinance comparison spreadsheet?
How can a mortgage brokerage use AI for a refinance comparison spreadsheet without sending it to ChatGPT or Claude?
Does a broker need a quote before suggesting a client stay with their current lender?
What did ASIC's October 2026 report say about comparing loan costs?
What must a credit proposal disclosure document contain?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo