cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Lorna
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

 
Solved
Best answer September 09, 2019

Accepted Solutions
Rasa-LilaM
QuickBooks Team

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hello there, @Davejoseph84.


You may encounter this error when the CSV file’s format is incorrect, or the template doesn’t meet the specific requirements. QuickBooks Self-Employed can import CSV files that use either a 3-column or 4-column format.


To seamlessly import the data, check the following information:

  • Remove zeroes (0) from the file and leave those cells blank.
  • Select the column header labels (from the dropdowns) that match the column header labels in your CSV file.
  • The file should contain the following information: Date, Description, and Amount.


For more information about formatting restrictions, check out the Import bank transactions using Excel CSV files article.


If the file format is already properly map, you can now import transactions again. Here’s how:

 

  1. Log in to your QBSE account to access the Transactions tab.
  2. Click the drop-down menu next to Add transaction.
  3. Select Import transactions and make sure it's the same account where you downloaded the data.
  4. Choose Import older transactions under the Action column.
  5. Click the Browse button and locate the file you've exported above.
  6. Select Include all transactions and then review your transactions.
  7. Hit the Continue button and click OK then Done.


Additionally, the following article provides an overview about exporting data:importing transactions in QBSE: Export your data from QuickBooks Self-Employed


Please let me know if there’s anything else I can help you find in QBSE. I’m always here to assist further. Have a good one.

 

View solution in original post

20 REPLIES 20
Lorna
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hi I've been in contact with QB help desk but after 5 days and 15 emails I still dont have an answer. This error come up when i try to import a very simple two lines of cash transactions.
EmmaM
QuickBooks Team

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hi Lorna

 

Thank you for reaching out to the Community. What we can do is look at the CSV and make sure we can get it to upload in a test Self Employed account and then email you back with the amended file as we have looked at your previous contacts and can see you have already gone through some formatting steps which have not resolved the error.We have sent an email to you at the email address registered to the Community

 

Thanks

 

Emma

Davejoseph84
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Did you get a reply? I am having the same issue. 

Rasa-LilaM
QuickBooks Team

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hello there, @Davejoseph84.


You may encounter this error when the CSV file’s format is incorrect, or the template doesn’t meet the specific requirements. QuickBooks Self-Employed can import CSV files that use either a 3-column or 4-column format.


To seamlessly import the data, check the following information:

  • Remove zeroes (0) from the file and leave those cells blank.
  • Select the column header labels (from the dropdowns) that match the column header labels in your CSV file.
  • The file should contain the following information: Date, Description, and Amount.


For more information about formatting restrictions, check out the Import bank transactions using Excel CSV files article.


If the file format is already properly map, you can now import transactions again. Here’s how:

 

  1. Log in to your QBSE account to access the Transactions tab.
  2. Click the drop-down menu next to Add transaction.
  3. Select Import transactions and make sure it's the same account where you downloaded the data.
  4. Choose Import older transactions under the Action column.
  5. Click the Browse button and locate the file you've exported above.
  6. Select Include all transactions and then review your transactions.
  7. Hit the Continue button and click OK then Done.


Additionally, the following article provides an overview about exporting data:importing transactions in QBSE: Export your data from QuickBooks Self-Employed


Please let me know if there’s anything else I can help you find in QBSE. I’m always here to assist further. Have a good one.

 

Jade78963
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hi Yes I did get a reply.

 

I was testing importing petty cash data and was adding a future date and this was causing the problem.  When I tested with the current date it worked.

Good luck

adada
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

I am having this issue even when importing 2 basic transactions with all defined format restrictions


@Rasa-LilaM wrote:

Hello there, @Davejoseph84.


You may encounter this error when the CSV file’s format is incorrect, or the template doesn’t meet the specific requirements. QuickBooks Self-Employed can import CSV files that use either a 3-column or 4-column format.


To seamlessly import the data, check the following information:

  • Remove zeroes (0) from the file and leave those cells blank.
  • Select the column header labels (from the dropdowns) that match the column header labels in your CSV file.
  • The file should contain the following information: Date, Description, and Amount.


For more information about formatting restrictions, check out the Import bank transactions using Excel CSV files article.


If the file format is already properly map, you can now import transactions again. Here’s how:

 

  1. Log in to your QBSE account to access the Transactions tab.
  2. Click the drop-down menu next to Add transaction.
  3. Select Import transactions and make sure it's the same account where you downloaded the data.
  4. Choose Import older transactions under the Action column.
  5. Click the Browse button and locate the file you've exported above.
  6. Select Include all transactions and then review your transactions.
  7. Hit the Continue button and click OK then Done.


