Automation library

Automate marketplace payouts into QuickBooks Online or Xero

Updated · By Ecomsellertool editorial team

Short answer

To automate marketplace payouts into QuickBooks Online or Xero, pull each Amazon settlement report, Shopify Payments payout and Walmart reconciliation report as it posts, map every line type to an account your accountant approves, and post one balanced summary entry per payout. Rules check that the lines add up to the bank deposit, and anything that does not, such as a reserve or a new fee, goes to a person.

  • Amazon removes the old flat-file and XML settlement reports on November 11, 2026; the Flat File V2 report lists every charge in amount-type, amount-description and amount columns (checked October 23, 2026).
  • Shopify Payments payout details break each payout into charges, refunds, adjustments, fees and reserves, and export to CSV with the amount, fee and net of each transaction.
  • Walmart's Recon Report API returns settlements, order transactions, commissions, shipping fees, taxes, adjustments and refunds for reconciliation.
  • QuickBooks Online requires a journal entry's debits to equal its credits, and Intuit tells users who are unsure which accounts to use to consult their accountant.
  • Xero's own Shopify integration is free on all Xero plans; A2X, a connector app, lists plans from US$29 a month for a channel such as Amazon or Shopify (checked October 23, 2026).

The step map: who runs each step

Trigger: A marketplace payout posts: an Amazon settlement report, a Shopify Payments payout or a Walmart reconciliation report.

Each step of the workflow in order, and whether a fixed rule, an AI model or a person runs it
StepWhat happensWho runs it
1When a settlement or payout posts, the workflow pulls the report with every line item and stores it under its settlement or payout ID.Rule
2The lines are checked to add up to the report's own total, and the payout ID is checked so the same payout is never posted twice.Rule
3Each line type (sales, shipping, refunds, each fee, tax collected by the marketplace, reimbursements, reserves) is mapped to an account through a mapping table your accountant approves.Rule
4An AI model suggests an account for any line type the table has never seen, with its reasoning, and the entry waits until a person accepts or changes it.AI model
5One balanced summary entry is built per payout and currency, with the net amount sent to a clearing account and the source report attached.Rule
6Mismatches are flagged: totals that do not tie out, reserves held or released, refunds without a matching order, and deposits that have not reached the bank.Rule
7A person reviews flagged payouts and approves the entry; payouts that tie out with every line mapped can post on their own once your accountant agrees.Person
8The entry is posted to QuickBooks Online or Xero, matched to the bank deposit when it arrives, and logged with the report it came from.Rule

6 rule steps · 1 AI model step · 1 person step. A rule follows fixed logic you approve; an AI model handles messy input and its output is checked by rules; a person makes the calls listed below.

Person

What stays with a person

  • The account mapping, and any new line type the model suggests an account for
  • Payouts that do not tie out to their own total or to the bank deposit
  • Reserves, chargebacks and disputes, and any reimbursement you choose to chase
  • Month-end cut-off and tax treatment, decided with your accountant
Tools

Which tools can run it

  • Your accounting system's own channel integration, such as Xero's Shopify integration
  • A connector app built for marketplace payouts, such as A2X
  • Custom code on your accounts, when channels, entities or rules outgrow the apps

Systems it connects

  • Amazon Seller Central
  • Shopify Payments
  • Walmart Marketplace
  • QuickBooks Online
  • Xero
  • Your bank feed

Build size: Medium

Reading the reports is routine; the work is the account map for each channel and the checks that catch a payout that does not tie out.

A marketplace payout is not a sale. It is sales, minus fees, minus refunds, plus or minus a dozen smaller lines, netted into one bank deposit days or weeks later. Bookkeepers who enter that deposit as revenue get the books wrong, and bookkeepers who rebuild it from reports every week lose a day to it. This recipe posts each payout as one balanced summary entry, splits fees and refunds by account, and stops the moment something does not add up. It is one page of our automation library.

What does the workflow do, step by step?

