---
source: https://carbone.io/examples/s-financial-dashboard/
title: "Financial Dashboard Software: Excel from JSON | Carbone"
description: "Add a financial dashboard to your software: an XLSX template fills KPI cards and tables from JSON with the Carbone API and keeps the conditional formatting."
generated_at: "2026-11-17"
---

# Quarterly financial dashboard

Eight KPIs and key accounts in a native Excel dashboard

[![Quarterly financial dashboard: XLSX generated from an XLSX template and JSON data](/examples/s-financial-dashboard/thumb-result.webp)](/examples/s-financial-dashboard/result.xlsx "Download the generated document")

[Download template](/examples/s-financial-dashboard/template.xlsx)

[Sample data](/examples/s-financial-dashboard/data.json)

[Download the generated XLSX](/examples/s-financial-dashboard/result.xlsx)

- **Template:** XLSX
- **Export as:** XLSX, PDF, ODS, CSV, HTML [+19 more](/documentation/developer/http-api/generate-reports.md#output-file-type)
- **Carbone:** 5.18+

Features

-   [Loop](/documentation/design/repetitions/with-arrays.md)
-   [Number format](/documentation/design/formatters/number.md)
-   [Count](/documentation/design/computation/aggregation.md)
-   [Conditional formatting](/documentation/design/template-formats/xlsx.md)

## Generate financial dashboards from your finance system

Finance teams and reporting tools send the quarter's figures to the Carbone API as JSON and get back the dashboard as a native Excel file. The generated XLSX keeps the layout of your sheet, its number formats and its conditional formatting, and it stays editable in Excel. Here, a quarterly dashboard presents eight KPIs, the revenue by segment against its target, and the key accounts, with colors that highlight the trends and statuses. The JSON data carries the inputs only: the growth, the share of total, the gap to target, the status and the totals are Excel formulas.

In this example, you will:

-   Display KPI cards with amounts and percentages
-   Repeat the rows of the segment and account tables
-   Compute the growth, the gap to target and the totals with Excel formulas
-   Highlight the values with conditional formatting
-   Add a dynamic footer

## How to build the dashboard in Excel

Follow these steps to generate a financial dashboard:

### 1\. Lay Out the KPI Cards and Tables

In Excel, create a sheet with a header band, eight KPI cards on two lines, a table for the revenue by segment and a table for the key accounts. Each card uses three rows: a label, a value and a trend. In **Page Layout** > **Page Setup**, choose the **Landscape** orientation and fit the sheet on one page wide.

### 2\. Display the Header and the KPIs

Display the data with [Carbone tags](/documentation/design/substitutions/the-basics.md):

-   In the header, mix text and tags in the same cell, for example `{d.report.title} - {d.report.period}` or `Generated: {d.report.generatedDate}`
-   Display the amounts with the [:formatN](/documentation/design/formatters/number.md#formatn-precision-options) formatter, for example `{d.kpis.netNewArr.value:formatN}`. In XLSX, `:formatN` writes a real number in the cell, and the number format of the cell displays it: set the format `#,##0.00 "€"` to display `1398700` as `1,398,700.00 €`
-   Display the ratios in the same way, for example `{d.kpis.churnRate.value:formatN}`, with the cell format set to **Percentage** to display `0.041` as `4.1%`
-   Display the trends with `{d.kpis.netNewArr.trend}`. The data contains the `↑` or `↓` arrow, used to color the text in step 5. The revenue card is a formula, `=E18`, that reads the total of the segment table

### 3\. List the Segments

Display the segments in a [loop](/documentation/design/repetitions/with-arrays.md#simple-array):

-   In the first row, add `{d.segments[i].name}`, `{d.segments[i].prevRevenue:formatN}`, `{d.segments[i].revenue:formatN}` and `{d.segments[i].target:formatN}`
-   In the same row, type the formulas: `=E15/C15-1` for the growth, `=E15/$E$18` for the share of total, `=E15-I15` for the gap to target and `=IF(K15>=0,"On Track","Off Target")` for the status
-   In the next row, add `{d.segments[i+1].name}` to end the loop
-   Below, add the **TOTAL** row with `=SUM(C15:C16)` and the same formulas on the total: Carbone updates them to cover every generated row, and the absolute reference `$E$18` follows the total row

_Only style the first row of the loop: Carbone copies its formatting to every generated row._

### 4\. List the Key Accounts

Display the accounts in a loop in the same way, with `{d.accounts[i].name}`, `{d.accounts[i].revenue:formatN}`, `{d.accounts[i].qoqDelta:formatN}`, `{d.accounts[i].health}`, and so on. In the **Rank** column, number the accounts with the [:cumCount](/documentation/design/computation/aggregation.md#cumcount-partitionby) formatter: `{d.accounts[i].name:cumCount:formatN}`.

### 5\. Add the Conditional Formatting

Carbone keeps the Excel conditional formatting and applies it to the generated values. Go to **Conditional Formatting** > **New Rule...** and create the rules:

-   **Trends**: **Format only cells that contain** > **Specific Text** `↑` in green, and `↓` in red
-   **Growth and gap to target**: **Use a formula to determine which cells to format**, for example `=G15>0` in green and `=G15<0` in red
-   **Statuses and health**: cells containing `On Track` or `Healthy` in green, `Monitor` in orange, `Off Target` or `Risk` in red
-   **Banded rows**: the formula `=MOD(ROW(),2)=1` with a light background

_The rows generated by a loop are only formatted inside the range of the rule. Apply the rules to a range that covers the maximum number of rows, for example `A23:N1449`._

### 6\. Add the Footer

Go to **Page Layout** > **Page Setup** > **Header/Footer**, click **Custom Footer...**, and type the tags, for example `{d.company.name} - Internal Use Only · Source: {d.report.source} · Data as of {d.report.asOfDate}`.

_Every amount, ratio and rank is a native Excel number, so the generated workbook can be sorted, summed and charted. The currency comes from the number format of the cell, not from the `lang` and `currency` options of the API request._

> This template requires Carbone v5.18.0 or later. Add the tag `{o.preReleaseFeatureIn=5018000}` to the template so the formulas and the conditional formatting follow the generated rows. Here, the tag is stored in the comments of the document properties.

Save the XLSX template, connect it to your JSON data, and let Carbone generate your financial dashboard automatically.

## Related Examples

Check out these similar templates to learn more:

- [Monthly sales report](/examples/s-financial-report/index.md): DOCX template to PDF.
- [Excel transaction report](/examples/transaction-report/index.md): XLSX template to XLSX.

## Related topics

- [Bank reconciliation report](/examples/bank-reconciliation-report/index.md)
- [Sales commission statement](/examples/sales-commission-statement/index.md)
- [Excel transaction report](/examples/transaction-report/index.md)
- [Monthly treasury FX report](/examples/financial-report/index.md)
- [Accounts receivable aging report](/examples/accounts-receivable-aging-report/index.md)
- [Budget vs actual report](/examples/budget-vs-actual-report/index.md)
