05/22/2026
Setting up a clearing account for an e-commerce platform like
Shopify is the gold standard for keeping your bookkeeping clean. It acts as a temporary holding tank for money that has been processed but hasn’t landed in your actual bank account yet.
Here is exactly how to set up the architecture and handle the routine workflow in your accounting software.
1. The Initial Setup First, you need to create the account itself on your Chart of Accounts. Account Type: Bank or Credit Card (Bank is preferred). Name: Shopify Clearing (or "Shopify Holding Account"). Detail Type: Checking or Cash on Hand. Starting Balance: $0. Why set it up as a Bank account?
Even though it isn't a physical bank, your bookkeeping software needs to treat it like one so you can easily transfer money out of it and into your real operating bank account.
2. The Routine WorkflowEvery time Shopify processes a batch of orders, a three-step movement of money occurs. To avoid duplicating income or burying fees, handle them sequentially:
1.Record Gross Sales and Fees: From Shopify Reports. Do not use your bank feed for this step. Look at your Shopify payout or finances report. Create a Journal Entry or a Sales Receipt dated to match the sales period. Debit Shopify Clearing for the Gross Sales (including collected shipping and sales tax).Credit Sales Revenue for the product totals. Credit Sales Tax Payable for the tax collected. Debit Merchant Service Fees (an expense account) for the Shopify processing fees deducted from that batch.
2.Match the Actual Bank Payout: In the Bank Feed. When the net cash deposit finally hits your physical business checking account, it will show up on your bank feed. Do not categorize this as sales income. Instead, record it as a Transfer from your Shopify Clearing account into your checking account.
3.Account for Adjustments: Refunds & Chargebacks. If there were customer returns, Shopify will deduct them from your payouts. Record these via a Journal Entry or Refund Receipt:
Credit Shopify Clearing for the total amount sent back to customers.
Debit Refunds/Returns (or Sales directly) to reduce your revenue.
