Cellar Balance

A multi-bar outlet will typically be managed using a cellar ledger system - either a manual version or computerised. The ledger will contain details of every transfer of stock between the cellar and all of the bars. Instead of entering details using the Transfers option, you can use the Cellar Balance option to input the data directly from the cellar ledger.

If you have already collected deliveries totals and closing stock figures, these can also be entered onto the cellar balance screen. If so, you will be able to get an on-the-fly balance check.

Before the cellar balance screen is displayed, you will be warned that you should not mix the use of the cellar balance screen with the transfers, credits and purchases screens. This is because data entered on those screens may be lost if you start to type into the columns on the cellar balance screen.

  1. Type in the quantity of the Purchases
    or press Enter to skip to the Credits column.

  2. Type in the quantity of the Credits
    or press Enter to skip to the Closing Stock column.

  3. Type in the quantity of the Closing Stock
    or press Enter to skip to the Breakages column.

  4. Type in the quantity of the Breakages
    or press Enter to skip to the Transfers column.

  5. Type in the quantity of the Transfers for each of the bars

    After the last bar, you will be able to continue with the Purchases for the next product.

    If the balance message is ticked, you may receive a warning message if the cellar does not balance for the product you just completed.


The Display All button allows you to display all products. The alternative (the default) is to display only the live products in the cellar. Once clicked, the button will change to show Display Live.


The Next 10 button allows you to view the issues to the next 10 bars. This button will only be available if there are more than 10 bars in the outlet, and you are not already showing the final 10 bars.


The Previous 10 button allows you to view the issues to the previous 10 bars. This button will only be available if there are more than 10 bars in the outlet, and you are not already showing the first 10 bars.


The Balance Message tick box allows you specify whether the a warning message is displayed if the cellar does not balance for each product. It will be displayed once you have entered the issues to the last bar.


To Find a Product press Control-F8 (the control key and the function key F8).

You will be prompted to type in the characters or numbers you wish to find.
You will be able to find product code, description, cost, etc.

Type them in and press Enter.

If the product found is not the one you want, you can find the next occurrence of the characters by pressing Control-F9.

You will not be prompted for the characters and the next product found will be highlighted.


Click on the Close button to return to Data Entry.


Back to Contents