CSV File Format for Bulk Import of Data. (Kubera for Business)

Note: This feature is only available for 'Kubera for Business' users.

Add New Assets & Debts

Step 1: Click on Import Data > New Assets & Debts on the Dashboard

Step 2: Upload CSV with these columns:

clientNameOrEmail,name,currency,value,sheetName,assetOrDebt,sectionName,portfolioName,price

sectionName is optional

portfolioName is required only if the client has multiple portfolios

price is required only if the asset is of type Quantity & Price. You can enter the quantity in the value column.

Step 1: Click on Import Data > Current Value on the Dashboard

Step 2: Upload CSV with these columns:

clientNameOrEmail,name,currency,value,portfolioName,price

portfolioName is required only if the client has multiple portfolios

price is required only if the asset is of type Quantity & Price. You can enter the quantity in the value column.

Step 1: Click on Import Data > Cash Flow on the Dashboard

Step 2: Upload CSV with these columns:

clientNameOrEmail,assetName,date,currency,cashIn,cashOut,note,portfolioName

portfolioName is required only if the client has multiple portfolios

Important:

The client and asset names in the CSV file must match exactly the way they are entered in Kubera.
The expected date format is YYYY-MM-DD
portfolioName is required only if the same client has multiple portfolios created.
Export Canoe Capital Activities: https://github.com/kubera-apps/canoe-capital-activity-export

Step 1: Click on Import Data > Historical Value on the Dashboard

Step 2: Upload CSV with these columns:

clientNameOrEmail,name,date,currency,value,portfolioName

portfolioName is required only if the client has multiple portfolios

Important:

The client and asset/debt names in the CSV file must match exactly the way they are entered in Kubera.
The expected date format is YYYY-MM-DD
portfolioName is required only if the same client has multiple portfolios created.