This tool automatically updates your foreign currency exchange rates in Spire from the Bank of Canada. Includes a utility to setup as a scheduled task.
This tool will highlight customers in red that have a balance over x days. Note: this is an example of a simple scheduled PostgreSQL command. There are many powerful applications of this concept. This generic implementation can be reused easily.