Synctools logo
  • X

  • Integrations Integrations
    • Shopify Shopify Shopify
      • Shopify and QuickBooksShopify and QuickBooks
      • Shopify and XEROShopify and XERO
      • Shopify and SageShopify and Sage
      • Shopify and NetsuiteShopify and NetSuite
      • Shopify and ZohoBooksShopify and ZohoBooks
      • Shopify and Business Central Shopify and Business Central
    • WooCommerceWooCommerce WooCommerce
      • WooCommerce and QuickBooks WooCommerce and QuickBooks
      • WooCommerce and XEROWooCommerce and XERO
      • WooCommerce and SageWooCommerce and Sage
      • WooCommerce and Netsuite WooCommerce and NetSuite
      • WooCommerce and Business CentralWooCommerce and Business Central
    • LinnworksLinnworksLinnworks
      • Linnworks and QuickBooksLinnworks and QuickBooks
      • Linnworks and XEROLinnworks and XERO
      • Linnworks and ZohoBooksLinnworks and ZohoBooks
  • For Accountants
  • Pricing
  • Resources Down-Arrow
    • Help DocumetationHelp Documentation
    • BlogBlog
    • Demo Videos Demo Videos
  • Demo
  • Login
  • Free Trial

Reach out to us for bespoke requirements

Select your accounting software
Choose an eCommerce platform
Your Name*
Email Address*
Contact number *
Website Name *
Your requirements*
What benefits you get
  • No setup fees
  • 14 days free trial
  • Free onboarding
  • Email & live chat support (skype)
Choose an eCommerce platform
Your name*
Email address*
Contact number *
Website name *
Your requirements*
What benefits you get
  • No setup fees
  • 14 days free trial
  • Free onboarding
  • Email & call support
Choose an eCommerce platform
Your name*
Email address*
Contact number *
Website name *
Your requirements*
What benefits you get
  • No setup fees
  • 14 days free trial
  • Free onboarding
  • Email & call support
Start simply with one channel

Adding more is easy within your trial period.

Shopify Shopify Linnworks Linnworks
WooCommerce WooCommerce
Sign in starting channel for connection
Shopify Shopify Linnworks Linnworks
WooCommerce WooCommerce

Shopify QuickBooks Integration

11
  • Shopify + Quickbooks Online Advanced Accounting Scenarios ( Return, Refund, Return Fees, tax )
  • Shopify + Quickbooks Online setup tax threshold limits
  • How to Reconcile shopify payouts with Quickbooks Online
  • How SyncTools Converts Foreign Currency to Your Home Currency for Accurate Reconciliation
  • Shopify + Quickbooks Online Transaction Categorization using Auto Mapping
  • Shopify + Quickbooks Online Deferred Revenue setup
  • Synctools: Shopify Cost of Goods Sold (COGS) Integration with QuickBooks
  • Shopify + Quickbooks Online Grouping by Sales Channel, Gateway, Country..
  • How to Setup Shopify + QuickBooks Integration
  • Shopify + Quickbooks Online Configuration Guide for Summarized Journal
  • The Complete User Guide to Integrating Shopify with QuickBooks

Shopify Xero Integration

9
  • Shopify + Xero Advanced Accounting Scenarios ( Tax, Return, Refund, Return Fees )
  • Shopify + Xero setup tax threshold limits
  • How to Reconcile shopify payouts with Xero
  • How SyncTools Converts Foreign Currency to Your Home Currency for Accurate Reconciliation
  • Shopify + Xero Transaction Categorization using Auto Mapping
  • Shopify + Xero Grouping by Sales Channel, Gateway, Country
  • Shopify + Xero Online COGS setup
  • SyncTools Shopify to Xero Integration Guide: Configuring Summarized Sync
  • SyncTools Shopify to Xero Integration Setup Guide

Shopify Sage Integration

1
  • How do I Get Started with SyncTools for Shopify to Sage?

Shopify NetSuite Integration

1
  • How do I Get Started with SyncTools for Shopify to NetSuite?

