Use of B&Bs and hotels as temporary accommodation is costing around £4.5m per month, a report states.