Retail accounting: Stock management, VAT & point-of-sale integration

Published 11 March 2026

Table of contents

• What is retail accounting?
• Tips to manage stock and COGs
• How to handle VAT in retail
• How to complete POS integration with accounting software
• Which retail metrics, KPIs, and stock controls to monitor
• Simplify retail accounting with Xero
• FAQs on retail accounting

Key takeaways

• Retail accounting practices are a specialised set of processes retailers can use to track their shop's performance. It’s especially good for businesses with a lot of inventory or transactions.
• Pair your point of sale (POS) and accounting software so your sales, discounts, value added tax (VAT), and payouts post cleanly each day and your books stay tidy.
• Choose a suitable inventory valuation method like FIFO or weighted average; use the retail method only as an estimate.
• Set up VAT correctly with mapped tax codes, the right scheme, and digital links to stay compliant with Making Tax Digital.

What is retail accounting?

Retail accounting is the process of tracking sales, stock, costs, value added tax (VAT), and cash flow to understand your shop’s day-to-day performance.

It’s a specialised approach to bookkeeping and small business accounting for retailers who have a lot of transactions and fast-moving stock. You need systems that can accurately track sales, update inventory in real time, and calculate cost of goods sold (COGS) efficiently.

A modern point of sale (POS) system and cloud accounting software for retail makes retail accounting easier. They can automate much of your returns, discounts, supplier lead times, shrinkage, and multi-channel selling by syncing data between your till, online store, and accounts, giving you consistent, up-to-date figures in one place.

Strong retail accounting foundations make it easier to manage your shop, make informed decisions, and reduce manual tasks prone to error.

Learn how retail accounting software could benefit your small business.

Tips to manage stock and COGS

Managing stock and COGS is central to running a profitable retail business. The right systems and processes help you keep accurate figures and offer deeper insights into how each product is performing. Here are some tips to consider:

Pick the right inventory costing method

Inventory costing calculates the COGS and the book value of the stock you have on hand. It affects your margins, tax position, and the accuracy of your financial reports.

Different methods suit different retail setups:

• FIFO (first in first out) assumes the oldest stock sells first. This approach often mirrors how products move in real life. It means COGS is based on earlier purchase prices, while closing stock reflects more recent costs. FIFO gives you a more accurate snapshot of profitability when supplier prices are rising or falling.
• Weighted average cost calculates an average cost per item (technically, per stock keeping unit or SKU) across all purchases to smooth out changes in supplier prices.
• Retail inventory method estimates the value of stock by subtracting your average markup from the retail value. It’s fast and practical for high-volume retailers who don’t track every unit, but it’s also the least accurate of the three methods.

LIFO (last in first out) is another inventory costing method, but be careful not to use it as it isn’t permitted under UK accounting standards.

Here’s how the retail method calculation works in practice:

• You hold £50,000 of goods at retail value with a 60% markup.
• This makes your estimated cost £31,250.
• If you sell £20,000 at retail, your estimated COGS is £12,500.
• Your estimated closing stock is the remaining cost: £18,750.

Because the retail method relies on assumptions rather than actual counts, the information is less reliable than other costing methods. That’s why stocktakes are especially important to confirm the real figures.

It’s best to consistently apply the same inventory method to ensure tax compliance and comparability across financial periods. Changing inventory methods for tax purposes generally requires filing Form 3115 with the IRS, as such changes can affect taxable income. Method changes are typically implemented at the beginning of a tax year.

Here’s more about inventory accounting and the different inventory accounting methods.

Set up stock control systems that work with POS

Modern POS systems and retail inventory management software can often be linked together to update stock levels whenever a product is sold or returned, giving you a snapshot of what’s left in stock. By syncing your POS system and retail inventory management software, you’ll get:

• accurate product data: all SKUs update automatically across your POS and accounting software
• stock levels: your in-store and ecommerce inventory updates instantly, so you’re unlikely to sell a product you no longer have in stock
• low stock alerts: your POS can warn you when stock falls below a preset level so you can reorder, and some systems can even trigger reorders automatically
• automatic COGS posting: your COGS is recorded each day without manual adjustments

For small retailers, these connections reduce manual reconciliation, cut admin time, and help you avoid missing sales by running out of stock.

Here’s more on how inventory management software can help you.

