cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

I have spent 7 hours today trying to upload my CSV file today. I have spent an hour on chat support and eventually Claudio R said I needed to follow this guide and that he was not trained on CSV imports.

 

I had actually been using that guide. but the file wouldn't upload.

 

I then spent over an hour on phone support and first of all they denied it was a csv file without even looking at it. Quickbooks displays this error every time I try to upload, after many format changes and various tweaks of the data

 

Something’s not quite right
Error while reading the file. Verify that file type is CSV.
 
Eventually she gave up and told me to ask paypal to check their downloads were good.
 
Is anyone available to look at my file and see if there is a basic error with it. The support did not do any fundamental checks
Solved
Best answer December 20, 2020

Accepted Solutions
hugheskerry
Level 2

Quickbooks refuses to accept my paypal CSV file is good

Wow, I just found (after 3 hours of troubleshooting and following the endless suggestions of formatting from the quickbooks support team) that the issue was that the extension of my file was .CSV instead of .csv  It is beyond me too that not one of the support people knew anything about it.  Thanks so much for posting this fix.

View solution in original post

50 REPLIES 50
Jovychris_A
Moderator

Quickbooks refuses to accept my paypal CSV file is good

Thanks for posting to the Community, @richgilb.

 

If you use the 3-column template, make sure that it has a negative sign on the Amount column (e.g. -100) to mark the value of the transaction as spent.

2.png

 

Besides, if you use the 4-column template, spent should on the Credits side and received is on the Debit side.

3.png


Make sure the columns are in order, and the dates' format is correct and save it as a comma delimited file. It will ensure the transactions are in order.
1.PNG

 

I've added an article as your reference on how to import bank transactions in QuickBooks Online: Import bank transactions using Excel CSV files.

 

Also, you can refer to this article on how to categorize the transactions you have uploaded: Categorize and match online bank transactions in QuickBooks Online.
 

Please let me know if you need further help. I'm always here to guide you. Have a good one!

richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

Step 1. Follow your guide (like I did all day yesterday) and created this file:

https://snipboard.io/jpRA2X.jpg

 

Step 2.  Follow your guide (like I did all day yesterday) and saved as this file type:

https://snipboard.io/No8X5J.jpg

 

Step 3: Follow your guide (like I did all day yesterday) and tried unsuccessfully to upload the file:

https://snipboard.io/4qPBY1.jpg

 

Please also note that your colleague over the phone told me to ask paypal to have a look at their systems when my accountant is able to upload my file in her version of Quickbooks. Consequently, we tried different browsers and then different computers. Does not work. My conclusion is either my account is not correctly set up or there is a bug in your software.

 

It's time you all stopped pushing bad or the same suggestions on me. So please, no more links and have you tried this and that comments. I have 2 professionals working on this for me also. They have yet to resolve it and it is costing me money just to work out how to upload a file. Therefore, it's time for you to take a copy of the file, try to upload it into my account and then tell me what was wrong. I don't care what policy you have regarding getting involved in uploading the data. It's the only help I need now.

 

Then we can all move on.

 

Please advise.

 

 

 

Rea_M
Moderator

Quickbooks refuses to accept my paypal CSV file is good

I appreciate you for following the guidelines on how to upload your Paypal CSV file to your QuickBooks Online (QBO) account and for providing screenshots above, @richgilb. This way, I can provide you an accurate solution to your concern.

 

You're on the right track in preparing your Paypal CSV file. To successfully import your Paypal transactions, you should format your CSV file correctly. Here are the things you need to consider:

  • Remove zeroes from the file and leave those cells blank.
  • Correct any transactions that display a number in the Description column.
  • Remove the word amount if it appears in the name of the Credit or Debit column.
  • Correct and standardise the Date format to a single layout (for example, dd/mm/yyyy).
  • Some banks provide the day of the week and include it in the Date column. To correct this, split the date and the day of the week into two separate columns

 

If you're still unable to upload after having the correct format and extension, I'd suggest contacting our QuickBooks Online Support team again. They have the tool to securely verify your account and check why you're unable to perform the process. They can also walk you through on how to successfully upload the file.

 

