cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
balapham-gmail-c
Level 1

Does anyone have issue with Paypal CSV files after importing? Amounts from csv files from Paypal mastercard were reversed from incoming to spending and vice versa.

For example: I spent $200 for amazon. After importing to QB, it is now reverse to I received $200. And also if I receive the money, it is now marked the amount as spending.
4 Comments 4
GlinetteC
Moderator

Does anyone have issue with Paypal CSV files after importing? Amounts from csv files from Paypal mastercard were reversed from incoming to spending and vice versa.

I appreciate you reporting this issue to us, balapham.

 

Let me provide some insights about importing data and offer assistance to resolve this.

 

When importing data into QuickBooks Self-Employed (QBSE), it is crucial to ensure that data is in the correct format. Let's consider reviewing your CSV file so we can fix this issue. 

 

Additionally, CSV files for credit card accounts may show transactions in reverse. Deposits, for example, may show as negative amounts because paying off your credit card balance reduces it.

 

You can also check these resources for additional reference about uploading transactions with CSV:

 

 

Further, you can assign categories to the transactions to ensure they are allocated correctly on the relevant line of your Schedule CCategorize transactions in QuickBooks Self-Employed.

 

If you have further questions about the process, post them in the comment. I'll be here to assist you more.

balapham-gmail-c
Level 1

Does anyone have issue with Paypal CSV files after importing? Amounts from csv files from Paypal mastercard were reversed from incoming to spending and vice versa.

What do you suggest me to do in this case since my CSV files are already formatted this way? 
Can i manually remove/add the minus sign of the amount to correct them?

balapham-gmail-c
Level 1

Does anyone have issue with Paypal CSV files after importing? Amounts from csv files from Paypal mastercard were reversed from incoming to spending and vice versa.

What do you suggest me to do in this case since my CSV files are already formatted this way?
Can I manually add/remove the minus sign on the files to correct the amount? Or is there any way that I can manually reverse all these numbers from QB? I would hate to go one by one number though so if there is a quick way that I can fix this would be greatly appreciated.
In the attachment below, the black numbers are supposed to be "spending", but in QB it is displayed as deposits, while the red numbers are supposed to be "deposit", but are displayed as negative. 

James_AL
QuickBooks Team

Does anyone have issue with Paypal CSV files after importing? Amounts from csv files from Paypal mastercard were reversed from incoming to spending and vice versa.

I appreciate you for getting back to us, balapham.

 

At present, it is not feasible to reverse the amount in QuickBooks. If you wish to eliminate an erroneous transaction, you may do so by selecting the transaction and clicking on the trash can icon. This process will remove the transaction from the list.

 

To adjust the amount of an expense while reimporting it, it is necessary to include a negative sign beside the expense amounts in the corresponding CSV file. This can be done by modifying the CSV file before importing it into QuickBooks. Once the file is updated, it can be uploaded onto the platform, and the adjusted expense amounts will be reflected accordingly. It is essential to ensure that the updated CSV file is free of errors and follows the appropriate format to ensure seamless integration with QuickBooks.

 

I added also this article so that you can learn how to format CSV files in Excel to get bank transactions into QuickBooks.

 

Lastly, for future help, you can click on this article: learn how schedule C categories appear on reports.

 

Keep me posted if you have other questions about importing categories using CSV files or any other QuickBooks-related concerns. I'll be here to provide you with the assistance you'll need.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up