I haven’t posted for a few days because I’ve been trying to figure out how to download transactions from Paypal to Quickbooks. Well, it’s not going to happen using only the Paypal downloads. it’s just not robust enough.

Firstly, I am in Canada so my main accounting currency is Canadian but most of my sales and expenses are in USD. Paypal allows me multicurrency within my account as does Quickbooks but the download doesn’t work. We don’t even have our date formatted the same way and the month and day are reversed when they come in among various other issues related to currency.  There is no way of associating a sale from Paypal with a sales receipt or invoice within Quickbooks that I could find. I did find a service that lots of folks were recommending. Some were even signing up for a month, downloading and cancelling … doing this quarterly. I will probably try this Simple Port.

I do like them both and I’m sure I’ll find a way to make them play nicely together. I can’t be the first person to try to do this. Surely!