Templates / Annual + Paycheck Budget
Annual & Paycheck Budget Spreadsheet
Budget by month and by paycheck, so you can see which bills each paycheck covers before payday.
$10
Buy on Ko-fi, $10Instant download: you get one .xlsx file. For Google Sheets, upload it to Google Drive and open it with Google Sheets. Digital item, so nothing is shipped. Personal use only; please don't resell or share the file.
What's inside
- Pay settings: weekly, biweekly, semi-monthly (15th and last day) or monthly; first payday and take-home pay
- Budget: up to 30 categories with monthly amounts and bill due days; yearly totals and share of take-home
- Paycheck Plan: every payday of the year, the bills due before the next payday, a share of your other spending and savings, what's left, and a running balance; extra-paycheck months and short paychecks are flagged
- Bill Calendar: every bill on its due date for all 12 months
- Transactions + Monthly Tracker: log income and spending; see planned vs actual by category for every month, with over-budget cells in red
- Sinking Funds: up to 20 savings goals with a target date, amount still needed, monthly amount to save and percent complete
- Dashboard: planned take-home, budgeted, left after budget, income and spending so far, this month's numbers, and charts
Good to know
- Works in Microsoft Excel, Google Sheets and LibreOffice. No macros.
- Yellow cells are for typing; grey cells calculate.
Previews
Questions
Does it work for biweekly pay?
Yes. Choose weekly, biweekly, semi-monthly (15th and last day) or monthly, and it lays out every payday of the year.
What happens in a three-paycheck month?
Extra-paycheck months and short paychecks are flagged on the Paycheck Plan.
How many savings goals can I track?
Up to 20 sinking funds, each with a target date and a monthly amount to save.
How many budget categories are there?
Up to 30.