LOOKING FOR PARTNERS 🤝

We're currently looking for partners and distributors in different regions. If you're interested, please feel free to contact us.

Square Inventory Quantities syncs with Xero Inventory Quantities

Sync Square and Xero Inventory

Learn about SyncPenguin's Square and Xero inventory level sync


Free 14-day trial with full support, no credit card required

Many retailers sell through Square at the counter but keep their books and tracked inventory in Xero. The two systems don't share stock levels, so every sale, return, and delivery has to be entered twice or reconciled at month-end. Xero's quantities on hand and inventory values drift away from what is actually on the shelf. Your accountant works from inaccurate stock figures, and restocks recorded in Xero never reach your Square register.

How SyncPenguin helps

SyncPenguin connects your Square location with your Xero organization and keeps their stock quantities in sync, matched by SKU (the Xero Item Code). Every Square sale reduces stock in Xero. Stock you receive and record in Xero can flow back to Square. Changes are applied as adjustments rather than overwrites and are recorded in Xero as proper transactions. You can post them to an inventory adjustment account, so your accounting, your stock counts, and your point of sale always agree. You choose one-way or two-way syncing, which SKUs are included, and whether to merge existing quantities when you start.

Best suited for: Retail shop owners using Square POS and Xero. Bookkeepers and accountants managing Xero for retail clients. Multi-location retailers and cafés selling stocked goods. Multichannel sellers combining in-store and online sales.

Real-world use cases

  • Push every Square POS sale to Xero in a one-way sync, so quantities on hand and inventory values in your books always match what was actually sold.
  • Run a two-way sync where in-store sales in Square reduce stock in Xero, and deliveries recorded in Xero automatically increase stock at your Square register.
  • Combine several Square locations into one Xero organization in a many-to-one sync, so your accounts reflect sales across all of your shops.
  • Use Xero as your central inventory record and keep stock in sync with both your Square retail shop and your Shopify online store.
  • Share one pool of stock between your Square shop, your WooCommerce website, and Xero, so a sale on any channel updates stock everywhere else.
  • Sync only a selected list of SKUs between Square and Xero, such as resale goods you track as inventory, while leaving made-to-order or service items out.
  • Sell at markets and pop-ups with Zettle, run your main shop on Square, and keep stock for both channels reflected in Xero.
  • Keep your Square shop, your Squarespace online store, and Xero aligned, so counter sales, web orders, and restocks are all counted once.
  • Connect your Square store and your BigCommerce shop with Xero to keep stock counts and inventory values accurate as your catalog grows.

Key features

Instant Sale Tracking

Square notifies SyncPenguin as soon as stock changes, so in-store sales are picked up within moments and reflected in Xero.

Accounting-Friendly

Stock changes are recorded in Xero as proper transactions, with an optional inventory adjustment account to keep your books balanced.

Smart Adjustments

Sales and restocks are synced as adjustments to current stock, so changes made in Square and Xero at the same time never overwrite each other.

SKU Matching

Square items are automatically matched to Xero items by SKU and Item Code, so no manual product mapping is needed.

Selective Sync

Sync your whole tracked catalog or limit syncing to a chosen list of SKUs and leave the rest untouched.

Affordable & Scalable

With SyncPenguin you only pay for changes to your inventory quantities, regardless of how many products you have now or will have in the future.

Things to note

  • Products are matched by SKU, so each Square item variation needs a SKU that matches a unique Item Code in Xero.
  • Only stock quantities are synced, in whole units. Products must already exist in both Square and Xero, and names, prices, and images are not changed.
  • Inventory tracking must be enabled for the items in both Square and Xero. Xero items also need a purchase price set, because it is used to value the stock adjustments.
  • Xero records tracked inventory through transactions, so stock increases appear as bills and decreases as supplier credit notes under an 'Inventory Adjustments (SyncPenguin)' contact. Select an inventory adjustment account in the settings to keep your books balanced.
  • Square changes are picked up within moments, while Xero changes are detected during regular sync checks. Very large catalogs may take a little longer because SyncPenguin respects Xero's API limits.
  • Each connection covers one Square location and one Xero organization. To sync more locations or organizations, add a connection for each one.

How to configure the sync?


This guide explains in detail how to create, configure, and start the sync.

If you'd like to start syncing right away, feel free to create an account and set up the sync on your own. Come back to this guide if anything is unclear. You can also contact us with any questions, requests, or feedback.

INVENTORY LEVELS ONLY

Please note that this sync connection doesn't include any other product data like images, descriptions, or prices. We simply match existing products and variants by SKUs between the two synced stores and keep the quantity in sync. This means that products that you want synced must have matching SKUs, and the SKUs must be unique within a store.

Step 1. Create a SyncPenguin account

The first step is to create a SyncPenguin account. We offer a free 14-day trial (no credit card required), so you can make sure everything works well before you commit. Follow the link below to create an account.

14-day free trial • no credit card required • quick setup

Step 2. Create the sync

Next, create a sync in the Synchronizations section of the dashboard by clicking the + New sync button. You'll see a wizard page where you need to do the following:

  • Choose Square Inventory Quantities for the first app.
  • Then choose Xero Inventory Quantities for the second app.
  • Then select the sync direction.
  • Then click the Create button.

Step 3. Provide access to Square and Xero

Now that your sync is created, the next important step is to grant SyncPenguin access to your store inventory data. You'll see an Account section for each app involved in the sync. Below we explain how to connect and configure each account.

How to connect Square?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Square Inventory Quantities account connection section will look like this:

Account for Square Inventory Quantities (Example)
Square Inventory Quantities

How to connect Xero?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Xero Inventory Quantities account connection section will look like this:

Account for Xero Inventory Quantities (Example)
Xero Inventory Quantities

Please make sure both apps are properly connected before starting the sync.

DATA SECURITY

If you're concerned about the security of your data, please check out our Security Practices page.

Step 4. Sync settings

In the Sync settings section, you can adjust some of the default settings of your sync:

  • The name of your sync.
  • Sync direction (two-way or one-way).
  • Sync interval (by default, the sync runs every 10 minutes).

Please note that this connection uses webhooks, so syncing will be near real-time in most cases. The sync interval is used as a fallback in case a webhook is not fired.

Sync settings

Step 5. Start the sync

The last step is to start the sync. To do that, click the Start syncing button.

You'll then be offered the following options:

  1. Copy quantities Square → Xero: take all Square SKUs and assign the same levels to Xero.
  2. Copy quantities Xero → Square: similar to the previous option but in the opposite direction.

We recommend running the initial sync in either direction to ensure the stock levels are initially the same for all matching SKUs.

Start sync
We'll be checking every 10 minutes for changes in your data.
What should we do initially with already existing inventory?

Once you've made your choice, click Start syncing. If you choose an initial copy, it'll be queued immediately. Once it's done, we'll check for inventory or product changes at the sync interval you've set, as well as react to webhooks, and sync them accordingly. Each sync run is shown in the Sync history at the bottom of the sync page.

Learn more

Frequently Asked Questions

Can I sync Square inventory with Xero?

How are Square sales recorded in Xero?

How does SyncPenguin match Square items to Xero items?

How quickly are stock changes synced between Square and Xero?

Will SyncPenguin overwrite my stock levels in Square or Xero?

Can I sync multiple Square locations with one Xero organization?

Does SyncPenguin create products or change prices in Xero or Square?