Give each service a unique row
Use a provider name, service date, and invoice reference to identify an entry. Keep the provider’s charge separate from what an insurer paid and what the statement says you owe. A statement date may differ from the treatment date, so record both if that helps match documents.
HHS explains that access rights generally include medical and billing records held by covered entities. Its right-of-access guidance describes broader record categories. Request the relevant existing records rather than expecting a provider to create a claim analysis for you.
Reconcile a simple example
Imagine a provider charges $1,500, the insurer pays $900, the provider records a $400 adjustment, and the patient balance is $200. The arithmetic is $1,500 minus $900 minus $400 equals $200. Do not add the charge and balance together as if they were different services.
Now suppose a later statement repeats the $200 balance. Update the existing row instead of adding another $200. If a separate clinician sends a bill for the same visit, check whether it represents a different service before deciding it is a duplicate.
Use these worksheet columns
- Service date and provider.
- Invoice or account reference stored privately.
- Original charge and any corrected charge.
- Insurance payment, adjustment, and patient payment.
- Remaining balance and date last confirmed.
- Document filename and any disputed item.
You can start with the blank expense ledger. It is a local organizational worksheet, not a submission to an insurer or a calculation of legal entitlement. Keep identifiers out of any version you share with an AI tool.
Resolve differences before using a total
If the provider’s statement and insurer’s explanation disagree, note the discrepancy and ask for clarification. Preserve both versions. Do not silently change a figure to make the totals match.
Whether a claim uses billed amounts, paid amounts, or another measure is a legal question that varies with jurisdiction and circumstances. Give the complete reconciliation to the professional reviewing your claim. A clear record of the underlying transactions is more useful than a single unexplained “medical expenses” figure.