Cash Till Balance Spreadsheet – No Alcohol

Why use the cash till balance sheet? Does your business have continuous cash shortages?

Are you unable to determine why you are short money? 

The key is accountability! The Cash Till Balance Sheet is useful in every business that has cash tills.

Cash Till Drawer View at a Glance without alcohol

This is a sample of an added tool to help your business understand where you stand month to date. These pages will automatically calculate from the information entered on the daily counts, so you always have the most recent information. You can even sort the information by columns.

• Also, if there is a shortage of more than $5.00 it will highlight in yellow
• Coupons more than $20.00 will highlight in Blue
• Customer Comps more than $25.00 will highlight in gray
• Voids more than $20.00 will highlight in Green
• Over-rings will highlight in Purple

How will cash till balance sheet help your business?

You can track the progress of the restaurant by category and view trends and view areas highlighted looking for common denominators such as: Shortages falling on the same shifts and employee. Unusual amounts of coupons, comps, voids and over-rings by comparison to other employee numbers, which will indicate a red flag telling you that you might have a problem with a dishonest employee. To help you with the calculation and review we have included the totals per category along with the percentages.

The Cash Till Balance Sheet is a daily summary of the closeout of your registers.

Keeping track of the cash flow and the people who are running the registers is a great way to manage your cash flow. With consistent use of this spreadsheet, your employees are accountable for cash shortages. A bonus feature is that you will be able to monitor and view the reports at a glance. This will help you to find common denominators that could create cash shortages or theft in your business. Without tracking this information’ theft could be happening right under your nose. The Cash Till Balance sheet No Alcohol has four (4) Till balance sheets per day.  

Other Spreadsheets:

• Microsoft Excel Safe Count System
• Safe Count Sheet
• Cash Till Balance Sheet With Alcohol
• Daily Sales Sheet With No Alcohol
• Daily Sales Sheet With Alcohol
• Daily Sales Sheet And Food Inventory No Alcohol
• Daily Sales Sheet And Food Inventory With Alcohol
• Weekly Food Inventory System No Alcohol
• Weekly Food Inventory System With Alcohol
• Food Ordering Management System No Alcohol
• Food Ordering Management System With Alcohol
• Vendor Management System
• Food Inventory Labor Management System (FILMS)
• Microsoft Excel Timekeeping System (20 Employees or Less)
• Microsoft Excel Timekeeping System (30 Employees or Less)
• Microsoft Excel Weekly Alcohol Perpetual Inventory System

Cash Till Balance Spreadsheet

Click the image to view larger

Click the image to view larger

 The Cash Till Balance Sheet

Is a daily summary of the closeout of your registers. Keeping track of the cash flow and the people who are running the registers is a great way to manage your cash flow. With consistent use of this spreadsheet, your employees are accountable for cash shortages. A bonus feature is that you will be able to monitor and view the reports at a glance. This will help you to find common denominators that could create cash shortages or theft in your business. Without tracking this information’ theft could be happening right under your nose. If you ever have to refer back to this information, it is readily available. Instead of stuffing your cash sheets away in a file drawer, these records are at your fingertips.

How do I use the Cash Till Balance Sheets?

At the end of each employee with a cash register, you should walk with the employee to the back office or to a designated counting area. 

1. If you have a computer or laptop, this program can be opened and then input the information. A manager needs to be present during the counting process, and we also advise having a witness present.
2. Either the employee, manager or witness must enter a the information on to the till sheets.
3. Never let a manager count the drawer without the employee being present, it leaves an open door to theft. By following these suggested procedures it gives your staff accountability.