Skip to main content

Shopify Accounting: A Complete Guide to Bookkeeping and Taxes for Ecommerce Sellers

· 9 min read
Mike Thrift
Mike Thrift
Marketing Manager

With over 5.6 million live stores and more than $378 billion in global merchandise volume processed in 2025, Shopify has become the backbone of modern ecommerce. But here's the thing most new sellers don't realize until tax season hits: running a Shopify store means running a real business, and that business needs real accounting.

Whether you're dropshipping phone cases or selling handmade ceramics, getting your bookkeeping right from the start saves you from painful surprises later. This guide walks you through everything you need to know about Shopify accounting—from setting up your books to handling multi-state sales tax.

Why Shopify Accounting Is Different from Traditional Bookkeeping

Ecommerce accounting has unique wrinkles that don't exist in a typical brick-and-mortar operation. Understanding these differences early prevents costly mistakes.

Bank Deposits Don't Equal Revenue

This is the single biggest misconception among Shopify sellers. The deposits hitting your bank account are net amounts—your actual sales minus Shopify's transaction fees, payment processing fees, refunds, and chargebacks. If you record bank deposits as revenue, you're understating your true sales and hiding your real cost structure.

For example, if you sell $10,000 worth of product in a month but Shopify deposits $9,200 after fees, your revenue is still $10,000. The $800 difference is an expense that needs to be tracked separately.

Multi-Channel Complexity

Most Shopify sellers don't just sell on their Shopify storefront. They're also on Amazon, Etsy, social media shops, and sometimes wholesale channels. Each platform has its own fee structure, payout schedule, and reporting format. Your accounting system needs to consolidate all of these into a single, accurate picture.

Inventory Timing Matters

Unlike service businesses, ecommerce sellers carry inventory. When you buy $5,000 of product from a supplier, that's not an expense yet—it's an asset on your balance sheet. It only becomes a cost of goods sold (COGS) expense when you actually sell the item. Getting this timing wrong distorts your profit margins and can create tax problems.

Setting Up Your Shopify Accounting Foundation

Before you start tracking transactions, you need the right structure in place.

Separate Your Finances

Open a dedicated business bank account and business credit card. This isn't optional—it's essential. When personal and business expenses are mixed together, you'll spend hours untangling them at tax time, and you risk missing legitimate deductions or, worse, raising red flags with the IRS.

Choose Your Accounting Method

You have two options:

Cash basis records income when you receive payment and expenses when you pay them. It's simpler and works fine for very small stores.

Accrual basis records income when earned and expenses when incurred, regardless of when cash changes hands. This method gives a more accurate picture of your business health and is required by GAAP. If your store generates more than $25 million in annual gross receipts, the IRS requires accrual accounting.

For most growing Shopify stores, accrual accounting is worth the extra effort because it shows your true profitability in each period.

Set Up Your Chart of Accounts

A well-organized chart of accounts is the backbone of your bookkeeping. For a Shopify store, you'll typically need:

Revenue accounts:

  • Product sales
  • Shipping income (if you charge customers for shipping)
  • Refunds and returns (as a contra-revenue account)

Cost of Goods Sold (COGS):

  • Product costs (landed cost including freight and duties)
  • Packaging materials
  • Shipping to customers

Operating expenses:

  • Shopify subscription fees
  • Payment processing fees
  • Marketing and advertising
  • Software and apps
  • Office supplies and equipment
  • Professional services (accounting, legal)

Assets:

  • Inventory
  • Business bank account
  • Accounts receivable

Liabilities:

  • Sales tax payable
  • Accounts payable
  • Credit card balances

Mastering Cost of Goods Sold

COGS is where most Shopify sellers get their numbers wrong, and inaccurate COGS means inaccurate profit margins.

Calculate True Landed Cost

Your cost per unit isn't just what your supplier charges. True landed cost includes:

  • Supplier price per unit
  • Inbound freight (shipping from supplier to your warehouse)
  • Customs duties and tariffs (for international sourcing)
  • Brokerage fees
  • Inspection or quality control costs

If you buy a product for $5 from an overseas supplier, but freight adds $0.80, duties add $0.60, and brokerage adds $0.10, your true landed cost is $6.50—30% higher than the invoice price alone.

Don't Confuse Fees with COGS

Shopify transaction fees, payment processing fees, and app subscription costs are not COGS. They're operating expenses. Recording them as COGS inflates your product costs and hides your true gross profit margin. Keep these categories separate so you can see how much you're actually making on each product before overhead.

Track Inventory Movements

Use a consistent inventory method—FIFO (first in, first out) is the most common for ecommerce. Record inventory purchases as assets, then move costs to COGS when items sell. At minimum, reconcile your physical inventory with your books quarterly.

Sales tax is arguably the most complex part of Shopify accounting, and getting it wrong can result in penalties, interest, and back-tax assessments.

Understand Economic Nexus

Since the 2018 Supreme Court ruling in South Dakota v. Wayfair, states can require online sellers to collect sales tax even without a physical presence. Most states have economic nexus thresholds—typically $100,000 in sales or 200 transactions within the state.

