Process credit/debit cards and ACH (E-check) all from within QuickBooks. Installation is quick and easy!

Review: PayPal Payment Request Wizard for QuickBooks

| June 3, 2008 | 19 Comments

Many businesses (particularly those that sell items on the Internet) use PayPal to process payments. If you are using PayPal but aren’t using an integrated web store application, PayPal offers a Payment Request Wizard that integrates with QuickBooks to let you send invoices to your customers with a PayPal payment button. Today I’ll take a look at this program.

The PayPal Payment Request Wizard is a free program that allows you to send an email invoice to your QuickBooks clients that includes a PayPal payment button. Your customer receives the email and simply clicks on the button to go to PayPal to enter a payment. This isn’t as sophisticated as the QuickBooks Billing Solutions system, but it doesn’t require you to use a merchant service account that requires a monthly fee or minimum. It does require you to have a PayPal business account (but your customers don’t need a PayPal account, they can just pay with a credit card).

At the download site you will see a screen similar to the following:

The web site says that this is compatible with Pro and Premier 2000 and later. The installation program notes also that this is only compatible with the US versions of QuickBooks. I did try it with Enterprise, and it seemed to work, although I did run into a few issues (which might not have had anything to do with Enterprise). It does not work with Simple Start.

You will download a “zip” file which you have to expand into an “exe” file that you can run on your computer. Installation is fairly simple, using standard installation techniques. However, they don’t provide you with all the details you need to have an easy and successful installation. Here is an outline of what you should do (note that I am doing this with Premier 2008 on Windows Vista):

  1. You must install this on a computer that already has QuickBooks installed.
  2. Run QuickBooks and open your company file as the Admin user.
  3. Run the installation EXE file.

  4. When you complete the installation process you will see an icon in the toolbar in QuickBooks. Note that this doesn’t follow Intuit’s guidelines for good programming procedures for QuickBooks compatible programs.

  5. At this point you can send invoices to your customers. However, you will run into some additional setup steps the first time that you use the program with a particular company file. This is important to note, because you must still be logged in as the admin user to be able to complete these steps.
  6. Click the PayPal button. You will get a license agreement window from PayPal that you must agree to (I didn’t see anything unusual here). You will then get this introductory window. Note that it says that your customer must have a PayPal account – that is no longer true, they can pay with credit card without creating a PayPal account.

  7. You can select either an Invoice or an Estimate. There isn’t an option for a sales order. Enter the order ID# – you will have to look it up in QuickBooks and enter it yourself. They don’t provide you with a list of open invoices, or pick it up from the screen in QuickBooks. QuickBooks allows you to enter duplicate invoice numbers, but I didn’t test this program to see what it would do in that case.

  8. At this point the wizard accesses QuickBooks for the first time. QuickBooks will open its standard dialog that deals with outside programs trying to get in to your data. This will only work if you are logged in as the Admin user. It only happens (normally) the first time the program works with a particular company file – after this you can be logged in as any user who has permission to view invoices. NOTE that the program is not “signed” with a certificate – this shows a lack of sophistication on PayPal’s side of things, but it is not a disaster (just make sure you got the program directly from PayPal, and not some other site). Since the program is not signed properly you will have to answer several confirming questions.

     

  9. It is important at this point that you select the third option, Yes, whenever the QuickBooks company file is open. You could possibly choose the fourth option so that you don’t need to have QuickBooks open when sending the invoice, but I don’t recommend that as only one user can be using this approach at a time.
  10. If the Wizard finds your invoice you will see the following screen. Note that you have to enter your PayPal account address (I didn’t find a way to have the program save this, so you enter it each time) and that you can’t change the “subject” line at this point.

  11. You get a confirmation screen:

    There are three “templates” that you can use, detailed, blank and Summary. You cannot change the details of them, they don’t relate to the QuickBooks template at all. So you can’t add custom columns, etc.

    This is a “detailed” preview:

    This is a “blank” preview:

    This is a “summary” preview:

  12. The wizard opens Outlook on my system and creates an email like the following. I doubt that the program will work with another email system other than Outlook, although I didn’t try. You can change the subject here, if you wish. Note, however, that it does not have the customer email address filled in. You have to go back to QB to look that up and fill it in yourself.

