This detailed report represents what you have been billed for along with a reference list of all the invoices raised during a month.
The key difference between the Commission Report and Invoice Report is that the Commission Report represents all the recovered failures including the payments for the invoices that were raised in any other month previously but were recovered via a payment attempt in the selected month, whereas, the Invoice Report represents the status of all the invoices raised in the selected month.
Follow the steps mentioned below to generate the report:
Login to your Receivables account .
Go to Reports > PFR Reports
Click PFR Invoice Report
Select the Year and Month for which you want to generate the report.
Select the user to whom you want to send the report. Select You from the list if you want to receive the email.
Enable Subscribe for a monthly report if you want to receive the PFR Invoice Report monthly.
Click GENERATE REPORT. You will receive an email with a link as a CTA to download the report.
In the email, click Download Report, and you will have the report file downloaded in your system.
Let us dive deeper into the columns and rows of the report:
Similar to the PFR Commission Report, this report also contains two sheets - Summary Report and Reference Invoice Report. While the Summary Report shows a summary of the report with numerical data for your invoices raised during the month, the Reference Invoice Report shows the details of all the invoices, including fields like month billed, invoice status, retry status, payment attempted date, and more.
The summary report is divided into three sections - Payments Attempted, No of Customers and No of Invoices. Each of these sections is connected to the following columns:
| Column | Description |
|---|---|
| Total Billed | The total amount of invoices that were raised during the selected month. |
| Total Payments Received | The total amount that was paid by the customer out of the total billed during the selected month. |
| Payments in Progress | The total amount of payments which are unpaid out of the total billed and is in progress. |
| Total Unrecovered Failures | The total amount of payments that failed and are yet to be recovered. |
| Retries in Progress | The total amount of unrecovered failed payments whose retries are in progress. |
| Retries Exhausted (Unrecovered) | The total amount of unrecovered failed payments for which retries are exhausted. |
| Engaged via Receivables (Overall) | The total amount of payments out of the total failed that were engaged via Receivables. |
| Total Saved | The total amount of recovered payments out of the total failed payments that were engaged via Receivables. |
This report is not as complex and interconnected as the Commission Report as it does not have a fully connected step-down funnel. It simply represents necessary bits of information about the invoices raised in the selected month in the form of columns connected to each other partially as listed below.
This report has two sets of connected columns that form separate funnels:
Set 1 - Total Billed, Total Payments Received, and Payments in Progress:
Here, the Total Billed represents the total amount of invoices that were raised or billed during the selected month, and out of the total billed, the Total Payments Received is the amount that the customer has already paid and the pending payments lie under Payments in Progress.
Set 2 - Total Unrecovered Failures, Retries in Progress, Retries Exhausted (Unrecovered), and Engaged via Receivables (Overall):
Here, the Total Unrecovered Failures represents the total amount of payments out of the total billed that failed but is still unrecovered. Out of the total unrecovered failures, the Retries in Progress shows the payments for which retries are in progress. Out of the Total Unrecovered Failures, the payments that have all retries exhausted fall under Retries Exhausted (Unrecovered).
Set 3: The overall payments that were engaged via Receivables fall under Engaged via Receivables (Overall). Out of which, the Total Saved indicates the total amount of payments that were recovered after failing.
Once you have understood this, let us see how you can map the rows and columns of the report:
Example 1: On the left, you have As % of Total failed, and we have 100.00 as the value under the column Retries Exhausted (Unrecovered). This represents that 100% of Total Failed payments (row) had Retries Exhausted (column).
Example 2: On the left, you have As % of Total billed, and we have 11.00 as the value under the column Total Unrecovered Failures. This represents that 11% of the Total Billed invoice payments (row) had failed payments and are still unrecovered.
Similarly, you can map other rows and columns and get the proper context of the values under them.
Also, the No of Customers section contains the data in terms of the percentage of the number of customers, and the No of Invoices includes the data as a percentage of the number of invoices.
Let us understand these sections with an example for each section:
No of Customers - Example: On the left, we have As a % of Total billed with a value of 85.00 under the Total Payments Received column. This represents that 85% of the total billed customers (row) had already paid and their payments have been received (column).
No of Invoices - Example: On the left, we have As a % of Total billed with a value of 79.00 under the Total Payments Received column. This represents that 79% of the total billed invoices (row) are already paid (column) in the selected month.
The second sheet under the workbook is the Reference Invoice Report which contains all the essential fields to dive deeper into the report. You can find all the customer and invoice-specific details in this report including details such as Month Billed, Invoice Status, Subscription Status, Payment Status, Retry Status, Last Payment Attempted Date, and more.
