The Collections Income Report reflects ALL money in and out of the office.
This report is ran by Assigned or Designated Provider and Action or Date of Service Date under Admin>Global Settings.
- Action- Reflects Posted Date selected when entering payment. (can be backdated)
- Date of Service- Action When payment was entered in VL.
If you receive EOB payments late on Friday and do not want to enter the payments in until Monday Morning. You would select Friday when posting the EOB as that is when you received the payment. The Action date would be Friday’s date but, the date of service date would be Monday’s date.
Any patient not Assigned or Designated to a provider (Depending on the option you choose) will fall under the Unassigned category of the report.
Matching certain reports
For the Collections Income Report to match the Day Sheet Report, both reports must be set to the same provider in Admin> Global settings. (Assigned or Designated) and Action must be selected for the Collections Income Report.
For the Collections Report to match the Practice Diagnosis Total Collections area, the Collections Income Report must be set to Designated Provider and Date of Service Date must be selected in Admin > Global Settings.
To Run the Report
Providers: Leave defaulted to All or select specific Provider
Date Range: Select Range of days, Day, Week, Month, Quarter or Year
Select Full Details or Summary Report.
Sample Full Details Report:
Full Details will allow you to see filters selected, Patient’s name, Case description, Posting Date, Action (type of payment or refund), Details (Cash, Check or Credit Card, Check numbers, CC type etc.), Action Date and Amount of Payment/Refund.
All Patients will be categorized under correct provider. If you see an Unassigned Provider Category with patient’s underneath, that means those patients are not Assigned or Designated to a provider.
Under Every provider, you will see Grand Totals for Patient Payments, Payer Payments, Total Payments, Payments Removed (refunded, Deleted etc.), Insurance Recoupments (Recoupments or insurance refunds), Negative income total and Adjusted collections grand total
(Total Payments- Negative income total= Adjusted collections grand total)
Sample Summary Report
The Summary report will also show the filters selected. You will see Patient payments, Insurance Payments, Removed/Deleted payments, Recoupments/Refunds for insurance payments and totals for each area and the Adjusted Income totals for all providers selected in the filters.
Remember: Total Payments - Negative Income Totals = Adjusted Income Total
To Download/Print a Report
All reports will display a tool bar at the top of the page when generated.
You will be able to Print and Export the document. You will see the Red Circle is highlighting the Print button and the Red Arrow is pointing to the Export options. X=Excel, A=Adobe and W=Word.
Training Video Reference
Please keep in mind, this is an old training video and may not provide a full explanation but, is provided for a visual walk through.