Skip to content
Daily Sales Report cover: a sample sheet with total sales, sale lines and average line and a bar chart, beside the Dashboard, Sales and Daily tabs

Daily Sales Report

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This report is for a shop, cafe or market stall that needs a clear view of each trading day. The Sales tab records every sale line with its date, item, channel, payment method, quantity and price, and the total calculates itself. The Daily tab adds up each date, counts the sale lines, works out the average line and shows how far the day landed from its target. The Dashboard summarizes sales by channel and by payment method.

Enter sales after every shift, or once a day from your till export. Set a realistic target for each date on the Daily tab, and leave the rows blank for days you are closed. A red row means that day finished below target. Check the channel breakdown each week to see which channel needs attention, and copy the file when a new month begins to keep the history.

Useful for

  • Closing the books at the end of each trading day
  • Checking which days fell short of the sales target
  • Comparing in-store, online and market sales each week

What's included

  • 4 tabs: Dashboard, Sales, Daily, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Sales: a table
  • Daily: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sales tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What does the average line show?

The average line is the total sales for a date divided by the number of sale lines for that date. It shows the typical value of one line on the till, so a quiet day with a few large orders can show a higher average than a busy day of small purchases.

How do I add a sales channel or payment method?

Add the new name to the Channel or Paid by list on the Sales tab, then put it into the matching dashboard breakdown, spelled identically. Any difference in spelling leaves that channel showing zero.

Can the report be trimmed to cover one trading day only?

Yes. Clear the Sales rows, keep only the date you need on the Daily tab, and enter that day's sales. The dashboard then shows that day's figures. Otherwise the totals cover every row on the Sales tab.

  • #sales-tracker
  • #daily-sales-report
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More sales tracker templates

See all 8

Also in Sales

All sales templates
Get this template

Preparing your template…