Bi-Monthly Budget Template in Google Sheets: Setup Guide

A bi-monthly budget template in Google Sheets can track income, planned spending, and actual expenses for each pay period. Create a transaction log and a summary table, then use SUMIFS to total expenses between two dates; first decide whether “bi-monthly” means twice a month or once every two months, since people use the term both ways.

What “bi-monthly” means for a budget

In everyday use, “bi-monthly” may mean two times per month or once every two months. For budgeting, people often mean a twice-monthly paycheck schedule, such as paydays on the 1st and 15th. That is different from biweekly pay, which arrives every two weeks and usually produces 26 paychecks per year. If your pay arrives every two weeks, budget by the actual pay dates rather than assuming two checks every calendar month.

This guide uses a flexible date range, so the same sheet can cover a half-month, a biweekly pay period, or a two-month period. You enter the start and end dates for the period you want to review. The categories and transaction log stay in place while the date range changes.

Build the template layout

In a blank Google Sheets spreadsheet opened in a web browser, create a sheet named Budget. Set up a small period header and two tables. For example, put “Period start” in A1 and its date in B1, then “Period end” in C1 and its date in D1. Enter actual date values, not text that merely looks like a date.

Starting in A4, create a budget summary with these headers: Category, Planned, Actual, and Remaining. Enter expense categories in A5:A12, such as rent, utilities, groceries, transportation, phone, debt payments, savings, and personal spending. Put planned amounts in column B. The transaction log can sit to the right, with headers Date, Category, and Amount in F1:H1; each new purchase or bill goes on its own row below.

Use one consistent category spelling in the summary and transaction log. “Groceries” and “Grocery” will be treated as different labels.
Enter each expense as a positive amount. The remaining calculation will subtract it from the planned amount.
Keep the transaction log as a running list rather than replacing old rows when a new pay period starts.
Format the date columns as dates and money columns as currency using Format > Number.

The layout separates the plan from the record of what happened. That makes it easier to change the period dates and compare spending without rebuilding the summary each time.

Add formulas to calculate spending

With transaction dates in F2:F, categories in G2:G, amounts in H2:H, the matching summary category in A5, the start date in B1, and the end date in D1, enter this in C5 to total that category’s expenses within the selected period:

=SUMIFS($H$2:$H,$G$2:$G,$A5,$F$2:$F,">="&$B$1,$F$2:$F,"<="&$D$1)

Copy the formula down the Actual column for the other categories. The dollar signs keep the transaction ranges and date cells fixed while the category reference changes by row. For example, if the selected dates are April 1 through April 15 and there are two grocery transactions of $42 and $58 in that range, the Groceries result is $100. Transactions dated outside the range are excluded.

With the planned amount in B5 and the calculated actual amount in C5, enter this formula in D5 to show what remains in that category:

=B5-C5

Copy it down the Remaining column. If the plan is $300 and the actual total is $100, the result is $200. A negative result means spending exceeded the planned amount; it is a signal to review the plan or the transactions, not a special error.

With planned amounts in B5:B12, enter this formula in the total row under Planned:

=SUM(B5:B12)

With actual amounts in C5:C12, enter this formula in the same total row under Actual:

=SUM(C5:C12)

For instance, if the category plans total $2,000 and recorded expenses total $1,850, the totals display those amounts and the combined unspent plan is $150. Make sure your category list includes the expenses you intend to monitor; a summary cannot account for transactions that have not been logged or categorized.

Use the sheet for each pay period

For a twice-monthly schedule, set the period dates to match how you want to organize cash flow. You might use the 1st through the 15th, then the 16th through the last day of the month. If your paycheck dates differ, use the dates that fit your actual pay cycle. For a biweekly schedule, enter the real start and end dates for each two-week period; the dates will not always align with calendar-month boundaries.

Enter the period start and end dates in the header.
Update planned category amounts based on income available for that period and bills due before the next payday.
Add expenses to the log as they occur, including the date, category, and amount.
Review Actual and Remaining, and investigate any unexpectedly high or negative totals.
At the next period, change the date range and revise the plan without deleting the transaction history.

When a bill covers a full month but you receive two checks, decide consistently how to assign it. You could budget the entire bill in the period when it is due, or reserve part of it from each check. Either approach can work as a tracking method; avoid counting the same bill twice in the total plan.

Plan income and irregular expenses

