How to generate an iXBRL report for Incorporated Charities

Introduction

HMRC have made some transitional arrangements for smaller charities. The format in which Charity Accounts are required to be submitted, depends on the size of the charity.

If a Charity has to prepare accounts under the Companies Act 2006 or Friendly and Industrial and Provident Societies Act 1968, users are required to file accounts and computations in iXBRL format.

However, HMRC recognises that the accounting principles by which smaller charities prepare accounts mean that the accounts template, included in the free software provided by HMRC, may not be suitable. Until HMRC provides free software that is suitable for smaller charities, HMRC will continue to accept accounts from smaller charities in PDF format. Computations must be filed in iXBRL format.

A smaller charity, for the purposes of this arrangement is one where, together with any wholly owned subsidiaries (companies owned by the charity), the combined income does not exceed £6.5 million for the accounting period. Charities with a combined income above £6.5 million will need to file their Company Tax Return, Accounts and Computations in iXBRL format.

Click the links below to jump to a particular section:

Step 1 – Identifying Account/Group descriptions that have been amended from the default settings

Step 2 – Tagging text within the data screens

Step 3 - Generating the iXBRL Accounts for submission to HMRC

Step 4 – Tagging report items within the Tag Editor

Step 5 – Reviewing the tagged iXBRL Report

Step 6 – Finalising the iXBRL Report

Step 7 – Creating a submission for HMRC

iXBRL Glossary

 


 

Step 1 – Identifying Account/Group descriptions that have been amended from the default settings

  1. From the PTP Accounts Production menu, select Reports | Account/Group Descriptions

The Specific Description Report Options screen displays.

  1. Select the relevant options for each section.

  2. Click OK.

 

  1. Click the cross in the top right-hand side of the screen to close the report, once the items have been reviewed.

Back to top

 


 

Step 2 – Tagging text within the data screens

  1. Select Edit | Data Screens

  2. Select the relevant section of the reports to tag from the data screen branches. For example, select Notes to Financial Statements | Other Disclosures | Related Party Disclosures

  1.  Highlight the text to be tagged.

  1. Click the iXBRL Tagging icon at the top of the menu bar or right-click on the mouse and select iXBRL tagging.


The iXBRL Tagging screen displays:

  1. Click the magnifying glass next to Concept Label to display the Taxonomy.

The Taxonomy screen displays:

  1. Browse the Taxonomy to find the appropriate Concept Label by clicking on the arrow icon next to the relevant headings to list available concept labels for selection. Alternatively, manually enter text in the search field i.e. related party, press the enter key.
  2. Select the relevant Context Reference.

  1. Click Save.

  1. Click OK.

The following screen displays:

  1. Double-click on the hash icon next to green O under Group Member mappings to confirm the mapping:

  1. Click on the cross to exit the iXBRL Tagging screen. The following screen shows the text which has been tagged within the Data screen highlighted in a purple text box:

  1. Click Save to save the changes to the data screens.

  2. Select Exit Screens.

Back to top

 


 

Step 3 - Generating the iXBRL Accounts for submission to HMRC

  1. From the PTP Accounts Production toolbar, select Reports | iXBRL

The Financial Statements – iXBRL Reports screen displays.

  1. Enter the 3 character mnemonic in the Report/Document field i.e. CHA

(To display a list of reports available, click on the icon next to the Report/Document field).

  1. Confirm the correct posting entries have been selected by default or make your selection in the Current and Last field.

  2. Click OK to generate the accounts to the Tag Editor.

 

  1. Click OK to continue.


The Tag Editor screen displays:

Back to top

 



Step 4 – Tagging report items within the Tag Editor

  1. Within the Tag Editor screen, select the Report – CHA tab.

  2. From the toolbar, click on the Show Taggable Items icon.

  1. Click on the arrow to scroll to the next page to review tagging.

  1. Select the item to be tagged, the box will then be highlighted in green as follows:

  1. On the right within the Mapping Control section, click the magnifying glass next to Concept Label field.


The Taxonomy screen displays:

The Mapping Control toolbar also consists of the Apply default, Clear mapping, Show/Hide notes and Next/Back icons:

Apply default -this option allows users to revert the tagged item back to the PTP default; this option only applies to pre tagged items of the report that have been amended

Clear mapping – this option clears mapped tags that have been applied

Show/Hide notes – this option allows users to show or hide notes

Next/Back - This option allows users to select the next or previous item to be tagged.

  1. Double-click on the relevant Concept Label:

  1. If required select the relevant option from the Concept Reference drop-down menu:

  1. Click Save.

The Field linked on Concept screen appears as follows:

Back to top

 


 

