Knowledgebase

Commissions reconciliation

Commissions reconciliation

In order to reconcile the commissions which you receive from network you will need to have access to the Finance module and work stack ‘All commissions’.

If you do not have that, please contact your Layer administrator who will be able to help you set this up.

Step 1 - Access the Commissions Work stack

To access the commissions, click on the Finance Tab and then select ‘Unpaid Commissions work stack’ or All commissions.

On the commissions grid I would like to point your attention to the two columns highlighted below.

Index

this column provides you with the number of lines from the sales order for which you are expecting payment for. If the index number repeats itself this means there is more than one payment expected for that line, this is specified in the Commission Element Type. E.g. Service Commission Profit and Service Recurring Margin Profit. 

Match Ref

in this column you will need to provide a reference number, which is basically a mobile number which links to that specific line.

Image A

Step 2 - Check and update the lines in the grid

In our example, we are expecting payment for six lines. Note from image A, line numbers 6 to 10 are not appearing as we are not expecting any commissions for those five lines (see image B)

Image B

Check for the ref number and if this has been populated already, continue with step four. If it hasn’t been populated then follow step three.

Step 3 - Provide Reference

If you are not able to provide the mobile numbers in the order, please contact your sales order processor to complete this.

In order to keep track of the commissions per line you will need to enter the reference number, which is mobile or landline number. To do this simply click on 'Provide Reference'.

You will then be taken to the sale order screen. To specify the numbers on the line, hover your mouse over Data Capture and select Mobile Services.

You will now be presented with the following window. In this grid you can enter MSISDN number.

Please note in our example we have provided the numbers for the services which we are expecting the commissions for.

You will not see that the match reference on the All Commissions grid has been updated. Now you can apply payment to your commissions.

Step 4 - Apply payment

Scenario 1 When you receive full payment for the line.

Before applying the payment against the line, please check the status of commission and outstanding amount. When you are ready to apply the payment simply click on the expand icon and then the plus button.

You will then be presented with the following fields.

Reference

- enter reference number either from the network or your internal reference number.

Value

- enter value of the commission you have received for this specific line

Description

- add relevant note

Once you completed these, please click on the tick icon to save the payment.

Continue with the rest of the lines against the order and then refresh the page.

You will now see that the payment field has been updated with the value entered.

The outstanding value has been amended to £0 and the status of the line has changed to 'satisfied'.

Other statuses which you will come across are 'Unpaid' and 'Part Paid'.

Scenario 2 When you receive only part of the commission

In our scenario we have only received £500 from the £720 expected. If you receive an incomplete payment from the network, enter the value of the payment which you have received and make sure you add a relevant note to the description.

E.g. date of querying this with the network.

In order to manage your commissions effectively you should enter every commission you received even if it is an incomplete amount.

The system will calculate the outstanding amount for you, which means you can query the outstanding amount with the network and come back to all outstanding commissions in due course. Please note that OGR payments will remain part paid until the contract has been fulfilled or the customer has achieved the equivalent bill threshold as outlined in the quote via overspend. You will also find that OGR field will regularly result in over payment due to additional spend.


Author: Michaela Gormanova