Conveyancer Foreign Purchaser Duty Worksheets: Use case and AI Confidentiality

Each week a conveyancer works out the transfer duty on every purchase and, where a buyer is a foreign person, the 9 per cent surcharge purchaser duty on top. A spreadsheet does the sums, and staff paste it into ChatGPT or Claude to check the formula or the totals. The sheet holds every purchaser’s name, their citizenship or visa status, the property and the price, and notes on foreign investment approval. This page marks every item in a realistic worksheet, shows which cells are only published rates, recomputes the totals, and shows how the same sheet is checked on Ermos inside the practice.

The foreign purchaser duty worksheet

Kept by the clerk through the week for matters approaching exchange or settlement. It shows each purchaser’s status as declared, the duty payable at the 2026/2027 rates and the surcharge where a foreign person is buying residential property, so the clients know what to put into trust.

fx=SUM(I2:I8)
ABCDEFGHIJ
1MatterPurchaserStatus on declarationPropertyPrice ($)Foreign shareTotal duty ($)Note
226-0431Australian citizens920,0000%35,587035,587Exchanged Fri 6 Nov. Cooling-off ends 5.00pm Fri 13 Nov
326-0433Almeida, RUnit 12/4 Mill Street, Lidcombe685,0000%25,012025,012Not a foreign person if the 200 day test is met. Declaration to say so
426-0434812,000100%30,72773,080103,807
526-0436Townhouse 4, 31 Larch Street, Ryde (new)1,090,00050%43,23749,05092,287
626-0440Ansell, GAustralian citizen1,450,0000%61,037061,037
726-0442Unit 17/21 Ferry Lane, Drummoyne1,020,0000%40,087040,087A citizen is not a foreign person for surcharge purposes. Do not apply 9%
826-0445Brightwell, KAustralian citizenUnit 8/15 Station Lane, Canterbury540,0000%18,487018,487
9Total
Duty week 9 NovDeclarationsFIRB log

An invented worksheet. Every person, property and matter is fictional, and the duty figures use the 2026/2027 Revenue NSW rates as published. The last row’s totals are the sum of the rows above. Hover or tap any highlighted cell for the analysis; the full list is below.

Foreign purchaser duty worksheet checker

An Agent+ that builds and checks the foreign purchaser duty worksheet. It reads each matter's contract and the purchaser's declared status, applies the duty rates and surcharge rule your practice has supplied, and fills the sheet row by row. Totals are recomputed so the clerk can see where a figure differs from the file.

What it does

  1. Reads each contract and the purchaser's declared status
  2. Fills the worksheet using the rates you supply
  3. Recomputes totals and flags rows that differ

What stays with your people. The clerk checks the rows and the licensee confirms the figures given to clients. The agent calculates from your rates; it does not decide a purchaser's status.

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 practice

  1. 1
    The purchasers’ names

    Named clients on named matters. Personal information, and the key that ties the status, property and price in the same row to real people. Keeping client information confidential is listed among the rules of conduct in Schedule 2 of the Conveyancers Licensing Regulation, according to the NSW Government. Privacy Act guide.

  2. 2
    Citizenship, visa and residence status

    A purchaser’s citizenship, visa subclass, days in Australia and country of residence. Personal information that reveals immigration status, though the Privacy Act’s closed list of sensitive information does not name it. Revenue NSW says a person is generally a foreign person unless an Australian citizen, ordinarily resident (a permanent resident in Australia at least 200 days in the preceding year), an exempt permanent resident or a qualifying retirement visa holder. Privacy Act guide.

  3. 3
    The property and the price

    An address and a price for each live purchase. The price is also the dutiable value on which both duties are worked out, and with the purchaser’s name it is the whole transaction.

  4. 4
    The transfer duty column and its rates

    The 2026/2027 transfer duty bands published by Revenue NSW (for example $11,602 plus $4.50 per $100 over $387,000 up to $1,290,000). The rates are public, so a formula with no client data is harmless to send. The column beside real prices is not, and a wrong band is an error a person must catch.

  5. 5
    The surcharge column and its 9% rate

    Revenue NSW says surcharge purchaser duty is 9 per cent of dutiable value for foreign persons acquiring residential-related property, charged in proportion to the share they acquire. The rule is public. The sums of $73,080 and $49,050 in the rows tell a reader who is a foreign person and how much they must find.

  6. 6
    The totals

    The sums of the price, transfer duty, surcharge and total duty across seven live matters. They show the practice’s weekly volume and the funds its clients must put up. The figures are arithmetic a person must check, whichever tool produced them.

  7. 7
    The foreign investment notes

    Notes on approval for two foreign purchasers of new dwellings. The Foreign Investment Review Board’s Guidance Note 6 (1 July 2026) says foreign persons generally need approval before acquiring residential land, that from 1 April 2025 to 30 June 2029 they are generally banned from buying established dwellings, and that the ban does not apply to new dwellings. The policy is public. Beside a named client’s matter it is not.

  8. 8
    The preparer and the checker

    Two initials tying the sheet to the clerk and the licensee. Low risk alone, but it names who is answerable for the figures.

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 practice 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 matter 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 conveyancing practices.

Common questions

Do ChatGPT and Claude use the information in a foreign purchaser duty worksheet?
Yes, whatever is pasted from the worksheet 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 worksheet lists seven purchasers with their citizenship or visa status, prices totalling $6,517,000, surcharge sums of $73,080 and $49,050, and notes on foreign investment approval.
Is it safe to paste a foreign purchaser duty worksheet into ChatGPT or Claude?
No, because each row ties a named purchaser's citizenship, visa subclass or days in Australia to a property and a price. 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. That is personal information that reveals immigration status. Beside a named client, even the public 9 per cent rate and the foreign investment policy show who owes surcharge duty and whether an approval is in hand.
Can I upload a foreign purchaser duty worksheet to ChatGPT or Claude instead of pasting it?
An uploaded file leaves the practice as a whole file, which can carry other sheets, hidden columns, comments, tracked changes and file properties as well as the part you meant to share. The OAIC's guidance also tells organisations to review carefully the terms and settings that will apply to their use of any AI product. This workbook has tabs called Declarations and FIRB log beside the duty tab, and all of them would go with the file.
How can a conveyancing practice use AI for a foreign purchaser duty worksheet 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 worksheet is prepared from the declarations on each client file and the practice's own duty template. A licensed conveyancer recomputes every band, surcharge and total before the clients are told what to put into trust.
What is the NSW surcharge purchaser duty rate?
Revenue NSW says surcharge purchaser duty is 9 per cent of the dutiable value of the property, paid in addition to transfer duty, when a foreign person acquires residential-related property. It is charged in proportion to the share acquired by foreign persons. Revenue NSW's own example for a $1 million purchase at 2026/2027 rates is $90,000 in surcharge and $39,187 in transfer duty.
Is an Australian citizen living overseas a foreign person for surcharge purchaser duty?
Revenue NSW says a person is generally a foreign person unless they are an Australian citizen, ordinarily resident in Australia (a permanent resident who was in Australia at least 200 days in the preceding year), an exempt permanent resident, or a retirement visa holder who meets the residence requirements. An Australian citizen is therefore not a foreign person under that test, wherever they live.
Can a foreign person buy an established dwelling in Australia at the moment?
The Foreign Investment Review Board's Guidance Note 6 (version 5, 1 July 2026) says it is Government policy that from 1 April 2025 to 30 June 2029 foreign persons are generally banned from buying established dwellings, with limited exceptions. The ban does not apply to new dwellings, which still need foreign investment approval. Earlier notes gave 31 March 2027 as the end date.

See Dominion answering from your own documents.

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

Book a demo