All Collections
Sales Management
Reconciling commissions
Reconciling commissions

Using a work stack to help with this process

R
Written by Raymond Carrel
Updated over a week ago

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

If you do not have access, 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 the Unpaid Commissions or All commissions work stack.

Some key columns are:

Index

this column provides you with the number of lines from the sales order for which you are expecting payment. If the index number repeats itself, this means that 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 that links to that specific line.


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 below).

Check for the ref number - if this has been populated already, continue to 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 for assistance.

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 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 the MSISDN number.

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

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 the commission and the outstanding amount. When you are ready to apply the payment, click on the chevron icon to expand the line, and then click the + button.

You will then be presented with the following fields:

  • Reference - enter the 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 a relevant note

Once all details have been entered, 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 of 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 receive, even if it is an incomplete amount.

The system will calculate the outstanding amount for you. This means that 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.

Did this answer your question?