Someone who is of "no account" is someone worthless. A bank account is a spot held at a bank for someone to make monetary transactions, or to simply store money. This joke is playing on the word "account" and its different meanings. 
A person who would make a banking joke is of no account .