Shared Expense Calculator
Automatically calculate who owes whom when splitting expenses among groups.
This template tracks shared expenses and automatically calculates settlement amounts between participants. Input who paid for what and how much, and the backend formulas determine net balances—showing exactly who owes money to whom and how much. Perfect for group trips, roommates, events, or any situation where multiple people share costs and need fair reimbursement.
What's inside
- Automatic settlement calculation showing net balances
- Tracks who paid for each expense
- Date and description logging for each transaction
- Calculates amounts owed between group members
- Handles multiple participants
Download this template
.xlsx · 2 sheets · included with lifetime access
More in Budgeting & Expense Management
Budgeting & Expense Management12-Month Yearly Budget Tracker
Plan and monitor monthly budgets across a full year with automatic average calculations.
- 12 monthly columns (Mês 1-12)
- Automatic AVERAGE calculations
- Simple row-based data entry
Budgeting & Expense ManagementAcademic Club Budget Template
Plan and track academic club finances with income and expense overview.
- Automatic income total calculation
- Budget vs actual tracking
- Expense categorization by activity type
Budgeting & Expense ManagementActual vs Budget Comparison
Track spending against budget with monthly summaries and year-to-date variance analysis.
- Automatic actual vs budget comparison by account
- YTD summary with remaining budget calculations
- Monthly expenses broken down by date and account
Budgeting & Expense ManagementActual vs Budget Comparison
Track spending against budgets with YTD summaries, monthly breakdowns, and variance analysis across accounts.
- Year-to-date actual vs budget comparison by GL code and account
- Monthly expense summary with automatic date rollups
- Itemized expense detail with invoice tracking