Question

Cant Import csv files

Forum|Forum|7 years ago
May 4, 2019
2 replies
4 views

Hi,

I'm trying to import CSV files for my bank accounts but am unable to do so. For my National bank and PC Financial Mastercard, there is no response when I select the file. For TD Bank, it shows the transactions but when I click continue, it shows me an error.

Kindly help me solve this.

Thanks

Ravie

QuickBooks Self-Employed

R

RCV

QuickBooks Team

Hi there, raviecharles.

We currently have an ongoing issue about unable to import CSV files into QuickBooks Self-Employed (QBSE). Our engineers are still investigating the cause of this issue.

While we are working on getting this resolved, I'd suggest contacting our QBSE Customer Support Team. They can add you to our notification list and you'll receive an email update for this one.

Here's how to reach them:

Click Help (next to Assistant) menu on the upper right.
Choose Contact us.
Fill in Ask a question (or tell us what’s wrong).
Select Continue.
Choose Chat method to contact support.

For more options on how to contact QBSE Support, you can check out this article: Get help with QuickBooks products and services.

I'll keep an eye on the issue and will get back to you if there's an update.

K

kg13

Still not working for me. When I tried to get help they just referred me to an article where I wasted even more time trying to change things and make it work. This makes it sound as if it just doesn't work for quickbooks self-employed.... Can you just confirm this so I can move on and cancel my subscription? Also there is no way to get to the link to help as you describe above. It just sends to more articles that are of no use for this issue.

AddieC

Level 5

Hi, I'm having the same problem listed above. I have two issues. Either:

1) The upload box turns red and hovering over the Browse button says "Darn. File upload failed. (Probably our fault.) Please give it another try. If you see this message again, you may need to contact us."

2) If I am able to Browse and select the csv file then I get this error: "Error Importing" "Uh-oh, looks like we ran into some trouble importing this file at line Http failure response for https://ca.selfemployed.intuit.com/secure/txImportData/csvImport/887971: 422 Unprocessable Entity. Look for a date or an amount that shows odd formatting. Correct it and try again."

I've been through the csv files according to the solution presented above, and all of the instructions provided elsewhere.

I would happily reach out to talk to someone but when I try to follow the steps above to contact someone (Click on "Help" > "Contact Us") I don't see any place to click "Contact Us." The options appears to not exist.

Hi there. Thanks for joining the conversation! Since you're using the QuickBooks Self-Employed product, the steps listed above may appear differently in your account.

You'll want to reach out to the designated Self-Employed team by filling out the email form found here: Get in touch. Don't forget to select QuickBooks Self-Employed from the product menu.

Alternatively, you can chat with an agent from the in-app chat support channel, as per the instructions here: Contact QuickBooks Self-Employed.

I hope this helps.

Cheers!

C

CBlue

''The date format you chose doesn’t match the date format in the CSV file. Either select another format or correct the dates in the CSV file to continue.''

I was having a very puzzling CSV import issue.

[EDIT : I found the problem on my own and I am posting the solution in order to help other people facing a similar issue.]

SOLUTION : look carefully at your entire data set. The list of rows may be quite long (several hundreds of rows of transactions). Some rows inside your CSV sheet might be missing a single Date.

In my case : 2 rows deep inside my data set were missing a Date ex. dd-mm-yyyy (this was because they were initially coming from a SPLIT expense/transaction imported from my old Quicken Home and Business data file!)

.............

Description of initial problem:

Even tough I successfully imported several CSV files (5 or 6) into various Quickbooks Online accounts (ex. Savings, Chequing data sets) all of a sudden when I try to import a CSV file into a RBC VISA account, the QB system tells me the Date format is wrong.

I used the same Date format as in all my previous files. To see if there was a temporary glitch, I attempted all the following:

- I refreshed the software page and retried

- I resaved my Excel data set into a new fresh CVS file (to avoid possible file corruption)

- I tried different CSV formats (regular CSV for Windows and and CSV UTF-8);

- I tried different date formats : dd/mm/yyyy or dd-mm-yyyy etc

- I tried a regional date format starting with * asterisk ex. *dd-mm-yyyy

- I even tried using a web browser to import the data set, instead of QB windows software, ---- nothing works!

What am i missing?

L

lin_jcaj

Level 9

There is an on-going investigation with regards to importing CSV files, CBlue.

Our product engineers are now investigating to check the root cause of the issue so they can look for a permanent fix. I'd encourage you to give us a call so they can add your company file to the lists of affected users.

Here's how:

Click Help icon in the upper-right corner of the screen.
Choose Contact us.
Enter a brief description of your concern, then click Let's talk.
Choose Get a callback.

I'll make sure to keep you updated once I'll receive progress about this investigation.

It'll be my pleasure to help if you have other concerns.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded