Cash and AR/DSO Dashboard

The Cash and AR/DSO dashboard enables you to monitor cash balances and analyze performance in the related areas of cash flow, accounts receivable aging, and days sales outstanding (DSO).

The cash analytics pair a summary of the current cash status with supporting detail by cash account. The Cash Trending line chart traces how deposits, disbursements, and cash balance have trended over the current fiscal year, and the Cash Waterfall chart supplements that information with a period-by-period visual representation of the effects of deposits and disbursements on cash balance.

Similarly, the AR analytics prominently display current balances for each of your AR aging ranges and then broaden your view to include trends in total AR and in the balance for each aging range for the current fiscal year. And you can drill down to evaluate AR for specific organizations.

Use the DSO analytics to do the following:
  • Monitor how quickly your customers are paying for billed goods and services.
  • Ensure that your unbilled revenue does not climb to an unacceptable level.
  • Judge the effectiveness of your collection procedures.
  • Evaluate whether current customer payment practices are in line with your cash flow needs.
  • Review period-by-period DSO values to ensure that they are trending in the right direction.

Related Topics

Related Topics:

  • Cash Summary
    The cash summary fields display beginning cash balance, total deposits, total disbursements, and ending cash balance for all cash accounts for either the current fiscal year to date or the current fiscal period.
  • Cash Account Details Table
    The Cash Account Details table displays beginning cash balance, total deposits, total disbursements, and ending cash balance, by account, for either the current fiscal year to date or the current fiscal period.
  • Cash Trending Chart
    The Cash Trending chart shows period-by-period trends for deposits, disbursements, and ending cash balance for the current fiscal year.
  • Cash Waterfall Chart
    The Cash Waterfall chart provides a graphical representation of the period-by-period impact of deposits and disbursements on your cash balance for the current fiscal year.
  • AR Summary
    The AR summary fields display the current total outstanding AR for each of your AR aging ranges.
  • AR Aging Chart
    The AR Aging chart displays AR amounts, broken down by aging range, as of the end date of each of the fiscal periods in the current fiscal year. Each full bar represents the total AR at the end of that period, and each segment in a bar represents the AR amount for invoices in that aging range.
  • Trending DSO Detail Table
    The Trending DSO Detail table displays, by period, ending AR balance, ending unbilled balance, total billing amount for the prior three periods, total revenue for the prior three periods, and the DSO value.
  • Current DSO by Client Table
    The Current DSO by Client table displays, by client, current AR balance, current unbilled balance, total billing amount for the prior three periods, total revenue for the prior three periods, and the DSO value.
  • Current DSO by Org Table
    The Current DSO by Org table displays, by organization, current AR balance, current unbilled balance, total billing amount for the prior three periods, total revenue for the prior three periods, and the DSO value.
  • AR/DSO Chart
    The AR/DSO chart displays, by period, either AR amounts or DSO values, depending on the option you select in Show AR By.
Parent Topic: Deltek CFO Dashboards