DD14 Receivables Aging & Collections: how it was built
Whom do I call today, and is collection getting worse? Rebuild this dashboard step by step in the Data Canvas.
DD14 · Receivables Aging & Collections
Code in this build: 8 widgets written in SQL, and 4 filter, chart or pivot settings written as code.
The question: Whom do I call today, and is collection getting worse?
Who asks, and when: The credit controller, daily.
The decision: Whom to call today, and whether collection is getting worse.
What the dashboard shows: Helix Retail Group owes 170,829.65 past 90 days - four invoices, and the whole of the 90+ bucket; DSO averages 50.3 days over 2026 against 43.4 in 2025.
Follow the pictures below, in order, and you end up with the same dashboard. Every step is one thing you do in the Data Canvas, on the demo data that installs with DataPallas.