How to budget by paycheck: give every payday a job
Short answer
List every bill with its due date, then list your paydays for the month. Give each bill to the last paycheck that lands at least two days before its due date. What is left on each paycheck goes to savings, debt and spending until nothing is unassigned. If you are paid every two weeks, two months of the year bring a third paycheck: plan it for savings or debt in advance.
- Write down your pay schedule (weekly, every two weeks, twice a month or monthly) and the exact paydays.
- List every bill once: name, amount and due day.
- Assign each bill to the latest payday that is at least two days before it is due.
- From what is left on each paycheck, set savings, extra debt payments and spending (groceries, gas, fun).
- Aim for $0 left to assign on every paycheck, and check it again each payday.
Copy-paste code
Spreadsheet formulas (Excel 2019+/365 or Google Sheets)
Paycheck that covers a bill: =MAXIFS(Paydays, Paydays, "<="&(DueDate-2))
Total bills on a paycheck: =SUMIFS(BillAmounts, CoveredBy, Payday)
Left to assign: =Pay - BillsTotal - Savings - Debt - Spending
Paychecks in a month: =COUNTIFS(Paydays, ">="&MonthStart, Paydays, "<="&EOMONTH(MonthStart,0))| Paycheck | Bills it covers | Savings + debt | Spending | Left |
|---|---|---|---|---|
| Fri 8 Jan, $2,450 | Rent $1,300 (due 15th), car $340 (due 18th) | $250 | $430 | $130 |
| Fri 22 Jan, $2,450 | Electric $140, insurance $160, phone $65, internet $70 | $1,400 | $430 | $185 |
Source: example household, made-up numbers
Three-paycheck months in 2027
Paid every other Friday starting 1 January 2027: January, July and December have three paydays. Starting 8 January 2027: April and October do. Paid every Friday: January, April, July, October and December have five paydays.
Budget the month as if it had two (or four) paychecks; the extra one becomes a planned savings deposit or debt payment instead of disappearing.
Why not a monthly budget?
A monthly budget says you can afford rent, but not which paycheck has to cover it. When rent is due on the 1st and you are paid on the 8th and 22nd, the paycheck view shows the gap before it becomes a late fee.
Paycheck Map Budget by Paycheck Spreadsheet: Every paycheck gets a plan
from $7.99Paycheck Map does the matching for you in Excel or Google Sheets: pick weekly, biweekly, semi-monthly or monthly pay, list bills once, and every payday shows the bills it covers, savings, debt, spending and what is left, with a debt snowball and sinking funds. $7.99 once.
Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)Questions
Does this work with irregular income?
Yes: budget from your lowest normal paycheck and put anything above it straight to savings or debt.
What about bills that are due before my first payday?
Cover them from the last paycheck of the previous month; the plan rolls month to month.
Is this financial advice?
No. It is a budgeting method; your numbers and choices are your own.
Free: the Free Planner Sampler
4 printable previews (budget, debt payoff, focus planner, habit tracker), then 5 short emails with formulas that make a budget stick.