You are building a finance data pipeline for a university environment where restricted funds must be tracked against allowable uses, fund balances, and close deadlines. The finance team needs early warning on potential compliance issues so they can investigate before month-end close, not after reports are finalized.
How would you design a process to monitor restricted funds and flag potential compliance issues before month-end close?