SuperAPI AI Directory

invoice-aging

General & other

View repository

Updated 10-16 06:51

About this skill

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)

# Tool Params
1 ZohoBilling_List_all_Invoices filter_by: Status.OverDue, per_page: 200
2 ZohoBilling_List_all_Invoices filter_by: Status.Unpaid, per_page: 200
3 ZohoBilling_List_all_Invoices filter_by: Status.PartiallyPaid, per_page: 200

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"