After the importing process, you can now assign and categorise your transactions. The system analyses all the information received from Paypal to give you the best possible suggestions for accepting them. For the detailed steps, kindly refer to this article: Assign, categorise, edit, and add your downloaded banking transactions. It contains instructions on how to review downloaded transactions, assign multiple categories, billable customers, and add attachments to name a few.

 

Please let me know if you have other concerns. I'm just around to help.

richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

I immediately went back to live chat, following your advice. I am still on it now, after 1 hour he does not know what to do and so far this does not seem true:

 

'They have the tool to securely verify your account and check why you're unable to perform the process.'

 

At the same time I have 2 consultants trying to sort it out.

 

I have now spent 9 hours on it. I hope this thread serves as useful info to other people considering using Quickbooks. What is clear is this: Quickbook will not go into your account and fix a problem. And this has not been the first problem.

 

This is where I am now. I have been waiting 45 minutes for the chat support agent to get back to me and he is ignoring my messages in this period.

 

hi csv wont load Read
 
Robyn G
 at 11:11, May 1:
is this for banking transactions?
 
 
You
 at 11:11, May 1:
 
 
paypal Read
 
Robyn G
 at 11:14, May 1:
ok no problem, and how are your files formatted
 
 
You
 at 11:14, May 1:
 
 
as per your guide Read
 
Robyn G
 at 11:15, May 1:
ok, no problem, can we set up a screen share?
 
 
You
 at 11:15, May 1:
 
 
ok Read
 
Robyn G
 at 11:15, May 1:
To further understand what’s been happening/what we are trying to achieve, I’d like to suggest connecting to your screen. Before we begin, please close any confidential or sensitive information that you might have opened on your screen. I want you to know that if you feel uncomfortable, you can disconnect by selecting the ‘X’ icon that will appear once we are connected. Stay in front of your computer so that we can work together and so you are able to keep track of everything that we are doing. I will end the remote access once we resolve your query.

When you are ready, please go to this website using another browser:

Once you’re there, it will give you a session key. Please let me know the key so I can proceed on joining the session.
 
 
You
 at 11:15, May 1:
 
 
24510 Read
 
You
 at 11:18, May 1:
 
 
ok, file is ready i think Read
 
Robyn G
 at 11:18, May 1:
yesh so if we try and upload again
 
 
You
 at 11:19, May 1:
 
 
can you check my qb account first? is there something i need to do to get it to accept the file? Read
 
Robyn G
 at 11:19, May 1:
so go back to where you are uploading your CSV to
 
 
You
 at 11:21, May 1:
 
 
there you go Read
 
Robyn G
 at 11:21, May 1:
so if you go through the process and show me where it isnt liking whats goingon
 
 
You
 at 11:21, May 1:
 
 
so you are going straight to upload without assessing the file or account? Read
 
You
 at 11:22, May 1:
 
 
there you go Read
 
Robyn G
 at 11:22, May 1:
so upload
 
 
Robyn G
 at 11:23, May 1:
ah so can we go back to the csv file
 
 
You
 at 11:24, May 1:
 
 
its not a mac Read
 
Robyn G
 at 11:24, May 1:
i want to see if we save it as a CSV file but in a different format, the msone
 
 
You
 at 11:24, May 1:
 
 
so save as a mac csv file on a windows machine? Read
 
Robyn G
 at 11:25, May 1:
the MS one if we can
 
 
Robyn G
 at 11:28, May 1:
do you have access to chrome at all?
 
 
You
 at 11:28, May 1:
 
 
yes. Read
 
Robyn G
 at 11:28, May 1:
can we can we try in chrome?
 
 
You
 at 11:28, May 1:
 
 
makes no difference though. Read
 
You
 at 11:28, May 1:
 
 
ok Read
 
Robyn G
 at 11:28, May 1:
ah really?
 
 
You
 at 11:32, May 1:
 
 
as you can see Read
 
Robyn G
 at 11:32, May 1:
So im just contacting the offline team to see whats going on
 
 
You
 at 11:32, May 1:
 
 
ok Read
 
You
 at 11:34, May 1:
 
 
tell them this too. it loads ok in my accountants verison. yesterday they got rid of me by blaming paypal, which was not an acceptbale conclusion Read
 
Robyn G
 at 11:38, May 1:
can we try saving the CSV file as a new file so if we rename it, sorry just trying to cross out every possibility
 
 
You
 at 11:38, May 1:
 
 
