Skip to main content
September 25, 2020
Solved

How do i treat a paypal fee in QB when we have received payment for an invoice minus the fee amount?

  • September 25, 2020
  • 2 replies
  • 0 views
The invoice total was say £1000, but after paypal took their fee, we only recieved say £800. I have created an expense for the paypal fee, but how do i connect this expense to the original customer invoice in order for it to be showed as fully paid?
Best answer by GeorgiaC

Hi accounts145, 

 

Thanks for your post. 😊 The steps below cover how to record receiving a payment minus fees in QuickBooks: 

 

1) Raise the invoice for the full amount manually (Sales > Invoices > New invoice)

2) Select 'Receive payment' on the invoice - enter the payment details and receive the full amount to the 'Undeposited funds' account on the 'Deposit to' drop-down

3) Create a bank deposit (+ New  > Bank Deposit) - make sure the date is when the payment hit your account 

4) Tick the invoice payment listed under 'Select the payments included in this deposit'

5) Scroll to 'Add funds to this deposit' - Set the 'Amounts are' drop-down to 'No VAT'

6) On the first line, enter the expense account for fees under 'Account', and enter the fee amount as a minus figure 

7) Check the total bank deposit amount in the top-right matches the payment received then save & close.

 

You can now match this transaction to the payment on your banking screen. As you've already recorded the expense separately, I'd advise deleting this to avoid duplications and follow the steps above to record this. 👍

2 replies

GeorgiaCAnswer
September 25, 2020

Hi accounts145, 

 

Thanks for your post. 😊 The steps below cover how to record receiving a payment minus fees in QuickBooks: 

 

1) Raise the invoice for the full amount manually (Sales > Invoices > New invoice)

2) Select 'Receive payment' on the invoice - enter the payment details and receive the full amount to the 'Undeposited funds' account on the 'Deposit to' drop-down

3) Create a bank deposit (+ New  > Bank Deposit) - make sure the date is when the payment hit your account 

4) Tick the invoice payment listed under 'Select the payments included in this deposit'

5) Scroll to 'Add funds to this deposit' - Set the 'Amounts are' drop-down to 'No VAT'

6) On the first line, enter the expense account for fees under 'Account', and enter the fee amount as a minus figure 

7) Check the total bank deposit amount in the top-right matches the payment received then save & close.

 

You can now match this transaction to the payment on your banking screen. As you've already recorded the expense separately, I'd advise deleting this to avoid duplications and follow the steps above to record this. 👍

September 25, 2020

This is great, thanks so much!!

June 11, 2021

I'm on quickbooks desktop US version. Signed up for quickbooks online UK thinking things are more automated. But they actually arent. So much of it is manual based. Even if you connect your paypal account, all sales go to undeposited, and you have to manually one by one deposit them and place in the fees. When it comes to refunds and partial discounts etc things get a little cray cray. I dont understand how this software especially the online one isnt way more automated, Quickbooks been around since 2010 right? and youre still chasing paypal to give you details that they wont let you have... I dont even know what that signals.