From raw files to a management report
Reconciled dataset, clear summary, chart and a factual report ready for human review.
Stop and check if…
- Unreadable source or missing page
- Unresolved duplicates or mismatched totals
- Mixed units/currencies or missing denominator
- Unsupported causal claim or unauthorized private data
Do not mark a stage done just because AI produced a draft. Use actual evidence and human approval. Keep private records in your approved tools. Prompt Bro never submits, posts, pays or approves anything.
0 of 4 stages verified
Stages unlock in order. Only completion ticks are saved in this browser; no documents, inputs or AI outputs are stored.
All 4 stages verified. Keep the approvals and evidence in your own records; this tick list is not proof.
- What you need
- Approved masked source files and required fields
- What to produce
- Source-linked rows, missing cells and template mapping
- Who checks it
- Owner verifies source and extraction
Open the tasks
- Convert PDF or image tables to Excel · Tested
- Fill a standard document or form from existing records · Tested
If this happens
- A page is unreadable or the table extraction looks wrong: Re-extract or type that part; compare totals with the source.
Handoff template
Workflow: From raw files to a management report Stage: Collect and extract (1 of 4) Source refs (document no. / date): [confirm] Item / unit / quantity: [confirm] Known (verified against source): [confirm] Unknown / held items and why: [confirm] This stage produced: Source-linked rows, missing cells and template mapping Approval status (approved / pending / rejected): [confirm] Approved by (Owner verifies source and extraction): [name / role] Evidence ref (where the proof is kept): [confirm] Next stage: Combine and clean, needs: Source tables, field map and unique key
- What you need
- Source tables, field map and unique key
- What to produce
- Canonical dataset, source counts and exceptions
- Who checks it
- Analyst confirms duplicate and missing-data treatment
Open the tasks
- Consolidate multiple Excel files into one report · Not yet tested
- Excel clean-up · Not yet tested
- Compare two Excel sheets · Not yet tested
If this happens
- Duplicates or blanks can't be resolved from the source: List them as open issues; don't delete or fill them silently.
Handoff template
Workflow: From raw files to a management report Stage: Combine and clean (2 of 4) Source refs (document no. / date): [confirm] Item / unit / quantity: [confirm] Known (verified against source): [confirm] Unknown / held items and why: [confirm] This stage produced: Canonical dataset, source counts and exceptions Approval status (approved / pending / rejected): [confirm] Approved by (Analyst confirms duplicate and missing-data treatment): [name / role] Evidence ref (where the proof is kept): [confirm] Next stage: Validate, needs: Cleaned copy and calculation rules
Unlocks after stage 1 is verified.
- What you need
- Cleaned copy and calculation rules
- What to produce
- Formula checks, control totals and held rows
- Who checks it
- Reviewer verifies totals locally
Open the tasks
- Write or fix an Excel formula · Not yet tested
- Check a spreadsheet before sending · Tested
If this happens
- Totals don't match the source, or units/currencies are mixed: Go back and fix the data before summarising. Go to stage 2: Combine and clean
Handoff template
Workflow: From raw files to a management report Stage: Validate (3 of 4) Source refs (document no. / date): [confirm] Item / unit / quantity: [confirm] Known (verified against source): [confirm] Unknown / held items and why: [confirm] This stage produced: Formula checks, control totals and held rows Approval status (approved / pending / rejected): [confirm] Approved by (Reviewer verifies totals locally): [name / role] Evidence ref (where the proof is kept): [confirm] Next stage: Summarise and communicate, needs: Validated data and reporting period
Unlocks after stage 2 is verified.
- What you need
- Validated data and reporting period
- What to produce
- Pivot summary, chart and email draft; known vs unknown
- Who checks it
- Manager reviews figures and sends locally
Open the tasks
- Create a PivotTable and summary report · Tested
- Turn numbers into charts and a report · Tested
- Write or reply to an office email · Tested
If this happens
- The draft claims a cause the data can't show: Rewrite as an observation and a question. Go to stage 3: Validate
Handoff template
Workflow: From raw files to a management report Stage: Summarise and communicate (4 of 4) Source refs (document no. / date): [confirm] Item / unit / quantity: [confirm] Known (verified against source): [confirm] Unknown / held items and why: [confirm] This stage produced: Pivot summary, chart and email draft; known vs unknown Approval status (approved / pending / rejected): [confirm] Approved by (Manager reviews figures and sends locally): [name / role] Evidence ref (where the proof is kept): [confirm] Next stage: none. Workflow ends after this approval.
Unlocks after stage 3 is verified.