New data has listed the 18 local authorities where financial vulnerability is commonplace and many are cut off from cash.