United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BroPar
Level 1
posted
‎February 08, 2022 04:00 PM
last updated ‎February 07, 2022 9:00 PM

Error: Some info may be missing from your file. Double-check that your file is complete and try uploading again.

When importing bank transactions using a CSV downloaded from my Bank, I keep getting this error. I have troubleshoot all the common errors, but keep getting the same error. I am importing December Quarter Deposits, file size is much smaller that maximum, file format is CSV, headings of columns match, date format is correct, data format matches the instructions. Am I missing something?

 

Error: Some info may be missing from your file. Double-check that your file is complete and try uploading again.

Reply
3 Comments 3
IntuitAika
Intuit
Intuit
‎February 08, 2022 04:26 PM

Error: Some info may be missing from your file. Double-check that your file is complete and try uploading again.

Hi BroPar, 

 

Thank you for posting in the Community. Let's try to check your CSV file and ensure that the file doesn't break any of these restrictions. 

 

  • 0's are not allowed anywhere in the file, e.g $0 should be left blank
  • Ensure there are no ( ) used for negative amounts and ensure the column(s) are formatted correctly
  • $ symbols are not allowed, e.g $234 should be 234
  • Commas for thousands are not allowed, e.g 2,111 should be 2111
  • Other special characters such as #, %, and & are not allowed.
  • Correct any transactions with the amount showing in the description column
  • Remove the word “amount" if it appears in the credit or debit column, i.e. credit amount, debit amount
  • Correct and standardise the date format to a single format i.e. dd/mm/yyyy
  • MAC users must save the file as a Windows CSV file

Also, please make sure that your CSV file format has the following columns only: Date, Description and Amount or Date, Description, Debit, Credit.

 

For more detailed information, you can also check on this article on how to import Bank transactions via CSV.

 

Get back to this thread if you need more help. We're just one comment away. Keep safe!

Reply
BroPar
Level 1
‎February 08, 2022 05:07 PM

Error: Some info may be missing from your file. Double-check that your file is complete and try uploading again.

Thanks Anika for the quick response, 

I had read this prior but gave the csv another look over, cleaned the data further removing anything except letters from the descriptions and tried again to import but had the same result. Is there anything else that could cause this error? There are 643 entries over 91 days, could that be an issue?

Brodie

Reply
IntuitSheila
Level 8
‎February 08, 2022 05:22 PM

Error: Some info may be missing from your file. Double-check that your file is complete and try uploading again.

Thanks for getting back to us, BroPar.

 

Are there other columns in your CSV file aside from the Date, Description, and Amount? If so, we'd recommend removing those columns as QuickBooks Online is unable to read that information. Please refer to the sample CSV format below.

 

 

Furthermore, have you tried to copy the CSV file to a new worksheet and format each columns and make sure it followed the accepted CSV format in QuickBooks Online. You can refer to this article to learn more about Common errors for importing bank transactions using CSV.

 

If the issue persist, we'd recommend contacting our Customer Care Team to help check your CSV file in a secure form. 

 

As always feel free to reply to this thread if you have other questions. We'll be here to get back and help you.

Reply