startDPL tagging process within Accounts using iXBRL R&T
How To

DPL tagging process within Accounts using iXBRL R&T

CCH IXBRL Review And Tag
Last update: Reading time 3 minutes
Detailed Profit And Loss (DPL)
    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.

    clipboard_ebfa99aec11de33d720a1eaf23cc0949f.png

    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 top ribbon under the tab Automation, click on the icon Allocate DPL tags.
    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.

    • 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)

    DPL 5.4.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. 

    Related documents

    CCH iXBRL Review & Tag: Training for Accounts conversion from MS Word and Excel (10133768)
    This document outlines a training course for converting statutory accounts from Word and Excel into iXBRL format using CCH iXBRL Review & Tag. The course, lasting up to 3 hours, targets users needing to tag accounts for submission to HMRC and Companies House. Key objectives include understanding iXBRL requirements, importing documents, applying tags, and the submission process. Prerequisites include familiarity with accounts and having credentials for HMRC and Companies House. Additional resources such as eLearning courses and webinars are also provided for further learning.
    CCH Accounts Production/iXBRL essentials training online (10133804)/(10133819)
    This document outlines a course on using CCH Accounts Production software, aimed at helping new users efficiently produce statutory accounts. The course includes 1 x 2 hour session and 1 x 3 hour session focusing on practical skills such as setting up accounting periods, importing trial balances, and navigating the software. It is designed for all employees involved in preparing statutory accounts. Training is conducted in an interactive environment called CloudShare, with additional resources available online for further learning and support.
    CCH iXBRL Review and Tag 2026.1
    The latest release of CCH iXBRL Review and Tag
    View
    The document outlines the features of a software interface with two main tabs: "CCH iXBRL Review and Tag" and "Companies House Submission." The first tab provides product version details and access to review and tagging settings, which are further explained in a linked system administrator guide. The second tab includes functionalities related to the Companies House licensed module, with an option to update the license if it has expired. Visual elements include images depicting the interface for clarity.
    Introduction: Tagging Detailed Profit and Loss
    The document outlines the process for tagging the Detailed Profit and Loss (DPL) statement for HMRC compliance, indicating that it must be submitted with either Accounts or tax computations, but not both. It specifies that CCH provides two options for tagging the DPL: via the CCH Corporation Tax return or using CCH iXBRL Review & Tag. Additionally, a link is provided for further instructions on tagging the DPL through the Corporation Tax method.