cancel
Showing results for 
Search instead for 
Did you mean: 
thayesbluvista
Level 1

PayPal - Bank Feed

Hello, Is there a way to use PayPal for the bank feed? I am paid by clients through PayPal. Thank you, thayesbluvista
Solved
Best answer December 04, 2017

Best Answers
AliciaRoy
Level 8

PayPal - Bank Feed

Hi thayesbluvista,

 

I'd love to help you import your PayPal transactions.

 

If you're using QuickBooks Online, you can download the Sync with PayPal app to integrate the two programs. Here's where you can read step-by-step instructions, and watch a video tutorial: https://quickbooks.intuit.com/tutorials/lessons/how-to-sync-with-paypal/. I also recommend checking out this article, which will help you with mapping and first-time setup: https://community.intuit.com/articles/1146124.

 

If you're using QuickBooks Desktop, those transactions will need to be imported manually. First, I recommend contacting PayPal to see if they have the option to export .iif files. If so, you can export the file, save it to your desktop, and then follow these steps to import it into QuickBooks:

 

NOTE: Always do a backup of your file before importing .iif files as they cannot be reversed.

  • From the QuickBooks File menu, select Utilities > Import > IIF Files.
  • Select the .iif file located on the desktop.
  • Click Open.

If you have any additional questions or need assistance along the way, please feel free to let me know.

View solution in original post

jessbru99568
Level 7

PayPal - Bank Feed

HI @thayesbluvista,

Yes, you can use Paypal through the bank feed. Its the best way to connect it and bring in the transactions. You would add it much like any other bank. Go to the banking page, Add account and type in Paypal. Then you will need to enter your login credentials. After that it should bring in your transactions. :)

View solution in original post

13 Comments 13
AliciaRoy
Level 8

PayPal - Bank Feed

Hi thayesbluvista,

 

I'd love to help you import your PayPal transactions.

 

If you're using QuickBooks Online, you can download the Sync with PayPal app to integrate the two programs. Here's where you can read step-by-step instructions, and watch a video tutorial: https://quickbooks.intuit.com/tutorials/lessons/how-to-sync-with-paypal/. I also recommend checking out this article, which will help you with mapping and first-time setup: https://community.intuit.com/articles/1146124.

 

If you're using QuickBooks Desktop, those transactions will need to be imported manually. First, I recommend contacting PayPal to see if they have the option to export .iif files. If so, you can export the file, save it to your desktop, and then follow these steps to import it into QuickBooks:

 

NOTE: Always do a backup of your file before importing .iif files as they cannot be reversed.

  • From the QuickBooks File menu, select Utilities > Import > IIF Files.
  • Select the .iif file located on the desktop.
  • Click Open.

If you have any additional questions or need assistance along the way, please feel free to let me know.

View solution in original post

jessbru99568
Level 7

PayPal - Bank Feed

HI @thayesbluvista,

Yes, you can use Paypal through the bank feed. Its the best way to connect it and bring in the transactions. You would add it much like any other bank. Go to the banking page, Add account and type in Paypal. Then you will need to enter your login credentials. After that it should bring in your transactions. :)

View solution in original post

peterpots1
Level 1

PayPal - Bank Feed

Quickbooks desktop does not give Paypal as an option to set up in bank feeds.  Paypal is not an available choice in the first screen of "Set up Bank Feeds", and there appears to be no way to add it.

Fiat Lux - ASIA
Level 15

PayPal - Bank Feed

@peterpots1 

You may need a 3rd party connector to integrate your PayPal account and QB Desktop.

peterpots1
Level 1

PayPal - Bank Feed

Do you have one to suggest?  The best I have come up with so far is to download an IIF file from Paypal and import it to QB Desktop.  However, this is problematic because it doesn't allow you to accept or not accept transactions that may already be in the register.  

 

Surely SOMEBODY out there has figured out a good way to do this.  I still can't believe that QB doesn't have Paypal set up as a bank feed option.  If it did, then it would be "easy" to download the csv from Paypal, and convert it to a QBO using 3rd party software like CSV2QBO, and import it like any other bank feed.  

 

It really surprises me that it doesn't seem like there is a straightforward way to do this.

LieraMarie_A
QuickBooks Team

PayPal - Bank Feed

Hi there, @peterpots1.

 

While waiting for @Fiat Lux - ASIA's reply, I'm here to help you explore available apps in QuickBooks Desktop. QBDT supports various third-party apps for any functionality you may need. To see if there's an app that can help you accomplish this, head to the Intuit App Center. Then, type a keyword like "Paypal" in the search bar.

 

Here's how:

  1. Go to https://desktop.apps.com/home.
  2. From the QuickBooks Compatibility section, choose the QuickBooks Desktop version you're using.
  3. Type in the clue word of the specific app you're looking for in the Search field and click the magnifying glass to search. 
    Capture.JPG

 

