Orange County NC Website
Browse       Search
BOH GOVERNANCE DASHBOARD Q2 FY17-18 <br />* NOTE :FY17-18 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 />Due to application updates, December Dental billing accuracy data is not available <br />42 <br />50 <br />42 42 <br />38 <br />20 <br />0 <br />20 <br />40 <br />60 <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 />MEDICAID INSURANCE <br />SELF PAY Total Earned Revenue ($234k YTD) <br />Budget Projection ($43.4k/m, $521k/y)YTD Month Avg ($39.k/m, ~$467k/y est) <br />FY16-17 D Revenue ($478k/y)FY16-17 D Revenue - Avg ($39.8k/m) <br />48 50 50 <br />74 <br />69 <br />34 <br />0 <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 />MEDICAL (PH) EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />MEDICAID INSURANCE <br />SELF PAY Total Earned Revenue ($325k YTD) <br />Budget Projection ($57.1k/m, $686k/y)YTD Month Avg ($54.1k/m, ~$649k/y est) <br />FY16-17 M Revenue ($660k/y)FY16-17 M Revenue - Avg ($55.k/m) <br />209 <br />236 <br />180 <br />252 259 <br />130 <br /> - <br /> 50 <br /> 100 <br /> 150 <br /> 200 <br /> 250 <br /> 300 <br /> 350 <br /> 400 <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 ($1.3M YTD)YTD Month Avg ($211k/m, ~$2.5M/y) <br />Prior: FY16-17 Total OCHD Revenue ($2.9M/y)Prior: FY16-17 Revenue - Avg ($240k/m, $2.9M/y) <br />FY17-18 Budget Projection ($278k/m, $3.3M/y) <br />105%102%105%96%105% <br />J A S O N D J F M A M J <br />Dental Billing Accuracy* <br />vs previous year & goal <br />D FY18 Total Accuracy (YTD avg 103%)D FY17 Accuracy - Avg (98%)Accuracy Target (90%) <br />94%94%93%92%92%81% <br />J A S O N D J F M A M J <br />Medical Billing Accuracy* <br />vs previous year & goal <br />M FY17 Total Accuracy (YTD avg 91%)M FY16 Avg Accuracy (96%)Accuracy Target (90%)