Is the transfer fee added to the Barclaycard account or does it need paying up front?

There's no need to pay anything up front - the fee will be added on to the amount you've transferred. You'll see the total on your next statement and when you complete the transfer online.