Skip to main content
CCH Software User Documentation

Statutory Database Access and Navigation

Product Help Banner.png

 

Accessing the Statutory Database

To access the statutory database select Statutory Database within the Financial Reporting folder in the Task Bar list.

Statutory Database Overview

The statutory database is presented in a ‘tree’ structure, which consists of several parent nodes (folders) each of which may contain sub-nodes (sub-folders), in turn may themselves have sub-nodes.  

To expand a folder, click on the ‘+’ symbol to the left of it, to collapse the folder click on the ‘-‘ symbol.  Alternatively use the arrow keys on your keyboard.  To collapse all nodes, select Collapse Tree on the top ribbon.

A node may be marked with a red or blue circle. These indicate whether the disclosure is not required (red) or optional (blue) for the dataset.  In the Unincorporated and FRS 105 entities no entry symbols may be displayed.

Explanation of statutory database ribbon

clipboard_ecaff5a07f95e6582242cf8c9dca51eea.png

Search functionality - searching for a word or a #code

The first box on the ribbon enables the user to search by word or #ref e.g. entering the words cash flow navigates to the first instance of those words and immediately below the entry search box is a box which returns the #reference for that field in the database, in this case being #cd999256.  Each item is identified by a #code.

When typing in a word, the down and up arrows will progress to the next or previous instance of the word(s).

Screen shots within this page come from the Limited (FRS 102) entity set to report under section 1A with no audit.

Show last print preview

Does just that, The print preview is run from the Financial statement screen Financial Statements and is able to viewed within the Statutory database.  This is the last preview of the full set of accounts, not individual pages, which may be more up to date than the last time a full preview was run.

View Active Nodes

Those which do not have a no entry symbol beside them - relevant only in the Unincorporated and Limited (FRS 105) entities. Click on to filter and click again to return to display all.  Note this functionality will not work if not if one of the aforementioned entities.

Custom paragraphs

Filters all paragraphs that have been customised within the current period for the client.  Note after performing a year-end these should be checked in the new year to ensure they are still relevant.  Click on to filter and click again to return to the full view.

Collapse Tree

Closes all folders.

Shortcut keys

clipboard_e3823574c13a8e13af64e0219a2bb8a36.png

Look-up options from the ribbon

clipboard_ec89684bbf040942cf4f51947013569a7.png

The five magnifying glasses on the ribbon (also available within the Financial statements screen) are explained below:

Name Ranges

To look up a named range, this may be referenced within a paragraph, e.g. [*TOTREV] is the named range for total revenue.

Statutory Data

Included here but required as already in the statutory database.  It is not a good idea to open the statutory database twice as it could be confusing.  

Compliance Terms

To look up compliance terms - may be referenced within a paragraph, e.g. #TERM23 returns the words Turnover or Revenue dependent upon whether reporting using Companies Act or IFRS terminology.

Word Items

To look up word items - may be referenced within a paragraph, e.g. #aw3 returns the words financial statements or #wd6 returns director.

Statutory Range

To look up a statutory range - may be referenced within a paragraph.  No need to navigate through to the statutory database but useful for a lookup.

 

Navigate to ....Using the statutory database link: Statutory Database selections and data entry

 

  • Was this article helpful?