Google Pay Inspired Expense Sharing System

A Data Science-based Expense Sharing System that tracks group expenses, calculates fair settlements, and provides analytical insights using Python and data visualization techniques.

📌 Project Overview

Managing shared expenses manually can be confusing and error-prone. This project automates expense tracking and settlement calculation while ensuring fairness in contributions.

The system:

Records group expenses

Splits expenses equally or by weighted contribution

Calculates who owes whom

Tracks balances dynamically

Visualizes spending patterns

🎯 Objectives

Automate group expense calculation

Ensure fair splitting logic

Handle uneven contributions

Track pending payments

Provide spending insights using data visualization

🛠️ Tech Stack

Python

Pandas

NumPy

Matplotlib

Jupyter Notebook

⚙️ How It Works

1️⃣ Input Data

Each expense record contains:

ExpenseID

PaidBy

Amount

Participants

2️⃣ Expense Splitting Methods Equal Split

Total expense divided equally among all participants.

Weighted Split

Participants contribute based on predefined percentage weights.

🔍 Data Processing Steps

Data cleaning and preprocessing using Pandas

Converting participant lists into structured format

Calculating individual expense shares

Generating user balance ledger

Creating settlement summary

📊 Data Visualization

The project generates:

Bar chart of total expenses per user

Spending comparison across group members

Settlement balance overview

🚧 Edge Case Handling

Uneven contributions

Missing payments

Refund adjustments (negative entries)

Partial participation