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.

fx
ABCDEFGHI
1DateTransactionPerson or supplierInOutBalanceAuthorised byEntered byNote
2Wed 30 Sep 2026Stocktake carried forward–Count agreed with the bound register
3Tue 6 Oct 2026ReceiptCourier delivery, receipt signed, placed in the safe
4Fri 9 Oct 2026Administered
5Wed 14 Oct 2026Administered
6Mon 26 Oct 2026Administered
7Thu 29 Oct 2026Administered
8Tue 10 Nov 2026Loss
9Fri 13 Nov 2026Administered
10Wed 18 Nov 2026StocktakeCount by RS and Mereana Tuck RN
Morphine 10 mg-mL amp

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

  1. Reads the spreadsheet, register entries and stock count
  2. Reconciles balances transaction by transaction
  3. 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

  1. 1
    Patient 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.

  2. 2
    The 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.

  3. 3
    Quantities 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.

  4. 4
    Who 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.

  5. 5
    The 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.

  6. 6
    The 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.

  7. 7
    The 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.

  8. 8
    The 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.

  9. 9
    The 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.

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 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 general practitioner (GP) practices.

Common questions

Do ChatGPT and Claude use the information in a Schedule 8 drug register spreadsheet?
Yes, everything pasted or uploaded 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 two palliative patients' names and street addresses, their diagnoses, a death on 15 November and the practice's morphine count.
Is it safe to upload a Schedule 8 drug register spreadsheet to ChatGPT or Claude?
No, because most rows name a patient and the sheet shows how much morphine the practice holds. 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. A request to make the count balance would also send the difference of one ampoule and the loss row to the AI company.
What else goes with a Schedule 8 drug register spreadsheet when it is uploaded to ChatGPT or Claude?
The whole file goes, which is more than the rows on screen. An uploaded file can carry other sheets, hidden columns, comments, tracked changes and file properties. This workbook has an oxycodone tab and a tab of stocktakes behind the morphine sheet, and they can hold more named patients. The OAIC's guidance also tells organisations to review carefully the terms and settings that will apply to their use of any AI product.
How can a GP practice use AI for a Schedule 8 drug register 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 reconciliation is worked from the practice's own records and template. The authorised person checks the difference of one against the bound register and the stock and signs the entry.
What must a Schedule 8 drug register entry include in NSW?
NSW Health says each entry must be made on the day or at the time of the transaction and must include the date, the quantity, the name and address of the person involved and the signature of the person making the entry and, where required, a witness. If the medicine is supplied on prescription the entry must also include the prescription reference number and the name of the prescriber.
How often must a NSW practice record a Schedule 8 stocktake?
NSW Health says an inventory of each Schedule 8 medicine must be conducted and recorded in the drug register every 3 months. Its page on the new legislation says that from 5 November 2026 the balance must be recorded at least once every 3 months, where it was previously required only in March and September. In private practice the authorised practitioner is responsible for keeping a compliant drug register on the premises.
Can a practice keep its Schedule 8 drug register in a spreadsheet?
NSW Health says a drug register may be a bound book with consecutively numbered pages, an electronic format that complies with the Electronic Drug Register Standards, or another form approved by the Secretary of NSW Health. An ordinary spreadsheet is not named on that page. Only an authorised person may make final entries, and for an electronic register that person needs a unique access credential.

See Dominion answering from your own documents.

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

Book a demo