Back to Prompt Library

AR aging buckets (30 / 60 / 90 / 90+ days)

Produces a standard aging summary bucketed by days past due. This is the format banks, bonding companies, and CPAs request.

Using my Knowify data, query InvoicesSummaryReport for all outstanding invoices within [date range] where OutstandingAmount is greater than 0. Bucket each invoice by days past due date: Current (not yet due), 1-30 days, 31-60 days, 61-90 days, 91-180 days, 180+ days. Show total outstanding and count of invoices in each bucket.