Restaurant Cash Control Forms and Spreadsheets

Does your business have continuous cash shortagesAre you unable to determine why you are short money?  The key is accountability!

The restaurant cash control forms and spreadsheets will help ensure your cash is going to the appropriate places and not getting lost in the shuffle.

restaurant cash control forms and spreadsheets


Go to
Restaurant forms to view all of our forms, quick reference charts, checklists and spreadsheets. Our forms were designed by individuals how worked for many years in the restaurant industry specifically corporate restaurant where system are proven to work.

 

If you do not see a specific restaurant form or spreadsheet here we can create one from scratch.  We also can customize any forms, spreadsheets that will fit your unique needs and budget.

 

Restaurant Spreadsheets

You'll find all the spreadsheet systems below. We take pride in our quality and value to the customer. We know restaurants and have developed these based on our experiences and input from restaurant owners. If you have ideas on what would help you please call us at 1+(717) 774-3698 or 1+(800) 753-0657. We would love to work with you on what you need for your restaurant.


Description

Images


Food Costing Tool Spreadsheet


This is a valuable food costing tool, why?
It’s all about the profit margin, you can’t guess what you want your prices to be at on your menu. Every ingredient in a specific menu item has a price attached to it. This price is what you paid for it from your purveyor.

Price out your whole menu for a better profit margin


more information



Restaurant Spreadsheet #Excel-018



View Larger Image

Add to Cart


$19.99



Restaurant Server Cash Checkout Spreadsheet


This is an excellent spreadsheet for total cash accountability. Do you have a way to record or checkout your servers cash at the end of their shifts? Well you do now, use the restaurant server cash checkout spreadsheet every time when your servers are ready to cash out with you or the manager. Simple to implement and use. This spreadsheet contains formulas that automatically calculate based on what you enter into the spreadsheet. This spreadsheet is completely accurate and safe to use.

At the end of each servers shift simply print out the servers closing summary report and enter the necessary information directly off the servers summary report on to the servers cash out spreadsheet. This system is a fantastic record system. Record up to 1 full month of activity.


more information



Restaurant Server Cash Checkout Spreadsheet #Excel-016



View Larger Image

Add to Cart

$19.99



Turnover Calculator Spreadsheet


Use the turnover calculator spreadsheet to find out the percentages of high turnover rates in your restaurant. High turnover can be very costly. Once you know what your turnover percentage is, then you can begin in creating an action plan in reducing the turnover cost.


more information



Restaurant Spreadsheet #Excel-017


View Larger Image View Larger Image

Add to Cart


$9.99



Restaurant Profit and Loss Spreadsheet


Two Page Document


A profit and loss statement (P&L) is a financial statement that summarizes the revenues, costs and expenses incurred during a specific period of time, usually a Monthly, fiscal quarter or year.

This profit & loss (P&L) is a monthly spreadsheet.

Let’s talk about food cost, it is recommended to do food inventory weekly opposed to monthly.

By doing food inventory weekly, you will be able to pinpoint areas of opportunities (missing food) and you will be able to react or correct the loss before it becomes a bigger problem. The longer you wait (monthly) the more money you lose.

At a glance you will be able to find out where your money is going and how much you are gaining or losing.

How does the spreadsheet work?
Colored shaded cells are protected: These cells contain formulas from various areas in this spreadsheet. By protecting these colored cells will elevate the chance of overwriting the formulas. Enter all monthly figures. Know where you stand on percentages and net profit & loss.
system.


more information




Restaurant Spreadsheet
Excel-014
Page 1



Profit and Loss View Larger Image



Restaurant Spreadsheet
Excel-014
Page 2


View Larger Image

Add to Cart
$19.99

WAS $24.99
For a Limited Time $19.99


Restaurant Prime Cost Spreadsheet


Knowing your restaurant numbers is critical, understanding the numbers is key. The two largest slices of the restaurant financial pie is food and labor cost. You need to physically monitor food and labor cost and be able to react to numbers the are considered out of wack.
Don't another moment buy this spreadsheet today and learn what numbers need attention.


more information



Restaurant Excel Spreadsheet #Excel-015



View Larger Image

Add to Cart

$19.99



Restaurant Alcohol Vendor Form


Are you tired of not knowing how much alcohol inventory you have on hand in your restaurant? Track how much alcohol is delivered to your restaurant.

Use this form to record your alcohol deliveries. File the form in the office for later use.

The manager on duty before they are done with the shift should record any deliveries for the day on to the alcohol vendor form. This saves time and money because you don't have to record a weeks worth of information at one time on to the form.


more information



