Free spreadsheet

Free paycheck budget spreadsheet

A paycheck budget template that opens in Google Sheets, Excel and Numbers. Type your payday and it lists the bills due before the next one. Then split what's left until nothing is left to assign.

Download the spreadsheet

Excel workbook (.xlsx) · 13 KB · No email, no sign-up

What's in it

  • Start here. How to use the file, and where you type how often you're paid and your usual take-home pay.
  • Bills. Each monthly bill, its amount and the day of the month it's due, with a total. There's room for 20.
  • Paycheck. One sheet for each payday: the bills this check pays, money set aside by bin, savings and debt, and what's left to assign.

The file opens with an example to type over: $1,800 every two weeks and the seven bills from how to budget biweekly paychecks.

The Paycheck sheet with its example filled in: payday on Friday, January 8, 2027, take-home pay of $1,800, three bills that come to $1,375, $425 set aside in three bins, and $0.00 left to assign.
The Paycheck sheet, with the example filled in.

How it works

Open it in Google Sheets
  1. Go to sheets.google.com and start a blank spreadsheet.
  2. Choose File, then Import, then Upload, and pick the file you downloaded.
  3. Choose Replace spreadsheet, then Import data.

Or upload the file to Google Drive and open it there. Sheets opens it as an Excel file. To keep it as a Sheets file, choose File, then Save as Google Sheets.

Open it in Excel

Open the file from your Downloads folder. On Windows, Excel may open it in Protected View because it came from the internet. Click Enable Editing and you can type. The file has no macros, so there's nothing else to allow.

Open it in Numbers

On a Mac, open Numbers, choose File, then Open, and pick the file. On an iPhone or iPad, open Numbers, tap Browse, find the file in Downloads and tap it. Numbers makes its own copy, so your changes are saved as a Numbers spreadsheet.

How to use it on payday
  1. Set it up once. On Start here, type the days between your paydays and your usual take-home pay. The file is set for biweekly pay, every 14 days. Paid every week? Make it 7. On Bills, list each monthly bill, its amount and the day it's due, in any order.
  2. Type your payday. On the Paycheck sheet, type the date in the gold cell. Every bill due from that day to the day before your next payday fills in, earliest first, with a total and what's left after bills.
  3. Add anything that isn't monthly. A car registration or a one-time bill goes in the gold rows under the list.
  4. Fill your bins. Groceries, gas and whatever else has to last until the next check. Bin is Granary's word for envelope.
  5. Send the rest to savings and debt. Keep moving money between the lines until Left to assign reads $0.00.
  6. Next payday, duplicate the sheet. Right-click the Paycheck tab and choose Duplicate. In Excel, choose Move or Copy and tick Create a copy. Then type the new payday.

Paid twice a month or once a month? Type your next payday on each Paycheck sheet, over the date the file works out.

What a spreadsheet won't do

A spreadsheet holds the plan. It can't see what happens after payday.

  • You keep it up by hand. Nothing is logged unless you open the file and type it in.
  • It shows what you set aside for groceries, not what's left of it on Thursday.
  • Every payday needs a new copy and a new date.

If that suits you, the spreadsheet is all you need.

More free tools