- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
"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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Your Account
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:
- Remove any zeroes (0)
- The Description column should not have numbers.
- Make sure that your date format is 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). 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:
- What to do if you get a bank error or can't download transactions in QBO
- What to do if you can’t find downloaded transactions in QuickBooks
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.
.