Restaurant Form #F-039


restaurant alcohol vendor form View Larger Image

Add to Cart

$2.99



Register Till Start Up Fund Count Form


This is an excellent form for total cash accountability. Cash drawers start off with a cash start up fund in each register till. Each till needs to be verified by the managers on each shift to ensure the beginning drawer funds are correct. Using this form consistently and correctly may help reduce revenue loss. There needs to be some sort of cash control procedures and policies in place in any business to help organize and implement changes that are needed to move the business forward. Using this form will diffidently keep people honest and accountable in their actions.

more information



Restaurant Form #F-053


View Larger Image

Add to Cart
$2.99

WAS $4.99
For a Limited Time $2.99
A $2.00 Savings




Restaurant Server Cash Checkout Form


This is an excellent form for total cash accountability. Restaurant Server Cash Checkout Form is vital for employee cash accountability. Use this form when your server or cashier is done with their shift. Simply print out the form and cut out the 4 worksheets, then print out their close out summery report. Enter the pertinent information, once entered you will be able to collect the right amount of cash owed to the restaurant or bar. If you are collecting money from a cashier you will also know if they or over or short.

more information



Restaurant Form #F-066


View Larger Image

Add to Cart
$4.99




Cash Register Audit Form


This is an excellent form for cash control accountability. Are you having cash control issues? Are you constantly experiencing cash shortages or overages?

Use the Cash Register Audit Form to reduce or eliminate shortages or overages. Any manager or employee is in in direct contact with money should be periodically audited. If a shortage or overage occurs, the manager or employee needs to be held accountable.

Another great tool is the employee write up form:


more information



Restaurant Form #F-053


View Larger Image

Add to Cart
$3.99




Cash Shortages Damaged Property Lost Property Stolen Property Agreement Form


The cash shortage, damaged , lost or stolen property form is an excellent way to hold your employee accountable for their cash shortages damaged, lost or stolen property.

The use of this form is crucial in recouping cash shortages, damaged, lost or stolen property. from your employees.

During the hiring process have all new hires or existing employees sign this form. File the form in the employees file for safe keeping.


more information



Restaurant Form #F-059



Cash Shortages Damaged Property Lost Property Stolen Property Agreement Form


View Larger Image

Add to Cart

$3.99





Restaurant Form #Excel-010A


cash-till-balance-sheet

View Larger Image

Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Time Keeping System - 20 Employees or Less


The Time Clock System can be used by any business and is completely universal.
Easy to set up:


  • Enter in your employee information or new hire information on to the Employee Information Sheet.

  • On a daily basis enter in your employees hours worked on their time cards, the system will do the rest.

The Time Clock system is designed for restaurants, however this system is universal to any business. We also designed this system for businesses that do not utilize a Point of Purchase System (POS)


more information



Restaurant Form #Excel-010B


time-clock-system

View Larger Image

Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Time Keeping System - 30 Employees or Less


The Time Clock System can be used by any business and is completely Universal. Easy to set up. The payroll time keeping system is the same as the above payroll Time Keeping System. The only difference is time keeping system in the row above is for 20 employees or less and the system in this row is for 30 employees or less.


more information



Restaurant Form Excel-001


excel-daily-safe-count-sheet


Add to Cart

$19.99

WAS $39.99
For a Limited Time $19.99
A $20.00 Savings




Daily Safe Count Spreadsheet


This is an excellent spreadsheet for total cash accountability. By using this form directly on your computer, the money adds up automatically.
All you need to do is count the money and input the count of each denomination. There are six sheets available per day, so you can have the count done at the beginning and ending of each shift.
You can use this to track any discrepancies in your safe count on a shift by shift basis. Have each manager coming in count the safe and record the amounts on this sheet.
The count should also be done at the end of each shift.
If you are finding money missing, this is a great way to pinpoint issues with a shift or manager.
The link for more info below also has a short video with information about how to use this system.


more information



Restaurant Form Excel-002A



cash-till-balance-sheet

View Larger Image


Add to Cart

$19.99

WAS $39.99
For a Limited Time $19.99
A $20.00 Savings




Cash Till Balance Spreadsheet No Alcohol


The Cash Till Balance Sheet is a daily summary of the closeout of your registers. At the end of your shift print out your close out slip. Began to record all coins and cash unto the cash till balance sheet. Record all credit cards and discounts. Once you record all the information that is needed than you will be able to view at a glance the + or - of the drawer. By keeping a solid record you will be able to track any discrepancies and pinpoint the origin of the shortage or overage. On the link below, you'll see a brief video explaining how the system works.


