Biweekly Budget Template: Plan Every Paycheck in Sheets or Excel

A biweekly budget template plans your money one paycheck at a time instead of one month at a time. Each paycheck covers the bills due before the next one arrives, and whatever is left is yours to spend or save until then. It is made for people paid every two weeks, whose paydays drift across the calendar and whose month sometimes holds three paychecks instead of two.

What the paycheck budget tracks

The Paycheck tab in our budget spreadsheet gives you the same view as the monthly tabs, what you planned next to what you actually spent in each category, but for a pay period instead of a calendar month. You choose the period:

• Weekly, for paychecks every Friday
• Biweekly, for paychecks every other week
• Semi-monthly, for two set dates a month
• Monthly
• Custom, for a schedule that fits none of those

The tools around it do the bill side. You enter each recurring bill once with its frequency and start date, and the spreadsheet schedules it for the whole year. A payment schedule lets you tick each bill off as paid, and the bill calendar shows past and upcoming bills on a monthly grid with weekly summaries, which is the quickest way to see what falls before your next payday.

Biweekly budget example: two paychecks in March

Example numbers: you take home $1,850 every other Friday, and your first payday of 2027 is January 8. That puts your March paydays on the 5th and the 19th. Your bills are internet $65 (due the 6th), phone $55 (10th), car payment $290 (15th), car insurance $130 (20th), electric $95 (24th) and rent $1,300 (1st).

The rule is simple: each bill comes out of the last paycheck before its due date.

Paycheck	Bills it covers	Bills total	Left after bills
March 5	Internet (Mar 6), phone (Mar 10), car payment (Mar 15)	$410	$1,440
March 19	Car insurance (Mar 20), electric (Mar 24), rent (Apr 1)	$1,525	$325
March 5, rebalanced	Same bills, plus $650 set aside for April rent	$1,060	$790
March 19, rebalanced	Same bills, minus the $650 already set aside	$875	$975

The first two rows show the classic biweekly trap. Rent is due April 1, one day before the April 2 payday, so it lands on the March 19 paycheck and leaves $325 for two weeks of groceries, gas and everything else. Setting aside half the rent from the March 5 paycheck evens the two periods out.

Three-paycheck months

At 26 paychecks a year, 24 cover two per month and the other two land in months that already have two. With paydays every other Friday from January 8, 2027, those months are April (2nd, 16th, 30th) and October (1st, 15th, 29th). If your first payday were January 1, 2027, you would get 27 paychecks that year, with three in January, July and December.

In a budget built on two paychecks a month, the third one ($1,850 here) has no monthly bills attached. Decide ahead of time where it goes.

Here is how the same yearly take-home of $48,100 (26 × $1,850) looks on each schedule:

Pay schedule	Paychecks a year	Per paycheck	Months with an extra paycheck
Weekly	52	$925	Four (five in a 53-payday year)
Biweekly	26	$1,850	Two (three in a 27-payday year)
Semi-monthly	24	$2,004	None
Monthly	12	$4,008	None

How to set up a biweekly budget in the spreadsheet

1. On the setup tab, choose your currency symbol, the month you start, and a zero-based or carry-over budget. Add your income sources and your categories.
2. Enter each bill as a recurring transaction with its frequency and first due date, so the whole year is scheduled from one entry.
3. Open the Paycheck tab, set the period to biweekly and select the pay period you are planning.
4. Plan the period, starting with the bills due before the next payday, then groceries, gas and savings.
5. Log spending as it happens. The Paycheck tab shows planned against actual for the period, so you can see mid-period whether groceries are running ahead.
6. Tick bills off in the payment schedule as you pay them, and check the bill calendar’s weekly summary before each payday.
7. Before a three-paycheck month, pick a job for the extra check: a fund in the sinking funds tracker, an extra payment in the debt snowball spreadsheet, or savings.

The method: budget by paycheck

Budgeting by paycheck works because it matches how money actually arrives. A monthly budget assumes all your income is available on the 1st; a paycheck budget asks only what this check must cover before the next one. Our guide on how to budget biweekly paychecks builds a full two-paycheck calendar and covers the weekly and semi-monthly versions.

Give every dollar of each paycheck a job and you are running zero-based budgeting one period at a time. If the amount changes from check to check (shift work, commission, freelancing), start from a baseline instead, as explained in budgeting with irregular income.

Most paycheck budgets fail on the bill side, not the spending side. A due-date inventory, as in how to organize bills, shows which bills cluster in one half of the month, and the bill tracker spreadsheet page covers the calendar and payment schedule in more detail.

Build your own biweekly budget template

Start with a Paydays tab. Type your first payday in A2 (for example 1/8/2027), put =A2+14 in A3 and fill down to A27 for 26 paydays. For weekly pay, use =A2+7, fill down to A53 and extend the ranges below to row 53. For semi-monthly pay on the 1st and 15th, type both January dates in A2 and A3, put =EDATE(A2,1) in A4 and fill down.

On a Bills tab, list each bill with its name in A, amount in B and due date in C. In D, find the paycheck that pays it, meaning the last payday before the due date:

• Paid from (D2): =MAXIFS(Paydays!$A$2:$A$27,Paydays!$A$2:$A$27,"<"&C2)

Back on the Paydays tab, type each take-home amount in B, then:

• Bills this paycheck (C2): =SUMIFS(Bills!$B:$B,Bills!$D:$D,A2)
• Left after bills (D2): =B2-C2
• Paychecks in a month (any spare cell): =COUNTIFS($A$2:$A$27,">="&DATE(2027,4,1),$A$2:$A$27,"<="&EOMONTH(DATE(2027,4,1),0)), which returns 3 for April with the example paydays

These formulas work in Google Sheets and in Excel 2019 or later. The differences are small but easy to trip on:

• Whole payday list in one formula: =SEQUENCE(26,1,DATE(2027,1,8),14) works in Google Sheets and in Excel for Microsoft 365 or Excel 2021 and later. Older Excel has no SEQUENCE, so use the fill-down version.
• Date format: the paydays and the Paid from column show as numbers until you format them. In Google Sheets use Format > Number > Date; in Excel use Home > Number Format > Short Date.
• A strange old date in Paid from: if you see 12/30/1899 in Google Sheets or 1/0/1900 in Excel, MAXIFS found no payday before that due date. Add an earlier payday to the list.

Who a biweekly budget suits

It suits you if you are paid weekly or every two weeks, if money runs thin in the days before payday, or if you want a plan for three-paycheck months before they arrive. It also helps when two paydays and a cluster of bills keep colliding in the same week.

It adds little if you are paid once a month and your bills are spread evenly; the monthly tabs do the same job with less setup. Paychecks do not import on their own: there is no bank connection, so you enter income and spending yourself. For income with no schedule at all, start with the baseline approach first and use a custom period once a pattern appears.

Before you plan your next paycheck, list the bills due before the one after it. That list is your whole plan for the next two weeks.