Notification matching rules

Bank identifiers SMS sender filters Package name filters Matching window before due date (days) Matching window after due date (days) Exact / partial tolerance Auto-create new month column in Google Sheet

Renewal reminder automation

Enable automatic renewal reminders First reminder (days before expiry) Second reminder (days before expiry) Daily reminders start (days before expiry)

Default flow: one reminder at 60 days, another at 30 days, then every day from 15 days remaining until the renewal is resolved.

MQTT notification delivery

Publish automatic alerts to MQTT MQTT host MQTT port MQTT username MQTT password Renewal MQTT topic

This build publishes structured JSON directly to your broker for Home Assistant automation handling.

Late-payment alert automation

Enable automatic late-payment alerts Trigger late-payment alert after this many days overdue Late-payment MQTT topic

A late-payment alert is published once per tenant/month when the payment first crosses the overdue threshold.

Google Sheet bridge settings

Spreadsheet ID Sheet name Apps Script web app URL Bridge shared secret Header row number Name header Property header

This build imports the Google Sheet once into the local database and treats the Ubuntu app as the source of truth. The sheet bridge is now for optional export/update only.