more information



Restaurant Form Excel-002B


cash-till-balance-with-alcohol

View Larger Image


Add to Cart

$19.99

WAS $39.99
For a Limited Time $19.99
A $20.00 Savings



Cash Till Balance Spreadsheet With Alcohol


The Cash Till Balance Sheet is a daily summary of the close-out of your registers. The only difference of the two cash balance sheets are that the above sheet is with no alcohol and the sheet to the left is with alcohol. Either way, both are vital in record keeping of the daily cash positives or negatives. When you click the link below, you'll also see videos on how this system works.


more information



Restaurant Form Excel-003A


daily-sales-sheet-with-alcohol

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Daily Sales Sheet Without Alcohol


The Daily Sales Sheet is a record of the of your restaurants cash flow. Included with tracking your sales, there are charts to see what is happening at a glance. Even though it is a Sales Tracking System, it does so much more than just track sales. You'll track check averages, plus or minus cash for the day, customer counts, and more just by inputting a few key numbers each day. There is a video included on the link below with more information on how the system works.


more information



Restaurant Form Excel-003B


daily-sales-sheet-with-alcohol

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Daily Sales Sheet With Alcohol


The Daily Sales Sheet is a record of the of your restaurants cash flow for restaurants that serve alcohol. There are charts to see what is happening at a glance in your business. This does more than just track your sales, you'll track food and alcohol sales, customer counts, check averages, whether your cash is above or below what it should be and more just by inputting a few key numbers each day. Click the link below for more information and a short video on how the system works.


more information



Restaurant Form Excel-004A


daily sales food inventory

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Daily Sales and Food Inventory No Alcohol


This is a great system that will help you spend less time calculating and more time on the floor. The best of two worlds, sales sheet and inventory. There are many other bonuses in this system. At a glance you will know where you stand on food cost percentage. The link below also has a short video on how to use this system.


more information



Restaurant Form Excel-004B


daily sales and food inventory with alcohol

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Daily Sales and Food Inventory With Alcohol


This system will help you spend less time calculating figures and spend more time in your dinning room where your money is. Conducting a weekly inventory is vital to your restaurant business. Are you losing revenue and have no idea where to look? You may have losses in the inventory. Where do you stand on your food cost percentages? By clicking the link below, you can also see a video on how the system works.


more information



Restaurant Form Excel-005A


food inventory no alcohol

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Weekly Food Inventory - No Alcohol


Do you have an Inventory system in place or are you a brand new business looking for an Inventory system that will work for your business? Customer’s have told us that this has really helped their business. Since we have years of experience in the restaurant industry, we know what works for restaurants.
Food Costs and Labor costs are vital to seeing whether you are meeting the goal of food costs in the equation. You can also see a video which explains how to use the system when you click on the link below. Don't hesitate to call us if you have any questions 1-717-774-3698 or 1-800-753-0657.


more information



Restaurant Form Excel-005A


food and alcohol inventory

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Weekly Food Inventory With Alcohol


Do you have an Inventory system in place for your restaurant or bar? This is the same basic system as the one without alcohol, but areas have been added for tracking beer, liquor, wine, and kegs. It also has sections for taking inventory in your bar area and bar storage. One of our customers who sells alcohol said this has really helped his bar. Since we have years of experience in the restaurant industry, some where alcohol was served, we know what works for restaurants.
You know that keeping track of your food and alcohol expenses are vital to seeing whether you are meeting the goal of making or breaking it. YOu'll be able to see if there is an excessive amount of something being used. This is important in tracking down where you could be losing money. Maybe it is because someone is overpouring alcohol, or giving out free drinks when you aren't there, or are busy with other responsibilities. Re-training employees or knowing who is taking away from your business is important in the equation. You can also see a video which explains how to use the system from the link below. Please, call us if you have any questions 1-717-774-3698 or 1-800-753-0657.


more information



Restaurant Form Excel-006A


food inventory and order management

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Food Order Management System


Are you an existing business and you can’t get a handle on ordering the correct amount of food for your restaurant? Or maybe you are visually eyeing the food inventory and guessing what you will,need to get through the week on food and drinks.
Unless you are a genius and can remember everything you have ordered and is in your inventory, and you are not using a working system you could be risking your restaurant. You may run out of food and create poor customer server or you may order food more food than you need, creating more inventory and increasing food spoilage loss. More inventory is difficult to track, the least amount of inventory on hand, without running out of food, may give you a better food cost and less chance of food waste. You could also be missing areas where losses are due to theft or over-portioning. Using this system will keep you informed and help you get organized.


more information



