When importing paypal transactions, specifically ebay sales, then when imported into QBO the paypal transaction creates 4 transactions in QBO and the business profit is wrongly calculated. How can I fix it?

Hello @aybenjas,

In QuickBooks Online, you can exclude your PayPal transactions to fix the profit of your bank account. Let me show you how.

1. Go to Transactions.
2. Select all 4 imported transactions.
3. Click Exclude.

In addition, here's an article you can read to learn more about excluding your bank transactions: Exclude or delete transactions in QuickBooks Self-Employed.

Lastly, I've also included this reference helpful for the steps in reviewing your transactions: How to categorize the transactions you download from your bank or enter into QuickBooks?

I'd suggest getting back to this thread if you need assistance with your transactions. I'm always here to back you up. Take care and stay safe!

Thanks for your response, that solution may not be ideal in my case, let me explain why, this is one example, in Paypal I have one transaction for $24.12, QBO imports it as these four transactions:

1. Funds Availabitlity - <name> (transfer) $24.12
2. Funds Availability - <name> (transfter) -$24.12,
3. <name> (Income) $27.04 and
4. PayPal Fee -$1.08

I could try to exclude the last three transactions, but I have around 2000 transactions that would need to be reviewed as some of them are correct and not others, isn't there a better way of fixing it?

Also the transaction number 1 needs to be changed to Business Income to properly reflect the profit

Thanks for coming back with more detailed information on what you're trying to achieve, @aybenjas. 

As an insight, QuickBooks will only depend on what your bank transmits to us. When the transactions are downloaded, it will go to your For Review section for you to properly categorize them to ensure they're accounted for properly. 

In case you notice duplicates, you can exclude the duplicates or the ones you think are calculated incorrectly. Then, categorize only the correct ones. You can follow the steps to exclude duplicates shared by my peer JonpriL. 

You can also edit or recategorize transactions in QuickBooks Self-Employed to change it to Business income. Here's how: 

1. Go to the Transactions menu, then locate the transaction you want to edit.
2. Select the dropdown icon to expand the transaction.
3. Edit the transaction name. You can also add notes or attach a receipt.
4. Select the link in the Type or Category column to change its category, then select a new category.
5. Click Save when done. 

Here are some helpful resources that can help you decide when to categorize the transactions as business income or expenses, personal, or transfer: 

• Schedule C categories in QuickBooks Self-Employed
• Categorize transactions in QuickBooks Self-Employed 
• Transfers: Owner's Deposit

Let me know if you have additional questions about categorizing transactions in QuickBooks. We're always around here to help in any way we can. 

@aybenjas 

As another option, explore the trial version of SlickConnect to exercise your needs.

https://www.moneythumb.com/?ref=110

Thanks but that solution doesn't work for me because as I said the number of transactions is too large to be feasible to edit one by one to reconcile. What I plan to do is to import CSV reports that I am generating in Paypal, my question now is, how can I completely delete all the transactions that were automatically synchronized from that Paypal account? Then I can import the csv files manually.

Welcome back, @aybenjas.

Since the transactions are coming from your PayPal account, you'll need to exclude them. This way, they'll be completely removed. Then, you can now import your PayPal transactions using CSV files. Here's how:

1. Sign in to your QuickBooks Self-Employed (QBSE) account.
2. Click Transactions from the left menu.
3. Find and select each PayPal transaction.
4. Select the Exclude this transaction checkbox.
5. Click Save.

I'm adding this article for more details: Exclude or delete transactions in QuickBooks Self-Employed.

Just in case you need more guidance importing your transactions from a CSV file, you can read this article here.

Keep in touch if you need any more assistance importing your PayPal transactions. I've got your back.