Ecommerce accounting automation: syncing Shopify, Amazon, Etsy and TikTok Shop payouts to QuickBooks or Xero

Month-end in a multichannel shop usually starts with the same puzzle. The sales report says one number, the bank received another, and nobody can say quickly which orders, fees and refunds sit inside each deposit. Ecommerce accounting automation solves that by moving sales, fees, refunds and payouts from each channel into QuickBooks or Xero in a form your bookkeeper can reconcile, without exporting CSVs.

This guide is for sellers on two or more of Shopify, Amazon, Etsy and TikTok Shop, and for the bookkeepers who close their months. It explains why payouts never match orders, the two ways to post the data, what each platform's finance API provides, how the ready-made tools work and when a custom sync makes sense.

One boundary first: I am a developer, not an accountant. Which accounts, tax codes and recognition rules you use is a decision for your accountant. This post covers the data and the plumbing that carries it.

Why payouts never match your orders

A payout is not a total of orders. It is the net of many movements over a period:

• Fees come out first. Referral or commission fees, fulfilment fees and payment processing fees are deducted before the money reaches you.
• Refunds and chargebacks are netted from later payouts, often in a different period from the original sale.
• Periods overlap. A payout covers a window that rarely lines up with calendar months. Intuit's guide to its Amazon connector describes Amazon payouts as typically covering sales over a 14-day period.
• Some money is held back. Amazon's Finances API marks some transactions as deferred until they are released, so a sale can appear before its money does.
• Several payers. On Shopify, Shopify Payments, PayPal and other providers each pay separately. TikTok Shop orders that sync into Shopify are paid by TikTok, to the bank account connected to TikTok, as Shopify's help centre explains.
• Tax and currency. Tax a marketplace collects on your behalf, and payouts in a different currency, add more lines.

So a payout breaks down as: sales and shipping charged, plus tax collected, minus refunds, minus each type of fee, minus amounts held back, plus or minus adjustments. Automation has to rebuild that breakdown for every deposit.

Summary journals vs order-level sync

There are two ways to get that breakdown into the books.

Approach	What lands in QuickBooks or Xero	Trade-off
Order-level	An invoice or sales receipt per order, plus fees and refunds	Full detail, but thousands of documents and hard to match to one deposit
Summary per payout	One entry per payout, split into sales, refunds, each fee type and tax, netting to the deposit	Matches the bank line one to one; order detail lives elsewhere
Hybrid	Summary entries in the ledger, order detail in your own database	Clean books plus lookups, but two places to maintain

For most sellers with real volume, summary entries per payout keep the ledger readable and make bank reconciliation a single match per deposit. Order-level sync suits low volume, or businesses that need customer-level records in the accounting system. Agree the choice with your accountant before anything is built.

The data each platform's finance API provides

Whatever posts the entries, a tool or custom code, it reads the same official sources.

Amazon. The settlement report (GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2) lists every line in a settlement period; Amazon generates it automatically and it cannot be requested on demand. The Finances API (version 2024-06-19) returns transactions with a breakdown of each amount, linked to order and settlement identifiers, and lets you work out which released transactions make up a payment. Amazon notes that its financial events might not include orders from the last 48 hours, so a sync should re-check recent days.

Shopify. For Shopify Payments, the GraphQL Admin API exposes payouts and the balance transactions inside them: amount, fee, net, type, the payout each belongs to and the related order. Reading them requires the view_payouts permission. Other payment providers have to be reconciled from their own statements.

Etsy. The Open API v3 has payment endpoints with the gross amount, card processing fee and net amount per order, and Payment Account ledger entries recording payments, refunds, disbursements to your bank and other debits and credits. Both need the transactions_r scope.

TikTok Shop. TikTok's Partner API includes finance endpoints for statements and payments, documented inside TikTok Shop Partner Center. Seller Center's Finance section shows each settlement period, which is the place to check figures by hand.

Ready-made tools: A2X, Link My Books and native connectors

Before building anything, look at the tools that already do this.

