A report by auditor general Adrian Crompton found the current system fails to deliver value for money and makes long-term financial planning difficult for local authorities.