Small Business Bookkeeping, VAT & Margins: The Basics for New Shop Owners

Most people who open a shop do it because they know retail, not because they enjoy paperwork. But small business bookkeeping is the part of the job that decides whether the shop actually makes money, and whether you find out in time to do anything about it. Get it right and you know your margin on every line, you know what VAT you owe before the bill lands, and you know which shelves are earning their keep.

Get it wrong and you trade for a year on gut feel, then discover at the accountant's office that a third of your range was selling at a loss once VAT and delivery were counted properly.

This guide covers the basics for new shop owners in the UK: what records you need, how VAT works when you buy wholesale and sell retail, how to calculate a real margin rather than a flattering one, and the simple monthly routine that keeps it all under control. We are wholesalers, not accountants, so treat this as a plain-English starting point and take formal advice from a qualified accountant or HMRC before you make decisions about your own tax position.

Small Business Bookkeeping: What It Actually Means for a Shop

Small business bookkeeping is simply the habit of recording every pound that comes into the business and every pound that goes out, in a way you can prove later. That is it. The accounting, the tax returns and the clever advice all sit on top of that foundation, and none of it works if the foundation is a carrier bag of receipts under the till.

For a shop, the records break down into a short list:

• Sales: your daily till readings, card machine settlements, and any online marketplace payouts.
• Purchases: wholesale invoices, cash and carry receipts, anything you bought to resell.
• Overheads: rent, business rates, utilities, insurance, card machine fees, EPOS subscriptions, waste collection, accountancy fees.
• Staff: wages, PAYE, National Insurance and pension contributions if you employ anyone.
• Stock: what you were holding at your year end, valued at cost.
• Bank: statements for every business account and card the shop uses.

The single biggest favour you can do yourself on day one is to open a separate business bank account and run everything through it. Mixing personal and business spending is the most common reason a new shop owner spends three weekends untangling a year of transactions instead of trading.

Setting Up Your Books: The Records Every Retailer Needs

You need to be able to answer three questions at any point in the year: what did I sell, what did I pay for it, and what do I still owe. Build your system around those.

Start with a filing routine rather than software. Every purchase invoice gets photographed or saved the day it arrives, filed by supplier and month. Every till Z reading gets recorded daily, not weekly. Every card settlement gets matched to the day it relates to, because the money lands in your account a day or two later and that gap is where reconciliation errors breed.

A few practical rules that save hours later:

• Record gross sales and any till discrepancies separately, so shrinkage shows up as a number rather than hiding inside a lower takings figure.
• Keep delivery charges with the invoice they belong to, so landed cost is easy to work out later.
• Note the payment method on every purchase. Cash purchases at a cash and carry are the ones most likely to go unrecorded, and they are pure lost tax relief when they do.
• File credit notes and returns against the original invoice, not on their own.
• Keep your records for the period HMRC requires. Check the current retention rules on GOV.UK, because they differ for sole traders and limited companies.

If you are buying from one main supplier, this gets a lot easier. A single monthly statement covering all your orders beats twenty scattered receipts from four different cash and carries. That is one of the quiet advantages of consolidating your core range of best sellers with fewer suppliers: your bookkeeping shrinks along with your admin.

VAT for Small Business: The Basics Every Shop Owner Should Know

VAT is where most new shop owners get caught out, usually because they compare a wholesale price that excludes VAT with a retail price that includes it and think the margin is far better than it is.

Here is the shape of it. If your business is VAT registered, you charge VAT on the things you sell that are standard rated, and you reclaim the VAT you paid on the things you bought. You pay HMRC the difference. If you are not registered, you cannot charge VAT and you cannot reclaim it, so the VAT you pay your wholesaler is simply part of your cost.

Three things determine whether registration applies to you:

• Your taxable turnover against the current VAT registration threshold. The threshold changes from time to time, so check the current figure on GOV.UK rather than relying on a number you read in a forum.
• Whether you choose to register voluntarily. Some retailers do this to reclaim VAT on setup costs and stock, even below the threshold.
• Which VAT scheme suits you. Standard accounting, cash accounting, annual accounting and the flat rate scheme all exist, and they suit different shops. This is a genuine accountant question, not a guess.

