Shopify Accounting and Bookkeeping: A Practical Guide

Last verified: June 2026

Most Shopify sellers hit £200k–£500k in revenue and suddenly realise their "accounting system" is a folder of downloaded CSVs and a spreadsheet their bookkeeper updates once a month. The numbers technically add up. But they don't tell you whether you're actually making money — or which products are quietly eroding your margins. That's the gap this guide fills.

Why Shopify sellers need dedicated accounting systems

Shopify's built-in reports give you sales data, not accounting data. That distinction matters enormously once your operation has any complexity. Sales figures don't account for refunds already processed, platform fees deducted at settlement, merchant cash advance repayments, or the cost of goods you actually sold. A week where Shopify reports £40,000 in sales might be a week where your real net cash inflow is closer to £28,000 once fees, returns, and COGS are stripped out.

This isn't a criticism of Shopify. It's an analytics platform first. The reports it produces — sessions, conversion rates, top products by revenue — are useful for merchandising decisions. But revenue is not profit, and profit is not cash. Those three figures can diverge significantly in any given month. If you're running the business from the revenue line alone, you're flying partially blind.

Formal bookkeeping serves a purpose beyond tax compliance. A proper accrual-basis profit and loss statement tells you what you earned in a period, regardless of when the cash landed. A balance sheet tells you what you own versus what you owe. A cash flow statement tells you whether you can pay your bills next month. None of these exist inside Shopify's dashboard, and none can be built reliably from a payments CSV without a lot of manual work.

For sellers running across multiple channels — Shopify plus Amazon, say, or Shopify plus a wholesale arm — the gap widens further. Each channel has its own settlement cadence, its own fee structure, its own refund logic. Pulling that into a single coherent picture requires an actual accounting system, not a reporting tool. We wrote about this in our complete guide to ecommerce accounting for sellers if you want the broader picture first.

And there's a practical operational angle too. Inventory cost tracking — knowing your COGS at the product level — feeds directly into your accounting. If you're selling on Amazon alongside Shopify, keeping stock in sync across channels prevents overselling and ensures your cost-of-goods figures reflect what's actually been dispatched. That's where Shopify and Amazon inventory synchronisation becomes a bookkeeping issue as much as an operations issue.

Setting up your Shopify accounting foundation

A solid accounting foundation for a Shopify store rests on three things: the right legal structure, a clean separation of finances, and a chart of accounts built for e-commerce from the start.

Separate your finances completely

This sounds obvious. Plenty of sellers still don't do it. Using a personal bank account for business transactions — even temporarily, even "just for now" — creates reconciliation problems that take hours to unwind. Open a dedicated business current account and a business credit card before your first sale. Every business expense flows through those accounts. Nothing else does. Your bookkeeper (or future you) will be grateful.

Build a chart of accounts for e-commerce

A chart of accounts is the taxonomy your financial data lives in. Get it wrong and your P&L is useless for comparison or analysis. A basic e-commerce chart of accounts should include, at minimum:

• Revenue: Gross product sales, shipping income, other income (gift cards, bundles)
• Cost of Goods Sold: Product cost, inbound freight, duties and customs, packaging materials
• Operating Expenses: Platform fees (Shopify subscription, payment processing), advertising spend, outbound shipping, warehouse costs, returns processing, software subscriptions
• Other Expenses: Bank charges, professional fees (accountant, solicitor), loan interest

One point worth flagging on platform fees: Shopify charges a subscription fee plus a payment processing percentage (or a transaction fee if you use an external gateway). Both should sit on separate expense lines, not lumped into a generic "fees" bucket. When you're doing a quarterly review and you want to know whether your processing costs went up because revenue went up or because your blended rate changed, you need that granularity.

Choose your accounting method

Cash basis accounting records revenue when cash hits your account and expenses when you pay them. Accrual accounting records revenue when it's earned and expenses when they're incurred. For most Shopify sellers past the startup phase, accrual gives a far more accurate picture — particularly if you're carrying inventory, offering payment terms to wholesale buyers, or running significant pre-orders. In the UK, businesses above the VAT registration threshold are generally expected to use accrual. In the US, C-corporations and businesses with inventory above certain thresholds are required to use accrual under IRS rules.

Start accrual. Switching later is genuinely painful — you have to restate historical figures and your year-over-year comparisons break.

Managing cash flow and reconciling payments

Reconciling Shopify payments means matching every transaction in your accounting system against the actual deposits in your bank account — catching the discrepancies that make your cash position look different from your sales dashboard.

Shopify Payments settles on a rolling cycle (typically daily in the UK and US after a short delay). What lands in your bank account is a net figure: gross sales, minus refunds processed in that period, minus payment processing fees, minus any reserves Shopify is holding. That's three separate adjustments between your reported sales and your actual deposit, and all three need to be accounted for correctly.

A worked example

Say you had a week where Shopify reports £18,500 in gross sales. During the same period, £620 in refunds were processed, Shopify's payment processing fee (typically around 1.5–2% for UK Shopify Payments, depending on your plan) deducted approximately £315, and Shopify held back £200 in rolling reserves. Your actual bank deposit for that period: roughly £17,365. If you're booking revenue at £18,500 without accounting for those items, your P&L is overstated by £1,135 in that one week alone — and that figure compounds every week.

