This page serves as a comprehensive reference for understanding key metrics within the revamped MoeGo Insights reports. It is designed to help you accurately interpret your data, track performance, and make informed business decisions with confidence.
Related Reading:
Report Metric Definition
1. Finance Reports
All finance reports display data based on the payment transaction date—that is, the date the payment was processed, not when the service was performed.
⚠️ Note: The payment date may not align with the sales date of an appointment, especially if payments are processed at a different time than when the service was rendered.
Currently Finance Report doesn't include a specifc column for no-show fee and memberships. However, the total collected/total payment will include these fees.
Payment Summary Report
Provides a high-level view of total payments collected, broken down by payment method, payment date, or sales date.
Metric | Definition | Formula |
Total Collected | The total amount received from all invoices (fully or partially paid), accounting for any refunds. |
|
Total Service/Add-on/Service Charge/Product/Package Sales | Net sales for the specific category. | Total Sales = price listed on invoice Sales will only display the paid amount in the payment summary/transaction report
|
Total Processing fee by client | The processing fee you've collected from clients (MoeGo Pay fee by client) | According to the processing fee rate you've set up in MoeGo Pay > Credit card processing fee setting |
Total Processing Fee | The processing fee amount MoeGo Pay deducts from your MoeGo Pay balance before sending out your payout | MoeGo Pay Processing fee Rate |
Total Tips | Total Collected Tips |
|
Total Taxes | Total Collected Taxes |
|
Total Deposit | Total Collected Deposit |
|
⚠️ Important Note:
Avoid directly comparing the Payment Summary Report in the revamped reporting system with the Sales by Payment Method report from the legacy version.
There may be data discrepancies due to differences in data synchronization timing and reporting logic.
The Payment Summary Report displays data based on the payment transaction date (i.e., when the payment was processed).
The Sales by Payment Method report (legacy) displays data based on the sales date, typically aligned with the appointment start date.
Additionally, this report does not include sales from retail items, packages, or memberships, which may result in differences when compared to the revamped reports.
Payment transaction report
Payment Amount | The total amount received from all invoices (fully or partially paid), accounting for any refunds. | Payment Amount = Total Service&Add-on Sales + Service Charge Sales + Total Tips + Total Taxes + Total Processing fee by clients (+ package/membership/product sales if any) |
Total Service/Add-on/Service Charge/Product/Package Sales | Net sales for the specifc category. This will be displayed as a negative number if the Transaction Type is Refund | Total Sales = price listed on invoice Sales will only display the paid amount in the payment summary/transaction report
|
Total Processing fee by client | The processing fee you've collected from clients (MoeGo Pay fee by client) | According to the processing fee rate you've set up in MoeGo Pay > Credit card processing fee setting |
Total Processing Fee | The processing fee amount MoeGo Pay deducts from your MoeGo Pay balance before sending out your payout | MoeGo Pay Processing fee Rate |
Transaction Type | Each transaction will be categorized as Sale or Refund, depends on the processed transaction
|
|
Payment Method | Options: Credit Card/Cash/Venmo, etc. All the payment methods you've used for each specific payment. |
|
Charge Status | Charge status for each transaction record will be recorded as Success or Failed. |
|
invoice ID/Booking ID | Unique ID for each invoice or appointment. You can click on the ID to view more details for invoice/appointment |
|
Transaction Date/Time | Date and time the transaction is processed |
|
Sale Date | The appointment start date or the product/package sale date |
|
2. Sales Report
All Sales reports display data based on the sales date--- appointment date, or sales date for retail, package, and membership.
Sales summary report
Metric | Definition | Formula |
Total Expected | The invoice total amount includes service/add-on price, service charge, tip, tax, and deducting discount. | Total Expected = Total Net Sales + Total Tips + Total Taxes + Total Fees
|
Total Unpaid | Invoice unpaid balance | Sum all invoice remaining unpaid balances |
Total Gross Sales | Service Price before Discount | Total Service Price on invoice (includes all service items, service, add-on, product, and package) |
Total Net Sales | Service Price after Discount | Total Service price - Total Discount |
Total Collected | The total amount received from all invoices (fully or partially paid), accounting for any refunds. |
|
Total collected fees | The processing fee you've collected from clients (MoeGo Pay fee by client) | According to the processing fee rate you've set up in MoeGo Pay > Credit card processing fee setting |
Total Collected Tips | Total Collected Tips |
|
Total Collected Taxes | Total Collected Taxes |
|
Total fees | The processing fee listed on the invoice that you will be collecting from clients (MoeGo Pay fee by client) | According to the processing fee rate you've set up in MoeGo Pay > Credit card processing fee setting |
Total Tips | Total Tip amount listed on all invoices |
|
Total Taxes | Total Taxes amount listed on all invoices |
|
Total Deposit | Total Deposit |
|
Total Discount | Total Discount listed on invoice |
|
Total Refund | Total Refunded Amount |
|
Sales invoice report
Metric | Definition | Formula |
Invoice/Client ID | Unique ID for invoice or client. You can click on the ID to check more invoice details or client profile details. |
|
Total Expected | The invoice total amount includes service/add-on price, service charge, tip, tax, and deducting discount. | Total Expected = Net Sales + Tips + Taxes + Fees
|
Total Unpaid | Invoice unpaid balance | Sum all invoice remaining unpaid invoice balances |
Total Collected | The total payment listed in the invoices. | Total Collected = Net Sales + Collected Tips + Collected Taxes + Collected Fees |
Gross Sales | Total Service Price before Discount (includes all service items, service, add-on, product, and package)
| Gross Sale = Total Service price
|
Net Sales | Total Service Price after Discount
| Total Service Price - Total Discount
|
Service/Add-on/Service Charge/Product/Package Gross Sales | Specifc item (service/add-on/service charge/product/package) Price before discount |
|
Service/Add-on/Service Charge/Product/Package Net Sales | Specifc item (service/add-on/service charge/product/package) Price after discount |
|
Collected Fees | The processing fee you've collected from clients (MoeGo Pay fee by client) | According to the processing fee rate you've set up in MoeGo Pay > Credit card processing fee setting |
Collected Tips | Total Collected Tips |
|
Collected Taxes | Total Collected Taxes |
|
fees | The processing fee listed on the invoice that you will be collecting from clients (MoeGo Pay fee by client) | According to the processing fee rate you've set up in MoeGo Pay > Credit card processing fee setting |
Tips | Total Tip amount listed on invoice | For Boarding:
|
Taxes | Total Taxes amount listed on the invoice | For Boarding:
|
Deposit | Total Deposit |
|
Discount | Discount listed on invoice |
|
Refund | Refunded Amount |
|
Service/Add-on/Package/Product Taxes | The portion of Taxes for specific items |
|
3. Appointments Report
All Sales reports display data based on the appointment date; only sales related to appointments will be displayed.
Retail, package, and membership are not included in these reports.
Grooming Appointment Summary Report
Metric | Definition | Formula |
Total Appointments | All appointments created, including cancelled and no-show appointments. |
|
Total client/pet serviced | Total number of clients/pets serviced (includes duplicates). |
|
Total Net Sales | Total Grooming Service Price after Discount ( add-on sale is not included) |
|
Average Price per ticket
| Average service price per invoice, excluding canceled appointments. | Average Earnings per Ticket = Total Net Sales / Number of appointments |
Average Tip Rate | Total tips received from non-canceled appointments divided by total gross sales. | Sum tip/Gross Sales |
Online Booking Rate | Percentage of appointments created via online booking among all appointments within selected date range |
|
Average Rebook Rate | Percentage of clients who have a future appointment scheduled out of all clients. | Average rebook rate = Number of rebooked clients / total clients with appointments |
Grooming/Boarding/Daycare Appointment List Report
Metric | Definition |
Average Review Score | The review scores received for the appointment. |
4. Employee Report
All employee reports display data based on the appointment date/sales date.
Staff performance report
Metric | Definition |
Average earnings per staff | Average net sale per staff per day. Average Earnings per Staff = Total Net Sales / (Number of Staff * Working Days) |
Average earnings per ticket | Average net sale per invoice, excluding canceled appointments. Average Earnings per Ticket = Total Net Sales / Number of appointments |
Average earnings per pet | Average net sale per pet serviced (de-duplicated). Average Earnings per Pet = Total Net Sales / Number of Pets Serviced |
Average earnings per day | Net sale/number of days within selected date range. |
First-time client | Have 1 upcoming or 1 finished appointment within the selected time range. |
Returning client | Have more than 1 finished appointment within the selected time range. |
Utilization | Total estimated hours divided by total working hours for each staff |
Grooming report sent rate | The percentage of completed appointments for which a grooming report was successfully sent to the client.
|
Average tip rate | The total sum of receivable tips from non-canceled appointments / Gross sale. |
Rebook rate by pet/clients | The percentage of pets or clients who had at least one completed appointment during the selected period and at least one future (non-canceled) appointment scheduled after that period, divided by the total number of pets or clients with at least one completed appointment in the selected period. |
5.Clients Insight
Summary view to understand client distribution and behavior in each demographic.
Client & pet summary
Metric | Definition |
Prospect clients | Have a profile created but no |
First-time client/pets | Have 1 upcoming or 1 finished appointment within the selected time range. |
Returning client/pets | Have more than 1 finished appointment within the selected time range. |
Second-time Client/pets | Have 1 finished appointment before the start time of the selected time period. |
Client on Recurring Schedule | Client scheduled with repeat appointments series. |
Rebooked clients | Clients who had at least one completed appointment during the selected period and at least one future (non-canceled) appointment scheduled after that period. |
Average Review Score | The average review scores received for the group of clients. |
Frequently Asked Questions
Why is the sales number in “Total Collected” on the Dashboard different from the “Total Collected” in the Payment Summary Report in the same period?
The Dashboard is based on the appointment date, whereas the Payment Summary Report is based on the transaction date. This can cause a discrepancy between the two totals.
Which sales metrics I can refer to when I need to exclude taxes and tips?
Gross Sales and Net Sales do not include taxes and tips.
Why the “Total Appointments” metric is higher than their “Total Bookings”?
Total Appointments includes all appointment statuses, whereas Total Bookings only includes completed appointments, excluding canceled and no-show statuses. Therefore, Total Appointments are usually higher than Total Bookings.