Evaluate current and historical financial data

I need the latest income statement and the last five years of monthly cash flow on one sheet so I can present performance to the finance director. Put current year-to-date and prior year-to-date side by side, show percent change, and highlight any quarters where operating cash turned negative. Before I send it, check formulas for hard-coded dates or rollups that would break on next month.

Before I hand this to the audit manager, make the trends obvious and the anomalies explainable: surface the three-year CAGR for revenue and EBITDA at the top, show rolling 12-month cash on hand, and flag months where receivables grew faster than sales. Add a one-line note next to each flagged line proposing likely causes: delayed collection, one-off write-down, or seasonality.

I reconciled the general ledger import to my consolidated workbook and found a $1.2 million mismatch for March operating expenses. The controller, Priya, is on leave and the month is due to close tomorrow. I don’t know whether the error is a mapping problem in my import, a late journal from the field team, or a duplicated row. What should I check first to diagnose the source, who should I call now, and what’s the fastest way to prevent this from corrupting the rest of the year’s rolling totals?

Every month we lose a morning reconciling the GL import: column mappings shift, new nominal codes appear, and someone overwrites the prior month’s sheet. It costs credibility with the business and delays forecasts. Help me design one repeatable habit that stops those daily fires: what three rules should I enforce for the import and one change to the workbook structure that prevents accidental overwrites?