Healthcare Medicare Claims Reconciliation Spreadsheets: Use case and AI Confidentiality

Each week the practice manager at an allied health clinic matches what was billed against what Medicare and the health funds paid, then chases the gaps. The work is repetitive, so the sheet is uploaded to ChatGPT or Claude to check the sums, list the unpaid lines or draft reminders. The sheet is a table of patient names against Medicare item numbers, dates of service, amounts and a note on each line, and an item number beside a name says what care that person received. This page marks every item in an invented reconciliation, names the duties each one touches under the Privacy Act and NSW health records law, and shows how the same sheet is worked on Ermos inside the clinic.

The Medicare claims reconciliation spreadsheet

Kept by the practice manager or billing officer each week from the practice software and the Medicare and health fund remittances, to match payments to services and follow up the gaps. It is often emailed or shared, which is how it reaches an AI tool.

fx
ABCDEFGHI
1DatePatientMBS itemServiceFee chargedBenefit paidGapOutstandingNote
2Psychology 50 min+
3Physiotherapy, GP plan
4Occupational therapy, GP plan
5Dietetics, GP plan
6Physiotherapy, GP plan
7Psychology 50 min+
8Physiotherapy, GP plan
9Physiotherapy by video
10Physiotherapy, GP plan
11HICAPSPhysiotherapy, Jacaranda Health Fund
12Psychology 50 min+
13Total1176.80730.05446.75225.05
Oct-Nov 2026

An invented spreadsheet. The patients, the clinic and the health fund are fictional, the fees charged are the invented clinic’s own, the health fund benefit is invented, and the Medicare item numbers and benefits are the published figures. Hover or tap any highlighted item for the analysis; the full list is below.

Claims reconciliation sheet builder

An Agent+ that builds and updates the weekly claims sheet from the practice's own billing export and the remittance advices it is given. It matches each service to its payment and lists the gaps and the balances still owing, in the layout the practice manager already uses.

What it does

  1. Reads the weekly billing export and remittance advices
  2. Matches payments to services, row by row
  3. Lists unmatched services and balances still owing

What stays with your people. The practice manager or billing officer checks every flagged row and decides the follow-up. The agent prepares the sheet 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 practice

  1. 1
    Patient names

    Six patients named against billing lines. This is personal information, and because the clinic collected it in providing a health service it is health information under section 6FA(b) of the Privacy Act. Health information is sensitive information (section 6(1)). A business that provides a health service and holds health information is not a small business operator (section 6D(4)(b)), so the $3 million turnover threshold does not take the clinic outside the Act. Privacy Act guide.

  2. 2
    Medicare item numbers

    Each number names a service. Item 80110 is a psychology session of at least 50 minutes in consulting rooms, 10960 physiotherapy, 10958 occupational therapy, 10954 dietetics and 93000 an allied health video attendance, all as the MBS describes them. Information about a health service provided to an individual is health information (section 6FA(a)(iii)). The number is public; the risk is the name beside it. Patient data guide.

  3. 3
    Dates of service

    When each person attended. A run of dates shows a treatment schedule and when someone will be at the clinic. Dates against a name record a health service provided. Patient data guide.

  4. 4
    Fees, benefits and gaps

    Money against names. The Medicare benefits are schedule benefits (one line is a health fund benefit), but the fees are the clinic’s own pricing, and the gap is what each patient personally pays. APP 11.1 asks an organisation to take reasonable steps to protect personal information from misuse, interference and loss and from unauthorised access, modification or disclosure. Privacy Act guide.

  5. 5
    The outstanding column

    A list of who owes what. It is a debtors list tied to health services, and it is the column staff most often paste out to draft reminders. Where reminders go matters, because several patients have asked for a particular channel. Privacy Act guide.

  6. 6
    The note column

    Free text with the most candid detail: a diagnosis, a spouse’s illness, a daughter who books, a husband who reads a patient’s inbox, and instructions about who must not be told. APP 6.1 stops an organisation using or disclosing information for another purpose without consent or an exception, and the clinic has to be able to follow these instructions. Patient data guide.

  7. 7
    The total formula

    A sum with no patient information in it. The formula can be shared safely; the sheet it sits in cannot.

  8. 8
    Other tabs, hidden columns and file properties

    A spreadsheet file carries more than the visible tab: other sheets such as a debtors list, hidden columns, comments and properties such as the author. Uploading the file sends all of it.

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 healthcare practices. See how this works in practice: Recall letters on Ermos.

Common questions

Do ChatGPT and Claude use the information in a Medicare claims reconciliation spreadsheet?
Everything 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 pairs six patients' names with item numbers, dates and gaps, and its note column holds a diagnosis, a husband who reads a patient's inbox and instructions about who must not be told.
Can we use ChatGPT or Claude for a Medicare claims spreadsheet if we remove the patient names?
Not safely, because the lines still describe people who can be identified. Removing names rarely makes a document anonymous. Information stays personal information while the person is reasonably identifiable, and the OAIC warns that information can be at risk of re-identification even when it has been de-identified or anonymised. An item number for a 50 minute psychology session, a date and a note about a daughter who books the appointments can point to one patient for anyone who knows the family. The sheet records health services, so it is health information under section 6FA(a)(iii) of the Privacy Act. 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.
What travels with a Medicare claims spreadsheet when it is uploaded to ChatGPT or Claude?
The whole file, including tabs nobody looked at. An uploaded file leaves the business as a whole file, which can carry other sheets, hidden columns, comments, tracked changes and file properties. Here that could include a debtors list on another tab and the author's name in the file properties. The OAIC's guidance also tells organisations to review carefully the terms and settings that will apply to their use of any AI product. The total formula alone is safe to share, but the sheet around it is not.
How can an allied health clinic use AI for a Medicare claims reconciliation 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 drafted from the clinic's billing records and its own reconciliation template. The practice manager checks every amount and every outstanding line before anyone acts on it.
Is a Medicare billing spreadsheet health information?
Yes. Section 6FA(a)(iii) of the Privacy Act makes information about a health service provided to an individual health information when it is also personal information. A line saying a named person had item 80110 on a date records a service. Section 6FA(b) also covers other personal information collected in providing a health service.
How many allied health services can Medicare cover for one patient in a year?
The MBS explanatory note MN.3.1 says a patient on a GP chronic condition plan can claim up to 5 individual allied health services per calendar year, counting face to face, video and phone services together. Better Access allows up to 10 individual and 10 group mental health services per calendar year. A patient cannot claim Medicare and a private health fund for the same service.
What must a clinic do with billing records it no longer needs?
APP 11.2 says an organisation must take reasonable steps to destroy or de-identify personal information it no longer needs, unless a law requires it to keep it. Under section 25 of the NSW Health Records and Information Privacy Act, a private health service provider keeps an adult's records for 7 years from the last service, and a child's records until age 25.

See Dominion answering from your own documents.

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

Book a demo