Paycheck Budget Spreadsheet: budget by payday. See every payday of the year, the bills each one has to cover, and exactly what's left to spend, worked out for you.
For Google Sheets, Excel and Apple Numbers, in any currency. Weekly, fortnightly or monthly pay.
WHAT'S INSIDE (5 tabs)
- Start Here: how to use it, with clickable contents
- Setup: your year, how often you're paid, your first payday, a typical pay amount, each bill with its due day and amount, and what you set aside from every pay
- Paychecks: each payday with the bills due before the next pay, your plan, savings and "left to spend". Pays that can't cover their bills are flagged in red
- Bill Schedule: every bill dated for the whole year and matched to the paycheck that must cover it. Tick a bill as you pay it
- Paycheck View: pick a pay number to see exactly which bills it covers
- Paydays generate themselves from your first payday
Two files in your download
- Blank workbook (.xlsx): ready for your own numbers
- Example workbook (.xlsx): the same workbook, filled in, so you can see how it works
Instructions and clickable contents are on the Start Here tab inside the workbook.
Works in
- Google Sheets: upload the file to Google Drive, open it, then choose File > Save as Google Sheets
- Microsoft Excel (Windows and Mac)
- Apple Numbers
Only long-standing spreadsheet functions are used, with no macros, so there is nothing to enable. There are no currency symbols built in, so any currency works.
Please note
- Digital download: nothing will be posted. We email the files to the Google account you signed in with.
- Formula cells are locked against accidents, with no password, so you can't break the maths by mistake.
- A budgeting tool only, not financial advice.
- Change the year and your first payday on Setup to reuse it next year.
- Looking for a month-by-month budget instead? See our Simple Budget Planner in the Spreadsheets section.
- For personal use by one purchaser. Please don't share or resell the files.
Questions? Email hello@fayandform.com.
Fay & Form Studio · thoughtful templates for work and life