Skip to content
Year-to-Date Profit and Loss cover: a sample sheet with income year to date and costs year to date and a column chart, beside the Dashboard and Accounts tabs

Year-to-Date Profit and Loss

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 template suits owners, managers and finance leads who review the year as it goes. The Accounts tab lists each account with its section (income, cost of sales or expenses), budget year to date, actual year to date, the variance and the share of budget used. Sample figures run through 31 October 2026 for a consulting firm with income, subcontractor costs and overheads.

The Dashboard shows year-to-date income, costs and net profit next to the net profit budget and profit margin. A column chart sets budget against actual for each section. Update the actual column from your ledger at each month end, and the totals and chart follow without any other changes.

Useful for

  • Checking profit against plan at the monthly review
  • Finding which costs are running over budget
  • Preparing a mid-year update for the board

What's included

  • 3 tabs: Dashboard, Accounts, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Accounts: 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 Accounts 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

Should the budget be spread evenly across the months?

Not always. Some income and costs fall in busy seasons, so a flat monthly split can make the year look worse or better than it is. Enter the year-to-date budget for each account using your seasonal plan, so the comparison measures performance rather than timing.

Why does the variance column show a positive figure for costs?

The variance is actual minus budget, so a cost that is higher than planned shows as a positive number. For income, a positive variance means you are ahead of plan. Read each row with its section in mind.

Can I add a new account partway through the year?

Yes. Type the account name at the bottom of the Accounts table and pick its section. Enter a budget for the period that remains, or leave it at zero if the cost was not planned, so the figures explain themselves.

  • #profit-and-loss
  • #ytd-profit-and-loss
  • #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…