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

# Aging balance

> Visualize how your receivables age over time with the Upflow aging balance widget, broken down by due, overdue brackets, and unapplied amounts.

Take a look at how your collection state evolved with the Aging balance widget, highlighting where you were at different points in time. Learn how your strategy impacted your collection over different periods and adjust it accordingly.

<img src="https://mintcdn.com/upflow-04dc27cd/AfdrXycJno4XMWAU/images/45488128580241.png?fit=max&auto=format&n=AfdrXycJno4XMWAU&q=85&s=0cd0fa38c3a0cae571d5a22b05d6811a" alt="" width="604" data-path="images/45488128580241.png" />

Each bar represents the amounts you were due at the end of each period (including disputed invoices), broken down into aging buckets (due, overdue for less than 30 days, 30 to 60 days, 60 to 90 days, more than 90 days). As well as unapplied amounts (learn more on their impact [here](/en-us/analytics/good-to-know/unapplied-amounts-in-analytics)).

Hover your mouse over the period you are interested in to display the breakdown. Note the amounts are always shown in your organization default currency. There is no breakdown by currencies today.

### Aging balance calculation

* For each period, the amounts are calculated for the end of the period, i.e. the end of the last day.
* For an ongoing/current period, it is calculated as of now (today).
* Future issued invoices are excluded from all analytics.
* When you apply filters to your Analytics report/dashboard, it will be calculated accordingly. The last period will correspond to the end date of the filter, which could be in the past. This is the best way to obtain the aging balance as of a date in the past.

## Use the aging balance widget

### Main dashboard

<img src="https://mintcdn.com/upflow-04dc27cd/AfdrXycJno4XMWAU/images/45488119219089.png?fit=max&auto=format&n=AfdrXycJno4XMWAU&q=85&s=4f39f92c38d31b7159f49db60623cd25" alt="" width="640" data-path="images/45488119219089.png" />

From your Upflow main dashboard, you will see a direct view of your aging balance, per bracket.

Click one to be redirected to the filtered invoices for more details, and export them if needed. To this view, you can filter further or rearrange the columns and save it!

### Analytics view

Filter your data from the dashboard’s filter button to focus on your interest (Date range, Country, Assigned users, Workflows, Custom fields…).

Hover your mouse over the widget to display the actions menu allowing you to export the widget’s (filtered) data.

| Action                                                                              | Screenshot                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| ----------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Display from absolute numbers to relative values.                                   | <img src="https://mintcdn.com/upflow-04dc27cd/AfdrXycJno4XMWAU/images/45488113233169.png?fit=max&auto=format&n=AfdrXycJno4XMWAU&q=85&s=ceac9fafc0e72b0f891b175f350b6654" width="182" alt="Toggle between absolute and relative values on the aging balance widget" data-path="images/45488113233169.png" />                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Break down the data per customer/invoice fields.                                    | <img src="https://mintcdn.com/upflow-04dc27cd/42UhFVgUk-opJEp-/images/45488081030801.png?fit=max&auto=format&n=42UhFVgUk-opJEp-&q=85&s=0ea70fecf22bbb920634555402c061fe" width="320" alt="Breakdown selector on the aging balance widget" data-path="images/45488081030801.png" />                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Remove one of the buckets by clicking its name in the legend.                       | <img src="https://mintcdn.com/upflow-04dc27cd/AfdrXycJno4XMWAU/images/45488081140881.png?fit=max&auto=format&n=AfdrXycJno4XMWAU&q=85&s=f02d5dc10cf39a4f136f5b62a0c7377c" width="458" alt="Aging balance legend with a bucket toggled off" data-path="images/45488081140881.png" />                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Move the widget around, expand or reduce its size.                                  | <img src="https://mintcdn.com/upflow-04dc27cd/AfdrXycJno4XMWAU/images/45488129100945.png?fit=max&auto=format&n=AfdrXycJno4XMWAU&q=85&s=28d4d2f391ae2166a1ba6c48e09876e8" width="258" alt="Drag handle on the aging balance widget" data-path="images/45488129100945.png" /> <img src="https://mintcdn.com/upflow-04dc27cd/AfdrXycJno4XMWAU/images/45488105670545.png?fit=max&auto=format&n=AfdrXycJno4XMWAU&q=85&s=89e3739393f9f75316a7c15564cf4f53" width="228" alt="Resize handle on the aging balance widget" data-path="images/45488105670545.png" /> |
| Remove, duplicate, export the widget, or copy the link to share it with a teammate. | <img src="https://mintcdn.com/upflow-04dc27cd/AfdrXycJno4XMWAU/images/45488081360529.png?fit=max&auto=format&n=AfdrXycJno4XMWAU&q=85&s=35a34640c7738fbe465b24bd92b25481" width="320" alt="Actions menu on the aging balance widget" data-path="images/45488081360529.png" />                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |

## FAQ/Good to know

#### When clicking the aging bucket, the total of invoices doesn't match the bucket's amount.

When applied Credit Notes have an issue date in the future, they will impact the Aging balance calculation.

This widget logic excludes applied transactions (payments, credit notes, refunds) with an issue date in the future. On the other hand, pre-computed invoice fields (status, aging bucket…) used by the list view take into account those future transactions.
