Orange County NC Website
Browse       Search
BOH GOVERNANCE DASHBOARD Q1 FY15-16 <br />* NOTE :FY 15 and 16 Billing Accuracy no longer combines dental and medical paid claims & unpaid claims. Because two different accounting systems are being used (Medical: Accrual; Dental: Cash) the two clinics are shown separately. <br />Billing Accuracy Formulas: Medical = Paid claims/(# encounters minus no charge claims). Un-claimed appointments are no longer factored in; Dental = Paid Claims/# kept appointments. <br />Claims can take a quarter to realize payment - billing accuracy for all months increases with time as claims are finalized and errors are reworked. <br />**FY14 Dental payments began procesing through Eaglesoft (the current system) in December. The prior months payments are not included in the data, thus producing a lower billing accuracy. <br />182 <br />201 229 <br /> - <br /> 50 <br /> 100 <br /> 150 <br /> 200 <br /> 250 <br /> 300 <br /> 350 <br />J A S O N D J F M A M J <br />Th <br />o <br />u <br />s <br />a <br />n <br />d <br />s <br />TOTAL HEALTH DEPARTMENT REVENUE <br />vs. budget projections & prior year <br />Personal Health Dental <br />Environ Health Grants <br />State Other <br />Total OCHD Revenue (.6M YTD)YTD Month Avg (204k/m, ~2.4M/y est) <br />FY16 Budget Projection (225k/m, 2.7M/y)Prior: FY15 Revenue - Avg (205k/m, ~2.5M/y) <br />46 <br />36 <br />48 <br /> - <br /> 10 <br /> 20 <br /> 30 <br /> 40 <br /> 50 <br /> 60 <br /> 70 <br /> 80 <br />J A S O N D J F M A M J <br />Th <br />o <br />u <br />s <br />a <br />n <br />d <br />s <br />MEDICAL (PH) EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />Self Pay Insurance <br />Medicaid Total PH Revenue (131k YTD) <br />YTD Month Avg (43.5k/m, ~522k/y est)Budget Projection (51k/m, 606k/y) <br />Prior: FY15 PH Revenue - Avg (50k/m, 601k/y)Prior: FY15 PH Revenue (~601k/y) <br />Prior: FY14 PH Revenue - Avg (44k/m, 532k/y) <br />36 40 43 <br /> - <br /> 20 <br /> 40 <br /> 60 <br /> 80 <br />J A S O N D J F M A M J <br />Th <br />o <br />u <br />s <br />a <br />n <br />d <br />s <br />DENTAL EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />Self Pay Insurance <br />Medicaid Total D Revenue (119k YTD) <br />YTD Month Avg (40k/m), ~476k/y est)Budget Projection (45k/m, 537k/y) <br />Prior: FY15 D Revenue - Avg (35k/m, ~423k/y)FY15 Year Dental Revenue (423k/y) <br />Prior: FY14 D Revenue - Avg (26k/m, 317k/y) <br />92%87%86% <br />J A S O N D J F M A M J <br />Medical Billing Accuracy* <br />vs previous year & goal <br />M FY16 Total Accuracy (YTD avg 88%)M FY15 Avg Accuracy (91%)Accuracy Target (90%) <br />103%93%90% <br />J A S O N D J F M A M J <br />Dental Billing Accuracy* <br />vs previous year & goal <br />D FY16 Total Accuracy (YTD avg 95%)D FY15 Accuracy - Avg (96%)Accuracy Target (90%)