Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 25, 2023
Question

I am getting a error message when I am trying to upload a CSV file. Any suggestions?

  • February 25, 2023
  • 2 replies
  • 13 views
No text available

2 replies

Level 5
February 26, 2023

You've come to the right place for help, aimee. 

 

I know why you're getting an error message while uploading a CSV file in QuickBooks Online. 

 

Ensure that the CSV file is correctly mapped. It's likely the reason for the error. You'll also need to consider these things upon importing:

 

  • The CSV file format is correct.
  • You followed your bank's steps in downloading the transaction into a CSV file.  
  • The transactions are as far back as January 1, 2014.
  • There's no zero from the file. If there are, leave those cells blank.
  • The date format should be dd/mm/yyyy.

 

For more details, check this out: Format CSV files in Excel to get bank transactions into QuickBooks.

 

If you're good, you can re-import the data

 

Here's how: 

 

  1. Go to the Transactions button.
  2. Choose All in the Account and Date drop-down arrow. 
  3. Examine the data. If there are any identical transactions, please delete them.
  4. Review and categorize the transactions to put them in your accounts. 

 

Lastly, can you please share with us the exact error message you get? This helps us determine the best resolution.

 

I've also attached this extra guide for you to keep track of your transactions properly: Categorize transactions in QuickBooks Self-Employed.

 

You can always post back if you have other banking or QuickBooks concerns. I'm always ready to assist. Take care of yourself.

Fiat Lux - ASIA
Level 14
February 26, 2023

@aimee-polzin 

You can use csv2qbo converter tool as a workaround.

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