Quickbooks Setup for Self Employed Ecommerce

QuickBooks setup for self employed ecommerce: what “done properly” looks like

If you sell online and you’re self employed, QuickBooks can be a solid choice — but only if it’s set up to reflect how ecommerce actually works. The difference between “it sort of works” and “it’s reliable for tax” usually comes down to a few key decisions at the start: how sales are recorded, how platform fees are treated, how stock is handled (if at all), and how VAT is tracked.

This guide explains a practical QuickBooks setup for self employed ecommerce sellers in the UK, in plain English. It’s written with Making Tax Digital in mind, so your records are not only tidy, but also compliant and easy to maintain.

Before you touch QuickBooks: get clear on your ecommerce reality

QuickBooks is only as accurate as the information you feed it. Before setup, take 10 minutes to answer these:

• Where do you sell? (Shopify, Amazon, eBay, Etsy, WooCommerce, TikTok Shop, your own site)
• How do you get paid? (Stripe, PayPal, Amazon settlements, Shopify Payments, Klarna, etc.)
• Do you hold stock? If yes, do you need stock tracking in QuickBooks, or is a separate stock tool better?
• Are you VAT registered? If yes, are you on Standard VAT, Flat Rate, or another scheme?
• Do you sell outside the UK? This affects VAT treatment and reporting.

If you’re also thinking about digital record keeping and future MTD requirements, our Making Tax Digital Setup for Self Employed Ecommerce service explains what you need to do now, what can wait, and how to keep everything joined up.

Step 1: choose the right QuickBooks version (and avoid paying for features you won’t use)

For most self employed ecommerce sellers, QuickBooks Online is the practical option because bank feeds, app integrations, and access for your accountant make life simpler.

• Simple Start can work for very small operations, but often becomes limiting once you want better reporting.
• Essentials / Plus is more common for ecommerce because it gives you better tools for tracking categories and performance.
• Advanced is usually unnecessary unless you have a larger team and complex reporting needs.

Choosing the “right” plan is less about turnover and more about how you need to record sales (and whether you need stock features). If you’re unsure, it’s worth deciding this before you connect any apps — changing later can be messy.

Step 2: set the business foundation correctly (so reports make sense)

In QuickBooks, the early settings affect everything that follows. We normally focus on:

• Business details (legal name, trading name, address, VAT number if registered)
• Accounting method (cash vs accrual). Most ecommerce sellers benefit from clarity here, especially if you’re VAT registered.
• VAT settings (only if VAT registered). This is not just a tick-box — it impacts how QuickBooks calculates VAT and what it expects from you.
• Chart of accounts tailored to ecommerce (so you can see profit properly, not just cash in/cash out).

A common mistake is leaving everything in one “Sales” bucket and one “Fees” bucket. It hides the true cost of selling on platforms and makes it hard to spot issues early.

Step 3: build an ecommerce-friendly chart of accounts

You don’t need dozens of categories, but you do need the right ones. A sensible structure usually includes:

• Sales income split by channel where useful (e.g. Shopify sales, Amazon sales, eBay sales)
• Sales returns/refunds (so you can see the real net sales)
• Cost of goods sold (COGS) for stock-based businesses (so gross profit is visible)
• Merchant fees (Stripe/PayPal processing fees)
• Marketplace fees (Amazon referral fees, FBA fees, eBay fees, Etsy fees)
• Postage and delivery (including shipping labels and courier costs)
• Packaging (mailers, boxes, inserts)
• Advertising and marketing (Meta ads, Google ads, influencer costs)
• Software subscriptions (apps, tools, email marketing platforms)

The aim is simple: your Profit & Loss should tell the truth. If it doesn’t, you’ll either overpay tax, underpay tax, or waste hours trying to fix it at the end of the year.

Step 4: connect bank feeds (and treat payouts properly)

Bank feeds are helpful, but ecommerce is rarely as simple as “a sale hits the bank”. Usually, you receive payouts after fees, refunds, and chargebacks.

In practice, you want QuickBooks to show:

• Gross sales (what the customer paid)
• Fees (what the platform/processor took)
• Refunds (what went back to customers)
• Net payout (what landed in your bank)

