Getting Started
Enable the cashflow feature (ask Lumonic chat or support email)
Visit the Cashflows tab in-app
Create a ledger
Note, one ledger is usually best as it makes calculating performance across companies and funds easier. We recommend a single ledger at the security level for most users.
Create Transaction types. Recommended types and sign treatment:
Create Tags (optional)
Create external IDs. If you are exporting these from another system, you can use external ids to make uploading without fear of duplicating cashflows easy. Lumonic will dedupe on any already existing external ids.
Uploading your Cashflows
Cashflow entries can be created two ways:
Manual input: In the ledger tab, click Actions -> Create Cashflow. You will be prompted to enter an amount, date, transaction type, scenario and entity (typically security).
Upload. Click Actions-> Import from File. Use the Lumonic provided template. Add any cashflows you wish to import. A few important concepts:
Cashflow IDs: These are Lumonic system IDs. Leave blank for new cashflows. For each new upload, you can download the latest from Lumonic which will include IDs. Then on upload only the new rows missing IDs will be created. This saves you the trouble of having to manually dedupe.
Entity Name/ID: Ensure these match the system exactly.
External ID: Ensures that Lumonic will not create duplicate cashflows when we see an external ID that already exists on another cashflow.
A few common mistakes to avoid:
Creating Performance Metrics
To calculate performance with your cashflow data, you must create performance metrics.
Go to Performance Metrics
Click Create. A builder will guide you through creating IRR and other basic metrics. If you want to use advanced mode and create them yourself, below are some typical configurations. Note that these will be based on the transaction type names you created earlier
Net IRR | Time-weighted annualized return rate | IRR | xirr( |
DPI | Cash-on-cash return (distributions / contributions) | Ratio | aggregate_sum(@security.cashflows.distribution) |
TVPI | Total value to paid-in (realized + unrealized) | Ratio | (aggregate_sum(@security.cashflows.distribution) |
RVPI | Residual value to paid-in (unrealized only) | Ratio | latest_nav(@security.cashflows.nav) |
MOIC | Multiple on invested capital | Ratio | (aggregate_sum(@security.cashflows.distribution) |
Reports on Performance
You can use the performance metrics you created in dashboards and via the Lumonic excel plugin.
@security.irr for example will return for a given entity.
Contact Lumonic support if you'd like a pre baked starter template for excel.