Reporting & Insights¶
Status: Shipped¶
Domain: Reporting Linear Projects: Embeddable- More visually appealing reports, Embeddable: Components
What It Does¶
Palm's reporting capabilities allow treasury teams to create, customize, and share dashboards and reports. The platform provides self-service tools for building visualizations of cash positions, forecasts, transactions, and other treasury data.
Reports can be scheduled for automatic delivery via email. PDF exports are available for distribution to stakeholders who won't log into dashboards.
Capabilities¶
| Capability | Status | Notes |
|---|---|---|
| Self-service dashboard creation | Shipped | Build and customize dashboards |
| Filtering and drill-down | Shipped | Navigate from summary to detail |
| Multi-currency support | Partial | Single default currency per customer |
| PDF export | Shipped | Generate static reports for distribution |
| Embeddable components | Shipped | Integrate Palm visuals into other tools |
| Scheduled email reports | Shipped | Daily/weekly/monthly delivery |
| Scheduled Slack reports | Not Shipped | Backend work started, FE not complete |
Jobs Fulfilled¶
From reporting/jobs.md
1. Create and modify cash reports independently with self-service capabilities¶
Desired Outcomes Addressed: - [x] Minimize the time required to create a new dashboard or report view - [x] Reduce the frequency of requests to the Palm team for custom report builds - [x] Increase the flexibility to adjust filters, currencies, and views on existing reports
How Palm Addresses This: - Self-service dashboard builder - Real-time preview of changes - Filtering and drill-down capabilities
2. Track investments, FX exposure, and cash concentration by bank¶
Desired Outcomes Addressed: - [x] Minimize the time required to see total balance by bank, currency, and entity - [ ] Increase visibility into investment maturity timing and interest tracking (partial - investments visibility in separate feature) - [x] Reduce the effort required to identify cash concentration risks across banks
How Palm Addresses This: - Balance breakdown by bank, currency, entity - Concentration analysis views - Historical trend charts
3. Build and deliver daily cash position to stakeholders before 8 AM (Emerging)¶
Desired Outcomes Addressed: - [x] Minimize the time required to compile daily cash position (30 min target) - [x] Reduce the effort required to distribute reports to appropriate teams - [x] Increase the automation of transaction ingestion and categorization
How Palm Addresses This: - Automated data refresh - Scheduled email delivery (daily/weekly/monthly) - PDF export for distribution
Pain Points Addressed¶
| Pain Point | Addressed? | Notes |
|---|---|---|
| Can't easily filter or modify existing reports | Yes | Self-service filtering and customization |
| Waiting for vendor/IT to build custom reports | Yes | Self-service dashboard creation |
| Regional teams don't have access to cash visibility | Yes | Role-based access to dashboards |
| Current BI tools lack bank account level detail | Yes | Transaction-level granularity |
| TMS reporting not intuitive or flexible | Yes | Modern self-service UX |
| Screenshot data from G-sheets to PowerPoint | Yes | Direct PDF export |
| CFO/executives won't log into dashboards | Yes | Scheduled email delivery |
What's NOT Included (Yet)¶
- Slack report delivery (backend work started, FE not complete)
- Multi-currency dashboards (only single default currency)
- Historical forecast vs actuals comparison charts
- Cascading/connected filters
- Narrative annotations ("reports that tell a story")
How It Works (Technical)¶
| Component | Technology | Notes |
|---|---|---|
| Dashboard engine | Embeddable | Dashboard building and rendering |
| PDF generation | Playwright | Browser automation with Firebase auth |
| Email delivery | Resend | Email service |
| Scheduling | Cloud Scheduler | Daily/weekly/monthly cadence |
| Analytics | Cube.js | Data layer |
Key files/services:
- /backend/report_scheduler/ - Scheduling and delivery
- /frontend/apps/palm/src/components/reporting/ - Report UI
- /frontend/apps/embeddable/ - Dashboard components
Related¶
- Domain knowledge: docs/knowledge/reporting/
- Roadmap: None currently planned
Last updated: 2026-02-03