Revenue By Category
The revenue by category report provides a breakdown of the business' revenue by the categories of income as defined in the system settings. Revenue by category allows the business to track the source of the operating revenue, determine levels of revenue provided by the categories of data allowing them to manage the money appropriately and to make informed business decisions.
Learn how to add billing categories in this support document.
How to Generate the Report
The options available for the generation of this report include the report period selected and the Category Options, as described below. Once the selections are made, you will select the Generate Report button.
| Report Configurations | Options | Description |
|---|---|---|
| Report Period |
All Dates Custom (user defines) This Week This Month This Quarter This Year Yesterday Last Week Last Month Last Quarter Last Year |
Choose which inclusive dates are needed for the report data. Selecting All Dates will use all invoices and payments in the system for generating the report. Select any of the custom options for obtaining a report based on a time period, or define your own Custom time period. |
| Category Options |
Hide Categories that do not have data during the report period Hide line items billed per category |
Checking the first box, hide categories with no data during report period, will filter out all the categories with zero values across the board. Checking the second box, hide line items billed per category, will filter out all line item breakdowns below the category level and summarize the data at the category level. |
If the Report Period is changed after the report has been generated, the report must be regenerated by selecting the Regenerate Report button. The data will not be updated until that action is taken.
How to Read the Report
Once the report is generated, the exact date and time the report is generated is shown under the report title. There is a button called More in the upper right giving options to Print the report or Download CSV for capturing the data.
The contents of the report provides the billing information about each category. The report is divided into sections for each category, as described below.
The bottom line of the report gives the totals for each of the columns.
| Report Data | Detailed Data | Description |
|---|---|---|
| Invoice Balances |
Invoiced Paid Outstanding |
Based on the period selected, these columns will show what was invoiced and amounts collected during that period only. The last column gives the Outstanding amount for that category on the invoices issued during the specific report period. |
| Revenue Collected |
Pre-tax Total |
This is the total amount collected during the period, even if the collected amount is not part of what was invoiced during the period. This could include, for instance, overpayments on an invoice, or payments from invoices posted prior to the defined report period. The first column provides the revenue calculated pre-tax, and the second column includes the tax collected on the category. |
It is important to know that charges such as late fees on an invoice are not included in the revenue by category report, they are not allocated to any specific categories. Line item discounts, invoice level discounts and credits used are reflected in the category totals.
