Calculate running totals

I have daily sales in column B and dates in column A on the sheet DailyRevenue. Add a running total in column C that starts at the first date and accumulates by date. Fill down so the running total updates automatically when new rows are appended. Confirm the last cell in column C matches the sum of column B and put the running total header 'YTD Running Total' in C1.

Before I send DailyRevenue to the CFO, make the running totals easy to scan. Put the running total in column C with the header YTD Running Total, freeze the header row, highlight any date where the running total decreases in red, and add a one-line formula check at top showing that the last running total equals SUM of column B. Flag any rows that break the monotonic increase rule.

I inserted a running total in DailyRevenue but on a few dates the total drops. I don't know if those are data errors, refunds that should be separate, or legitimate negative entries. The ops lead wants me to correct them before Friday. What's the quickest way to diagnose whether these are input errors versus valid negatives, and what should I present to ops so they can decide which policy to apply going forward?

Every month we spend time debugging why running totals in DailyRevenue drop unexpectedly. This costs analysts hours and annoys the CFO. Recommend one consistent intake rule and two checks we can enforce automatically on import so running totals remain audit-ready. Also suggest which colleague should own fixing exceptions and how to record the resolution in the sheet.