But it gets more granular than that. Chargebacks are a separate line item. When a customer disputes a charge and wins, Shopify debits your account directly. That's not a refund — it's a separate transaction type that needs its own accounting treatment (and potentially its own expense line, since chargeback losses are deductible differently from ordinary returns in some jurisdictions).

Monthly reconciliation workflow

A basic monthly reconciliation workflow looks like this:

1. Download your Shopify Payments payout report for the month (Finance → Payouts in Shopify admin)
2. Match each payout total to your bank statement
3. Identify any discrepancies and trace them to specific transaction types (refunds, fees, reserves, chargebacks)
4. Post the correct journal entries: gross sales to revenue, fees to expense, refunds as contra-revenue, reserves to a current liability account until released
5. Confirm your closing cash balance in your accounting system matches your bank statement exactly

If you're also selling on Amazon, you'll know this process gets considerably more complex — Amazon's settlement reports include dozens of transaction types. We covered that in our Amazon seller accounting guide in detail. The principle is the same; the volume and complexity is higher.

For multi-channel operations, posting clean, accrual-correct journals to your ledger is one of those tasks that looks simple until you're doing it across four marketplaces at once.

Tax compliance and deduction tracking for Shopify stores

Tax compliance for Shopify sellers has two distinct dimensions: collecting and remitting the right taxes from customers, and claiming the legitimate deductions that reduce your own tax bill.

Sales tax nexus in the US

US sales tax is where most growing Shopify sellers have exposure they don't know about. Since the South Dakota v. Wayfair Supreme Court decision in 2018, states can require out-of-state sellers to collect and remit sales tax based on economic nexus — meaning your sales volume or transaction count in a state, not physical presence. Most states have set their economic nexus threshold at $100,000 in sales or 200 transactions in a calendar year.

And here's the uncomfortable bit: if you've crossed that threshold in California, Texas, or New York and you haven't been collecting sales tax, you have back liability. The penalties and interest vary by state but they're not trivial. We put together a detailed guide to US sales tax nexus for e-commerce sellers that covers each state's thresholds and the steps to get compliant.

Shopify's built-in tax settings handle collection reasonably well once you've told it where you have nexus. The problem is that most sellers haven't done the nexus analysis first. Do that analysis before you configure Shopify's tax settings, not after.

UK VAT

In the UK, the VAT registration threshold is currently £90,000 in taxable turnover in any rolling 12-month period. Once you cross it, you have 30 days to register. VAT-registered Shopify sellers need to charge VAT at the correct rate (20% standard, 5% reduced, 0% zero-rated depending on product type), file VAT returns (usually quarterly via Making Tax Digital), and reconcile VAT collected in Shopify against VAT due on purchases.

One common error: treating Shopify Payments processing fees as VAT-exempt when they're actually subject to reverse-charge VAT in some circumstances. Get your accountant to verify your treatment of platform fees — it's a common audit point.

Deduction tracking

Legitimate deductions for Shopify sellers are broader than most people realise. Every one of these should sit on a separate expense line in your chart of accounts:

