How to Set Up a Monthly Budget for Friends: Simple Shared Expense Tracker

✨ Community Finance

Published: May 4, 2026

Friends can set up a monthly shared budget using a free Google Sheets template with columns for expenses, participant marks (enter "1" for who shares it), split types (e.g., equal per person or 100%/0% for reimbursements), and balances. Review weekly and settle monthly via cash or payment apps. This works for U.S. friend groups tracking recurring shared costs like dinners, gifts, events, or club dues without needing paid apps.

Such a setup keeps records clear, reduces disputes, and handles equal or uneven splits. For example, mark all participants with "1" for a group dinner, or adjust for one friend covering more, as in KeyCuts blog examples.

Real-time collaboration lets everyone see updates live, per ExpenseSorted guidance.

Assign roles and set group rules before building the budget

Start with a quick group discussion to assign roles and agree on rules. This prevents confusion over who enters expenses or how to split costs.

Decide on a main tracker: one person enters most receipts, while others add their own within 3 days. Set a review cadence, like weekly check-ins via text or call, and full monthly tallies at month-end.

Choose split preferences upfront. Equal splits work for shared items like club dues. For uneven cases, use percentages: one friend ate 60% of a pizza, others 20% each, and one skipped at 0%, as in Ratehub.ca examples (adapt for U.S. groups). Sample rules script: "Enter receipts within 3 days with photo links. Settle IOUs by month-end via cash, Venmo, or Zelle. Disputes go to group vote."

Document these in a shared note or sheet tab. Tradeoffs: Equal splits are simplest but unfair if usage varies; uneven splits are precise but need consensus.

Choose a lightweight tracking tool for your monthly budget

Spreadsheets suit most friend groups for monthly budgets. Google Sheets allows real-time edits: everyone with edit access sees live changes and can update simultaneously.

Share via link with edit permissions for collaboration. Use "commenter" access for read-only views if needed. Google Sheets works on phones for quick adds.

Excel fits offline needs: save locally and email updates. For very small groups, a shared note app or printable form may suffice over full trackers.

Skip complex apps unless your group exceeds 10 people or needs automated reminders. Simple rules often handle low-volume expenses.

Build the core monthly budget sheet with essential columns and splits

Create a new Google Sheet or Excel file. Name it "Friends Monthly Budget - 2026" and share the link.

Add these core columns in row 1:

Column	Purpose	Example
A: Date	When expense happened	2026-01-15
B: Description	What it was	Group dinner at Taco Truck
C: Amount	Total cost	$80
D: Paid By	Who paid upfront	Alex
E: Split Type	Equal, uneven, or reimbursement	Equal
F-J: Participants (one per friend)	Mark "1" if included, "0" or blank if not (per KeyCuts)	Alex:1, Jordan:1, Taylor:1, Riley:0
K: Notes	Receipt link or details	[Google Drive link]

For equal splits, calculate per-person share in a formula column: divide amount by sum of participant 1s (e.g., per KeyCuts approach).

Handle reimbursements: Mark one person at 100%, others at 0% in participant columns, and note "Reimbursement" in Split Type, per ExpenseSorted templates.

Example: Group dinner ($80, 3 participants): Mark Alex, Jordan, Taylor as "1", Riley "0". Each owes ~$26.67.

Uneven example: Pizza ($40, uneven): Alex 60% ($24), Jordan/Taylor 20% ($8 each), Riley 0% (adapted from Ratehub.ca workflow).

Add a summary tab: Use SUMIF to tally balances per person (e.g., total owed minus paid).

Set monthly tabs: One per month for organization. Common mistake: Forgetting to protect formula rows - lock them via sheet protections.

Handle receipts, updates, and monthly reviews

Snap photos of receipts right after purchase. Upload to free Google Drive or Dropbox, paste shareable links in the Notes column.

Update the sheet after each expense, ideally same day. Assign a weekly reviewer to scan for imbalances: Text group, "Balances: Alex owes $15, others even."

Monthly review: Meet virtually or in person end-of-month. Tally totals, confirm splits. Sample script: "From January sheet: You owe $25 from pizza - Venmo to Alex? Or cash next meetup."

Common mistakes: Wrong sharing permissions (use edit links, not view-only); ignoring zeros for no-shows; duplicate entries. Weekly check-ins catch these early.

For ongoing accuracy, set phone reminders for reviews.

Settle up and maintain records

At month-end, request payments based on balances. Options: Cash at next meetup, or apps like Venmo/Zelle for speed. Note payments in a "Settled" column (e.g., Date Paid, Amount, By Whom).

Export the sheet monthly: File > Download > PDF or CSV for records. Keep a master folder of exports and receipt photos.

Tradeoffs: Cash avoids fees but risks loss; apps are trackable but may have limits - check terms. For U.S. readers, retain records for personal use; consult a pro for tax questions on large reimbursements.

This keeps everything documented without complexity.