The detail that matters most in a convenience or discount shop is that not everything you sell carries the same VAT rate. Household cleaning products, toiletries, air fresheners, confectionery and soft drinks are treated differently from most basic foodstuffs and from children's clothing. Your EPOS needs to know the correct rate for each product, because if it does not, your VAT return will be wrong in a way that is very hard to unpick after the fact.

Reading a Wholesale Invoice Properly

Wholesale prices in the UK trade are almost always quoted excluding VAT. Retail prices are almost always quoted including VAT. If you forget that, every margin you calculate will be flattering and wrong.

So build the habit of always comparing like with like. Take the invoice price excluding VAT, add the share of delivery that applies to that line, and you have your landed cost. Take your shelf price, strip out the VAT if the item is standard rated, and you have your net selling price. The gap between those two numbers is your real gross profit.

Our own terms are a useful worked example: the minimum order is 250 pounds plus VAT, and UK delivery is free on orders over 750 pounds plus VAT on our own fleet. Those figures are quoted net because that is how trade pricing works. If you are VAT registered, the VAT you pay on that invoice comes back to you on your return, so your true cost is the net figure. If you are not registered, the VAT is a real cost and belongs in your landed cost calculation.

Delivery is the line most new retailers forget. A small order with a carriage charge can wipe out the margin on a whole case. Consolidating into fewer, larger orders to clear a free delivery threshold is one of the simplest margin improvements available to a small shop, and it shows up immediately in the books.

Margins: The Number That Tells You If the Shop Works

Margin and markup are not the same thing, and confusing them is the second great trap after VAT.

Markup is the percentage you add to your cost. Margin is the percentage of your selling price that is profit. Buy something for one pound and sell it for two, and you have applied a 100 per cent markup but earned a 50 per cent margin. Both numbers are true, but only margin tells you what share of your takings you keep.

The formulas are short enough to memorise:

• Gross profit = net selling price minus landed cost.
• Margin percentage = gross profit divided by net selling price, multiplied by 100.
• Markup percentage = gross profit divided by landed cost, multiplied by 100.
• Selling price from a target margin = landed cost divided by (1 minus the margin as a decimal). For a 40 per cent target on a 3 pound cost, that is 3 divided by 0.6, which is 5 pounds net.

Work an example through with VAT included. Say you buy a case of twelve for 18 pounds net, which is 1.50 per unit. You sell each unit at 2.99 including VAT. At a 20 per cent standard rate, the net selling price is 2.99 divided by 1.2, which is 2.49. Your gross profit is 0.99 per unit and your margin is roughly 40 per cent. Price the same item at 2.49 on the shelf and your net price falls to 2.07, your profit to 0.57 and your margin to about 27 per cent. Same product, same supplier, a very different shop.

This is also why clearance and deal lines are worth watching closely. A short-dated or end-of-line buy can carry a much better margin than your regular range, but only if you sell through it before it ages. Margin you never realise is not margin.

Branded Versus Own Label in the Numbers

Bookkeeping makes the branded versus own-label argument concrete rather than theoretical.

Recognised brands sell themselves. Customers know what they should cost, which caps your price and therefore your margin, but they turn over quickly and they bring people through the door. Own-label and value lines carry no price expectation in the customer's head, so they usually earn a better percentage margin, though they need the branded lines nearby to give shoppers a reference point.

Most shops that work well run both. Our own brands sit in that second category: Max Flush in household, Perfect Scents and Lu Mist in air care and fragrance, and Eight Triple Eight in personal care, alongside stocked names such as Yankee and Febreze. In the books, the pattern to look for is simple. Branded lines should be earning their space through volume, own-label lines through percentage margin. Any line doing neither is a candidate for delisting when you review your range.

Stock, Cash Flow and Why They Are Not the Same as Profit

A shop can be profitable on paper and still run out of money. That happens because stock is cash sitting on a shelf, and bookkeeping is how you see it.

Two habits protect you. First, count your stock properly at least once a year and ideally more often, valued at what you paid rather than what you hope to sell it for. That figure feeds your accounts and tells you how much of your working capital is tied up. Second, track your rate of sale by line so you can tell fast movers from slow ones. Twelve weeks of cover on a slow seller is money you cannot spend on the lines that actually turn.

Practical points for a small shop:

• Buy deep on proven lines, shallow on new ones. Test a case before you commit to a pallet.
• Match order frequency to shelf life and rate of sale rather than ordering everything on the same cycle.
• Watch the seasonal peaks. Money committed to seasonal stock in September is money you cannot use in October.
• Review newly listed lines after four to six weeks and be honest about the ones that have not moved.

Software, Spreadsheets and Making Tax Digital

You do not need expensive software to start, but you do need something you will actually use every week.

A well-built spreadsheet is perfectly adequate for a single small shop in year one: one tab for daily takings, one for purchases, one for overheads, one for a simple margin calculator. The moment you are VAT registered, though, digital record keeping and digital filing requirements apply under Making Tax Digital, and the rules have been extending to more businesses over time. Check the current position for your business type on GOV.UK, and pick software that is compatible before you build a system you then have to rebuild.

Whatever you choose, look for a few features that genuinely save shop owners time: bank feed reconciliation, receipt capture from your phone, VAT rate handling per product category, and an export your accountant can open without complaint. Integration with your EPOS is a bonus rather than a necessity at small scale.

A Simple Monthly and Quarterly Routine

Bookkeeping fails when it becomes a quarterly panic. Break it into a rhythm instead.

• Daily: record takings, file the day's purchase invoices, note anything unusual while you still remember it.
• Weekly: reconcile the bank, chase any missing invoices from suppliers, check card settlements match your till.
• Monthly: review margin by category, check your top twenty and bottom twenty lines by sales, look at overheads against last month, put aside the money you expect to owe in VAT and tax.
  • Setting VAT aside in a separate account as you go is the single habit that stops a quarterly bill becoming a crisis.
• Quarterly: prepare and file your VAT return if registered, count stock on your fastest-moving categories, review supplier pricing.
• Annually: full stock count, year-end accounts with your accountant, a proper range review.

The monthly margin review is the one that changes behaviour. Once you can see that a category is running at 22 per cent when you assumed 35, you buy differently the next time.

Common Bookkeeping Mistakes New Shop Owners Make

• Comparing a net wholesale price with a gross retail price and believing the margin.
• Ignoring delivery and carriage when calculating landed cost.
• Treating cash purchases as too small to record, then losing the tax relief on all of them.
• Using one VAT rate across a mixed range because the EPOS was set up in a hurry.
• Confusing turnover with profit, and drawings with wages.
• Leaving stock valuation to the accountant at year end instead of counting it themselves.
• Not putting VAT aside monthly, then borrowing to pay a bill they always knew was coming.

None of these are complicated to fix. They are just easier to fix early than late.

When to Bring in an Accountant

Do your own day-to-day bookkeeping and pay a professional for the judgement calls. An accountant earns their fee on the decisions: sole trader or limited company, which VAT scheme, how to handle a vehicle, what counts as an allowable expense, how to structure things as you grow. Those decisions have real money attached and the wrong answer compounds.

Come to that first meeting with clean records and you will pay less for better advice. Come with a shoebox and you will pay someone a professional rate to do data entry.

How Your Wholesaler Can Make the Books Easier

The supplier you choose affects your bookkeeping more than most retailers expect. When you are comparing wholesalers, ask about the things that show up in your accounts, not just the price list:

• Are prices quoted clearly excluding VAT, with VAT shown as a separate line on the invoice?
• Is there a realistic minimum order, so you can buy in sensible quantities rather than committing thousands in one go? Ours is 250 pounds plus VAT.
• What does delivery cost, and at what point does it become free? Ours is free on UK orders over 750 pounds plus VAT using our own fleet.
• Is the range wide enough to consolidate your buying, so you are handling fewer invoices? We hold over 600 lines across household, toiletries, fragrance and home care in a 40,000 square foot warehouse in Nelson, Lancashire.
• Can you get proper documentation quickly when your accountant asks for a copy invoice?

Northern Marketing has been supplying independent retailers since 2009, and clean paperwork is part of the service rather than an extra. Fewer suppliers, clearer invoices and a predictable delivery cost make the difference between books you dread and books you can keep on top of in an hour a week.

Getting your numbers straight starts with knowing exactly what your stock costs you. Talk to the NMS team about opening a trade account, clear net pricing and consolidating your buying, on 01282 788 685 or enquiries@nmarketing.co.uk, Monday to Saturday 9am to 5pm.