Shopify Business Central Integration

1
  • How do I Get Started with SyncTools for Shopify to Business Central?
  • Home
  • docs
  • Shopify Integration
  • Shopify Xero Integration
  • SyncTools Shopify to Xero Integration Guide: Configuring Summarized Sync
View Categories

SyncTools Shopify to Xero Integration Guide: Configuring Summarized Sync

This guide will walk you through the configuration process for syncing summarized entries from your Shopify store to Xero using SyncTools. By the end of this guide, you’ll be able to easily set up summarized sync for your store’s financial data, ensuring automated accounting and easy reconciliation.

Step 1: Sign In to Your SyncTools Account #

  • Visit the SyncTools login page and enter your registered email and password to sign in.
  • If you’re a new user, you can sign up for an account by clicking on Sign up today.

 

Step 2: Navigate to the SyncTools Dashboard  #

 

  • Once logged in, you’ll be directed to your SyncTools Dashboard where you can view your Shopify store data and Xero account details.
  • From here, you’ll see key metrics such as monthly orders and sales totals.

Step 3: Go To Settings #

  • In the bottom left corner, click on your profile (e.g., John S) to open the user menu.
  • From the dropdown, select Settings.

Step 4: Choose Synchronization Options #

Select Summarized Entries #

  • In the Configuration section, you will be prompted to choose between Summarized Entries and Individual Transaction Entries.
  • Select Summarized Entries for the streamlined syncing of Shopify data on a daily, weekly, or monthly basis.

#

Choose Invoice Creation Frequency #

  • Under the Choose frequency of invoice creation section, select how often you want to create summarized invoices. Lets say, choose daily if you want your summarised entries to sync on a daily basis.

Pick the start date for sync #

  • Choose the date from which you want to start importing Shopify records. This will define when SyncTools begins syncing your transactions to Xero.

Choose Invoice Status how you want it in Xero #

Select the Invoice Status that suits your accounting workflow:

  • Draft: Draft invoices will be created in Xero.
  • Submitted for Approval: The invoice will be submitted for approval in Xero.
  • Approved: Automatically approve the invoice in Xero.

Select whether you want Tax inclusive or Exclusive invoices  #

  • Determine whether the invoices should be Tax Inclusive or Exclusive.

Step 5: Select Your Operating and Registered Countries #

  • Choose the operating country (where your business operates) and any additional countries where your business is registered.

Step 6: Set Up Grouping Preferences #

Default and Advanced Grouping #

  • Choose the grouping options for transactions. SyncTools offers both Default Grouping (by country or gateway) and Advanced Grouping (by sales channel, product category, etc.).
    • Default Grouping: Group by country or gateway.
    • Advanced Grouping: Group by channel (online, imported, manual), product categories, etc.

Tip: Use Advanced Grouping for more granular financial reporting.

🔔 Note: For a detailed guide on how the Grouping Feature works, check out our documentation here.

Step 7: Map Your Shopify Data to Xero Accounts #

  • In the Mapping section, you need to map your Shopify transactions (sales, refunds, shipping income, etc.) to the corresponding Xero accounts.
    • For example, map Shopify Sales to the appropriate Xero Revenue account.
    • You can use the Bulk Create & Map button to map multiple transactions at once.

Step 8:  Review and Confirm Mappings #

  • Once you’ve completed the mappings, review and confirm your choices.
  • Ensure that all Shopify transactions are mapped correctly to your Xero accounts.

Tip: Double-check for any unmapped transactions to avoid errors in your financial records. Additionally, ensure that this step is repeated for each country enabled in the previous step to guarantee a smooth sync.

Step 9:  Enable and Configure Cost of Goods Sold (COGS) #

Enable COGS Sync #

To automatically track the cost of products sold at each payout period, enable COGS Sync. This feature will post itemized costs as invoice transactions into your accounting system.

  • This ensures accurate tracking of inventory and profitability for each sale.

Click the Enable Cost of Goods Sold button to activate the COGS sync.

Choose Default Accounts for COGS #

