cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
Victor-Morel
Level 1

How to solve issue uploading csv file for transactions ?

Since my bank isn't integrated with QB Online, I upload regularly the bank transactions through a csv file. So far it has been working great for a year but today it didn't work. I have used the same csv format as usual, same columns as usual. Nothing different. First try QB got stuck trying to upload the transactions, which was weird bc it never really happened to me. Then i tried again and a mesage appeared : "We can’t upload everything from your file Some info may be missing from your file. Double-check that your file is complete and try uploading again." I am pretty sure there is no mistake with my file.... is this a temporary bug in QB ?
3 Comments 3
AntoniettaE
QuickBooks Team

How to solve issue uploading csv file for transactions ?

The browser's cache can fill up and cause issues like not being able to upload transactions in your QuickBooks Online (QBO), Victor.

 

I recommend accessing QBO in a private or incognito browsing mode. This method helps speed up your computer and free up space, allowing for smoother operations.

 

Here are the keyboard shortcuts for popular browsers:

 

  • Google Chrome: Ctrl + Shift + N
  • Microsoft Edge: Ctrl + Shift + N
  • Safari: Command + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P

 

Once done, log in to your QBO account and upload your transactions again. If you can see them, consider clearing your browser's cache to improve performance and minimize technical issues. Exploring other supported browsers can also be beneficial.

 

Additionally, after successfully uploading transactions in QuickBooks Online, you can review and categorize them into the correct accounts. For detailed guidance on this, please check out this article: Categorize online bank transactions in QuickBooks Online.

 

If you have more questions about your CSV file transactions, feel free to reply here or post on the Community page. We're here to help whenever you need us.

alethea2
Level 1

How to solve issue uploading csv file for transactions ?

Hello there, I am experiencing the same problem. I tried this but it didn't work. Any help would be appreciated.

RCV
QuickBooks Team
QuickBooks Team

How to solve issue uploading csv file for transactions ?

There are a few steps we can take to troubleshoot the issue with uploading your CSV file to QuickBooks Online (QBO) especially if it has been working well in the past, Alethea2.

 

We appreciate you performing some troubleshooting solutions to get this resolved. Let's make sure we choose the correct columns in the mapping stage since QBO is unable to read the data otherwise. Let me guide you on how:

 

  1. Delete columns you do not need from your CSV to avoid any confusion. The columns that are required by QuickBooks are:
    • Date
    • Description
    • Amount
  2. Change the names of the columns in your CSV to match the titles in QuickBooks.

 

Also, some financial institutions don't all create their CSV files the same way. We may need to make adjustments to import your transactions successfully. Here are a few things to look out for:

 

  • Currency symbols and commas: it is best to keep the amounts column as simple as possible.
  • Special characters in the bank description can prevent you from importing your file. Look out for these and remove them before uploading the file again.
  • Check the date format to ensure it matches your chosen one at the mapping stage.

 

For additional tips on identifying formatting issues with CSV files, you can check out this article: Common errors for importing bank transactions using CSV in QuickBooks Online.

 

When your file is formatted correctly, follow these steps to upload them into QuickBooks Online

 

Once you've imported all your bank transactions, categorise and match them to your existing entries to avoid duplicates and efficiently keep track of your business's growth and activities, ensuring everything is accurate.

 

You can always revisit this thread if you have more questions about importing bank transactions or any QuickBooks-related concerns. You have a good one.