If the transactions was never confirmed than the money never moved. To make the money show up in your wallet just restart your client with the -rescan option.