The step map above runs once per payout. It starts from the marketplace's own report, never from the bank deposit, because only the report says what the deposit is made of. Xero's e-commerce accounting guide makes the same point: a payout arrives bundled, so you separate gross sales from platform fees and refunds, and the net left over should match the deposit (checked October 23, 2026). Each channel publishes that breakdown in its own format.

ChannelWhere the payout data comes fromWhat it lists
AmazonThe settlement report, Flat File V2, retrieved through the Selling Partner API. Amazon schedules these reports itself; they cannot be requested or scheduled, and the older flat-file and XML versions are removed on November 11, 2026 (checked October 23, 2026)Settlement start and end dates, deposit date and total amount, then one row per charge, with amount-type, amount-description, amount and SKU
Shopify PaymentsPayout details in the Shopify admin, exportable to CSV (checked October 23, 2026)Charges, refunds, adjustments, fees and reserves; per transaction, the amount, fee and net
WalmartThe Recon Report API, which Walmart says can be parsed into accounting and ERP systems (checked October 23, 2026)Settlements, order transactions, commissions, shipping fees, taxes, adjustments and refunds

Between settlements, Amazon's Finances API returns financial events without waiting for a statement period to close; its current version, v2024-06-19, lists them through listTransactions (checked October 23, 2026). The workflow can use it to warn early about a large refund or a new charge, but it posts from the settlement report, so the entry matches the money that actually moved.

The heart of the build is the account map: one row per line type, agreed with your accountant before anything posts. The table below is an example of its shape, not a recommendation for your books.

Line type in the payoutExample accountNote
Product salesSales, one account per channelLets you see revenue by channel
Shipping and gift wrap charged to buyersShipping incomeKept apart from product sales
Refunds to buyersSales refundsRefund fees go with the other fees
Referral, commission and fulfillment feesSelling fees and fulfillment costsOne account per fee family keeps contribution margin readable
Advertising charged against the payout, if your ad account bills that wayAdvertisingOtherwise ads arrive as a card charge
Sales tax the marketplace collected and remitsA tax clearing account, not incomeUnder marketplace facilitator rules, the marketplace collects; your accountant decides the treatment
Reimbursements for lost or damaged unitsOther income or an inventory adjustmentYour accountant decides
Reserve held back or releasedA marketplace reserve balanceExplains why the deposit differs from sales minus fees
The net payoutA clearing account for the channelCleared when the bank deposit is matched

Payout check: sales + other income − refunds − fees − other charges − reserve held + reserve released = the bank deposit

The same order rows, with each order's ship-to state, can also feed our sales tax nexus threshold alerts, which warn your finance owner before your sales into a state reach its registration threshold.

What changes on November 11, 2026 for Amazon settlement reports?

Amazon's SP-API deprecation schedule removes the old Flat File and XML settlement reports on November 11, 2026; they were deprecated on March 17, 2025 (checked October 23, 2026). Any payout posting, A2X-style import or spreadsheet macro that still reads GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE or GET_V2_SETTLEMENT_REPORT_DATA_XML stops getting new settlements that day. The replacement is not a rename, so check each of these before then.

What changesBeforeFrom November 11, 2026What the workflow must do
Report typeGET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE or _XMLOnly GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2Search for the V2 report type with getReports; settlement reports still cannot be requested
Where each charge sitsPrices spread across separate columnsThree columns: amount-type, amount-description, amountMap each charge on the pair of amount-type and amount-description, not on a column name
Number formatOne formatAmounts in the marketplace's local format, such as 95,00 in the EUParse amounts by marketplace before adding them up
A fee Amazon adds laterCould need a new columnArrives as a new amount-description in the same amount columnAn unmapped description stops the entry and goes to the model step and a person
App permissionThe old flat file listed three roles, including Inventory and Order TrackingV2 lists only the Finance and Accounting roleConfirm your app registration includes Finance and Accounting
Events between settlementsFinances API v0 listFinancialEvents calls, removed August 27, 2027Finances API v2024-06-19 listTransactionsMove early warnings to listTransactions and expect breakdown types Amazon has not listed yet

