Conditions that must be met by an invoice to be included in a revenue report:
Exemplary situation to illustrate calculations for each of the revenue reports type.
Total paid amount is divided over 13 months equally. The received amount is the monthly earned revenue and is included in the report for every month of the service duration described on the invoice.
February: 1000/13 = 76.92
March: 1000/13 = 76.92
*(see screenshot for all details)
The report shows the amounts that are deferred per month. The value is calculated for every month of the service duration separately, based on the previous month calculation result.
February: 1000 - (1000/13) = 923.076931
March: 923.08 - 76.92 = 846.1538462
*(see screenshot for all details)
Total amount paid one time included in the report for the month of payment only.
February '23: 1000
The payment for the item is not included in further months calculations.
See the table below for visual comparison of each report calculation method:
Displaying the amounts on unpaid invoices for the selected point in time. It provides an overview of invoices that are either not paid at all or paid after the due date.
A clear report presenting the current aggregate of credits for each individual client.
This report comprises a detailed record of all transactions recorded within the specified date ranges in the system.
This report displays all placed orders, which can be filtered, for example, by their status.
Important Notes!
1. Items that are of different types or have no dates in description are included only once in the report for the month of creating the invoice.
2. In case no data is displayed in the reports, please update your WHMCS Connector to the latest version available.