Step 5 - Reviewing the tagged iXBRL Report

  1. Within the Tag Editor screen, select the Report – CHA tab.

The example client below shows where report items have been automatically tagged by the software:

  1. From the toolbar, click on the Show Tag Report icon.

The Tag Report tab is generated as follows:

 

Back to top

 



Step 6 – Finalising the iXBRL Report

  1. Follow Step 3 to generate the Tag Editor screen.

  2. Select the Validate icon.

Upon successful validation, the following message displays.

  1. Click OK.

  2. Select iXBRL Finalise.


The Accounts Finalised screen displays:

 

Back to top

 


 

Step 7 – Creating a submission for HMRC

  1. Click on the Create HMRC Copy.

The following screen displays.

Save file in IRIS – This allows the iXBRL Account fie to be automatically attached when generating the Electronic CT600 in PTPBusiness Tax.

Save externally – This allows the iXBRL accounts file to be saved in a specific folder

  1. Click OK.

 

 

Back to top

 


 

iXBRL GLOSSARY

iXBRL

Inline eXtensible Business Reporting Language - electronic communication language for business and financial data, which can be read by both computers and humans. It is a bridge between HTML (hypertext mark-up language – normally used on websites) and XBRL to enable XBRL documents to be read by humans, preserving the branding and formatting of the data sent. All reports in the UK must be filed in Inline XBRL format.

Instance document

An iXBRL version of the financial report which contains a set of values which can be understood by reference to the taxonomies on which the instance is based. An instance is created by matching business data against taxonomy. Every instance must reference the taxonomies on which it is based, so that its contents can be understood. It is a technical file intended for consumption by appropriate software, not easily read by humans.

Taxonomies

The dictionaries used in XBRL to define specific tags for individual items of data, e.g. “net profit”. Taxonomies are presented in the same format as the financial reports they typically represent. The full list of Taxonomies can be found in the Mapping Tool, in both the Mapping Control tab for selection and the Taxonomy Browser for reference. The Taxonomy is displayed using the XBRL. org‟s specified presentation view.

Presentation View

A view of the taxonomies in a user friendly format with user friendly labels to represent the concepts contained within the taxonomy.

Taxonomy Browser

The taxonomy browser allows a user to see the taxonomy presentation view as provided by XBRL UK.

Concept Label

This is a human-readable tag which uniquely identifies each data item within the taxonomy. These are the individual selectable tags that are contained within the Taxonomy list within the Tag Editor Mapping Control tab. These labels are unique to the data type selected when the specified Context and dimension are applied to it.

Concept ID

This is the computer readable version of the taxonomy concept Label. The concept is used and within the instance document as a unique reference for the tagged data in the reports. This concept Id can be seen for reference against each of the Concept Labels within the taxonomy browser.

Concept Type

This is the selected items data format, such as; monetary, numeric, text string etc. Depending on the data type of the selected value for tagging, will then depict which concept can be selected for tagging from within the Taxonomy list, as these are date type dependant.

Context Reference

All tags have a period type which identifies whether they are measured as an instant i.e. at a particular point in time, or over duration, i.e. for a period. The taxonomy defines if a Concept Label has Context Reference defined as an instant or a duration, PTP will provide applicable options to select from based on this taxonomy setting, i.e. for an instant, options for c/fwd current year, b/fwd current year, c/fwd last year or b/fwd last year for a duration Current year or Last Year.

Dimensions

Taxonomy dimensions represent the different forms in which financial data may be reported. Concept Labels may only exist once in the taxonomy, but dimensions can be used to tag the different forms in which it is reported.

Turnover

Dimensions can be used to tag a turnover figure for a specific geographic market, or tag a turnover figure for a continuing operation.

Tangible fixed assets, additions

Dimensions can be used to tag individual addition figures for each type of assets and to tag additions relating to owned assets or leased assets.

For the majority of concept labels there are default dimensions, these default dimension will be pre-defined. Where this is not the case the user will be automatically directed to specify the relevant dimension to apply to the selected data concept. If dimensions are set to a default they can be selected to the appropriate dimension for the report item being tagged.

Mapping attributes

Additional information associated with the data which is being tagged required to create a valid iXBRL instance.

Decimals attribute

The degree to which numbers have been rounded, this will vary automatically depending on the report run i.e. round pounds/round thousands. Manually tagged items in the data screens must have this attribute set by the user.

Unit Reference attribute

Represents the unit of measure, and is required for numeric concepts i.e. monetary elements would have a monetary unit type, GBP. These values will be automatically populated depending on the posting entry currency. Users can select an alternative currency if appropriate for manually tagged items in the data screens.

 

Back to top