MA Assist Home
MA Assist
From
To
Client

Total Debt Trend with invoices raised & receipts

Debt Balance
Weekly Invoices & Receipts

Debt Movement latest week waterfall

Top 10 Debtors with trend sparklines

Rank Client Name Total Debt Change Weeks Invoices Oldest Trend

Aging Breakdown by Client who owes what in each bucket

Rank Client Name Amount % of Bucket

Overdue vs Not Due latest week

Aging Distribution % composition over time

Average Age of Debt weighted by bucket value

Collection Efficiency receipts vs invoices + CEI

Credit Notes Trend total & % of debt

Weekly Collections money collected per week How this is calculated

Each week we compare the current transaction ledger against the previous week to derive the net money collected:

Net Invoices Settled — the value of invoices that left the ledger (paid/settled/written off) minus new invoices raised that week. This gives the true net reduction in outstanding invoices.

Net Receipts Received — new receipt transactions (payments from clients) that appeared this week minus old receipts that were allocated out. This gives the true net increase in payments held.

Net Collected = Net Invoices Settled + Net Receipts Received

= (Settled − New Raised) + (Receipts In − Receipts Allocated)

Requires transaction-level data in both the current and previous week’s snapshots. Hover over bars for full breakdown.

Receipts Breakdown payments received by client

Rank Client Name Count Total Value % of Total

Aging Migration week-on-week bucket changes

Concentration Risk top 10 debtors & cumulative %