Cover placeholder
010 / Automation
Split Bill & Expense Sharing
Fair splits and who-owes-whom summaries.
Solo developer2025Apps ScriptSheets
03 / Context
Problem
Pembagian tagihan grup sering membingungkan; sulit tahu siapa hutang ke siapa setelah banyak transaksi.
04 / Concept
Solution
Tool Sheets yang menghitung split adil dan merangkum saldo antar anggota secara otomatis.
01 / Outcome
Deliverable
- Sheet input pengeluaran
- Hitungan split otomatis
- Ringkasan who-owes-whom
02 / Process
Workflow
- 1Input expense
- 2Pilih peserta
- 3Hitung share
- 4Agregasi saldo
- 5Tampilkan settlement
05 / System
Architecture
- Sheets UI
- Apps Script calculator
- Summary views
06 / Diagram
Flowchart
01Add expense
02Allocate shares
03Net balances
04Suggest transfers
07 / Data
Database Design
Expenses
| Column | Type | Notes |
|---|---|---|
expense_id | STRING | — |
payer | STRING | — |
amount | NUMBER | — |
participants | STRING | — |