Reserves

The table shows various statistics about the reserves held by charities in England and Wales, based on data from the Charity Commission register of charities. The columns in the table are:

• ar_cycle_reference - the year the statistics refer to
• no_reserves - number of organisations with no reserves
• with_reserves - number of organisations with reserves
• no_reserves_pc - proportion of charities with zero reserves
• all_charities - number of charities that returned an annual return in this year
• latest_recieved - latest date that an annual return has been received
• latest_fye - latest financial year end an annual return relates to.

The figures only relate to charities with over £500,000 in a year as smaller charities don't return these figures in the annual return. "Zero reserves" actually means less than £10,000 in reserves.

The line chart shows the proportion of charities with zero reserves, by year. The latest year is likely to be incomplete.

Owned by david, visibility: Public

select ar_cycle_reference,
	sum(case when reserves > 10000 then 0 else 1 end) as no_reserves,
	sum(case when reserves > 10000 then 1 else 0 end) as with_reserves,
	sum(case when reserves > 10000 then 0 else 1 end) / count(*)::float as no_reserves_pc,
	count(*) as all_charities,
	max(ar_received_date) as latest_recieved,
	max(fin_period_end_date) as latest_fye
from charity_ccewcharityarpartb cc 
where extract('year' from fin_period_end_date) >= 2016
group by ar_cycle_reference 
order by ar_cycle_reference

select ar_cycle_reference as chartjs_line_label,
	(sum(case when reserves > 10000 then 0 else 1 end) / count(*)::float) * 100 as chartjs_line_value
from charity_ccewcharityarpartb cc 
where extract('year' from fin_period_end_date) >= 2016
group by chartjs_line_label
order by chartjs_line_label