Monthly save/upload dashboard with bank filters, month views, variance tables, payoff models, expenses, and savings trends.
Global Dashboard Filters
Global bank filter: choose one bank/account here and the KPIs, charts, snapshot table, variance table, history table, and entry table will all reflect that bank.
Total Debt
$0
Selected month total
Total Expenses
$0
Selected month expenses
Savings
$0
Selected month savings
Net Position
$0
Savings minus debt
Monthly Trend by Selected Bank / Type
Debt Mix for Selected Month
Table 1 — Selected Month Snapshot
Cleaner version of your Excel table: bank, amount, percent of total, notes, MoM variance, and monthly paydown amounts with a 30% interest/buffer added.
Table 2 — Bank Variance by Month
Shows month-to-month movement by bank/account. Filter by bank to see one account across time.
YTD Trend
Paydown Scenario Model
Selected Bank Snapshot History
Shows clean snapshot history for the selected month. Blank bank rows are hidden, and jumps/drops are highlighted.
Editable Data Entry Table
Simple entry: Bank, Date, Type, New Total, Notes. Use Duplicate to copy a row, then only change the date and new total. The global bank filter also filters this table so it is easier to work on one account at a time.