Maintain accurate digital records for stock and VAT

Because UK retailers must follow VAT rules – including Making Tax Digital (MTD) – accurate digital records are essential. When sales, stock movements, and VAT are captured correctly, you get a clear and reliable view of margins and overall business performance.

Carry out stocktakes regularly

Even with a reliable POS system, it’s normal for your actual stock levels to differ slightly from your records. Regular stocktakes help you keep your accounts accurate and catch issues before they become major problems.

• Run full stocktakes at least annually. Smaller spot checks throughout the year help keep your records tidy and reduce surprises at year end.
• Investigate the cause of discrepancies. It could be theft, breakage, spoilage, scanning errors, delivery mistakes, or even a POS setup issue.
• Record shrinkage and write-offs in your POS. This keeps your COGS and margins accurate and prevents errors rolling forward into future periods.
• Look for recurring problems with certain products or suppliers. Repeated issues can reveal weaknesses in your processes or a supplier’s quality control.

Accurate stock records give you a clearer view of your business’s performance and help you make better decisions around pricing and purchasing.

Here are more benefits of retail POS software for your business.

How to handle VAT in retail

Retail VAT can be complicated – a lot of transactions, differing VAT rates, discounts, and returns all add to the challenges of bookkeeping for a retail shop. Getting the setup right early on makes VAT easier to manage and means fewer headaches when it’s time to file.

1. Choose the right VAT and retail schemes

HMRC offers several VAT schemes for small businesses, and the right one depends on your turnover and what you sell. There are three main options:

• Standard VAT accounting: the default method – you charge VAT on sales and reclaim VAT on purchases. The amount owed is based on the invoice date, not when you receive the cash.
• Cash accounting scheme: this is similar to the standard scheme, but VAT is only due when the cash actually changes hands.
• Flat Rate Scheme (FRS): available to businesses with turnover under £150,000, you pay a fixed percentage of your gross sales based on your industry category – learn more about FRS. It’s a straightforward method but might not be suitable if you buy a lot of stock or sell zero-rated goods. You also can’t use the FRS with any of the retail schemes outlined below.

HMRC also offers three retail schemes for high-volume retailers who calculate VAT from daily gross takings instead of individual transactions:

• Point of sale schemes: Your POS identifies the correct VAT rate for each item sold and applies VAT at the till. This is the simplest option if your POS can track VAT per product.
• Apportionment scheme: You calculate VAT by splitting your total takings between VAT rates based on the proportion of goods you buy at each rate. This is only available to retailers who buy and resell goods, not service providers or manufacturers.
• Direct calculation scheme: Calculate VAT by estimating how many items you sold in each VAT category, based on their typical selling prices or markups, and then applying the correct VAT rate to those estimates.

Once you’ve chosen a scheme that fits your business, the next step is to make sure your systems record VAT accurately and can submit returns digitally.

2. Set up Making Tax Digital for retail

MTD applies to every VAT-registered business, regardless of turnover. MTD rules shape how VAT for retail businesses in the UK must be recorded and submitted.

MTD requires you to keep digital VAT records and file returns through MTD-compatible software. Using the right platform allows you to record sales and purchases digitally at source, apply VAT automatically, and submit VAT returns directly to HMRC. This improves accuracy and reduces compliance risk.

While HMRC requires digital record keeping and digital links between systems, connecting your POS, eCommerce platform, and accounting software also helps ensure transactions flow automatically. Your accounting software can then file your quarterly VAT return directly to HMRC.

This setup means there’s no need for manual overrides or to copy and paste information between documents or online forms. It makes VAT submissions far more reliable, reduces manual work, and cuts the potential for errors.

Here’s how to sign up to MTD.

3. Account for discounts, returns, and gift cards

Some types of transactions follow different VAT rules, so it helps to have a POS and accounting system that can handle every scenario.

• Discounts: VAT is calculated on the price paid, not the original selling price.
• Returns and refunds: no VAT is due on returned goods.
• Gift cards and vouchers: VAT is due when the gift card is redeemed, not when it’s sold. This is because the VAT due on the item purchased isn’t known until after the fact.

With the right POS, transactions are handled correctly the first time, meaning less admin for you and more accurate VAT submissions.

How to complete POS integration with accounting software