• A2X connects Amazon, Shopify, eBay, Etsy, Walmart, TikTok Shop and PayPal to QuickBooks Online and Xero. It describes its output as auto-categorised summaries of sales, fees and taxes matched to deposits, with rules per transaction type and optional COGS workflows.
• Link My Books covers Amazon, Shopify, eBay, Etsy, Walmart, TikTok Shop, Square and WooCommerce, posting to Xero or QuickBooks Online. It sends a summary invoice for each payout, matches bank deposits automatically and has built-in VAT, GST and sales tax handling.
• Synder offers both per-transaction and summary sync, if your accountant wants order-level detail.
• Native connectors. Intuit's Amazon Connector by QuickBooks imports each Amazon sale as a separate transaction with its fees, plus payout summaries, into QuickBooks Online.

These tools are maintained, cost a monthly subscription, and your bookkeeper may already know them. If one supports all your channels and your accountant is happy with its entries, use it.

When a custom accounting sync makes sense

A custom sync earns its place when the tools do not fit how the business runs:

• A channel they do not cover, such as a wholesale portal, a regional marketplace or your own custom site.
• Rules of your own: several legal entities, tracking categories per brand or warehouse, or fees split in a way your accountant needs.
• Costs from your own systems. Landed cost per SKU from your purchasing records, so gross margin is right in the books.
• One pipeline for several jobs. The same payout data can feed a profit view in a multichannel sales dashboard, not only the ledger.

On the accounting side, both QuickBooks Online and Xero have public APIs. Since 2 March 2026 Xero has priced API access by tier, and its Starter tier, with up to five connections, carries no charge; a business linking only its own organisation needs one connection. Check current terms before you build.

No-code platforms can move simple payout totals, but per-fee breakdowns, retries and idempotency get awkward quickly. I compare the options in Zapier, Make, n8n or custom code.

How to set up ecommerce accounting automation well

Whether you buy a tool or build a sync, the same rules apply:

1. Design the entries with your accountant first: accounts, tax codes, summary or order-level, and a clearing account per channel or payment provider.
2. Make every payout entry net to the deposit, so reconciliation is one match per bank line.
3. Map every transaction type explicitly. Unknown types go to a suspense account and raise an alert; they are never dropped silently.
4. Post each payout exactly once. Store the payout or settlement ID and refuse duplicates, so a retry cannot double-count.
5. Handle currency and time properly. Post in the payout's currency, store timestamps in UTC and cut periods in your business's own timezone.
6. Keep the raw files from each platform, so any entry can be traced back to its source.
7. Reconcile monthly: posted payouts against bank deposits per channel, with differences listed.
8. Start from a clean date. Do not re-post months your accountant has already closed.

What ecommerce accounting automation costs

A subscription tool is the cheapest route when it fits. A custom sync costs more up front and fits your rules exactly.

I build e-commerce automation and integrations on official APIs. A payout export from one marketplace into your accounting software is the kind of single automation my Marketplace & e-commerce apps MVP plan covers, from $2,500. Two or more channels with stock and orders kept in sync, plus a dashboard, start from $5,500 on the Flexible plan. These are starting prices; every project gets a fixed quote after a short brief, payment is in milestones you can try, and the code and accounts stay in your name. See custom e-commerce automation for how this fits with the rest of a seller's setup.

FAQ

Why doesn't my Shopify payout match my sales for the same days?

A Shopify Payments payout contains the balance transactions that were available when it was issued, not the orders placed on those days. Processing fees are deducted, refunds and chargebacks are netted against later payouts, and orders paid through PayPal or other providers are paid out separately. Marketplace orders synced into Shopify, such as TikTok Shop orders, are paid by the marketplace itself. Match each payout to its balance transactions instead of to a date range of orders.

Should I post every order to QuickBooks or Xero, or one entry per payout?

For most sellers with steady volume, one summary entry per payout is easier to live with: it splits sales, refunds, fees and tax, nets to the bank deposit and keeps the ledger readable. Posting every order makes sense at low volume or when you need customer-level records in the accounting system. Ask your accountant which they prefer before choosing a tool or building a sync, because changing later is painful.

Do I need A2X or Link My Books, or can I build my own sync?

Try the ready-made tools first. A2X and Link My Books both support Shopify, Amazon, Etsy and TikTok Shop and post summary entries to QuickBooks Online or Xero, and your bookkeeper may already use one. Build your own when a channel is not supported, when your entities or tracking categories need rules the tools cannot express, or when the same payout data should also feed your own reporting.

If you want your payouts landing in the books without CSVs, send me a short brief: which channels you sell on, whether you use QuickBooks or Xero, roughly how many orders a month you handle and how your bookkeeper closes the month today. For the wider picture, start with e-commerce automation: what to automate first.