cancel
Showing results for 
Search instead for 
Did you mean: 
CB in CT
Level 2

How do I import PayPal data - specifically date,item purchased, Purchaser name, email address, order amount and fee?

 
6 Comments 6
SarahannC
Moderator

How do I import PayPal data - specifically date,item purchased, Purchaser name, email address, order amount and fee?

Hello there, CB in CT. It's nice to have you here.

 

You can import your Paypal data in QuickBooks Desktop or look for a third-party application to import specific details you want from Paypal to your QuickBooks company file.

 

First is to contact the PayPal support team to see if they have the option to export .iif files. If so, you can export the file and save it to your desktop, where you can easily find it. Once done,  proceed with the steps below to import them:

 

  1. Sign in to your company file as an admin. Note: If you’re in Multi-user mode, go to the File menu, then select Switch to Single-user Mode.
  2. Go to the File menu.
  3. Select Utilities.
  4. Select Import, then click Import IIF.
  5. Select the IIF file you want to import, then select Open.
  6. Select OK to confirm the import.

 

If you want to export or edit an IIFs file, you can read this article for details: IIF files.

 

When you want to look for a third-party application, just go to Apps for QuickBooks Desktop.  From the QuickBooks Compatibility section, choose the QuickBooks Desktop version you're using. Then, type in the clue word of the specific app you're looking for in the Search field and click the magnifying glass to search. 

 

If you have any additional questions or need assistance along the way, please feel free to let me know. Take care always and have a good one!

Fiat Lux - ASIA
Level 15

How do I import PayPal data - specifically date,item purchased, Purchaser name, email address, order amount and fee?

@CB in CT 

You may prepare Sales Receipt data in XLS/CSV and utilize one of these importer tools.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

If you don't mind to pay a subscription, consider to utilize another connector to sync PayPal and QB Desktop. 

BigRedConsulting
Community Champion

How do I import PayPal data - specifically date,item purchased, Purchaser name, email address, order amount and fee?

Use our tool, the BRC PayPal Link , to import your PayPal history including all these data fields and more.

CB in CT
Level 2

How do I import PayPal data - specifically date,item purchased, Purchaser name, email address, order amount and fee?

Thank you!  I received multiple options so need time to review.

CB in CT
Level 2

How do I import PayPal data - specifically date,item purchased, Purchaser name, email address, order amount and fee?

Thank you!  I received multiple options so need time to review.

CB in CT
Level 2

How do I import PayPal data - specifically date,item purchased, Purchaser name, email address, order amount and fee?

Thank you!  I will check it out.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us