NOTE:  As of February 2015, this report is intended for use with NC Medicaid payers only.  

How to Run the Report

From Barnestorm Office click on Reports> Employees > 02.35 NC Medicaid Billed/Paid Summary.  This report will show a summary of what’s been billed/paid, including hours for CAP, PCS, PDN and Other. This report also displays adjusted amounts, as well as any unpaid balances.  If you would like a detail of each date of service, choose the Print Date By Date Details option (more details below).  This report will show a variety of information, based on the filtering option(s) you choose below:

• From /Thru = Enter your desired date range for month(s) of service.
• Program(s) / Payer(s) / Employee(s) =Filter report by entering program, payer and team numbers.  Or leave blank to view all.
• UnPaid Charges Only = By checking this box, the report will only display patients with unpaid balances.
• Print Date by Date Details = By checking this box, the report will display each date of service and show a breakdown of the $AmtBilled, amount paid, hours, etc. The service date will appear on the outer column of the report.  Only chargeable visits will generate on this report. 
• CAP/PCS/PDN/All = These checkboxes allow the option to choose CAP only, PCS only, or PDN only.  You also have the option to select multiple;OR select All by clicking the All box or leave all boxes unchecked to include all in the filtering.  
• Skilled = Shows you only unpaid skilled services by revenue codes.  You have the option to select Therapy Only or Supplies Only, as well. 
• There are several “Print By”Options.

How to Read the Report

NOTE:  The columns seen on your report will be based on the “Print By”option you choose above.  The following may or may not appear, based on your “Print By” selection.  The totals/calculations, that appear on your report, will be based on the From/Thru period entered above.

• Office= Displays the Office Number
• Employee = Displays the Employee Last, First Name.
• Patient = Displays the Patient Last,First Name.
• PCS Hours = Displays the total PCS Hours.
• CAP Hours = Displays the total CAP Hours.
• Oth Hours = Displays the total Oth Hours.  “Other Hours” are hours not related to CAP, PCS or PDN.  Note:  If you do not specify CAP, PCS or PDN (see above), the report may include any "other hours" as well as charges related to those hours from other payer sources.  To ensure that only CAP, PCS, and/or PDN hours calculate on the report, please check those appropriate checkboxes.
• Total Hours = Displays total hours,including CAP, PCS and Other.
• $AmtBilled = Displays the amount billed for that patient.
• $AmtPaid = Displays the amount paid for that patient, even if payment was made after the from and through date.
• $AmtAdj = Displays the amount adjusted for that patient, even if adjustment was made after the from and through date.
• $Unpaid = Displays the balance due for that patient.