Bring the payout in.
Use the beta Shopify connection where it’s enabled for your account, or export the payout report from Shopify admin and import the CSV. Every line item is kept, with a trail back to the source report.
Shopify to
QuickBooks Online.
Shopify settles days of orders into one payout from Shopify Payments. TidyPayouts unpacks it — sales, refunds, processing fees, chargebacks and reserves — and posts one reviewed journal entry that matches the deposit to the penny.
BETA WORKFLOWS✓ Free during beta✓ Review before posting
ShopifyPayout reports
TidyPayoutsBreakdown · mapping · review
QuickBooks OnlineOne journal entry per payoutWHAT’S INSIDE A SHOPIFY PAYOUT.Many orders.
Many orders.
One deposit. No mystery.
Several days of orders often land
in a single payout. Keep them straight.
- ↳Gross salesProduct and shipping revenue for the orders in the payout period.
- ↩Refunds & returnsRefunded orders and restocked lines, with the fees you got back.
- ⚖Shopify Payments feesProcessing fees on charges and refunds — a real cost, in its own account.
- %Sales tax collectedTax Shopify collected on your behalf, mapped to a liability — not income.
- ◎ChargebacksDisputed charges and the fees that come with them, flagged for review.
- ✦AdjustmentsPayout corrections and fee reversals, so every period reconciles.
- ≋ReservesPayment holds that roll into a later payout, tracked until released.
- ◫Gift card & other salesGift card activity and other payout lines, each with its own mapping.
FOUR STEPS. EVERY PAYOUT.From payout to
From payout to
journal entry, in order.
Set it up once.
Then it’s just review and post.
Give every line an account.
Map each line type to an account in your QuickBooks chart of accounts — gross sales, refunds, processing fees, tax, chargebacks, reserves. Mappings are reusable: set them once, and every future payout follows.
Check it against the deposit.
Resolve unmapped lines, look over chargebacks and adjustments, and compare the net against the deposit that actually arrived. Nothing posts until you approve it.
Send it to QuickBooks.
One balanced journal entry, dated the payout’s deposit date, nets to the penny of your bank feed. Reversible and re-postable if you change a mapping later.
WHAT LANDS IN YOUR BOOKS.One entry.
One entry.
Every dollar explained.
Your P&L shows real store margins —
after processing fees, not before.
Example: a $5,790.75 payout
ILLUSTRATIVE · SAMPLE DATA| Account (as you mapped it) | Debit | Credit |
|---|---|---|
| Checking account the deposit itself | $5,790.75 | |
| Refunds & returns refunded orders | $212.40 | |
| Payment processing fees Shopify Payments | $176.85 | |
| Sales — online store product and shipping revenue | $6,180.00 | |
| Totals | $6,180.00 | $6,180.00 |
One journal entry per payout, dated the deposit date. The entry nets to $5,790.75 — the amount that hit the bank — so QuickBooks’ bank feed matches without manual reconciling. Sales tax, chargebacks and reserves, when present, get their own mapped lines. Made a mistake or changed a mapping? Entries can be reversed and re-posted without losing the trail back to the source report.
THE SETUP GUIDE.Set it up in
Set it up in
an afternoon.
Most of this is one-time work.
After that, a payout takes minutes.
Create your TidyPayouts account
Join the free beta with your email — no credit card, every plan is free while we’re in beta.
Connect QuickBooks Online
In the app, go to
Settings → Account settingsand connect QuickBooks with your Intuit login. Owner access in TidyPayouts is required, and the connection syncs your chart of accounts so mapping uses your real account names. Availability is rolling out during beta; check connection status inside the app.Bring in your Shopify payouts
Where the Shopify connection is enabled for your account, payouts arrive on their own. Otherwise, in Shopify admin go to
Settings → Payments → View payoutsand export the payout summary or transactions as CSV, then import it. Import one payout at a time or a date range — each payout becomes its own review.Map your line types
Assign each payout line type — gross sales, refunds, processing fees, sales tax, chargebacks, reserves — to an account. Sensible defaults get you most of the way; adjust anything to match your chart.
Review the payout
Compare the net against the actual deposit, look over chargebacks and adjustments, and add product costs if you track COGS. Unmapped lines are held out (and clearly listed) rather than guessed into an account.
Post, then match the deposit
Send the journal entry to QuickBooks, then match the deposit in your bank feed. Done — on to the next payout, with the whole trail kept for review.
Is the Shopify to QuickBooks connection available now?+
Both connections are part of the beta and availability is rolling out by account. Meanwhile you can import Shopify payout CSVs directly, and post to QuickBooks as soon as the connection is offered to you. Check connection status inside the app before relying on a live import or post.
Does TidyPayouts post per order or per payout?+
Per payout. Shopify settles many orders into one deposit, so the books stay aligned with your bank: one balanced journal entry per payout, dated the deposit date, with sales, refunds, fees and taxes on their own lines. Order and SKU detail stays in your workspace for margins and product costs.
How do I export my Shopify payouts?+
In Shopify admin, go to Settings → Payments and open View payouts. Export the payout summary or transactions for the period you need as CSV, then import it into TidyPayouts. Each payout is broken down into sales, refunds, processing fees, chargebacks, reserves and more.
What happens to sales tax Shopify collects?+
Where Shopify calculates and collects sales tax on your behalf, the tax is imported as its own line and mapped to a sales tax liability account — never to income. What you still owe to remit is what the liability account shows.
Can my bookkeeper double-check before anything posts?+
Yes — that’s the point. Summaries, mappings and source records are all reviewable, and nothing posts until someone approves it. If a posted entry needs to change, it’s reversed and re-posted rather than edited behind the scenes.
OTHER CHANNELS, SAME IDEA.More pairs,
More pairs,
same tidy path.
Bring every channel into the same
QuickBooks workflow.
Amazon to QuickBooks
Settlement flat files or the beta connection: referral and FBA fees, storage, advertising, reserves.
Read the Amazon guide →
eBay to QuickBooks
Final value fees, Promoted Listings, labels and dispute holds from Seller Hub CSVs.
Read the eBay guide →
Etsy to QuickBooks
Listing, transaction and processing fees, Offsite Ads and the tax Etsy collects.
Read the Etsy guide →
Walmart to QuickBooks
Referral and WFS fees, returns, adjustments and chargebacks from Seller Center.
Read the Walmart guide →Your payouts,
already sorted.
The next payout doesn’t have to be a mystery deposit.
Start your free beta →Free during beta. No credit card. A little more breathing room.