Safe Count Spreadsheet

Safe Count Spreadsheetsafe count spreadsheet

The safe count spreadsheet is an excellent tool for total cash accountability. Very simple to use, it automatically calculates everything for you. This is a great way to be consistent with the everyday accounting of the restaurant’s revenue. If you do not have a system in place now, or you want to upgrade from an existing system, then I fully recommend the safe count spreadsheet.

You could use a standard form and spend valuable time performing calculations by hand. This also could lead to mistakes in the calculations. It makes more sense to spend that time with your employees and customers. Using the safe count spreadsheet consistently and correctly will keep people honest and will decease any money shortages mainly because shortages can be tracked to a specific shift and person.

For restaurants and other types of business that do not use a system to help keep track of their safe money will have unexplained shortages due to theft. If the safe counts are off during the counts from shift to shift, then you will need to rectify the safe by shorting the nightly deposit to get the safe count to where it needs to be.  Ultimately this will effect the bottom line, especially if it was theft.

To ensure that the safe counts are being done consistently the owner/upper management needs to audit the safe and the safe count spreadsheet periodically. The owner / upper management should arrive at the location unannounced.

What should I count in the safe?

  • Back up paper dollars.
  • Rolled coins.
  • Cash deposits.
  • Tip out envelopes
  • Petty cash
  • Cash drop envelopes.


How to use the safe count spreadsheet?

The morning manager first thing should count the entire safe and enter those figures unto the safe count spreadsheet. If the counts are not correct, then recount the cash deposit and cash tills. Have another manager or owner / general manger recount the safe.

If the counts are still not correct then rectify the safe by shorting the day cash deposit. Make sure you enter all the information about the shortage into the comment section on the safe count spreadsheet and the managers log book. Make sure you include the date, time and who counted the safe.

The safe is counted again  at the end of the AM shift. The PM shift can not open the safe until the AM shift is done with the safe count. The Pm shift will take over the shift and then they can begin the beginning count. If the safe count is off then the PM manager reports the shortage to the AM shift. The AM manager needs to verify the PM opening count is correct before leaving for the day.

The AM shift should also take to the bank the AM shift cash deposit. The AM shift needs to get to the bank before the sun goes down. The PM shift will secure their deposit in the safe over night. The AM shift will take the Previous nights deposit to the bank and verify the deposit and return to the business with the validated deposit slip.

The safe count spreadsheet is easy to use. All you need to do is enter in all your counts and the system will automatically calculate the figures for you. If used consistently and properly the safe count sheet will be a valuable accountability tool.

Other Spreadsheets


  WAS $24.99
For a Limited Time $19.99
A $5.00 Savings

Add to Cart

Safe Count Spreadsheet

safe count

safe count spreadsheet

Safe Count Spreadsheet

Each shift has a beginning and end safe count sheet. There are three shifts, AM, PM and Overnight shift.

Below is what the sheet look like in life size picture.

Click to enlarge

Safe Count Sheets

Leave a comment

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

Optimization WordPress Plugins & Solutions by W3 EDGE