The transactions call needs one more rule. Amazon's listTransactions reference returns transactions as DEFERRED, RELEASED or DEFERRED_RELEASED, up to 500 per page, and says financial events might not include orders from the last 48 hours (checked October 23, 2026). Amazon's guide to matching transactions to a payment filters on RELEASED and the payment's financial event group ID. A workflow that adds up every status double counts money Amazon is still holding, so the early-warning pull filters by status and never feeds the posted entry.

If your accounting runs on a connector app, ask the vendor whether it already reads the V2 report. If it runs on your own code, the change is usually a short job: new report type, a mapping table keyed on amount-type and amount-description, locale-aware parsing, and a test against your last three settlements. Send us the workflow if you want it checked before November 11.

Which tool should run it?

Pick the simplest option that covers your channels, and be honest about when that is an app rather than a build. If you sell on Shopify and use Xero, start with Xero's own Shopify integration: Xero lists it as free on all Xero plans, syncing sales, payouts, fees and taxes, with a daily summary option for high-volume stores (checked October 23, 2026). If you sell on several standard channels, a connector app is usually the better choice than custom code.

OptionFits whenWhat to know
Your accounting system's own channel integrationOne Shopify store into XeroFree on all Xero plans; daily summary or per-sale sync; Shopify Payments payouts matched to the bank
A connector app such as A2XStandard channels into one accounting fileA2X says it posts payout summaries to QuickBooks Online, Xero, Sage or NetSuite for channels including Amazon, Shopify, eBay, Etsy, Walmart, TikTok Shop and PayPal. Its pricing page lists plans from US$29 a month for channels such as Amazon or Shopify, and from US$79 a month for Walmart (checked October 23, 2026)
Custom code on your accountsChannels or charges the apps miss, several legal entities, your own mapping rules, or payout data that also feeds reportingQuickBooks Online journal entries must balance, debits equal to credits, and Xero's Accounting API has a Manual Journals endpoint for posting them (checked October 23, 2026). It can run on Ecomsellertool Growth OS

Custom code earns its cost when the payout is one input among several: 3PL invoices, landed costs, a profit report per SKU and a finance team that wants the mapping rules in code it can test. If all you need is clean books for two channels, the app is cheaper and you should use it.

What should stay with a person?

The account map, first of all. The model step exists for the day a marketplace adds a fee type nobody has seen: it suggests an account and explains why, but the entry waits until a person accepts or changes the mapping. After that, a person handles the payouts the rules flag, decides what to do about reserves, chargebacks and disputes, and closes the month with your accountant. If you sell into the EU or UK, the documents behind these numbers have their own recipe: VAT invoices for marketplace orders. Recovering lost inventory is a separate job, covered on our FBA reimbursements page; this workflow only books the reimbursement lines Amazon has already paid.

What can go wrong, and how do you catch it?

Most errors in marketplace bookkeeping are timing and classification errors, not arithmetic. Each one needs a check that stops the entry instead of posting a wrong number.

What goes wrongHow it shows upThe check that catches it
Amazon holds a reserveThe deposit is less than sales minus feesReserve lines map to a reserve balance; Amazon's guide to account level reserves describes them as temporary holds, set per seller, with a standard release 7 days after delivery: a January 1 sale delivered on January 6 is typically released on January 14 (checked October 23, 2026)
The deposit is late or missingThe clearing account does not clearAn alert when no matching bank line arrives in the expected window; Shopify says a bank can take 1 to 3 business days to deposit a payout
A new fee type appearsAn unmapped lineThe model suggests an account and the entry waits for a person
A settlement spans two monthsRevenue lands in the wrong monthYour accountant chooses the cut-off rule, and the workflow applies it the same way every time
The same payout is posted twiceDoubled sales and feesPayout and settlement IDs are stored and a repeat is refused
3PL charges never appearFulfillment costs look too low3PL invoices are a separate input, checked as on our 3PL reconciliation page and booked as bills by our supplier invoices recipe