Select the Cost of Goods Sold account and the Inventory account that SyncTools will use to track and sync product costs to Xero.

  • The Cost of Goods Sold account records the direct costs associated with products sold.
  • The Inventory account keeps track of the value of goods available for sale.

Set Synchronization Frequency #


Choose the frequency for COGS synchronization. You can select either Daily (automatic) or Monthly (manual) synchronization. This determines how frequently your product costs will be updated in Xero.

  • Daily synchronization: Keeps your financial data up-to-date with real-time updates.
  • Monthly synchronization: Allows you to consolidate updates into a single period for easier financial review.

 

Step10 : Review the Shopify Payouts and sync in xero #

  • You’ve now successfully set up your summarized sync between Shopify and Xero using SyncTools. This integration ensures that your Shopify payouts and cost of goods sold are synced seamlessly, saving you time and reducing the risk of manual errors in your accounting. 
  • Track the monthly breakdown of Shopify payouts. This will give you an overview of your sales, shipping, taxes, and payments made. Ensure that all transactions are being posted correctly to Xero. If not, you can select and post to xero.

 

Share This Article :
  • Facebook
  • X
  • LinkedIn
Updated on July 8, 2025
Shopify + Xero Online COGS setup
Table of Contents
  • Step 1: Sign In to Your SyncTools Account
  • Step 2: Navigate to the SyncTools Dashboard 
  • Step 3: Go To Settings
  • Step 4: Choose Synchronization Options
    • Select Summarized Entries
    • Choose Invoice Creation Frequency
    • Pick the start date for sync
    • Choose Invoice Status how you want it in Xero
    • Select whether you want Tax inclusive or Exclusive invoices 
  • Step 5: Select Your Operating and Registered Countries
  • Step 6: Set Up Grouping Preferences
    • Default and Advanced Grouping
  • Step 7: Map Your Shopify Data to Xero Accounts
  • Step 8:  Review and Confirm Mappings
  • Step 9:  Enable and Configure Cost of Goods Sold (COGS)
    • Enable COGS Sync
    • Choose Default Accounts for COGS
    • Set Synchronization Frequency
  • Step10 : Review the Shopify Payouts and sync in xero

QuickBooks Integrations

  • Shopify and QuickBooks
  • WooCommerce and QuickBooks
  • Amazon and QuicBooks
  • eBay and QuickBooks
  • BigCommerce and QuickBooks
  • Walmart and QuickBooks
  • Magento and QuickBooks
  • Linnworks and QuickBooks

XERO Integrations

  • Shopify and Xero
  • WooCommerce and Xero
  • Amazon and Xero
  • eBay and Xero
  • BigCommerce and Xero
  • Walmart and Xero
  • Magento and Xero
  • Linnworks and Xero

Dynamic 365 Business Central Integrations

  • Shopify and Business Central
  • WooCommerce and Business Central
  • Amazon and Business Central
  • eBay and Business Central
  • BigCommerce and Business Central
  • Walmart and Business Central
  • Magento and Business Central

NetSuite Integrations

  • Shopify and NetSuite
  • WooCommerce and Netsuite
  • Amazon and NetSuite
  • eBay and NetSuite
  • BigCommerce and NetSuite
  • Walmart and NetSuite
  • Magento and NetSuite

Sage Integrations

  • Shopify and Sage
  • WooCommerce and Sage
  • Amazon and Sage
  • eBay and Sage
  • BigCommerce and Sage
  • Walmart and Sage
  • Magento and Sage

SyncTools

  • About Us
  • Customer Review
  • Pricing
  • Contact us
  • Terms & Conditions
  • Privacy policy
  • Sitemap

Industries

  • SyncTools for Accountants
  • SyncTools For eCommerce
  • SyncTools for SaaS

Resources

  • Knowledge base
  • Use cases
  • Demo videos
  • Blog
+1 323 672 3738 +44 73803 28797
  • linkedin
  • Youtube
  • Facebook
  • Instagram
  • Twitter

Copyright © by SyncTools.io All rights reserved