If I get QB Online and sync with Square, will Square send QB inventory data?

Hello watercolorgirl77,

When you increase the inventory in QuickBooks Online, it doesn't affect Square data. Square only imports your invoices and payments to QuickBooks. However, it doesn't manage your QuickBooks inventory.

To know more about Square and QuickBooks Online integration, you can use these articles for reference:

• Sync with Square
• Sync with Square Hub

Feel free to let us know if you need anything else.

What is a "csv" as mentioned in the reply?

A warm welcome to the Community, pawfittergirl.

Let me share what I know about the CSV file in QuickBooks Desktop.

A Comma Separated Values (CSV) file is a plain text file that contains a list of data. These files are often used for exchanging data between different applications. Since CSV files store information in a text-only form, support for saving the file to another format is included in lots of different online services and downloadable programs.

You can check this recommended article to know more about CSV file format: Import/export CSV files.

Feel free to get back to me if you require more information about CSV file. Have a great rest of your day.

I will be trying this tomorrow ! Hope it works.

Has anyone been able to solve this problem? As far as I can tell no one seems to be able to and it seems like it should be fairly simple. It is my understanding that the issue is that Square has a tab called Variation while quickbooks does not allow for this and therefore cannot import the data from square invoices to match in quickbooks. When I sell a brand with item name "Hawaii Bee Company" and I sell soap, it only knows that the name is Hawaii Bee Company but is does not allow for the soap to be subtracted from soap inventory only that something sold from that brand. This is a major issue that makes this feature completely incompatible with any importing of inventory data since all retail I know has varying types of the same brand. 

Hi @KauBookeeping,

I understand that Square has a variation of each item. However, QuickBooks will only receive compatible data when importing inventory data from Square.

As mentioned by IntuitTony, you can consider setting up an identical item list by exporting your list as a CSV from Square and manually import it to your QuickBooks. That way, the integration will record sales item accordingly in QuickBooks.

In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBDT Self-help.

Feel free to leave a comment below if you have any questions. I'll be right here to help.

Hi,

I subscribe QB Online with the hope to have a real integration between the 2 software but apparently this is not real. So, for example, if I purchase more products and add the Purchase on QB, I'll need to add manually all the items in Square too?

The integration between QuickBooks Online and Square has its own limitation at the moment, vaneprovin.

It's currently a one-way integration which we only receive data from Square. This means you'll need to update the quantity of the product in Square first. QBO will then mirror the information once we receive daily updates from them. 

We'll send your feedback directly to our engineers. Updates and product enhancements are often based from feedback and suggestions that are sent to them.

The Community is always ready to help you again if you have other questions. 

Hi @Anonymous 

Thank you so much. I look through it, but I currently have a Wix website, and they don't support this integration with Wix, only with other platforms.

To pay that amount of fees they charge it would be great to integrate with my website too. I'll consider changing my website to another platform. 

Thanks anyway!

Thank you very much @JenoP for your help. 

In this case, everytime I change my inventory on Square, it will change the quantities automatically on QB through the daily updates? 

Thanks for sending my feedback to the engineers, I think that would be a great and necessary improvement in the software.  

That's right, vaneprovin.

Once you update your inventory in Square it will sync in QuickBooks. You can check that here: https://quickbooks.intuit.com/integrations/square/. Click QuickBooks, and you'll see it under Always know what’s in stock.

We always want what's best for our customers. Your feedback can help our developers improve the features in QuickBooks.

If any other concerns arise, please feel free to post any time.

This is only in Quickbooks. Inventory should automatically be pushed to Quickbooks from Square via the integration.  This is the missing piece.  When do Quickbooks plan to add this to the integration with Square.

QBO is already set to integrate to several applications, eparker1.

Each of these application has their own way of integration. Others might perform the way you wanted and others might not. 

Since QuickBooks is the receiving end, you might want to reach out to the third-party app where inventories are initiated. They can surely take note of your feature requests and feedback. 

Right now, you can follow the steps provided by IntuitTony above as a workaround. 

You're always welcome to drop by again if you have additional concerns. 
 

We asked for this integration last July when we moved all of our sales from QuickBooks POS to Square and then moved to QuickBooks Online.  There are definitely some areas for improvement on QuickBooks side.  Being able to fully pass inventory data back and forth daily, or even on a push basis,  would be wonderful.  The other thing I have not been able to find where to fix is the Uncategorized Expense integrating to QuickBooks.  We have a Square Capital Loan and the deducts from each card transaction land in Uncategorized Expense.  I have to manually move it to the correct payable account.

Is it possible to keep track of the inventory in Square and not in Quickbooks?  As things are sold through Square, Square inventory is updated and the payment goes to the Sales of Product Income account in Quickbooks.  In this scenario, how would I enter the expense of buying product in Quickbooks?  Would I enter the cost of the goods to a category rather than to individual inventory items?  If so, which category?

Thank you

Hi James

Tried to follow the thread and not clear on this. Once the Square csv inventory list is imported into QBO, does Square operate off the Inventory from QBO ie QBO holds the maintenance inventory list and when Square deduct quantities as they are sold, add quantities as they are purchased? Tks Dan (new to Square & QBO)

@Hom 

You need to keep importing your inventory data to QBO by manually or sync them with a connector.