Import CSV issue - Cannot read properties of null (reading 'code')

EddieDelag · ‎March 19, 2024

Intuit and The Cooperative Bank refuse to play nicely together.

EVERY time I use QB, whether on app or pc, I receive an OTP. It's incredibly annoying.

But it gets worse. Now, QB won't import csv's from the bank.

I see this error a lot:

Error Importing

Darn. File upload failed. (Probably our fault.) Please give it another try. If you see this message again, you might need to contact us.

After trying to import again I receive this:

Error Importing

Uh-oh, looks like we ran into some trouble importing this file at line Cannot read properties of null (reading 'code'). Look for a date or an amount that shows odd formatting. Correct it and try again.

Everything looks fine on the csv and I've even tried a csv with just a single line in it and even that gives the same error. I've even tried different types of csv. Nothing works and I've wasted far too much time on this.

Can somebody suggest something other than me switching to Xero?

4Gal · ‎March 19, 2024

Do you have QB Desktop or QB Online?

EddieDelag · ‎March 19, 2024

Online

emmam6 · ‎March 19, 2024

Hello EddieDelag, thanks for contacting the Community about your experiences with the connection to the Co-operative bank in QuickBooks. We appreciate that it can be frustrating using a code every time, however in order for us to have the open banking connection as a third party it was determined through talks and testing with the Co-operative that our users would need to use Strong Customer Authentication (SCA) to connect. Therefore, you'll need to enter your user ID and password when updating transactions.

In regard to the error message when uploading a CSV. CSV's often need to be formatted to be uploaded into different systems and changes in formats at one side can affect the other. For example, the date format dd/mm/yyyy that QuickBooks reads and the one your bank has may differ in format in the coding.

To determine if that is the reason, if you can go to the CSV, click on the column with the date on at the very top>format and then find date and select the date format dd/mm/yyyy and save the CSV and then try the upload again. If that does not work can follow this article on formatting CSV's and try the other steps

We are including a help article on importing a CSV here just as a helpful resource. In particular step 3 on formatting.

Feel free to come back here if none of this works for you we'd be happy to help further or with any questions that you may have.

4Gal · ‎March 19, 2024

@EddieDelag

Use the trial version of csv2qbo converter tool to isolate the problem.

https://www.moneythumb.com/?ref=110

Topics

Training

Community

Resources

Import CSV issue - Cannot read properties of null (reading 'code')