A biweekly paycheck budget template plans each paycheck on its own: list your paydays, assign every bill to the paycheck that arrives before its due date, and split what is left between spending and savings. Because 26 paychecks do not divide evenly into 12 months, two or three months a year bring a third paycheck with no bills attached. In the worked example below, a $1,900 paycheck covers $2,240 of monthly bills across two paydays, and the extra paychecks in 2027 add $5,700 of free cash.
The template uses four tabs and works the same in Google Sheets and Excel.
The layout: four tabs
| Tab | What it holds | Why it is separate |
|---|
| Paydays | Every payday of the year, one per row | The calendar every other tab reads |
| Bills | Each bill with amount and due day | Fixed costs you set once |
| Plan | One column per paycheck: bills, spending, savings | The budget you check on payday |
| Actuals | Your bank transactions with a category | Shows whether the plan held |
Paydays tab
Type your first payday of the year in A2, then =A2+14 in A3 and fill down. In column B, count how many paychecks fall in each payday's month:
=COUNTIFS(A:A, ">="&EOMONTH(A2,-1)+1, A:A, "<="&EOMONTH(A2,0))
Any row showing 3 belongs to a three-paycheck month.
How many paychecks you get in 2027
Biweekly pay means 26 paychecks in most years. Some years have 27, depending on your first payday. If your first 2027 payday is Friday 1 January, the dates run:
| Month | Paydays | Paychecks |
|---|
| January | 1, 15, 29 | 3 |
| February to June | two each | 2 |
| July | 2, 16, 30 | 3 |
| August to November | two each | 2 |
| December | 3, 17, 31 | 3 |
| 2027 total | | 27 |
If your first payday is a week later, your three-paycheck months move. The Paydays tab works this out for you, so check it rather than this table once you enter your own date.
Assign each bill to a paycheck
On the Bills tab, list the bill, the amount and its due date for the current month. Then one formula picks the paycheck that pays it:
=MAXIFS(Paydays!A:A, Paydays!A:A, "<="&C2)
This returns the latest payday on or before the due date in C2. MAXIFS works in Google Sheets and in Excel 2019 or later.
Worked example: $1,900 every two weeks
The figures below are an illustration, not anyone's real budget. Net pay is $1,900 per paycheck, which is about $4,116.67 a month on average (=1900*26/12). Budget with $3,800 a month, the two paychecks you get in every month, and treat the rest as a bonus.
| Bill | Amount | Due day | Category |
|---|
| Rent | $1,500 | 1st | Living |
| Electricity | $120 | 8th | Utility |
| Internet | $80 | 12th | Utility |
| Phone | $50 | 20th | Utility |
| Car loan | $320 | 22nd | Debt Repayment |
| Streaming and gym | $70 | 25th | Living |
| Credit card minimum | $100 | 28th | Debt Repayment |
| Total | $2,240 | | |
Paying rent in full from the first paycheck, along with electricity and internet, leaves it $200 for everything else, while the second keeps $1,360. A common fix is to set half the rent aside from each paycheck: $750 each.
| Paycheck 1 (bills due 1st–14th) | Paycheck 2 (bills due 15th–31st) |
|---|
| Net pay | $1,900 | $1,900 |
| Rent (half each) | $750 | $750 |
| Other bills | $200 (electricity, internet) | $540 (phone, car loan, streaming and gym, card) |
| Left after bills | $950 | $610 |
| Groceries | $250 | $250 |
| Transport | $90 | $90 |
| Dinner and bars | $80 | $80 |
| Shopping | $60 | $60 |
| To savings | $470 | $130 |
Both columns balance to zero: every dollar of the $3,800 has a job. The month saves $600, and each extra paycheck adds a full $1,900. With three extra paychecks in 2027 (27 minus 24), that is $5,700 on top.
If you want both paychecks to look the same, use the even-split method instead: every bill becomes =Amount*12/26 per paycheck. Rent turns into about $692.31 and the $2,240 of bills into about $1,033.85 per paycheck. You then pay each bill from a holding account when it is due. It is smoother, but it needs a separate account and a bit more discipline.
Categories that keep the plan readable
A paycheck plan only stays useful if your spending lands in the same buckets every time. Expense Sorted Local starts every new user on 14 default categories before it has learned from their own labels. They are a reasonable set for a paycheck budget too:
| Category | How to treat it in a paycheck plan |
|---|
| Living | Fixed (rent, subscriptions, gym) |
| Utility | Fixed (power, internet, phone, water) |
| Debt Repayment | Fixed (loans, card payments) |
| Tax | Fixed when you pay tax yourself |
| Kids | Fixed or variable (childcare, school fees) |
| Groceries | Variable, per paycheck |
| Transport | Variable (fuel, parking, public transport) |
| DinnerBars | Variable (restaurants, coffee, takeaways) |
| Shopping | Variable |
| Medical | Variable (pharmacy, GP, dental) |
| Travel | Sinking fund |
| Business | Separate if you are self-employed |
| Income | Pay and interest, not spending |
| Transfer | Moves between your own accounts, not spending |
Two of these are not spending at all. Income is the paycheck itself, and Transfer covers moves between your own accounts. Leave both out of spending totals, or the moment you move money to savings the sheet counts it as an expense.
Check the plan against your bank CSV
On the Actuals tab, import your bank's CSV export with Date, Description, Amount and Category columns. Then compare each category with the plan for the pay period:
=SUMIFS(Actuals!C:C, Actuals!D:D, "Groceries", Actuals!A:A, ">="&B1, Actuals!A:A, "<"&B1+14)
where B1 is the payday that starts the period. If categorizing every row is the slow part, auto-categorizing bank transactions in Excel covers formula and rule options, and the bank transaction categorization guide compares the approaches. For a month-at-a-time view next to this one, the monthly expense tracker template uses the same columns.
Irregular costs (car registration, annual insurance, holidays) are what usually break a paycheck plan. Put a fixed amount per paycheck into a sinking fund spreadsheet and the extra paychecks are a natural way to top it up.
When this template does not fit
A biweekly template assumes the same net pay every two weeks. If your hours or commissions change, budget from your lowest normal paycheck and treat anything above it as extra. If you are paid twice a month on fixed dates (for example the 15th and the last day), you get 24 paychecks and no extra ones, so plan with monthly bill amounts instead. And if your bills are more than two paychecks can cover, the template will show the shortfall; it cannot close it.
FAQ
How does a biweekly paycheck budget work?
You budget each paycheck separately instead of a whole month. Every bill is assigned to the paycheck that arrives before its due date, and whatever is left on that paycheck is split between groceries, transport, other spending and savings.
How many paychecks do you get a year if you are paid biweekly?
Usually 26, and in some years 27. If your first 2027 payday is Friday 1 January, you are paid 27 times in 2027, with three paychecks in January, July and December.
What do I do with the third paycheck in a month?
If your monthly bills are already covered by two paychecks, the third one is free of bills. Most people send it to savings, a sinking fund or extra debt payments. In the worked example on this page that is $1,900 each time.
How do I convert a monthly bill to a biweekly amount?
Multiply the monthly amount by 12 and divide by 26. A $1,500 monthly rent becomes about $692.31 per paycheck. Use this when you want every paycheck to set aside the same share instead of paying the full bill from one paycheck.
Which formula finds the paycheck that pays a bill?
MAXIFS. =MAXIFS(Paydays, Paydays, "<="&DueDate) returns the latest payday on or before the bill's due date. It works in Google Sheets and in Excel 2019 or later.
