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: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Doghouse101
Level 1
posted
‎October 06, 2019 02:03 PM
last updated ‎October 06, 2019 6:03 AM

Importing CSV transaactions from HSBC Midata file

Hi, I'm trying to update QB with Historic transactions from an HSBC account using a Midata file, (which is the only way of doing it with HSBC!!!) and I keep receiving this error message after uploading the file;

 

"Error Importing

Uh-oh, looks like we ran into some trouble importing this file at line Http failure response for https://uk.selfemployed.intuit.com/secure/txImportData/csvImport/788648: 422 OK. Look for a date or an amount that shows odd formatting. Correct it and try again."
 
Any thoughts on how to solve this?
0 Cheers
Cheer
Reply Join the conversation
1 REPLY 1
JessT
Moderator
Moderator
‎October 06, 2019 03:06 PM

Importing CSV transaactions from HSBC Midata file

Hi Doghouse101,

 

Please check the dates of your transactions on your Excel file and make sure they have the correct format (dd/mm/yy). Even a single transaction with an incorrect format can cause an error when importing transactions.

 

If you still get the same error, please contact our Support to check this further. Click Help and choose Contact us.

 

If you have other questions, you can always go back to this thread.

0 Cheers
Cheer
Reply Join the conversation
Featured
Get started with QuickBooks Online
Ready to get started with QuickBooks Online? This walkthrough guides you th...
Read more

Need to get in touch?

Contact us