Investments Visibility¶
Status: Shipped¶
Domain: Investments & Debt Linear Projects: Investments Visibility V0
What It Does¶
Palm provides visibility into investment positions alongside operational cash, giving treasury teams a complete picture of total liquidity. This bridges the gap between operational bank accounts (day-to-day cash) and invested cash (term deposits, money market funds, etc.) that is often tracked separately in spreadsheets.
The platform shows investment holdings with key details like maturity dates, interest rates, counterparty information, and current values. Combined with operational cash views, treasury teams can answer the critical question: "How much total liquidity do we have and when will it be available?"
Capabilities¶
| Capability | Status | Notes |
|---|---|---|
| Investment position tracking | Shipped | Full schema with principal, currency, rates, fees |
| Investment types | Shipped | MMF, TIME_DEPOSIT, NOTICE supported |
| Maturity date visibility | Shipped | Maturity tracking with computed days_until_maturity |
| Interest rate tracking | Shipped | Track rates across portfolio |
| Investment status tracking | Shipped | PENDING, ACTIVE, MATURED, OPEN_ENDED |
| Daily balance tracking | Shipped | dim_investment_daily_balances model |
| Cash + investments unified view | Shipped | Investments visible alongside operational cash in Forecast Overview |
| Entity-level positions | Shipped | Investments linked to accounts and entities |
| Settlement account tracking | Shipped | Separate principal/interest/fees settlement accounts |
| Investment data expansion | Shipped | Investment fields in all transaction datasets + Treasury Spring Excel parser for term deposit ingestion |
Jobs Fulfilled¶
1. See total liquidity position including invested cash alongside operational cash¶
Desired Outcomes Addressed: - [x] Reduce effort to distinguish operational cash from invested cash - [x] Minimize confusion about total available liquidity - [x] Increase visibility into cash + cash equivalents in one view - [ ] Minimize the uncertainty when deciding investment duration (future: dedicated investments management)
How Palm Addresses This: - Forecast Overview shows investments alongside operational cash with split visualizations - Investment forecasts auto-generated from instrument terms and integrated into base forecasts - KPIs show operational cash vs invested cash breakdown
2. Track investments (term deposits) and manage maturities/rollovers¶
Desired Outcomes Addressed: - [x] Minimize the time spent manually entering investment data in Google Sheets - [x] Reduce the risk of forgetting a maturity date and accidentally rolling over - [x] Increase visibility into total investment position across counterparties
How Palm Addresses This: - Centralized investment tracking replaces spreadsheets - Maturity dates clearly visible - Counterparty aggregation shows concentration
3. Make informed investment decisions with confidence about cash availability¶
Desired Outcomes Addressed: - [ ] Minimize the uncertainty when deciding investment duration (partial - forward visibility in progress) - [x] Increase the visibility of when invested cash becomes available - [ ] Reduce the frequency of overly conservative investment decisions (depends on forecast integration) - [x] Minimize the time spent manually tracking investment maturities
How Palm Addresses This: - Maturity visibility helps plan upcoming cash availability - Investment data alongside forecasts enables better decisions - Reduced manual tracking frees time for analysis
Pain Points Addressed¶
| Pain Point | Addressed? | Notes |
|---|---|---|
| Investment tracking in Google Sheets is manual | Yes | Centralized platform tracking |
| Cannot see investments alongside cash | Yes | Unified liquidity view |
| Money market fund data not integrated | Partial | Manual entry for now |
| Making overly conservative decisions due to lack of visibility | Partial | Better visibility, but forecast integration needed |
What's NOT Included (Yet)¶
- Dedicated investments UI page
- Credit rating tracking (S&P, Moody's, Fitch)
- Bank/counterparty exposure limit monitoring
- MMF integration (automatic data feeds - manual import only)
- Interest accrual calculations
- Investment policy compliance monitoring
How It Works (Technical)¶
| Component | Technology | Notes |
|---|---|---|
| Data storage | PostgreSQL | palm.investments table (Nov 2025) |
| Investment types | Enum | MMF, TIME_DEPOSIT, NOTICE |
| Status tracking | Enum | PENDING, ACTIVE, MATURED, OPEN_ENDED |
| Data ingestion | Parsers | Kyriba Excel, Treasury Spring Excel |
| Analytics | DBT | dim_investments, fact_investments, daily balances |
| Reporting | Cube.js | investments.cube.yml |
Key files/services:
- /db_schemas/palm_schema.sql - Investments table
- /backend/palm_dbt/models/silver/dim_investments.sql - Dimension model
- /backend/palm_dbt/models/gold/fact_investments.sql - Fact model
- /backend/adhoc_scripts/ingest_investments/ - Data ingestion
Related¶
- Domain knowledge: docs/knowledge/investments-debt/
- Roadmap: See total liquidity in one view (Delivered)
Last updated: 2026-03-10