Table of Contents

Cash

The Cash module of COSMO Analytics (BC on Fabric).

The Cash module turns Dynamics 365 Business Central receivables and payables data into an analytics-ready star schema for working-capital and liquidity management. It covers open and overdue amounts on both the receivable (customer) and payable (vendor) side, ageing structure, average days overdue, historical overdue trends and cash-discount realisation - with built-in time intelligence (PY, YoY, YoY %), multi-currency (invoice vs. reporting currency) and multi-company support, plus document-level detail down to individual open invoices and their due dates.

Key capabilities

  • Accounts receivable analysis - open and overdue customer balances by ageing group
  • Accounts payable analysis - open and overdue vendor balances by ageing group
  • Overdue exposure monitoring with amount and document counts, current and historical
  • Average days overdue tracking on both the receivable and payable side
  • Cash-discount performance - realised discounts and their share of total payments
  • Document-level drill to individual open invoices, document types and due dates
  • Time intelligence (PY, YoY, YoY %) and multi-currency / multi-company support

Who is it for

Persona Focus
CFO / Treasurer Steer liquidity and working capital; balance receivables against payables.
Credit / AR Manager Collect receivables faster; reduce overdue balances and days sales outstanding.
AP Manager / Purchasing Manage payment timing; capture cash discounts and avoid overdue payables.
Accountant / AR-AP Clerk Reconcile open items, trace document detail and validate ageing.

At a glance, the cash semantic model ships 174 measures, 22 dimensions and 3 fact table(s).

Tip

Have an ad-hoc cash question? Build your own report on the shipped semantic model in Power BI in just a few clicks - the measures, dimensions and time intelligence are ready to use.

Edit this page