Commission Download User Guide

Setup:

1. There are two areas of setup required, on Durell and the providers with whom you wish to receive your e-statements through Durell.
   

Setup in Durell: 

1. To set up commission downloads in Durell please contact the Durell Sales team and ask to be set up on Commission Downloads, we will then need your full company name and your FCA number (please email this information to sales@durell.co.uk).  Once we have that, we will contact you and set up your commission downloads within Durell.
   

Setup with the Insurers:

1. Each provider will need to be contacted and asked to have e-statements switched on and sent to Durell’s OpenText Mailbox.  Please see the text quoted below, if you copy and paste this into an email and send it to the insurers you want setting up for commission downloads this should contain all the information they require.
   

“Dear Sirs, 

We wish to receive EDI Commission statements through Durell Software Ltd, they use an OpenText Mailbox, the details of which are below:

The Durell Mailbox on the OpenText IBP1 service is DURELL.

The Durell EDI Code, which is required in the actual data as the recipient code is; DURELL.

If your EDI system requires a number to be able to send the EDI Data to Durell, the assigned EDI Code is: "0000 +FSANo", i.e. "0000123456".

Both of these codes are equally valid to OpenText minus a few exceptions when trading with partners on other Value Added Services such as GXS.

The Address used to send data varies by location;

On the same service:

           The addressing for an FTS or IBP1 user is just the Mailbox name DURELL with a service of FTS.

On the OpenText traditional EDI service (GMS):

           The addressing for a GMS user is IBP1!FTS! DURELL.

As an X.400 user:

           The addressing for an X.400 user is c=GB, ad=ATTMAIL, O=ATTMAIL, dd.type=EDI, DD.value= IBP1!FTS! DURELL.

An "offnet" / Interconnect user:

           An Interconnect User must tell the Provider to send to EasyLink, specifically the EasyLink Gateway.

The Interconnect User must ask the Provider to set up a relationship and then route the message to the EasyLink Gateway for processing.

 

The GXS Gateway Mailbox for EasyLink is called ABJ08600.

We would also like to retain our paper statements once this has been turned on.

If you have any questions or problems with the setup, please contact Durell on 01823 326324 or sales@durell.co.uk.”

Using Commission downloads

1. To access the Commission Downloads section of Durell go into the Accounts Section and then the Sales Ledger.  Once in the sales Ledger click the Purple Uplink button in the top toolbar.
   

1. To download any new statements that have been delivered to your OpenText Mailbox please click “Check for new entries” (Red Arrow below).
   

1. This will populate the Commission Downloads window with all the statements that were in your OpenText Mailbox, regardless of the date of the statement or the insurer.
   
2. The best way to filter your results is by Provider and Statement Date.  By selecting one provider (Blue Arrow) and one Statement date (Green Arrow) this will give you all the entries on one statement.  This can then be compared to the paper statement that was provided to you by the insurer.

1. The yellow arrow on the screenshot below shows the DISPLAYED commission total and the SELECTED commission total.  The displayed commission total is the total of all the commission that is present in the current filtered results, i.e. if you have filtered the results by insurer and date you should have one full statement so the total displayed should be the amount of the insurer statement.

1. As you select commission to post to the accounts the SELECTED amount will increase, once you have finished selecting commission to post to the accounts this should equal the statement amount.
   

Setup options (purple arrow)

1. If you click the Setup button (Purple Arrow) the Commission & Fees Downloads Setup window.  In this window you can select which account set you want to post the commissions to as well as the bank account and payment method.  This is also where you can select the default nominal accounts to post unmatched commission/fees to. 
   

Linking Commission to Clients

1. Durell will, by default, check the Policy numbers of the commission entries that have been downloaded and link them to the corresponding policy within Durell (if the policy is in Durell).  These entries are highlighted Green.  If the policy is not in Durell there are two ways you can post the commissions, by posting all commissions to the accounts unlinked to any clients or you can individually link each commission entry to a client. 
   
2. If you post the commissions to the accounts without linking them to a client there will no way to be able to report on how much renewal commission or on-going fees you have earned from those clients.

Manually Linking Commission to Clients

1. Any entries that have not been automatically linked can be manually linked.  This only needs to be done once per client, Durell will remember the manual link for subsequent statements.
   
2. By double clicking on an entry you will open the “Match Policy” Window.  This is where you can select either a client, or policy to allocate the commission against.  You can also select the Nominal Account to allocate that commission/fee entry against.  

1. The Commission will be linked against the client that is selected in the yellow box (blue arrow in screenshot above).  Durell will use the information provided by the insurer to make it as easy as possible to find the relevant client by allowing you to search your Durell database for clients using this information.  For instance, if you have commission for a client called Mr White (policy number 6755986) then that information will automatically populate this screen and by clicking on the “Search…” button next to either the name or policy number will search your Durell database for similar records (red arrows).
   

1. You can then select the relevant record and this will populate the correct record in the Yellow box mentioned above.
   
2. Entries matched manually will appear in the list of commissions highlighted in yellow.  Automatically linked entries appear highlighted in green.  Invoices for manually linked commission entries are posted against the record selected in the “Durell Insurer” box (red arrow in screenshot below).
   

Posting the commission and fees to the accounts

1. Tick the box in the “Process” column (Purple Arrow) of the entries that you wish to post to the accounts.  These entries should make up the statement you have received from the insurer.
   
2. If you have matched all the clients on the statement against address records in Durell, or you wish to post all entries in the statement you can click either “Select all” or “Select all matched” (Green Arrow) this will “bulk tick” the entries.
   
3. At this point the SELECTED commission total should equal the statement amount.
   
4. To post to the accounts click the “Post selected entries…” button (yellow arrow).  
   

1. This will open the “Post Downloaded Commission Entries to the Accounts” box.  Here you will have 3 options on how you would like to post the commission.  You can either:
   
2. Just post the invoices to the accounts, this will post the ticked invoices to the Sales Ledger and leave them outstanding (i.e unpaid).
   
3. Post the invoices to the accounts and create a cashbook receipt allocating those invoices against the cashbook entry – this option is useful if the insurer sends a cheque or other payment method where the money does not get paid directly into your bank account.
   
4. Post the invoices to the accounts, create the cashbook entry and send that cashbook entry to the bank account – This is the option you will use the most as normally the insurer will pay the money directly into your bank account when they send you the statement.
   

• Related Articles

• Contract Enquiry - Bulk Revaluations

  This guide will show you how to create and save a Bulk Runner request, which will automatically update the values of every contract you have included. When proceeding through this for the first time, we would strongly recommend only selecting a ...

• Create a New Fund

  When inputting Funds into Durell, you will need to ensure that the fund is created correctly, otherwise contracts may not revalue or give you error messages while working within them. This guide will show you how to create a new fund. Once you are in ...

• Updating Fund Prices

  In order to greatly reduce the chance of errors during price updates, please maintain the FinExpress data base first. With everyone signed out of Durell, press the Windows key and “R”. In the new box that appears, type the following command in and ...