If you only record the net payout as “sales”, your turnover is wrong and your fees disappear — which can cause problems for VAT, Self Assessment, and basic decision-making.

Step 5: integrate your selling platforms (without creating duplicates)

Most ecommerce sellers use an integration app to push sales data into QuickBooks. The key is to choose a method that matches your volume and the level of detail you need.

• Low volume: you may be able to post daily/weekly summaries rather than every single order.
• Higher volume: automated postings are essential, but they must be configured to avoid duplicate income and VAT errors.

What we look for in an integration setup:

• It posts sales in a way that matches payouts and settlement reports
• It handles refunds and fees clearly
• It doesn’t create thousands of messy customer records
• It supports UK VAT logic where relevant

If you are planning your wider compliance approach alongside software, the Making Tax Digital Setup for Self Employed Ecommerce guide is a good place to start, because it covers record-keeping, integrations, and what HMRC expects in practice.

Step 6: set up VAT properly (if you’re VAT registered)

VAT and ecommerce can get complicated quickly, especially with mixed UK and international sales. The goal in QuickBooks is not to “make the VAT return go through” — it’s to make sure the VAT return is right.

Key VAT setup points:

• Correct VAT scheme (Standard vs Flat Rate, etc.)
• Correct VAT codes for UK sales, zero-rated items (if applicable), and outside-the-scope transactions
• Fee invoices from platforms (some include VAT, some don’t, and some are overseas suppliers)

If you’re not VAT registered, still keep an eye on turnover and thresholds. Ecommerce can grow quickly, and late registration can be expensive and stressful.

Step 7: decide how you’ll handle stock (and keep it consistent)

Not every self employed ecommerce seller needs stock tracking inside QuickBooks. What matters is consistency and a method that matches your business.

• If you have a small product range, you may track stock in QuickBooks or via a simple stock tool and post journals monthly.
• If you have lots of SKUs, a dedicated inventory system often works better, with summary postings into QuickBooks.
• If you are dropshipping, stock tracking may be minimal, but you still need clean purchase and fee categorisation.

The biggest mistake is switching methods mid-year without a plan. It can distort profit and make your year-end accounts harder than they need to be.

Step 8: set up rules, receipts, and a routine (so it stays tidy)

A good setup saves time every week. In QuickBooks, that usually means:

• Bank rules to categorise regular transactions correctly
• Receipt capture so expenses have evidence (HMRC expects you to keep records)
• Monthly reconciliations so you know the numbers are right, not just “entered”

A simple routine beats a big clean-up. If you keep on top of it monthly, your Self Assessment and (where relevant) VAT returns become far less stressful.

Common QuickBooks setup problems we see with ecommerce sellers

• Net payouts posted as sales, which understates turnover and hides fees
• Duplicate sales from bank feeds plus integrations
• VAT coded incorrectly on platform fees or overseas charges
• No clear split between owner’s spending and business costs
• Reports that don’t match reality (especially gross profit and channel performance)

These issues are fixable, but it’s quicker and cheaper to avoid them by setting things up properly at the start.

How this links to Making Tax Digital (MTD)

Making Tax Digital is about keeping digital records and submitting information to HMRC using compatible software. For ecommerce sellers, the practical impact is that your bookkeeping needs to be reliable and consistent — not a spreadsheet scramble at year-end.

If you want a step-by-step approach that joins up software, record keeping, and compliance, see our Making Tax Digital Setup for Self Employed Ecommerce page. It’s written specifically for online sellers and focuses on what to do now to stay on track.

When it’s worth getting help with your QuickBooks setup

You may benefit from professional setup support if:

• you sell on multiple platforms and can’t see clear profit by channel
• you’re VAT registered (or close to the threshold)
• your payouts don’t match your QuickBooks income
• you’ve had to “guess” VAT codes or categories
• you want confidence that your records will stand up to HMRC scrutiny

At Tax Digital, we set QuickBooks up so it’s practical for day-to-day ecommerce trading and robust for tax compliance. The aim is simple: compliance made easy, with less stress and fewer surprises.