Restaurant Form Excel-006B


food and alcohol inventory and order management

View Larger Image


Add to Cart

$19.99

WAS $49.99
For a Limited Time $19.99
A $30.00 Savings




Food and Alcohol Order Management System


Are you an existing or new food service business and you are not sure how to order the correct amount of food for your restaurant? Or maybe you are guessing what you will need to get through the week on food and drinks.
Especially when your inventory involves expensive items and alcohol inventory, you could be losing money just in food and alcohol losses. When you have a way to track the food and alcohol usage and ordering you'll be ahead of the game when it comes to your food costs. Without a system, you may run out of food and create poor customer server or you may order food more food than you need, creating more inventory and increasing food spoilage loss. Alcohol ordering is one of those tricky tasks that can make or break you if you aren't aware of what is happening. You should keep the least amount of inventory on hand, without running out of food or alcohol. This gives you a better food cost and less chance of food waste. You could also be missing areas where losses are due to theft or over-portioning--especially when liquor is served. Using this system will keep you informed and help you get organized.


more information



Restaurant Form Excel-007


invoice tracking

View Larger Image

Add to Cart

$19.99

WAS $39.99
For a Limited Time $19.99
A $20.00 Savings




Vendor Management System


Are you experiencing problems due to bills not being paid on time? The Vendor Management System is easy to set up and use. Simply have your managers fill the information onto the vendor sheets before leaving for the day. Basically, they are logging in the information as they go. Each day check the vendor management system to view any outstanding bills. Enter the due date into the system and you will know how soon the bill is due or past due. The color coding system allows you to view bills that are approaching due dates or are 30, 60, 90 days past due. The key to the system working consistently and properly is having management entering the invoices into the system daily and checking for any outstanding bills or if a bill is approaching the due date.


more information



Restaurant Form Excel-008


Inventory spreadsheet

restaurant spreadsheets

daily sales food inventory labor system home
restaurant spreadsheets

Add to Cart

$29.99

WAS $49.99
For a Limited Time $29.99
A $20.00 Savings




Food Inventory Labor Management System (FILMS)


FILMS is finally here! - The Restaurant Food Inventory Labor Management System (FILMS).

This system has it all and is fully loaded. This system is an all in one spreadsheet system. This is not your typical spreadsheet; it's much more than a normal spreadsheet. For instance, we have created a home page with active buttons for you to access the system instead of the tabs you would normally find at the bottom of your spreadsheet.

What does FILMS actually do?
• 9- Part Video Tutorial - How to use each area of the system.
• Manager Communication Calendar – Use this as a replacement of a manager communication log book.
• Business, Employee and Manager Phone Contact List.
• Daily Sales Shift 1, 2 and 3. Enter the final figures at the end of each shift for better accountability. Use the daily sales sheets as a permanent record.
• Vendor Log and Department Totals – Managers should towards the end of their shifts enter the invoice information into the vendor log along with any credits.
• Food, Drink and Paper Inventory system – Enter the food or paper product information (Set-up). Once done print the sheet and do your counts. Once done enter those counts into the input sheets corresponding with the correct date. You will even know your cost percentages.
• Food Costing Tool – Adjust your food menu prices based on your projected food cost percent.
• Food, Paper, Chemicals/Cleaning and Smallwares Ordering System.
• Employee Labor System – Time keeping payroll system. Enter the in and out times per employee. View the total hours and dollars per day, week or month.
• Customer Count Comparison Chart – Use this chart as a tool in comparing the customer counts.
• Restaurant Sales Comparison Chart – Use this as a tool in comparing sales per day.
• Profit & Loss (P&L) Spreadsheet – This tool is 100% protected (viewing only). You will know your bottom line net profit or loss for the month

more information


Restaurant Form Excel-011


http://workplacewizards.com/images/Perpetual-inventory-system-small.jpg

perpetual inventory

Add to Cart

$19.99

WAS $39.99
For a Limited Time $19.99
A $20.00 Savings




Weekly Alcohol Perpetual Inventory Spreadsheet


The good thing about the Alcohol Perpetual Inventory System is that you can actually pinpoint who and when a particular product went missing from your restaurant or business inventory.

Lets say you conducted an weekly inventory and your Alcohol percentage is high.

To use this system you will need to make a list of your top 5 to 10 Alcohol products that you would think people would steal.

Enter those alcohol products onto the perpetual sheet. On a regular basis, count those items in your inventory. Vary the time to count to try to determine when the items are going missing?


more information

©2012 - 2017 Copyright Workplace Wizards Restaurant Consulting Schim Enterprises LLC