Syncing your store, accounting and inventory

If you sell online, three records need to agree: what you sold, the money you received, and what you have left in stock. When they live in separate systems that do not talk to each other, someone spends hours reconciling them, and mistakes slip through. Overselling, wrong tax figures and month-end surprises usually trace back here. This guide explains how to connect them and what to decide first.

The three systems

Your store (Shopify, WooCommerce, Squarespace, a marketplace) records orders, customers and often stock.
Your accounting software (QuickBooks, Xero and others) records income, fees, taxes and bank activity.
Your inventory may be tracked in the store itself, or in a separate inventory or warehouse system if you sell in several places, hold stock in multiple locations, or manufacture.

Step 1: Decide the source of truth

For each kind of information, pick one system that owns it. Other systems receive copies.

Information	Common owner
Products, prices, descriptions	Store, or an inventory system if you sell on several channels
Stock levels	Store if you sell in one place; an inventory system if you sell in several
Orders	Store or marketplace where the sale happened
Revenue, fees, taxes, payouts	Accounting software

The most common failure is two systems both believing they own stock levels and overwriting each other.

Each kind of information has one owner. Other systems get copies. Two systems that both think they own stock will overwrite each other.

Read this as text

Selling in one place. Your store owns products, prices, descriptions, stock levels and orders. It sends sales to your accounting software, either order by order or as a daily or per-payout summary. Accounting owns revenue, fees, taxes and payouts.

Selling on several channels. An inventory or order management system usually becomes the hub. It owns products, prices and stock levels and sends stock to each channel. Each channel, such as your store or a marketplace, owns the orders placed on it and sends them to the hub. The hub connects to accounting, which still owns revenue, fees, taxes and payouts.

The most common failure is two systems both believing they own stock levels and overwriting each other.

Step 2: Choose how sales reach accounting

There are two broad approaches.

Order-by-order

Every order creates a sales record in your accounting software, with the customer and line items.

Pros: Full detail in your books.
Cons: Large volumes clutter the books and can create thousands of customer records.

Summary entries

The connector posts a daily or per-payout summary: total sales, tax, shipping, discounts, fees and refunds.

Pros: Clean books, easier reconciliation with payouts.
Cons: Less detail in accounting. You look at the store for individual orders.

Higher-volume stores often prefer summaries. Your accountant or bookkeeper should help choose, because it affects how they work.

Step 3: Map the details

This is where most problems come from. Work through it with your bookkeeper.

Sales accounts. Which income account each product type or channel posts to.

Taxes. How the store's tax settings map to your accounting tax codes. Test orders from different regions. See Sales tax basics.

Payment processor fees. Record sales at their full amount and fees as an expense, rather than recording only the net payout.

Payouts. Use a clearing account for each payment provider, so you can match payouts to your bank deposits. See Payouts and bank transfers.

Refunds, discounts, gift cards and shipping. Each needs a clear home.

Products and SKUs. Every product and variant needs a unique SKU that matches in every system. Mismatched SKUs are the main cause of stock errors.

Step 4: Pick the connector

Native or vendor apps. Accounting platforms and stores offer connectors in their app marketplaces. These are the usual first choice. See Shopify apps explained or WooCommerce extensions explained.
Specialist sync tools. Third-party services built specifically to post e-commerce sales to accounting, often with good summary and payout handling.
Inventory systems. If you sell on several channels, an inventory or order management system often becomes the hub, connecting each channel and the accounting software.
General automation tools such as Zapier or Make can fill gaps, but are rarely the best choice for core accounting sync.
Custom integration for unusual setups or high volume. See When a no-code automation becomes a custom integration.

Step 5: Test, then go live

Before you go live

0 of 4 done

Start from a clear date, ideally the start of a month or accounting period.
Process a handful of real orders, including a refund, a discount and an order from a different tax region.
Check each one in accounting and compare stock levels in every system.
Do not import historical orders without your bookkeeper's agreement. It can double-count income already recorded.

Saved in this browser only.

Keeping it healthy

Reconcile monthly. Match payouts from your payment provider to bank deposits, and store sales totals to accounting totals.
Count stock periodically and compare with the system. Investigate differences rather than overwriting them.
Watch for sync errors. Most connectors show a log or send alerts. Someone should check it weekly. See Keeping automations from breaking silently.
Re-test after changes, such as new tax rules, new sales channels or new payment methods.

Common mistakes

Recording net payouts as revenue, which understates sales and hides fees.
Two systems managing stock without a clear owner.
Missing or duplicate SKUs.
Setting it up without the bookkeeper, then discovering the books need cleaning up at year end.