ReportToaster

Premium Report - Aged Receivables

Aged Receivables

This report is used to identify customers with outstanding balances.

This is determined by comparing the Order Date and the Paid at date and including any orders where either

  1. The order is unpaid.
  2. The order is only partially paid and a balance still remains.
  3. The order has been paid, but only after the last date on the report (default - 365 days ago to Today)

This report is designed to quickly find customers who have unpaid/partially paid orders, and group them into 'aging buckets' of how many days it's been since their order(s), and display the total sales for those orders:

By default the report is set from 365 days ago to Today. However, you can adjust this date range to whatever you like.

Here are a few terms to be familiar with in order to understand Aged Receivables, numbered in the screenshots above:

**1.) Cancelled at, is not set (FILTER):**This filter ensures that orders that have been cancelled are excluded from the report.

**2.) Total Due, greater than 0 (FILTER):**This metrics filter ensures that only customers with a Total Due (see below) greater than 0 are included in the report.

3.) Total Sales: The sum total value of all the orders for that customer.

4.) Paid Amount: The amount that has already been paid by that customer.

5.) Total Due: The amount still owed by that customer.

Remember - This is 'Total Due' as of the last date on the date range selected for the report (default - 365 days ago to Today).

6.) Aging Buckets: Orders are 'bucketed' according to the number of days that have passed since the Order Date on an unpaid order and the last date on the report (default - Today).

If an order falls within this range, the total still due for that order is displayed in the field.

Note - We can create further aging buckets for users upon request - just reach out to us at support@cloudlab.com and we can get those setup for you accordingly.

Like all Report Toaster reports, these reports are fully customizable - so you can adjust the date range, add/remove columns, introduce a filter or change the sort to suit your individual needs. See our basic guides here for more info.