cancel
Showing results for 
Search instead for 
Did you mean: 
mikelu9661
Level 3

sale receipt not matching with paypal

Hello,
 
I have quickbooks online plus, 
 
I'm having trouble matching my ebay/paypal sales receipt with the feed whenever i include the paypal processing fee within the sale receipt to get a better breakdown of whats my net received. Whenever I include it on my sales receipt, it doesn't have a match or when i tried to manually match it, i get an error saying "Select a bank account for this deposit.", while there no option anywhere on the page for that, and deposit to method is already choosed on the sale receipt, everything is filled in. The match works only when i include the gross amount with no expense deducted, as a gross to gross match then manually deduct the fee from the "resolve the difference". I just find it more convenience when including within the sale receipt, if its possible which i believe it should be but not sure why this error is occuring. Whenever I do other outside of ebay sale receipt to match with my bank deposit that is non-paypal, it seems to match perfectly fine even when i breakdown with the fees within the sale receipt.
 
 
 
I can confirm the below
 
1.) Gross amount is included
 
2.) After fee breakdown, the subtotal sums the net matching the deposited amount (excluding gross)
 
3.) Deposit to account matches
 
4.) Date are either 1-2 days away or exact.
 
5.) I create a service product for the fee product to include within the sale receipt then have a fee charter acct linked to the product.
 
6.) I used - so the breakdown subtotal matches the feed
1 Comment 1
RenjolynC
QuickBooks Team

sale receipt not matching with paypal

I'll help you match the transactions, mikelu9661.

 

We can modify your sales receipt and remove the item for the fee. Then, select Undeposited Funds from the Deposit to field. This way, we can deposit the sales receipt and deduct the fee.

 

Here are the steps:

 

  1. Go to Sales > Customers.
  2. Select the customer's name and open the Sales Receipt.
  3. In the Sales Receipts page, choose Undeposited Funds account from the Deposit to drop-down.
  4. Hit the Save and close button.

Please see these sample screenshots for reference:

 

 

Then, create a bank deposit by following these steps:

 

  1. On the left navigation menu, click the + New button.
  2. Select Bank deposit under Others.
  3. Choose the bank where you want to deposit the sales receipt from the Account drop-down list. 
  4. Under Select the payments included in this deposit, put a check mark on the Sales Receipt box.
  5. Under Add funds to this deposit, select the account for the PayPal fee from the Account drop-down menu.
  6. Enter the other details, and then the fee as a negative amount.
  7. Hit the Save and new button.

Please see sample screenshot below:

 

 

Once done, you can now match the deposit to the downloaded transaction. Here's what it looks like:

 

 

When you're ready to reconcile, I've got this article for future reference: Reconcile an account in QuickBooks Online.

 

Please let me know if you need anything else. I'll get back to you as soon as I can. Have a good day!

Need to get in touch?

Contact us