All sheetsPaycheck to Paycheck Budget in Google Sheets: Plan Every Payday | Efficiency Sheets
Paycheck to Paycheck Budget in Google Sheets: Plan Every Payday
Budget by paycheck instead of by month. Which bills each payday covers, the Google Sheets formulas to sort them, and what to do with the two extra paychecks a year.
Efficiency Sheets ·
A paycheck budget plans each payday on its own. Instead of one monthly total, you ask: which bills does this paycheck have to cover before the next one arrives? It's the most useful way to budget when money is tight between paydays.
How it works
List every bill with its amount and due date.
Assign each bill to the paycheck that lands before its due date.
Subtract those bills from that paycheck. What's left is your spending money until the next payday.
An example
Say you're paid $1,900 on the 1st and the 15th.
Bill
Due
Amount
Paid from
Rent
1st
$1,200
1st paycheck
Car payment
8th
$340
1st paycheck
Phone
12th
$65
1st paycheck
Electric
20th
$110
15th paycheck
Car insurance
22nd
Questions
How many paychecks do I get a year if I'm paid every two weeks?
26. That's two a month for ten months and three in two months. Budget on two a month and treat the third paycheck in those two months as extra.
Should I budget by paycheck or by month?
If bills fall due before your next payday and money gets tight mid-month, budget by paycheck. If you have a cushion of a month's expenses, a monthly budget is simpler.
What if a bill is due right before payday?
Assign it to the paycheck before. The rule is that each bill is paid from the last paycheck that lands before its due date.
Does this work for weekly pay?
Yes. Use four paycheck columns instead of two, and plan the fifth payday in some months as extra.
The 1st paycheck covers $1,605 in bills and leaves $295 until the 15th. The 15th paycheck covers $325 and leaves $1,575. Same monthly income, but you can see that the first two weeks are the tight ones, so that's when to keep spending low and the second half is when to save.
Setting it up in Google Sheets
List bills in columns A to C: name, due day (just the number, like 8) and amount. Put your paydays in F1 and F2 (for example 1 and 15).
In column D, find the paycheck that pays each bill:
=IF(B2<$F$2,"Paycheck 1","Paycheck 2")
Then total each paycheck's bills:
=SUMIF(D:D,"Paycheck 1",C:C)
And what's left from each one:
=1900-SUMIF(D:D,"Paycheck 1",C:C)
If your paydays are on the 5th and 20th, a bill due on the 2nd is paid by the 20th paycheck from the month before. Move those by hand, or set D to a dropdown (Data → Data validation) so you choose the paycheck yourself.
Paid every two weeks?
Biweekly pay means 26 paychecks a year, so two months each year have three. Budget every month on two. When a third paycheck arrives, it isn't needed for bills, so it can go straight to savings, debt or a sinking fund. Those two paychecks are often the easiest money you'll ever save.
Building a buffer
The goal of a paycheck budget is to stop needing one. Each payday, move even $25 of the leftover into savings. Once that buffer equals a month of bills, you can pay everything from last month's income and switch to a simpler monthly budget.
A ready-made version
The Ultimate Budget Sheet has income by payday (expected and actual), bills with due dates and paid checkboxes, and a Left to Spend total that updates as you type, so you can see each payday's money without building the formulas yourself.
