Skip to content
Monthly Income Statement cover: a sample sheet with total revenue, gross profit and gross margin and a bar chart, beside the Dashboard and Lines tabs

Monthly Income Statement

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This income statement suits a small business owner or bookkeeper who wants a clear picture of one month's trading. The Lines tab takes each line item with its section (revenue, cost of sales, operating expense or other expense), its amount and a note. The Effect on profit column adds revenue and subtracts costs, so the net result is one total.

The Dashboard shows total revenue, gross profit, gross margin, operating expenses and net income, plus a bar chart of where the money went by section. The sample month is a shop with product and service sales. Overwrite those lines with real numbers, but leave the sections alone so the totals stay right.

Useful for

  • Reviewing last month's profit with the owner
  • Comparing gross margin across several months
  • Preparing figures for a bank or lender

What's included

  • 3 tabs: Dashboard, Lines, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Lines: a table
  • 1 chart 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 Lines 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 is the difference between gross profit and net income?

Gross profit is revenue minus cost of sales, the direct cost of what you sold. Net income goes further and takes off operating expenses, such as rent and wages, and other costs like loan interest. Tax is also a deduction, but this sheet leaves it out, so add it separately.

Where do I put a cost that could be either a cost of sales or an operating expense?

Put a cost in cost of sales when it rises and falls with what you sell, such as stock and packaging. Anything else, such as rent and software, goes under operating expense. Apply that rule consistently, and margins from different months stay comparable.

Can I use the statement for more than one month?

Yes. Copy the sheet when a new month begins and clear the Amount column. Keep each month in its own file, or add a month column to compare results over the year.

  • #profit-and-loss
  • #small-business-income-statement
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 12

Also in Finance

All finance templates
Get this template

Preparing your template…