Can someone please explain why I am suddenly unable to upload CSV files downloaded and formatted from PayPal? I've followed instructions, removed special characters, etc.

Naomi_Lange · ‎May 01, 2020

AileneA · ‎May 02, 2020

Thank you for reaching out to the Community. Before we dive in with an accurate solution, did you encounter error upon uploading CSV files?

Some importing files has there own set of format. We need to ensure we verify this requirements to prevent any error issues when importing your CSV data.

Also, we can start refreshing your browser to import them within QuickBooks Online. Click the Reload icon or press F5 on your keyboard. It could be that the error is caused by a full cache on our browser.

Let's try to fix it out by following the recommendation below:

Use a different browser like Google Chrome, Mozilla, Microsoft Edge, and Safari. Then, try to import them in your QBO account again. It's a way to verify if the error is caused by having too much data in our browser.
If everything works fine, that would be the time that we can clear the cache to help QuickBooks run better on your computer.
The other option is to use the supported browser in QBO .

Once done, let go back and try to import CSV file from PayPal. Let me show you how:

Select Banking from the left navigation bar, then click File Upload.
On the File Upload page, click Browse.
Choose the appropriate .CSV file then click Next.
From the QuickBooks Account drop-down, select the appropriate bank account you want to import your transactions to, then click Next.
Map the statement fields according to your .CSV file's format.
Then, map the Debit and Credit fields. Debit field in QuickBooks mean money out and Credit for money in. When you are ready, click Next.
If you'd like to exclude any transactions, untick the checkbox next to those transactions, then click Next.
Click Yes to import transactions.

For detailed steps and some tips before you begin importing, check this out: Import bank transactions from .CSV to QuickBooks.

Please know that the Community is always here to help you out. Just click the Reply button, and I'll get back to you. Have a great day!

View solution in original post

AileneA · ‎May 02, 2020

Hi there, @Naomi_Lange.

Thank you for reaching out to the Community. Before we dive in with an accurate solution, did you encounter error upon uploading CSV files?

Some importing files has there own set of format. We need to ensure we verify this requirements to prevent any error issues when importing your CSV data.

Also, we can start refreshing your browser to import them within QuickBooks Online. Click the Reload icon or press F5 on your keyboard. It could be that the error is caused by a full cache on our browser.

Let's try to fix it out by following the recommendation below:

Use a different browser like Google Chrome, Mozilla, Microsoft Edge, and Safari. Then, try to import them in your QBO account again. It's a way to verify if the error is caused by having too much data in our browser.
If everything works fine, that would be the time that we can clear the cache to help QuickBooks run better on your computer.
The other option is to use the supported browser in QBO .

Once done, let go back and try to import CSV file from PayPal. Let me show you how:

Select Banking from the left navigation bar, then click File Upload.
On the File Upload page, click Browse.
Choose the appropriate .CSV file then click Next.
From the QuickBooks Account drop-down, select the appropriate bank account you want to import your transactions to, then click Next.
Map the statement fields according to your .CSV file's format.
Then, map the Debit and Credit fields. Debit field in QuickBooks mean money out and Credit for money in. When you are ready, click Next.
If you'd like to exclude any transactions, untick the checkbox next to those transactions, then click Next.
Click Yes to import transactions.

For detailed steps and some tips before you begin importing, check this out: Import bank transactions from .CSV to QuickBooks.

Please know that the Community is always here to help you out. Just click the Reply button, and I'll get back to you. Have a great day!

Fiat Lux - ASIA · ‎May 02, 2020

@Naomi_Lange

Try open your CSV file, save as XLS, and close the file. Then reopen the XLS file, save as CSV, and close it. Try again to import the CSV file into QBO.

Naomi_Lange · ‎May 20, 2020

Thank you for your reply.

I have tried what you recommended and the issue still persists. I do not have this issue with uploading CSV files exported (then manually formatted) from Stripe, GoCardless or our bank, CAF Bank. The issue only occurs with PayPal transactions.

I have not set up an automatic feed from PayPal because we accept payments in multiple currencies and QBO doesn't support multiple currency in this way. Am I the only one that has come across this issue?

Thanks again for your reply.

The ONLY solution that has been found is to copy and paste each individual cell into a new .csv file. This is entirely unsustainable based on the number of donations we receive. I'm won

JoesemM · ‎May 20, 2020

Thanks for getting back to us, @Naomi_Lange.

Since none of the recommended steps work's for you, I'd suggest giving us a quick call. Our dedicated team can securely access your account and has the necessary tools to double-check what's causing this to happen.

Here's how:

Log in to your QuickBooks Online account.
Click the Help icon located in the upper right-hand corner.
In the Help window, click the Contact Us button located at the bottom.
Enter your question and click Let's talk.
Select Start messaging or Get a callback.

You can also copy the link of this thread in the address bar above and give it to our specialists. This way, there isn't a need to re-explain the situation.

Just a heads up, we have limited staffing and have reduced support hours to 6 AM-6 PM PT Monday-Friday due to COVID-19. We will resume normal hours as soon as possible.

If you have any additional questions, please feel free to reach out to me here in the Community. I'm always here to help. Take good care.

Fiat Lux - ASIA · ‎May 20, 2020

@Naomi_Lange

Another option, utilize the trial period of TP Importer. It would be a serious problem if the tool is unable to read it as well.

https:// transactionpro.grsm.io/qbo

Naomi_Lange · ‎May 21, 2020

Thanks again for your reply.

I've fixed it! Here's how:

Downloaded a different browser, in case it was a browser issue.

Then when I saved the file, I chose 'Save As' then CSV (comma delimited) and within Tools > Web Options > Encoding I chose Unicode (UTF-8). It may have been an encoding issue.

Phew! Glad this is resolved!

Best wishes,
Naomi

Becky29 · ‎May 21, 2020

Awesome :beaming_face_with_smiling_eyes::thumbs_up: Pleased you got it sorted Naomi.

designgirl · ‎May 21, 2022

I'm so frustrated...

I have uploaded my transactions from PayPal in a csv file.

All of my transactions are showing up as deposits!

Also, the transaction fees are not showing up.

Does the system not read debits vs. credits?

I'm so confused!

Would appreciate some help. thank you!!! :)

ShiellaGraceA · ‎May 21, 2022

This isn't the kind of impression we want to leave you with, @designgirl.

I have some information about the PayPal Bank Feeds. To confirm, are your multi-currency feature enabled? If so, we are currently receiving a report about this, and we don't support multi-currency bank feeds.

It's best to reach out to our Customer Care Support. This way, we can add your account to the list of affected users. Here's how to reach out:

Go to the Help menu at the top.
Select Contact Us located at the bottom.
Enter a brief description of the issue and then tap Continue.
Click Chat.

With the above recommendation, you can receive a notification whenever a resolution status is available.

Meanwhile, you can follow the steps found in this article for manually uploading transactions: Manually upload bank transactions into QuickBooks Online.

In case you need help with other bank-related tasks, browse this link to go to the page. It has our general banking topics with articles: Find help with your bank accounts.

Please know that you're always welcome to reply to this thread if you have other banking questions. I'm more than happy to answer them for you. Take care and have a good one.

Topics

Training

Community

Resources

Can someone please explain why I am suddenly unable to upload CSV files downloaded and formatted from PayPal? I've followed instructions, removed special characters, etc.