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

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    Level 14
    March 9, 2021

    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.


    @Haas CFO 

    Utilize the trial version of this app to isolate the issue

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

     

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