cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here

Reply to message

View discussion in a popup

Replying to:
EduardA
QuickBooks Team

Reply to message

Hi Melwynn, welcome back.

 

What you should do when you see an error while uploading your CSV bank statement into QuickBooks is follow these steps:

 

  • Remove any zeroes (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".
  • Mac users should save the file as a Windows CSV.
  • Make sure the dates use a single format. We recommend using dd/mm/yyyy.

 

To learn more about proper CSV formatting, check out this article: Format CSV files in Excel to get bank transactions into QuickBooks.

 

You may also want to visit this resource for additional tips on resolving common errors when uploading CSV files: Common errors for importing bank transactions using CSV in QuickBooks Online.

 

If you have any other concerns, don't hesitate to reply in the thread.