Useful reports to use for payment reconciliation
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. Refer to this guide for more details on the Orders page and filters.