The customer will receive this email, and if they click on the PayPal button they will get something similar to the following. Note that they can log in to PayPal to use their account, or use their own credit card without creating an account. This is important as I’ve found many people would rather not create a PayPal account. An important point to make to your customers is you’re your company will never see their actual credit card information, so they don’t have to worry about how secure things are in YOUR company file.

Note that this is not like a “payment request” that you can generate in PayPal. No record of this is added to your PayPal business account until the user has decided to make a payment. Your only record of transmission is in your Outlook “sent” folder.

Conclusion

I have to say that I’m not terribly impressed. This doesn’t have a high degree of integration with QuickBooks. It doesn’t save me a lot of effort, particularly since I have to enter so much of the information each time. If I wanted to do billing of this kind I would consider using the QuickBooks Billing Solutions system, as long as you are happy with their merchant services account (I used it for awhile, liked billing solutions, didn’t find their merchant services to be a good fit for me). The problems that I saw were:

  • The Installation procedure was not clear.
  • The Program not signed with certificate.
  • You have to look up your invoice number instead of just having it taken from the screen, or from a list of open invoices.
  • You have to enter your PayPal email each time.
  • It doesn’t pick up the customer’s email from the customer record.
  • The email message it creates has misspellings that Outlook complained about (annoying).
  • You can’t format the invoice to add your own custom columns, etc.

In addition, on my Vista system, I ran into some operational problems. I didn’t spend enough time to decide if this was Vista, QuickBooks, PayPal or the phase of the moon. This was on my testing system, which has a large number of very odd programs installed. However, QuickBooks runs perfectly well on it. The problem was that after the first time I sent a test invoice, subsequent tests would open five copies of the “select payment type” window (the first step of the invoicing process). I’d complete one of them, and it worked, then I had to close all of the others. Again, this might be a Vista problem, as their installation program and setup seem to be oriented towards XP systems.

Tags: ,

Category: Import/Export, Invoicing, Product Reviews

About the Author (Author Profile)

Charlie Russell is the founder of CCRSoftware. He’s been involved with the small business software industry since the mid 70′s, focusing on inventory and accounting software for small businesses. Charlie is a Certified Advanced QuickBooks ProAdvisor. Look for Charlie’s articles in the QuickBooks and Beyond blog, as well as his California Wildflower Hikes blog.

Connect with Charlie at Google

Comments (19)