The expense summary is only one side of a useful budget. Add an income section with expected take-home pay and other reliable income for the selected period. Compare that total with planned spending and saving. If the plan exceeds available income, adjust categories before treating the difference as money available to spend. For variable income, consider entering a conservative estimate and updating the sheet when money actually arrives.

Irregular expenses can make a short pay-period budget look misleading. Annual insurance, school costs, car repairs, and holiday spending may not occur in every period. One way to prepare is to give such costs their own category and reserve a portion across multiple periods. For example, if an illustrative $600 bill is expected in six months, setting aside $100 in each of six monthly periods would build the full amount, assuming the timing and amount remain unchanged. This is a planning example, not financial advice; check actual bills and obligations.

You can also add a “sinking funds” section for planned future costs, but distinguish money reserved for a bill from money already spent. A cash-flow plan may show a transfer to savings as planned allocation; an expense report may treat that transfer differently. Choose a method and apply it consistently so totals remain interpretable.

Make the template easier to use

Google Sheets can make the sheet clearer without adding complex formulas. Freeze the header row using View > Freeze, and use Data > Create a filter if you want to sort or filter the transaction log. A filter can help isolate one category or period while reviewing the records. It does not change the underlying totals.

For visual alerts, select the Remaining cells and use Format > Conditional formatting. You can apply a rule to highlight values below zero. Pick a restrained color and make sure the number remains readable. This is a visual cue only: it does not prevent an overspend or verify whether a transaction is correct.

Consider using a dropdown for transaction categories to reduce spelling differences. Select the category cells in the log and choose Data > Data validation, then set a dropdown from a range containing the category list. Google Sheets’ labels and options can change over time, so follow the current on-screen data-validation choices. If you share the file, use an appropriate sharing permission and avoid placing account numbers, passwords, or other sensitive credentials in the sheet.

Common problems and how to fix them

A category total is zero: Check that the transaction category exactly matches the summary label, the amount is numeric, and the transaction date falls within the selected dates.
A date is ignored: A date pasted as plain text may not compare as a real date. Re-enter it as a date value and check the cell format.
The total is too high: Look for duplicate log rows, transactions entered in the wrong period, or a category included twice in the summary.
The remaining amount is negative: Confirm the transaction is genuine, then decide whether the category plan needs updating or spending needs attention.
A bill appears in both periods: The date-based formula counts a transaction only in the period containing its date, but a plan may allocate the bill in advance. Keep planned allocations distinct from recorded payments.

Google Sheets recalculates formulas as cells change. If a result still looks wrong, check the formula references and whether the period start date is earlier than or equal to the end date. Also make sure you have not entered refunds as ordinary positive expenses if your goal is to show net spending; you may need to record refunds consistently, such as with a negative amount, and understand how that affects the summary.

Google Sheets versus a downloadable template

A custom sheet is useful when you want control over categories, period dates, and sharing. It also makes you responsible for setting up formulas and checking the data. A prebuilt Google Sheets template may save setup time, but inspect its formulas and sharing settings before entering personal information. Templates vary, and a polished design does not guarantee that every category or calculation suits your situation.

Google Sheets is browser-based and saves changes to the file in Google Drive when you are online. Excel uses different menus and has its own compatibility details, so instructions for one program should not be assumed to match the other exactly. The formulas shown here use functions available in Google Sheets. You do not need a paid budgeting add-on for this basic layout; any third-party tool may have separate features, costs, or data-sharing terms to review.

Frequently Asked Questions

Is bi-monthly the same as biweekly?
No. Bi-monthly can mean twice a month or every two months, while biweekly usually means every two weeks. Because these schedules produce different periods and paycheck counts, set the sheet dates to your real pay cycle.

Can I use this budget template for paychecks on the 1st and 15th?
Yes. Enter the first half-month’s start and end dates, then update them for the second half. If a payday falls on a weekend or holiday, use the dates that match when you actually receive and manage the money.

Can the template track a full month instead?
Yes. Set the start date to the first day of the month and the end date to the last day. The same transaction formula totals only dates inside that range.

Do I need to enter every purchase?
For the actual totals to be complete, record each expense you want included. You can enter transactions daily or import and review records periodically, but check for duplicates and make sure categories and dates are correct.

Can I use this in Excel?
The basic functions and layout have Excel counterparts, but menus and some spreadsheet behaviors differ. This setup is written for Google Sheets in a browser; follow Excel-specific instructions if you rebuild it in Microsoft Excel.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.