A system assures revenue reconciliation of customer billing and vendor settlements for multimedia services, including voice over IP, provided through a network. The system includes a data repository configured to store a plurality of tables, each table including data collected from a plurality of network elements in the network and relating to at least one of customer usage, mediation, customer billing and vendor settlement. The system also includes a processor configured to execute an alert rule based on data retrieved from at least one table stored in the data repository. The alert rule includes a comparison between the at least one table and at least one other table of the plurality of tables. The processor triggers an alert associated with the alert rule when a corresponding alert rule threshold is exceeded based on the comparison, and initiates reporting of the triggered alert.