Update once, see everything. Excel dashboard, paste new transactions into tables, refresh pivots & optional Power Query ...
Calc's advanced pattern matching is simple and direct.