MA030: Service Profitability Analysis
The MA030 displays profit percentages for services that were performed within the date range. Service costs are based on what was entered in the Cost Per Service field in the service definition.
Tip: Run the MA030 monthly to view the profitability of each service.
When reading this report:
- You want your Profit % to be high. The higher this number, the more profit your business earns when that service is performed.
- If you see a Profit % of 100% for a service, that means the Cost Per Service on the definition is probably set to $0. You should address this by entering an accurate Cost Per Service on that service definition (unless of course it actually costs $0 to perform that service).
- Negative percentages can occur when the Cost Per Service exceeds the price being paid for it. You can address this by increasing the service price to recoup costs, or by somehow reducing the Cost Per Service.
Report definitions
Total for date range
- Qty: The sum of all Service Category Qty subtotals. This field does not consider refunds.
- Income: The sum of all Service Category Income subtotals. This field does not consider refunds.
- Refund Issued: The sum of all Refunds Issued subtotals.
- Refund Amount: The sum of all Refund Amount subtotals.
- Total Income: The sum of all Total Income subtotals.
- Total Cost: The sum of all Service Category Total Cost subtotals.
- Profit: The total profit for the date range. (Income ‒ Total Cost)
- Profit %: The total profit percentage for the date range. (Total Profit / Total Income) * 100
Service Category list
- Qty: The number of times that service was performed in the date range. This field does not consider refunds.
- Income: The service sales amount, not including refunds.
- Refund Issued: The number of full or partial refunds that were issued.
- Refund Amount: The amount that was refunded. Partial refunds function as a discount that was supposed to be given but forgotten at the time of sale.
- Total Income: (Income ‒ Refund Amount)
- Cost Per Service: The amount defined in the Cost Per Service field of the service definition.
- Total Cost: (Cost Per Service * Qy)
- Profit: (Total Income ‒ Total Cost)
- Profit %: (Profit / Total Income) * 100
Setting up the MA030 report
- Type MA030 in the Convobar, or go to Meevo > Reports > Analytical, and then select the MA030 report.
- Select a date or date range for running the report:
- To run a report for a specific date range, select Custom and specify the Start Date and End Date for the report.
- Otherwise, select a predefined date or range (Yesterday, This Week, Last Week, etc.).
Note: If you select a predefined range (a date other than Custom), you can still change the Start Date and End Date. Doing so automatically changes the date range to Custom.
- All Service Categories: Select All Service Categories to run the report for all categories. To run the report for specific Service Categories, deselect the option and use the drop-down to select which you'd like to run. Not selecting any Service Categories will run the report for all of them.
Running the report
- When you are ready to generate the report, select a Report Format beside the Run Report button.
- Here is a rundown of each format type:
- PDF: Each time you select Run Report with PDF selected, Meevo opens a separate browser tab that displays the PDF'ed report. Meevo remains on the setup page, so you can quickly jump back over to Meevo to run more date ranges or other reports. Each PDF report you run will open its own browser tab, so you can easily review and compare reports by simply jumping between browser tabs.
- HTML: This is our original legacy format, which opens the report within Meevo. All of the functionality within that report is still there and available via the toolbar.
- XLSX: Each time you select Run Report, your browser auto-downloads the report in .xlsx format. Select the downloaded file in the browser footer to open the spreadsheet.
- Select Run Report to generate the report in your chosen format. Depending on the type of report and criteria you entered, this process may take a few minutes.