Enterprise Financial Reports in General Case Management

Standard Financial Reports in General Case Management

Common Uses

• Aging Report - I want to know my total open AR regardless of funding source, this includes any service where an Invoice has been generated.
• Unpaid Claims - I want to know only the open AR associated with services where a Claim has been generated.
• Claims: Rejected - I want to know what Claims have denied and need my attention.
• Authorizations - I want to view all my Active Authorizations across Clients.

Common Report Features/Options

• Group by/Sort: If option is present, open dropdown to select alternate views
• Expand All: Expand all data in the report to view with one easy click
• Excel: Download the entire expanded report into Excel
• Zoho Reports Add-On: Create customized reports you can add to your extendedReach system

Aging Report

This aging invoice report lists the invoice totals in separate columns, helping to differentiate between the total balance, current balance, aging as of 30+ days, 60+ days, 90+ days and 120+ days. This view shows all open invoices and unapplied payment credits. It includes services with or without an associated Claim.

You can expand by Program and then by aging category to view specific details.

Report Options:

• Group By: You can view the aging report using a selected Grouping option
• Invoice Date
• Case Name (Client)
• Payer Name (Funding Source Bill To or Client Name)
• Insurance (Primary Insurance)
• Caseworker
• Service Date
• Category

Aging Report as of Date: You can view the aging report as of a specific date by clicking on the "Aging Report as of Date". A pop-up will then appear where you can enter the date you want to view. To view all posted balances, make sure "Show posted balances" is checked. If you do not want to include posted items, uncheck that option.

• • Once you click on "Submit", a PDF of the aging report will generate. The Aging Categories will be limited to Current, 30+, 60+ and 90+ days categories only.

Unpaid Claims

This aging claims report list the claim totals in separate columns, helping to differentiate between the total balance, current balance, aging as of 30+ days, 60+ days, 90+ days and 120+ days. This report only shows balances associated with open, unpaid claims. 

This view can be grouped by Client Name, Date or Payer (Current Payer on Claim).

Authorizations

This report displays any active authorizations grouped by Program for current clients only. For purposes of this report, active means the auth still has a remaining balance available and has not been moved to Inactive status.

Additional sorting options include:

• Active By Date
• Active by Date Expiring
•  Active by Name
•  Active by Balance
• Pending by Date

**Note: Active vs Inactive authorization in not determined by Date Expiring but by status change. Once an Authorization is moved to Inactive, any remaining units on that Auth are no longer available for use. Under System Settings> System Configuration your agency can control preferences for how long an Auth should stay active after the expiration date. Closed Authorizations can be made Active/Inactive by editing the Auth.

Average Fee

Average fee per units recorded. Can be viewed by Year, Program, Activity and Month.

Branch Balances

Outstanding balances by Program with Amount, Date, Organization and Bill To/Client Name information.

Claims: Rejected

All claims that have been rejected/denied. A Claim Status can be moved to Rejected by editing the Claim Status based on information you have received or from posting an 835 remittance for a $0 payment within eR. This report lists the number of claims currently in Rejected Status grouped by Year, Program, Rejection Reason (if specified), and Payer on Claim with details on Amount, Date, Organization, Client Name, and link to review/edit claim details. Also includes percentage breakdown for rejection trending. If the Rejection Reason is listed as Not Specified, it can be updated by editing the Claim and selecting a Reason. Reasons can be configured by your agency.

Once the claim status is updated to Submitted, Paid or Resubmitted the claim will no longer appear on this list unless new rejection information is received/entered.

Credit Balances

Outstanding credit balances list invoices that have an overpayment applied resulting in a credit balance. Credit balances can be transferred to other open invoices or refunded using the appropriate Adjustment type (Transfer Credit Balance or Refund).

Payments: Insurance

Insurance payments received

Payments: Unapplied

Payments received that have not been applied. Unlike Credit Balances (where the funds have already been applied to an invoice and created an overpayment) Unapplied Balances are payments where the amount has not been fully applied to invoice(s) and there is still an available balance left to apply. The most common scenario is for payments received in advance of services rendered where the invoices may not yet exist at the time of payment. Unapplied payments can be applied at anytime by editing the payment and applying to an open invoice.

Payments: Other

Miscellaneous payments received that are not Insurance payments.

Posted: Adjustments

All adjustments that have been posted to the agency’s accounting system

Posted: Payments

All payments that have been posted to the agency’s accounting system

Posted: Prepaid Funding

All prepaid fundings that have been posted to the agency’s accounting system

Posted: Receivables

All receivables that have been posted to the agency’s accounting system. (Total charges less payments/adjustments/write-offs)

Posted: Revenue

All revenue generated from activities that has been posted to the agency’s accounting system. (Total charges)

Posted: Transfers

All Internal Transfers that have been posted to the agency’s accounting system. Only available/needed when Transfer Accounts are used for agencies that may need to move revenue between departments where they are not expecting payment. These are transfers specific to Adjustment Type= Internal Transfer that move a transaction from one General Ledger to another (credits receivable to internal credit ledger account to not expect payment)