Start with one number that does not match
Choose a report and trace its total to the source records. Compare the same period, currency and business definition before joining more systems.
When a source fails
Preserve the last valid cut, show when it was updated and flag missing records. A failed refresh must not quietly turn missing data into zero.