Restaurant Excel Spreadsheets Download

1)Tracking Employee Attendance and restaurant schedule management sheet : Loved it
There are two sheets one shows profit and loss summary and the other one is related to labor.Weekly opening hours,then labor compliment i.e the payment you pay for per hour to the employee,most of the things are calculated automatically such at the labor costs and total weekly labor schedule, you have to fill in data related to weekly opening hrs in p&l summary sheet. Both of the sheets share data so you have to be careful while filling data. It is not so typical once you understand how things work.

 

2) This schedule sheet is a bit simple than the above. One can simply create a daily schedule by inserting the number “1” or “.5” in each cell to indicate if an employee is to be scheduled a full or half hour  in the that time slot. You can change the estimated payroll tax and benefits that are added up to 15 percent to make it look realistic labor total.

3) Cost of Goods sold : Keeps a check on the spending and compare it with the sales.

4) Restaurant Suppliers check and backroom inventory control sheet : It can work well for small hotels also.It consist 4 different sheets to track purchases and credits information along with total department sales, the other backroom inventory cost along with supplies and retail inventory management sheet.

5) Running inventory sheet : Multi-purpose sheet for restaurant

6) Inventory : This first one is a simple restaurant inventory management sheet that means it is a a sample sheet, with very less automated calculations on its own.If your restaurant is a veg one than you have to change the entire items.Simple to handle and understand one can also add it to one drive or take a print out.

 

More spreadsheets includes

• https://freespreadsheet.net/2014/08/restaurant-inventory-spreadsheet-excel.html
• Hotel Cum Restaurant Report Template
• Managing rsetaurant finances