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.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Patient | MBS item | Service | Fee charged | Benefit paid | Gap | Outstanding | Note |
| 2 | 26/10/20263 | Jordan Whitfield1 | 801102 | Psychology 50 min+ | 165.004 | 101.554 | 63.454 | 0.005 | Gap paid by card. Invoices to him only, nothing to parents or employer.6 |
| 3 | 27/10/20263 | Keith Jamieson1 | 109602 | Physiotherapy, GP plan | 95.004 | 63.404 | 31.604 | 0.005 | Day 6 after knee replacement. Wife has Parkinson’s.6 |
| 4 | 28/10/20263 | Iris Kasprzak1 | 109582 | Occupational therapy, GP plan | 63.404 | 63.404 | 0.004 | 0.005 | Bulk billed. Rheumatoid arthritis, hand splints. Daughter books.6 |
| 5 | 29/10/20263 | Dmitri Ivanov1 | 109542 | Dietetics, GP plan | 63.404 | 63.404 | 0.004 | 0.005 | Bulk billed. Type 2 diabetes. No emails to his work address.6 |
| 6 | 30/10/20263 | Keith Jamieson1 | 109602 | Physiotherapy, GP plan | 95.004 | 63.404 | 31.604 | 0.005 | Paid at desk.6 |
| 7 | 02/11/20263 | Jordan Whitfield1 | 801102 | Psychology 50 min+ | 165.004 | 101.554 | 63.454 | 0.005 | Gap paid by card.6 |
| 8 | 03/11/20263 | Keith Jamieson1 | 109602 | Physiotherapy, GP plan | 95.004 | 63.404 | 31.604 | 0.005 | Last Medicare service this year (5 of 5). Switch to health fund.6 |
| 9 | 04/11/20263 | Hana Kimura1 | 930002 | Physiotherapy by video | 80.004 | 63.404 | 16.604 | 16.605 | Katoomba. Gap invoice emailed 5 Nov.6 |
| 10 | 05/11/20263 | Lena Jovanovic1 | 109602 | Physiotherapy, GP plan | 95.004 | 0.004 | 95.004 | 95.005 | Medicare rejected: 5 of 5 used. Ring her, no email: husband reads her inbox.6 |
| 11 | 06/11/20263 | Keith Jamieson1 | HICAPS | Physiotherapy, Jacaranda Health Fund | 95.004 | 45.004 | 50.004 | 50.005 | Medicare used up. Fund member no. on file.6 |
| 12 | 09/11/20263 | Jordan Whitfield1 | 801102 | Psychology 50 min+ | 165.004 | 101.554 | 63.454 | 63.455 | Remind by letter only. No SMS.6 |
| 13 | Total | 1176.80 | 730.05 | 446.75 | 225.05 |
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
- Reads the weekly billing export and remittance advices
- Matches payments to services, row by row
- 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
- 1Patient 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.
Frontier Models (ChatGPT, Claude) Transmitted to the provider, 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 Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. See the use case - 2Medicare 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.
Frontier Models (ChatGPT, Claude) An item number identifies the service; the risk is the name next to it 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 Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. See the use case - 3Dates 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.
Frontier Models (ChatGPT, Claude) Dates reveal a schedule, though not a diagnosis 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 Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. See the use case - 4Fees, 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.
Frontier Models (ChatGPT, Claude) Fees, benefits and gaps against named patients transmitted Ermos Edge Stays on your instance; a permitted excerpt may go to the named Australian provider, and the totals still need a person to check them Ermos Dominion Stays on the unit, but the AI can still add up wrongly, so a person checks against the remittance Use case Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. See the use case - 5The 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.
Frontier Models (ChatGPT, Claude) A list of who owes the clinic money 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 Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. See the use case - 6The 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.
Frontier Models (ChatGPT, Claude) Diagnoses, family illness and who must not be told transmitted Ermos Edge Stays on your instance; a permitted excerpt may go to the named Australian provider, which is contractually barred from keeping it Ermos Dominion Stays on the unit in your office Use case Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. See the use case - 7The total formula
A sum with no patient information in it. The formula can be shared safely; the sheet it sits in cannot.
Frontier Models (ChatGPT, Claude) A formula with no patient data in it Ermos Edge Not about where data goes Ermos Dominion Not about where data goes Use case Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. See the use case - 8Other 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.
Frontier Models (ChatGPT, Claude) Every tab, hidden column and comment travels with the file 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 Claims reconciliation sheet builder. Builds the weekly reconciliation sheet from the practice's billing export and remittance advices, and flags services with gaps or a balance still owing. 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 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?
Can we use ChatGPT or Claude for a Medicare claims spreadsheet if we remove the patient names?
What travels with a Medicare claims spreadsheet when it is uploaded to ChatGPT or Claude?
How can an allied health clinic use AI for a Medicare claims reconciliation without sending it to ChatGPT or Claude?
Is a Medicare billing spreadsheet health information?
How many allied health services can Medicare cover for one patient in a year?
What must a clinic do with billing records it no longer needs?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo