Skip to main content
Sign in

Fee & Commission Uploading

Hannah Snowden
  • Updated

Uploading Fees

**If uploading fees is not something that you have done before, we suggested reaching out to us so that we can walk you through this process initially**

  • Navigate to Settings > Client Fee > Batch Import > Download a copy of the import template

It is important that you do not change the order or title of the column headings in the template, but simply insert your data as well as formatting this in-line with the below rules.

Formatting the Fee Data

  • Put your data into the template as you feel it is appropriate to enter
  • Format the account number so they are all numbers with 0 decimal places (this prevents scientific notation from showing up in the fees):

{% video_player "embed_player" overrideable=False, type='scriptV4', hide_playlist=True, viral_sharing=False, embed_button=False, autoplay=False, hidden_controls=False, loop=False, muted=False, width='688', height='387', player_id='30637137952', style='' %}

  • Remove all “,” and “.” From the client name
  • Format the columns: Amount, Net amount and GST so that they are all formatted as numbers with 2 decimal places. (Do not leave “$” symbols in these columns)
  • Make sure the type of fee is either Ongoing or Upfront
  • Make sure the fee type fits into one of the 6 SubType Categories

Type of fee 

Ongoing 

Upfront 

Fee Type 

Ongoing fee for service 

Upfront fee for service 

Other ongoing fee 

New business 

Renewal revenue 

Other upfront fee 

 

Want to customise the fee types and sub types? Let us know and we can work with you to adjust these in your site as the upload must MATCH EXACTLY what is available in your site to import.

 

  • Make sure there are no blank cells for:  
    • Client Name
    • Account Number
    • Adviser Name
    • Source
    • Fee Date
    • Amount
    • Fee Type
    • Net Amount
    • GST
  • Set the date format to dd/mm/yyyy using the custom format

 

{% video_player "embed_player" overrideable=False, type='scriptV4', hide_playlist=True, viral_sharing=False, embed_button=False, autoplay=False, hidden_controls=False, loop=False, muted=False, width='688', height='387', player_id='30638048520', style='' %}

 

  • Save the file as a .CSV

Uploading Fees

  • Navigate to Settings
  • Client fee > Batch import
  • Click the blue “Browse” button to select the file to be uploaded
  • Click Submit
  • Click on Notifications which will let you know when the fees have been uploaded
  • NOTE: if you need to upload the file again, change the name of the file which will help with the upload

Post-Uploading Checklist

  • Navigate to Settings > Client Fees > Mapping Screen
  • Filter by the Batch ID for the upload you have just completed > Select the most recent batch and click “apply filters”, so you are only seeing fees that you have uploaded
  • Check that the Type of Fee and Sub Type are not blank
  • Check the fee date has not defaulted to today's date
  • Check the account numbers for “+” and “0000” which indicates that the account numbers have been entered with scientific notation
  • Check account numbers for .00

 Mapping Fees

  • Navigate to Settings > Client Fees > Mapping Screen
  • Filter by the Batch ID for the upload you have just completed > Select the most recent batch > Select Mapping Status: UNMAPPED and click “Show”, so you are only seeing fees that you have uploaded

mceclip0.png

  • You will then need to map the unmapped fees below
  • Begin typing a client's name under the Select Client heading > Select the client > tick the actions box > Map Records