Set Up a Monthly Chores and Bills Tracker in Google Sheets

Tracking Bills and Chores on One Sheet

Does your living room whiteboard keep turning into a messy ledger of electric bills and paper towel IOUs? Most shared households try juggling three apps before realizing a single Google Sheet does the job better. You do not need complex project management software. A basic spreadsheet with clear categories for monthly bills and chore supplies keeps everyone honest.

Rent, internet, and electricity stay on fixed schedules. Chores get trickier because cleaning itself is labor, but cleaning supplies cost real cash. Turns out, combining both into one ledger prevents the classic argument where someone claims their deep cleaning compensates for a missing utility payment. Everything sits in plain view.

Recommended Columns for the Monthly Log

Keep the column structure strict from day one. When columns stay uniform, tallying totals takes seconds instead of hours.

Here is a tested layout that balances recurring bills with chore costs:

Categorizing items as either "Bill" or "Chore" makes month-end filtering clean. If someone buys vacuum filters, it goes under "Chore". If the water bill arrives, mark it "Bill".

How to Handle Splits and Reimbursements

Math errors cause bad roommate vibes. You can prevent them by writing simple formulas in the individual share columns rather than entering hard numbers by hand.

1. Set up an equal split formula. In cell G2 (Jordan's share), type =E2/2 if Jordan and Taylor split everything down the middle. For four roommates, divide by four.

2. Handle upfront reimbursements cleanly. Sometimes one roommate pays back another directly through Venmo or Zelle. As noted in Expense Sorted's guide on splitting expenses, log a direct repayment by setting the category to "Reimbursement", putting 100% of the cost in the debtor's column, and 0% for the person receiving cash. That offsets the balance without creating phantom expenses.

3. Add a check column at the end. Create column J labeled "Split Check". Enter =SUM(G2:H2)-E2. If the result is $0.00, your splits equal the total amount. If it shows any other number, someone mistyped a share.

4. Total each person's balance at the bottom. Use =SUM(G2:G50) at the foot of Jordan's share column. In an adjacent summary cell, subtract what Jordan already paid upfront from what Jordan owes. That single number tells Jordan whether to send money or wait for a payout.

Protecting Cells and Setting Permissions

Thing is, shared spreadsheets break quickly when multiple people type over formulas. One accidental backspace in a total cell ruins the entire monthly reconciliation.

Google Sheets lets you lock specific ranges while leaving data rows open. Following the steps in the SheetsBootcamp tutorial on protecting sheets and ranges, highlight your header row (A1:I1) and your formula totals at the bottom. Right-click, select "View more cell actions", and pick "Protect range". Set permissions so only the sheet creator can modify those cells. Everyone else can still enter dates, descriptions, and amounts in the empty rows below.

For file sharing:

• Add roommates via their Google email addresses rather than creating a public link.
• Grant them "Editor" access so they can log expenses from their phones.
• Uncheck "Editors can change permissions and share" in the sharing settings gear menu.

These three precautions stop accidental formula deletions and keep your household finances private.

The Monthly Tab Reset

Do not overwrite last month's numbers. You need that record when utility disputes pop up three months later.

Right-click the current month's tab at the bottom of your screen and select "Duplicate". Rename the new tab for the upcoming month, like "May 2026". Highlight the data rows from column A through E in the new tab and hit delete. Leave the headers, split formulas, and bottom summaries untouched.

If someone still owes money when the month closes, carry that single figure forward. Insert an entry in row 2 titled "April Unsettled Balance" under the Description column. Put the remaining balance in the debtor's share column. That clears the old tab completely while rolling the debt into the current period.

Where Shared Spreadsheets Go Wrong

Spreadsheets fail when people try to make them do too much. To be honest, I know people who spend hours building macro scripts and pivot tables for an apartment, which is kind of hilarious when all you really need is to know who bought paper towels and whether someone paid their half of the wifi. Fancy automation just gives your roommates an excuse not to use the sheet.

Another trap is logging micro-expenses. Splitting a $1.89 sponge turns expense tracking into a chore of its own. Agree as a house on a threshold, such as $10 or $15, where purchases below that line either rotate informally or get bundled onto a single month-end receipt.

Keep receipt photos in one shared Google Drive folder. Whenever you buy cleaning supplies or pay a utility bill, snap a photo and drop the link in column I. That eliminates the "did this really cost fifty bucks" interrogation on settlement day.

Establishing Your Household Settlement Habit

A sheet only works if people look at it regularly.

Pick one evening near the end of the month for a ten-minute check-in. Open the tracker together, verify that all receipts are linked, and inspect the check column. Send payments right there on your phones before closing the laptop.

Open Google Sheets now and set up the header row. Enter last month's electric bill as a practice run to confirm your formulas balance out to zero.