Scottish Welfare Fund Statistics: update to 30 June 2023

How the data is collected

One month after the end of each quarter, Local Authorities are asked to submit an XML file containing the information as set out in the data specification.

The data specification for the Scottish Welfare Fund is available here.

Guidance to help Local Authority officers to record information is available here.

and guidance for Family Reunion Crisis Grants is here.

The data sent to Scottish Government each quarter should include all applications where an initial decision, Tier 1 review or Tier 2 review have been completed, plus any updates to previous cases (e.g. were information within a case has been revised, or a case has reached a different stage). To take account of delays between applications being received and decisions made, and retrospective changes in award values, the data cuts that are sent to Scottish Government each quarter should be sent at least a month after the end of the quarter that will be reported on.

This data is then uploaded to the Scottish Government’s ProcXed website. Once the data has been validated by our software, the data is passed over to the Scottish Government’s Communities Analysis Division.

Revisions

Each updated publication of statistics will include revisions to figures for previous quarters, with more recent quarters being subject to a greater degree of revision than more distant ones. There are several reasons for this:

(i) the cuts of data received by Scottish Government each quarter will include retrospective changes to past applications. For example, where the actual amount spent on an item was different to the amount initially awarded, this expenditure will be updated in the new data cut.
(ii) the cuts of data received by Scottish Government only include information about applications that have at least reached the stage of having an initial decision made. Some applications may therefore be received by the Local Authority in one quarter and decided in the next quarter. Scottish Government would only receive details about these applications in the next quarter’s data cut, at which point the application will be added into the previous quarter’s application statistics retrospectively.
(iii) Tier 1 and Tier 2 reviews can lead to changes in final outcome and final award amount. Where a case has been reviewed, expenditure is assigned to the quarter of the initial decision rather than the review date.

Processing times

Initial Processing Time is the number of working days between the date all information was received and the initial decision. Our count of working days counts the number of Mondays to Fridays between these two dates. No allowance is made for local holidays and bank holidays. If the date all information was provided is missing, the application date is used instead.

Households

We collect information on all people within each application. To group people into household units we filter the people table to contain only the main applicant and their partner. We ensure that there is no more than two people for each application. We generate a unique household reference based on the hashed National Insurance Number, gender and date of birth of the main applicant, and if applicable, their partner.

Repeat applications and awards

An application is defined as a repeat application if the household made another Community Care Grant or Crisis Grant application within the 12 months of the current application. Similarly a repeat award occurs if an award was made within 12 months of the current award. While there is no limit on the number of Community Care Grants an individual can receive in any one year, Crisis Grants are normally limited to three in a rolling 12 month period.

Data quality

To ensure the data we receive is of the highest quality, we have asked all IT providers to implement the data specification as fully as possible. The data specification includes a number of validations. These validations are provided through an XSD schema and have also been implemented into the ProcXed system. Once Local Authorities submit data to the ProcXed system, a number of validations are triggered and warning messages appear. Local Authorities may re-submit data to fix these errors or they can comment them to explain why they believe the data to be valid. On submission of the data to the Scottish Government, each Local Authority is sent a detailed automatic report showing the contents of the data and any remaining errors.

To ensure sufficient data has been submitted, we cross check all submitted data with the monthly management information submitted to the Scottish Government (Chart 7, Chart 8). The automatic reports sent to Local Authorities contain charts which allow them to easily see if there is a discrepancy between these two data sources.

Known data issues:

City of Edinburgh experienced a software issue in March 2020 that has caused some Crisis Grant awards and expenditure from March 2020 to be recorded in April 2020 in the quarterly data extract supplied to Scottish Government. Comparison of the quarterly data to monthly management information (Table 45) indicates that around 1,335 crisis awards and £141,000 associated expenditure made in March 2020 has been shifted into April 2020 in the quarterly data extract used to produce this publication. This means that in Edinburgh in Jan-Mar 2020 around 33% crisis awards and 38% expenditure are missing, and in Apr-Jun 2020 around 17% of crisis awards and expenditure should have been recorded in the previous quarter. Scotland totals will also be affected. It is not currently possible to amend case details so that they appear against the correct month/quarter/financial year.