Connecting your POS to your accounting software gives you rapid, accurate sales data and reduces a lot of manual admin. There are three main things to do:

1. Map tax rates, tenders, tips, and surcharges

Set up your POS and accounting software so each type of transaction to the correct accounts, including VAT rates, payment methods, and any additional charges. Once everything is configured correctly, your POS will handle most of the work, with only a quick check needed to make sure totals match at the end of the day.

2. Automate daily sales and reconcile payouts

Set your POS to send a daily summary of sales, VAT, and refunds directly to your accounting software. As you make sales, card processors and ecommerce platforms deposit the funds into your bank in batches. With your POS and accounts connected, each payout is automatically reconciled and the chance of errors is reduced.

3. Consolidate in‑store and ecommerce sales

Bring all sales channels into the same accounting workflows so sales, VAT, fees and refunds feed directly and consistently into your accounts. Most modern POS systems support ecommerce accounting integration, helping prevent double counting and giving you a single, combined view of your performance at month end.

Which retail metrics, KPIs, and stock controls to monitor

Tracking important retail metrics helps you understand what’s selling, how your margins are shifting, and how much cash is tied up in stock. These are the essential numbers to follow:

Track gross margin and COGS

Gross margin shows how much profit you make after you deduct COGS. Checking it regularly helps you spot changes in supplier pricing, overuse of discounts or promotional pricing, or stock shrinkage.

Good POS and accounting software give you a clear view of margin and COGS by product, category, and channel, so you can see how each part of your business is performing.

Measure stock turn and sell‑through

Stock turn shows how quickly your stock is sold. A higher stock turn is usually better as it means lower storage costs, less risk of products becoming obsolete, and less cash tied up in stock over time.

Sell-through shows the percentage of stock sold over a period – useful for understanding how new ranges or seasonal lines are performing.

These metrics help you spot slow-moving lines early and make informed buying decisions.

Spot aged stock and set reorder points

Aged stock ties up cash and takes up space. Identifying which items are moving slowly helps you plan your next steps, whether that’s launching a promotion or phasing out those products.

Reorder points let you set alerts when stock drops to a set level so you can reorder – and some systems can even place reorders automatically when those levels are reached. This helps prevent lost sales if you run out of popular items.

Together, these controls are a key part of stock control for small businesses in the UK, helping you keep the right products in stock and maintain your cash flow.

Simplify retail accounting with Xero

Xero brings your POS, ecommerce platforms and accounting together, giving you a real-time overview of sales, stock, and cash flow. Xero’s accurate VAT mapping and automated stock tracking mean fewer manual tasks to manage and accurate, up-to-date records, giving you more time to grow your retail business.

Get one month free

FAQs on retail accounting

Retail accounting can be confusing. Here are some clear answers to common questions:

Is the retail method acceptable under UK standards?

Yes. The retail inventory method is allowed, but it’s best used for estimates only. To make sure your stock numbers are accurate, it’s a good idea to support them by doing stocktakes regularly.

Is LIFO allowed in the UK?

No. LIFO, isn’t permitted under UK GAAP or IFRS because it doesn’t reflect a realistic flow of goods and can distort reported profits.

How often should I run a stocktake?

Most retailers run a full stocktake at least once a year. You can also run smaller spot checks throughout the year to keep your records accurate and catch issues early.

Should I post individual receipts or a daily POS summary?

Daily POS summaries are best, as posting every receipt would clutter your accounts. Only record individual receipts for high-value or unusual transactions.

How do gift cards affect VAT?

It depends on the type of card. If it’s a general gift card, VAT is due when the card is redeemed because the VAT rate isn’t known until you see what the customer buys. But if the voucher can only be used for a specific item – a voucher valid only on coffee, say – then VAT is due at the point of sale because the rate is already known. This applies even if the voucher is never redeemed.

How do upfront deposits affect VAT?

It depends. Under invoice accounting, VAT is due when the invoice is issued, so the timing of the deposit doesn’t change the VAT point. But under cash accounting, VAT is due when payment is received – so apply VAT to the deposit paid upfront, and the remainder when the balance is received.

How do I reconcile merchant fees without cluttering my sales?

Record merchant fees separately by mapping them to a dedicated expense account. This keeps sales figures clean while making sure fees are deducted and reconciled correctly.