As your Shopify store grows, you'll likely trigger nexus in multiple states. You need to:

  1. Monitor your sales by state to know when you approach thresholds
  2. Register for a sales tax permit in each state where you have nexus
  3. Configure Shopify's tax settings to collect the correct rates
  4. File returns on schedule (monthly, quarterly, or annually depending on the state)

Record Sales Tax Correctly

Sales tax collected from customers is not your income. It's a liability—money you're holding in trust for the state. Record it as:

  • Debit: Cash/Bank Account
  • Credit: Sales Tax Payable (liability)

When you remit the tax to the state:

  • Debit: Sales Tax Payable
  • Credit: Cash/Bank Account

If you've been recording collected sales tax as revenue, you're overstating your income and will owe taxes on money that was never yours.

Consider Automation

With different rates across thousands of jurisdictions, manual sales tax management is impractical for growing stores. Tools like TaxJar, Avalara, or Shopify's built-in tax engine can automate rate calculation, but you still need to handle registration, filing, and remittance.

Monthly Bookkeeping Routine

Consistency beats complexity. Establish a monthly routine and stick to it.

Weekly Tasks

  • Categorize transactions as they come in rather than batching them
  • Review outstanding invoices and follow up on late payments
  • Check inventory levels against your accounting records

Monthly Close Process

  1. Reconcile bank and credit card statements with your accounting records. Every transaction should be accounted for.
  2. Review Shopify payouts against your sales reports. Compare gross sales, fees, refunds, and net deposits.
  3. Update inventory values and record COGS for the period.
  4. Accrue expenses that you've incurred but haven't paid yet.
  5. Review your profit and loss statement to catch any anomalies early.
  6. Set aside money for taxes—a good rule of thumb is 25-30% of net profit for income taxes, plus whatever sales tax you've collected.

Reconciling Shopify Payouts

Shopify's payout reports show net deposits, but your books need the gross numbers. Here's how to reconcile:

Shopify Report LineAccounting Entry
Gross salesRevenue
RefundsContra-revenue
Shopify feesOperating expense
Payment processing feesOperating expense
Net payoutCash received

The net payout should equal gross sales minus refunds minus all fees. If it doesn't, investigate the difference before moving on.

Handling Returns and Refunds

Returns are a normal part of ecommerce—the average return rate for online purchases hovers around 20-30%. Your accounting needs to handle them cleanly.

When a customer returns a product:

  1. Reverse the revenue by debiting your contra-revenue (returns) account
  2. Reverse COGS if the product goes back into sellable inventory
  3. Record any restocking fees as a separate revenue line
  4. Write off damaged returns as a loss if items can't be resold

Track your return rate by product and channel. A high return rate on a specific product might mean you need to improve your product description, sizing guide, or quality control—not just adjust your books.

Common Shopify Accounting Mistakes to Avoid

Recording Deposits as Revenue

We covered this above, but it bears repeating: your bank deposits are not your revenue. Always start from gross sales and work down.

Ignoring Shopify's Payout Timing

Shopify typically takes two business days to process payouts. Sales made on December 30th might not hit your bank until January 2nd. Under accrual accounting, those sales belong in December. Record revenue based on when the sale occurred, not when the money arrives.

Neglecting to Track Transaction Fees

Shopify charges 2.4-2.9% plus $0.30 per transaction on its basic plan. On $100,000 in annual sales, that's roughly $2,700-$3,200 in fees. If you're not tracking these, you're overstating your profit by thousands of dollars.

Forgetting About Shopify Apps

The average Shopify store uses 6-8 paid apps. Those $9.99/month subscriptions add up fast—$720-$960 per year. Treat them as operating expenses and review them regularly to cut any you're not actively using.

Mixing Inventory Purchases with Expenses

Buying inventory is not an expense—it's purchasing an asset. Only record the cost as an expense (COGS) when the inventory is sold. This distinction directly affects your tax liability and profit calculations.

When to Get Professional Help

You can handle basic bookkeeping yourself when you're starting out, but consider hiring an accountant or bookkeeper when:

  • Annual revenue exceeds $100,000 and the complexity of sales tax and inventory tracking becomes significant
  • You sell across multiple states or countries and need to manage nexus obligations
  • You're spending more than a few hours per month on bookkeeping instead of growing your business
  • You're preparing for funding and need clean, professional financial statements
  • Tax season feels overwhelming and you're not confident in your filing accuracy

A good ecommerce accountant pays for themselves by catching errors, maximizing deductions, and freeing up your time to focus on what you do best—selling.

Simplify Your Ecommerce Finances

Managing a Shopify store is exciting, but the accounting behind it doesn't have to be a headache. The key is building good habits early: separate your finances, track costs accurately, stay on top of sales tax, and reconcile your books monthly. Beancount.io offers plain-text accounting that gives you complete transparency over your financial data—every transaction is human-readable, version-controlled, and ready for automation. Get started for free and take control of your ecommerce bookkeeping.