Loading GST Billing Software
header image

Free Download - Bar Inventory Management (Liquor) Software

Erachana Line

An Inventory Management Solution for Liquor Shops including Daily Stock Management for all types of liquors and various Stock Reports.


Bar Inventry

Bar Inventory is an Inventory Management Solution for Liquor Shops by ERachana Technologies. Using the Bar Inventory Application, you can have effective inventory control of your bar.

Bar Inventory is helpful to Liquor shops to keep track of Liquor in their Bars effectively. You can store details of various Categories of Liquor according to the Brands and items. You can make stock entries of Inward and Outward Stock. Also, you can obtain summarised and detailed item-wise inward and outward stock reports, Running Balance and other reports.


You can use the Bar Inventory Application to keep accurate inventory control of your bar by maintaining Inward and Outward Stock details and restock your beer, wine, spirits and malt liquor etc. in a timely manner. By having all your inventory reports at your fingertips, you can easily aggregate the data to better understand how long an item lasts and when to order, ensuring you are never out of stock of your customers' favourite alcoholic beverages..


Bar Inventory application also helps you understand and monitor the performance of your bar sales by determining exactly how much liquor stock your bar had at the beginning of your inventory period, and at the end of the inventory period and hence derive your inventory usage. This application is designed for those who are involved in inventory management at wineries, liquor stores, restaurants and need to keep up-to-date inventory records for their Bars.






Features

  • • Stock Details
  • • Statistics of Sales or Purchases by Day/Week/Month/Year
  • • Item-wise Reports
  • • Accurate Stock Control





How to use ERachana's Bar Inventory Application?


Installation

ERachana’s Bar Inventory Application can be installed in the same way as any other standard windows application. Download, Install and Register the Bar Inventory Application from our website www.erachana.net. Installation & Registration are explained in Detail in other videos.

After registration, create a New File and enter Masters Details.





Create Masters

Masters are used for storing various master details. The Masters can be accessed from the Masters menu.



Enter Liquor Categories in Category

First, different categories of Liquor Beverages like Rum, Whiskey etc. are entered in Category Master.

To enter Categories, in Masters, click Category. In the window that opens, enter Display Number, Category Name and click Save.



Enter Liquor Brands in Brand

The names of different liquor beverage brands sold in the Bar are entered in Brand in Masters menu.

To enter Brands, in Masters menu, click Brand. In the window that opens, enter Brand Name and click Save.



Enter Items in Item Master

The details of items available in the Bar are entered in Item Master according to the Category, Brand, Quantity, Price and Opening Stock.

To enter Item details, in Masters, click Item Master. In the window that opens, enter Category Name, Brand Name, Quantity, Price and Opening Stock. Click Save to save the details.







Stock Entry

It is important to keep track of Inventory while running your Bar to take stock control and ensure profitability.

In Inward Stock Entry, enter stock as and when it is purchased, or at regular intervals like Daily, weekly or monthly and in Outward Stock, enter details of stock sold.

Inward Stock Entry

To enter Inward Stock details, in Stock menu click Inward Stock.



In the window that opens, enter In Date. Select Item Name, Amount, and enter Inward Stock in Stock In and click Save.



Bulk Stock In Entry

To make entries of Inward Stock of multiple categories at the same time, select Bulk Stock In in Stock menu.



In the window that opens, enter Date, Filter, and select Category if needed. Then click List.



The details of categories are populated in the grid. You can enter details of stock received in REC and the Total for the same gets updated in the Total column. Click Save to save the details.



Outward Stock Entry

To enter Outward Stock details, in Stock menu click Outward Stock.



In the window that opens, enter Out Date. Select Item Name, Amount, and enter Inward Stock in Stock Out and click Save.



Bulk Stock Out Entry

To make entries of Outward Stock of multiple categories at the same time, select Bulk Stock Out in Stock menu.



In the window that opens, enter Date, Filter, and select Category if needed. Then click List.



The details of categories are populated in the grid. You can edit and enter details of Sales in Sales column in the grid and the closing Balance for the same gets updated in the CB column, and amount also gets updated. Click Save to save the details.







Reports

Various useful reports are available in Bar Inventory to keep track of Liquor Stock Movement in your Bar.

You can track item-wise stock in Item Report. You can view summarised or detailed and item-wise inward and Outward Stock in Inward Stock Report and Outward Stock Report. The Running Liquor Stock Balance in your Bar can be seen in Running Stock Balance. The Excise Report for a given date can be seen in Excise Report.

By using these reports, you can easily order items when the stock is low, know how your investment is used and even find which items are most or least in demand.

Item Report

To generate Item Report, click Item Report in Reports menu.



In the window that opens, select liquor item Category, Brand, or Item name and click List.
Item Stock Details Report is generated in the Grid.



Inward Stock Report

To generate Inward Stock Report, click Inward Stock Report in Reports menu.



In the window that opens, select liquor item Category, Brand, or Item name. You can select other criteria like Quantity of Stock In, Amount, Stock In Date etc. and click List.



Inward Stock Report is generated in the Grid.

Outward Stock Report

To generate Outward Stock Report, click Outward Stock Report in Reports menu.



In the window that opens, select liquor item Category, Brand, or Item name. You can select other criteria like Quantity of Stock Out, Amount, Stock Out Date etc. and click List.



Outward Stock Report is generated in the Grid.

Running Stock Balance

You can see the Stock Balance for a day, month or year or any other interval in Running Stock Balance.

To see the Stock Running Balance, click Running Stock Balance in Reports menu.



In the window that opens, enter From and To dates and click List.



You can see the summary in the bottom of the grid. To export the report to excel, click Report button, to generate an editable excel report.



Excise Report

You can see the Excise Report of various liquor categories, for the selected date in Excise Report.

To see the Excise Report, select Excise Report in Reports menu.



In the window that opens, enter Start Date and click List.



You can see the details in the grid. The total sales and total purchases for different item categories can be seen at the bottom of the screen. You can click Report button to export the report to an editable excel file.



Note : All the reports mentioned above can be exported to an editable excel file by clicking the Export/Report button in the respective windows.



Release Notes

Version 1.0.0.0 New Release 26 /2/2018

1. Allows Stock Management

2. Allows Category-wise Bulk Stock entries

3. Allows users to view Statistics of Sales or Purchases by Day/Week/Month/Year

4. Allows users to view item-wise inward and outward stock Reports

5. Allows users to view Running Balance and Excise Reports.