Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
pridekitty
Level 1

I'm getting Darn. File upload failed when trying to upload transactions. I've verified the colums are only date, description, and amount?

 
1 Comment 1
Ethel_A
QuickBooks Team

I'm getting Darn. File upload failed when trying to upload transactions. I've verified the colums are only date, description, and amount?

The error message shows there's a problem with the CSV file format when importing it into QuickBooks Self-Employed, @pridekitty.

 

Here are some tips to review and fix your CSV file before importing:

 

  1. When checking your file, make sure to clear out any zeros in cells that should be blank and leave them empty.
  2. Make sure the Description column does not include any numbers or special characters.
  3. Delete the word "amount" from the Credit or Debit column header if it’s present.
  4. Make sure the date format is consistent across the file, like dd/mm/yyyy.
  5. Mac users should save the CSV file in Windows CSV format to prevent compatibility issues.
  6. In some cases, banks add the day of the week in the Date column (e.g., 20/11/2018 TUE). To fix this, use Excel's “Text to Columns” tool with space as the delimiter to split the date and day into separate columns, then remove the day of the week.

 

If everything is correct, and still getting the same error. I recommend refreshing the page, log out of your account, and log back in. Upload again your CSV file.

 

Leave a comment below if you have any additional questions about uploading files in QuickBooks Self-Employed.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us