When there are active upgrades for a member, when they click the 'Account upgrades' link in the visitor menu they will see purchased upgrades as in this example:
If you would like to send an email about expired upgrades automatically, you might like this add-on: