Skip to main content
anonimus
Aug 7, 2020 7:32 AM UTC
Solved

error while loading transactions manually

When i try to download bank transactions in format CSV, like this,

 when I click next, I get a message 

"Something’s not quite right
Your file does not contain the three required columns: transaction date, memo and amount."
What's wrong? You can send a sample of the correct format?
AlcaeusF
AlcaeusFAnswer
Aug 7, 2020 8:46 AM UTC

Welcome back to the Community, @anonimus.

 

This error occurs when the mapping of your CSV file is incorrect. Make sure to enter the right columns in the mapping stage so that QuickBooks Online (QBO) will read the data.

 

QBO can import CSV files that use either a 3 (Date, Description, and Amount) or 4-column (Date, Description, Credit, and Debit) format. Change the names to match the titles in the system. Check out this article for the sample template format: Import bank transactions using Excel CSV files.

 

Just in case, I'll add this article for future reference: Common errors for importing bank transactions using CSV.

 

Please let me know in the comment below if you have any other issues or concerns. I'm always here to help. Have a good one!

View in thread

8 replies

AlcaeusF
AlcaeusFAnswer
Aug 7, 2020 8:46 AM UTC

Welcome back to the Community, @anonimus.

 

This error occurs when the mapping of your CSV file is incorrect. Make sure to enter the right columns in the mapping stage so that QuickBooks Online (QBO) will read the data.

 

QBO can import CSV files that use either a 3 (Date, Description, and Amount) or 4-column (Date, Description, Credit, and Debit) format. Change the names to match the titles in the system. Check out this article for the sample template format: Import bank transactions using Excel CSV files.

 

Just in case, I'll add this article for future reference: Common errors for importing bank transactions using CSV.

 

Please let me know in the comment below if you have any other issues or concerns. I'm always here to help. Have a good one!

StephLux
Feb 14, 2021 4:43 PM UTC

Hi,

I have the same CSV importing issue and have been trying all solutions without any success .

My file is set up as requested but I keep having the error message when I try to upload the csv file with my bank statement ...

The following error has occurred:
Your file does not contain the three required columns: transaction date, memo and amount.

Anyone can help ?

Thanks

 

 

Terms & ConditionsAccessibility statement