When you say you tried to automate the process were you trying to replace your manual transfer money with a bank rule? Bank Transfer is a short hand transaction but when you use Bank Rules you need to do the long hand transaction - Read here for previous discussion - in your case use Bank/PayPal instead of Bank/Cash