Skip to content
Triniteq Support

System programming · Guide

Running a stocktake in PowerEPOS Stock

Start, count and finalise a full or ad-hoc stocktake in the PowerEPOS System Manager, including counting in other sizes and checking variances before stock levels are updated.

PowerEPOS + Stock

Running a stocktake in PowerEPOS Stock

Stocktakes in PowerEPOS Stock V2

Stocktakes are run in the PowerEPOS System Manager. You can start one ahead of time, or date it back to when the count was actually done, so stock levels and variances are accurate.

In this guide

  • StartBefore you start
  • 1Open Stocktakes
  • 2Start a new stocktake
  • 3Choose which ingredients were counted
  • 4Choose when the stock was counted
  • 5Choose the stock categories, then start
  • 6Enter your counts
  • 7Count in a different size, if needed
  • 8Check the Valuation, Summary Report and Discrepancy Report
  • 9Finalise the stocktake
  • 10Save or email the reports
  • 11Need help?

Start

Before you start

  • Access to the Stock Management console in the PowerEPOS System Manager.
  • Your counts, either written on a count sheet or in a .CSV file with the PLU number and stock count for each item.

Step 1

Open Stocktakes

In the System Manager, click Stock Management, then click Stocktakes in the Stock section.

The Stock Management console with the Stocktakes tile highlighted in the Stock section
The Stocktakes tile in the Stock section.

First stocktake at a venue

If this is your first count, you can click Set Initial Stock on the bottom bar of the Stocktakes screen. You can also do your first count as a normal stocktake: it works the same way, there is just no comparison data shown.

The bottom left of the Stocktakes screen showing the Show Finalised and Show Deleted toggles above the Set Filter and Set Initial Stock buttons
The Set Initial Stock button, with the Show Finalised? and Show Deleted? toggles above it.

Step 2

Start a new stocktake

The Stocktakes screen lists every stocktake in progress. Turn on Show Finalised? or Show Deleted? to review earlier stocktakes.

  1. Click New on the bottom bar.
  2. If you have more than one outlet, select the outlet you are counting and click Select.
The Stocktakes screen listing one ad-hoc stocktake for the Brisbane outlet with the status In progress
Stocktakes in progress, with New on the bottom bar.
The Select an Outlet window listing the outlets under Domain Group, with Brisbane highlighted
Choose the outlet you are counting.

Step 3

Choose which ingredients were counted

Under Which ingredients were counted? on the Starting a new Stocktake screen, choose one:

  1. Full Stocktake: counts every qualifying item. Use it for a full inventory count.
  2. Ad-hoc Stocktake: only changes the stock items you enter a count for. Use it when you only need to update a few items.
The Starting a new Stocktake screen for the Brisbane outlet with Full Stocktake selected, a single count date and time set, and Draught Beer ticked under Beverage
A full stocktake of Draught Beer, counted at one point in time.

Uncounted items in a full stocktake become zero

When a Full Stocktake is finalised, any item with no count is treated as 0 and its stock level is set to 0. If you are only counting some items, use Ad-hoc Stocktake.

Step 4

Choose when the stock was counted

Under When should the stock be counted?, choose one:

  1. Record all counts using a single specified point in time: set the date and time, or click Now. The stocktake only uses stock and sales data from the last stocktake up to this date and time.
  2. Each stock item has its own recorded time of count: use this when items were counted at different times. You enter the date and time against each item on the sheet as you count it.

Step 5

Choose the stock categories, then start

Under Which ingredients will be counted?, tick the stock categories you are counting. The stocktake only uses data for, and only updates stock levels in, the categories you tick.

  1. Expand a category to tick only some of its groups, for example Draught Beer under Beverage.
  2. Use the search box to find a category by name.
  3. When all the settings are correct, click Start to generate the stocktake sheet.

The stocktake sheet fills in automatically with these columns:

  • PLU and Description.
  • Size: the stocktake size.
  • Unit Cost: the cost of one stocktake size.
  • Opening Stock.
  • Received: through purchases.
  • Sales: through the POS.
  • Transfers: between stock locations.
  • Wastage: through the POS and Stock.
  • Mixed: manual mixes made in Stock.
  • Additional Mixing: automatic mixes triggered by sales in the POS.
  • Mix Consumption.
  • Expected Stock.
  • Count, Variance and Variance Cost.
A new ad-hoc Brisbane stocktake sheet listing four draught beers with empty Count cells, the Rev button at the top right and the toolbar along the bottom
A new stocktake sheet, before counts are entered.

The bottom bar of the sheet has these tools:

  • Refresh: picks up any changes made since the sheet was opened that affect this stocktake.
  • Show Deleted: shows items that have been removed from the sheet.
  • Valuation: shows the total cost of the items against their standard portion size.
  • Count Sheet: a printable sheet to write the count for each item on.
  • Summary Report: a quick summary of the sheet, with variances and their percentage against cost.
  • Discrepancy Report: the items with a variance, for review.
  • Auto Mix: creates a standard mix batch based on expected stock levels.
  • Stocktake: reopens the setup screen to change the counted ingredients or the stocktake type.
  • Finalise: finalises the stocktake.
  • Import Count: imports counts from a .CSV file on your PC instead of typing them in.
  • New: starts a new stocktake.

Step 6

Enter your counts

Enter your counts in one of two ways:

  1. Type each count into the Count column. Variance and Variance Cost update as you go.
  2. Click Import Count and choose a .CSV file with the PLU number and stock count for each item.
The stocktake sheet with counts entered in the Count column and the variance and variance cost shown for Peroni and Cooper's Ale
Counts entered, with the variances calculated.

Step 7

Count in a different size, if needed

If you counted an item in a size other than its standard stocktake size (kegs instead of litres, for example), enter it in that size and the system converts it to the standard size for you.

  1. Hover over the item's Count cell and click the popup button that appears.
  2. In the Enter Count window, type the count against the size you counted in, for example Keg (50).
  3. Check the Total at the bottom, then click outside the window to finish.
  4. Back on the sheet, the count shows with an asterisk in front of it. The asterisk means the count was calculated from a size other than the standard stocktake size.
The Enter Count window for Cooper's Ale with 2 entered against Keg (50), giving a total of 100 litres
Two 50 litre kegs entered, totalling 100 litres.

Step 8

Check the Valuation, Summary Report and Discrepancy Report

Use these reports to spot errors before you finalise. For each variance, either correct the cause or ignore it if the reason is known.

  1. If a variance is caused by a missing or incorrect mix or wastage entry, back-date the correct mix or wastage, then click Refresh on the sheet.
  2. If an item's stocktake size is wrong, fix the Stock PLU and publish it. Then click the yellow Rev button at the top right of the sheet and update to the latest revision. The size and cost correct themselves.
The yellow Rev 445 button at the top right of the stocktake sheet
The revision button on the stocktake sheet.

Step 9

Finalise the stocktake

Once you are happy with the stocktake, click Finalise, then click Yes on the prompt. Stock levels are updated to match the counts.

The Confirm prompt asking whether you are ready to finalise the stocktake, with Yes, No and Cancel buttons
Click Yes to finalise.

Review every variance first

Finalising adjusts stock levels to match the counts entered. Once finalised, the next stocktake takes its data from this stocktake's date onwards.

Step 10

Save or email the reports

After finalising, open the Valuation, Summary Report and Discrepancy Report and download or email them as PDFs for your records.

Step 11

Need help?

Triniteq support

Our support team is here to help.

Call 1300 784 276 or email support@triniteq.com, and include your venue name so we can find your setup straight away.

Still stuck?

Send us the details and the Triniteq support team will pick it up.