Revenue Reporting Overview

XPLAN CommPay enables you to view, report on and download revenue received (at XPLAN > Administration Functions > CommPay). You also have the ability to map revenue data to your XPLAN clients and analyse your revenues.

Follow our practical guide on how to use CommPay to produce reports and CSV files for a particular commission statement or for a specified period.

For more information on how to use CommPay, refer to the  XPLAN CommPay User Guide on the Adviser Payment Services page on the BT Adviser Services (BTAS) site.

Revenue reporting

Once a revenue payment is finalised and processed by BTGL’s Adviser Payment Services, revenue information can be viewed, reported on, and/or downloaded from CommPay.

There are three types of reporting available in CommPay:

• Transactions, which enables you to use search filters to view and download transactions across all policies and all clients that you have access to in CommPay. The filters available have been customised by Wealth Axis.
• Reports, which enables you to produce standard reports designed and implemented by IRESS. Adviser Payment Services manages the underlying data in these reports.
• Practice Analysis, which allows you to further analyse your client revenue, and includes visual tools such as graphs and charting.

How do I produce a report for a commission statement?

The Adviser Reconciliation Report displays all revenue applied to policies and client fees for a single specified payment period (or commission statement). It includes all adjustments and auto journals that are applicable for the period. This report also displays a Year to Date payment summary, and enables Practice principals and advisers to identify how and from where client revenues are being received.

To produce an Adviser Reconciliation Report for a particular commission statement:

1. Go to XPLAN > Administration Functions > CommPay > Reports.
   
   
2. Select the Adviser Reconciliation Report.
   
   
3. In the Filtering section:
   
   
   • For Report Type, select  Detailed.
     
     
   • For Group By, select  Revenue Type.
     
     
   • For Supplier Amount, select Gross Amount.
     
     
   • For Report File Type, select PDF.
     
     
     
     
4. In the Period section:
   
   
   1. In the Payment Year dropdown list, select the year required.
      
      
   2. In the Payment Period dropdown list, select the commission statement required.
      
      
      • The Wealth Axis Financial Year runs from October to September, and payment periods have been set up in CommPay accordingly.
        
        
      • You are only able to produce a report for one commission statement period at a time. To produce a single report on two or more commission statements, you will need to use the Transactions report.
        
        
        
        
5. In the Account section, select the required Adviser from the dropdown list.
   
   
   • If All is selected, an individual report will be produced for each Adviser that you have access to.
     
     
     
     
6. Click OK .
   
   
7. The report will be generated in the background. Click OK .
   
   
8. When the report has been generated, click  to display the new system message.
   
   
9. Click Download to download and view the generated report.

How do I view or download the details of a commission statement?

To view or download the details of a commission statement:

1. Go to XPLAN > Administration Functions > CommPay > Transactions.
   
   
2. In the Account section, select the required  Adviser from the dropdown list.
   
   
   • If All is selected, the CSV file will contain revenue data for all Advisers that you have access to. However, the CSV file may fail to generate if the file size is too large. Subsequently, if you would like to download data for more than one Adviser, you may need to produce multiple CSV files (one for each Adviser).
     
     
   • You can view a large number of revenue transactions on screen in CommPay. However, to avoid system performance issues it is suggested that you select the appropriate Filtering and Group By options to ensure that less than 5,000 transactions will be displayed.
     
     
     
     
3. In the Filtering section, from the Status dropdown list select Processed Only:
   
   
   
   
4. In the Group By section, from the Group By dropdown list select Client & Account (Single Line).
   
   
   • Alternatively, selecting (None) will bring through all of the underlying “raw” transactional data for each revenue record.
     
     
     
     
5. In the Searching Period section:
   
   
   1. In the Search Period dropdown list, select Specify Payment Period.
      
      
   2. In the Year dropdown list, select the year required.
      
      
   3. In the Period dropdown list, select the commission statement required.
      
      
      • The Wealth Axis Financial Year runs from October to September, and payment periods have been set up in CommPay accordingly.
        
        
        
        
6. Click CSV (at the top right-hand corner of the screen).
   
   
   • Alternatively, to view the revenues on screen, click Search (at the top right-hand corner of the screen).
     
     
7. The file will be generated in the background. Click OK .
   
   
8. When the file has been generated, click  to display the new system message.
   
   
9. Click Download to download and view the generated CSV file.

How do I view or download the details of two or more commission statements?

To download the details of two or more commission statements:

1. Follow Steps 1 to 4 above for How do I view or download the details of a commission statement?
   
   
2. In the Searching Period section:
   
   
   1. In the Search Period dropdown list, select Specify Payment Period Range.
      
      
   2. In the Start Year dropdown list, select the beginning of the period required.
      
      
   3. In the Start Period dropdown list, select the first commission statement required.
      
      
   4. In the End Year dropdown list, select the end of the period required.
      
      
   5. In the End Period dropdown list, select the last commission statement required.
      
      
      • The Wealth Axis Financial Year runs from October to September, and payment periods have been set up in CommPay accordingly.
        
        
      • To download revenues for the 12-month period to 30 June, select the first payment year (Start Year) and choose Period 19 (Start Period), followed by the next payment year (End Year) and choose Period 18 (End Period):
        
        
        
        
3. Click CSV (at the top right-hand corner of the screen).
   
   
   • Alternatively, to view the revenues on screen, click Search  (at the top right-hand corner of the screen).
     
     
4. The file will be generated in the background. Click OK.
   
   
5. When the file has been generated, click  to display the new system message.
   
   
6. Click Download to download the generated CSV file.

How do I view or download the details of revenue received in a specified period?

To download the details of revenue received in a specified period:

1. Follow Steps 1 to 4 above for How do I view or download the details of a commission statement?
   
   
2. In the Searching Period section:
   
   
   1. In the Search Period dropdown list, select Specify Statement Record Date Range.
      
      
   2. Enter the Start Date.
      
      
   3. Enter the End Date.
      
      
      • The dates are based on when Adviser Payment Services received the revenue (not when the revenue was paid to the Practice/Adviser).
        
        
        
        
3. Click CSV (at the top right-hand corner of the screen).
   
   
4. Alternatively, to view the revenues on screen, click  Search (at the top right-hand corner of the screen).
   
   
5. The file will be generated in the background. Click OK.
   
   
6. When the file has been generated, click  to display the new system message.
   
   
7. Click Download to download and view the generated CSV file.