Schedule Financial Statement Delivery
Use Financial Scheduler to run a statement on a cron and email PDF or XLSX output.
Where: Mission Control → Financial Statements → Financial Scheduler
Route: /missioncontrol/financials/scheduler
You need a viewable statement (template) from Builder and, for tree scope, trees from Build financial trees.
Create a schedule
- Open Financial Scheduler.
- Click New schedule (empty state or sidebar +).
- On the Config tab:
- Schedule Name (required)
- Enabled / Disabled switch
- Statement — select a statement you can view
- Output Format — PDF or XLSX
- End Month — Relative (recommended) with offset months (
0= current,-1= previous), or Fixed month - Scope Mode:
- Parameters — Companies + Part fields / Lookup
- Trees — pick tree and nodes under Trees scope
- Open Email and fill required fields:
- Email To
- Email Subject (default:
Scheduled Financial Statement) - Email Body
- Optional Email CC / Email BCC
- Click Save.
Rules require a saved schedule. After the first save, open Rules.
Sidebar list: Schedules. Green/red status dots mean Enabled / Disabled. Row ⋯: Execute, Duplicate, Delete → Delete Schedule.
Add cron rules
- Select a saved schedule.
- Open Rules.
- Click Add rule.
- In Add Rule:
- Set Timezone
- Choose Frequency (
minutes,hourly,daily,weekly,monthly, orcustom-cron) and the time/day options for that frequency - Enable the rule as needed
- Click Save Rule.
Edit an existing rule with Edit Rule. Delete confirms with Delete Rule.
Until the schedule is saved once, Rules shows: Save the schedule first to manage cron rules.
Run and review
| Action | Where |
|---|---|
| Execute | Header or sidebar ⋯ — runs the schedule now (after it exists) |
| Executions tab | History of runs (parameters/email snapshots when present) |
| Email tab | Edit recipients/body; right Email preview when on Email |
Keep the schedule Enabled for automatic runs. Use Disabled to pause without deleting.
Checklist before relying on email
- Statement selected and runnable under the chosen scope (parameters companies/parts or tree nodes).
- End Month mode/offset matches how you close books (usually relative previous month).
- At least one enabled rule with the correct timezone.
- Email To / Subject / Body filled; test with Execute and check Executions.