What is included
- One daily row records up to four sales channels, discounts, guests, labor cost and cash over/short.
- Net sales, average check and labor percentage calculate from those entries.
- Monthly and year views compare sales with weekday targets and summarize cash differences.
- Includes Google Sheets and demo/blank Excel files; the cash over/short figure is recorded in the daily log.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Daily sales totals and their source reports
- The cash figures used in your closing process
- Labor-cost inputs for the same trading day
A practical way to use your records
Define the trading day consistently, particularly if service continues after midnight. Enter figures from the closing records, review differences and keep an explanation for adjustments. Compare the daily log with supporting reports before relying on a period summary.
A worked example
Fictional example: a restaurant closing routine reconciles cash in the drawer for one day.
- Opening float
- $100
- Cash sales
- $650
- Documented cash payout
- $40
- Counted closing cash
- $705
- Use the source cash-close records to check $100 opening float plus $650 cash sales less the $40 payout, outside the daily sales entry.
- Enter the resulting cash over/short figure in Daily Log, together with the date and an explanation in Notes; retain the count and payout evidence.
Result: Expected cash is $710, so the $705 count leaves a $5 shortfall. Record the shortfall in the daily row using the guide's sign convention. The sheet tracks that entered cash difference; these supporting drawer calculations are not additional promised input fields.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Restaurant Daily Sales & Cash Tracker for Google Sheets and Excel
Additional previews from this product's Etsy listing. Open any image for a larger view.
Questions about this product
Is this an end-of-day report spreadsheet?
Yes. The listing names an end-of-day report, sales log, cash tracker and labor-cost dashboard.
Does it connect automatically to my point-of-sale system?
Check the current Etsy listing for supported imports and integrations if a point-of-sale connection is essential to your workflow.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
