Task: the weekly sales report
- Task
- Weekly sales report for the management team
- Trigger and frequency
- Every Monday morning, started by hand
- Owner
- One person in sales; the head of sales approves the report
- Input: systems and data
- CSV export from the online shop, invoice sheet from accounting, list of returns from customer service
- Output: systems and data
- Summary spreadsheet emailed to the management team
- Errors and exceptions
- Returns get missed, exchange rates are typed in by hand, the report is late when the person is on leave
- Effort
- About 3 hours every Monday, one person
- Priority
- High
- First small step
- Automation prepares, a person approves
Why this first step
First, the three exports are merged into one sheet automatically. The person in sales checks totals and returns before sending, and exchange rates come from one source instead of manual entry.