Invoice Aging

Overdue Invoices

List all overdue and unpaid invoices ranked by amount descending.

Setup

Resolve org ID via ZohoBilling_List_all_Organizations.

Fetch (run in parallel)

Paginate while has_more_page: true. Deduplicate across lists by invoice ID.

Output

Overdue & Unpaid Invoices — [date]
Total exposure: $XXX,XXX across N invoices
────────────────────────────────────────────────────────
 #  Invoice      Customer            Amount    Days    Status
────────────────────────────────────────────────────────
 1  INV-10045    Acme Corp          $48,200    92d    Overdue
 2  INV-10089    Northwind Traders  $31,500    45d    Overdue
 3  INV-10102    Globex Industries  $18,300    31d    PartiallyPaid
...
────────────────────────────────────────────────────────
Subtotals: Overdue $X · Unpaid $X · PartiallyPaid $X

Sort order: Overdue first (by days desc), then Unpaid (by amount desc), then PartiallyPaid.

Aging buckets summary at the bottom:

0–30 days:   N invoices  $XXX,XXX
31–60 days:  N invoices  $XXX,XXX
61–90 days:  N invoices  $XXX,XXX
90+ days:    N invoices  $XXX,XXX  ⚠ High write-off risk

Constraints

• Paginate all three status lists fully before deduplicating
• Days overdue = today − due_date
• Flag 90+ day bucket if it contains > 20% of total exposure
• Propose-only: no write actions

Edge cases

• Zero results: "No overdue or unpaid invoices — AR is clean 🟢"
• More than 100 invoices: show top 50 by amount, add note "Showing top 50 of N — filter by customer for details"