You can read this article for details about tasks you can do with IIF Files: IIF files.

 

Always feel free to visit us here in the Community if you have other questions. I'm just a few clicks away.

peterpots1
Level 1

PayPal - Bank Feed

I don't have Quickbooks Online.  I chose Quickbooks Desktop because Quickbooks Online does not have a Sales Order capability, which I need for my business.  I make product to order, so need to carry the order in QB without invoicing it, until I'm ready to ship it.  Then I convert the SO into an Invoice.  I originally bought QB Online, but even after working with sales/tech support, did not see where there was a good option for what I need to do, carrying a sales order until the product is ready to ship, and I convert it to an invoice.  Am I missing something?  Is there a good way to do this in QB Online?

ReymondO
QuickBooks Team

PayPal - Bank Feed

Hello there, @peterpots1.

 

Yes, you're right. Sales Order feature is unavailable in QuickBooks Online (QBDT). Although, you can use another non-posting transaction such as an estimate. Then, convert it into an invoice to record your actual sales. 

 

To know more about this process, you can check out this article: How to create and send estimates in QuickBooks Online.

 

I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience.

 

 In the meantime, I recommend visiting our Firm of the Future site. This is where we share recent happenings and future developments, such as updates to newly added features.

 

If you have any other concerns, feedback, or questions, don't hesitate and come back to the Community. I'm always here to help you. Have a great day.

Fiat Lux - ASIA
Level 15

PayPal - Bank Feed

@peterpots1 

You may switch to QBO but you will need an additional app to have a sales order feature.

https:// quickbooks.grsm.io/US

https:// quickbooks.grsm.io/us-promo

 

Click our profile name and send your business email address in a private message to us. We may introduce you directly to the app developer to connect your PayPal account and QBD.

serealxo
Level 1

PayPal - Bank Feed

Hello how are you guys saving Paypal as a bank feed? for the detail do i save as Bank on Hand or as chequing? not sure what to save it as!

Mich_S
QuickBooks Team

PayPal - Bank Feed

I'd be glad to help you today, @serealxo.

 

Once PayPal and QuickBooks are connected, you can easily edit, categorize, and match transactions in QuickBooks.

 

Let me guide you on how to connect to PayPal:

  1. From the left, select Apps. Then click on Connect to PayPal.
  2. Select Get app now.
  3. Put a checkmark on the file, then select Install.
  4. Select Let's do it.
  5. Click on Give permission, enter the email address associated with your PayPal account then,  Next.
  6. Log in to your PayPal account.
  7. Hit Agree and Connect. Then, once the connection is established, select Return to Intuit.
  8. Select the PayPal Bank and hit Next.
  9. Select the sales tax rate that will be applied to all imported sales transactions, then select Next.
  10. If you have historical transactions, select the date you like to start importing from, then select Done.

Please feel free to read these handy articles for your reference:
Connect to PayPal FAQ

Use the Connect to PayPal app

 

Let me know if you have additional concerns. Have a wonderful day and take care!

Vegishake
Level 1

PayPal - Bank Feed

Hello, I tried testing out importing a months worth of transactions with paypal iff. the problem I get is that the sales are split between paypal and other income, why does it split? because all of the sales occur the same way through paypal so shouldnt it be all put into the other income like I stated during the download of the iff file. Also it shows all the other incomes sales as negatives? any idea why? and it shows my expenses as positives. So its got them the wrong way round. Also, its added all of the paypal fees to the other expenses, but its just showing as separate/individual expenses, ideally I would have liked it to link the fees to the sales, but thats probably asking too much. so I was prepared to input them manually to the sales. But any idea why it just adds those in on their own. Its not very stream lined. 

 

If you can help answer the questions above with a solution thatll be great. Otherwise I'll be looking at deleting all the paypal fees individually which is tedious and than I'll have to take off the minuses (-) individually and input the paypal fees to the sales. Than go through my expenses and make those minuses and link them to their correct expenses. So, a solution would be great... otherwise I guess I'll live back in the 1900's and get a steam train to work while doing these accounts :'O must be a method to this madness.

TirzahC
Level 5

PayPal - Bank Feed

Hi there, Vegishake.

 

If you've imported the transactions as a CSV file, you'll need to double-check if transactions have symbols or characters. 

 

Let's make sure to map the columns of the uploaded transactions correctly in QuickBooks. This way, you'll see the right split or reverse amounts. You can keep your table layouts separated to get the best preview results. Tables placed inside of tables, or merging and splitting cells can cause unexpected results. You can exclude if you imported the wrong transactions. 

 

As a workaround, you can follow this column format on this article and save the file and import again: How to import bank transactions using CSV files

 

Please let me know how it goes. I'll be around to help. Have a great day.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us