Final Invoices Available vs. Actual

Report Overview

You can use this report in two ways.

Report type options are provided on the parameter page, as indicated in the image below.

Data is available beginning January 1, 2015.

Journal Entry

If you select the Journal Entry report type, you can view pertinent information in the form of journal entries. There are two journal entry report types. You can choose between the Journal Entry report type and the Journal Entry by Profit Center report type. The Journal Entries report summarizes all revenue. The Journal Entries by Profit Center report breaks out revenue by profit center.

Select the desired report type form the report's parameters page, as shown below.

Here is a sample of the Journal Entries report:

Here is a sample of the Journal Entries by Profit Center report: 

Summary Report Sections

The report is composed of several sections, including:

Total Invoices Available vs Collected Summary

The Total Invoices section summarizes the three sections covering current invoices, prior invoices, and future invoices. The total Adjusted Avail to Collect represents all invoices, current and prior, available to collect after adjustments. The % Collected vs. Availableshows the percentage of available invoices collected for the month.

The % Coll vs. Avail does not include RFC collections in the calculation. Invoices that are sent to collections are no longer considered available to collect.

To get the percentage shown:
1. Numerator = Total Invoices – (CM + PM + FM RFC Collected Invoices)
2. Denominator = Total Adjusted Available to Collect
3. Multiply the number times 100.

Member accounts that were in RFC status prior to the month selected are not included in the Current Invoices section unless a payment has been made to the account in the month selected. If no payment has been made, past due invoices are only incorporated into the Prior Invoices section. However, accounts placed in RFC status during the month selected are displayed in the Current Invoices section.

Current Month Invoices Available vs Collected Summary

This section displays the invoice amounts that were available to collect in the selected month and provides the total amount collected as well as the percentage collected. You can see this information by profit center and as a total for all profit centers.

Column Column Description
Initial Avail to Coll The value of current month member billings as of the beginning of the month.
Change Changes to current month member billings that occur during the month. Changes are often due to changes in member agreements.
RFC Change Current month member billings that have been returned for collection (RFC) during the month.
Adjusted Avail to Coll The net value of current month member billings as of the end of the month. This value is net of Initial Avail to Coll, Change, and RFC Change.
Total Current Collections Collections on current month member billings, Adjusted Avail to Coll.
Total Collections All collections on current month Adjusted Avail to Coll.

Prior Month Invoices Available vs Collected Summary

The Prior Month Invoices Available vs Collected Summary summarizes past due invoices, comparing the amount available to collect to the amount actually collected.

Column Column Description
Initial Available to Collect Value of the prior outstanding (i.e. delinquent, accounts receivable) member billings as of the beginning of the month.
Change Changes to the prior member billings that occur during the month. Changes are often due to changes in member agreements.
RFC Change Prior member billings that have been returned for collection (RFC) during the month.
Adjusted Avail to Coll The net value of prior member billings still outstanding as of the end of the month. This value is net of Initial Available to Collect, Change, and RFC Change.
Collected Prior Invoices Collections on prior member billings, Adjusted Available to Collect.
RFC Collected Prior Invoices Collections on prior invoices after they reached RFC status.
Total Prior Collections All collections on prior months Adjusted Invoices Available to Collect.

Future Invoices Available vs Collected Summary

The Future Invoices Available vs Collected Summary shows paid-ahead invoices and provides the total future invoices collected for the current month.

Column Column Description
Collected Future Invoices Collections in excess of all outstanding invoices, which are applied to future invoices.
RFC Collected Future Invoices Changes to the prior member billings that occur during the month. Changes are often due to changes in member agreements.

Accounts Receivable Reconciliation

The Accounts Receivable Reconciliation section provides the Ending A/R after Adjustment. The Ending A/R after Adjustment is found by combing the Calculated Ending A/R with Other Adjustments.

The report captures data as it was at the end of the month selected on the parameters page. If an account was in RFC status at that time, it will appear that way in the report even if it has since been brought back into good standing. Additionally, any accounts for members who joined during the month selected will not appear in the report.

Drill-Down Reports

Each profit center name is formatted as a hyperlink leading to a drill-down report. The drill-down reports provide a listing of members included in that profit center. The data is displayed in the same format as the main report.

You can view a sample drill-down report below.

Sample Report

Here is a sample of the Final Invoices Available vs Actual report.