A bills and paydays calendar you can make today
Put every payday and bill on one calendar and the tight days jump out. Three layouts, paper, phone and spreadsheet, plus how to read what you see.
· 4 min read · By the GroFunds team
A list of bills tells you what you owe. It doesn’t tell you that four of them land in the three days before payday. A calendar does, at a glance.
You can make one tonight in about half an hour. Pick the layout that suits how you like to look at things, fill it in once, and update it when something changes.
What goes on it
Whatever layout you choose, you need the same information:
- every payday, with the amount that lands (take home, not gross)
- every bill, with its due date and amount
- every scheduled transfer, like savings or money to a partner
- yearly and quarterly bills, in the month they fall
If you don’t have a full list yet, start with the recurring bills checklist and your last two months of statements.
Layout 1: The paper month
Good for: people who like to see the whole month on the fridge.
- Print a blank monthly calendar, or draw a grid with seven columns and five or six rows.
- Write your paydays in one colour. Use a box or a highlight so they stand out.
- Write each bill on its due date in a second colour, with the amount.
- Under each week, write the week’s total of bills.
Use pencil for amounts that change, like utilities.
Then step back and look. Where are the clusters? Is there a stretch of several days with bills and no payday?
Layout 2: The phone calendar
Good for: couples and families, or anyone who lives in their phone calendar.
- Create a new calendar called “Bills and pay” so it can be shown or hidden on its own.
- Add each payday as a repeating all day event, set to the right cycle (every two weeks, twice a month, weekly).
- Add each bill as a repeating all day event on its due date, with the amount in the title, like “Phone $65”.
- For yearly bills, set the repeat to yearly and add a reminder two weeks before.
- Share the calendar with your partner if you split bills.
The advantage here is reminders. Set one for the day before any bill that comes out of a tight account.
Layout 3: The spreadsheet
Good for: people who want to see the running balance, not just the dates.
Make one row per day of the month, with these columns:
- Date
- Item: what comes in or goes out that day
- In: paydays and other money arriving
- Out: bills and transfers
- Balance: the running total
For the balance column, the first row is your balance at the start of the month. Every row after that is the balance from the row above, plus that row’s In, minus that row’s Out. Most spreadsheet apps let you write that once and copy it down the column.
If you want to go further, build a month end balance spreadsheet in 15 minutes adds everyday spending to the same sheet.
A filled in example
Here’s an example with invented numbers, using the spreadsheet layout for the first half of a month. Pay is $2,000 every second Friday, and the account starts the month at $900.
| Date | Item | In | Out | Balance |
|---|---|---|---|---|
| 1st | Rent | $1,400 | $500 below zero | |
| 2nd | Pay | $2,000 | $1,500 | |
| 5th | Car insurance | $140 | $1,360 | |
| 8th | Phone | $65 | $1,295 | |
| 10th | Internet | $80 | $1,215 | |
| 14th | Gym | $45 | $1,170 | |
| 16th | Pay | $2,000 | $3,170 |
(Everyday spending is left out here to keep the example readable.)
Look at the first row. Rent comes out one day before payday, and the account drops below zero overnight. On a list, you’d never see it. On the calendar it’s the first thing you notice.
What to look for once it’s filled in
Bills right before payday. Like rent on the 1st with pay on the 2nd above. The fix is to move the bill a few days later, or to keep enough in the account to cover it. Lining up your bills with your payday has a script for asking.
Clusters. Three or four bills in the same few days, especially in the week before payday. Spread them out if you can.
Empty stretches. Long gaps with no bills often follow payday. That’s the safest time to schedule transfers to savings.
Big months. In the yearly view, months where an annual bill lands. Set a little aside each month ahead of time; annual bills that catch people out explains how.
The lowest point. If you used the spreadsheet, scan the Balance column for the smallest number. That’s your tightest day of the month, and it matters more than the end of the month. The lowest point in your month goes into why.
Keep it current
A calendar that’s out of date is worse than none, because you’ll trust it. A few habits keep it honest:
- when a bill amount changes, update it that day
- when you add or cancel a subscription, add or remove it from the calendar
- once a month, check the next month’s dates against your statements
It takes five minutes a month once the first version exists.
GroFunds finds your bills and paydays from your bank accounts and shows where the month will land, every day, so the calendar keeps itself up to date.