Why a pay cycle calendar matters

Most budgeting advice assumes a monthly cycle, but most Australians are paid fortnightly. This mismatch causes real problems: monthly budget categories don't align with fortnightly income, some months have two pays and others have three, and bills that fall between pays can create cash flow gaps.

A pay cycle calendar spreadsheet solves this by mapping your income and bills to your actual pay dates, so you can see exactly when money comes in, when it goes out, and when the gaps are.

This guide walks through building a pay cycle calendar that works with your actual pay frequency.

Step 1: Know your pay dates

Start by listing your pay dates for the next 3–6 months. If you're paid fortnightly, your pay dates are every two weeks on the same weekday. If weekly, every week. If monthly, on the same date each month.

Finding your pay dates

• Check your bank account for the last few pay deposits and note the pattern
• Ask your employer for the pay schedule if you're not sure
• Account for public holidays — pays may come a day early if the normal pay day is a public holiday

Example: fortnightly pays

If you're paid every second Friday, your next 6 pay dates might be:

• Friday 16 October
• Friday 30 October
• Friday 13 November
• Friday 27 November
• Friday 11 December
• Friday 25 December

Step 2: Set up the calendar structure

Create a spreadsheet with one row per pay cycle. The columns:

| Pay # | Pay date | Income | Bills this cycle | Net for cycle | Daily allowance | Buffer after | |---|---|---|---|---|---|---| | 1 | 2026-10-16 | $1,820 | $1,100 | $720 | $51 | $850 | | 2 | 2026-10-30 | $1,820 | $1,200 | $620 | $44 | $1,470 | | 3 | 2026-11-13 | $1,820 | $900 | $920 | $66 | $2,390 |

What each column means

