DPL tagging process within Accounts using iXBRL R&T

Last updated
Save as PDF

Product Help Banner.png

Step 1 - go to the first page of the DPL page

Go to the first page of the Detailed Trading and Profit and Loss Account (DPL).
Either scroll down the bar or by typing the word 'detailed' into the search box and click on the magnify glass.

Step 2 - define DPL Expense Type areas

On the left hand side of the page, right click and select Define DPL Expense Type areas.

DPL 2.PNG

Step 3 - highlight the expense type areas

Highlight the lines, including balances for Cost of Sales section
Select Cost of Sales from the top left of the Accounts (Set DPL expense type areas menu)
Click on the green + to add the expense type area drop-down list to obtain the following result:

DPL 3.PNG

Proceed with the same process for the distribution costs and administrative lines. Remember to choose the respective expense type area, example below.

DPL 3.1.PNG

On the DPL expenses type areas menu, click on the disk icon to save.

DPL 3.2.PNG

The result of this step is the following, all lines that were previously highlighted as above will have a coloured dot on the left hand side.

DPL 3.3.PNG

Step 4 - run the Auto DPL tags

This process will look for the DPL tags using the description of the expenses.

On the task bar under the tab Automation, select Learning Active
Click on the icon Allocate DPL tags.

DPL 4.PNG

Step 5 - review the tags allocated by the Auto DPL tags process

Once the Auto DPL tag is finished, there will be review flags (coloured circles with an R within) on the left hand side of the balances:

Green circle indicates a direct match
Red circle indicates multiple matches
No circle at all indicates that the description of the line does not match with any tag listed on the taxonomy

DPL 5.PNG

GREEN CIRCLE

Hover over the green circle and the details of the tag allocated will display as per below:

DPL 5.1.png

RED CIRCLE

Click on the red circle, the Set Tag window pops up
At the bottom of it, click on the box Apply tag selection to comparative period
Choose most appropriate tag from the list given

DPL 5.2.png

Once the tag is chosen, the red circle disappears and the balance is now tagged as below.

DPL 5.3.PNG

NO CIRCLE

Any expense which does not have green or red circle are not tagged and therefore must be tagged, steps below.

Tags are in the taxonomy on the right side of the window under the section Full Detailed Profit and Loss.

Make sure the icon Learning Active which is on the task bar is highlighted (step 4 above)
Locate the tag within the taxonomy using the search box at the top right or simply expanding the Full Detailed Profit and Loss section
To apply a tag from the taxonomy, drag and drop it onto the balance
Make sure the date context is correct (duration of current year or duration of prior year)
Make sure the item number is consistent for current year and prior year (if more items are required for the same tag, click the box at the bottom left of the screen)
Once the above is completed, The Tag Learning window pops up, click Yes to confirm you want to save the tag applied to that description in order to minimising manual tagging.

DPL 5.4.PNG

Once the above is completed, The Tag Learning window pops up, click Yes to confirm you want to save the tag applied to that description in order to minimising manual tagging in future.

DPL 5.41.PNG

Proceed with the above for the comparative year.

Step 6 - accept and clear review flags

Once the review flags are reviewed and any missing tag is applied, from the ribbon click Accept and clear review flags. Learning active will automatically close.

DPL 6.png