Quick Start Tutorial:
To create a new dimension in MODLR there are two options:
- Click on the actions button in the top right corner.
- Select “New Dimension” from the dropdown.
- Click the “Dimensions” tab.
- Click on the “New Dimension” button.
There are multiple options of dimensions types which we will go over in a future tutorial. But for this tutorial, we will utilise the ‘Standard’ dimension.
- Click the Dimensions type bar.
- Select ‘Standard’ dimension type.
- Click “Create Dimension”.
We can create and edit hierarchies within our dimension using MODLR.
After creating your dimension either:
- Double-clicking on the name of the new dimension.
- Click the manage button on the right-hand side.
When we are at the dimension management screen we have multiple options to add hierarchies, edit, or delete them on the left-hand side.
For this example, we will use a very basic Operating Income account structure starting with creating an Operating Income element.
- On the top-left hand side, double click “edit” next to the “Default” hierarchy.
- On the new blank line type out : “Operating Income”.
- Press the ‘Enter’ key.
- Now we have our first element in our hierarchy.
To add child elements to our “Operating Income” element we:
- Go to the next line using the ‘Enter’ key.
- Press the ‘Tab’ key.
- Type out the name of the child element, in this example, it will be “Gross Profit”.
- Hit the ‘Enter’ key to move on to the next line.
Here we now have the “Gross Profit” element as the child element of our “Operating Income” element. Using the same process we can add child elements, to the “Gross Profit” element.
- Repeating the previous process of entering child elements (Child elements, Step 1-3) we will type out the account code “4-000” element then repeat the process and create the “5-000” child element.
To stop making children for Gross Profit:
- Press ‘Tab’ back until we are in line with Gross Profit.
- We can add Operating Expenses using the element creation process (Child elements, Step 1-3).
- Type the element “6-000”.
This is once again a child of Operating Income.
While using account codes can be useful, you may want things to be clearer in some situations. For this, we can use aliases. Which are effectively nicknames which can be turned on in your reports.
So to create Aliases:
- Go to the left-hand side and click ‘Add’ next to the word Account Aliases.
- Type out “Name”.
- Click the “Add Alias” button.
This will create Aliases linked to names for the elements.
Click on ‘Edit’ next to the newly created “Name” Alias.
Another pop-up box will come out with the existing elements in your dimension. You can create Aliases of each element in the blank box next to them.
We will rename our account code elements into their Accounting Names:
- Next to “4-000” type “Revenue”.
- Next to “5-000” type “Cost of Goods Sold”.
- Next to “6-000” type Operating Expenses.
- Click the “Save Alias” button.
Creating automated adjustments:
If you link your accounting system with MODLR, there are a series of automations we can provide for your calculations. One being automated subtraction.
- Type “[-1]” in front of child element “Cost of Goods sold”, this will change the sign of the values when this element is being added into its parent element.
- Type “[S]” in front of an element, which will allow the cell to accept text, as well as numbers, to be entered. This is usually only used on elements within a measures dimension.