Mortgage Broker Construction Loan Progress Payment Schedules: Use case and AI Confidentiality
A construction loan is drawn in stages, and the broker keeps the sheet that follows each one. The progress payment schedule lists the builder’s fixed price, what the clients pay from their own money first, what the lender releases at each stage, the growing balance and the interest owing as it grows. Brokers paste it into ChatGPT or Claude to check the arithmetic, to re-cut the draws after a variation and to write the explanation the clients ask for. This page marks every item in a routine progress payment schedule that the National Consumer Credit Protection Act and the Privacy Act bear on, and shows how the same schedule is handled on Ermos inside the brokerage.
The construction loan progress payment schedule
Built when the lender formally approves a construction loan and updated each time the builder claims a stage. Section 115 of the National Consumer Credit Protection Act requires the licensee to have made the preliminary assessment and the section 117 inquiries within 90 days before it gives the credit assistance, and the assessment must cover the period proposed for entering the contract. ASIC’s RG 273.121 and 273.122 say that when the credit assistance process is delayed the broker should consider whether to start a new assessment or make further inquiries before making a recommendation or assisting the consumer.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Detail | Claim ($) | Clients pay ($) | Loan draw ($) | Loan balance ($) | Interest a month ($) | Expected / status |
| 2 | Clients and loan | Mitchell and Amelia Jefferies. Hartwell Credit Union construction loan $540,000, application HCU-0000000, settles Friday 27 November.1 Land: Lot 14, 22 Willet Court, Gables NSW 2765, owned outright, valued at $350,000 by Valmont Inspections on 20 October.2 | ||||||
| 3 | Builder and contract | Woodcote Homes Pty Ltd, builder licence 000000C, fixed price $598,000 signed Monday 28 September. Claims paid to BSB 000-000, account 0000 0000.3 | 598,000 | |||||
| 4 | Deposit (5%) | Clients’ own money: savings ending 6620 and $19,500 from the sale of Mitchell’s ute4 | 29,900 | 29,900 | 0 | 0 | 0 | Paid Friday 9 Oct |
| 5 | Variation 1 | Kitchen benchtop and ceiling fans, signed Monday 2 Nov, sent to Hartwell Wednesday 4 Nov | 7,300 | 7,300 | 0 | 0 | 0 | Paid on signing |
| 6 | Base (15%) | Slab. Clients pay the first part from their own money | 89,700 | 28,100 | 61,6005 | 61,600 | 3156 | Mid January 2027, after the builder’s Christmas shutdown7 |
| 7 | Frame (20%) | Frame and roof | 119,600 | 0 | 119,6005 | 181,200 | 927 | March 2027 |
| 8 | Lock-up (25%) | Brickwork, windows, external doors | 149,500 | 0 | 149,5005 | 330,700 | 1,692 | May 2027 |
| 9 | Fixing (20%) | Internal linings, cabinets, tiling | 119,600 | 0 | 119,6005 | 450,300 | 2,304 | July 2027 |
| 10 | Completion (15%) | Final fit-off, certificate, handover | 89,700 | 0 | 89,7005 | 540,000 | 2,7636 | September 20277 |
| 11 | Totals | Contract plus variation | 605,300 | 65,300 | 540,000 | 540,000 | ||
| 12 | Before the first draw | Builder’s insurance certificate (home warranty cover) still to come. Council approval seen. Valmont inspects before each draw and Hartwell releases funds three business days later.8 | ||||||
| 13 | Broker note | Mitchell wants a $60,000 pool and landscaping after handover; Amelia has not seen that figure. Mitchell says Woodcote has a name for slow lock-ups, and the 5% contingency is thin. If lock-up slips past June they pay rent and interest together.9 | ||||||
| 14 | Method | Draw = claim less the clients’ contribution until their agreed contribution is paid. Balance = running total of draws. Interest a month = balance x assumed variable rate (6.14%) / 12.10 |
An invented schedule. The clients, builder, valuer and lender are invented; the licence, application, BSB and account values are placeholders, and the interest rate is assumed for the example. Hover or tap any highlighted cell for the analysis; the full list is below.
Construction loan stage schedule builder
An Agent+ that sets up the construction loan spreadsheet from the lender's approval letter and the builder's contract. It lists each stage, the claim amount and the running loan balance, updates the interest as claims are added, and flags when the file's assessment date may need a second look.
What it does
- Reads the approval letter and the building contract
- Builds the stage-by-stage schedule and running balance
- Flags claims that differ from the contract stages
What stays with your people. A broker or loan processor checks each claim against the lender's instructions. The agent builds the sheet and makes no payments.
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 and the loan
Two names, a lender and an application reference, tied to every figure below. Personal information. Whether the Privacy Act reaches a particular brokerage depends on its turnover and activities (section 6D); the clients expect confidence either way. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Two names and a loan reference transmitted, 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 Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 2The land and its valuation
Where the family owns land, that they own it outright and what a valuer says it is worth. The equity that makes the loan work, and the address a fraudster would use to pose as the builder, the lender or the conveyancer. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A home address, its value and the equity 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 Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 3Builder, contract price and payment details
A named builder, a fixed price and the account the claims are paid to. The account belongs to the business rather than the clients, but the price ties to them, and a leaked set of payment details is what payment redirection fraud needs. APP 11.1 requires an APP entity to take reasonable steps to protect the personal information it holds from misuse, interference and loss and from unauthorised access, modification or disclosure. Privacy Act guide.
Frontier Models (ChatGPT, Claude) The price and the payment account transmitted Ermos Edge Stays on your instance; confirming the builder’s account by phone before any payment is still a human job Ermos Dominion Stays on the unit; confirming the builder’s account by phone before any payment is still a human job Use case Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 4Where the clients’ own money came from
A savings account ending and the sale of a vehicle. Financial information the broker collected because section 117 of the National Consumer Credit Protection Act requires reasonable inquiries about the consumer’s financial situation and reasonable steps to verify it. Privacy Act guide.
Frontier Models (ChatGPT, Claude) The clients’ savings and a vehicle sale transmitted; on consumer tiers they 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 Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 5Stage claims and loan draws
Every claim, how much the clients pay first and how much the lender releases. It shows the cost of the build to the dollar. The cost to complete and the stages are part of the financial situation and the objectives the licensee must inquire into (section 117) before it assesses whether the contract would be unsuitable (section 118). Privacy Act guide.
Frontier Models (ChatGPT, Claude) The cost of the build, stage by stage, 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 Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 6The interest estimate
Indicative monthly interest as each draw is made, at an assumed variable rate. A model can add this up wrongly or quote a rate that was never offered, and the figure goes to clients deciding what they can afford. Section 118(2) asks whether the clients could meet their obligations and whether the contract meets their requirements and objectives, so the check is the broker’s.
Frontier Models (ChatGPT, Claude) The household’s monthly cost during the build transmitted Ermos Edge Stays on your instance; the model can still add up wrongly or assume the wrong rate, so the broker checks the figures Ermos Dominion Stays on the unit; the model can still add up wrongly or assume the wrong rate, so the broker checks the figures Use case Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 7Expected dates
When the builder expects to claim each stage, including the Christmas shutdown. Low risk alone. Beside the clients’ names it shows when the home is empty and when they will be paying rent and interest together. If the application is still being prepared when dates slip, RG 273.121 and 273.122 address delay in the credit assistance process.
Frontier Models (ChatGPT, Claude) Dates are low risk alone, but sit beside the clients’ names 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 Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 8Conditions outstanding
Which documents are still missing, who inspects and when funds are released. The operating detail of a lender’s process, which may sit behind the lender’s broker terms, and exactly what a fraudster posing as the lender would ask the clients for.
Frontier Models (ChatGPT, Claude) A lender’s process, and what a fraudster would ask for, transmitted Ermos Edge Stays on your instance; the lender’s broker terms about its process still apply Ermos Dominion Stays on the unit; the lender’s broker terms about its process still apply Use case Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 9The broker’s candid note
A plan one partner has not agreed to, a figure the other has not seen and a tradesperson’s reputation. ASIC’s RG 273.116 says the best interests duty is applied on the information available at the time, including reasonably foreseeable changes to the consumer’s circumstances and financial situation, so a plan like this may be something the broker has to weigh. It is written for the file, never for a general-purpose tool. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A confidence and an opinion of a named builder 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 Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by the broker. See the use case - 10The method
The draw rule, a running total and the interest formula. No client figures once the numbers are removed. A spreadsheet file can also carry hidden tabs, cell comments and file properties, and the Variations and Inspections tabs travel with it.
Frontier Models (ChatGPT, Claude) A standard calculation; send the formula rather than the file, which carries the other tabs Ermos Edge Nothing to keep in; the method is a standard calculation Ermos Dominion Nothing to keep in; the method is a standard calculation Use case Construction loan stage schedule builder. Builds the progress payment schedule from the approval and the builder's contract, then updates it as each stage claim is entered by 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: Documentation best practice on Ermos.
Common questions
Do ChatGPT and Claude use the information in a construction loan progress payment schedule?
Is it safe to paste a construction loan progress payment schedule into ChatGPT or Claude?
Can I upload a construction loan progress payment schedule to ChatGPT or Claude instead of pasting it?
How can a mortgage brokerage use AI for a construction loan progress payment schedule without sending it to ChatGPT or Claude?
What happens to the assessment if the credit assistance process is delayed?
Does the broker have to allow for changes the clients are only thinking about?
What does the Privacy Act say about protecting a client file?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo