Does anyone know how to overcome the issue of'missing info' when manually uploading bank data? Some transactions are accepted but majority have a red exclamation mark

Hi there, @cuttingroom-ouim.

Thanks for sharing detailed information about your concerns. The issue you've encountered appears when QuickBooks is unable to read the data you've uploaded due to incorrect mapping. 

To resolve this, ensure you have chosen the correct columns in the mapping stage. To make it easier, delete columns you do not need from your CSV to avoid any confusion. The columns that are only required by QuickBooks are:

• Date
• Description
• Amount

Then, change the names of the columns in your CSV to match the titles in QuickBooks.

For additional insights, you can check out this link to learn more about formatting CSV files in Excel to get bank transactions into QuickBooks. 

Let me know again if you have an additional concern about anything else in QuickBooks. Take care!

Hi Katherine, 

Thanks for the suggestions.  I had already taken all the steps you have suggested.  I even tested a small sample to ensure the correct number of coloumns were used and that all numerical data removed within the descriptions.  Alas!  Still no joy.

I can share some information that can help you with uploading your transactions, @cuttingroom-ouim.

Since you're still having an error after trying the steps provided by katherinejoyceO, I suggest reaching out to our Customer Support team. They can check your file template in a secure environment and help you with the format. 

You can reach our Customer Support for QuickBooks Online (QBO) by going to the Help icon at the top right of the account. Follow the steps below: 

1. Go to the Help icon to connect to a live support agent. 
2. Click on the Contact Us button and provide some details about this concern.
3. Provide us some information about your concern in the What can we help you with? box and click on Continue.
4. You'll now be provided options on how to connect to our Customer Support.

You can check this article for more information about the different types of support we offer and their availability: QuickBooks Online Support.

After adding your transactions, you can now match and categorize those transactions and reconcile them to ensure your books are accurate and there aren't any duplicate transactions:

• Categorise and match online bank transactions in QuickBooks Online
• Reconcile an account in QuickBooks Online

Let me know if there’s anything else that I can assist with about your bank transactions by leaving a comment below. I’m always here to assist. Have a wonderful day!