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

Quickbook is linked to paypal, but I can't see how fees are taken into account

Hello everyone

 

I have my Quickbooks connected to my business PayPal account so that transactions are easily imported when I click the update button.

 

The import works, but it doesn't seem to take into account the PayPal fees? Here is a real transaction from my account on PayPal:

 

paypal-transaction.png

As you can see, although I received £23.98, when I actually have in my paypal account is £22.98 because of the £1 PayPal fee.

 

In Quickbooks, that £1 fee is nowhere to be found, and it tells me that I received £23.98!

 

quickbooks-transaction.png

 

How can I tell Quickbooks that infact I was charged £1 fee on tat particular transaction? I'm confused.

4 Comments 4
MariaSoledadG
QuickBooks Team

Quickbook is linked to paypal, but I can't see how fees are taken into account

Let me help you with this, J59.

 

You can create an invoice with the exact amount of 23.98. Then, record a receive payment for the same amount for payment. Here are the articles for the steps:

 Here' how:

  1. Select + New.
  2. Then select Invoice or Send Invoice.
  3. From the Customer ▼ dropdown, select a customer. Make sure all of their info is correct, especially their email address.
  4. Review the Invoice date. If you need to, change the due date in the Terms ▼ dropdown.

    Tip: Net refers to the number of days until the payment is due. The default is 30 days, but you can change the due date if needed.

  5. From the Product/Service column, select a product or service. You can also select +Add new to create a new product or service right from the invoice.
  6. Enter a quantity, rate, and amount (22.98)
  7. Select the Tax checkbox if you need to charge sales tax.
  8. Click Save and send

Once done, you can receive payment with the same amount of the invoice. Please check this article for more information: Record Invoice Payment in QBO.

 

Finally, create a deposit selecting the 23.98 item. Then, add a line item with negative amount for the PayPal fee.

  1. Click + Plus.
  2. Select Bank deposit.
  3. Fill in the necessary information such as the Received From, Account, Description, and Amount.
  4. Click Save and close.

You can also add and match bank transactions in QBO: Categorize And Match Online Bank Transactions In QuickBooks Online.

 

Let us know if you need further assistance. I'll be right here to help.

J59
Level 1

Quickbook is linked to paypal, but I can't see how fees are taken into account

Thanks Maria, those steps seem quite involved. Are you saying for each imported transaction from PayPal (there are nearly a 1000), I am going to have to create an invoice for each!? 😮

J59
Level 1

Quickbook is linked to paypal, but I can't see how fees are taken into account

Thanks Maria, those steps seem to require a lot of effort.

 

I wouldn't mind if it was 1 or 2 transactions, but this problem is happening on all the transactions that I've imported from PayPal.

 

Are you saying I would have to do all that for every transaction I imported from PayPal?

SarahannC
Moderator

Quickbook is linked to paypal, but I can't see how fees are taken into account

I’m glad that you were able to get back here, J59.

 

Let me provide additional information about handling Paypal fees in QuickBooks Online.

 

I see that manually recording transactions would take a lot of time. And, I agree with you that it requires a bit more effort when there are hundreds of imported transactions within the Banking page. 

 

The fees will be added when you match or add a transaction in the For Review tab. Please know that these fees are obtained from PayPal, which they’ll not show as separate transactions in your feed. 

 

Let's say you imported hundreds of transactions within QuickBooks. What we are going to do is match them, and the system will add the fees with these transactions. Here's how:

 

  1. Go to Banking on the left panel.
  2. Within the Banking tab, make sure you are in the For Review section.
  3. Find the downloaded transactions associated with the fee.
  4. Click Add or Match under the Action column.

 

Sample screenshot:

q.PNG

 

Here's an article where you can get more details about it: Categorize and match online bank transactions. Also, you may want to visit here and gather more information about frequently asked questions in Paypal.

 

I hope for nothing but the growth of your business. Please stay in touch if you require additional details with this. I'd like to assist and help you more. Keep safe!

Need to get in touch?

Contact us