we did do that by adding MS DOS....but anyway.... Read
 
Robyn G
 at 11:38, May 1:
ah sorry yes, excuse me
 
 
You
 at 11:40, May 1:
 
 
can you please rad this link? Read
 
You
 at 11:40, May 1:
 
 
Read
 
Info
 at 11:49, May 1:
Sorry it's taking longer than expected to reply. Your agent will respond shortly.
 
 
You
 at 12:05, May 1:
 
 
can you please let me know if any versions of QB do not allow csv imports? Read
 
You
 at 12:24, May 1:
 
 
you have been gone 45 mins and have acknowledged none of my messages. Please note this makes me think you have left the chat, not a good feeling to have after 9 hours of unsuccessfully tring to load this file.

 

richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

The agent has just closed the chat window, wasting a full morning of my time.

 

So I followed the advice again and got nowhere.

 

 

RaymondJayO
Moderator

Quickbooks refuses to accept my paypal CSV file is good

I can see the value of importing your PayPal CSV file to QuickBooks Online (QBO), @richgilb. I've checked my resources, and there are no reported issues about this. But I have additional steps you can perform to resolve this. 

 

Based on the first screenshot you've provided above, it looks like the date isn't formatted correctly. That may be the reason the system keeps prompting an error while reading the CSV file.

 

To help fix this, I'd suggest using the standard Date format to a single pattern, such as dd/mm/yyyy. In your case, use 09/01/2020. This way, you'll be able to upload the file into the program. I'll guide you how. 

  1. Open the CSV file. 
  2. Highlight the Date column and right-click on it. 
  3. Select Date in the Number tab. 
  4. Choose English (U.K.) as the Locale (location)
  5. Click 14/03/2001 as the Type
  6. Hit OK

 

The screenshot below shows you the last four steps. For more troubleshooting steps, see the Formatting CSV files for import section through this article: Import Bank Transactions.

FormatTheDateCorrectly.PNG

 

Once done, save the file as a CSV type. Then, upload it to QBO again. 

 

After that, you can assign, categorise, edit, and add your imported PayPal transactions. It helps you ensure your financial records are accurate in the software. Just go to the For Review tab to complete this task. 

 

You can count me in if you need anything else. Keep safe always. Stay healthy, @richgilb.

richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

this is the screenshot of an ideal csv as shown to me by your colleague. It conflicts with your suggestion.

 

https://snipboard.io/of2tbS.jpg

 

Also I tried both. It makes no difference.

 

Advice to all reading this. Avoid Quickbooks support when you have CSV issues. I found a guy in India who has identified the problem in 5 minutes for $5.

 

Quickbooks support was going on for about 7 hours or so. And they tell you the wrong stuff.  I spent about 10 hours on it in total.

Thumbs down to all QB support, phone, chat and here.

 

Mike219
Level 1

Quickbooks refuses to accept my paypal CSV file is good

Any chance you'd share the solution to this?  Smiley Happy

 

PayPal use to automatically transfer the transaction fees with sales but as they have stopped doing this I've had to resort to manually uploading the csv export from PayPal.  Well.. attempt to.  I get the same error when trying to import it. 

 

I've tried saving it the csv as a number of different versions and making formatting changes to the document with no success.

 

I'm sure I imported this in the past with no issues at all, but something must have changed?

 

Cheers,

 

Mike

JonpriL
Moderator

Quickbooks refuses to accept my paypal CSV file is good

Hello @Mike219,

 

While waiting for the response from our member, @richgilb, you'll want to make you've meet the following requirements in creating the CSV file of your transactions.

In addition, here's an article you can read to learn more creating a CSV file of your transactions: Import bank transactions using Excel CSV files.

 

Lastly, I've got you these helpful article to help manage your account and transactions: Banking for QuickBooks Online.

 

Keep me posted in the comments if you have any other questions. I'll be here to help.

richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

Hi there. I had to pay a consultant on Upwork to look at the file.  He succeeded in 5 minutes. Instead of describing stuff like 'Paypal Fee' he did this: 'Paypal_Fee'.

 

Forget QB support. You cans see here they don't really read the issue, they just copy and paste the guides. Look how many times they have pasted the guide just on this thread. And the guide does not work.

 

 