Trackback URL | Comments RSS Feed

  1. Geri says:

    I also ran into an issue with QB 2008 Pro (Vista OS) hanging on exit after I installed the PayPal button; sometimes for 5 minutes before it closes on its own. It’s definitely the PayPal module. I uninstalled the PayPal Invoice module to make sure that my system wasn’t at fault; opened my company file and then closed it. No hang time without the PayPal module installed. Reinstalled PayPal and again QB hangs on exit. Is anyone else experiencing this? It is a non issue really; just an annoyance. I’m thinking it may have something to do with the lack of certificate and the Vista UA?

  2. The certificate issue won’t have an effect. That is mostly an issue of making you feel secure that you are installing something from a trusted source. It’s a silly thing for them to not deal with. If you download this from PayPal, not a big deal. If a friend gives it to you, you don’t know that this really is from PayPal.

    I ran my test on Vista Ultimate with User Access Control (UAC) enabled. I didn’t see your problem, but I did see others. Hard to say what the issue is, but there are a few things that PayPal did in this program that aren’t standard. They wouldn’t be able to get this program on the approved list on the QuickBooks Solutions Marketplace because they didn’t follow Intuit’s guidelines, at least to a small degree.

  3. Les Murphy says:

    Great blow by blow instructions. I agree with your findings. To make matters worse, the quickbooks_wizard_US.zip file available from PayPal appears to be corrupt and no response back on my trouble ticket. I’ll try to stay inside of QuickBooks and will advise everyone else to do the same.

  4. Charlie says:

    Les, I just confirmed what you said, the current version of the utility that you download cannot be unzipped. Interesting.

  5. Barry says:

    Sure would like to try this myself, but the utility downloaded from PayPal cannot be unzipped. No response from PayPal. Would it be possible for you to email me a copy?

    • Charlie says:

      Unfortunately I did not save a copy of the file, since I decided to not continue using it. I also sent a notice to PayPal about this without a response.

  6. The instructions show that you can customize the amount you want to request your customer to pay….for instance, i ask for a deposit, so it is only half of the invoice the first time. But when i go into set up my invoice to send it has the “amount” section grayed out. Does anyone know how i can fix this? thanks

  7. Robert says:

    I have given up trying to make the Paypal Payment Wizard work in QB 2009 – it worked wonderfully for QB 2005. But no longer seems to work.

    Paypal “tech support” (if one calls what they have support) claims it no longer works in QB2009. Is this true or what?

  8. Charlie says:

    Robert, I don’t have an answer for you. I didn’t particularly care for the way it worked in the first place, so I’ve not pursued it with them. I’m looking at some other PayPal integration products, but I don’t have any thoughts on them yet

  9. Steve says:

    It appears that whatever issue there was with the zip file has been resolved.

    Also, the utility does work with QB 2010 (at least the Premier).

    • Charlie says:

      Thanks, Steve. I hadn’t looked at that lately. Thank goodness PayPal has listened and fixed that problem.

      I’m still not a fan of their overall process, unless they have improved that as well.

  10. John says:

    I downloaded the request for payment in Quickbooks wizard, followed the instructions, and everything seemed fine. The email I sent to my customer even appeared in my sent mail boz. HOWEVER, my customer never received the email. I tried forwarding her the email in my sent mail box without success too. The email itself works — I even tested it — but I still can’t get the request to be sent. Any thoughts?

  11. Emily says:

    I downloaded the program but can’t get it to do anything. When I put in the invoice # and review the information as I would to send the e-mail, it just freezes and says not responding. I tried it on 2 different office computers several times. I have Premier 2010 Contractor’s edition.

  12. Derrick says:

    I installed it in QuickBooks 2010 Pro and it works okay until you exit, which causes QB to hang. I have to close it out with the task manager. I don’t think I want to do that each time.

  13. LizK says:

    Been searching online and cannot find an answer. When I invoice in QB and use the Paypal link, is there anyway that the invoice can be a PDF but with a link to PayPal? My boss hates the look of the Outlook invoice with the PayPal link. Doesn’t think it looks very professional.

  14. Ed Walker says:

    I installed the quickbooks paypal app on my windows 7 64 bit machine, everything went fine except it will not generate a e-mail and I get some error messages when I close QB.

    Now, my e-mail program opens every time I open quickbooks and open the customer panel.

    I haven’t been able to fix that except by selecting web mail which is not configured.

    Its not a program I’d recommend.

  15. TMelton says:

    I have the same issue with Paypal payment wizard not responding once I hit the create button. I use Thunderbird for my email system and do not have any issues with other programs that auto send things. Bummer, this would have saved me a lot of time. I have QB 2012 Pro. :(

  16. Charlie says:

    I’ve not revisited this particular product since I wrote the article in 2008. There are other options to consider, such as the Transaction Pro Importer (http://www.sleeter.com/blog/2012/02/quickbooks-transaction-pro-importer/) or the PayPal to QuickBooks link from Big Red Consulting (http://www.bigredconsulting.com/).

    Please note that I’ve not tried either of those to import from PayPal…

Leave a Reply