Why WooCommerce payouts often don\u2019t match the bank feed in Xero<\/strong><\/h2>\n\n\n\nWooCommerce itself doesn\u2019t send payouts to your bank, but your payment processors (Stripe, PayPal, Authorize.Net, etc.) do. Each of these adds its own complexity:<\/p>\n\n\n\n
\n- Fees:<\/strong> Payment gateways deduct fees before sending money to your bank.
<\/li>\n\n\n\n- Refunds and chargebacks:<\/strong> These often hit your account separately, not tied to the original sale.
<\/li>\n\n\n\n- Shipping & discounts:<\/strong> Unless mapped correctly, these won\u2019t reflect in the right places in Xero.
<\/li>\n\n\n\n- Taxes (including marketplace facilitator tax):<\/strong> Sales tax may be collected and remitted by the processor, meaning you never see the cash.
<\/li>\n\n\n\n- Timing differences:<\/strong> Today\u2019s sale may only reach your bank account a few days later.
<\/li>\n<\/ul>\n\n\n\nAll this explains why what you see in WooCommerce reports may not match the deposit that hits your Xero bank feed.<\/p>\n\n\n\n
Reconciling WooCommerce payments in Xero via Synder<\/strong><\/h2>\n\n\n\nStep 1: Create a Synder account and connect integrations<\/strong><\/h3>\n\n\n\nSign up for a Synder account and connect WooCommerce and Xero. This establishes the link between your store and your accounting system. At this stage, you\u2019re only connecting the platforms \u2013 no data is moving yet.<\/p>\n\n\n
\n![\"Connecting](\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/connecting-woocommerce-and-xero-to-synder.png\")
<\/figure>\n<\/div>\n\n\n<\/p>\n\n\n\n
Note<\/em>:<\/strong> Before syncing, set up your Xero chart of accounts with clearing accounts for WooCommerce payouts and other WooCommerce transactions, like sales, refunds, and fees. Use one clearing account per payment processor (e.g., Stripe, PayPal). In Synder, map each processor to its clearing account and link your real bank account for deposits. This way, payouts align with your Xero bank feed.<\/p>\n\n\n\nDuring the connection process, you\u2019ll also be prompted to select a sync mode. Choose Per Transaction<\/strong> if you need detailed records and quantity-on-hand tracking. For cleaner books, tracking of inventory assents and COGS totals, Summary Sync<\/strong> is the simpler option.<\/p>\n\n\n\n![\"Selecting](\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/selecting-sync-mode-in-sydner.png\")
<\/figure>\n<\/div>\n\n\nStep 2: Configure mapping<\/strong><\/h3>\n\n\n\nWith the integrations connected, go into Synder\u2019s settings to choose how data should be posted in Xero. Map sales, shipping, discounts, taxes, fees, and refunds to the right Xero accounts so everything lands in the correct place automatically.<\/p>\n\n\n\n
Step 3: Enable sync and import transactions<\/strong><\/h3>\n\n\n\nOnce mapping is complete, turn on the sync. Synder will start importing WooCommerce orders and related data \u2014 including line items, shipping, discounts, and taxes. In Per Transaction<\/strong> mode, all line items are synced individually, but you can also use the Group by SKU<\/strong> option to track totals for each product. <\/p>\n\n\n\nAt the same time, connected payment processors like Stripe or PayPal will feed in fees, refunds, and payout information. From this point on, Synder continuously records new transactions into your Xero clearing accounts using the rules you set up in Step 2.<\/p>\n\n\n
\n![\"Syncing](\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/syncing-woocommerce-transaction-data-1024x548.png\")
<\/figure>\n<\/div>\n\n\nStep 4: Reconcile the clearing account against payouts<\/strong><\/h3>\n\n\n\nWhen your payment processor issues a payout, Synder creates a transfer in Xero that moves the payout amount from the clearing account to your checking account. This reduces the clearing account balance to zero, or to the same amount as the ending balance in your payment platform, ensuring the account can be fully reconciled.<\/p>\n\n\n\n
When the deposit later shows in your Xero bank feed, you only need to match that transfer, not reconcile dozens of transactions one by one. This is the essence of Synder\u2019s reconciliation flow and is what ensures your books align in just a click.<\/p>\n\n\n
\n![\"Reconciliation](\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/reconciliation-in-xero-1024x456.png\")
<\/figure>\n<\/div>\n\n\nStep 5: Handle refunds, returns, and adjustments<\/strong><\/h3>\n\n\n\nRefunds and returns flow through the clearing account just like sales but as negative transactions tied back to the original order. This keeps your revenue, tax balances, and cost of goods sold accurate without extra steps. <\/p>\n\n\n\n
Importing historical WooCommerce transactions<\/strong><\/h2>\n\n\n\nKeeping past periods accurate is just as important as staying current. Synder allows you to bring in historical WooCommerce data so your books reflect the full picture, not just new sales. With historical sync enabled:<\/p>\n\n\n\n
\n- Older WooCommerce sales, refunds, fees, and payouts are imported and posted into the same clearing account workflow you use for current transactions.
<\/li>\n\n\n\n - Transfers tied to those historical payouts are created automatically, allowing you to match them against deposits that already exist in your Xero bank feed.
<\/li>\n\n\n\n - Books remain accurate not only for the present but also for past reporting periods, giving you reliable P&L and balance sheet numbers across the board.
<\/li>\n\n\n\n - You can import as much WooCommerce history as the platform allows, with no limits from Synder, ensuring no gaps when you start automating.<\/li>\n<\/ul>\n\n\n\n
Note:<\/em><\/strong> Importing history is free on Synder\u2019s Premium plan, includes 3 months for free on the Pro plan, and is a paid feature on Basic and Essential plans.<\/p>\n\n\n\nInventory & COGS tracking <\/strong><\/h2>\n\n\n\nTracking inventory and COGS properly is a major reason to choose itemized sync with Synder. Without it, many merchants end up doing month-end adjustments or guessing. With correct setup:<\/p>\n\n\n\n
\n- Each product sale triggers a reduction in stock in Xero in the Per Transaction Sync mode.
<\/li>\n\n\n\n - The cost associated with that sale is recognized immediately in COGS.
<\/li>\n\n\n\n - Returns and refunds reverse both the sale and the cost entry, preserving gross margin accuracy.
<\/li>\n\n\n\n - If you use variants or bundles, Synder can handle those complexities (depending on settings).
<\/li>\n<\/ul>\n\n\n\nFee mapping & marketplace tax setup<\/strong><\/h2>\n\n\n\nBecause payment gateways deduct their fees before depositing, your bank deposit is always net.<\/em> To keep things aligned:<\/p>\n\n\n\n\n- Synder records the gross sale<\/strong> in the clearing account with all components (tax, shipping, discount).
<\/li>\n\n\n\n- It also records the fee separately as an expense (or to a merchant fee account). In the Per Transaction<\/strong> mode, the fee is reflected as a bill and payment<\/strong>, while in the Summary<\/strong> mode, it appears as a payment and credit note<\/strong>.
<\/li>\n\n\n\n- Then it posts the net transfer<\/strong> to the checking account in Xero.
<\/li>\n\n\n\n- For marketplace facilitator tax<\/strong> (e.g. marketplaces remitting tax on your behalf), you can map those taxes to a liability account so you don\u2019t overstate your remittable sales.
<\/li>\n<\/ul>\n\n\n\nThis structure ensures your deposit matches the bank feed exactly<\/em>, while still capturing full detail.<\/p>\n\n\n\nMatching WooCommerce payouts to bank deposits<\/strong><\/h2>\n\n\n\nBecause every payout is recorded as a transfer from the clearing account, when the deposit appears in your Xero bank feed, you don\u2019t need to reconcile line by line. You just match or confirm the deposit with that transfer record. This significantly reduces manual reconciliation work and ensures your bank balance, clearing balance, and sales records stay in harmony.<\/p>\n\n\n\n
FAQ<\/strong><\/h2>\n\n\n\nWhy don\u2019t my WooCommerce payouts match what I see in Xero?<\/strong><\/h3>\n\n\n\nBecause the deposit is net<\/strong> of fees, refunds, taxes, and possibly withheld marketplace tax, while WooCommerce reports often show gross<\/strong> amounts. Without an integration to break those parts out, you\u2019ll always see a gap.<\/p>\n\n\n\nHow do I map taxes, shipping, and discounts from WooCommerce to the correct Xero accounts?<\/strong><\/h3>\n\n\n\nIn Summary<\/strong> mode, you map each component, such as tax, shipping, and discounts, to specific Xero accounts (e.g., revenue, liability, contra-revenue). In Per Transaction<\/strong> mode, these settings are defined in Synder, but some categories (like fees) can be assigned manually, while income accounts are determined by the product\u2019s income account in Xero. This ensures recording is granular and automated.<\/p>\n\n\n\nShould I use daily summary or itemized posting?<\/strong><\/h3>\n\n\n\nIf you need accurate inventory tracking, COGS, or customer details, including closing open invoices with payments, choose the itemized Per Transaction Sync<\/strong>. For smaller stores not tracking stock, the Summary <\/strong>mode may be sufficient. But the itemized sync gives you better traceability.<\/p>\n\n\n\nHow are fees recorded so deposits match my Xero bank feed?<\/strong><\/h3>\n\n\n\nSynder records the full (gross) sale, posts the fee as a separate expense, and then applies the net transfer. In the Per Transaction<\/strong> mode, the fee is reflected as a bill and payment<\/strong>, while in Summary<\/strong> mode, it\u2019s recorded as a payment and credit note<\/strong>. The deposit in your bank matches that net transfer. So instead of reconciling dozens of lines, you match one transfer.<\/p>\n\n\n\nCan Xero update inventory and COGS automatically when WooCommerce items sell or are returned?<\/strong><\/h3>\n\n\n\nYes, when Per Transaction Sync is enabled, every sale adjusts inventory and recognizes COGS. Returns reverse the process automatically.<\/p>\n","protected":false},"excerpt":{"rendered":"If you\u2019ve ever tried to reconcile WooCommerce payments in Xero manually, you already know how messy it can…\n","protected":false},"author":2254,"featured_media":30502,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","csco_post_video_location":[],"csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"footnotes":"","_ppma_block_editor_authors":""},"categories":[43,45,326],"tags":[255],"ppma_author":[391],"class_list":["post-30496","post","type-post","status-publish","format-standard","has-post-thumbnail","category-accounting","category-business-management","category-how-to-do-your-accounting","tag-business-owner","cs-entry","cs-video-wrap"],"yoast_head":"\n
Reconcile WooCommerce Payments with Xero Easily<\/title>\n<meta name=\"description\" content=\"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reconcile WooCommerce Payments with Xero Easily\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SynderHQ\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-09T09:33:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-10T09:39:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png\" \/>\n\t<meta property=\"og:image:width\" content=\"4416\" \/>\n\t<meta property=\"og:image:height\" content=\"1386\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Helga Vasilevsky\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Helga Vasilevsky\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reconcile WooCommerce Payments with Xero Easily","description":"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","og_locale":"en_US","og_type":"article","og_title":"Reconcile WooCommerce Payments with Xero Easily","og_description":"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.","og_url":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","og_site_name":"Synder blog","article_publisher":"https:\/\/www.facebook.com\/SynderHQ\/","article_published_time":"2025-10-09T09:33:07+00:00","article_modified_time":"2025-10-10T09:39:10+00:00","og_image":[{"width":4416,"height":1386,"url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","type":"image\/png"}],"author":"Helga Vasilevsky","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Helga Vasilevsky","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#article","isPartOf":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/"},"author":{"name":"Helga Vasilevsky","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/92b8d5f9f740c4e8f088f96f3194f67d"},"headline":"How to reconcile WooCommerce payments in Xero","datePublished":"2025-10-09T09:33:07+00:00","dateModified":"2025-10-10T09:39:10+00:00","mainEntityOfPage":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/"},"wordCount":1403,"commentCount":0,"publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"image":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","keywords":["Business Owner"],"articleSection":["Accounting","Business","How to Do Your Accounting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","url":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","name":"Reconcile WooCommerce Payments with Xero Easily","isPartOf":{"@id":"https:\/\/synder.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","datePublished":"2025-10-09T09:33:07+00:00","dateModified":"2025-10-10T09:39:10+00:00","description":"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.","breadcrumb":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","width":4416,"height":1386,"caption":"How to reconcile WooCommerce payments in Xero"},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/synder.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Accounting","item":"https:\/\/synder.com\/blog\/category\/accounting\/"},{"@type":"ListItem","position":3,"name":"How to reconcile WooCommerce payments in Xero"}]},{"@type":"WebSite","@id":"https:\/\/synder.com\/blog\/#website","url":"https:\/\/synder.com\/blog\/","name":"Synder blog","description":"Business Hacks & Accounting Automation Use Cases","publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synder.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/synder.com\/blog\/#organization","name":"Synder","url":"https:\/\/synder.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","width":303,"height":332,"caption":"Synder"},"image":{"@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SynderHQ\/"]},{"@type":"Person","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/92b8d5f9f740c4e8f088f96f3194f67d","name":"Helga Vasilevsky","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg4617e45e979af54d7b8f72c03ef8f67b","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","caption":"Helga Vasilevsky"},"description":"Helga is a FinTech writer at Synder, where she covers topics at the intersection of accounting, ecommerce and SaaS. After going through Synder\u2019s internal accounting training, she set out to explain financial processes, like reconciliation, tax automation, and multi-platform syncing, in a way that resonates with both accountants and business owners. Her articles are grounded in real user questions and crafted in collaboration with Synder\u2019s support and product teams.","sameAs":["https:\/\/www.linkedin.com\/in\/olga-vasilevaskaya-65b455102\/"],"url":"https:\/\/synder.com\/blog\/author\/olgavasilevskaya\/"}]}},"authors":[{"term_id":391,"user_id":2254,"is_guest":0,"slug":"olgavasilevskaya","display_name":"Helga Vasilevsky","avatar_url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","author_category":"","first_name":"Helga","last_name":"Vasilevsky","user_url":"","job_title":"","description":"Helga is a FinTech writer at Synder, where she covers topics at the intersection of accounting, ecommerce and SaaS. After going through Synder\u2019s internal accounting training, she set out to explain financial processes, like reconciliation, tax automation, and multi-platform syncing, in a way that resonates with both accountants and business owners. Her articles are grounded in real user questions and crafted in collaboration with Synder\u2019s support and product teams."}],"_links":{"self":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/30496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/users\/2254"}],"replies":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/comments?post=30496"}],"version-history":[{"count":2,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/30496\/revisions"}],"predecessor-version":[{"id":30504,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/30496\/revisions\/30504"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media\/30502"}],"wp:attachment":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media?parent=30496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/categories?post=30496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/tags?post=30496"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=30496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ul>\n\n\n\n
All this explains why what you see in WooCommerce reports may not match the deposit that hits your Xero bank feed.<\/p>\n\n\n\n
Reconciling WooCommerce payments in Xero via Synder<\/strong><\/h2>\n\n\n\nStep 1: Create a Synder account and connect integrations<\/strong><\/h3>\n\n\n\nSign up for a Synder account and connect WooCommerce and Xero. This establishes the link between your store and your accounting system. At this stage, you\u2019re only connecting the platforms \u2013 no data is moving yet.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n<\/p>\n\n\n\n
Note<\/em>:<\/strong> Before syncing, set up your Xero chart of accounts with clearing accounts for WooCommerce payouts and other WooCommerce transactions, like sales, refunds, and fees. Use one clearing account per payment processor (e.g., Stripe, PayPal). In Synder, map each processor to its clearing account and link your real bank account for deposits. This way, payouts align with your Xero bank feed.<\/p>\n\n\n\nDuring the connection process, you\u2019ll also be prompted to select a sync mode. Choose Per Transaction<\/strong> if you need detailed records and quantity-on-hand tracking. For cleaner books, tracking of inventory assents and COGS totals, Summary Sync<\/strong> is the simpler option.<\/p>\n\n\n\n<\/figure>\n<\/div>\n\n\nStep 2: Configure mapping<\/strong><\/h3>\n\n\n\nWith the integrations connected, go into Synder\u2019s settings to choose how data should be posted in Xero. Map sales, shipping, discounts, taxes, fees, and refunds to the right Xero accounts so everything lands in the correct place automatically.<\/p>\n\n\n\n
Step 3: Enable sync and import transactions<\/strong><\/h3>\n\n\n\nOnce mapping is complete, turn on the sync. Synder will start importing WooCommerce orders and related data \u2014 including line items, shipping, discounts, and taxes. In Per Transaction<\/strong> mode, all line items are synced individually, but you can also use the Group by SKU<\/strong> option to track totals for each product. <\/p>\n\n\n\nAt the same time, connected payment processors like Stripe or PayPal will feed in fees, refunds, and payout information. From this point on, Synder continuously records new transactions into your Xero clearing accounts using the rules you set up in Step 2.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\nStep 4: Reconcile the clearing account against payouts<\/strong><\/h3>\n\n\n\nWhen your payment processor issues a payout, Synder creates a transfer in Xero that moves the payout amount from the clearing account to your checking account. This reduces the clearing account balance to zero, or to the same amount as the ending balance in your payment platform, ensuring the account can be fully reconciled.<\/p>\n\n\n\n
When the deposit later shows in your Xero bank feed, you only need to match that transfer, not reconcile dozens of transactions one by one. This is the essence of Synder\u2019s reconciliation flow and is what ensures your books align in just a click.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\nStep 5: Handle refunds, returns, and adjustments<\/strong><\/h3>\n\n\n\nRefunds and returns flow through the clearing account just like sales but as negative transactions tied back to the original order. This keeps your revenue, tax balances, and cost of goods sold accurate without extra steps. <\/p>\n\n\n\n
Importing historical WooCommerce transactions<\/strong><\/h2>\n\n\n\nKeeping past periods accurate is just as important as staying current. Synder allows you to bring in historical WooCommerce data so your books reflect the full picture, not just new sales. With historical sync enabled:<\/p>\n\n\n\n
\n- Older WooCommerce sales, refunds, fees, and payouts are imported and posted into the same clearing account workflow you use for current transactions.
<\/li>\n\n\n\n - Transfers tied to those historical payouts are created automatically, allowing you to match them against deposits that already exist in your Xero bank feed.
<\/li>\n\n\n\n - Books remain accurate not only for the present but also for past reporting periods, giving you reliable P&L and balance sheet numbers across the board.
<\/li>\n\n\n\n - You can import as much WooCommerce history as the platform allows, with no limits from Synder, ensuring no gaps when you start automating.<\/li>\n<\/ul>\n\n\n\n
Note:<\/em><\/strong> Importing history is free on Synder\u2019s Premium plan, includes 3 months for free on the Pro plan, and is a paid feature on Basic and Essential plans.<\/p>\n\n\n\nInventory & COGS tracking <\/strong><\/h2>\n\n\n\nTracking inventory and COGS properly is a major reason to choose itemized sync with Synder. Without it, many merchants end up doing month-end adjustments or guessing. With correct setup:<\/p>\n\n\n\n
\n- Each product sale triggers a reduction in stock in Xero in the Per Transaction Sync mode.
<\/li>\n\n\n\n - The cost associated with that sale is recognized immediately in COGS.
<\/li>\n\n\n\n - Returns and refunds reverse both the sale and the cost entry, preserving gross margin accuracy.
<\/li>\n\n\n\n - If you use variants or bundles, Synder can handle those complexities (depending on settings).
<\/li>\n<\/ul>\n\n\n\nFee mapping & marketplace tax setup<\/strong><\/h2>\n\n\n\nBecause payment gateways deduct their fees before depositing, your bank deposit is always net.<\/em> To keep things aligned:<\/p>\n\n\n\n\n- Synder records the gross sale<\/strong> in the clearing account with all components (tax, shipping, discount).
<\/li>\n\n\n\n- It also records the fee separately as an expense (or to a merchant fee account). In the Per Transaction<\/strong> mode, the fee is reflected as a bill and payment<\/strong>, while in the Summary<\/strong> mode, it appears as a payment and credit note<\/strong>.
<\/li>\n\n\n\n- Then it posts the net transfer<\/strong> to the checking account in Xero.
<\/li>\n\n\n\n- For marketplace facilitator tax<\/strong> (e.g. marketplaces remitting tax on your behalf), you can map those taxes to a liability account so you don\u2019t overstate your remittable sales.
<\/li>\n<\/ul>\n\n\n\nThis structure ensures your deposit matches the bank feed exactly<\/em>, while still capturing full detail.<\/p>\n\n\n\nMatching WooCommerce payouts to bank deposits<\/strong><\/h2>\n\n\n\nBecause every payout is recorded as a transfer from the clearing account, when the deposit appears in your Xero bank feed, you don\u2019t need to reconcile line by line. You just match or confirm the deposit with that transfer record. This significantly reduces manual reconciliation work and ensures your bank balance, clearing balance, and sales records stay in harmony.<\/p>\n\n\n\n
FAQ<\/strong><\/h2>\n\n\n\nWhy don\u2019t my WooCommerce payouts match what I see in Xero?<\/strong><\/h3>\n\n\n\nBecause the deposit is net<\/strong> of fees, refunds, taxes, and possibly withheld marketplace tax, while WooCommerce reports often show gross<\/strong> amounts. Without an integration to break those parts out, you\u2019ll always see a gap.<\/p>\n\n\n\nHow do I map taxes, shipping, and discounts from WooCommerce to the correct Xero accounts?<\/strong><\/h3>\n\n\n\nIn Summary<\/strong> mode, you map each component, such as tax, shipping, and discounts, to specific Xero accounts (e.g., revenue, liability, contra-revenue). In Per Transaction<\/strong> mode, these settings are defined in Synder, but some categories (like fees) can be assigned manually, while income accounts are determined by the product\u2019s income account in Xero. This ensures recording is granular and automated.<\/p>\n\n\n\nShould I use daily summary or itemized posting?<\/strong><\/h3>\n\n\n\nIf you need accurate inventory tracking, COGS, or customer details, including closing open invoices with payments, choose the itemized Per Transaction Sync<\/strong>. For smaller stores not tracking stock, the Summary <\/strong>mode may be sufficient. But the itemized sync gives you better traceability.<\/p>\n\n\n\nHow are fees recorded so deposits match my Xero bank feed?<\/strong><\/h3>\n\n\n\nSynder records the full (gross) sale, posts the fee as a separate expense, and then applies the net transfer. In the Per Transaction<\/strong> mode, the fee is reflected as a bill and payment<\/strong>, while in Summary<\/strong> mode, it\u2019s recorded as a payment and credit note<\/strong>. The deposit in your bank matches that net transfer. So instead of reconciling dozens of lines, you match one transfer.<\/p>\n\n\n\nCan Xero update inventory and COGS automatically when WooCommerce items sell or are returned?<\/strong><\/h3>\n\n\n\nYes, when Per Transaction Sync is enabled, every sale adjusts inventory and recognizes COGS. Returns reverse the process automatically.<\/p>\n","protected":false},"excerpt":{"rendered":"If you\u2019ve ever tried to reconcile WooCommerce payments in Xero manually, you already know how messy it can…\n","protected":false},"author":2254,"featured_media":30502,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","csco_post_video_location":[],"csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"footnotes":"","_ppma_block_editor_authors":""},"categories":[43,45,326],"tags":[255],"ppma_author":[391],"class_list":["post-30496","post","type-post","status-publish","format-standard","has-post-thumbnail","category-accounting","category-business-management","category-how-to-do-your-accounting","tag-business-owner","cs-entry","cs-video-wrap"],"yoast_head":"\n
Reconcile WooCommerce Payments with Xero Easily<\/title>\n<meta name=\"description\" content=\"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reconcile WooCommerce Payments with Xero Easily\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SynderHQ\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-09T09:33:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-10T09:39:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png\" \/>\n\t<meta property=\"og:image:width\" content=\"4416\" \/>\n\t<meta property=\"og:image:height\" content=\"1386\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Helga Vasilevsky\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Helga Vasilevsky\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reconcile WooCommerce Payments with Xero Easily","description":"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","og_locale":"en_US","og_type":"article","og_title":"Reconcile WooCommerce Payments with Xero Easily","og_description":"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.","og_url":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","og_site_name":"Synder blog","article_publisher":"https:\/\/www.facebook.com\/SynderHQ\/","article_published_time":"2025-10-09T09:33:07+00:00","article_modified_time":"2025-10-10T09:39:10+00:00","og_image":[{"width":4416,"height":1386,"url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","type":"image\/png"}],"author":"Helga Vasilevsky","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Helga Vasilevsky","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#article","isPartOf":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/"},"author":{"name":"Helga Vasilevsky","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/92b8d5f9f740c4e8f088f96f3194f67d"},"headline":"How to reconcile WooCommerce payments in Xero","datePublished":"2025-10-09T09:33:07+00:00","dateModified":"2025-10-10T09:39:10+00:00","mainEntityOfPage":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/"},"wordCount":1403,"commentCount":0,"publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"image":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","keywords":["Business Owner"],"articleSection":["Accounting","Business","How to Do Your Accounting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","url":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/","name":"Reconcile WooCommerce Payments with Xero Easily","isPartOf":{"@id":"https:\/\/synder.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","datePublished":"2025-10-09T09:33:07+00:00","dateModified":"2025-10-10T09:39:10+00:00","description":"Learn how to connect WooCommerce with Xero, track sales, fees, refunds, inventory, and COGS, and ensure your payouts match the bank feed.","breadcrumb":{"@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#primaryimage","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/10\/banners-for-blog-2025-10-10T113037.663.png","width":4416,"height":1386,"caption":"How to reconcile WooCommerce payments in Xero"},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/blog\/reconcile-woocommerce-payments-with-xero-easily\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/synder.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Accounting","item":"https:\/\/synder.com\/blog\/category\/accounting\/"},{"@type":"ListItem","position":3,"name":"How to reconcile WooCommerce payments in Xero"}]},{"@type":"WebSite","@id":"https:\/\/synder.com\/blog\/#website","url":"https:\/\/synder.com\/blog\/","name":"Synder blog","description":"Business Hacks & Accounting Automation Use Cases","publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synder.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/synder.com\/blog\/#organization","name":"Synder","url":"https:\/\/synder.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","width":303,"height":332,"caption":"Synder"},"image":{"@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SynderHQ\/"]},{"@type":"Person","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/92b8d5f9f740c4e8f088f96f3194f67d","name":"Helga Vasilevsky","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg4617e45e979af54d7b8f72c03ef8f67b","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","caption":"Helga Vasilevsky"},"description":"Helga is a FinTech writer at Synder, where she covers topics at the intersection of accounting, ecommerce and SaaS. After going through Synder\u2019s internal accounting training, she set out to explain financial processes, like reconciliation, tax automation, and multi-platform syncing, in a way that resonates with both accountants and business owners. Her articles are grounded in real user questions and crafted in collaboration with Synder\u2019s support and product teams.","sameAs":["https:\/\/www.linkedin.com\/in\/olga-vasilevaskaya-65b455102\/"],"url":"https:\/\/synder.com\/blog\/author\/olgavasilevskaya\/"}]}},"authors":[{"term_id":391,"user_id":2254,"is_guest":0,"slug":"olgavasilevskaya","display_name":"Helga Vasilevsky","avatar_url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","author_category":"","first_name":"Helga","last_name":"Vasilevsky","user_url":"","job_title":"","description":"Helga is a FinTech writer at Synder, where she covers topics at the intersection of accounting, ecommerce and SaaS. After going through Synder\u2019s internal accounting training, she set out to explain financial processes, like reconciliation, tax automation, and multi-platform syncing, in a way that resonates with both accountants and business owners. Her articles are grounded in real user questions and crafted in collaboration with Synder\u2019s support and product teams."}],"_links":{"self":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/30496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/users\/2254"}],"replies":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/comments?post=30496"}],"version-history":[{"count":2,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/30496\/revisions"}],"predecessor-version":[{"id":30504,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/30496\/revisions\/30504"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media\/30502"}],"wp:attachment":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media?parent=30496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/categories?post=30496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/tags?post=30496"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=30496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Sign up for a Synder account and connect WooCommerce and Xero. This establishes the link between your store and your accounting system. At this stage, you\u2019re only connecting the platforms \u2013 no data is moving yet.<\/p>\n\n\n
<\/figure>\n<\/div>\n\n\n<\/p>\n\n\n\n
Note<\/em>:<\/strong> Before syncing, set up your Xero chart of accounts with clearing accounts for WooCommerce payouts and other WooCommerce transactions, like sales, refunds, and fees. Use one clearing account per payment processor (e.g., Stripe, PayPal). In Synder, map each processor to its clearing account and link your real bank account for deposits. This way, payouts align with your Xero bank feed.<\/p>\n\n\n\n During the connection process, you\u2019ll also be prompted to select a sync mode. Choose Per Transaction<\/strong> if you need detailed records and quantity-on-hand tracking. For cleaner books, tracking of inventory assents and COGS totals, Summary Sync<\/strong> is the simpler option.<\/p>\n\n\n With the integrations connected, go into Synder\u2019s settings to choose how data should be posted in Xero. Map sales, shipping, discounts, taxes, fees, and refunds to the right Xero accounts so everything lands in the correct place automatically.<\/p>\n\n\n\n Once mapping is complete, turn on the sync. Synder will start importing WooCommerce orders and related data \u2014 including line items, shipping, discounts, and taxes. In Per Transaction<\/strong> mode, all line items are synced individually, but you can also use the Group by SKU<\/strong> option to track totals for each product. <\/p>\n\n\n\n At the same time, connected payment processors like Stripe or PayPal will feed in fees, refunds, and payout information. From this point on, Synder continuously records new transactions into your Xero clearing accounts using the rules you set up in Step 2.<\/p>\n\n\n When your payment processor issues a payout, Synder creates a transfer in Xero that moves the payout amount from the clearing account to your checking account. This reduces the clearing account balance to zero, or to the same amount as the ending balance in your payment platform, ensuring the account can be fully reconciled.<\/p>\n\n\n\n When the deposit later shows in your Xero bank feed, you only need to match that transfer, not reconcile dozens of transactions one by one. This is the essence of Synder\u2019s reconciliation flow and is what ensures your books align in just a click.<\/p>\n\n\n Refunds and returns flow through the clearing account just like sales but as negative transactions tied back to the original order. This keeps your revenue, tax balances, and cost of goods sold accurate without extra steps. <\/p>\n\n\n\n Keeping past periods accurate is just as important as staying current. Synder allows you to bring in historical WooCommerce data so your books reflect the full picture, not just new sales. With historical sync enabled:<\/p>\n\n\n\n Note:<\/em><\/strong> Importing history is free on Synder\u2019s Premium plan, includes 3 months for free on the Pro plan, and is a paid feature on Basic and Essential plans.<\/p>\n\n\n\n Tracking inventory and COGS properly is a major reason to choose itemized sync with Synder. Without it, many merchants end up doing month-end adjustments or guessing. With correct setup:<\/p>\n\n\n\n Because payment gateways deduct their fees before depositing, your bank deposit is always net.<\/em> To keep things aligned:<\/p>\n\n\n\n This structure ensures your deposit matches the bank feed exactly<\/em>, while still capturing full detail.<\/p>\n\n\n\n Because every payout is recorded as a transfer from the clearing account, when the deposit appears in your Xero bank feed, you don\u2019t need to reconcile line by line. You just match or confirm the deposit with that transfer record. This significantly reduces manual reconciliation work and ensures your bank balance, clearing balance, and sales records stay in harmony.<\/p>\n\n\n\n Because the deposit is net<\/strong> of fees, refunds, taxes, and possibly withheld marketplace tax, while WooCommerce reports often show gross<\/strong> amounts. Without an integration to break those parts out, you\u2019ll always see a gap.<\/p>\n\n\n\n In Summary<\/strong> mode, you map each component, such as tax, shipping, and discounts, to specific Xero accounts (e.g., revenue, liability, contra-revenue). In Per Transaction<\/strong> mode, these settings are defined in Synder, but some categories (like fees) can be assigned manually, while income accounts are determined by the product\u2019s income account in Xero. This ensures recording is granular and automated.<\/p>\n\n\n\n If you need accurate inventory tracking, COGS, or customer details, including closing open invoices with payments, choose the itemized Per Transaction Sync<\/strong>. For smaller stores not tracking stock, the Summary <\/strong>mode may be sufficient. But the itemized sync gives you better traceability.<\/p>\n\n\n\n Synder records the full (gross) sale, posts the fee as a separate expense, and then applies the net transfer. In the Per Transaction<\/strong> mode, the fee is reflected as a bill and payment<\/strong>, while in Summary<\/strong> mode, it\u2019s recorded as a payment and credit note<\/strong>. The deposit in your bank matches that net transfer. So instead of reconciling dozens of lines, you match one transfer.<\/p>\n\n\n\n Yes, when Per Transaction Sync is enabled, every sale adjusts inventory and recognizes COGS. Returns reverse the process automatically.<\/p>\n","protected":false},"excerpt":{"rendered":"If you\u2019ve ever tried to reconcile WooCommerce payments in Xero manually, you already know how messy it can…\n","protected":false},"author":2254,"featured_media":30502,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","csco_post_video_location":[],"csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"footnotes":"","_ppma_block_editor_authors":""},"categories":[43,45,326],"tags":[255],"ppma_author":[391],"class_list":["post-30496","post","type-post","status-publish","format-standard","has-post-thumbnail","category-accounting","category-business-management","category-how-to-do-your-accounting","tag-business-owner","cs-entry","cs-video-wrap"],"yoast_head":"\n<\/figure>\n<\/div>\n\n\nStep 2: Configure mapping<\/strong><\/h3>\n\n\n\n
Step 3: Enable sync and import transactions<\/strong><\/h3>\n\n\n\n
<\/figure>\n<\/div>\n\n\nStep 4: Reconcile the clearing account against payouts<\/strong><\/h3>\n\n\n\n
<\/figure>\n<\/div>\n\n\nStep 5: Handle refunds, returns, and adjustments<\/strong><\/h3>\n\n\n\n
Importing historical WooCommerce transactions<\/strong><\/h2>\n\n\n\n
\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\nInventory & COGS tracking <\/strong><\/h2>\n\n\n\n
\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ul>\n\n\n\nFee mapping & marketplace tax setup<\/strong><\/h2>\n\n\n\n
\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ul>\n\n\n\nMatching WooCommerce payouts to bank deposits<\/strong><\/h2>\n\n\n\n
FAQ<\/strong><\/h2>\n\n\n\n
Why don\u2019t my WooCommerce payouts match what I see in Xero?<\/strong><\/h3>\n\n\n\n
How do I map taxes, shipping, and discounts from WooCommerce to the correct Xero accounts?<\/strong><\/h3>\n\n\n\n
Should I use daily summary or itemized posting?<\/strong><\/h3>\n\n\n\n
How are fees recorded so deposits match my Xero bank feed?<\/strong><\/h3>\n\n\n\n
Can Xero update inventory and COGS automatically when WooCommerce items sell or are returned?<\/strong><\/h3>\n\n\n\n