Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingProfit & Loss StatementsIncome Statement with Year-on-Year Comparison

SpreadsheetProfit & Loss StatementsFree

Income Statement with Year-on-Year Comparison

Revenue, cost of sales and expenses for two periods with gross, operating and net margins.

Shown with sample data

Colour

Income Statement with Year-on-Year Comparison

Revenue, cost of sales and expenses for two periods with gross, operating and net margins.

Revenue
$508,000
Gross margin
54%
Operating profit
$58,200
Net profit
$43,200
This period by section
  • Revenue$508,000
  • Cost of sales$235,000
  • Operating expenses$214,800
  • Interest and tax$15,000

How to use it

  1. 1Replace the lines with your own, keeping each in the right section.
  2. 2Enter both periods as positive numbers.
  3. 3Read the margins in the key figures.
  4. 4Investigate cost lines that grew faster than revenue.

In this workbook

  • About
  • What’s included
  • How to use

About this template

Compare this period with the last on one page. Enter each income and cost line for both; the statement works out gross profit, operating profit and net profit, the margin at each level and the change in every line, so you can see whether growth is reaching the bottom line.

Who it’s for

  • Annual and quarterly reviews
  • Board packs
  • Lender updates

What’s included

  • Income statement sheet: Each line for both periods.
  • By section sheet: This period and Last period and the number of entries for each section.

How to use it

  1. 1Replace the lines with your own, keeping each in the right section.
  2. 2Enter both periods as positive numbers.
  3. 3Read the margins in the key figures.
  4. 4Investigate cost lines that grew faster than revenue.
Related searchesincome statementprofit and loss comparisonyear on yeargross marginnet profit

Details

Format
Spreadsheet
Category
Profit & Loss Statements
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProfit & Loss StatementsFree

Income Statement with Year-on-Year Comparison

Revenue, cost of sales and expenses for two periods with gross, operating and net margins.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Profit & Loss Statements
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