Additionally, the following article provides an overview about exporting data:importing transactions in QBSE: Export your data from QuickBooks Self-Employed


Please let me know if there’s anything else I can help you find in QBSE. I’m always here to assist further. Have a good one.

 


 

Michelle_b
QuickBooks Team

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hi there, @adada

 

I want to make sure you're CSV format will correct so that you're able to export into QuickBooks Sel-Employed. 

 

Please note that every bank has different CSV files. With this, I suggest checking the file format associated with your bank. 

 

Once verified, I recommend contacting our Customer Care Team. They'll be able to initiate a screen sharing session to take a closer look to moreover isolate this issue and guide you with the whole process.

 

Here's how to contact them: 

  1. Go to the Help (?) icon on the upper right side. 
  2. Click Contact Us on the bottom part. 
  3. Enter your concern in the description field, then hit Continue
  4. Select your preferred support method.
  • Message an agent (Live chat)
  • Call an agent, or Get a callback

Please check out this article on how to contact depending on what device you've used: Contact QuickBooks Self-Employed Support.

 

Once the importing process is done, you can now assign the transactions to the specific category. For more information, please visit this article: Categorise and edit transactions.

 

Keep me posted on how the call goes or if you have other questions about QuickBooks. I'm always here to provide help. Have a good one.

adada
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hi 

 

I exported an excel from the bank (4 column) and copied the data to a new csv comma delim.. to ensure that there’s no format issue. 

what would you suggest as the next step? 

John C
QuickBooks Team

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hi adada

 

What are the four columns that you have? You should have Date, Description, Money In, Money Out, there should be no symbols in the money columns and we recommend that you refomat the date column. How may lines is the Excel comprised of?

adada
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hi

Yes exactly the same column except Money in/out is Debit/Credit

 

There are no formats on the currency and I tried uploading twice. Once with no format to the date and QB reads it as numbers and once with short for date and then it shows properly on the screen. 

 

I also ensured all transactions with some numbers in the description are also not added. 

 

There are only 2 transactions from past dates in the file. 

adada
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

The thing is your batch update is not designed well....many other people are facing this issue and your product team should build this feature with proper parsing. The amount of time answering, looking for solutions and trying different formats is way more then adding stuff manually. 

adada
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Instead of answering millions of questions and finding clues in other people's answers. Please do me a favor and send me a sample csv file from YOUR side with some transactions that your system accept and let me try uploading that as is. 

 

If it works then your file works and I will replace my transactions, if not then we know it does not and we post on reddit and tell everyone to stop bothering with the same question that has been plaguing the company for a while. 

MJoy_D
Moderator

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

I can help you import your CSV file transaction successfully, @adada.

 

Here's a screenshot of a CSV file format that'll be imported successfully to QuickBooks Self-Employed (QBSE): realCSV.JPG

 

Try to compare it with the CSV file that you have. 

 

I'm always here if you need further assistance. Have a wonderful day!

NasUr
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

same pb here, any luck to fix this issue ?

 

 

EmmaM
QuickBooks Team

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hello NasUr, Could you send us a PM/DM to QuickbooksUK on either Twitter/Facebook or Instagram with a screenshot of your CSV file so we can take a look into why this is happening for you.Thank you.

NasUr
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Screen Shot 2022-05-13 at 4.12.08 PM.png

EmmaM
QuickBooks Team

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Hello NasUr, The date format needs to be in YYYY so in this case 13/05/2022. To do this If you can in the excel file right click on the date column and select to reformat the cell using the date option, once that has been done it will change the column to be YYYY, and then if you can save the file and try the import again. Thanks

NasUr
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

I got same error message as shown down below 

 

 

NasUr
Level 1

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Screen Shot 2022-05-13 at 11.06.04 PM.png

KlentB
Moderator

Error: Uh-oh, looks like we ran into some trouble importing this file. Delete any blank lines in the file, and try again. If you see this message several times, go to Help > Contact us

Thanks for keeping us updated, NasUr.

 

That error message normally occurs if the data on your CSV file is incorrectly formatted. I've also tried creating a CSV file based on your screenshot and was able to successfully import it.  

 

To fix this, you'll want to make sure that the format of the date is mm/dd/yyyy (05/13/2022 ) and the amount should have two decimal places (20.00). Take a look at my screenshots below:

 

importCSV3.PNG

 

importCSV2.PNG

 

I've also included some articles that will help you review and manage your business transactions:

 

Feel welcome to reach out to me again if you need more help in importing your other transactions. I'll always have your back.

 

Need to get in touch?

Contact us