Bulk Import: Cash Pools

Modified on Wed, 22 Apr at 7:21 AM

The Cash Pools import template lets you bulk-upload cash pool definitions and their associated transactions into Delio. Use it to set up investable cash accounts linked to assets, and to record credits, debits, and movements against those pools.

Overview

The template is a two-sheet spreadsheet. Complete both sheets before uploading:

Sheet 1 — Cash Pools: defines the cash pools themselves — each pool is linked to an asset and given a name and optional description.
Sheet 2 — Cash Pool Transactions: records the individual credit, debit, and movement transactions against those pools.

Before you start: Make sure the assets you intend to link cash pools to already exist in Delio. The Asset linked to column must match the exact asset name as it appears in the platform.

Sheet 1 — Cash Pools

Each row in this sheet defines one cash pool. A single asset can have multiple cash pools (for example, separate pools for Fees, Expense Reserve, and Interest Accruals).

Cash Pools sheet showing the three column headers: Asset linked to, Name, Description — The Cash Pools sheet — one row per cash pool, linked to an asset in column A.

Column	Required	Description
Asset linked to	Yes	The name of the asset this cash pool belongs to, exactly as it appears in Delio.
Name	Yes	The name of the cash pool (also referred to as ‘Investable Cash’). For example: Fees, Expense Reserve, or Interest Accruals.
Description	No	An optional free-text description of the cash pool.

Cash Pools sheet with example data showing Fees, Expense Reserve and Interest Accruals entered as cash pool names — Example cash pools — Fees, Expense Reserve, and Interest Accruals — all linked to the same asset.

Sheet 2 — Cash Pool Transactions

Each row records one transaction against a cash pool. Three transaction types are supported: Credit, Debit, and Movement.

Cash Pool Transactions sheet showing all column headers: Type, Date, Investor Name, Asset, Source, Route, Amount, Description — The Cash Pool Transactions sheet — one row per transaction.

Column	Required	Description
Type	Yes	The transaction type. Must be one of: `Credit`, `Debit`, or `Movement`.
Date	Yes	The date of the transaction.
Investor Name	Yes	The unique investor reference as it appears in Delio.
Asset	Yes	The name of the asset the cash pool belongs to.
Source	Conditional	The name of the cash pool (investable cash) involved. Credits: not required — any value entered will be ignored. Debits: the cash pool the funds are drawn from. Movements: the cash pool the funds are received into.
Route	Conditional	The name of the cash pool (investable cash) involved. Credits: the cash pool the funds are received into. Debits: not required — any value entered will be ignored. Movements: the cash pool the funds are received into.
Amount	Yes	The transaction value.
Description	No	An optional free-text description of the transaction.

Cash Pool Transactions sheet with the Source column selected and an annotation comment explaining its usage for Credits, Debits and Movements — Inline notes on the Source column explain how it behaves differently depending on the transaction type.

Source vs Route: Think of Source as where money comes from and Route as where it goes. For a Credit (money arriving), only Route is relevant. For a Debit (money leaving), only Source is relevant. For a Movement (money transferring between pools), both are used.

Transaction type reference

Use this table as a quick reference when completing the Cash Pool Transactions sheet:

Type	Source	Route	Use when
`Credit`	Not required	Cash pool receiving funds	Money is coming into a cash pool
`Debit`	Cash pool funds are drawn from	Not required	Money is going out of a cash pool
`Movement`	Cash pool receiving funds	Cash pool receiving funds	Money is moving between cash pools

Uploading the template

Complete Sheet 1 (Cash Pools) in full before moving to Sheet 2.
Complete Sheet 2 (Cash Pool Transactions), ensuring each transaction references a cash pool name that matches exactly what you entered in Sheet 1.
Save the file and navigate to the Data Import section in Delio.
Select the Cash Pools template type and upload your completed file.
Review any validation errors returned and correct the highlighted rows before re-uploading.

Tip: Column headers must not be modified. Do not rename, reorder, or delete any columns — the import will fail if the headers do not match the expected template exactly.