In March 2020, some COVID-19 related Crisis Grant applications received by Glasgow City were recorded as Community Care Grant applications in the quarterly data extract supplied to Scottish Government. Comparison to the monthly management information (Tables 44 and 45) supplied separately by the local authority indicates that in March 2020, around 1,000 applications, 400 awards and £60,000 associated expenditure has been recorded as Community Care Grants rather than Crisis Grants. However, this is difficult to quantify exactly due to ongoing and pre-existing discrepancies between the monthly management information and quarterly extract. These issues will also affect Scotland totals. From April 2020 onwards the issue of COVID related Crisis Grants being recorded as Community Care Grants appears to have been resolved.

Scotland level figures are affected by specific issues described for Edinburgh and Glasgow and there may be additional issues with data quality related to COVID-19. Comparison of management information (Tables 44 and 45) and figures derived from quarterly data extracts indicates discrepancies in numbers of applications, awards and expenditure for several local authorities. In many cases, the quarterly extract included fewer Community Care Grants and/or Crisis Grants than the monthly figures. This could be due to delays in applications being processed, applications being withdrawn, or awards being kept as 'pending' or 'in principle' on local authority systems until they can be delivered/installed etc. Overall at Scotland level, compared to the monthly management information the quarterly data extracts contained 3% fewer CCG applications, but 2% more CCG awards and 5% more CCG expenditure; while there were 1% fewer Crisis Grant, but 1% more Crisis Grant awards and 12% more Crisis Grant expenditure. Issues caused by processing or delivery/installation delays should be resolved in future updates to the publication as more data extracts are received. Any issues caused by processing or delivery/installation delays should be resolved in future updates to the publication as more data extracts are received.

Missing information/delays in receiving information:

An application is included in the quarterly data extract to the Scottish Government only when an application has been decided and when a payment has been made. For Crisis Grants, applications are less complex and payments are made quickly, resulting in almost no lag between cases being decided and being included in the data extract. However, for Community Care Grants, a large number of items may need to be ordered and payment may not occur until up to one month later, when invoices arrive. This results in a lag time between applications beginning in the Local Authority and applications being included in the extract to the Scottish Government. To rectify this problem, we are asking Local Authorities to submit data one to two months after the end of the quarter. This will ensure that, as far as possible, all relevant cases are included in the data extract.

Some Local Authorities may not have been able to enter all of their data in time to include in this publication. Late entry of data may mean that this data appears in subsequent quarters, rather than in the quarter when the case was actually dealt with. As dates are automatically system generated, late entry of data has a knock on effect on any calculation which involves processing times or payment times.

Some question responses may default to “Other” in some IT systems. This particularly applies for reasons for applications, rejections, reviews and review decisions. We are currently working with IT providers and Local Authorities to ensure that the full range of questions and responses are available in all Local Authority IT systems. Some questions may not be completed at all. This includes the vulnerability and referrals questions for some Local Authorities.

During the Covid pandemic, there have been unusual delays in processing applications due to high volumes of applications for Self-Isolation Support Grants, which are often dealt with by the same teams. This has sometimes led to delays in recording applications and their outcomes.

Midlothian has been unable to provide data at some points since early 2022, leading to estimates of some of their headline figures based on their monthly management information. We are working with them to facilitate a comprehensive update to account for these omissions.

Expenditure:

Unless otherwise stated, all expenditure information in this publication is based on the date of decision. As such it should be regarded as committed spend, rather than actual spend. For example, a Local Authority may commit to purchasing floor coverings for a household and set aside money for this (on the decision date). In practice, it may be some time later before the Local Authority is invoiced and pays the money to the supplier (on the payment date). Overall, there is very little difference between analysing expenditure information using payment dates as opposed to decision dates. Where a case has been reviewed, expenditure is assigned to the quarter of the initial decision rather than the review date. This means that if the initial decision took place in 2018-19 but a review decision is made in 2019-20, all of the expenditure for the case is counted in 2018-19.

It is possible for the value of an award to increase or decrease between the decision and payment date. For example, Local Authorities may estimate the cost of carpets and the final invoice for these may be less than originally thought. This results in money being paid back into their systems. Where we receive updated information about this change in expenditure in quarterly data returns, the statistics for previous quarters are updated to reflect this. We also receive separate reconciliations information from some Local Authorities. Over time, the expenditure data in the quarterly monitoring may exceed monies actually spent if reconciliations are not applied.