lance10
Level 1

Quickbooks refuses to accept my paypal CSV file is good

OP were you able to upload files before with no issues?  I've been uploading fine for years, but just recently started encountering this issue.  So do you need to manually format all of your csv files now prior to uploading?

 

Thanks,

Lance

GlinetteC
Moderator

Quickbooks refuses to accept my paypal CSV file is good

Thanks for joining this thread, Lance.

 

Let me provide additional information about uploading a CSV file in QuickBooks Online. If you go along with the instructions on importing bank transactions from a CSV file to QuickBooks, and yet you're unable to import them successfully, you may consider checking these few things before trying it again.

 

  • Make sure you've chosen the correct columns in the mapping stage. Otherwise, QBO will not be able to read the data. Consider deleting the columns you don't need. QBO only requires the Date, Description, and Amount.
  • Not all banks create their CSV files the same way, so you may need to make extra changes to get your transactions in. A few things to consider looking for are currency symbols and commas, special characters in the bank description, date format should match the one you chose at the mapping stage.
  • Money out transactions only.

You'll want to check the common errors for importing bank transactions using CSV for more details.

 

I'd appreciate it if you'd update me about this. I want to make sure this is taken care of.

richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

Yes, I have to manually format, but note none of the advice I got from QB staff worked at all. The most recent post by a moderator also would nit have worked. I even had a QB support staff on my file for 2 hours. They could not get it to load either and ultimately blamed paypal

Rea_M
Moderator

Quickbooks refuses to accept my paypal CSV file is good

Thanks for getting back to us, richgilb.

 

I'd like to get this issue about uploading your Paypal CSV file resolved. Here in the Community, our top priority is the safety of your account. With this, I'd recommend contacting our QuickBooks Online Support team again. 

 

You can inform our representative about the unresolved issue regarding CSV files so they can trace your previous case. Then, have them investigate further above the problem.

 

In the meantime, you might want to check our Help articles page for future reference. From there, you can read great articles that can guide you about banking, income, and expenses  to name a few.

 

Please let me  know if you have other concerns. I'm always around to help. Take care and stay safe.

richgilb
Level 2

Quickbooks refuses to accept my paypal CSV file is good

been there wasted many hours with qb support...check my account history instead of copy and paste responses maybe?

GraceC
QuickBooks Team

Quickbooks refuses to accept my paypal CSV file is good

Hello, @richgilb.

 

Once you import your PayPal CSV file to QuickBooks Online (QBO), there are certain factors to consider.

  • Make sure the file is on a CSV (comma-separated values) format.
  • Ensure to save your data as a CSV or Comma delimited.
  • Check if the file has blank lines if it does delete them.
  • Please make sure to select the column header labels (from the dropdowns) that match the column header labels in your CSV file.
  • Your CSV file should contain the following information: DateDescription and Amount. Here's how your file looks like when it's ready:

4 columns

User-added image

 

3 columns

User-added image

 

Once verified, you can re-import your transactions following the correct format. You can use these articles for more detailed steps in importing your transactions:

Also, you can categorize, add, and match your bank transaction to avoid duplicate transactions in your QuickBooks Online.

 

Feel free to hit the Reply button to leave a comment below if you have any other questions.

distantunicorn
Level 1

Quickbooks refuses to accept my paypal CSV file is good

Same here - worked fine for months now won't upload in June.

RCV
QuickBooks Team
QuickBooks Team

Quickbooks refuses to accept my paypal CSV file is good

I know how important it is to import your PayPal CSV file to QuickBooks Online (QBO), distantunicorn.

 

I've checked our records, and there are no reported cases about this. I've got some steps we can perform to resolve this. 

 

To successfully import your Paypal transactions, let's make sure we format your CSV file correctly. These are the things we need to consider:

 

  • Remove zeroes from the file and leave those cells blank.
  • Correct any transactions that display a number in the Description column.
  • Remove the word amount if it appears in the name of the Credit or Debit column.
  • Correct and standardise the Date format to a single layout.
  • Split the date and the day of the week into two separate columns. Do this if banks provide the day of the week and include it in the Date column.

Once verified, you can re-import your transactions following the correct format. Just in case you encounter any errors, refer to this article to troubleshoot the issue: Common errors for importing bank transactions using CSV.

 

