Karo Data Management LogoKaro Data Management Logo

Practice Register and FFS Analysis

This spreadsheet is a summary of the financial information, patient numbers and demographic analysis of your practice. View a sample report (pdf 405kb)  

A description of each sheet follows.

Summary Page

This page is a brief summary of you register and financial information including FFS deductions for the month.

On the right side of the page, there are clickable links to each of the sheets in the spreadsheet. To return to the summary page just click Home (in cell B2) on any of the other sheets.

Financial Monthly

There are two tables on this sheet. Together they give you a monthly analysis of the funding streams for the practice for the current month and over time. All amounts are GST exclusive.

Monthly Payments (excl GST) for Current Month

This shows the monthly financial calculations for this month. It includes First Contact Care (your core payment) and, where applicable, the VLCA, U6, U14 and CSC amounts. Your monthly FFS deductions are also included in this and subtracted from the total.

Where requested (by the PHO) this table will be broken down by provider. Note the provider information is from the provider specified in NES not the PMS, changes to the provider need to be updated in both the PMS and NES for this report to be updated.

Practice Monthly Total

This table gives the practice monthly totals for First Contact Care for each month based on your practice’s Funding Model (VLCA, CSC, Under 14 etc) at the time.

For us to enable the FFS to be deducted correctly we have had to load the January register in as 3 separate months (Jan, Feb, Mar 2019) Note: For information prior to this date you will need to refer to your earlier Register Analysis Reports.

Patient Enrolments

There are two tables at the top of this sheet. The table on the left shows you the funded patients (as at the 1st of the month) by month and the change over the month (new patients coming in and patients that have been terminated). The first row only has the currently funded patients as it is not yet known how many new and terminated patients you will have as the month has only just started.

The table on the right shows you a break down of all of the terminated patients by the reason for termination. This reason has either been generated automatically by the MoH or when you have done a manual enrolment end and will be the reason that you entered in NES.

For details on your terminated patients, see your register updates spreadsheet

Where requested there is a third table on this sheet, with enrolments by provider for the current month.

Enrolment Graphs Sheet

There are two graphs of your practice monthly totals from the previous sheet. It illustrates changes in the patient numbers at your practice over time. For example, the data may indicate it is a good time to make decisions about accepting new patients.

Please note the vertical axis on the funded patients over time graph is being automatically set by Excel – it may be exaggerating the extent of changes over time.

Funding Details Sheet

This sheet gives you a further analysis of your population and the First Contact Care (FCC) funding received for them. Note: Any patient with an unknown gender on NES/NHI is NOT included in these tables - this may mean there is small discrepancy between this sheet and the Summary sheet - the Summary sheet is the information that will be used for your funding.

The first table at the top of the sheet shows you the breakdown of your patients by all the categories that affect FCC funding of age, gender and card status. The funding is different if the patient has both a CSC and HUHC so the count of those patients is shown in a separate column. The First Level Service amount shows the base level funding for patients (without the application of any fee reduction subsidies).

The subsequent tables show the additional funding that you are entitled to for the fee reduction subsidies, that is if you have signed up to the CSC and Under 14 subsidies. Note there is no CSC subsidy for Under 14s as this is covered in the Under 14 subsidy. 

Patient Demographics Sheet

On this sheet there are multiple tables and graphs with information about the demographics of the patients in your practice.

Age Group Breakdowns:

By Gender:

This table shows the number of patients broken down by age group and gender. It is used as the basis of the first graph on the right. It is worth looking closely at the age and gender distribution of your practice as this will have a significant impact on the service utilisation (i.e. how often people visit your practice). It is also important to notice whether you have nearly equal numbers of men and women enrolled in your practice.

By Ethnic Group:

This table shows the number of patients broken down by age group and ethnic group (based on the priority ethnicity ranking). This table is used as the basis of the graph to the right. It is worth looking closely at the age and ethnicity distribution of your practice as this will have a significant impact on the service utilisation (i.e. how often people visit your practice).

By Quintile:

This table shows the number of patients broken down by age group and quintile. This table is used as the basis of the graph to the right. This shows the number of patients in your practice in each quintile. Each quintile in the New Zealand population is around 20%: slightly less in Quintile 1 (18%) increasing to slightly more in Quintile 5 (21%).

