Skip to content
Monthly Sales Report cover: a sample sheet with revenue, deals closed and average deal and a column chart, beside the Dashboard, Deals and Targets tabs

Monthly Sales Report

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Sales managers and small business owners review revenue with this report, one month and one region at a time. The Deals tab records every closed deal: its date, rep, region, month, account and amount. The Targets tab sets a target for every region and month, pulls the actual revenue from the deals and shows attainment as a percentage, shaded from weak to strong. The Dashboard compares target and revenue by month and totals each region.

Record each deal as it closes and choose its month from the list so totals land in the right group. Enter targets ahead of the month so any gap appears early. Rows on the Targets tab turn red when a region has reached less than 80 percent of its target. For a quarterly review, copy the file, add the months you need to the Month lists and give each region its own row on the Targets tab.

Useful for

  • Reviewing revenue against target at month end
  • Comparing regions to find which one is falling behind
  • Preparing a monthly revenue update for leadership

What's included

  • 4 tabs: Dashboard, Deals, Targets, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Deals: a table
  • Targets: 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 Deals 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

Why does a region show zero revenue?

The region name on the Deals tab must match the name on the Targets tab exactly, including capital letters and spaces. A typo or an extra space puts the deal outside the total. Check the spelling in the Region column first, then the Targets tab.

How is attainment calculated?

Attainment is the actual revenue for a region and month divided by its target. A value of 100 percent means the target was met exactly, and anything above it is over target. The colour scale on the Targets tab makes the strongest and weakest regions easy to spot.

What happens when a new month starts?

Add the new month to the Month lists on the Deals and Targets tabs, then add a row for each region on the Targets tab. Old months stay in the file, so the dashboard keeps a running comparison.

  • #sales-tracker
  • #monthly-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…