I have just managed to find another chat about this, and it seems this problem has been ongoing since as far back as 2020 so I think I'll just give up and stop wasting my time on it to be honest. Pretty poor show from Quickbooks if you can't sort it out, it's a basic accounting feature that I should be able to use. Very disappointing.