<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=984096836450318&amp;ev=PageView&amp;noscript=1">
Limited Offer Get 50% OFF on all plans and guaranteed books today 50% OFF Get guaranteed books today Talk to Sales
Back to all recordings
Your Shopify Deposit Isn’t Your Revenue—Here’s What It Hides
This recording is locked
Fill out the short form below to unlock and watch instantly.
Unlock this recording

Enter your details to watch

By submitting, you agree to receive occasional emails from Webgility. Unsubscribe anytime.

About the author
John May

John May

Customer Engagement, Webgility

Passionate about helping ecommerce businesses get the most out of automation, accounting, and connected commerce.

The Ecommerce Clinic Recording

Your Shopify Deposit Isn’t Your Revenue—Here’s What It Hides

About this session

A Shopify order, bank deposit, and actual revenue can show three different numbers. This Ecom Clinic follows a simulated DTC Shopify order from checkout through processing fees, payout, and a clearing account to show ecommerce operators how the money should move through their books—and why recording a bank deposit directly as sales can distort revenue, expenses, liabilities, and financial visibility.

Key learnings
  • Understand why a Shopify bank deposit is not the same as revenue or profit.
  • Follow the flow of a Shopify order from checkout to payout and reconciliation.
  • Separate product sales, shipping income, sales tax, and processing fees in your books.
  • Use a clearing account to manage the timing gap between sales and bank deposits.
  • Understand why processing fees can disappear from financial reports when deposits are booked directly to sales.
  • Track collected sales tax as a liability, not income.
  • Monitor clearing account balances for unreconciled transactions.
  • Separate shipping income from shipping expenses to understand actual profitability.
  • Record transaction components separately for a more accurate view of revenue and profitability.
Full article

Why Shopify Payout Reconciliation Matters for Accurate Ecommerce Books

A Shopify sale can look straightforward at checkout, but the number a customer pays is not necessarily your revenue, your bank deposit, or your profit. Discounts, shipping charges, sales tax, processing fees, payout timing, and product costs can all change what each number means.

That makes Shopify payout reconciliation an important part of understanding what your ecommerce business actually earned.

Consider the simulated DTC order used in this Ecom Clinic. The merchandise starts at $60. After a $6 discount, product sales are $54. The customer is then charged $6 for shipping and $4.32 in sales tax, bringing the checkout total to $64.32.

But $64.32 does not simply become revenue.

In the example, product sales after the discount contribute $54 of revenue, while the $6 shipping charge is tracked separately as shipping income. The $4.32 collected in sales tax is treated as a liability rather than income. Keeping these amounts separate makes the books more useful for understanding where money came from and what is still owed.

The numbers change again before cash reaches the bank.

The session uses a $2.17 Shopify processing fee and a $62.15 payout to illustrate what happens when fees are deducted before the merchant sees the deposit. It also assumes the sale occurs on November 3 and the payout reaches the bank on November 5, demonstrating the timing gap between the transaction and the cash deposit.

That gap is where a clearing account becomes useful.

A clearing account acts as a temporary holding place between the ecommerce transaction and the corresponding bank activity. In the example, $64.32 enters the clearing account, while the $2.17 fee and $62.15 payout clear it back to zero. A balance moving toward zero indicates that the related activity is being matched. A balance that continues accumulating can signal transactions or reconciliation issues that need investigation.

This process also exposes a common bookkeeping problem: recording the bank deposit directly as sales.

Doing so collapses several types of financial activity into one number. Processing fees can disappear as distinct expenses. Collected sales tax can fail to appear correctly as a liability. Revenue can be misstated. And the business loses the detail needed to understand its actual economics.

Shipping illustrates why that detail matters. When shipping charged to the customer is recorded separately as income, it can later be compared with the actual shipping expense. That helps operators see whether their shipping charges reflect what fulfillment is costing the business.

The larger lesson is simple: a payout tells you how much cash arrived, not the complete financial story behind the sale.

Reliable ecommerce bookkeeping requires capturing and appropriately segmenting the components behind each transaction—sales, shipping, taxes, fees, payouts, and other relevant costs. With a repeatable reconciliation process and properly managed clearing accounts, Shopify sellers can build cleaner financial records and make decisions from a more meaningful view of revenue, expenses, and profitability.

Frequently asked questions
What is Shopify payout reconciliation?

Shopify payout reconciliation is the process of matching ecommerce transaction activity—including sales, shipping, taxes, fees, and payouts—to the corresponding accounting and bank activity so the underlying amounts are properly recorded.

Why doesn’t my Shopify payout equal my sales revenue?

A payout can include money collected for different purposes and may already have processing fees deducted. The webinar example separates product revenue, shipping income, sales tax liability, and processing fees rather than treating the bank deposit as one sales number.

What is a clearing account in Shopify accounting?

A clearing account is a temporary holding account between recorded ecommerce activity and the eventual bank payout. It helps account for timing differences and makes it easier to identify amounts that have not yet reconciled.

Should Shopify sales tax be recorded as revenue?

In the workflow presented in this session, sales tax collected from the customer is recorded as a liability rather than income or expense. The transcript notes that the timing of remittance depends on how the business is set up.

How does Webgility help with Shopify payout reconciliation?
 Webgility helps automate ecommerce accounting by pulling order and expense data from channels such as Shopify into QuickBooks. The session also describes an additional reconciliation service in which Webgility’s accounting team can audit books, flag exceptions, and provide recommendations. 
50+
Channels connected to QuickBooks
One close
Covers every channel, same books
30 min/week
Down from 8 hours, same volume
Same rules
New channels apply existing configuration
The Demo

Find out what your operational gaps are actually costing you.

Our team of experts will help surface your operations and finance concerns. In 30 minutes, we will discuss your channels, accounting setup, leakages, inventory inconsistencies, and close process.

Operational Snapshot ● Live
Orders reconciled today 1,247 ✓
Amazon payout tied out $47,241 ✓
Exceptions resolved 3 cleared
Inventory synced All channels ✓
Books status Certified ✓