Introduction
This article will describe the standard financial reports available under the Summaries > Financial menu.
Prerequisites
- Enterprise Financials is enabled and set up.
- If your agency doesn’t currently have this option and you’re interested in learning more, please contact success@extendedreach.com
- Be a Full Administrator or a Restricted Administrator - Billing Administrator with “Access Summaries Menus” on your User Group or User ID
Overview
Outline of Standard Financial Reports in Foster Care
Go to Summaries > Financial to see these reports
Aging Report |
Displays all outstanding balances |
Authorizations |
Lists all active authorizations by Program |
Credit Balances |
Invoices with an overpayment |
Payments: Unapplied |
Payments entered with a balance left to be applied |
Posted: Adjustments |
Adjustments in a posted/closed month |
Posted: Payments |
Payments in a posted/closed month |
Posted: Receivables |
Receivables in a posted/closed month |
Posted: Reimbursements |
Reimbursements in a posted/closed month |
Posted: Revenue |
Revenue in a posted/closed month |
Common Uses
- Aging Report - I want to know my total open AR.
- Authorizations - I want to view all Active Authorizations across clients.
- Reimbursements – I want to view all Reimbursements by Type.
Common Report Features/Options
- Group by - If option is present, open dropdown to select alternate views.
- Expand All – Click to expand and view all data in the report.
- Excel – Click to download the entire expanded report into Excel.
Report Descriptions
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 and 90+ days. This view shows all open invoices and unapplied payment credits. It includes days care and billable activities with or without an associated Claim.
Above screenshot shows the aging invoice report.
You can expand by Program and then by aging category to view specific details.
Report Options:
- Group By: Hover over “Group Aging” to select one of these Groupings
- Branch
- Case Name (Client)
- Collection Category (have “Collection Note” option checked and a Category and Note entered)
- Funding Organization
- Region
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". Enter the desired date on the pop up. To view all posted balances, make sure "Show posted balances" is checked. If you do not want to include posted items, uncheck that option.
Above screenshot shows Aging Report as of Date.
Enter desired date on the pop up and click Submit. The PDF report will generate.
Authorizations
This report defaults to show all active authorizations for current clients, grouped by Program. For purposes of this report, active means the authorization still has a remaining balance available and has not been marked as Inactive.
To see active and inactive authorizations, hover over “Show” and click on “All”.
NOTE: Balance only populates if the Authorization Type is Charge.
Above screenshot shows Authorizations screen.
Click on an Authorization to see details, which includes Authorization Use.
Above screenshot shows authorization use example.
Above screenshot shows authorization use example.
Credit Balances
This report lists invoices that have an overpayment applied resulting in a credit balance. Credit balances can be refunded using the Refund Adjustment Type.
Payments: Unapplied
This report displays payments that have not been fully applied to invoice(s) so there is still an available balance left to apply. This contrasts with Credit Balances, where the funds have been applied to an invoice and created an overpayment. The most common scenario is 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 any time by editing the payment and applying to an open invoice.
Posted reports- the following Posted reports will only populate for months that have been Posted (closed). Posted months appear under Organization Billing > Posting: Posted by Batch.
- Posted: Adjustments
- Posted: Payments
- Posted: Receivables- Total charges less payments/adjustments/write-offs.
- Posted: Reimbursements
-
Posted: Revenue- Total charges.