HESA FSR with HE-BCI survey collection 2013/14
View the C12031 Check documentation guide for help with interpreting check documentation
HESA FSR with HE-BCI survey collection 2013/14
Check documentation guide
return to index
Version 1.0 Produced 2014-10-03
- Item priorities
- What to do if you find issues within your check documentation
- FSR and HE-BCI Part B check documentation
- HEBCI_B_T1_to_T4 and HEBCI_B_T4cont_T5
- T1_T3_Difference, T5_T6a_T6b_Difference, T7_Difference and T8_Difference
- FSR template visual checks
- Exception report
- Comparison of HEFCE Financial Tables to HESA FSR
- Checking HE-BCI Part A
A successful COMMIT transaction will generate two reports containing management information that higher education providers (HEPs) will need to review to assess data quality. The check documentation is the most substantial of these reports.
Check documentation takes the form of an Excel workbook containing a series of tables which present much of the returned data to enable HEPs to ensure that their submission represents their HEP as expected. In part, check documentation provides a preview of some of the onward uses of the data. Therefore review of the check documentation should be undertaken by HEPs to verify their submitted data.
It is intended that all the sheets within the check documentation will be checked by both HEPs and HESA. Colleagues within HEPs are in an excellent position to recognise more detailed anomalies within their data, using local knowledge of the intricacies of their own HEPs, and are strongly encouraged to closely scrutinise the check documentation reports. The check documentation is also used by HESA to conduct data analysis and quality assurance of a data submission. Queries raised on these check documentation items form the basis of any data quality queries fed back to HEPs through the Minerva data quality database.
This guide deals each of the sheets in turn, providing details of the populations and fields used in their creation, along with guidance on interpreting the items and tips relating to common issues. Note that this guide is not exhaustive and HEPs are advised to review the check documentation extensively for their own purposes.
Each check documentation item covered in this guide has been allocated a priority based on the data concerned (including the minimum data quality standards acceptable to HESA's Statutory Customers), the onwards use of the data and commonly found issues. However, the assigned priorities should be treated with caution as these are general estimates. Depending on the inserted data the actual severities assigned to data quality queries raised in Minerva may differ for individual HEPs.
|Major - high priority|
|Major - low priority|
Where anomalies are found you should record them on any relevant Minerva queries raised by HESA and flag the queries to be fixed on resubmission by selecting the 'Need to decommit' radio button. The HEP should then contact [email protected] to request that the FSR/HE-BCI Part B data is decommitted, or the HE-BCI Part A web form reopened, in order that the necessary amendments can be made and the data resubmitted.
The finance check documentation consists of ten sheets of tables and items containing summary statistics, key financial indicators, automated credibility checking, year-on-year difference checks and cost centres. The figures in these tables and items come from the FSR and HE-BCI Part B template submissions this year and last year. These tables have ratio calculations and automatic query calculations built into the checkdoc sheets. All queries that are automatically triggered, then appear as an automatic query on the Front_Sheet.
This sheet is designed as a useful check sheet for colleagues analysing the submitted data both at the HEP and at HESA. The Front-Sheet contains a checklist of the items from all sheets within the workbook and will be auto-populated with any automatic queries triggered on the rest of the sheets within the check documentation. The exception to this is 1 FSR v. Published Accounts check.
1 FSR v. Published Accounts check
This table is a quick reference point by which the comparability to the HEP's published accounts can be gauged. Checks should be carried out to:
- Compare both the FSR submitted this year with the restated figures for last year, looking for any differences of a magnitude of +/-750 and a ratio of +/-2
- Compare the submitted FSR to the HEP's published accounts to ensure commonality of reporting.
All HE-BCI Part B tables are replicated in the Check documentation on sheets HEBCI_B_T1_to_T4 and HEBCI_B_T4cont_T5.
Three types of automated query are run on these sheets.
Query 1 (shown in lilac) highlights high year-on-year differences
Query 2 (shown in lime) highlights where the restated difference is 5% or more
Query 3 (shown in aqua) highlights where the number return is greater than 5% of the total amount returned by the sector in the previous year.
Where queries are raised, HESA requires explanation of the reason behind the year-on-year variations. These responses will then be taken alongside the HE-BCI dataset by data users to explain patterns and shifts.
This worksheet is designed to consider differences between the data submitted for the current and restated year and also year-on-year differences which could impact the Key Financial Indicators (KFIs).
Item 1 - Summary financial statistics
This table compares a key headline figures year-on-year between the current and restated figures to check for consistency. Automated queries will be raised on the front sheet where the difference is within the bounds of the ratio and difference below.
2013/14 & 2012/13 <> = 0, AND difference >750 or <-750 AND, Ratio >2 or <-2
2013/14 or 2012/13 = 0, AND difference >750 or <-750
Item 2 - Key Financial Indicators
This section details the Key Financial Indicators that will be published on heidi using the submitted data. These indicators should be checked to ensure that they correctly represent your HEP. Automated queries will be flagged on the check documentation where there is a high year-on-year difference. The specified difference varies for each ratio. These differences are listed in column U within the worksheet.
This worksheet details key areas within the FSR to ensure correct completion.
Item 1 Queries where there is no expenditure in Table 7 'Total research grants and contracts', but income has been returned in Table 5b 'Total research grants and contracts', and vice versa.
Item 2 Queries where there is no expenditure in Table 7 'Total research grants and contracts' under a particular source, but income has been returned in Table 5b under that source, and vice versa.
Item 3 Queries where no recurrent (research) income has been returned. It is expected that most HEPs will receive research income from the funding bodies.
Item 4 Queries where funding council grants have been assigned to 'Residences and catering operations' (Table 8, Head 1 column 2). In most cases it is not expected that the funding councils will provide funding for these operations.
These sheets list comparative data between that data returned this year, the restated figures for the previous year and the figures that were returned in the previous year's submission. Comparison ratios are run to check the order of magnitude of changes between these three figures. Queries are raised where the difference is not within the bounds of the ratio and difference below.
(2013/14 & 2012/13 <> = 0 and AB ratio >2 or <-2 and AB difference >750 or<-750)
(2013/14 & 2012/13 <> = 0 and ABi ratio >2 or <-2 and ABi difference >705 or <-750)
(2013/14 & 2012/13 <> = 0 and BiB ratio >0.25 or <-0.25 and BiB difference >250 or <-250)
This sheet provides comparative analysis of cost centre data between the FSR, Student and Staff records for 2013/14. It is generally expected that for a cost centres where income/expenditure has been reported there will also be student and staff FTE attributed to the cost centre. Any mismatches should be investigated and rectified where necessary.
It is strongly recommended that the Staff, Student and FSR record contacts liaise ahead of the data submission period to ensure all three returns are completed consistently; the submitted data will be the basis for publication and corrections cannot be made after the data collection closes.
The CCANALYSIS sheet can also be used to assess unit expenditure calculations between the FSR and Student records for each cost centre. Unit expenditure is calculated as Expenditure (£000s)/Student FTE.
Tip: in general unit expenditure is c.£10k per student, with cost centres 1-3 typically having generally higher expenditures.
It is advised that the below visual checks are undertaken against the FSR to ensure that the template has been correctly populated. Most of these items are the basis of figures for the Key Financial Indicators. These are items which are commonly misreported.
Heads 2b and 2c 'Other operating expenses' and 'Depreciation' are often inversely recorded on the FSR. These heads should be checked against the published accounts to ensure this is not the case.
Head 7 'Exceptional items' are often incorrectly recorded on the FSR. This head should be checked against the published accounts to ensure this is not the case.
Head 13 'Closing reserves and endowments' should match the published accounts, or if not the accounting practices adopted in the notes to the published accounts.
Head 7a should be checked by HEPs in Wales to ensure that this head is only completed where the institution has funds that are reimbursable to HEFCW.
Heads 13a and 13b 'Endowments: Expendable' and 'Endowments: Permanent' are often inversely recorded on the FSR. These heads should be checked against the published accounts to ensure this is not the case.
HEPs are advised to check that UK-based charity income is split correctly between 'open competitive process' and 'other'.
HEPs are advised to check that income from research training support grant income in head 4 is split between 'Income for general research studentships from charities (open competitive process)' and 'Other research training support grants'.
Following a successful COMMIT transaction, HEPs are advised to review any warnings listed within the Exception Report. Any data items listed should be examined and amended and/or explained as necessary through Minerva.
Full details of the commit-stage exception rules for C13031 can be found at COMMIT-stage quality rules.
Exception warnings detail data that has passed but is highlighted because it does not correspond to other sources.
Exception reports are retained for each processed commit transaction to enable cross-comparison of exceptions between submissions.
The most commonly encountered exception warnings relate to Recurrent grant amounts for both teaching and research (Rules 31102 and 31103). These exception warnings involve a cross-comparison with the confirmed grant amounts sent to HESA by the funding councils. Where the level of difference between the funding council figure and that returned in the FSR is greater than £10,000 a warning will trigger.
Tip: Where one, or both, of the Recurrent grant exception warnings are triggered the submitted data should be checked to ensure that it has been reported in line with SORP. Note that it is not expected that an HEP will accrue funding council grants. Grants should be accounted for in the year in which they are received as set out in paragraphs 50 and 52 of the SORP.
From 2011/12, there is now a report generated at commit stage for HEPs in England and Northern Ireland. This report will provide a comparison between the HEFCE financial tables and the FSR. It is expected that there should be consistency between the HEFCE tables and the FSR and HEPs should review this report and explain or correct any anomalies in the tables.
HE-BCI A is not included within the main check documentation for the FSR with HE-BCI data submission. Instead a separate Summary Report is produced which lists all data returned in the Part A web form for the current and previous year.
The table below details the expected year-on-year changes within HE-BCI A and can be used as a basis for data quality assurance checks of the Part A Summary Report.
|Strategy||1||Little or no change year-on-year.|
|2||No significant movement in the type of activities within which the HEP works year-on-year.|
|3||Little or no change year-on-year.|
|4||The data returned should reflect the HEP's strategic priorities. If the HEPs third stream priorities have changed year-on-year this should be reflected in the answers.|
|5||Little or no change year-on-year.|
|6||Little or no change year-on-year.|
|7a||Little or no change year-on-year.|
|7b||Little or no change year-on-year.|
|8||Answers may change if the HEP has introduced new incentives.|
|Infrastructure||9||It is not expected that there would be the same number of staff members in each category.|
|10||Little or no change year-on-year.|
|11||Little or no change year-on-year.|
|12||Little or no change year-on-year.|
|13||Little or no change year-on-year.|
|14||Little or no change year-on-year.|
|15||Little or no change year-on-year.|
|16||Change possible year-on-year.|
|Intellectual property||17||Little or no change year-on-year.|
|18||Little or no change year-on-year.|
|19||Little or no change year-on-year.|
|20||A full response is required to this question where the response to question 19 is 'Yes'.|
|21a||Generally expected that the answers to 21a and 21b will correspond to HE-BCI Part B Table 4 Head 4 Intellectual property (spin off activity)|
|21b||Generally expected that the answers to 21a and 21b will correspond to HE-BCI Part B Table 4 Head 4 Intellectual property (spin off activity)|
|Social, community, cultural||22||Little or no change year-on-year.|
|23||A full response is required to this question.|
|24||A full response is required to this question.|
|25||Little or no change year-on-year.|
|26||Little or no change year-on-year.|
|Regeneration||27||Expected that the answer to 27 will correspond to HE-BCI Part B Table 3 Regeneration and development programmes.|
|28||Generally expected that the level of community engagement will increase year-on-year.|
|Education and CPD||29||Change would be expected if the HEP's education courses, placements policy, RDA involvement or CPD has altered since last year.|
|30||Little or no change year-on-year.|
|31||Little or no change year-on-year.|
|32||Little or no change year-on-year.|
|33||Little or no change year-on-year.|
Contact Liaison by email or on 01242 211144.