To reconcile Stripe payouts in QuickBooks Online, post gross sales, fees, refunds and reserves to a Stripe clearing account, then match each bank deposit to the payout that clears it. The same clearing-account method works for Shopify Payments and Amazon settlements. After every payout, the clearing balance should equal the money still in transit, and nothing else.
Why do payouts never match sales?
A processor payout is a net figure. Stripe deducts its processing fee from each charge, subtracts refunds and disputes, holds any reserve, and pays out what is left on a rolling schedule.
Standard US card pricing is 2.9% plus 30 cents per successful charge (Stripe, 2026). A $100 sale arrives as $96.80, and a day with ten sales and one refund arrives as something that matches nothing on the sales report.
Timing adds a second layer. Stripe pays out on a rolling basis, with US accounts commonly receiving funds two business days after the charge, and you can set daily, weekly or monthly schedules (Stripe, 2026). A payout therefore covers charges from a window, not a calendar day, and a month-end payout includes charges from the previous month.
Shopify Payments and Amazon work the same way with different labels. Shopify nets transaction fees and refunds from each payout.
Amazon settles on a cycle, typically every 14 days, and nets referral fees, FBA fees, advertising, refunds and reserves in one statement (Amazon Seller Central, 2026). Recording the deposit as income in all three cases understates sales, hides fees and makes sales tax wrong.
What is the clearing-account method?
A clearing account is a bank-type account in your ledger that stands in for the processor’s balance. Sales go in gross.
Fees, refunds, disputes and reserves come out. Each payout is a transfer from the clearing account to the real bank account, and that transfer matches the deposit in the bank feed.
The method works because it separates two questions. The first is whether the sales, fees and refunds for a period are recorded correctly, which you check against the processor’s reports.
The second is whether the money arrived, which you check against the bank statement. Booking the deposit as income mixes the two and answers neither.
The control is the clearing balance itself. After the last payout of the month, the balance should equal the charges the processor has taken but not yet paid out, plus any reserve.
Stripe, Shopify and Amazon each report that in-transit or unavailable balance, so the check takes a minute. A balance that grows month after month means something is not being posted.
How do you reconcile Stripe payouts in QuickBooks Online?
Set up one clearing account per Stripe account, as a bank-type account named Stripe clearing. Add income accounts for Stripe sales, an expense account for Stripe fees, and a contra-income or expense account for refunds and disputes. Then follow the steps for each payout or each month.
- Pull the payout reconciliation report from the Stripe dashboard for the period. It lists, per payout, the gross charges, fees, refunds, disputes and adjustments that make up the net amount (Stripe, 2026).
- Post a journal entry or a sales receipt for the gross charges to Stripe sales, with the clearing account as the deposit account. Split sales tax collected to the tax liability account if Stripe Tax or your invoicing tool charges it.
- Post fees as an expense paid from the clearing account. Post refunds and disputes as reductions of sales, paid from the clearing account, with dispute fees as an expense.
- Record each payout as a transfer from Stripe clearing to the bank account, dated the payout date. In the bank feed, match the deposit to that transfer rather than adding it as income.
- At month-end, compare the clearing balance with Stripe’s pending and in-transit balance. They should agree to the cent.
If you invoice customers through QuickBooks Online and they pay by Stripe, record the payment against the invoice with Stripe clearing as the deposit account. The fee then posts separately, and the customer’s balance shows paid in full. Our Stripe software page lists the QuickBooks Online and Xero setups we support.
How do you reconcile Shopify payouts?
Shopify Payments pays out the net of orders processed through it, and the payout detail report in the Shopify admin shows each payout with charges, refunds, adjustments and fees (Shopify, 2026). Orders paid through PayPal, Amazon Pay or other gateways are not in the payout, so each gateway needs its own clearing account.
For each payout, post gross sales, discounts, shipping collected, sales tax collected and refunds to the Shopify clearing account. Post Shopify Payments fees as an expense.
Transfer the net to the bank and match it to the deposit. Sales tax collected goes to the liability account, not to income, so the sales-tax return can be prepared from the ledger.
Gift cards, tips and multi-currency orders need care. A gift card sale is a liability until redeemed, tips are usually a pass-through to staff, and a currency conversion shows up as a difference between the order total and the payout amount.
Post the difference to a currency gain or loss account rather than forcing it into fees. The Shopify software page covers the ledger setup for each.
How do you reconcile Amazon settlements?
Amazon pays sellers on a settlement cycle, typically every 14 days, and each settlement report lists the transactions that make up the deposit: product sales, shipping and gift wrap credits, promotional rebates, refunds, referral fees, FBA fulfillment and storage fees, advertising charges, and reserve amounts held or released (Amazon Seller Central, 2026). The deposit is the net of all of it.
Post each category to the Amazon clearing account for the settlement period. Sales, shipping and promotions go to income accounts; referral, FBA, storage and advertising fees go to their own expense accounts, because each answers a different question about margin. Refunds reduce sales, and refunded referral fees reduce fees.
Reserves are the part most sellers get wrong. Amazon holds a portion of the balance for a period after delivery, and the settlement shows a beginning reserve released and an ending reserve held.
Record the ending reserve as a receivable from Amazon, not as a fee, so the balance sheet shows money you are owed. Sales tax collected by Amazon under marketplace facilitator rules is remitted by Amazon in most US states, so record it as collected and remitted by the marketplace, not as your liability. The Amazon Seller Central software page covers the setup.
How do you handle fees, refunds, disputes and reserves?
The table summarizes how each item behaves at the three processors and where it posts in the ledger.
| Item | Stripe | Shopify Payments | Amazon | Where it posts |
|---|---|---|---|---|
| Processing fee | 2.9% plus 30 cents per successful US card charge; deducted per charge (Stripe, 2026) | Rate varies by plan; deducted per payout (Shopify, 2026) | Referral fee by category plus FBA and storage fees (Amazon, 2026) | Fee expense accounts, paid from clearing |
| Refund | Original fee is not returned (Stripe, 2026) | Original transaction fee is not returned (Shopify, 2026) | Referral fee partly refunded; refund administration fee retained | Refunds contra-income, paid from clearing |
| Dispute or chargeback | $15 dispute fee in the US; amount debited when the dispute opens (Stripe, 2026) | Chargeback fee applies; amount held during the dispute (Shopify, 2026) | A-to-z claims debited in the settlement | Disputes contra-income; fee to expense |
| Reserve or hold | Applied to some accounts; shown as pending balance | Holds shown in payout status | Ending reserve held each settlement; released next cycle | Receivable from processor |
| Sales tax collected | Passed through if Stripe Tax or your invoice charges it | Collected on orders; you remit | Collected and remitted by Amazon under marketplace facilitator rules in most US states | Tax liability, or marketplace-remitted memo account |
| Currency conversion | Converted at payout with a conversion fee | Converted at payout | Converted at disbursement | Currency gain or loss |
| Payout | Rolling schedule; commonly two business days for US accounts | Rolling schedule by region | Typically every 14 days | Transfer from clearing to bank |
Two rules keep the table honest. Never post a net figure when the processor gives you the gross and the deductions, and never post a difference to fees just to make the payout tie. A difference is a missing line, and the processor report will show which.
Should you use A2X, Link My Books or a manual summary?
Below a few hundred orders a month on one channel in one country, a manual summary works. Pull the payout or settlement report, post one journal per payout or one per month, and match the transfers. The work takes an hour or two a month and the control is the clearing balance.
Above that volume, or with more than one channel, currency or tax jurisdiction, a summary tool pays for itself. A2X and Link My Books read each payout or settlement from Stripe, Shopify, Amazon and other channels and post one summary journal to QuickBooks Online or Xero with sales, fees, refunds, tax and reserves split to the right accounts. The bank deposit then matches the journal to the cent.
The tool does not remove the reconciliation. It removes the posting.
Someone still has to confirm the clearing balance each month, chase the items the tool flags and check that the tax mapping is right after every product or region change. Our A2X cleanup guide covers the mapping errors we see most often.
How do you know the reconciliation is right?
Run four checks at month-end. First, the clearing balance equals the processor’s pending or unavailable balance plus any reserve. Second, gross sales in the ledger for the month equal gross sales on the processor’s report for the same period, allowing for the timing window at the start and end.
Third, every payout in the processor’s report has a matching transfer in the ledger, and every transfer has a matching bank deposit. A payout with no deposit is money in transit or a failed payout; a deposit with no payout is a payment from somewhere else.
Fourth, fees in the ledger equal fees on the processor’s report. If the fee line is the plug, the reconciliation is not done.
Keep an exception log. Every item that did not tie, why, and what was done about it. The log is what a reviewer, a preparer or a lender reads to trust the number, and it is what makes next month faster.
How does LedgerBPO handle payout reconciliation?
Our payment-processor reconciliation service runs the clearing-account method inside your own QuickBooks Online or Xero file, with or without A2X or Link My Books. The work runs through our ReconBot process: a payout-matching workflow that posts each payout, matches it to the bank and logs every exception with its cause and fix.
A named accountant does the posting and matching, a named backup covers absence, and a team lead reviews each close through our Two-Tier Review before reports go out. Sales-tax and VAT workings are prepared from the ledger for your preparer; for US clients, tax work is preparation support: your firm reviews and signs. Pricing depends on volume and scope, so we send a custom quote within 1 business day.
If your clearing accounts have been growing for months, the first job is a cleanup rather than a routine. Send us the last payout report from each processor and the current clearing balances, and we will scope the catch-up before monthly reconciliation starts.
Sources
- Stripe Docs, Receive payouts: docs.stripe.com
- Stripe Docs, Refunds: docs.stripe.com
- Stripe Docs, Disputes: docs.stripe.com
- Stripe, Pricing: stripe.com
- Shopify Help Center, Shopify Payments payouts: help.shopify.com
- Amazon Seller Central, Payments and settlement reports: sellercentral.amazon.com
- A2X, ecommerce accounting: a2xaccounting.com
- QuickBooks Online support, bank transfers and reconciliation: quickbooks.intuit.com
Frequently asked questions
How do I reconcile Stripe payouts in QuickBooks Online?
Create a Stripe clearing account as a bank-type account, post gross sales, Stripe fees and refunds to it for each payout period, and record each payout as a transfer from the clearing account to your bank. Match the transfer to the bank-feed deposit. After each payout, the clearing balance should equal the charges Stripe has not yet paid out. Stripe's payout reconciliation report gives the totals by payout (Stripe, 2026).
Why does my Stripe payout not match my sales?
Because Stripe deducts fees, refunds, disputes and dispute fees before paying out, and because a payout covers charges from a rolling window, not a calendar day. Standard US card pricing is 2.9% plus 30 cents per successful charge, refunds do not return the original fee, and a lost dispute costs a $15 fee (Stripe, 2026). Post each of those lines and the payout matches.
How do I record Shopify payouts in QuickBooks Online or Xero?
Use a Shopify Payments clearing account. For each payout, post gross sales, discounts, shipping collected, sales tax collected, refunds and Shopify Payments fees from the payout detail report, then transfer the net to the bank. Sales through PayPal or other gateways are separate clearing accounts, since Shopify does not pay those out. Shopify Payments keeps the original transaction fee on a refund (Shopify, 2026).
How do I reconcile Amazon settlements?
Amazon pays out on a settlement cycle, typically every 14 days, and the settlement report lists product sales, shipping, promotions, refunds, referral fees, FBA fees, storage fees, advertising and reserves (Amazon Seller Central, 2026). Post each category to an Amazon clearing account for the settlement period, record the reserve as a receivable from Amazon, and transfer the net to the bank. A2X does this posting automatically.
Should I use A2X or Link My Books for payout reconciliation?
Use one of them once you pass a few hundred orders a month or sell in more than one country. Both tools read each payout or settlement and post one summary journal with sales, fees, refunds, tax and reserves split correctly, which removes most of the manual work. Below that volume, a monthly summary from the processor's reports posted by hand is workable. Our A2X software page covers setup.
Does LedgerBPO reconcile Stripe, Shopify and Amazon payouts?
Yes. Our payment-processor reconciliation service runs the clearing-account method inside your own QuickBooks Online or Xero file, through our ReconBot process: a payout-matching workflow with an exception log for every item that does not tie. A named accountant posts and matches, a backup covers, and a team lead reviews each close. Pricing depends on volume and scope, so we send a custom quote within 1 business day.
Sources
- Stripe Docs, Receive payouts
- Stripe Docs, Refunds and fees
- Stripe Docs, Disputes and fraud
- Stripe, Pricing (standard US card processing)
- Shopify Help Center, Shopify Payments payouts
- Amazon Seller Central, Payments and settlement reports
- A2X, ecommerce accounting for Amazon, Shopify and other channels
- QuickBooks Online support, bank transfers and reconciliation
