Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
K
Kraanerg
February 3, 2020
Question

Problem Importing CSV files

  • February 3, 2020
  • 1 reply
  • 0 views

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

    1 reply

    L
    LauraAB
    Level 8
    February 3, 2020

    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. 

    M
    mark120
    February 6, 2020

    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

    L
    LauraAB
    Level 8
    February 6, 2020

    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!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement