GP Schedule 8 Drug Register Spreadsheets: Use case and AI Confidentiality
A practice that keeps morphine for palliative home visits has to keep a Schedule 8 drug register, and the practice manager keeps a working copy in a spreadsheet beside the bound book to check the balances. When the count is out by one, the quickest fix looks like uploading the sheet to ChatGPT or Claude and asking where the gap is. Each row is a named patient, an address, a dose and the doctor who gave it. This page marks each column of an invented Schedule 8 drug register spreadsheet, recomputes the balances, sets out what NSW Health says about drug registers after the new medicines legislation began on 5 November 2026, and shows how the same sheet is worked on Ermos inside the practice.
The Schedule 8 drug register spreadsheet
Kept by the practice manager as a working copy of the bound drug register, updated after each transaction and at each stocktake, and checked against the register and the stock in the S8 safe. It is the practice’s own reconciliation, and the bound book is the register.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Transaction | Person or supplier | In | Out | Balance | Authorised by | Entered by | Note |
| 2 | Wed 30 Sep 2026 | Stocktake carried forward | – | 103 | TV4 | TV4 | Count agreed with the bound register | ||
| 3 | Tue 6 Oct 2026 | Receipt | Eastwood Village Pharmacy, 54 Rutledge Street, Eastwood. Order signed by TV2 | 53 | 153 | TV4 | TV4 | Courier delivery, receipt signed, placed in the safe | |
| 4 | Fri 9 Oct 2026 | Administered | Pearl Ratcliffe, 17 Nankin Street, Eastwood1 | 13 | 143 | TV4 | TV4 | Home visit. Metastatic breast cancer, breakthrough pain. 10 mg subcutaneous.5 | |
| 5 | Wed 14 Oct 2026 | Administered | Pearl Ratcliffe, 17 Nankin Street, Eastwood1 | 13 | 133 | TV4 | TV4 | Home visit. 10 mg subcutaneous. Daughter present.5 | |
| 6 | Mon 26 Oct 2026 | Administered | Noel Redmond, 4 Nevin Close, Eastwood1 | 13 | 123 | RS4 | RS4 | Home visit. Bowel cancer with liver metastases, pain not controlled on oral medicines. 10 mg subcutaneous.5 | |
| 7 | Thu 29 Oct 2026 | Administered | Noel Redmond, 4 Nevin Close, Eastwood1 | 13 | 113 | RS4 | RS4 | Home visit. 10 mg subcutaneous. His wife asked about a syringe driver.5 | |
| 8 | Tue 10 Nov 2026 | Loss | Ampoule broken in the treatment room. Witnessed by Mereana Tuck RN6 | 13 | 103 | RS4 | RS4 | Explained loss, recorded in the bound register6 | |
| 9 | Fri 13 Nov 2026 | Administered | Pearl Ratcliffe, 17 Nankin Street, Eastwood1 | 13 | 93 | TV4 | TV4 | Last dose given. Pearl died on 15 November.5 | |
| 10 | Wed 18 Nov 2026 | Stocktake | Count by RS and Mereana Tuck RN | 93 | RS4 | OS4 | Counted 8. Sheet says 9. The difference is Noel Redmond’s 10 mg on Mon 16 Nov, in the bound register but not yet copied here.7 |
An invented working copy of a practice Schedule 8 drug register for one product, morphine 10 mg in 1 mL ampoules, as at Thursday 19 November 2026. All patients and the doctors’ initials (TV, RS) and the practice manager’s (OS) are fictional. Balance is 10 carried forward, plus 5 received, minus 6 out (five administered and one lost), which is 9. The physical count on 18 November was 8, one fewer than the sheet. The sheet is not the register. Hover or tap any highlighted item for the analysis; the full list is below.
Controlled drug register reconciler
An Agent+ that reconciles the practice's working copy of the drug register. It reads the spreadsheet, the entries the practice manager supplies from the bound register and the latest stock count, and produces a reconciliation sheet showing each difference, with the transaction it relates to.
What it does
- Reads the spreadsheet, register entries and stock count
- Reconciles balances transaction by transaction
- Lists differences and unexplained entries for investigation
What stays with your people. The practice manager and a GP check every difference against the bound register and the safe. The bound register stays the record; the agent only compares.
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
- 1Patient names and street addresses
NSW Health says each drug register entry must include the name and address of the person involved in the transaction. Here that is a person who was given morphine at home. Information about a health service provided to an individual is health information (Privacy Act s 6FA(a)(iii)), and health information is sensitive information under s 6(1). APP 11.1 asks for reasonable steps to protect personal information from misuse, interference and loss and from unauthorised access, modification or disclosure. Patient data guide.
Frontier Models (ChatGPT, Claude) Transmitted to the AI company, 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 Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 2The supplier and the order
NSW Health says S8 medicines must be ordered and signed by an authorised person, that an authorised person signs and dates the receipt, and that the medicine is placed in the S8 safe and recorded in the drug register. The row names the pharmacy and shows who signed the order, which tells a reader where the practice gets its controlled drugs.
Frontier Models (ChatGPT, Claude) A supplier and who signed the order; low sensitivity, but it shows the supply chain Ermos Edge Not about where data goes Ermos Dominion Not about where data goes Use case Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 3Quantities and the running balance
Nothing here is personal information. It does show how many ampoules of an opioid are on the premises and when they were last topped up, which is a security matter. NSW Health says access to S8 medicines is restricted to authorised personnel and that each brand and strength has its own page in the register.
Frontier Models (ChatGPT, Claude) Stock held at the practice transmitted; a security matter more than a privacy one 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 Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 4Who authorised and who entered
Initials for the doctors and the practice manager. NSW Health says only an authorised person may make final entries in a drug register, and for an electronic register that must be someone with a unique access credential. A copy kept by the practice manager can hold initials, but a tool that tidies the sheet is not an authorised person and cannot sign.
Frontier Models (ChatGPT, Claude) Initials only; the sheet cannot stand in for an authorised person’s signature Ermos Edge Not about where data goes Ermos Dominion Not about where data goes Use case Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 5The notes: diagnoses, doses and a death
Free text with the indication for each dose, a diagnosis, a family member and the date a patient died. It is health information about named people, and a family member’s remark is personal information about someone who is not the patient. Patient data guide.
Frontier Models (ChatGPT, Claude) Sensitive health information 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 Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 6The loss row
NSW Health says any loss of an S8 medicine must be recorded in the drug register and that an unexplained loss or theft must be reported to Pharmaceutical Services. Its page on the new legislation says an explained loss, such as a witnessed spill, no longer has to be reported from 5 November 2026. This row calls the loss explained and names a nurse as witness. Whether a loss is explained is for the authorised person to judge.
Frontier Models (ChatGPT, Claude) A loss, a witness and a judgment that it was explained, 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 Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 7The stocktake row and the difference of one
NSW Health says an inventory of each S8 medicine must be recorded in the drug register every 3 months, and that from 5 November 2026 the balance must be recorded at least once every 3 months where it was previously required in March and September. Here the count is 8 and the sheet says 9. A tool asked to make the sheet balance can only change a number. Whether the stock or the entry is wrong is for the authorised person to establish from the bound register and the count.
Frontier Models (ChatGPT, Claude) A mismatch transmitted and a neat answer returned; the real difference stays unresolved Ermos Edge Stays on your instance; an excerpt holding it could reach the named Australian provider, which keeps nothing; the difference is resolved by the authorised person against the bound register and the stock Ermos Dominion Stays on the unit; the difference is resolved by the authorised person against the bound register and the stock Use case Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 8The balance formula
Opening balance plus receipts minus quantities out. It holds no patient information, so the formula can be shared. The sheet it sits in cannot.
Frontier Models (ChatGPT, Claude) A formula with no data in it; harmless to send on its own Ermos Edge Not about where data goes Ermos Dominion Not about where data goes Use case Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. See the use case - 9The other tabs
The workbook carries a page for each other product and a tab of stocktakes. NSW Health says registers must be retained for a minimum of 2 years from the last entry, so these tabs can hold a long list of named patients. Uploading the file sends every tab, hidden column and comment.
Frontier Models (ChatGPT, Claude) Every other tab and every named patient in the workbook 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 Controlled drug register reconciler. Compares the working spreadsheet with the bound register entries and the stock count, and lists differences for the practice manager to investigate. 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 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 patient record. 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 general practitioner (GP) practices.
Common questions
Do ChatGPT and Claude use the information in a Schedule 8 drug register spreadsheet?
Is it safe to upload a Schedule 8 drug register spreadsheet to ChatGPT or Claude?
What else goes with a Schedule 8 drug register spreadsheet when it is uploaded to ChatGPT or Claude?
How can a GP practice use AI for a Schedule 8 drug register spreadsheet without sending it to ChatGPT or Claude?
What must a Schedule 8 drug register entry include in NSW?
How often must a NSW practice record a Schedule 8 stocktake?
Can a practice keep its Schedule 8 drug register in a spreadsheet?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo