Run profit and loss report

I need the profit and loss report for Q2 by business unit for the investor update next Wednesday. Run the P&L through the end of June, break out revenue, COGS, gross margin, selling expense, and operating income by unit, and include a one-page variance versus budget with explanations for any line over $100,000. Deliver the Excel to me and to Ricardo in commercial by Tuesday evening.

Before I send the P&L to Ricardo’s team, make it easy for them to approve: put the three largest drivers of variance on page one, make subtotal lines for gross margin and EBITDA bold and findable, flag entries with manual journal adjustments this quarter and attach the supporting description so a reviewer won’t have to hunt.

The Q2 P&L shows a $210,000 revenue drop in the North Region I didn’t expect. I’m worried it’s a booking cut, an invoicing hold, or data mapping gone wrong, and I have to tell Ricardo by end of day. I don’t know which it is and I can’t call every sales rep. What’s the most likely diagnosis and the fastest way to validate it so I can give a truthful short update and a remediation plan?

Quarter after quarter we catch revenue classification or mapping mistakes only after the investor deck has been drafted, forcing restatements or awkward explanations. What three process changes would prevent these late discoveries, who should own the controls, and what measurable evidence should we require to be confident the fixes are working after two quarters?