Over 1,000 staff were redeployed to deal with the fall-out from leaving the EU. Now, the financial consequences are coming to light.