To assist in your finance teams reconciliation of balancing your revenue to the payments paid and any payment outstanding, there's a few reports that will help provide with the information you'll need to look into this.
STEP 1: To start, you'll want to find out how much revenue you took for a particular date range in the past and/or what you're forecasted as of that day to have for Revenue Dates in the future.
To do this head to Reports > Sales > Revenue Allocation Summary:
Filter this report to the Revenue Date range you're looking at i.e. 1st May to 31st May - Refer to this guide for full details about this report
The Total figures at the top are broken down by Paid / Unpaid and Total. Depending how many Revenue Centres you have you'll want to scroll all the way to the right to find the Total Revenues.
The Total Revenue figures are looking at Total Net. To find the Total Gross figures, this will need to be exported into a CSV document. The Export button can be found at the top right of the report.
STEP 2: To then match the revenue, you will need to head to the transactions report which will contain every transaction taken through the Trybe system.
To do this head to Reports > Finance > Transactions:
This report is defaulted to 'Transaction Date' but you will need to change this to filter by Revenue Date. To do this select 'Add Filter' > change to Revenue Date > enter your date range. Then remember to use the 'x' next to the Transaction Date filter to remove this. Refer to this guide for full details about this report.
You'll want to Export this using the Export button in the top right of the report.
When you have downloaded and opened the export into an Excel document, we would recommend removing any recurring ‘membership’ payments (as the revenues for these are not included in the first report). To do this, find Column D (Type) to remove 'Membership' so that you're only filtered to view all transactions from Orders.
Then go to Column L (Amount) to sum the amount of payments.
These reports should balance but if there are any discrepancies such as Overpayments or Outstanding payments, you can use your Orders page > filter to the Revenue Date to then comb through the Orders to find the discrepancy.
Best report to work out Commissions owed to my Therapists
If your Therapists are owed Commissions on the treatments they provided. You can find a list of all the Appointments taken within a Date Range, the Therapist who took the Appointment and the revenue of that Appointment.
To do this head to Reports > Sales > Sold Items
This report will list every item sold in a date range format which can be exported as a full CSV document and from there you will be able to filter by ‘Practitioner’. See guide here. Please note that the Sold By column will be taken from the Commission section on the Order, and may not necessarily be the practitioner who provided the treatment -
In the export, you can then filter by a particular Practitioner in Column O and then sum up the values in Column U (Cost) and/or Column W (Cost minus Discount).