• Income — what you receive on this pay date
• Bills this cycle — the total of all bills due between this pay and the next
• Net for cycle — income minus bills (what's left for living costs and savings)
• Daily allowance — net divided by the number of days until the next pay
• Buffer after — your projected balance after this cycle's bills are paid

Step 3: Map bills to pay cycles

This is the key step. For each bill, determine which pay cycle it falls in based on its due date.

List all bills with due dates

| Bill | Amount | Due date | |---|---|---| | Rent | $800 | 15th of each month | | Electricity | $180 | 28th of each quarter | | Phone | $60 | 20th of each month | | Car insurance | $66 | 25th of each month | | Internet | $80 | 22nd of each month | | Groceries | $150 | Weekly (every Friday) |

Assign each bill to a pay cycle

For each bill, check which pay date comes just before its due date. That's the pay cycle it belongs to.

• Rent (15th): falls in the cycle starting 16th (the pay on the 16th covers rent due on the 15th of the next month — wait, this depends on timing. Let's say rent is due on the 15th and you're paid on the 16th — rent for the 15th is paid from the previous pay on the 2nd)

This can get confusing. The simplest approach: list bills by their actual due date and assign each to the most recent pay before that date.

Use a formula to assign bills

If your bills are in a separate sheet with due dates, you can use a formula to sum bills for each cycle:

=SUMIFS(Bills!B:B, Bills!C:C, ">="&A2, Bills!C:C, "<"&A3)

This sums all bill amounts where the due date is on or after this pay date (A2) and before the next pay date (A3).

Step 4: Calculate the daily allowance

The daily allowance is how much you can spend per day on living costs (food, transport, entertainment) during this pay cycle:

=Net_for_cycle / Days_in_cycle

Where Days_in_cycle is the number of days between this pay and the next (14 for fortnightly, 7 for weekly).

Example

• Net for cycle: $720
• Days in cycle: 14
• Daily allowance: $720 / 14 = $51/day

This tells you that during this pay cycle, you can spend $51 per day on living costs. If you spend less, you're ahead. If you spend more, you'll run out before the next pay.

The free payday calculator does this calculation instantly — enter your balance, income, bills, and buffer, and it shows your daily allowance and projected balance.

Step 5: Project your balance

The most valuable column is the projected balance after each cycle. This shows whether you're building a buffer or running it down.

=Previous_buffer + Net_for_cycle - Living_costs - Savings

If you're tracking living costs and savings, this projects your balance forward. If you just want a rough projection, assume living costs equal the daily allowance times the days in the cycle (which means the buffer stays flat), and adjust based on whether you actually spent more or less.

Example projection

| Pay # | Pay date | Income | Bills | Net | Buffer after | |---|---|---|---|---|---| | 1 | 2026-10-16 | $1,820 | $1,100 | $720 | $850 | | 2 | 2026-10-30 | $1,820 | $1,200 | $620 | $1,470 | | 3 | 2026-11-13 | $1,820 | $900 | $920 | $2,390 | | 4 | 2026-11-27 | $1,820 | $1,050 | $770 | $3,160 |

The buffer grows because income exceeds bills plus living costs. If the buffer were shrinking, you'd see it immediately and could adjust.

Step 6: Identify tight cycles

Some pay cycles will be tighter than others — when several large bills fall in the same cycle. The calendar makes these visible:

| Pay # | Pay date | Bills | Net | Daily allowance | |---|---|---|---|---| | 2 | 2026-10-30 | $1,200 | $620 | $44 | | 5 | 2026-12-11 | $1,450 | $370 | $26 |

Cycle 5 is tight — $26/day is low. You can see this coming weeks in advance and adjust: reduce spending in the cycles before, or use buffer from earlier cycles to cover it.

The three-pay month

If you're paid fortnightly, twice a year you'll have a month with three pays instead of two. These are windfall cycles — the extra pay has no bills assigned to it (because bills are monthly). Use the three-pay month to:

• Build your buffer — transfer the extra pay to savings
• Pay down debt — put the extra toward your highest-priority debt. See our guide to organising debt
• Fund a sinking fund — boost a sinking fund for an upcoming annual bill

Step 7: Add savings and debt repayment

If you're saving or paying off debt, include these in the calendar:

| Pay # | Pay date | Bills | Savings | Debt | Net for living | |---|---|---|---|---|---| | 1 | 2026-10-16 | $1,100 | $135 | $200 | $385 | | 2 | 2026-10-30 | $1,200 | $135 | $200 | $285 |

Now the daily allowance is based on what's left after bills, savings, and debt — the actual money available for living costs.

Pay yourself first

In the calendar, put savings and debt repayment before living costs, not after. If you save what's left, there's usually nothing left. If you save first, the living costs adjust to what's available. See our guide to setting savings goals.

Step 8: Handle variable income

If your income varies (casual, freelance, seasonal), the calendar is even more useful — but you need to handle the uncertainty:

• Use a conservative estimate. Enter your expected income, not your maximum. If you earn more, it's a bonus.
• Plan for the low cycles. Identify cycles where income might be low and build a buffer in the good cycles to cover them.
• Update as you go. When you know the actual income for a cycle, update the calendar. The projections adjust.

Common pay cycle calendar mistakes

• Using monthly categories with fortnightly income. This creates a mismatch. Convert everything to your pay frequency.
• Not accounting for the three-pay month. If you don't plan for the extra pay, it gets absorbed into spending. Assign it a purpose in advance.
• Forgetting bills that fall between pays. A bill due on the 14th when you're paid on the 16th needs to be covered by the previous pay. Map carefully.
• Not projecting the buffer. Without the projection, you can't see whether you're building or depleting your buffer over time.
• Not updating. A calendar that's a month old is useless. Update each pay cycle with actual income and bills.

When a spreadsheet isn't enough

A pay cycle calendar spreadsheet is powerful, but maintaining it manually is work. The Payday Compass app does all of this automatically:

• Projects your balance forward based on income, bills, and spending
• Calculates your daily allowance for each cycle
• Shows your runway — when your balance will hit zero or your buffer
• Alerts you when a bill will breach your buffer
• Handles the three-pay month automatically

For a quick check on your current daily allowance and runway, use the free payday calculator.

Summary

A pay cycle calendar spreadsheet maps your income and bills to your actual pay dates, showing income, bills, net, daily allowance, and projected buffer for each cycle. Use SUMIFS to assign bills to cycles, calculate the daily allowance by dividing net by days in the cycle, and project the buffer forward to see whether you're building or depleting it. Identify tight cycles in advance, plan for the three-pay month, and include savings and debt repayment before living costs. The calendar turns budgeting from a monthly abstraction into a cycle-by-cycle plan that matches how you actually live.

For automatic pay cycle projection and runway, try the Payday Compass Money Runway.