High Needs Analysis:

Patient Register by Ethnic Group and Deprivation Index

This table shows your register of patients by ethnic group and quintile 5, which make up your high needs patients.

High Needs analysis

This table shows the total patients that qualify as 'high need' patients (Maori, Pacific Island, Dep 5) giving the total high need patients for the Practice. If the percentage is over 50%, you may be eligible also for the Very Low Cost Access (VLCA) funding.

This graph shows the proportion of patients by the high needs criteria. It is based on the High needs analysis table to the left.

FFS Deductions Sheet

There are two tables and three graphs on this sheet

FFS Deductions by Month of the Deduction

This table shows the number of FFS deductions that your practice has had for the month based on when the deduction was made/claimed for.

The graph to the right of the table shows total FFS deductions (for a maximum of the previous two years) in graph form.

This can assist you to track trends and whether changes in opening hours or doctor availability has had an impact on the number of your patients who are seeking services elsewhere.

 

FFS Deductions by Month of the Visit – note the last 2 months are not included as not all visits have been claimed yet.

This table shows the number of FFS deductions that your practice has had based on the date of the visit (rather than when it was claimed as per above)

The graph to the right of the table shows the total number of FFS visits (for a maximum of the previous two years) in graph form.

This can assist you to track trends and whether changes in opening hours or doctor availability has had an impact on the number of your patients who are seeking services elsewhere.

The third graph on the page shows the average deduction per patient (all patients funded for the month) by the month of the visit from the second table. The level of this amount is an indicator of the overall cost of the FFS deductions across all your patients.

FFS This Month Detail Sheet

This shows all FFS deductions for your practice. Do NOT contact patients about their reasons for visits elsewhere. They are entitled to do this, although if a patient has had a significant number of visits elsewhere, you may contact them to see if they still want to be enrolled with your service.

Patients Matched against the current register

The patients in this table have made a visit to another medical practice. Repeat visits to another practice may mean they have moved to that practice. You may want to check NES or contact them to ask if this is the case and if they still wish to be enrolled with your service.

The table also shows the day of the week of the visit. Lots of weekend visits possibly indicate visits to after-hours clinics. It also shows the date of the last visit (DLV) with you. You may want to compare DLV with the information on the six months total sheet.

There is also the list of providers on this sheet that can be filtered, this can be helpful to see if a particular Doctor has been unavailable.

FFS This Month Totals Sheet

This table shows total FFS Deductions for this month. It shows the total dollar amount that has been claimed for each patient, with the highest total at the top.

FFS Six Month Totals Sheet

This table shows total FFS deductions for your patients for the last six months. It shows the total visits and the total amount of the deductions for each patient over the last six months.

For comparison, the last column shows the total amount of First Contact Care funding for six months (based of the current months funding). Follow the instructions as for 'this months detail' . It also shows the DLV to help you work out what to do.

Note: This sheet is looking up historical records, so may not be accurate

  • for the first 3 months of NES, or
  • if you have not yet been with your PHO for 6 months
  • your PHO has not had its data processed for 6 months by Karo

Some FAQ’s for FFS

1. Why is the FFS amount deducted sometimes $0? 

The FFS amount paid is the amount paid to the other doctor the patient visited. The FFS deducted amount is the amount deducted from your PHO. Usually they are the same but if the patient goes elsewhere more than three times in a month, the fourth and subsequent visit is not deducted from your PHO.

2. Why do I keep getting FFS deductions months after a patient has transferred to another practice?

The other practice that saw the patient has up to three months to lodge the casual GMS claim with MOH. If the patient visited the other practice on 28 Feb and that practice was a bit slow to get their claims in (maybe their practice manager was on leave), the claim may not be lodged with MOH until the end of April. HPAC would then process that claim during May and the FFS deduction would come to the PHO/practice in June. So it is possible for you to still be getting FFS deductions four months after a patient has transferred from your practice.

If you are concerned about the validity of a deduction, you need to look in your FFS spreadsheet and note the 'date of the visit' that the claim was for (N.B. not the 'date of the deduction'), then check back on your PMS to see if the patient’s enrolment on NES was ended after that date.