I designed a deposit tracking sheet for each location when we decided to accept cash for purchases at the stores. At the end of each day, the shift supervisor inputs the money in the drawer, the cash sales, and any refunds or payouts. The difference between the expected and actual cash in the drawer, as well as the total deposit amount, are automatically calculated through formulas in the sheet. There is also room for the shift supervisor to put their name and any notes in case there is a discrepancy that needs to be explained.
I aimed for this sheet to be as simple to use as possible. Baristas have enough to worry about when closing, so saving them as many steps as possible is worthwhile.
Please note, so as not to publish actual sales data, all of the displayed numbers are placeholders.
