The link below is to a base I developed for tracking medical expenses. It can track expenses for any number of patients, medical services, and providers. The base allows the recording of charges, insurance amounts (disallowed and allowed), deductibles, co-insurance and co-pay amounts. It also can track amounts paid by insurance to the provider and to the insured, as well as payments made in settlement of bills from providers. There is a main Medical Expenses table and additional Patient, Service, and Provider tables. Each field has a description of what it is for, and there are several different views of the main Medical Expenses table.
Of course, the sample data in the base is just that and is intended to show the various types of entries that can be necessary in recording expenses, insurance rulings, and personal payments.
Copying the base is enabled on this read-only link. I hope that some will find it useful.
Medical Expense Tracking
Van Zeck
