A Shopify payout is not a sales figure and it should never be categorised as one. It is a net transfer: gross orders, minus discounts, plus shipping charged to the customer, plus sales tax you collected, minus refunds, minus processing fees, minus any chargebacks or adjustments that happened to settle in the same window. Accept the bank feed’s suggestion to book that transfer as income and you have understated revenue, buried the processing fee, and turned money you owe a state into money you think you earned.
The other half of the problem is timing. A payout period does not line up with a calendar month, so the deposit that lands on the third of October contains orders placed in September. Post it on the deposit date and September’s revenue walks into October. Post it twice, once from the order data and once from the bank deposit, and you have double counted the whole thing, which is the specific error this post is named after.
Both problems have the same fix and it is a single technique: a clearing account. This post shows the clearing account method with a balanced worked example you can check on a calculator, how to split a payout across a month end, how to handle multiple gateways, and where the sales tax and gift card traps sit. It assumes QuickBooks Online, but the logic is identical in any double entry ledger.
Everything here is general information about bookkeeping practice and none of it is tax or accounting advice. Confirm the treatment with your own accountant before you rely on it, because your entity, your states and your registrations change the answers.
How this site is paid: the QuickBooks links below are monetised affiliate links and Intuit pays us if you buy through one. The other tools mentioned differ. The Synder and Finaloop links are also monetised and pay us. The A2X link is a plain link with no tracking on it and earns us nothing. Link My Books is linked directly to its own site because we have no arrangement with that company at all. The Shopify, Bizee and Hiscox links in the closing section are affiliate links too and they pay us.
Why the payout number is the wrong number
The bank feed shows you one figure. That figure is what Shopify moved, after Shopify already subtracted what it was owed. Everything Shopify subtracted is a real business expense that has to appear somewhere in your accounts, and everything it added on top of your product price is either income or a liability, not revenue.
Take that apart and there are at least six distinct things buried inside a single deposit. Gross product sales are revenue. Shipping charged to the customer is revenue, usually posted to its own income account so you can compare it against what shipping actually cost you. Discounts are contra revenue and belong on their own line, because a discount is not a lower price, it is a price you gave away and should be able to measure. Refunds are contra revenue for the same reason. Payment processing fees are an operating expense. Sales tax collected is a liability until you remit it, unless a marketplace facilitator rule moves that obligation somewhere else.
Book the net figure as income and all six collapse into one number that is none of them. The profit and loss looks superficially reasonable, because the missing revenue and the missing expense roughly cancel, which is precisely why sellers run this way for a year without noticing. What you lose is every ratio worth having. Gross margin, processing cost as a percentage of sales, discount leakage, refund rate. All of them require the components, and the components are what you threw away.
What I could not verify, stated plainly
I tried to fetch Shopify’s own help documentation on payouts and payout schedules for this post, at several URLs, and none of the pages returned any payout content to an automated reader. So this post prints no Shopify payout schedule, no payout timing, and no Shopify Payments processing rate. I am not going to publish a percentage I could not read off Shopify’s own page.
That is not a problem for the method, because the method does not need a rate. You read the fee total straight off your own payout report, which is authoritative for your account in a way that a published rate card never is anyway. Open your Shopify admin, find the payout, and use the numbers on it. If you want the schedule and the rate, get them from Shopify support or your own payouts page rather than from any blog, including this one.
A worked payout, with the arithmetic shown
These are illustrative figures I chose to demonstrate the structure. They are not from any real store and yours will look different. What matters is that the entry balances and that every component has its own home.
| Line on the payout report | Amount | What it is |
|---|---|---|
| Gross product sales | $10,000.00 | Revenue |
| Discounts applied | ($500.00) | Contra revenue |
| Shipping charged to customers | $420.00 | Revenue |
| Sales tax collected | $780.00 | Liability |
| Refunds issued | ($300.00) | Contra revenue |
| Payment processing fees | ($318.00) | Expense |
| Net payout to your bank | $10,082.00 | Cash movement only |
Work it through. Ten thousand, less five hundred of discounts, is $9,500. Add $420 of shipping to get $9,920. Add $780 of sales tax to get $10,700. Take off $300 of refunds to get $10,400. Take off $318 of fees and you land on the $10,082 that hit the bank. Every step is visible and every step is a different account.
Now notice the damage a single categorisation does. Booking $10,082 as sales overstates nothing and understates a lot: true gross product sales were $10,000, shipping income was $420, and $780 of that deposit was never yours in the first place. It also hides $318 of processing cost, $500 of discount and $300 of refunds. Four separate management numbers, gone.
This method needs a real double entry ledger
QuickBooks Online lists Simple Start at $38 a month, Essentials at $85, Plus at $140 and Advanced at $340, each carrying 50 percent off for three months. At list that is $456, $1,020, $1,680 and $4,080 a year in steady state. Journal entries and clearing accounts work on every tier including Simple Start, so you do not need to buy up for the technique in this post. Verify current pricing on the page before you commit.
The clearing account method, step by step
Create one current asset account in your chart of accounts. Call it Shopify Clearing. Some people call it Shopify Undeposited Funds, which is fine as long as you do not use QuickBooks’ own built in Undeposited Funds account for it, because that account has other jobs and you want this balance isolated.
The method has exactly two entries per payout and they happen at different moments.
Entry one, on the sales side. Record what the store actually did, with the balancing figure going into Shopify Clearing rather than into the bank.
| Account | Debit | Credit |
|---|---|---|
| Shopify Clearing | $10,082.00 | |
| Discounts given, contra revenue | $500.00 | |
| Refunds and returns, contra revenue | $300.00 | |
| Payment processing fees | $318.00 | |
| Product sales | $10,000.00 | |
| Shipping income | $420.00 | |
| Sales tax payable | $780.00 | |
| Totals | $11,200.00 | $11,200.00 |
Entry two, when the money arrives. This one is trivial and it is the only entry that touches the bank.
| Account | Debit | Credit |
|---|---|---|
| Business checking account | $10,082.00 | |
| Shopify Clearing | $10,082.00 |
Shopify Clearing now sits at zero. That zero is the point of the whole exercise. It is a self checking mechanism: if the account does not clear, either you recorded the sales side wrong or the payout contained something you did not account for, and the residual balance is the exact size of your error.
In the QuickBooks banking screen you will now match the incoming deposit against entry two rather than categorising it as income. This is the step people skip. If you categorise the deposit as income while entry one already exists, you have recorded the same sale twice, your revenue doubles, and the clearing account never clears. That is the double counting in the title of this post, and the clearing balance is what tells you it happened.
Splitting a payout across a month end
Say a payout period runs from 28 September to 4 October and the deposit lands on 7 October. Three quarters of that revenue belongs to September and posting it on 7 October puts it in the wrong month.
Split entry one. Post the September portion dated 30 September, post the October portion dated inside October, and let both push their balancing figure into Shopify Clearing. Entry two still happens once, on 7 October, for the full deposit amount.
What you get at 30 September is a Shopify Clearing balance equal to the money Shopify was holding on your behalf at that instant. That is not a plug. That is a genuine receivable and it belongs on your balance sheet. A store that runs this properly can answer the question “how much of my September revenue had not yet reached the bank on the last day of the month” from the balance sheet, immediately, which is not a question most stores can answer at all.
The split needs the order level detail, which you get from a Shopify sales report filtered to the date range rather than from the payout report itself. If splitting by hand every month sounds tedious, that is the honest signal that you have outgrown manual entry, which is the next section.
Multiple gateways, and the trap they set
Shopify Payments is not the only way money reaches you. PayPal, Amazon Pay, Shop Pay Installments and any third party gateway each settle separately, on their own schedules, with their own fee structures, into their own deposits. A store running three gateways gets three streams of deposits that all originate from the same order book.
The trap is obvious once stated and invisible until it bites. If you build entry one from total store sales, you have recorded all the revenue. If you then match three separate gateway deposits against a single clearing entry sized for only one of them, nothing reconciles. Conversely, if you build one entry per gateway from that gateway’s own report, and the reports overlap, you double count.
The clean structure is one clearing account per gateway. Shopify Clearing, PayPal Clearing, Amazon Pay Clearing. Each gets its own entry one built from that gateway’s own payout report, and each gets its own entry two when that gateway’s deposit lands. Each clears to zero independently. It is more accounts and it is far less thinking.
PayPal deserves a specific warning because it is a wallet rather than a pipe. Money can sit in a PayPal balance for weeks, get spent directly out of PayPal on a supplier invoice, and never touch your bank at all. Treat the PayPal balance as a bank account in its own right, with its own reconciliation, rather than pretending it is a clearing account that always empties.
Price the tier you need, not the headline
The advertised QuickBooks price is a three month price. Simple Start at $19 a month becomes $38, which is $399 in year one and $456 every year after. Plus at $70 becomes $140, which is $1,470 then $1,680. Intuit’s inventory page places inventory tracking on Plus and Advanced only, so a store holding stock is looking at the higher number. Intuit does not publish its payment processing rates anywhere, so ask before you sign up.
Sales tax, gift cards and tips
Three items inside a payout are not revenue and get mishandled constantly.
Sales tax collected is money you are holding for a state. It is a liability from the moment you collect it until the moment you remit it. Where a marketplace facilitator rule applies, the obligation may sit with the marketplace rather than with you, in which case the tax should not be on your balance sheet as a liability at all. Which rule applies depends on your states, your nexus and your registrations, and it is exactly the question to take to a CPA rather than to a blog. Do not guess it, and do not assume the treatment that applied last year still applies.
Gift cards are deferred revenue when sold and revenue when redeemed. A store that books gift card sales as income in the month of sale has recognised revenue for goods it has not shipped. The correct entry credits a deferred revenue liability on sale and moves it to product sales on redemption. Unredeemed balances have their own rules that vary by state, which is another CPA question.
Tips, where a store collects them, are usually a liability rather than income, because the money is destined for someone else. If you are collecting tips through Shopify checkout, get the treatment confirmed rather than letting them drop into product sales.
By hand, or pay a connector
The method above is perfectly manageable by hand at low volume. One payout period, one summarised entry, one bank match. Call it twenty minutes if your accounts are already set up. At a weekly payout cadence that is under twenty hours a year.
It stops being manageable when you add gateways, add a marketplace, or start needing month end splits every month. At that point a settlement connector reads the payout report, builds the summarised journal entry, and posts it into your ledger against the clearing account without you keying anything.
| Tool | Published entry price | What that buys | Pays this site |
|---|---|---|---|
| A2X | $29 a month, Mini | Up to 200 orders a month on the Shopify plan, with published steps at $45 for 500, $79 for 2,000 and $115 for 5,000 | No, plain link |
| Synder | $65 a month, Basic | 500 synced transactions a month and 2 integrations, or $52 a month billed yearly | Yes, affiliate |
| Link My Books | Not published as a fixed list | The pricing page runs an interactive calculator keyed to orders and channels rather than showing static tiers | No, no arrangement |
| Finaloop | Not published on the page I could reach | A managed bookkeeping product rather than a connector into a ledger you run | Yes, affiliate |
A2X publishes the clearest ladder for Shopify: $29 a month up to 200 orders, $45 up to 500, $79 up to 2,000, $115 up to 5,000 and $159 up to 10,000, with published steps continuing to $1,499 for 250,000 orders a month. Synder runs $65, $129, $299 and $599 a month, or $52, $103, $240 and $480 billed annually, against transaction ceilings of 500, 3,000, 20,000 and 40,000. Link My Books runs a calculator rather than a static price list, so no figure for it appears here.
The test is the same as always. A2X Mini at $29 a month is $348 a year. If manual payout entry costs you two hours a month, that is 24 hours a year and $14.50 an hour of your time. Almost nobody’s hour is worth less than that. Higher up the ladder the calculation reverses, and at the point where you are paying four figures a month for a connector you are already big enough to have a bookkeeper doing the judgement work the connector cannot.
Which QuickBooks plan this needs
None of the technique in this post is gated. Journal entries, clearing accounts and bank matching all work on QuickBooks Online Simple Start at $38 a month, which is $399 in year one with the three month discount and $456 a year in steady state. If somebody tells you that reconciling payouts requires Plus, they are wrong about the ledger and probably thinking about inventory.
Inventory is the actual gate. Intuit’s inventory page states that inventory tracking is available in QuickBooks Online Plus and QuickBooks Online Advanced, which puts the entry point at $140 a month at list, $1,470 in year one and $1,680 a year after that. A store holding stock generally needs it and a store that never touches a unit generally does not. Every tier is costed for year one and year two in the full breakdown of what QuickBooks actually costs across both years.
If you have not built the chart of accounts yet, do that before you connect anything, because connecting a channel to a chart of accounts that is not ready produces months of recategorisation. The correct sequence is in the guide to setting up QuickBooks for an ecommerce store in the order that prevents rework. For the wider ranking of ledgers aimed at stores that hold stock, see the best accounting software for ecommerce ranked by where inventory starts.
Running the business behind the books
Clean payout reconciliation tells you the truth about the store. It does not improve the store. Once the processing fee and the discount leakage are visible on their own lines, you may not like what they say, and the answer to that is upstream in what you sell and what you charge for it.
If you are choosing what to sell, start from the list of profitable high ticket niches and look for categories where a single order covers a month of software and processing.
A higher average order value changes every ratio in this post, and the reason it does is worth understanding before you commit to a category. I explain it in the guide to how the high ticket dropshipping model works.
Margin is decided in the supplier conversation more than anywhere else, so work through the complete step by step supplier sourcing guide before you accept anybody’s opening price list.
Set the entity up properly early, because it determines how these accounts are structured and what your accountant needs from you at year end. The walkthrough is in my guide to business formation for high ticket dropshipping.
For the stack, Shopify runs the storefront because its connector ecosystem into accounting tools is the deepest available. Company formation and registered agent filings go through Bizee.
General liability cover comes from Hiscox, which suppliers will often ask to see before they open a dealer account.
Frequently Asked Questions
Can I just categorise the Shopify deposit as income in the bank feed? No. The deposit is net of processing fees, discounts and refunds, and it includes sales tax that is not yours. Categorising it as income understates revenue, hides the fee, and treats a liability as earnings.
What exactly is a clearing account? A current asset account that holds money owed to you between the moment a sale happens and the moment cash reaches your bank. You post sales into it and post the deposit out of it. When it reaches zero, the payout is fully accounted for.
Why does my clearing account not go to zero? Because something in the payout was not recorded, or was recorded at the wrong amount. The remaining balance is exactly the size of the discrepancy, which usually makes it easy to find. Common culprits are a chargeback, a Shopify Capital repayment, an app fee or a currency adjustment.
Do I need a separate clearing account for PayPal? Yes, and treat the PayPal balance itself as a bank account rather than a clearing account, because money can sit there and be spent from there without ever reaching your checking account.
Where does sales tax go? To a liability account, not to income, for as long as the obligation to remit is yours. Where a marketplace facilitator rule shifts the obligation, the treatment changes. Confirm which applies to you with a CPA or the relevant state authority.
Does QuickBooks do this automatically? Not from a raw payout. Either you key the summarised journal entry or a connector such as A2X or Synder builds and posts it for you. The clearing account is required either way.
Is any of this tax advice? No. It is general information about bookkeeping practice. Sales tax, gift card breakage and tip handling all depend on facts specific to your business and your states. Confirm with your own accountant.
Bottom Line
A Shopify payout is a net transfer and treating it as a sales figure destroys four management numbers at once: your gross revenue, your discount leakage, your refund rate and your cost of processing. On the worked payout in this post, booking the $10,082 deposit as income would have hidden $318 of processing cost, $500 of discounts, $300 of refunds, and $780 of sales tax that was never yours.
The whole fix is one clearing account and two entries. Entry one records what the store did and pushes the balancing figure into clearing. Entry two records the deposit and empties clearing. If clearing does not reach zero, the leftover is the exact size of what you missed, and that self checking property is worth more than any feature on a pricing page. Split the entry at the month boundary when a payout straddles one, give every gateway its own clearing account, and buy a connector the moment the hours it saves are worth more than it costs.
Set the ledger up once and stop guessing
QuickBooks Online lists Simple Start at $38, Essentials at $85, Plus at $140 and Advanced at $340 a month, with 50 percent off for three months. Year one works out to $399, $892.50, $1,470 and $3,570, and every year after that to $456, $1,020, $1,680 and $4,080. The clearing account method in this post runs on the cheapest tier, so buy up only if you genuinely need inventory or extra seats.
If you would rather have the entire store built, sourced and launched for you rather than assembling the stack piece by piece, that is exactly what my done for you high ticket dropshipping build and launch service does.
Related Articles
How to Do Accounting for Amazon Settlement Reports Without Booking the Deposit as Revenue
QuickBooks vs Bench 2026: Software You Run or Bookkeeping Someone Else Does
How to Set Up QuickBooks for an Ecommerce Store: The Order That Prevents Rework
QuickBooks Pricing 2026: Every Plan Costed for Year One and Year Two
How to File Taxes as an Ecommerce Seller: 2026 Step by Step Guide
Trevor Fenner is an ecommerce entrepreneur and the founder of Ecommerce Paradise, a platform focused on helping entrepreneurs build and scale profitable high-ticket ecommerce and dropshipping businesses. With over a decade of hands-on experience, Trevor specializes in high-ticket dropshipping strategy, niche and product selection, supplier recruiting and onboarding, Google & Bing Shopping ads, ecommerce SEO, and systems-driven automation and scaling. Through Ecommerce Paradise, he provides free education via in-depth guides like How to Start High-Ticket Dropshipping, advanced training through the High-Ticket Dropshipping Masterclass, and fully done-for-you turnkey ecommerce services for entrepreneurs who want a faster, more hands-off path to growth. Trevor is known for emphasizing sustainable, real-world ecommerce models over hype-driven tactics, helping store owners build scalable, sellable, and location-independent brands.
Still deciding what to sell?
Grab the free list of 1,000+ niches that work for high-ticket dropshipping, sorted by category.
Free. Unsubscribe any time.
