cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
claus-voigtmann
Level 1

what to do if csv file upload fails continually?

 
2 REPLIES 2
SIAB
Level 7

what to do if csv file upload fails continually?

Try opening your QBO account on any private/incognito browser.

Nicole_N
QuickBooks Team

what to do if csv file upload fails continually?

We need to double check your file format and make sure to choose the correct columns in the mapping stage, Claus.

 

Before importing your file into QuickBooks, follow these steps to make sure it’s formatted correctly:

 

  1. Delete any columns in your CSV file that you don’t need. This will help avoid confusion during the mapping process. The required columns for QuickBooks are:

    • Date
    • Description
    • Amount
       
  2. Make sure the column names in your CSV to match the titles in QuickBooks.
  3. Remove any special characters in your file (like @, #, %, etc.), as they can cause errors. Use Excel’s "Find and Replace" tool to do this quickly.
  4. Ensure the dates in your file align with the format you’ve chosen for QuickBooks mapping, preferably dd/mm/yyyy.
  5. In the Amount, Credit, or Debit columns, clear out any cells with zero values and leave them blank instead.
  6. Make sure the Description column only contains text and doesn’t include numbers.

 

For additional tips on identifying formatting issues with CSV files, you can check out this article: Fix common CSV formatting issues.

 

When your file is formatted correctly, follow these steps to upload them into QuickBooks Online

 

Once you've successfully imported your file, categorise your transactions to ensure everything is accurate.

 

If you have more questions or concerns, please leave a reply below and we'd be glad to further assist.

Need to get in touch?

Contact us