Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello
While trying to uplaod a CVS file, I get the message "Your file does not contain the three required columns: transaction date, memo and amount."
I have reviewed the file to make sure it is correctly formatted but it just does´t work.
Thanks
Use the trial version of csv2qbo converter tool to isolate the problem.
https://www.moneythumb.com/?ref=110
It's my pleasure to have you here in the Community, @FCbruno. I'll help you fix the error message you've received so you can upload your transactions as soon as possible.
This issue can happen when the CSV file doesn't contain the correct format. I understand that you have reviewed your file already yet the still issue persists. At this time, I recommend you revisit your file to isolate the issue. Make sure that the Date, Description, and Amount columns are available.
Once done, upload the file through the Banking page.
If you're getting the same result, I suggest replicating the steps through a private window to narrow down the result. There are times that cache on the regular browser you're using may affect your QuickBooks experience.
You can use either of these keyboard shortcuts to save you time:
If it works fine, go back to your original browser and clear its cache to refresh the page.
On the other hand, I'm also adding this material for more tips about the supported CSV template for your banking entries: Format CSV files in Excel to get bank transactions into QuickBooks.
Once the transactions are available in QuickBooks, you're now ready to review and categorize them.
I'm happy to help you today. Give me a comment below if you have follow-up questions. I'm always here to provide additional assistance. Keep safe!
Thank you for all the tips but it still does not work. Any other alternatives? Thanks
Good afternoon, @FCbruno.
Thanks for reaching back out to the Community!
If none of the steps worked my colleague provided, I recommend contacting our Customer Support Team for further assistance. Here's how:
It's that easy!
Keep us updated on how it goes. We're always here to have your back. Take care!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here