Sales through Amazon, Shopify, eBay, Etsy, and TikTok Shop may complicate accountancy. Each of these sales platforms has its own settlement reports, fees, refunds, and currency conversion. Without a proper system, manually reconciling all of this information is difficult and time-consuming.
Accuracy in bookkeeping is extremely important for UK firms. VAT-registered firms must keep electronic VAT accounting records and file VAT returns using suitable software from the Making Tax Digital for VAT initiative. Making Tax Digital for Income Tax is applicable to some single traders and landlords with earnings that exceed the relevant level beginning in April 2026. HMRC requires firms to have sufficient accounting documentation to accurately calculate their taxes.
What Is COGS and Why It Matters for Multi-Channel Sellers
The cost of goods sold (COGS) is the direct cost of the product or items sold by a company. The Cost of goods sold covers the cost of acquiring or creating the inventory of products, as well as any additional charges, such as inbound freight, that are required to get the inventory to its current location and condition. HMRC considers these types of charges when computing inventory costs.
A basic COGS calculation is:
Opening inventory + purchases and other direct costs − closing inventory = COGS
Valuing stock appropriately is critical since the closing stock determines how much profit is earned for the accounting quarter. HMRC usually requires that trade stock be evaluated using a recognised principle, such as the lower of cost and net realisable value.
When a business sells goods through many channels, COGS must be calculated independently for each sales channel. Depending on the cost of referrals, fulfilment, payment fees, and selling expenses, the costs associated with selling the goods through Amazon, Shopify, eBay, or other channels may change significantly. All of these expenses are critical in determining the actual profitability of the sales channel, yet none of them is included in the cost of products sold. To put it another way, the product can be profitable on one channel but not on another.
Why Manual Bookkeeping Breaks Down Across Channels
Reports on settlement costs and rewards are also used differently by various markets. When you are managing thousands of transactions and several SKU items, manually reconciling them with the bank can get tiresome, and mistakes can occur very quickly.
You also need to pay close attention to your inventories. Your inventory value still includes purchased stocks that have not been sold yet. When the inventory is sold, the cost of these stocks is recorded as Cost of Goods Sold in the Profit & Loss account. Your inventory and profit calculations are impacted by ineffective stock management. When you bring in goods from overseas, it gets much more problematic. Depending on the business’s VAT status, the import VAT must be recorded separately, but all expenses required to bring the inventory to where it is now can be included in the inventory cost.
How Bookkeeping Automation Solves This
E-commerce accounting automation reduces the number of repeated operations associated with inventory accounting, payouts, refund processing, sales recording, and fee recording. By offering common account identifiers and linking marketplace settlements with corresponding bank statements, integration tools enable you to link different channels of selling products or services to your accounting application.
The primary objective is to give the business an integrated view of sales, fees, VAT, inventory, and cash flows via various channels in addition to automating the data input process. While e-commerce interfaces can be used to link sales channels with accounting transactions, systems like Xero enable the management of inventory levels and their value.
Setting Up COGS Tracking Correctly
A precise COGS management strategy divides inventories, cost of goods sold, and operational expenditures. The following are some of the items that will be needed:
- Create an account for the cost of goods sold (COGS): The COGS account is used to hold the costs associated with sold products. All costs, including advertising and subscription fees, are documented in their individual expense accounts.
- Create an account for inventory assets: All unsold inventory must be recognised as inventory rather than cost of goods sold.
- Map all sales channels to the system: Amazon, eBay, and other sales channels must be set up to record sales, refunds, fees, VAT, and payments individually.
- Linking sales to inventory: Inventory and accounting systems must minimise inventory and assign costs to sold items. This can be done automatically or manually with journals.
In this case, we must ensure that the inventory asset is on the balance sheet while also accounting for the cost of the things sold in the profit and loss account.
Choosing a Cost Flow Method
When it comes to multi-channel sales firms, the inventory valuation method is defined by the stock type and accounting system in use. There are several inventory valuation methods, including first in, first out (FIFO) and weighted average cost. The inventory valuation approach chosen must be consistent and result in a realistic closing stock value. It has an influence on the cost of products sold, reported profit, and taxable profit for corporation tax or self-assessment purposes. It is critical to choose a strategy that the company can implement consistently.
The VAT and Tax Angle
COGS impacts taxable profit but is unaffected by VAT. VAT is often computed using the taxable sales and input VAT, rather than inventory costs. VAT-registered businesses generally claim VAT on qualifying inventory as input VAT, so it is not factored into inventory costs. However, firms that are not VAT registered are unable to claim VAT. Hence, VAT-inclusive cost can be utilised. In addition, multi-channel sellers must apply VAT treatment based on the customer’s location, the supply channel utilised, whether the sale is made through a marketplace, and if the transaction is domestic, export, or import.
The VAT treatment is not impacted by the currency used in the transactions. Accounting and VAT records should utilise an appropriate exchange rate when dealing with foreign currencies. HMRC offers currency rates for VAT purposes. Making Tax Digital for VAT requires the use of digital records and VAT filing using suitable software, wherever possible. However, the MTD does not include a clause requiring monthly reconciliation of each platform or a six-year retention term. Errors in COGS and inventory management can lead to improper tax computations. Sales, inventory, VAT, and costs must all be maintained separately to avoid this.
Common Mistakes Sellers Make
Operating expenses such as PPC, software, and marketplace fees might also be included in COGS, which is a common error. This should be recorded independently from inventory expenses. Another concern is the mixing of personal and corporate activities, the use of out-of-date inventory spreadsheets, and the failure to account for foreign exchange changes in multi-currency sales. It is also critical to accurately track any inventory designated for sampling, testing, or marketing reasons. When inventory is taken out of stock for these purposes, it should be properly accounted for and not held on hand.
How UK Ecommerce Accountants Help
Managing COGS across several marketplaces requires more than basic bookkeeping. At UK Ecommerce Accountants, we help online sellers bring sales, fees, stock and tax data together into accurate, well-organised accounts.
- Consolidate sales channels: We bring Amazon, Shopify, eBay, Etsy and TikTok Shop data into your accounting system while keeping channel-level reporting where required.
- Set up COGS and inventory accounts: We configure your Xero or other cloud accounting software so inventory costs are recorded correctly and COGS is recognised when stock is sold.
- Apply the right inventory method: We help establish an appropriate stock valuation method, such as FIFO or weighted average cost, based on your products and accounting requirements.
- Map marketplace transactions: We separate sales, refunds, VAT, marketplace fees and other adjustments instead of recording everything as a single payout.
- Reconcile marketplace settlements: We match platform settlements with bank transactions to identify missing, duplicated or incorrectly recorded entries.
- Support VAT compliance: We help record VAT correctly across different sales channels, transaction types and currencies and support digital VAT record keeping under Making Tax Digital where applicable.
- Handle input VAT correctly: We ensure eligible input VAT on stock purchases is recorded and reclaimed correctly, subject to the normal VAT rules.
- Track channel-specific costs: We account for costs such as Amazon FBA and referral fees separately from product costs so management reports show the true cost of selling through each channel.
- Prepare reliable tax figures: Accurate sales, expenses, inventory and VAT records provide a stronger basis for VAT Returns, Self Assessment and Corporation Tax calculations.
FAQs:
What is the difference between bookkeeping and COGS tracking for ecommerce sellers?
Bookkeeping records all of the business’s financial transactions, such as sales, fees, expenses, and payments. COGS recording involves determining the costs paid in purchasing the goods sold by the company. COGS reported in this manner are then utilised to calculate gross profit.
Why does COGS matter for VAT registered sellers?
VAT accounting and COGS accounting are two distinct accounting systems. VAT paid on inventory purchases is typically reclaimable and hence not included in the inventory’s underlying cost for a registered firm. VAT paid on the purchase of inventory cannot be recovered by a firm that is not registered to pay VAT.
Can I track COGS manually in a spreadsheet?
Yes, a spreadsheet can be appropriate for the task at hand. But with an increasing number of transactions and accounting for stock, orders, returns, fees, and settlements in multiple marketplaces, things become complicated.
Which cost flow method should multi-channel sellers use?
Not all methods are effective for everyone. Both the FIFO and weighted average costing methods are widely used, and precise identification is effective for identifiable inventory. The approach chosen must be appropriate for the inventory and consistent.
How long must UK sellers keep VAT and inventory records?
Most VAT registered businesses must preserve their VAT records for at least six years. It covers VAT accounts and other documents needed to prepare VAT returns. Different categories of records have varying retention periods. HMRC VAT Record-Keeping Guidelines
Do platform fees count as part of COGS?
No, fees for using marketplaces’ referral services, shipping fees, and advertising charges are often maintained separately from inventory costs. This allows you to view both the gross product margin and the cost of doing business in the marketplace.
