<aside> 🏦 IronBank — Home. Expenses arrive automatically from Telegram and Splitwise — you build the views once, then just read them. Your to-do list is ⚠️ Needs Your Attention, below. Full step-by-step setup: Dashboard Build Guide. This build uses grouped tables with column sums instead of charts.

</aside>

⚠️ Needs Your Attention

<aside> 👉 Your to-do list — keep it at the top. Build three linked views: (1) Expenses where Settlement Status = "Needs mapping" — parked, waiting on a person; (2) People where Splitwise User ID is empty — people to set up; (3) Expenses where Sync Action is not None — queued deletes/re-pushes. To clear a parked expense, set the person up (see How to Resolve below).

</aside>

Untitled


💰 Balances at a Glance

<aside> 👉 People database. Build a Table sorted by Net Balance (descending) showing Net Balance + Net Balance By Group, and turn on a Sum on the Net Balance column — that total is your overall net position. Positive = they owe you; negative = you owe them. Numbers come from Splitwise, refreshed each sync. No chart needed — the column Sum does it.

</aside>

Untitled

📊 Expenditure

<aside> 👉 Expenses database. Build grouped Tables with a Sum on Amount (your share): This Month (filter Date is this month), By Category (group by Expense Type), By Month (group by Month), By Year (group by Year). Each group carries its own total — your spend breakdown without any chart.

</aside>

Untitled

🔧 Splitwise Manager

<aside> 👉 Groups database as a Table — tick Allowed to import a group (its history backfills once; Backfilled marks it done). Splitwise Users is your read-only contact list — the pick-list behind each person's Splitwise Identity. Set someone up in People: pick their Splitwise Identity, optionally a Default Group (leave empty to settle directly with them).

</aside>

Untitled

🧩 How to Resolve