What is the process for hotel financial and beverage reports?

In the hotel, there are drink bills coming in and out every day. What is the process for the drink report? Here is a list of drinks in and out, I hope it will be helpful to you. 01

First create a new worksheet on the computer desktop. 02

Click to enter the blank worksheet. 03

Then set up a table in the blank form, which can also be customized. I made a title titled "Drink In and Out Table". You can also make it according to my format. (As shown in the picture) 04

After setting up the form, fill in the "product name", "last month's inventory", "in" and "out", and "this month's inventory". Here I only make it until the 5th. As a demonstration, everyone can do it from the 1st to the 30th. 05

Fill in the name of the drink in the box under "Product Name". 06

Then fill in the drinks in stock last month. 07

Then fill in the wine collection list written by each department. Fill it out on which day it is. The same goes for the purchase of goods. Fill it out clearly. (As shown in the picture) 08

After filling in the details, enter the formula below in the box under "This month's inventory", and then click the Enter key. The formula entered here is "last month's inventory" and the daily import and export quantity is equal to "this month's inventory". 09

Then change the cursor to the ?+? icon, pull down the formula, and all the drinks this month will be calculated. 10

This is the process of hotel financial and beverage reports. Isn’t it simple and clear?