A missing source is an open question. Turning it into a zero quietly changes the answer.
Zero and unknown mean different things
A measured zero says that a valid observation or calculation produced no value within a defined scope. An unavailable value says the answer is not known. Those statements should look different in a report.
If a spend source is disconnected, showing $0 makes the total look complete while understating the cost. Leaving the value unavailable preserves the uncertainty and makes the missing work visible.
Describe what the total includes
A total should carry a simple explanation of its scope. List the available sources, the period covered, and any exclusions. This makes it easier for another person to understand what the number can support.
Partial coverage can still be useful. A team can compare the connected sources or investigate a recorded change. The key is to keep that narrower question separate from a claim about the whole business.
Turn a gap into a next step
Give each missing source an action: confirm account access, retrieve records, check dates, or investigate a failed import. A visible gap is easier to resolve than a quiet assumption.
When new records arrive, review the scope again. Changes to a total may reflect better coverage rather than changed performance. Keeping those two explanations separate makes a review more useful.
What is the source? What is the method? What remains unknown?
Explore the platform
