Guidance for users: experimental Statistics on Housing Benefit and Council Tax Benefit flows information
Updated 10 November 2020
Applies to England, Scotland and Wales
The Department for Work and Pensions (DWP) has stopped publishing Housing Benefit flows data in spreadsheet format. The final release in spreadsheet format included data to May 2020.
The flows data is now only released on DWP’s Stat-Xplore, an online tool which allows you to create your own customised tables and charts. Use Stat-Xplore tool to find the latest data.
The guidance on this page is for reference only. New methodology guidance has been published to support the move of data to Stat-Xplore.
1. Summary
This document aims to assist users wishing to use the new Housing Benefit (HB) and Council Tax Benefit (CTB) flows data. It provides background information on the justification for publishing flows data, potential data issues you may need to be aware of, and a description of how the flows data is constructed.
The flows statistics are designed to supplement the National Statistics on caseloads published by DWP. The figures are currently being released as ‘experimental statistics’, more detail on which is available later in the paper.
2. What are HB/CTB flows?
The flows statistics cover information on the number of new and closed claims for a HB/CTB each month.
Definition of an on-flow
An on-flow is defined as being the start of a new claim for HB/CTB.
Definition of an off-flow
An off-flow is defined as being the end of a claim for HB/CTB.
3. Why are the benefit flows figures being labelled as experimental?
Labelling the benefit flows figures as experimental is consistent with UK Statistical Authority guidance on new statistical outputs. It helps to identify the figures as new and demonstrates that we are open to feedback on their usefulness. For more information and guidance on the use of experimental statistics, please visit the following page on the ONS website:
If you have any feedback on the usefulness of the flows statistics, then we would be pleased to receive this using the following email address: stats-consultation@dwp.gov.uk
4. How are the caseload and flows data related?
Many users may assume that the figures contained within the caseload National Statistics and the flows data can be exactly reconciled, so that the opening caseload, plus the people flowing onto the benefit over the quarter, minus the number flowing off benefit over the quarter, will equal the closing caseload for a benefit.
However, although often very close, the relationship between the datasets is more complex with differences arising due to the following:
Flows data is derived by linking two “frozen” caseload datasets together. It is this ‘frozen’ dataset that is used to produce monthly National Statistic[footnote 1] caseload statistics.
Read the methodology used to derive the caseload data.
Off-flow
An off-flow is counted if a claimant appears on month X and not on month Y. For example the May 2009 off-flow figure is calculated by counting claimants that are on the National Statistic “frozen” dataset in April 2009 and not on the May 2009 dataset.
On-flow
An on-flow is counted if a claimant does not appear on month X and does appear on month Y. For example the May 2009 on-flow figure is calculated by counting claimants that are not on the National Statistic “frozen” dataset in April 2009 and appear on the May 2009 dataset.
Limitations
The main limitations with the flows data is that a number of records have missing start dates on the source data[footnote 2] and are therefore removed from the “frozen” caseload dataset. Subsequently the start date can appear in the following months “frozen” dataset so there is a large off-flow one month followed by a large on-flow the next.
The “frozen” datasets contain data that is substituted for months with missing or dubious caseload. This results in inconsistent flows data for these local authorities.
The flows data records people flowing on and off HB/CTB based on their address at the time of flow. It will therefore exclude people who remain on HB/CTB but move between one local authority to another. However, this latter group will be reflected as a change in the overall caseload for a particular local authority;
Rounding to base 10 make it difficult to produce exact reconciliations between the caseload and flows information.
5. Rounding policy
The same policy on data protection and rounding has been adopted for both the National Statistics caseload and flows data which involves rounding to base 10.
-
National Statistics are prepared in accordance with the UK Statistics Authority Code of Practice for Official Statistics. Further information can be found at: http://www.statisticsauthority.gov.uk ↩
-
The source data is the Single Housing Benefit Extract (SHBE). ↩