Define the report's audience and fixed sections first. Then identify each section's source, owner, refresh time, and verification method before automating collection or formatting.
Run one week manually with a small sample to expose missing data and unclear decisions. Add failure routing for late inputs, avoid duplicate output on retries, and require review of numbers and claims before distribution. The workflow should automate predictable assembly while keeping judgment visible.
Which section needs the most manual correction each week?