In App Transactions for connected Square POS, I get this message "We couldn't Add the transaction(s) due to "Quantity required for tracked Inventory item." Please help!

Hi there, @jacquijax. Let me help you go over essential details concerning the Square importation limits in QuickBooks Online.

We are limited to importing 1,000 rows at a time. If your list is longer than that, I suggest breaking it down into smaller files. Furthermore, it's important to know that once you've imported a list, you can't undo it.

Additionally, adhering to proper spreadsheet format aids in the successful import of items into QuickBooks Online. See details below:

• Product/Service Name: There is a character limit of 100 characters. Avoid special characters. See the approved character list for more info.
• Income Account: You can't use sub-accounts.
• Quantity as of the date: MM/DD/YYYY or DD/MM/YYYY is an example of a format.
• Income and Expense accounts: You can't use sub-accounts.

Feel free to visit this article for more details about importing products and services into QuickBooks Online.

Moreover, check out this link for common questions about importing data to QuickBooks Online.

You're still welcome to ask here if you have concerns about managing your data. Need a guide for handling transactions? Let me know the details and I'll help you out.

Thank you for replying.

I'm not importing a spreadsheet - I am connected through the app.  On the "App Transactions" page within Banking I am trying to add a day's transactions but I am getting that message.  

Thank you.

Thank you for the additional information, @jacquijax . I'll point you in the right direction to get this sorted out so you can proceed to add the transaction into your QuickBooks Online (QBO).

First and foremost, I'd like to express my gratitude for the time and effort you've put into this. In your situation, I'd suggest contacting our support team. A representative can then check and investigate to determine the root cause of this problem. Here are the steps to get started:

1. Sign in to your QuickBooks Online company.
2. Select Help (?).
3. Select either tab to get started:
   
   

• Assistant: Get quick, personalized answers. Select a suggestions option, or type a question or topic you need help with. If you decide  you need further help, you can still Talk to a human.
• Search: Search the QuickBooks Online Knowledge base directly, or select Contact Us nd choose a way to connect with us:
  
  
• Start a chat with a support expert.
• Get a callback from the next available expert.
• As the Community to get help from business like yours.
  
  

Additionally, I'll leave these articles for future reference:

• Manually upload transactions into QuickBooks Online
• Categorize and match online bank transactions in QuickBooks Online
  
  

Feel free to get back to if you have any additional concerns. Rest assured, I'll be here to assist you once again. Have a nice day! 

I am having the same problem. Did you find a fix for this?

Hi there, @brfordyce.

I've come with a solution that can help fix your issue with syncing transactions from Square.

Our product engineers did an investigation on this issue and found out that this happens when the item is tracked as an Inventory item instead of a Service or Non-Inventory. Since the item is actually a non-inventory item, there won't be any quantity associated with it. Thus, it's the reason why you receive an error when adding them to QuickBooks. 

To get this fixed, you'll want to mark the item as a service or non-inventory item and add them to your QuickBooks Online. Also, I suggest having Square validate the items being added as inventory/tracked or as Service/Non-inventory.

This should resolve your issue, @brfordyce. You may also want to learn more about importing your Square transactions in QuickBooks. You can check out this article for the detailed steps and information: Connect your Square account to QuickBooks Online.

Please let me know how it goes in the comment section below. I'm only a post away if you have any follow-up questions.

Hi Mark. All the items in the transactions are non-inventory items in quickbooks. I believe the issue is related to partial payments. I had three different groups of transactions that would not accept. These were all on three different days. Each of these groups had a transaction where a partial payment was made in cash along with credit card. I also noticed the cash part of the transactions had not shown in the cash transaction imports that I had accepted.

I believe the import process has a problem accepting transactions that have been paid using two methods such as credit card and cash.

Hi there, @brfordyce. 

Thanks for getting back to us. 

When you have Square connected in QuickBooks Online, there isn't a way to move the money out transactions. However, you can import them manually. 

Since you're having issues with the import, I recommend contacting our Technical Support Team. This way, an agent can review your account in a secure environment and use their tools to screen share with you. During the screen share, the agent can help walk you through the process and see exactly how you're currently importing the transactions. You can use the link I've included below to connect with an agent directly. 

• QuickBooks Online Support

Additionally, you can see the help article Connect your Square account, that my colleague shared above, for further details about imports. 

Please let me know if you have any questions or concerns. Take care!