cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Kraanerg
Level 1

Problem Importing CSV files

Imported CSV files into QBSE but columns do not align correctly. Eliminated the "Unique ID" column as it's a constant and adjusted the names but here is no "Balance option". Program will not allow me to move forward no matter what I call the "Balance" column


Unique ID                                            Date                          Description          Amount          Balance
0000403****-170-SDA-0****1   Jan-31-2020                Interest Paid              $0.05         $1,293.56

11 Comments 11
LauraAB
QuickBooks Team

Problem Importing CSV files

Hello Kraanerg,

 

Thanks for joining us! It sounds to me like you're running into this issue when trying to manually import your bank feed or other transactions via the .CSV file. I want to make sure you're able to get this taken care of so you can get back to business.

 

Although I get the feeling you're well acquainted with the process, here's our article for this process, just to make sure you have all the information you need: Add older transactions to QuickBooks Self-Employed

 

For this situation, I'd like for you to get help directly from an agent. They'll be able to work through this with you step-by-step and work through any bumps in the road during the process. You can get help for QuickBooks Self-Employed by following the steps in this link: Contact QuickBooks Self-Employed Support To reach an agent, you can type "talk to human" in the Assistant tool.

 

I hope that helps! Enjoy the rest of your day. 

mark120
Level 1

Problem Importing CSV files

Good Morning,

 

I am having real difficulty uploading my CSV files I have downloaded from my bankl account. HSBC does not allow me to connect direct so I require to import manually. 

 

When I go to import the spreadsheet it 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."

 

I have been trying for two days now. I have tried at work and using my personal computer at home with no luck. I tried using incognito mode and other browsers with no luck. 

 

Is there currently a software error on your side?

 

 

Regards

 

Mark Taylor

LauraAB
QuickBooks Team

Problem Importing CSV files

Hello Mark,

 

Thanks for letting me know what error you're getting when trying to upload you .CSV files. If you're using QuickBooks Self-Employed, I recommend following the same process I gave Kraanerg about contacting support. You've done great troubleshooting so far, and I want to make sure you get this taken care of as quickly as possible. An agent will be able to work with you to figure out what's going on and let you know what steps need to be taken to resolve this issue.

 

I hope that helps!

Alexander5
Level 1

Problem Importing CSV files

Hello, 

I am having issues with self-employed .csv import.

 

I was able to import the .csv I got from CIBC. All the transactions are in QB S-E. The problem is that they all show as credit transactions and thus perceived as income by the software. So they are all wrong. And now I can tell the system to ignore them, this looks really messy. Can you help me clean this mess up?

 

Alexandre

Alexander5
Level 1

Problem Importing CSV files

The .csv file has 4 columns, Date, description, debit, credit.

 

If possible, I would like avoiding to merge the two amounts columns, but I suppose that would solve a part of my problem. I join a picture of the top of the file.

AddieC
QuickBooks Team

Problem Importing CSV files

Hi Alexander5, 

 

I'd urge you to reach out to the designated Self-Employed team directly for any questions pertaining to the Self-Employed product. This team is best equipped to help you with all things related to this version of QuickBooks. Here's where you can contact them: Get in touch.

 

Have a great day.

Alexander5
Level 1

Problem Importing CSV files

Thanks Addie, 

I was told by your sales department there would be no tech support for self-employed, this is why I came here.

Thanks for your quick reply,

 

Alex

AddieC
QuickBooks Team

Problem Importing CSV files

Hi there. There's absolutely tech support for QuickBooks Self-Employed! While they don't have a phone support team, they have email and in-product support available for you. If you'd rather utilize the in-app support, follow the steps here: Contact QuickBooks Self-Employed Support

Haas CFO
Level 1

Problem Importing CSV files

Having the same issue. Was able to import from my credit cards but not my bank. I have tried everything to reformat the bank CSV to no avail. Removed symbols, rearranged columns, mimicked the successful files, nothing works. Big bummer.

Fiat Lux - ASIA
Level 15

Problem Importing CSV files

@Haas CFO 

Utilize the trial version of this app to isolate the issue

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

 

LauraAB
QuickBooks Team

Problem Importing CSV files

Hello Haas CFO,

 

It's good to hear that you've been trying different troubleshooting steps to make sure you can import your bank's CSV files into QuickBooks Self-Employed. I can appreciate how it would be confusing that for the credit card it worked without issue but the bank's file is giving you trouble, even after making sure the formatting is correct. I want to ensure you get the assistance you need with this.

 

Starting with a third-party service that may be able to detect issues with CSV files is a good place to start. It could be there's something that's not immediately visible with the file that's causing the problem, so checking out those kinds of services may be beneficial to getting back on track. Feel free to explore this option if you'd like.

 

This is also a good opportunity to connect with QuickBooks Self-Employed support, as has been highlighted on this thread a few times. I'd just like to take a moment to clarify that process since the article provided previously has been edited from when it was originally posted. The way to connect with the QuickBooks Self-Employed team is as follows.

  1. Select the Assistant feature.
  2. Type and enter "talk to human" in the chat box.
  3. Follow the prompts.

That way, you can connect with a human member of our team instead of the chat bot. Our team member will be able to gather your details and guide you toward a resolution with uploading your file.

 

I hope this helps!

Need to get in touch?

Contact us