Managing VAT becomes more complicated when your ecommerce business sells through multiple online platforms. Shopify, Amazon, eBay and other marketplaces can generate hundreds or thousands of transactions every month. Each sale, refund, marketplace fee and payment needs to be recorded correctly.
For UK online sellers, preparing VAT returns also means understanding which sales are taxable, applying the correct VAT rates and keeping accurate digital records.
Ecommerce VAT Returns Using QuickBooks can help businesses organise their VAT records, review transactions and prepare VAT returns using accounting software.
QuickBooks Online provides tools for tracking VAT, managing income and expenses, reconciling bank accounts and reviewing VAT reports. However, the accuracy of your return depends on how your transactions are recorded and how your VAT settings are configured.
This guide explains how ecommerce businesses can use QuickBooks for VAT accounting, manage marketplace transactions and avoid common reporting mistakes.
Why VAT Management Matters for Ecommerce Businesses
VAT is an important part of financial management for UK ecommerce businesses. Unlike traditional retail stores, online sellers often receive payments from several sources.
For example, a business might sell products through Shopify, Amazon and eBay while accepting payments through PayPal, Stripe and marketplace payment systems.
Each platform may handle sales, fees, refunds and VAT information differently.
Without accurate bookkeeping, these transactions can create problems such as:
- Incorrect VAT calculations on sales
- Duplicate income recorded from marketplace payouts
- Missing VAT on eligible business expenses
- Incorrect treatment of overseas transactions
- Differences between sales reports and accounting records
- Inaccurate VAT returns submitted to HMRC
QuickBooks can help organise these records, but businesses must understand how marketplace transactions affect their VAT position.
Understanding UK Ecommerce VAT Requirements