If the same thing happens, I'd suggest contacting our Customer Support Team. They have the tool to securely verify your account and check why you're unable to upload your PayPal CSV file into your account.

 

Here's how to reach them:

 

  1. Click the Help icon on the top right. 
  2. Tap the Contact Us button at the bottom. 
  3. Enter a short description of your concern. 
  4. Tick Continue
  5. Choose Message an agent to connect with our support. 

 

I've got a link here that provides you with articles about managing your account and transactions: Banking for QuickBooks Online.

 

Keep me posted in the comments if you need a hand with creating bank rules. I'll be here to help. Have a great day ahead. 

finance71
Level 2

Quickbooks refuses to accept my paypal CSV file is good

Quickbooks support used to be great. As anyone reading this thread can see... they now.. are not. 

 

After 4 months of headache and well over 40hrs invested, I stumbled upon the simple (maddeningly simple) solution:

 

- IF YOUR CSV FILE ENDS IN ALL CAPS, LOWER THEM TO LOWERCASE. (i.e. "paypal-export.CSV" will not work; "paypal-export.csv" will)

 

Why not a single support agent or QA tester could locate this solution is beyond me.

distantunicorn
Level 1

Quickbooks refuses to accept my paypal CSV file is good

Update:  Support emailed me a sample csv that I was able to cut and paste, and for some reason that worked, even though the one I created myself looked exactly the same. So if you can't get it to work, ask them for the file! Thank you Roldan.

Jen_D
Moderator

Quickbooks refuses to accept my paypal CSV file is good

I appreciate the time you've taken sharing these brilliant solutions in our forum, @finance71 and @distantunicorn,

 

This will surely benefit other users experiencing the same problem with uploading Paypal CSV files in QuickBooks. It is really helpful to have awesome people like you in the Community.

 

Rest assured, our engineers are constantly looking for solutions to resolve bank issues in our program permanently.

 

Should you need further assistance, please feel free to get back to this forum or connect with me again. Wishing your continued success. All the best!

jlombardo1515
Level 1

Quickbooks refuses to accept my paypal CSV file is good

I ran into the same problem when I was trying to do this.  I tried saving it again using the "save as" menu option and found it was saved as a different type of csv file before.  Excel has 2 different types (CSV UTF-8, which is the original type of file it was saved as, and regular CSV).  Once I saved it as a regular .csv file, it worked.  Hope this helps someone having similar issues so that support doesn't have to get involved at all.

smarque
Level 1

Quickbooks refuses to accept my paypal CSV file is good

Good day. Thank you so much for an article of yours that I came across Regarding the importing of csv files into QBO. The problem that I am experiencing is that in the Amount column it adds on two zeros to the RHS of the amount. Do you have any idea how I can solve? Your help will be greatly appreciated. Alistair

ChristieAnn
QuickBooks Team

Quickbooks refuses to accept my paypal CSV file is good

Hi there, smarque.

 

I'll share information about how to successfully import your transactions using CSV files without any errors and issues.

 

The issue you're experiencing occurs if the bank file format isn’t compatible with QuickBooks. Some financial institutions have set them for the file to be uploaded without flaws. That said, I suggest reviewing your CSV file and enter the format based on the requirements.

 

  • 0's are not allowed anywhere in the file, e.g $0 should be left blank
  • $ symbols are not allowed, e.g $234 should be 234
  • Commas for thousands are not allowed, e.g 2,111 should be 2111
  • Other special characters such as #, %, and & are not allowed.
  • Correct any transactions with the amount showing in the description column
  • Remove the word “amount" if it appears in the credit or debit column, i.e. credit amount, debit amount 
  • Correct and standardize the date format to a single format i.e. dd/mm/yyyy
  • MAC users must save the file as a Windows CSV file

 

For additional information, you can refer to this article: Import bank transactions using Excel CSV files.

 

You can check this article to see a few things to check before importing again your transactions after getting an error: Common errors for importing bank transactions using CSV.

 

Once done, you can now your bank and credit card transactions after you download them into QuickBooks to avoid duplicate entries. Please refer to this article to see the detailed steps: Categorise and match online bank transactions in QuickBooks Online.

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

Need to get in touch?

Contact us