> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bango.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Billing forecast report

> Report format for future invoices due in the next month.

# Forecast report

The forecast report lists future invoices due in the next month.

For example, a forecast report run on **31 January** shows future invoices due in **February**.

Use this report to help predict future charges.

<Warning>
  Forecast reports are not guaranteed to be completely accurate. Invoices are recalculated when they become due, so invoice values can change after the forecast report is generated.
</Warning>

## Why forecast values can change

Differences between a forecast report and the final invoice can be caused by:

* Price changes
* Entitlement tier changes, such as an upgraded or downgraded subscription tier
* Additional subscriptions created after the forecast report was run
* Subscriptions suspended or terminated after the forecast report was run

## Report format

| Column name | Format | Description | Example |
| - | -: | - | - |
| `consumerIdentifier` | string | Unique identifier for your consumer | `AC-345/JF7A` |
| `consumerOfferId` | uuid | Unique identifier for the consumer bundle | `dd8e206a-fb89-4ed1-9115-af38466d6003` |
| `offerId` | uuid | Unique identifier for the offer associated with the consumer bundle | `088bdb2b-742f-4a4a-b0c3-bd0589b49a6c` |
| `billingPlanId` | uuid | Unique identifier for the billing plan associated with the consumer bundle | `5264c710-52a8-4668-bbfc-12eeeb515f9c` |
| `invoiceId` | uuid | Unique identifier for the invoice | `4096f6f0-121f-4b44-81a5-c5598e67daf3` |
| `invoiceEffectiveTs` | ISO-8601 to milliseconds | Date and time the invoice becomes due | `2025-05-22T17:53:21.013Z` |
| `currency` | ISO-4217 | Alphabetic three-letter currency code | `USD` |
| `invoiceDisplayAmount` | number | Amount due, shown to the maximum decimals for the currency | `17.99` |
| `invoiceStatus` | string enum | Forecast invoice status. The only available value is `CALCULATED`. | `CALCULATED` |

## Enum values

### `invoiceStatus`

| Value | Description |
| - | - |
| `CALCULATED` | Forecast invoice has been calculated |

## Example header

```csv theme={null}
consumerIdentifier,consumerOfferId,offerId,billingPlanId,invoiceId,invoiceEffectiveTs,currency,invoiceDisplayAmount,invoiceStatus
```

## How to use the forecast report

| Use case | Relevant columns |
| - | - |
| Identify the consumer | `consumerIdentifier` |
| Link the invoice to a consumer bundle | `consumerOfferId` |
| Link the invoice to an offer | `offerId` |
| Link the invoice to a billing plan | `billingPlanId` |
| Identify the forecast invoice | `invoiceId` |
| Determine when the invoice is due | `invoiceEffectiveTs` |
| Estimate the charge amount | `currency`, `invoiceDisplayAmount` |
| Confirm forecast invoice state | `invoiceStatus` |

## Related reports

<CardGroup cols={2}>
  <Card title="Billing plan report" icon="receipt" href="/billing-charging-reports/billing-plan-report">
    Detailed billing plan information, including current and future phases.
  </Card>

  <Card title="Billing & charging reports" icon="receipt" href="/billing-charging-reports">
    Overview of billing and charging report options.
  </Card>
</CardGroup>