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.

Reply to message

View discussion in a popup

Replying to:
LieraMarie_A
QuickBooks Team

Reply to message

Hi, @enzo73. I'll ensure you can upload your CSV file successfully. 

 

There may be an issue with the file format. Let's ensure your data follows the 3-column or 4-column format. The 3-column format has DateDescription, and Amount columns. See the screenshot below.

 

 

The 4-column format has DateDescriptionCredit, and Debit columns.

 

 

Please take note that CSV files for credit card accounts may display transactions in reverse. For example, deposits may appear as negative amounts because paying your credit card reduces your balance. 

 

Then, if you get the same error message when you upload, do the following:

 

  • Remove any zeros (0) from the file. Leave those cells blank.
  • Correct any transactions that display numbers in the Description column.
  • Remove the word "amount" if it appears in the Credit or Debit column header. They should only read "Credit" and "Debit" without the word "amount."
  • Make sure the dates are in one format. We recommend you use: dd/mm/yyyy.
  • Mac users must save the file as a Windows CSV file.
  • Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). You need to remove the day of the week. To do this, split the date and the day of the week into separate columns:
    1. Open the CSV in Microsoft Excel.
    2. Highlight the column that contains the date.
    3. Go to Data then select Text to Columns.
    4. Follow the onscreen steps and select the following:
      • Original data type: Delimited
      • Delimiters: Space
      • Column data format: General

 

You may also have too much accumulated historical data. Whenever you visit a website, it saves some information from the web page in its cache and cookies. These files allow the websites you visit most often to load faster. Not to worry, clearing them will do the trick.

 

First, let's try accessing your account through an incognito window to rule out the possibility of a webpage issue. You can refer to these shortcut keys to open an incognito window in all supported browsers:

 

  • Chrome: Ctrl+Shift+N
  • Firefox: Ctrl+Shift+P
  • Safari: Command+Shift+N

 

If the upload goes through, switch back to your regular browser. Then, clear its cache. This way, you can access QuickBooks with a clean slate. You can also use a different supported one.
 

Finally, review and categorize your transactions to put them in your accounts.

 

Be sure to keep in touch if you need more help with managing your bank feeds. We want to ensure this matter gets resolved. Have a good one, @enzo73!

Need to get in touch?

Contact us