Back to Prompt Library

Collection rate trend by quarter

Shows what percentage of invoiced revenue was actually collected each quarter — revealing whether collections are improving or deteriorating over time.

Using my Knowify data, query InvoicesSummaryReport for all invoices within [date range]. Sum TotalAmount and OutstandingAmount per quarter. Derive collected amount and calculate collection rate (collected divided by invoiced) for each quarter. Is the rate improving or worsening?