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

"Your file does not contain the three required columns", this is the error message I get when I try to import bank transactions into quickbooks. Please assist

 
1 Comment 1
MichelleBh
Moderator

"Your file does not contain the three required columns", this is the error message I get when I try to import bank transactions into quickbooks. Please assist

I'll make sure that you can get rid of the import error., @lnzandassociates

 

Let's fix the error "Your file does not contain the three required columns" without a moment's delay. This way, you can import your bank transactions in no time. 

 

This error will appear if your comma-separated values (CSV) setup is incorrect. To correct this, ensure to follow our format shown below: 

 

Also, here are a few other things to check if you see an error message when you upload: 

 

  1. Remove any zeroes (0)
  2. The Description column should not have numbers. 
  3. Make sure that your date format is dd/mm/yyyy. 
  4. Mac users must save the file as a Windows CSV file.
  5. Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). To split this, follow the steps in this article: Format CSV files in Excel to get bank transactions into QuickBooks. Directly go to Fine-tune the formatting section.

 

Once confirmed, I'd recommend uploading the data again to verify if it's already performing well. Once accomplished, you can categorise your transactions whenever you're ready. As such, the data will include at the time of reconciliation

 

In case you encounter an issue with the updated transactions, see the following articles for resolution:

 

 

Remember that you can always ask me about any topics or other processes within QuickBooks. I'm always ready to work with you again. Take care, lnzandassociates.