Report Examples

Business Intelligence

Click on the report name for a sample of each report.

Business Area	Report Name	Description
Executive and Finance	Revenue Cycle KPI Dashboard
	Case Mix by Financial Class.
	Underpayment Placement Program – Cash Collected by Payor.
	Detail Contract Report by Contract Code.
	Profit and Loss Statement by Patient Type and Financial Class
	Profit and Loss Summary by Doctor
	Underpayment Placement Program – Performance and Adjudication Analysis
	Patient Volumes Summary
	Underpayment Placement Program – Recovery Open Inventory by Payor
	Underpayment Placement Program – Resubmittal by Payor
	Underpayment Placement Program – Resubmittal by Reason
	Resubmittal Detail Report
	Target by Financial Class
	Target by CPT
	Target by CPT for export
	Target by ICD-9 Procedure Code
	Target by UB Revenue Code
	Bad Debt Writeoffs
	Denial % of Revenue
	In house receivables
	Payment Variance Summary by Payor.
	Net A/R
	Profit and Loss Statement by Patient Type.
Patient Financial Services	Medicare Paid Log
	Medicare Unbilled Log
	Medicare Unpaid Log
	Patient Paid Log by Payor
	Patient Unbilled Log by Payor
	Patient Unpaid Log by Payor
	Bill Hold Days
	Aging Detail
	Aging Summary
Managed Care	Aging Graph
	Payment Aging Summary for Managed Care by Discharge Date.
	Managed Care – Cost Per Case Report
	Managed Care Summary YTD
	Managed Care Contract Performance Summary CY vs PY
	Patient Services by Contract Code
	Reimbursement by Contract
	Reimbursement Summary by Financial Class
	Revenues by Contract
	Payment Variance Detail by Payor
	Payor KPI Matrix – MTD, YTD, CY/PY
	Payor Score Card
	Principal Procedure by MD
	Reimbursement by Contract. Use this report to identify reimbursement trends in Commercial contracts.
Revenue Recovery	Collection Agency Netback % & $
	Contractual Variance Detail by Payor
	Contractual Variance Summary by Payor
	Contract Allowance Variance by Insurance Code.
	Inpatient High Dollars
	Late Charge Audit by Department
	NICU/Nursery Audit
	Outpatient High Dollars
	Zero Payment Accounts
	ER Level of Care
Utilization Management	Denied and Approved LOS by MD
	Denied Revenue by MD
	LOS by Nursing Unit

Crystal Reports

No matter what version, we can write Crystal Reports for you. See Reporting Packages for more detail. Crystal Reports is our most prominent core competency.

Extraction to External Database or Cube

Perhaps you need to merge your data with other sources. We can help you to extract and set that up.  Some applications are for internal reporting of core measures data.

SQL and Stored Procedures

When you run into an issue where the data is a very large or complex query, processing time becomes an issue. We can find a solution to that through employing SQL and Stored Procedures though for the end user, the results are simple….point and click.