Paylogic reports help in analyzing the numbers recorded in the system and derive valuable output. There are various reports available within Paylogic.
To access the reports available within Paylogic, go to the ‘Report’ section on the main screen.
All the reports are separately covered in the further articles and details of each report is found on the following pages.
- Payout Report
Payout Report shows the confirmed payouts for each Adviser Groups, including details of the monetary payout of those Adviser Groups. It shows the amount to be paid and any splits or fixed fees applicable for the payout for the Adviser Group.
- The Payout report screen shows the monthly calendar with the dates marked in 'Green' to show the dates on which payouts have already been confirmed.
- To view the Adviser Group payout details, click on the date and the payout report will be displayed below.
- Click on the Adviser Group Name to view the details of Total Payouts and the Final Payable Amount.
- The Payout report screen provides other options to unconfirm (delete) the payout and to download the data.
- Unconfirm All tab allows to unconfirm the payout for all the adviser groups (if payout confirmed for more than 1 adviser group) made on the specific date.
- ‘Download ABA’ tab downloads the Australian Bankers Association report. This report shows you the amounts to be paid to each adviser and can be used to upload to your bank for the physical processing of your payment.
There are 3 tabs besides the Adviser Group name.
- The first tab allows you 'Unconfirm Payout' for a specific Adviser group.
- The second tab showing ‘XL’ allows you to download the Payout report in Excel format.
- The last tab showing ‘PDF’ allows you to download the Payout report in PDF format.
- Licensee Income
Licensee Income is a report which displays the total income retained by Licensee after paying to Adviser groups and Referrers including any fixed fee charges from Adviser groups.
The steps to generate the Licensee Income Report are:
- Select the date range for the period you wish to generate the report.
- Click on the 'Submit' button.
- A grid will be displayed showing the Licensee Income disbursed based on the chosen Adviser groups.
Click on the icons to download the report in various formats that meet your needs (excel and pdf).
Total Amount Received (Excluding GST) - Amount Received by Licensee through Revenue Statement.
Paid to Adviser Group (Excluding GST) - Amount paid by Licensee to Adviser group as per the split applied.
Paid to Licensee Referrer (Excluding GST) - Amount paid by Licensee to Licensee Referrer as per the split applied.
Retained by Licensee (Excluding GST) - Amount retained by Licensee after paying to Adviser groups and referrers.
Total Fixed fee Charged to Adviser group (Excluding GST) - Fee charged by the Licensee on Adviser groups.
Total Licensee Income (Excluding GST) - Total of fixed fee charged and income retained by Licensee after paying to Adviser groups and Licensee Referrer.
A bar chart is displayed showing the Licensee Income retained based on Adviser groups below the grid.
You can download the graph in various formats, see the below screenshot.
- Adviser Product Analysis
This report shows the income received for different products before any splits have been applied, grouped by the 'Adviser' and 'Adviser Group'.
Once the Data is confirmed in ‘Process Payout Section’ at Licensee level you can download the Adviser Product Analysis’ by following these step:
- Go to ‘Reports’
- Select the date range for the period you wish to generate the report.
- Click on the 'Submit' button.
- A grid will be displayed showing the Licensee Income disbursed based on Adviser groups.
5. Click on any group and it will further show the Licensee income based on different advisers sitting under the Adviser group.
6. You can download the report in various formats (excel and pdf) by clicking on the relevant icon.
- Payment Banking Report
Payment Banking Report refers to a Report which shows the amount paid to the Adviser Group for a specific period. It shows the final payable amount which is to be deposited in the bank for an Adviser group after the final confirmation of the payout.
To access the Payment Banking Report, follow the below steps:
- Go to ‘Reports’
- Select the date range for the period you wish to generate the report.
- Click on the Submit button.
Once the date range is selected, the report will show the banked amount for the particular Adviser Group.
- You can download the report in various formats (excel and pdf) by clicking on the relevant icon.
- Product File Summary
Product File summary shows the amount per product provider which is confirmed for a specific period. It also provides an option to view the Product Provider amount confirmed for an Adviser Group or a product provider.
It shows a detailed analysis of the uploaded amount of a Product provider and the status of the payment.
Total shows the uploaded amount of the Product Provider.
The payable amount shows the amount which is uploaded but not confirmed as a payment in the period.
The paid amount shows the amount which is uploaded, confirmed and paid for the product provider.
Unmapped shows the amount which is uploaded but is not paid as the transactions is not mapped to an Adviser.
To generate a Product File Summary Report, go to:
- ‘Reports’
- Select Product File Summary
- Select the date range for the period you wish to generate the report.
- Select the Adviser Group in the ‘Select Adviser Group’ dropdown’ if the report is to be generated for a specific Adviser Group and Check All to show the report for all the Adviser groups.
- Select the product provider in the ‘Product Provider’ dropdown’ if the report is to be generated for a specific Product Provider and Check All to show the report for all the Product Providers in the particular period.
- Click on the Submit button.
Once the Submit tab is clicked, it will display all the records and the status of payments.
You can download the report in various formats (excel and pdf) by clicking on the relevant icon.
- New Accounts Report
The New Account Report helps you to recognize the new clients which have been recorded in PayLogic for the first time.
This report shows all the new clients and transactions with the Product Provider and the Client Account Code.
To generate the New Accounts Report, go to:
- ‘Reports’
- Select New Accounts
- Select the date range for the period you wish to generate the report.
- Select the Product Provider in the Product Provider dropdown to generate a report for any specific Product Provider. (you can select all if appropriate)
- The statements dropdown shows the uploaded statement/s for the selected period.
- Client Account Code dropdown shows the newly recorded Client codes in PayLogic.
- Click on the Submit button to save the changes.
Once the Submit tab is clicked, it will display all the records for the new clients for the selected period.
You can download the report in various formats (excel and pdf) by clicking on the appropriate icons.
