It is automatic, but the bells get deposited into your bank the next in-game day, not right after the trade.
Which is why I'm not sure what's wrong, OP. If it's the next day then the bells should be in your account. Can't imagine this being the problem, but have you talked to Reese yet? Maybe you need to trigger the "I've deposited the bells into your account" convo first?