The IRR my Excel sheet shows (XIRR) is not matching with Kubera

Excel is correct, but Kubera shows this a bit differently.

Kubera shows ROI (absolute return) or IRR (annualized return) depending on two key factors:

Investment Duration

Kubera displays absolute returns (ROI) for short-term investments because IRR (Internal Rate of Return) is an annualized metric and only becomes meaningful when the investment duration exceeds one year.

In your case, based on the last update date of the cost basis* or the oldest entry in the cash flow for this asset is less than a year old. This classifies it as a short-term investment, so Kubera shows the simple percentage increase—ROI.

Once the investment reaches the one-year mark, Kubera will automatically switch to showing IRR, giving you an annualized view of your returns.

Selected Evaluation Period

Even for investments older than one year, if the evaluation period is set to:

• 1 Year
• Year-to-Date (YTD)
• Quarter-to-Date (QTD)

Kubera will still show ROI, the absolute change during that specific period, instead of IRR.

This is because these are fixed timeframes, and the intent is to show simple gain or loss over that window, not annualized performance.

When you are on the asset's Returns screen, click the IRR% to open the Rate of Returns Settings screen. From there, choose your preferred evaluation period.

*Last Update date is shown right below the Cost basis field in the Asset details > Returns tab. Click on it to change it.