Table of Contents

Cash - Key Business Questions

The questions below are grouped by the persona who typically asks them. Each question is answered either through a ready-made standard report or through an ad-hoc, self-service analysis you build yourself on the semantic model by combining the listed measures with the listed dimensions.

CFO / Treasurer

Steer liquidity and working capital; balance receivables against payables.

How much are we owed and how much do we owe right now?

Answer with the report: Receivables

  • Measures: AR Amount Receivable, AR Amount Open, AP Amount Payable, AP Amount Open

How large is our overdue exposure on the receivable and payable side?

Answer with the report: Payables

  • Measures: AR Amount Overdue, AR Amount Overdue %, AP Amount Overdue, AP Amount Overdue %

How is our overdue exposure developing versus last year?

Answer ad-hoc (self-service): build this on the semantic model yourself.

  • Measures: AR Amount Overdue YoY %, AP Amount Overdue YoY %, AR Amount Open YoY %, AP Amount Open YoY %
  • Break down by: Calendar (DueDate), Client

Credit / AR Manager

Collect receivables faster; reduce overdue balances and days sales outstanding.

Which customers have the largest open and overdue receivables?

Answer with the report: Receivables

  • Measures: AR Amount Open, AR Amount Overdue, AR #Documents Open, AR #Documents Overdue

Answer with the report: Receivable Details

  • Measures: AR Avg Days Overdue, AR Avg Days Overdue (incl in Time), AR Amount Overdue % (Historical)

How well are customers using cash discounts, and what are we granting?

Answer with the report: Receivable Details

  • Measures: AR Payment Amount CashDiscount, AR Payments CashDiscount (% of TTL)

Which individual invoices are overdue and by how many days?

Answer ad-hoc (self-service): build this on the semantic model yourself.

  • Measures: AR Amount Open, AR Amount Receivable, AR Avg Days Overdue (incl in Time)
  • Break down by: InvoiceCustomer, Calendar (DueDate)

AP Manager / Purchasing

Manage payment timing; capture cash discounts and avoid overdue payables.

Which vendors carry the largest open and overdue payables?

Answer with the report: Payables

  • Measures: AP Amount Open, AP Amount Overdue, AP #Documents Open, AP #Documents Overdue

How is our average days overdue to vendors developing over time?

Answer with the report: Payables Details

  • Measures: AP Avg Days Overdue, AP Avg Days Overdue (incl in Time), AP Amount Overdue % (Historical)

How much cash discount are we realising on payments, and what share is that?

Answer with the report: Payables Details

  • Measures: AP Payment Amount CashDiscount, AP Payments CashDiscount (% of TTL)

Which payable documents are due next and for how much?

Answer ad-hoc (self-service): build this on the semantic model yourself.

  • Measures: AP Amount Open, AP Amount Payable, AP Amount Discountable
  • Break down by: Vendor, Calendar (DueDate)

Accountant / AR-AP Clerk

Reconcile open items, trace document detail and validate ageing.

How do open receivables and payables split across ageing groups?

Answer with the report: Receivables

  • Measures: AR Amount Open, AR Amount Overdue, AP Amount Open, AP Amount Overdue

How many open and overdue documents are behind a given balance?

Answer ad-hoc (self-service): build this on the semantic model yourself.

  • Measures: AR #Documents, AR #Documents Open, AR #Documents Overdue, AP #Documents Open
  • Break down by: InvoiceCustomer, Vendor, LedgerEntryDocumentType

What is the receivable and payable exposure in the original invoice currency?

Answer ad-hoc (self-service): build this on the semantic model yourself.

  • Measures: AR Amount Receivable (FC), AP Amount Payable (FC)
  • Break down by: CurrencySource, Client
Edit this page