Shopify Bookkeeping: From Gross Sales to the Bank Deposit
Why the deposit from the payment processor is not your revenue, how to record fees, refunds, sales tax, and gift cards, and how to keep the books reconciled across channels.
Reviewed by the Fairlight Accounting cross-border tax team — U.S. & Canadian Tax Desks
The money that lands in the bank from Shopify Payments is gross sales minus processing fees, refunds, and chargebacks. Booking the deposit as revenue understates sales, loses the fee deduction, and buries the sales tax liability. Tax-ready e-commerce books start from the platform's sales report and reconcile it to the payout every month.
On this page
How does a payout break down?
| Component | Where it belongs |
|---|---|
| Gross product sales | Revenue |
| Shipping charged to customers | Revenue (shipping paid out is an expense) |
| Discounts and returns | Contra revenue |
| Sales tax collected | Liability until remitted — never revenue |
| Shopify Payments processing fees | Expense |
| Platform subscription and app fees | Expense (often billed separately) |
| Chargebacks and chargeback fees | Contra revenue and expense |
| Gift cards sold | Liability until redeemed |
| Net payout | Cash — the only line the bank shows |
An integration that posts summarized daily or weekly sales journal entries, split into these components, keeps the books accurate without recording thousands of orders individually.
How are multiple channels handled?
Each channel — Shopify, Amazon, Etsy, a wholesale account, in-person sales — has its own settlement report and fee structure, and marketplaces such as Amazon and Etsy generally collect and remit sales tax themselves under state marketplace facilitator laws. Record each channel's gross sales, fees, and taxes separately, reconcile each payout to its report, and keep marketplace-collected tax out of your own sales tax liability. Inventory sold across channels must reduce one inventory balance.
What about inventory and cost of goods sold?
Purchases go to inventory, not expense; cost of goods sold is recorded as items sell (or at period-end from a count). Landed cost — product, freight-in, duties, and tariffs — belongs in inventory. Small business taxpayers — average annual gross receipts of $32 million or less for the three prior years (the 2026 threshold) — can use simplified inventory methods for tax and are exempt from the uniform capitalization rules, but the books still need a defensible cost per unit.
What reporting arrives in January?
Shopify Payments, other processors, and marketplaces issue Form 1099-K reporting gross payment volume — card payments are reportable at any amount, while payment apps and online marketplaces must report only when a seller's payments exceed $20,000 and 200 transactions for the year (the threshold P.L. 119-21 restored retroactively), though they may report lower amounts. The business's revenue should reconcile to the total of all 1099-Ks plus sales settled outside card processing, with fees, refunds, and tax collected explaining the difference. A return that reports net deposits as sales will not match.
What is the monthly close?
Post the sales summaries for each channel; reconcile each payout to the bank; reconcile the sales tax liability to the amounts collected by state and remit; count or roll forward inventory and post cost of goods sold; record gift card sales and redemptions; and review the margin by channel. Thirty minutes a month beats a January reconstruction.
Frequently asked questions
Is the Shopify sales report enough for my tax return?
It is the starting point; the books must reconcile it to the bank and to the 1099-K.
Do I record each order in my accounting software?
No. Summarized journal entries by day or payout are standard; order-level detail stays in the platform.
How do I handle sales to customers in other countries?
Record in dollars at the processor's conversion; the exchange difference is part of revenue or fees as the processor reports it. Value-added tax that a marketplace collects and remits under the other country's rules is not your liability, but selling directly from your own store can require you to register for and charge that country's value-added tax.
Does Amazon FBA inventory affect anything?
Inventory in fulfillment centers is still your asset — and may create sales tax nexus in those states.
Official sources
The IRS explains: “A payment app or online marketplace is required to send you a Form 1099-K if the payments you received for goods or services total over $20,000 in more than 200 transactions. However, they may send you a Form 1099-K with lower amounts and/or transactions.” — Internal Revenue Service, Understanding your Form 1099-K, https://www.irs.gov/businesses/understanding-your-form-1099-k
The IRS explains: “If you make or buy goods to sell, you can deduct the cost of goods sold from your gross receipts on Schedule C (Form 1040). However, to determine these costs, you must value your inventory at the beginning and end of each tax year.” — Internal Revenue Service, Publication 334 (2025), Tax Guide for Small Business, https://www.irs.gov/publications/p334
Next step
Fairlight Accounting handles U.S. domestic, cross-border (U.S.–Canada), and international tax returns, plus bookkeeping, payroll, and CFO advisory. Our bookkeeping team connects each sales channel and reconciles every payout to the bank monthly. See pricing or book a free fit call.
Cross-border taxes, handled in one place
U.S. and Canadian filings prepared together by our U.S. and Canadian Tax Desks.
Book a free fit call