Almost one in 10 (9 per cent) households are in arrears, research from Hargreaves Lansdown has revealed.