---
source: https://carbone.io/examples/s-financial-report/
title: "Sales Reporting Software: Monthly Report in Word | Carbone"
description: "Generate monthly sales reports from JSON with the Carbone API: a DOCX template shows KPI cards, colored trend arrows, a native bar chart and top accounts."
generated_at: "2026-11-17"
---

# Monthly sales report

CRM figures with KPIs, a bar chart and top accounts

[![Monthly sales report: PDF generated from a DOCX template and JSON data](/examples/s-financial-report/thumb-result.webp)](/examples/s-financial-report/result.pdf "Download the generated document")

[Download template](/examples/s-financial-report/template.docx)

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

[Download the generated PDF](/examples/s-financial-report/result.pdf)

- **Template:** DOCX
- **Export as:** PDF, DOCX, ODT, HTML, PNG [+25 more](/documentation/developer/http-api/generate-reports.md#output-file-type)
- **Carbone:** 4.0+

Features

-   [Loop](/documentation/design/repetitions/with-arrays.md)
-   [Chart](/documentation/design/advanced-features/charts.md)
-   [Condition](/documentation/design/conditions/overview.md)
-   [Color](/documentation/design/advanced-features/colors.md)

## Generate sales reports from your CRM or ERP

Sales and finance teams send the month's figures from their CRM or ERP to the Carbone API as JSON and get back the performance report for management as a PDF.

Here, a DOCX template presents three KPIs, a bar chart comparing product line revenue over two months, and a ranking of the top accounts.

In this example, you will:

-   Display KPIs with currency formatting
-   Show colored up and down arrows based on a value
-   Feed a native bar chart with a loop
-   Display a ranking table

## How to build a monthly sales report

Follow these steps to create your sales performance report:

### 1\. Build the Header and the KPI Cards

-   Insert tables for the header and the three KPI cards, and set their borders to **None**.
-   Display the data with [Carbone tags](/documentation/design/substitutions/the-basics.md). Example: `{d.report.title}`
-   Format the amounts with [:formatC](/documentation/design/formatters/currency.md#formatc-precisionorformat-targetcurrencyoroptions). Example: `{d.kpis.revenue.value:formatC(0)}`

_Tip: The currency depends on the `lang` and `currencySource` / `currencyTarget` options of the render request (here `en-us` and `USD`)._

### 2\. Add Trend Indicators

-   Display an arrow with the conditional formatters [ifGTE](/documentation/design/conditions/overview.md#ifgte-value) and [show/elseShow](/documentation/design/conditions/inline-conditions.md#show-text-elseshow-text), and remove the sign with [:abs](/documentation/design/formatters/number.md#abs): `{d.kpis.revenue.deltaPct:ifGTE(0):show(↑):elseShow(↓)} {d.kpis.revenue.deltaPct:abs}%`
-   Color the paragraph with [:color](/documentation/design/advanced-features/colors.md#condition-and-color): `{d.kpis.revenue.deltaPct:ifGTE(0):show(1F8A4C):elseShow(B23A48):color(p, text)}`

### 3\. Add a Bar Chart

-   Insert a native [chart](/documentation/design/advanced-features/charts.md#native-charts), here a **Clustered Bar** chart.
-   In the chart data sheet, define the series labels and a [loop](/documentation/design/repetitions/with-arrays.md#simple-array) on the product lines:

```text
|                            | {d.report.period.currentLabel}             | {d.report.period.previousLabel}             |
|----------------------------|--------------------------------------------|---------------------------------------------|
| {d.productLines[i].name}   | {d.productLines[i].currentMonth:formatN}   | {d.productLines[i].previousMonth:formatN}   |
| {d.productLines[i+1].name} | {d.productLines[i+1].currentMonth:formatN} | {d.productLines[i+1].previousMonth:formatN} |
```

-   Use [:formatN](/documentation/design/formatters/number.md#formatn-precision-options) so the chart receives numbers.
-   Customize the chart in Word: legend, colors, **Data Labels** and number format (here `[$-409]$#,##0,"K"` to display thousands with US separators).

### 4\. Display the Top Accounts Table

-   Insert a table with a header row, then display the accounts in a [loop](/documentation/design/repetitions/with-arrays.md#simple-array): `{d.topAccounts[i].name}` in the first row and `{d.topAccounts[i+1]}` in the second.
-   Reuse the formatters of the previous steps for the revenue and the trend.  
    Example: `{d.topAccounts[i].revenue:formatC(0)}`

_Tip: Spaces are allowed inside tags, for example `{d.topAccounts[i] .revenue :formatC(0)}`, so long tags wrap at a readable place in narrow cells._

Save the DOCX template, connect it to your JSON data, and let Carbone generate your **sales performance report** automatically.

## Related Examples

Check out these similar templates to learn more:

- [Monthly treasury FX report](/examples/financial-report/index.md): DOCX template to PDF.
- [Quarterly financial dashboard](/examples/s-financial-dashboard/index.md): XLSX template to XLSX.

## Related topics

- [Monthly management report](/examples/monthly-management-report/index.md)
- [Quarterly board pack](/examples/quarterly-board-pack/index.md)
- [Utility invoice with payment slip](/examples/invoice-expert/index.md)
- [Monthly fund factsheet](/examples/fund-factsheet/index.md)
- [Multi-page product invoice](/examples/invoice-simple/index.md)
- [Monthly treasury FX report](/examples/financial-report/index.md)
