How to set up commodities and classify purchases accordingly

How to set up commodities and classify purchases accordingly

Step 1:  Setting up your commodities

Step 1.1: Log in to the Supplier Management System. On the dashboard, go to the 6th card, namely “User and Account Settings”, and click on “Commodity Classifications”:

Picture_1.png

Step 1.2: This will take you to the following screen, where you should click on “New commodity classification”:

Picture_2.png

Firstly, decide on the different commodities according to which you would like to classify your spend. You can also have “main commodities”, under which you can have further “Sub-commodities”, as follows:

Picture_3.png

In this example, I have selected “Telecommunications” as my commodity. This will be my main commodity and so I will leave the “Parent” field blank and click on “Save commodity classification”, which will give you the following screen:

Picture_4.pngPicture_5.png

Now, I am going to add a “sub-commodity”.  Go back to Step 1.2 and click on “New Commodity Classification”. I am adding “Telephone” and selecting “Telecommunications” which I created in the previous step as the Parent. This means Telecommunications is the main commodity and telephone is set as a sub-commodity.

Picture_6.png

You can carry on repeating the above steps until you have all the applicable sub-commodities saved under your main commodity. Your commodities will then be listed as follows:

Here is an example of what multiple commodities with sub-commodities would look like:

Picture_7.png 

Step 2: Commodity Classification Rules

The purpose of Commodity Classification Rules is to set rules for classification of spend under different commodities.  Some spend items might fall under more than one classification and setting rules will determine under which specific commodity these spend items are classified.   In order to apply rules to your commodity classification, click on the “Rules” option under the Commodity Classification screen:

Picture_8.png

Then click on, “New Rule”:

Picture_9.png

In the example, I am going to create a rule for the classification of transport spend as either “Uber” or “Taxi” (under the main commodities of “Entertainment” and “Transport”). Once I click on “New rule”, I enter the details as follows:

Picture_10.png

Then click on “Next”, which will take you to this screen:

Picture_11.png

In this example I have created a rule to classify as “Uber”, if the Vendor Code starts with 565.

There are various options for the rule, and classification can happen according to vendor code, expense code etc. The condition can be that the code “starts with” a certain number, “contains” a certain number, etc.

I am now going to add another criteria to this rule, namely that the “Expense Code 1” must be 100:

Picture_12.png

I have now created a rule that the system should classify a spend item as “Uber” when both these criteria are present. The usefulness of the rule will become apparent when we create our next rule for when a spend item needs to be classified as “taxi”:

Picture_13.png

According to the above rule, spend should be classified as “Taxi”, if the “Vendor code” starts with 565, and the “Expense code 1” is 200.

Thus, it is possible to have two items with vendor codes starting with the same numbers (in this example 565), but to create a rule that should the expense code be 100, it is classified as “Uber”, and should the expense code be 200, it is classified as “Taxi”. In practice this is something which could happen quite often.

Notice that “Rules will be applied in the order in which they are listed”:

Picture_14.png

This means that the “Uber” related rule will be applied first, before the “Taxi” rule will be applied. So where the Vendor code starts with 565, the system will firstly check whether the Expense code is 100 and classify as “Uber”, before it applies the rule for classifying as “Taxi”.

Step 3: Using Commodity Classification

Step 3.1: Upload suppliers: On the Supplier Database card on the dashboard, click on “upload suppliers” (this can be done either manually, ie one supplier at a time, or via a bulk upload using an excel spreadsheet):

Picture_15.png            

Step 3.2: When adding the relevant supplier, under “Commodity Classification”, enter the commodity you would like to allocate the spend with that supplier to:

Picture_16.png

Step 3.3: When you create a new procurement scorecard, your spend will not be classified according to the commodities which you have set up:

Picture_17.png

If you click on a commodity, for example “Transport”, it will show you which sub-commodities the spend was on:

Picture_18.png

 

Picture_19.png

Step 4: Analysing your commodity spend

Once you have classified all your spend according to specific commodities, you can now pull reports on these commodities and effectively analyse your spend per commodity:

Step 4.1: On the “Procurement Scorecards” card on the dashboard, click on the scorecard which you would like to analyse:

Picture_20.png

 Then, click on “Reports”:

Picture_21.png

You can now go ahead and create a report using a specific commodity.  Click on “New Report”:

Picture_22.png

Ensure that the “Commodity classification” field is entered. Using the other fields, you can narrow down your report as much as you need.

Commodity Classification seems complex but is a very useful tool once implemented.

    • Related Articles

    • Creating a new Scenario

      Create a new Scenario 1. Select the Scenario Scorecards icon from the dashboard page, as shown below. 2. This action (Step 1) will take you to the screen below. To create a new scenario click on the New Scenario link, as indicated. 3. Complete the ...
    • How to refresh a procurement scorecard in SMS

      There are instances when changes are made in the supplier database by updating BEE information of suppliers after running a procurement scorecard. In order for the changes to be updated instantly, it is best to prompt the refresh on the scorecard to ...
    • Authentication

      All requests sent to the API must include a signature and the account identifier to authenticate the request. So add the following headers to all requests: Header Name Header Value Authorization Your account key Mpowered-Signature Calculated ...
    • Add A User

      Only Administrators on the accounts will be able to add additional users. They can also set different access rights according to the permissions wished by the Administrator. Step1: When logged into your Supplier Management system, select Users from ...
    • Updating Suppliers information

      Updating Suppliers Information 1. Select the Supplier Database icon from the dashboard page, as shown below. 2. Your list of suppliers will appear, as illustrated below. 3. You have a choice to update suppliers individually or via spreadsheet. To ...