Payout Reconciliation Software: Payout Reconciliation Reports for Shopify, Stripe, and Etsy Sellers
Gross
Fees
Take-home
...
Next month Estimate
Payout calendar
Sample data for illustration
In short
Payout reconciliation is the process of matching each deposit that lands in your bank account to the individual orders, refunds, and fees that make it up. It is necessary because a payout is a net number and your sales are a gross number, so the two never agree on their own. Shopify publishes a payout reconciliation report under Finance then Documents, which breaks a date range into starting balance, activity before fees, fees, total payouts, and ending balance, on a 3-day data delay. Stripe publishes an equivalent payout reconciliation report that ties each bank deposit to the batch of charges, refunds, and fees behind it. The gap most sellers hit is that neither report knows about the platform on the other browser tab. Etsy, Amazon, Gumroad, Patreon, YouTube, and Twitch each settle on their own schedule with their own deductions, and none of them files into Shopify or Stripe. Connector tools such as A2X (from $29 a month per sales channel) and Synder ($65 a month on the Basic plan) post reconciled journal entries into QuickBooks Online or Xero. Earnly, from $12 a month, sits one step earlier and shows gross, fees, and take-home per payout across twelve platforms on a single board.
Last updated August 2026
The honest read
Every payout reconciliation problem starts the same way. Money arrives. The amount is specific and slightly wrong: $2,143.17, or $6,904.62, or $318.40. It is not a number you recognize, it does not match any order, it does not match any day of sales, and there is no obvious way to work backward to what it covers. That gap between the deposit and the sales is the entire job, and it exists because payment platforms settle in batches while your store records revenue per order. A Shopify payout on a Thursday might cover Monday afternoon through Tuesday afternoon, minus two refunds, minus processing on every charge in the batch, minus a chargeback you did not know about, plus a release from reserve. Seven moving parts, one number. The good news is that both Shopify and Stripe now publish a real reconciliation report, and most sellers have never opened either one. In Shopify the path is Finance, then Documents, then Payout Reconciliation Report. It covers a date range you pick (last month, last three months, last six months, or a custom range starting from January 1, 2025), and it lays out a summary of starting balance, balance change from activity, activity before fees, fees, net, total payouts, and ending balance, with the detail broken out by type: charges, refunds, disputes, adjustments, duties and taxes, reserves and holds, shipping, Shopify Capital, and the rest. The one thing to know before you trust it is the 3-day data delay, so a transaction captured yesterday will not be there. Stripe has the same idea under a different name. The Stripe payout reconciliation report matches each payout in your bank account to the batch of payments and other balance transactions it settles, and the balance summary report gives the higher-level starting balance, activity, payouts, ending balance view for a period. Both download as CSV from the Dashboard, in summary or itemized form. Where this breaks down is the second platform. A seller who runs a Shopify store and an Etsy shop and a Patreon has three reconciliation problems, not one, and only Shopify hands them a reconciliation report. Etsy publishes a monthly statement but not a reconciliation document. Patreon initiates payouts on the 5th and shows you a balance, not a batch. YouTube pays through AdSense on a $100 threshold with a payment window from the 21st to the 26th. Twitch has a $50 threshold and net-15 terms. Each one deducts differently and settles differently, and the deposits all land in the same checking account looking like undifferentiated ACH credits. This is the point where sellers reach for a connector. A2X, at a published starting price of US$29 a month per sales channel for Amazon, Shopify, Etsy, eBay, and PayPal (Walmart is $79), posts a summarized journal entry per payout into QuickBooks Online or Xero, split into gross sales, fees, refunds, and sales tax, so the entry reconciles to the penny against the bank line. Synder does a similar job with a different shape, at $65 a month for Basic on monthly billing with 500 synced transactions included, rising to $115 for Essential and $275 for Pro. Link My Books is the third name that comes up constantly, and it is worth flagging that the vendor does not publish fixed tier prices at all: the pricing page is a calculator driven by orders per month (200 up to 250,000) and channel count (1 to 10), so any comparison article quoting you Link My Books plan names and dollar figures is quoting something the vendor page does not show. Those tools solve the accounting-entry half of the problem, and they solve it well. What none of them is built to do is answer the question a creator or a small seller actually asks first, which is simply: of everything I sold this month, across every platform, how much am I keeping, and when does it land? That is the slot Earnly sits in. It is not accounting software and does not pretend to be. It keeps no ledger, tracks no expenses, files nothing, and never touches your money. What it does is put every payout from twelve platforms on one board as gross, then platform fees, then processing, then take-home, with a payout calendar of expected pay dates and a next-month forecast that is always labeled an estimate, from $12 a month. If your accountant needs journal entries in Xero, buy the connector. If you need to see whether Etsy is worth the hours now that Offsite Ads is taking 15% of the orders it sources, that is a different tool, and it is this one.
Published prices
Where each platform publishes a payout report, and what it actually gives you
The single most useful thing to know about payout reconciliation is that only some platforms hand you a reconciliation document. The rest give you a statement, a balance, or nothing. Verified against vendor documentation in August 2026.
| Platform | Where to find the payout report | What it reconciles | Catch |
|---|---|---|---|
| Shopify Payments | Finance > Documents > Payout Reconciliation Report | Starting balance, activity, fees, payouts, ending balance | 3-day data delay, ranges start Jan 1, 2025 |
| Shopify (transactions) | Settings > Payments > View payouts > View Transactions | Per-transaction amount, fee, net, payout date | CSV is emailed, not downloaded in browser |
| Stripe | Dashboard > Reports > Payout reconciliation | Each bank deposit to the batch of charges behind it | Automatic payouts only; manual payouts differ |
| Stripe (fees) | Dashboard > Reports > All Fees | Every fee charged in a date range | Separate from the payout report |
| Etsy | Shop Manager > Finances > Monthly Statements | Monthly fees and deposits, not per-payout batches | No reconciliation document, statement only |
| Amazon | Seller Central > Payments > Date Range Reports | Settlement totals per disbursement period | Reserves shift the amount without warning |
| PayPal | Reports > Activity download | Transaction-level gross, fee, net | No batching concept, so no payout batch view |
| Patreon, Gumroad, Ko-fi, Substack | Creator dashboard earnings pages | Running balance and payout history | No downloadable reconciliation report |
| YouTube (AdSense) | AdSense > Payments > Transactions | Monthly earnings finalized, threshold, payment issued | Earnings finalize by the 3rd, paid 21st to 26th |
| Twitch | Creator Dashboard > Revenue > Payout History | Payout amount, period, method | $50 threshold, net 15, so timing lags a month |
Shopify and Stripe details come from the vendor help documentation in August 2026. Platform dashboards change their menu paths regularly, so treat the exact click path as a starting point rather than a permanent address. Every figure on this page is an estimate you should confirm against your own platform statements before filing anything.
Published prices
Payout reconciliation tools compared, by the job each one does
These products get grouped together in roundups and they should not be. Two of them push journal entries into a ledger, one is a ledger, and one shows you what you keep. US list prices as published on the vendor pricing pages in August 2026.
| Tool | Entry price | What it reconciles | Where the output goes |
|---|---|---|---|
| Earnly | $12/mo Solo | 12 platforms: gross, fees, take-home per payout | A board you read, plus CSV and PDF export |
| QuickBooks Online | $38/mo Simple Start | Bank feed against your own ledger entries | Your books, but the deposit stays net |
| A2X | From $29/mo per channel | One payout into a split journal entry | QuickBooks Online or Xero |
| A2X (Walmart) | From $79/mo | Same, for the Walmart channel | QuickBooks Online or Xero |
| Synder | $65/mo Basic, 500 transactions | Transaction-level sync with fee splitting | QuickBooks Online, Xero, or Sage |
| Synder Essential | From $115/mo, 1,000 transactions | Same, at higher volume | QuickBooks Online, Xero, or Sage |
| Link My Books | Calculator, no published tiers | Shopify, Stripe, PayPal and marketplace payouts | QuickBooks Online or Xero |
Link My Books is listed without a price on purpose. Its pricing page in August 2026 is an interactive calculator keyed to orders per month and channel count, with no named tiers and no fixed dollar figures, so quoting a plan price here would mean repeating a third-party number the vendor does not publish. Synder prices are the monthly-billing figures; annual billing is roughly 20% lower. A2X charges per sales channel, so Shopify plus Etsy is two subscriptions.
How to reconcile a Shopify payout, step by step
Work from the deposit backward, not from the orders forward. Orders forward is what makes this take four hours.
- 1. Pull the bank line. Note the exact amount and the date it cleared. Shopify Payments deposits in the US settle a minimum of 3 business days from the business day after capture, so the money is describing sales from earlier in the week.
- 2. Open Finance, then Documents, then Payout Reconciliation Report. Set the range to the month that contains your deposit. Read the summary block first: starting balance, activity before fees, fees, net, total payouts, ending balance. If ending balance minus starting balance equals activity minus payouts, the period is internally consistent.
- 3. Match the payout line. In the Payouts section, find the row whose amount equals your bank line. That row is your batch.
- 4. Export the transactions. Settings, then Payments, then View payouts, then View Transactions. Filter to the payout date, pick your CSV type, and click Export balance transactions. The file is emailed to you and to the store owner rather than downloading in the browser, which surprises people the first time.
- 5. Add it up. The CSV carries amount, fee, and net per transaction along with the payout status and date. Sum net for the batch. It should equal the deposit. If it does not, the difference is almost always a refund dated outside your filter, a dispute, or a reserve movement.
- 6. Record gross, then fees. In your books, the income line is the sum of the amount column, and the fees are a separate expense. Recording the deposit as income understates your revenue by exactly the fee total, which is the mistake that makes a Schedule C disagree with a 1099-K.
If you want the schedule side of this rather than the arithmetic, the Shopify payouts tracker shows the same payouts with gross, fees, and take-home already separated, and the guide to a Shopify payout stuck on pending covers the case where the deposit never arrives at all.
How to reconcile a Stripe payout
Stripe splits the job across two reports and it helps to know which one you want. The balance summary report answers "what happened to my balance this month" with starting balance, total activity, total payouts, and ending balance. The payout reconciliation report answers "what is in this specific deposit" by tying each payout to the batch of charges, refunds, and other balance transactions that settled inside it. If you use automatic payouts, which most people do, the payout reconciliation report is the one that matches a bank line.
Both live under Reports in the Dashboard and both download as CSV. Each section offers a Summary download, which is the data exactly as shown on screen, and an Itemized download, which is the full underlying transaction list. Take the itemized version when you are chasing a discrepancy and the summary when you are handing something to a bookkeeper.
Fees are reported separately. Reports, then All Fees, filtered to a date range, gives you every fee Stripe charged in the period, which is what you want for the expense side of the entry rather than trying to derive it from the payout batch. Stripe's standard US card rate is 2.9% plus $0.30 and payouts run on a rolling schedule roughly 2 business days behind, so a Monday payout is broadly Thursday and Friday money.
Why your payout never matches your sales, in one paragraph
Because they are measuring different things at different moments. Sales are recorded when the order is placed, at gross, in your store's timezone. A payout is recorded when a batch settles, at net, on the processor's schedule, after subtracting per-transaction processing, platform commission, refunds that landed in the window, chargebacks, currency conversion if you sell internationally, and any amount held back in reserve. Add sales tax, which you collected but do not own, and the two numbers have almost no reason to agree. Reconciliation is not about making them equal. It is about proving that the difference is fully explained.
The practical test is whether every dollar of the gap has a name. Gross sales minus platform fees minus processing minus refunds minus reserve equals payout. If it balances, you are done. If there is $18.40 left over, that is not rounding, it is a transaction you have not found yet, and it is worth finding, because industry estimates put undetected reconciliation discrepancies at 2% to 4% of transaction volume for stores that never check.
Reconciling platforms that publish no reconciliation report
This is the part of the job that no connector covers, and it is most of the job for anyone whose income is not all card payments through one store. Etsy gives you monthly statements, not payout batches. Patreon initiates payouts on the 5th and shows a balance. Gumroad pays out on Fridays once you clear $10. Ko-fi holds nothing and pays straight through. Substack pays via Stripe with no payout day and no threshold. YouTube pays through AdSense on a $100 threshold, finalizing earnings by the 3rd and issuing payment between the 21st and the 26th. Twitch holds until $50 and pays net 15, which means the money you earned in January arrives around the middle of March.
With no reconciliation document, the method is to build one. For each platform, record gross for the period, the platform's own published deduction, processing where it is charged separately, and the resulting expected net, then check that expected net against the deposit when it lands. The platform fees calculator covers the deduction side per platform, and the payout calendar covers the timing side so you know which month a deposit belongs to. Doing this by hand across four platforms is a monthly spreadsheet chore. Doing it across twelve is why this product exists.
Payout reconciliation and your 1099-K
This is the reason reconciliation stops being bookkeeping hygiene and starts being money. Payment platforms report your gross to the IRS. Form 1099-K carries unadjusted gross sales for the year before any fee, refund, or shipping cost is subtracted. Your bank account only ever saw net. If you build your Schedule C from deposits, your reported receipts will be lower than the 1099-K the IRS already holds, by exactly the amount of the fees, and a mismatch is a straightforward trigger for a notice.
The correct treatment produces the same taxable profit by a different route: report the gross as income, then deduct the platform and processing fees as a business expense. Reconciliation is what gives you a defensible gross figure to report. Worth knowing for 2026 filings: the One Big Beautiful Bill Act moved the 1099-K threshold back to more than $20,000 and more than 200 transactions, with both conditions required, and moved the 1099-NEC and 1099-MISC threshold from $600 to $2,000 for payments made on or after January 1, 2026. Income is taxable whether or not a form is issued, and some states set lower thresholds than the federal one. See the 1099 guide for content creators for the full picture, and confirm your own position with a CPA.
When you need A2X or Synder, and when you do not
Buy a connector when the output has to be a journal entry. If you have a bookkeeper who works in QuickBooks Online or Xero, if you file a corporate return, if you carry inventory, or if you are being asked for month-end close on a schedule, a tool that posts a split entry per payout is worth its price several times over in hours saved and errors avoided. A2X starts at US$29 a month per sales channel and Synder at $65 a month on Basic, and both pay for themselves against even a modest bookkeeping rate of $20 to $50 an hour.
Skip the connector when the output is a decision, not an entry. If you are one person with a Shopify store, an Etsy shop, and a Patreon, and what you actually need to know is which of the three is worth another quarter of your time, a journal entry in Xero does not tell you that. Neither does a bank feed. What tells you that is gross, fees, and take-home per platform, side by side, which is a $12 a month problem rather than a $65 a month problem. Plenty of sellers eventually run both, and that is a perfectly reasonable stack: the connector keeps the books clean and the board keeps the decisions honest.
Related reading on the commercial side: the best income tracker apps compared, Etsy bookkeeping software, and accounting software for content creators.
Side by side
Where the boards differ
| What you get | Earnly | Payout reconciliation |
|---|---|---|
| Reconciles payouts across 12 platforms, not one | Yes | Usually per channel |
| Gross -> platform fee -> processing -> take-home per payout | Yes | No |
| Payout calendar with expected pay dates | Yes | No |
| Works for platforms with no reconciliation report | Yes | No |
| Posts journal entries into QuickBooks or Xero | No | Yes |
| Keeps a double-entry ledger | No | Varies |
| Read-only, never touches your money | Yes | Varies |
| Price | From $12/mo | $29 to $65+/mo |
Comparison reflects published pricing and feature descriptions as of August 2026; both products change. Pick the tool that fits how you earn. See what the board looks like on the income tracker homepage, or start with the revenue dashboard.
Questions people actually ask
What is payout reconciliation?
Payout reconciliation is the process of matching each deposit you receive to the individual orders, refunds, and fees that make it up. A payout is a net figure paid in batches on the processor's schedule, while your sales are recorded per order at gross, so the two never match on their own. Reconciliation proves that every dollar of the difference is accounted for.
What is the payment reconciliation process?
The payment reconciliation process is four steps. Take the deposit amount from your bank. Pull the platform report that covers that batch. Sum gross sales, then subtract platform fees, processing, refunds, and any reserve held back. Confirm the result equals the deposit. Anything left over is an unidentified transaction, not rounding, and should be traced before you close the month.
What does payout reconciliation mean in accounting?
In accounting, payout reconciliation means proving that a net bank deposit ties back to gross revenue plus its offsetting expenses. The entry records gross sales as income and platform and processing fees as expenses, rather than recording the deposit itself as income. Done correctly, taxable profit is unchanged but your reported gross matches what the platform reports to the IRS.
How do I get a Shopify payout report?
Shopify publishes two. For a full reconciliation, go to Finance, then Documents, then Payout Reconciliation Report, pick a date range, and export to PDF. For transaction-level detail, go to Settings, then Payments, then View payouts, then View Transactions, choose your range and CSV type, and click Export balance transactions. The CSV arrives by email to you and the store owner.
What is a Shopify payout?
A Shopify payout is a batched transfer of your Shopify Payments balance to your bank account. It covers a window of captured transactions minus processing fees, refunds, chargebacks, and any reserve. In the US the minimum settlement time is 3 business days from the business day after capture, and there is no minimum payout amount, so small balances still transfer.
How do I reconcile Shopify payments in QuickBooks?
You have two paths. Manually, export the payout transactions CSV, record the gross as sales income and the fee column as an expense, then match the resulting net to the bank feed line. Automatically, add a connector such as A2X, from US$29 a month per sales channel, which posts one summarized journal entry per payout split into gross sales, fees, refunds, and sales tax so the entry reconciles against the bank to the penny.
How do I reconcile Shopify payments in Xero?
The method is identical to QuickBooks because the problem is identical. A2X, Link My Books, and Synder all publish Xero integrations that post a per-payout journal entry splitting gross sales from fees, so the entry can be matched directly against the Xero bank statement line. Doing it by hand means exporting the balance transactions CSV and building the split entry yourself each payout.
How long does a Shopify payout take?
In the United States, Shopify Payments settles a minimum of 3 business days from the business day after the transaction is captured, which most sellers experience as 2 to 5 business days end to end. New stores and stores that trigger a risk review can sit longer while funds are held in reserve. There is no minimum payout amount in the US.
Does Stripe have a payout reconciliation report?
Yes. Stripe publishes a payout reconciliation report that matches each payout arriving in your bank account to the batch of charges, refunds, and other balance transactions that settled inside it. It is designed for accounts using automatic payouts. Stripe also publishes a separate balance summary report for period-level starting balance, activity, payouts, and ending balance, and an All Fees report for the expense side.
Can I reconcile payouts from Etsy, Patreon, and YouTube the same way?
Not with the same reports, because those platforms do not publish reconciliation documents. Etsy gives monthly statements, Patreon and Gumroad show a running balance, and YouTube reports through AdSense. The workable method is to record gross per platform, subtract each platform's published deductions, and check the expected net against the deposit when it lands, which is what an income tracker such as Earnly automates across twelve platforms.