• Shopify subscription fees and app charges
• Payment processing fees (Shopify Payments, Stripe, PayPal)
• Advertising spend (Meta, Google, TikTok, Pinterest)
• Shipping costs — both outbound to customers and inbound from suppliers
• Packaging materials (boxes, mailers, void fill, branded tissue)
• Returns processing costs (restocking, inspection, re-packaging)
• Warehouse rent and utilities (or a home office proportion if you're shipping from home)
• Professional fees — accountant, solicitor, bookkeeper
• Software subscriptions (including inventory management, shipping, design tools)
• Employee costs — salaries, employer NI contributions, pension contributions

Most sellers undercount their deductible expenses because they don't track them in real time — they try to reconstruct them at year-end from bank statements. Categorise expenses as they occur. It takes 30 seconds per transaction and saves hours in January.

Monthly and annual financial reporting best practices

Consistent financial reporting is what turns accounting from a compliance task into a management tool.

The three reports that matter

Three financial statements give you a complete picture of your business:

• Profit & Loss (Income Statement): Revenue minus all expenses equals net profit. Run this monthly. Compare it to the same month last year to spot trends.
• Balance Sheet: Assets (stock, cash, receivables) minus liabilities (supplier credit, loans, VAT owed) equals equity. Run this monthly. Watch your inventory value — it's usually the biggest asset on the balance sheet for a product seller.
• Cash Flow Statement: The actual movement of cash in and out. Profitable businesses go bust when they run out of cash. This report is why.

Quarterly P&L reviews

A quarterly P&L review isn't an accountant's task — it's a founder or operations manager task. Set aside two hours at the end of each quarter to answer these specific questions:

1. Which products had the highest gross margin this quarter? Which had the lowest?
2. Did advertising spend as a percentage of revenue increase or decrease versus last quarter?
3. Were there any cost lines that grew faster than revenue? (That's your cost overrun signal.)
4. What's the trend in your returns rate? Returns processing is a real cost — if it's rising, find out why.

When we were running our own brands, the quarterly review was the single most reliable way to catch a problem before it became a crisis. One quarter we noticed shipping costs had grown from 8% of revenue to 11.5% — not because we were shipping more orders, but because our carrier had quietly increased dimensional weight pricing and our average package size had grown. Three months of missing that would have wiped out a meaningful portion of annual profit.

Year-end preparation

For UK limited companies, your statutory accounts are due nine months after your financial year-end. For US entities, filing deadlines vary by structure (S-corps, LLCs, C-corps all differ). What matters is that year-end preparation isn't a December scramble — it's a process you maintain all year. If your books are reconciled monthly, year-end is a two-day job. If they're not, it's a two-month nightmare.

One area that catches sellers out: stock valuation. Your closing inventory needs to be valued at the lower of cost or net realisable value. That means if you're holding £80,000 of slow-moving stock that you'd realistically sell for less than cost (end-of-season clearance, obsolete SKUs), your accountant may need to write some of that value down. Those writedowns are deductible — but only if you've actually identified them. A proper inventory management system that tracks stock age and movement velocity makes this exercise far less painful.

Comparison: manual vs automated Shopify accounting workflows

The efficiency argument for automation is real, but the accuracy argument is more compelling. Manual reconciliation doesn't just take longer — it introduces systematic errors that make your financial statements unreliable for decision-making.

Inventory accounting and COGS

Cost of Goods Sold is the single most impactful line on a Shopify seller's P&L. Get it wrong and your gross margin figures are meaningless. There are three main inventory costing methods:

• FIFO (First In, First Out): The oldest stock is assumed sold first. Gives a more accurate balance sheet in inflationary environments. Most common for physical goods.
• AVCO (Average Cost): All units of a SKU are valued at the running average cost. Simpler to maintain. Used widely by e-commerce sellers with homogeneous SKUs.
• Specific Identification: Each unit tracked individually. Only practical for high-value, low-volume items (jewellery, art, electronics with serial numbers).

Whichever method you choose, the discipline that matters is updating costs every time you receive a new purchase order. If you bought 500 units of a SKU at £12 in January and another 500 at £14 in April (costs went up — it happens), your COGS calculation has to reflect whichever units were actually sold. Using a stale January cost figure against April and May sales will overstate your margins. Keeping accurate stock records at the purchase-order level is what makes this possible.

For sellers running across Shopify and other channels, inventory accuracy also affects your accounting directly — a stock discrepancy between channels creates phantom COGS. If Shopify records a sale but your inventory system shows the unit was actually sold on Amazon, you've double-counted the COGS. Proper channel integration isn't just an operations convenience — it's an accounting requirement.

Frequently asked questions

How do I reconcile my Shopify account with my bank statements?

Download your Shopify Payments payout report for each period and match each net deposit to the corresponding line on your bank statement. Because each payout is net of fees, refunds, and any held reserves, you need to post the gross sales figure to revenue and separately post the fee, refund, and reserve amounts to their respective accounts — the payout total alone isn't enough for accurate bookkeeping. Do this monthly rather than quarterly or at year-end; it keeps discrepancies small and easy to trace.

What accounting software integrates best with Shopify?

Xero and QuickBooks Online are the two most widely used accounting platforms among Shopify sellers, with Xero having particularly strong adoption among UK and Australian merchants. But the software matters less than how the integration works. A direct Shopify-to-accounting sync that posts only the net payout as a lump sum gives you less useful data than one that parses each settlement into individual transaction types (sales, fees, refunds, reserves, tax). For sellers who want that granularity without manual entry, Ceendesis Accounting handles exactly this for Shopify and other major marketplaces, posting accrual-correct journals into Xero (with QuickBooks Online support rolling out — no Sage yet).

How do I track inventory costs and COGS in Shopify accounting?

Assign a unit cost to every SKU in your inventory system and update that cost every time you receive a new purchase order. Shopify's native product cost field gives you a starting point, but it doesn't handle cost changes over time or multi-location COGS attribution well. For meaningful COGS tracking, you need an inventory system that records costs at the purchase-order level and feeds those figures into your accounting software when a sale is recorded. If you're managing stock across Shopify and other channels, our guide to multi-channel inventory forecasting covers how to keep those figures consistent across channels.

If you're ready to move beyond spreadsheets and CSV exports, start with three things: get your chart of accounts set up correctly, separate your business finances if you haven't already, and put a monthly reconciliation routine in place — ideally one that doesn't depend on someone manually downloading and cross-referencing reports. For sellers on Shopify (and Amazon, eBay, Etsy, Walmart, TikTok Shop, Square, or WooCommerce), Ceendesis Accounting parses your settlement and payout data, splits each payout into sales, fees, refunds, reserves, and tax with per-product COGS tracking, and posts clean accrual-correct journals directly into Xero. It's built around Xero today — QuickBooks Online support is rolling out, and there's no Sage integration yet — so check that fits your stack before you commit. The goal isn't software for its own sake; it's financial statements you can actually trust so you can make better decisions with them.