cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
dudeyds
Level 1

Linked paypal account income matching forwarded receipts

Hi,

I process a lot of ebay sales and payments.

I'm trying to forward my emails from paypal for each sale, to match the receipt with each transaction on quickbooks.

The email states the payment received but does not include the deduction for paypal fees.

However the account statement with my linked paypal account does include the deduction for paypal fees.

Ie. I received a payment of £4.85 according to the email, however the statement says it is £4.40.

How can I automatically sort these receipts to make them match the payments in quick books?

2 REPLIES 2
Charies_M
Moderator

Linked paypal account income matching forwarded receipts

Good day, dudeyds.

 

I can help match the Paypal payments with your forwarded receipts in QuickBooks Online (QBO).

 

Let's add the PayPal fee as we deposit the invoice payments to your register. Here's how we do it:

  1. Open the invoice and click the Receive payment button.
  2. Fill in the necessary information. (Select Undeposited Funds in the Deposit to field.)
  3. Click Save and close.

Then, create a Bank Deposit and enter the fee as a negative amount. Please follow the instructions below:

  1. Click the + New button and select Bank deposit.
  2. Select the bank account in the Account field and enter the Date.
  3. Under the Select the payments included in this deposit section, mark the invoice payment.
  4. Go to the Add funds to this deposit section, and select the bank fee account in the ACCOUNT column.
  5. Enter the bank fee as a negative amount and click Save and new.

After utilizing the Receive payment option in the program, you can proceed to the Banking page. Then, match the transaction you've manually created in QuickBooks and the downloaded ones.

 

Here are the steps on how to do it:

 

  1. On the left panel, click Banking or Transactions.
  2. In the For review tab, find the square fee payment. 
  3. If you agree with the match information shown in the row, click the Match button. If not, select Find match to look at the correct one.

In addition to that, you visit these links about reconciliation in QBO:

 Should you need more help in matching transactions in QuickBooks Online, please let me know.

Fiat Lux - ASIA
Level 15

Linked paypal account income matching forwarded receipts

@dudeyds 

As another option, explore this connector to reconcile eBay and PayPal transactions into your QBO easily.

https://synder.grsm.io/quickbooks

 

Need to get in touch?

Contact us