Auto Order Rebill Value Report

Navigation

Overview

The "Auto Order Rebill Value" report generates a spread sheet style report with a break down of the rebill value by item.

Simply click on the report from the Menu to generate the report.

Report Pickup

After clicking on the report you will encounter the following message about navigating to the report pickup area to download the completed report:

Downloading the Report from Report Pickup

Simply click on the download button to download the file you wish to view.

View of the Downloaded Report

This report provides a breakdown by item of the rebill value per month for the auto orders within the account.

Now let's describe each column in the report

ColumnDescription
Age (Months)As rebills occur on an item a row per month will appear in the report starting at 1.  The number of rows is determined by the longest active rebill customer.  In this example we've been rebilling SAMPLEITEM for nine months.
CustomersThe number of customers that have made it through this month.  In our sample data we started out with 925 customers in month 1.  By Month 8 we have only 517 of those customers still actively rebilling.
$ Net During MonthThe amount of net (sales - refunds) money that rebilled during this month.  So we collected $4,297.84 in month 1 and $179.91 in month 8 associated with the rebills of SAMPLEITEM.
$ Net Through MonthThis is the cumulative net value of this month's rebills plus all the previous months.  So by the end of month 8 we have rebilled $12,433.77
Avg. Customer ValueThis is the average value of all the customers by the time this month has rolled around.  So by month 8 we know that the average customer has been worth $13.44.  This number is calculated by the $ Net Through Month column divided by the total number of original customers.  So in our example $12,433.77 divided by 925 gives us $13.44
No Rebills During MonthThe number of recurring orders that fired off during this month associated with the auto order.  So 304 customers rebilled during month 1 and 9 rebilled during month 8.
$ Rebilled During MonthThis is the gross amount of money rebilled to the customer during the month (not reduced for refunds)
No. Rebills Through MonthTotal number of rebills that have occurred cumulatively through this month.  So by month 8 we have rebilled customers 738 total times.
$ Rebilled Through MonthThis is the cumulative gross amount rebilled to the customer through the give month.  So by the end of month 8 we have rebilled $14,772.61.
No Refunds During MonthThe number of refunds that have occurred during the month.  So the first month was heavy with 90 refunds, but in month 7 we refunded zero people.
$ Refunded During MonthThe amount of money that was refunded during the month.
No. Refunds Through MonthThe total number of refunds that have occurred during all the months prior and including this month.  So by month 8 we have refunded 117 transactions
$ Refunded Through MonthThe total amount that has been refunded during all the months prior and including this month.  So by month 9 we have refunded $2,338.84