West Lothian indicated that the expenditure for 2013-14 is an underestimate. This appears to have been due to issues in setting up the IT system for this data collection at the start of the scheme in 2013. Information about expenditure was collected manually rather than through ProcXed and cannot now be updated. West Lothian have indicated that this has led to an ongoing underspend being calculated for the Local Authority. Additionally, other Local Authorities have indicated that the figures published for annual over- and underspend do not always match Local Authorities’ own accounts.

Where Scottish Government receive updated information about expenditure from Local Authorities, the statistics for previous quarters are updated to reflect this. However, Local Authorities have a cut-off point after the end of a financial year at which point they have to produce accounts. At this point, expenditure for the year is calculated, and over- or underspend is calculated. At this point the council meets the overspend, or rolls forward the underspend to the next financial year’s budget. If there is a change in the value of an award after this date, this will not be reflected in Local Authority calculation of the available budget for the next financial year. Additionally, some Local Authorities may choose to top up the budget for the fund at the start of a financial year with additional funds.

In earlier publications, we included funds provided by Local Authorities in the available budget. However, this funding has been removed from calculations. Available budget therefore only represents the amounts allocated by Scottish Government plus any underspend from previous years, and it is assumed that Local Authorities meet any overspend each year.

Each year the discrepancies between these annual expenditure figures and Local Authorities’ accounts are compounded. We are reviewing these differences and to realign our calculation of Local Authorities’ over- or underspend.

Joint Community Care Grant and Crisis Grant applications:

Households can apply for both Community Care Grants and Crisis Grants in the same application. In versions of the publication covering the period up to December 2017, total applications reported were the total number of applications recorded on Local Authority IT systems. In some Local Authorities, these applications in some cases will include both a Community Care Grant and a Crisis Grant element. However, some Local Authorities now have a facility to split a single application into the Community Care Grant and Crisis Grant elements, and treat these as two separate applications. Where Local Authorities have used this facility on their IT system, Scottish government would receive this as two separate applications, with no information about whether they had originally been made together as one application.

Because of this, we changed the methodology for how total applications to Scottish Welfare Fund are reported from the 2017-18 publication onwards. For all Local Authorities, we now report the number of Community Care Grants and number of Crisis Grant applications added together. Therefore, joint applications for Community Care Grants and Crisis Grants will now be counted in the figures as two applications. This makes the figures for total Scottish Welfare Fund applications consistent across all the Local Authorities. In addition to the issue described above, Local Authorities have informed us that on some occasions, applicants may tick boxes on their application forms to apply for both a Community Care Grant and a Crisis Grant, but based on the types of item that have been requested, the Local Authority may process this application as only a Community Care Grant (e.g. if only flooring requested) or only a Crisis Grant (e.g. if only food requested). In these cases, the statistics in this publication reflect the way in which an application has been processed by the Local Authority, rather than the original tick boxes selected by an applicant.

Reviews:

Orkney are unable to supply Tier 1 review information via the ProcXed system. Orkney have supplied full details about all reviews carried out separately, however numbers are small.

East Ayrshire were unable to submit data on Tier 1 reviews via the ProcXed system until July 2018, but were able to supply summary information about numbers of review applications and decisions separately for 2014 onwards, which is included in the publication tables. This accounts for a small proportion of grants where it is unknown if reviews were made within target times. From July 2018 onwards, East Ayrshire have supplied full review information via ProcXed.

Improvements:

We continue to work with Local Authorities to make the data more consistent across data fields and Local Authorities. We are reviewing how Local Authorities interpret the guidance and record information and also identifying issues that are due differences in IT systems.

Coverage:

Charts are truncated to start from April 2018. This is to enhance readability and to focus on the most relevant trends of recent years. Earlier data back to the start of the scheme can be found in previous releases.

Comparisons with other UK Statistics

Annual reports by the Secretary of State for Work and Pensions on the Social Fund for the period prior to 1 April 2013 are available from the Department for Work and Pensions. The most recently available report can be found here.

On 1 April 2013, the Department for Work and Pensions devolved the responsibility for Community Care Grants and Crisis Loans to the Scottish Government, the Welsh Government and directly to English Local Authorities.

As a single national scheme covering the UK is no longer in operation, comparable statistics for other parts of the UK are not available.