A few small additions fix most of this. Show the date of the last refresh somewhere visible. Note the source next to any number that comes from outside the main table. Flag partial periods, like a month that isn’t over yet, so a dip doesn’t get read as a trend. And add one check cell that compares a total against a known figure, so a broken refresh shows up right away.