How to Budget a Biweekly Paycheck in Google Sheets (26 Paychecks, 12 Months of Bills)

A monthly budget assumes money arrives once a month. Biweekly pay arrives 26 times a year, which is not 12 × 2. Two months a year you get three paychecks, the rent always lands on the same one, and "I make 4,800 a month" is true in ten months and wrong in two. Here is how to budget by paycheck instead, with the numbers from the template's sample.

The 26 vs 12 problem

Take a biweekly paycheck of about 2,400. Two paychecks a month feel like 4,800 a month. But 26 paychecks × 2,400 = 62,400 a year, and 62,400 ÷ 12 = 5,200 a month. That is a 400-a-month gap between how it feels and what it is. The gap arrives as two "extra" paychecks a year, in the two months that have three pay dates.

Which months? It depends on your first pay date. For the sample schedule (first paycheck Friday, September 4, 2026, then every 14 days) the pay dates fall like this:

Shift the first pay date by a week and the three-paycheck months move. There is no rule of thumb; you have to list the dates. Which is the first thing the spreadsheet does.

Step 1: list the pay dates

One yellow cell with the first pay date, then a formula that adds 14 days, filled down for as many periods as you want (the template does 60, a bit over two years).

B6:  2026-09-04          ← first pay date, typed
B7:  =B6+14              ← fill down

Now number each paycheck within its month. This is the column that makes bill assignment possible: it answers "is this the 1st, 2nd or 3rd paycheck of the month?" for every row.

=COUNTIFS($B$6:$B$65, ">="&DATE(YEAR(B6),MONTH(B6),1), $B$6:$B$65, "<="&B6)

It counts pay dates from the first of the month up to this one. A third paycheck gets a 3, and you can see the three-paycheck months without a calendar.

Step 2: assign every bill to a paycheck

The sample has 12 recurring bills, 2,437 a month. Each one has a due day and a paycheck number: bills due early in the month come out of paycheck 1, bills due after the second pay date come out of paycheck 2.

The bills per paycheck is one SUMIFS: sum the Amount column where the Paycheck column equals this row's paycheck number.

=SUMIFS(Bills!$D$6:$D$45, Bills!$I$6:$I$45, J6)
   D = amounts, I = paycheck number, J6 = this row's paycheck-of-month

Then left over = income − bills − planned spending − savings, per row. Here is what the two sample paychecks look like:

A monthly budget would show 4,800 income, 2,437 bills, 1,300 spending, 500 savings and 563 left, and everything looks fine. The paycheck view shows that the first half of the month runs on 123. That is the number that decides whether the card gets used on the 10th.

Step 3: fix the lopsided paycheck

Rent on paycheck 1 is the usual reason the first half of the month is tight. Three ways to even it out, in order of how much they change:

1. Move small bills. Anything with a due day near the second pay date can move to paycheck 2. In the sample, the split is already 1,477 vs 960, and rent alone is 1,400: there is not much left to move. Which leads to the next option.
2. Uneven savings. Put 100 to savings from paycheck 1 and 400 from paycheck 2 instead of 200 / 300. Total savings unchanged, paycheck 1 leaves 223 instead of 123.
3. Get one paycheck ahead. Keep one full paycheck in the account as a buffer, so the rent due on the 1st is paid from the paycheck that arrived two weeks before. The third paycheck in October is the easiest way to build that buffer once, and after that the calendar stops mattering.

Step 4: what to do with the third paycheck

In a three-paycheck month, paychecks 1 and 2 still carry every bill. Paycheck 3 owes nothing but its own planned spending. In the sample that is about 2,400 income − 650 spending = 1,750 free, twice a year. Decide in advance where it goes, or it goes to nothing in particular:

• the one-paycheck buffer from step 3 (once);
• the highest-APR debt (the snowball vs avalanche article shows what a one-off extra does to the debt-free date);
• a sinking fund for the next irregular bill: car insurance renewal, holidays, a trip.

Skip the build

The three formulas above give you the core: pay dates, paycheck-of-month and bills per paycheck. What they do not give you is the bill calendar for the month, the "due in the next 7 days" list, a 600-row expense log matched to the right paycheck by date, and sinking funds with paychecks-to-go. That is the template.

Paycheck Budget Spreadsheet for Google Sheets and Excel

Set the pay frequency and the first pay date, type each bill once with its due day and paycheck number, and every pay date shows income, bills, planned spending, savings and left over. Bill calendar, expenses log with auto-categories, sinking funds, 60 pay periods. Lite (4 tabs) and Full (10 tabs) in one purchase.

Get the Paycheck Budget on Etsy →

Only need the pay dates and bills per paycheck? The Simple Paycheck Budget is the one-tab version.

See it work

FAQ