04.03 Hierachies - Get Started with the Samples

04.03 Hierachies - Get Started with the Samples

The most common hierarchies that one comes across in FastClose, are the P&L and the Balance Sheet.

Whilst you can build these from scratch – we recommend you start with one of our prebuilt samples and amend it to match your chart of accounts, as we’ve already worked out the maths.

Here is a video, or read below.

Opening a Sample P&L

The samples can be found in the Solutions area of the “Home” dialog, within “01 GL P&Ls, Balance Sheets etc”

image

Depending on whether you are holding your Budgets (within your ERP, or within the FastClose Planning feature), select the relevant subfolder.

image

Then navigate according to how you wish your numbers to be displayed:

image

Within each of those the same set of P&Ls exist showcasing various layout but all sharing the same main hierarchy.

image

Open the “P&L Cumulative This Year To Date with Target” sample.

When the report opens it will show you some guidance, including a link to this video, that walks you through the setup process. This mirrors what is discussed here also.

Switch to the “Insert” tab, and select “Hierarchies”…

fea16515-e0e3-4547-9aaf-37fd8dccfa06

…which will display the hierarchy list dialog.

image

This has a single pre-built hierarchy defined, which we then amend to match the chart of accounts of your business, so click on edit.

image

Hierarchies are used to combine leaf level data, aggregating it to create information that was not stored in the ERP. For example, there could be a number of different “Office Expense” nominals that all rollup to a single consolidated “Office Expenses” item (as shown above) that will then be seen on the P&L.

The idea here is to amend the sample so that the nominals that fall into each area, match your chart of accounts.

If you expand each node, you will see the items that make them up. Eg:

image

Amend the ranges or add individual items from the picker on the left to match your chart of accounts. If your accounts don’t form one contiguous range you can add further ranges alongside, to build the complete structure.

You might also want to add further groupings, particularly expenses to mirror your business.

On the right hand side of the currently selected node is an “Add” button that can be used to add additional nodes alongside or if the current node is an aggregated node, beneath as well.

image

The hierarchy supports the following node types:

In addition, hierarchies also support leaf nodes. These are added from the list of all the members in the hierarchy dimension that is displayed on the left hand side of the dialog. Double clicking on a member will add it at the currently selected location.

Best practice:

If possible use aggregated nodes with ranges rather than wildcards, calculated nodes or single lead nodes.

Node settings vary depending on the type of node but the common controls are shown below:

252db172-c7d6-456f-8fb9-e0dbdb596685

Hierarchy Validation

FastClose will validate the hierarchy when closing the dialog to check for any obvious issues. Where the system detects that data would be included twice between two different non-calculation nodes for example, it will provide an error message to help the user track down the problem which could otherwise lead to “double-counting”.

In addition there is also a hierarchy report tool in the dialog. This checks the hierarchy against the source dimension looking for members that have not been included anywhere in the hierarchy. This can be useful where the user wants to determine the degree of completeness of the structure.

ca827290-6429-43d4-a9ec-6fd87068c748

A further numerical check can be carried out using the so called “Check Node”. This can be found at the bottom of the hierarchy and looks like this:

image

The calculation range should be amended to pick up the entire P&L and the node unhidden.

After closing the Hierarchy Editor, also close the parent dialog, which will ask if you want to update the shared library copy of the hierarchy OR unsubscribe.

image

If you intend your work to be used by everyone select “update” otherwise select “unsubscribe” – if you selected “Update” all the other Sample P&Ls will now pick up your work.

Setting the Sales Account Range

Finally we need to edit the “SalesAccountRange” variable which is used in the conditions of various calcs and in the hierarchy, to get the math right.

Go to “Insert->Variables” and update the SalesAccountRange variable to match your range of revenue account nominals

image

If the sales account range is not contiguous, commas separated ranges or individual nominals can be placed in it.

Finally we can now run the report.

Confirm the numbers in the check node match the Net Profit. If they do, you can hide the “Check node” calc again in the hierarchy editor, but if there is a mismatch, some nominals are missing and some trouble shooting needs doing.

Powered By