Skip to content
The title slide and first slides of the 80 20 Budget template

80 20 Budget

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

The 80 20 budget is built on one habit: pay yourself first. Each paycheck gets its own row with the pay, the share you keep and two formulas that show the amount to move to savings and the amount left to spend. A Moved checkbox lets you tick off the transfer as soon as it happens, and the Summary separates what you have paid yourself from what is still planned.

The spending side is just as light. The Split tab divides the remaining eighty percent across a few categories, and each category shows a budget, what you spent and what is left. Sample rows follow three biweekly paychecks of $1,980 and a month of ordinary costs. Change the rate on any row if one paycheck calls for a different share.

Useful for

  • Automate savings with one transfer per paycheck
  • Divide the remaining pay among a few categories
  • Tick off each savings transfer as it happens

What's included

  • 5 tabs: Summary, Income, Split, Spending, How to use
  • Summary: a dashboard with 6 summary figures
  • Income: a table
  • Split: a table with 1 summary figures
  • Spending: 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 Income 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 80 20 budget?

You save twenty percent of each paycheck and spend the other eighty. It is simpler than tracking every category and puts saving first.

Can I use a different percentage than 20?

Yes. The Pay yourself column is an input on every row, so change it for one paycheck or for all of them.

How does the Moved checkbox work?

Tick it after the transfer clears. The Summary counts only ticked rows under Moved to savings.

  • #budget
  • #80-20-budget
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More budget templates

See all 61

Also in Finance

All finance templates
Get this template

Preparing your template…