Complete Medi-Cal Services and Expenditures Month of Payment
County and Statewide Summary Reports (updated annually)

(includes utilization data by aid category, reported statewide and by county.
Each file covers one county (or statewide). The first aid category for each county file
is "Cash Grant - AGED Aid Code 10". The last aid category is "80 Total Certified,"
which provides aggregate data for all individual aid categories).

Some of these files were created in Microsoft Excel and utilize a Pivot Table.
Note that a Pivot Table was added to permit the user to summarize and analyze the data interactively.
For more information about the elements of a Pivot Table please go to the Microsoft website at: http://support.microsoft.com/
-or-
You can visit the MCSS General Information page and view MCSS's
Tips for Manipulating Microsoft's Excel Pivot Tables

*Please note that recent changes to the Health Insurance Portability and Accountability Act (HIPAA) have added new restrictions as to the type of entities that can receive personal medical data and the purposes for which the data can be used. Please refer to our General Information page for more information.

Note:  as our Department normally uses the term, "Medi-Cal eligible" is someone who is on Medi-Cal. If there is a share of cost (SOC) that must be paid before Medi-Cal picks up the remaining costs of care, such a person could be certified or uncertified, that is, he/she met their SOC for that month or they haven't, respectively. If "certified" and uncertified are not used when describing "eligible," "certified is normally implied. The term "beneficiary" usually means a Medi-Cal eligible who, if normally construed to mean a Medi-Cal eligible enrolled in a Medi-Cal managed care plan.

The terms "eligible," "beneficiary," and "enrollee" are used interchangeably within Medi-Cal.  Each refers to a person who meets all requirements for receiving a Medi-Cal medical service or good (e.g., drugs, DME items) and is enrolled in the Medi-Cal program by the Department. 

Please send comments and suggestions regarding the Medical Care Statistics Section Website to: Medical Care Statistics Section