Before preparing ecommerce VAT returns using QuickBooks, it is important to understand the basic UK VAT rules.
VAT Registration Threshold
The UK VAT registration threshold is £90,000 of taxable turnover over a rolling 12 month period.
Businesses must generally register for VAT when their taxable turnover exceeds this threshold. Registration can also be required when a business expects its taxable turnover to exceed the threshold within the next 30 days alone.
Some businesses choose to register voluntarily even when their turnover is below the threshold.
VAT registration requirements can differ for overseas businesses making taxable supplies in the UK.
UK VAT Rates
The UK has several VAT treatments depending on the goods or services supplied.
| VAT treatment | Rate | Example |
|---|---|---|
| Standard rate | 20% | Most consumer electronics and accessories |
| Reduced rate | 5% | Certain qualifying goods |
| Zero rate | 0% | Many qualifying children’s clothes |
| Exempt | No VAT charged | Certain exempt services |
| Outside the scope | Not subject to UK VAT | Certain transactions outside UK VAT rules |
Zero rated, exempt and outside the scope transactions are not interchangeable. They can affect VAT reporting and input VAT recovery differently.
Ecommerce sellers should ensure that each product is assigned the correct VAT treatment.
Making Tax Digital for VAT
VAT registered businesses generally need to follow HMRC’s Making Tax Digital requirements.
This includes maintaining appropriate digital records and submitting VAT returns through compatible software.
QuickBooks Online offers Making Tax Digital functionality for supported UK VAT subscriptions and configurations.
For official guidance, visit HMRC VAT guidance.
How QuickBooks Helps Ecommerce Businesses Manage VAT
QuickBooks Online includes several accounting features that support ecommerce VAT management.
VAT Tracking
QuickBooks allows businesses to assign VAT codes to transactions and calculate VAT based on their settings.
This helps online sellers track VAT on sales, purchases and eligible expenses.
VAT Reports
QuickBooks provides VAT reports that can help businesses review their VAT position before submitting a return.
These reports can highlight transactions and VAT amounts that need further investigation.
Bank Reconciliation
Bank reconciliation allows businesses to compare recorded transactions against their bank statements.
This is particularly important for ecommerce sellers receiving marketplace settlements rather than individual customer payments.
Ecommerce Integrations
QuickBooks can connect with ecommerce platforms through supported integrations and third party applications.
Depending on the integration, businesses may be able to transfer sales summaries, fees, refunds and payment information into their accounting records.
However, not every integration handles VAT in the same way. Businesses should check how each connection records sales and taxes before relying on automated data.
How to Set Up QuickBooks for Ecommerce VAT Returns
Correct setup is one of the most important steps when using QuickBooks for VAT reporting.
Step 1: Confirm Your VAT Registration Details
Before enabling VAT, confirm that your business is registered with HMRC.
You should have the following information available:
- Business VAT registration number
- VAT registration effective date
- Applicable VAT accounting scheme
- VAT return periods
- HMRC Making Tax Digital authorisation details
Make sure the information matches your HMRC records.
Step 2: Configure VAT Settings in QuickBooks
Open the VAT section in QuickBooks Online and follow the setup process for your UK company.
Depending on your QuickBooks version, you may need to select your VAT accounting scheme and reporting frequency.
Check that the selected scheme matches the one your business uses.
For example, businesses using standard VAT accounting generally account for VAT according to the applicable tax point rules, while businesses using the Cash Accounting Scheme follow different timing rules.
Step 3: Review Your Chart of Accounts
Your chart of accounts determines how income, expenses, assets and liabilities appear in QuickBooks.
Ecommerce businesses may benefit from separate accounts for:
- Shopify sales
- Amazon sales
- eBay sales
- Marketplace selling fees
- Payment processing charges
- Customer refunds
- Shipping income
- Marketplace clearing accounts
The exact structure depends on the size and complexity of the business.
Separate sales accounts can improve reporting, but VAT treatment must still be applied correctly to individual transactions or suitable sales summaries.
Step 4: Connect Ecommerce Platforms
QuickBooks may be connected to platforms such as Shopify, Amazon and eBay through compatible applications.
Before connecting an integration, check whether it supports:
- Gross sales reporting
- VAT breakdowns
- Refunds and credit notes
- Marketplace fees
- Settlement reconciliation
- Multiple currencies
- Marketplace collected taxes
An integration should not be assumed to produce correct UK VAT figures automatically.
Step 5: Test Transactions Before Using Live Data
Start with a small sample of sales, refunds and payouts.
Compare the imported figures against the original marketplace reports.
Check whether VAT amounts, fees and payment balances are correct.
This helps identify errors before they affect a full VAT return period.
Recording Ecommerce Sales Correctly in QuickBooks
One of the most common ecommerce accounting mistakes is recording marketplace payouts as total sales.
Marketplace payouts are often lower than gross sales because platforms deduct fees, refunds and other adjustments.
Example: Recording an Amazon Settlement
Suppose an Amazon seller has the following transactions during a settlement period.
| Transaction | Amount |
|---|---|
| Gross customer sales including VAT | £12,000 |
| Marketplace fees | £1,200 |
| Customer refunds | £600 |
| Net settlement received | £10,200 |
In this simplified example, gross sales are assumed to be standard rated UK sales, refunds relate to those sales, and the £1,200 fee is shown separately without assuming its VAT treatment.
The business receives £10,200 in its bank account.
However, recording only £10,200 as sales would hide the gross sales, refunds and fees.
Instead, the accounting records should separately recognise the relevant sales, refunds, marketplace charges and settlement.
The business must also determine the correct VAT treatment of the marketplace fees using the supplier invoices and applicable rules.
This provides a more accurate picture of sales revenue and VAT liabilities.
Managing Shopify VAT Transactions in QuickBooks
Shopify sellers may receive payments through Shopify Payments, PayPal or other providers.
The amount deposited into the bank account can differ from the original order value because of processing fees, refunds and settlement timing.
For accurate VAT reporting, Shopify sellers should review:
- Sales by VAT rate
- Customer refunds and returns
- Shipping charges
- Discounts and promotions
- Payment processing fees
- International orders
- Settlement reports
For example, if a customer purchases a standard rated product for £120 including VAT, the sale normally contains £100 net revenue and £20 output VAT.
If a payment provider deducts a £3 fee and transfers £117, the original sale should not simply be recorded as £117.
The £3 fee should be accounted for separately, with its VAT treatment checked.
Businesses using Shopify integrations should verify that the imported data correctly distinguishes sales from payments and fees.
Handling Amazon and eBay VAT in QuickBooks
Amazon and eBay sellers may face additional VAT considerations because marketplace operators can be responsible for collecting and accounting for VAT on certain transactions.
This depends on factors such as the seller’s location, where goods are located, the customer and the type of transaction.
Marketplace Collected VAT
In certain circumstances, online marketplaces must account for UK VAT on sales facilitated through their platforms.
When this applies, sellers need to avoid recording VAT as payable by their business when the marketplace is responsible for that VAT.
However, the correct accounting treatment depends on the specific transaction.
Marketplace Fees
Amazon and eBay may charge selling fees, subscription charges, advertising fees and other service costs.
These fees can have different VAT treatments depending on the supplier, the service and the seller’s circumstances.
Sellers should review fee invoices and apply the appropriate VAT codes in QuickBooks.
Settlement Reconciliation
Marketplace settlements may include sales, refunds, fees, adjustments and reserve balances.
Using a dedicated clearing account can help businesses reconcile the activity against payments received.
This is particularly useful for sellers processing large transaction volumes.
How to Prepare Ecommerce VAT Returns Using QuickBooks
Once your ecommerce transactions are recorded correctly, you can begin preparing your VAT return.
Step 1: Review Sales Transactions
Check that all sales for the VAT period have been recorded.
Compare QuickBooks sales figures against reports from Shopify, Amazon, eBay and other platforms.
Investigate missing sales, duplicate transactions and incorrect VAT codes.
Step 2: Review Purchase VAT
Check supplier invoices and business expenses to identify VAT that may be recoverable.
Common ecommerce expenses include:
- Inventory purchases
- Packaging materials
- Advertising costs
- Software subscriptions
- Warehouse expenses
- Professional services
Not every expense includes recoverable VAT. Recovery depends on the VAT rules, the nature of the purchase and the supporting documentation.
Step 3: Reconcile Marketplace Settlements
Compare marketplace reports against QuickBooks clearing accounts and bank deposits.
Check that fees, refunds and settlement adjustments have been recorded separately.
Investigate unexplained differences before finalising the VAT figures.
Step 4: Review the VAT Return
Open the VAT section in QuickBooks and select the relevant return period.
Review the VAT return figures, including:
| VAT box | Information reported |
|---|---|
| Box 1 | VAT due on sales and other outputs |
| Box 2 | VAT due on certain Northern Ireland acquisitions from EU member states |
| Box 3 | Total VAT due |
| Box 4 | VAT reclaimed on purchases and other inputs |
| Box 5 | Net VAT payable or reclaimable |
| Box 6 | Total value of sales and other outputs excluding VAT |
| Box 7 | Total value of purchases and other inputs excluding VAT |
| Box 8 | Relevant goods supplied from Northern Ireland to EU member states |
| Box 9 | Relevant goods acquired in Northern Ireland from EU member states |
Check the figures against your accounting records and supporting reports. The boxes must be completed according to HMRC rules, which may require adjustments beyond ordinary sales and purchases.
Step 5: Submit Your VAT Return to HMRC
QuickBooks Online supports electronic VAT submission through Making Tax Digital for supported UK VAT schemes.
Before submitting, ensure your business is authorised to connect QuickBooks with HMRC.
According to QuickBooks’ current guidance, you can open the VAT Returns section, prepare the relevant return and select Submit to HMRC once your checks are complete.
Wait for confirmation that HMRC has accepted the return and retain the submission receipt. QuickBooks
Common Ecommerce VAT Mistakes to Avoid
Even with accounting software, ecommerce businesses can make VAT reporting errors.
Recording Net Payouts as Sales
Marketplace deposits should not automatically be treated as total sales revenue.
This can result in incorrect turnover and VAT figures.
Using Incorrect VAT Codes
Different products and transactions may require different VAT treatments.
Using a standard VAT code for every transaction can produce inaccurate results.
Ignoring Customer Refunds
Refunds and returns can affect VAT calculations.
Businesses should record the relevant credit notes and adjustments in the correct period according to the applicable rules.
Incorrectly Recording Marketplace VAT
Certain marketplace transactions involve VAT collected and accounted for by the platform rather than the seller.
For example, special rules apply to qualifying imported consignments valued at £135 or less and certain sales by overseas sellers of goods already located in the UK. GOV.UK+1
Missing International VAT Rules
Selling products outside the UK can involve export VAT rules, import VAT, overseas tax registrations and other obligations.
A UK VAT return does not necessarily cover every tax obligation arising from international ecommerce sales.
Failing to Reconcile Accounts
Unreconciled bank accounts and marketplace clearing balances can hide missing transactions or duplicated entries.
Regular reconciliation helps identify these issues before VAT returns are prepared.
Best Practices for Accurate Ecommerce VAT Reporting
Businesses can improve their VAT reporting by following a consistent accounting process.
Maintain regular bookkeeping. Record sales, refunds, fees and expenses throughout the month instead of waiting until the VAT deadline.
Use suitable integrations. Choose ecommerce integrations that provide the transaction details and VAT information your business needs.
Review VAT codes. Check VAT settings whenever your products, sales channels or international selling arrangements change.
Keep supporting documents. Retain relevant invoices, marketplace reports, refund records and VAT calculations in line with HMRC requirements.
Reconcile clearing accounts. Ensure marketplace balances can be explained using settlement reports and payments received.
Review reports before submission. Compare QuickBooks figures against source records and investigate unusual differences.
Get specialist support when needed. Ecommerce VAT can become complex when businesses sell internationally, use several marketplaces or process high transaction volumes.
When Should You Get Professional Ecommerce VAT Support?
Some ecommerce businesses can manage straightforward VAT returns internally.
However, professional support may be useful when your business experiences:
- High sales volumes across several marketplaces
- Complex Amazon or eBay settlement reports
- International sales and VAT obligations
- Incorrect VAT codes in QuickBooks
- Unreconciled marketplace clearing accounts
- Historical VAT reporting errors
- Difficulty preparing Making Tax Digital returns
An ecommerce accountant can review transaction records, investigate differences and help ensure VAT returns reflect the correct accounting treatment.
This is particularly valuable for growing businesses that need reliable financial information alongside VAT compliance.
Why QuickBooks Is Useful for Growing Ecommerce Businesses
QuickBooks offers more than VAT return preparation.
When configured correctly, it can help ecommerce businesses monitor income, expenses, outstanding balances and financial performance.
For example, separating marketplace sales and fees can make it easier to understand which selling channels generate revenue and how operating costs affect profitability.
Regular bookkeeping also gives business owners better information for inventory planning, cash flow management and business decisions.
However, QuickBooks is only as reliable as the records entered into it. Correct VAT setup, accurate transaction imports and regular reconciliations remain essential.
Conclusion
Ecommerce VAT Returns Using QuickBooks can help UK online sellers organise their tax records and prepare VAT returns through compatible accounting software.
The key is recording transactions correctly.
Shopify, Amazon, eBay and other marketplaces often report gross sales, fees, refunds and settlements separately. These figures need to be reconciled before VAT returns are finalised.
Businesses must also consider marketplace VAT rules, international transactions and the correct VAT treatment of purchases.
With proper setup, regular bookkeeping and careful reviews, QuickBooks can become a valuable part of your ecommerce accounting process.
Get Expert Help with Ecommerce VAT Returns Using QuickBooks
Managing VAT across multiple ecommerce platforms can take valuable time away from running your business.
At eSeller Accountant, we help online sellers manage ecommerce bookkeeping, reconcile marketplace transactions and prepare accurate accounting records for VAT reporting.
Whether you sell through Shopify, Amazon, eBay or multiple channels, our team can help you identify accounting issues and improve the reliability of your QuickBooks records.
Need help with your ecommerce VAT returns?
Get a Quote from eSeller Accountant
Speak with our team about your ecommerce accounting requirements and find out how we can support your business.