I don’t have much time to reply now, but I’ll confess that I don’t currently have anything like an automatic reminder/alarm system set up, and not much in the way of templates with drop-downs and such.
I just have a dynamic table like this for all credit accounts (and modified variant for utilities, etc.) And because it’s a dynamic table, it’s really easy to sort by “day” (which means day of the month, so that I’m orienting to the day of the month for upcoming payments), or by “balance” (to see where the big balances are) or “rate” or by “modified” (to make sure I’ve updated everything recently).
<<table-dynamic filter:"[tag[credit]]" fields:"tbl-expand title bal day autopay? limit rate end bank notes modified tbl-clone" stateTiddler:"credit_table" footerRows:"1" class:"alternating-rows" caption:"all <$text text={{{[all[tiddlers]tag[credit]count[]]}}}/> items under <<tag>>" >>
… and the footer row has <<sum>>
under bal and limit columns.
For routine costs (utilities, insurance, etc.), this variant table:
<<table-dynamic filter:"[all[tiddlers]tag<currentTiddler>]" fields:"tbl-expand title amt x12 x4 x2 auto-pay? notes tbl-clone" footerRows="1">>
(The x12 column is for stuff paid monthly, the x4 for quarterly, the x2 for semi-annual)
Mostly, this works for me as a “console” solution — I can get an easy overview, and I can also toggle into edit mode to update anything without opening up the account-specific tiddlers, and without scrolling away from the big picture.
Also note a lovely convenient feature of dynamic tables here: if a column exists in the dynamic table, when you’re in edit mode you can directly enter values even if the field doesn’t exist yet in the row’s tiddler, and the field is thereby instantly created with the entered value. So when I set up a new account, I tend to add all data (after title and tag) within the dynamic table, which effectively prompts me to add the standard parameters (like the rate details for a credit card, monthly biling date, etc.), and this approach alos safeguards against creating a field incorrectly. Of course I could generate a special edit template for credit cards, but the dynamic table makes this feel unnecessary. The only thing I go to the actual tiddler for is long-form notes (Correspondence about this disputed charge, that customer-service confusion… As of Jan 2025 this bank was bought out by this other one…)