As was pointed out in the previous report (Days Receivable By Client By Type), first you want to understand who are your slow payers.

Next, take a look at just your outstanding invoice risk. Select a starting invoice  date and compare invoices by type (FFA, L&S, Project, T&M, BT) to what was paid over another period of time. This will provide valuable insight into which clients have slowed down their payments for certain types of invoices.

The filters allow a Starting Invoice Date (1) - start looking at invoices that are outstanding starting at this date. Then compare to another Date Range (for example - last year). The date range can be custom (2) or a preset date range (3).

The body of the report shows:

1. Client Name
2. Account Manager Name
3. Invoice #
4. Type of Invoice (FFA, L&S, Project, T&M, BT)
5. Invoice Date
6. Days Outstanding (for the current invoice) - We track from the date of the invoice.
7. Weighted Days Average (what was paid for the Comparison Date Range) - Average number of days outstanding for invoices. It is weighted by the amount of the invoice.
   Weighted days Average = sum of (Invoice amounts X days before payment) / sum of invoice amounts
8. Delta Days (Days Outstanding - Weighted Days Average)
9. Invoice Amount

The report can be sorted by any of the above columns. In the example below, the report is sorted by the amount of revenue invoiced.