Cash on delivery that your own courier collects never appears in a marketplace payout. It arrives in the courier's remittances, which our COD remittance reconciliation recipe matches order by order. Gift cards sold through Shopify reach the payout as cash but stay a liability until redeemed; our gift card liability reconciliation recipe ties that liability to Shopify's outstanding balance each month.

Who builds this for ecommerce brands?

Ecomsellertool builds finance workflows like this one on your own accounts. We have built software on Amazon's seller APIs since 2017, including fee and finance data pipelines for profit reporting, and shipped 50+ tools for 100+ teams. We map your channels and your accountant's chart of accounts first, then build the pulls, checks and postings. Send a project brief below, or read how our workflow automation service works.

The data side of this recipe is work we have shipped:

  • Fees Amazon does not report as a line. For Seller-Drive we built a profit and loss statement that pulls Amazon's financial data through its Finances API and a fee calculation engine that computes the fees Amazon does not provide.
  • An accounting firm's Amazon pipeline. For Zonkeepers, an accounting firm, we built an AWS pipeline that ingests Amazon order and finance reports into P&L analytics, with Amazon fees, tax, shipping, refunds, promotions and reimbursements broken out.

Get this workflow built

Send us your version of this workflow

Describe the workflow you want automated. We reply with a written plan: scope, timeline and a fixed price.

A few sentences is enough: what happens today, who does it and how often.

Starts when you fill in the form

A quick private check that runs in your browser. No tracking, no puzzles.

A person reads every brief. You get a written plan within 2 business days; no obligation.

Frequently asked questions

Should I post every marketplace order to QuickBooks or Xero?

Usually not. Most brands post one summarized entry per payout, split by account, and keep order-level detail in the marketplace reports or their own reporting. Summaries keep the ledger readable and still match the bank deposit. Your accountant decides how much detail your books need.

Why doesn't my Amazon deposit match my sales?

Because a payout is net. Amazon deducts fees, refunds and other charges before it pays, and it can hold part of the balance as a reserve that is released in a later period. The settlement report lists each of those lines, which is why the workflow posts from the report rather than from the bank deposit.

Will my Amazon payout posting break on November 11, 2026?

It will if it still reads the old Flat File or XML settlement report, which Amazon removes on November 11, 2026. Switch to the Flat File V2 settlement report, map charges on its amount-type and amount-description columns, parse amounts in each marketplace's local format, and test the change against recent settlements before that date.

Is A2X or a custom build better for marketplace accounting?

For standard channels going into one accounting file, a connector app such as A2X is usually the better choice, since it is built for exactly this job. A custom build earns its cost when you have channels or charges the app does not cover, several legal entities, mapping rules of your own, or payout data that also feeds other systems.

Can the workflow post entries without anyone checking them?

It can, for payouts that tie out to the deposit and contain only line types already mapped, if your accountant agrees. Anything else, such as a new fee, a reserve change or a missing deposit, waits for a person. Many teams review every entry for the first few months, then switch to exceptions only.

Is this page accounting or tax advice?

No. It shows how the workflow moves and checks the numbers. Which accounts to use, how to treat sales tax a marketplace collected, reserves and reimbursements, and how to handle a payout that spans two months are decisions for your accountant or tax advisor.

Which marketplaces can this workflow handle?

Any channel that publishes payout data you can download or read through an API. This page covers Amazon settlement reports, Shopify Payments payouts and Walmart's reconciliation report. For any other channel we check its payout data first, before we put it in a plan.

Jaimin Dholakia, founder of Ecomsellertool
Jaimin Dholakia · Founder
Schedule a call

Get this workflow built on your own systems.

Prefer to talk the workflow through first? Schedule a free call with the engineers who would build it. Selling on Amazon? The free 24-hour diagnostic finds the operations gaps in your account: connect it with Login with Amazon, on Amazon’s own consent screen (we only read data; we never change listings, prices, stock or ads), and get a report within 24 hours of connecting, on business days.

Free · 30 minutes · Pick any open slot