AM IT Solution

Contract value on the day a deal is won, invoiced value on the day an invoice is issued, and cash on the day money arrives are three different quantities on three different dates. Reports that blur them are worse than no reports. The word "revenue" without a basis is banned from the product, and every figure states which basis it is on.

Financial records are protected by database triggers, not by good intentions: the activity log rejects updates and deletes outright, an issued invoice rejects edits to its frozen fields, payments cannot be edited or deleted, and a milestone amount freezes once its invoice is issued. Corrections happen the documented way — credit note, void and reissue, or a reversal row.

Paid status, outstanding balance, overdue, project health, progress: all of them are derived. None of them gets a column. The moment a derived value is stored it starts disagreeing with the rows it came from, and every report built on it inherits the disagreement.