Bill Tracker & Paycheck Budget Spreadsheet – Excel + Google Sheets

Hinweis: Diese Vorlage ist auf Englisch (Spalten, Texte und Anleitung). Sie funktioniert in Excel und Google Sheets.

Bill tracker spreadsheet for Google Sheets and Excel that shows which bills each paycheck has to cover – a paycheck budget and bill payment organizer with a printable bill calendar.

Enter how often you are paid and your bills once. The spreadsheet finds the bills due before every payday, adds them up and shows what is left to spend. No formulas to build, no tabs to copy.

What you get

• 1 spreadsheet with 5 tabs: Start, Dashboard, Paychecks, Bills, Bill Calendar – plus an optional Charts tab
• Up to 40 bills: monthly, every 3 months, every 6 months, yearly or one time
• Up to 60 paydays in a 12-month plan, calculated for you: weekly, every 2 weeks, twice a month or monthly
• Dashboard for this paycheck: income, bills due, savings, left to spend, still available, bills paid, progress bar – plus 2 charts for the whole year
• 12-month paid checklist: choose ✓ when a bill is paid. Autopay bills count as paid once the due date has passed. Overdue bills turn red
• Bill calendar: the amount due on each day of the month, every bill sorted by date and the paycheck that pays it
• Example data you can switch ON or OFF, so you see a filled tracker first
• Dark design version of the same spreadsheet (in the Extras folder)
• 2-page quick start guide

Bonus

Printable Bill Calendar, 17 pages: monthly bill calendars from November 2026 to December 2027, a “My Bills” list, a 2027 bill payment checklist and a paycheck planner page. US Letter, plus A4 in the Extras folder. The Extras folder also has 8 phone pictures (bill checklist, paycheck planner, bill calendar) to share with your family.

What you need

• Excel 2016 or newer (Windows or Mac) – no Microsoft 365 subscription needed, or
• Google Sheets – free with a Google account, or
• LibreOffice Calc – free (tested with this file)
• On your phone, use the free Excel app or Google Sheets app
• No macros, no add-ons, no subscription

How to start

• Tab Start: set the example data switch to OFF, enter how often you are paid, one payday and your usual pay.
• Tab Bills: add each bill with amount, next due date and how often.
• Tab Dashboard: see the bills due before your next payday and what is left to spend.

Your data

The Excel file stays on your device – no account and no internet needed. If you use Google Sheets, your copy is stored in your own Google account.

Good to know

• This is a digital download. Nothing will be shipped.
• You get the download link right after checkout and by email.
• 14-day money-back guarantee.
• Formula cells are locked so nothing breaks. You can unlock them without a password.
• Colors can look slightly different on each screen.
• This spreadsheet is a planning tool, not financial advice.

Help

Questions or ideas? Write to info@propraxisplan.de – we usually reply the same day.

© ProPraxisPlan