← All prebuilt solutions
Industry

Pub Stocktake & Wet/Dry GP

Stock usage, expected takings and stock result for the bar and kitchen – with gross profit on wet and dry sales

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Pub Stocktake & Wet/Dry GP

Overview

A stocktake tells you whether the money in the till matches the drink and food that went out. Done every four weeks it catches over-pouring, wrong prices and theft quickly, and shows whether your prices give the gross profit you need.

Price
£20
Who it’s for
Industry
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Stock

Opening stock, deliveries, closing stock and selling prices. What you do: enter at each stocktake.

Stock
Results

Step 2

Results

Expected takings, actual takings and the stock result. What you do: nothing to enter.

Step 3

Settings

Your business and period dates. What you do: fill in each period.

Settings

Step 4

Who it is for

Made for people like you

  • Example – text
  • Pubs and bars – Find losses from wastage, over-pouring or theft.
  • Restaurants and hotels with a bar – Track wet and dry GP separately.
  • Stocktakers – A clear stock result for each period.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – The stock period, takings from the till for the period, and the allowances.
  2. Stock – For each line, the cost, serves per unit and selling price (once), then each stocktake the opening count (last closing), deliveries and today's count.
  3. Results – The stock result for wet and dry, and gross profit against target.
  4. Next period – Save a copy, then move closing counts into opening and clear deliveries.

Key features

  • A full stocktake for a pub, bar or club: opening stock, deliveries and closing count for every line, with the cost of what was used.
  • Works out the takings the stock should have produced at your selling prices, allows for wastage, staff drinks and promotions, and compares it with actual takings – the stock result.
  • Shows gross profit for wet and dry sales against your targets, GP by category and how many weeks of stock you are holding.

What’s included

  • Dashboard – Results at a glance
  • Settings – Period, takings and allowances
  • Stock – Every stock line
  • Results – Stock result and GP
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions