Two sheets expected: Transactions and Category mapping. Start from the template if you have neither.
Running account balance, starting from the first year in data. Zoom in and the axis detail sharpens to month, then day. Major events are marked with coloured points when a single transaction is larger than the salary received in the same period; hover a marked point for concept, category and amount. Self-transfers are excluded. In Day view, hover any date to see movements recorded that day.
Inner ring = type, middle = category, outer = subcategory. The year/type controls also drive “Where it goes”. Click a category segment to open the detailed subcategory view.
Category totals and drill-down detail. Select a category to view its subcategories, or a subcategory to view individual expenses.
Inner ring = type, middle = earning category, outer = earning subcategory. Uses the same period, type, category, subcategory and concept filters. Click a segment to open the detailed earnings view.
Earning totals and drill-down detail. Select a category to view its subcategories, or a subcategory to view individual earning transactions.
Income above zero, expenses below (stacked by the selected expense type or subtype color mode). Dashed line = net per period (income − expenses). Uses the shared filters above for both income and expenses.
Income above zero, coloured by employer (salary-bonus in grey). Expenses below zero in light grey (person transfers and extraordinary items excluded). Dashed line = net per period. Use the filters above to isolate one type, category or concept — when you do, income hides so the chosen spend and its net line stand alone.
Concepts marked recurring, aggregated. Click a row to expand the payments included.
Concepts marked common, aggregated over the active selected period. AVG monthly and AVG yearly are normalized by that period. Click a row to expand the payments included.
Concepts marked extraordinary, aggregated over the active selected period. AVG monthly and AVG yearly are normalized by that period. Click a row to expand the payments included.