Invoice aging

Skill openaccountant/skills/business/invoice-aging

Track unpaid invoices by age bucket and flag overdue payments.From its SKILL.md

Install

npx -y skills add openaccountant/skills --skill invoice-aging

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

3.5 KB, 784 tokens by cl100k_base, as published. Nobody here has run it

Invoice Aging Report

Overview

Analyze accounts receivable by sorting outstanding invoices into aging buckets: Current (0-30 days), 31-60 days, 61-90 days, and 90+ days. Identifies clients with chronically late payments and calculates total exposure.

Wilson Tools Used

transaction_search — find payment transactions matched to known clients or invoice references, identify gaps where expected payments are missing

Workflow

Ask for the list of outstanding invoices (client name, invoice amount, invoice date, due date) or ask the user to describe their invoicing pattern.
Use transaction_search to find all incoming payments from each client over the past 6 months.
Cross-reference received payments against known invoice amounts and dates.
For each unpaid or partially paid invoice, calculate days outstanding from the due date.
Sort into aging buckets:

ACCOUNTS RECEIVABLE AGING — as of [Date]
═══════════════════════════════════════════════════════
Client          Current   31-60    61-90     90+     Total
────────────────────────────────────────────────────────
Acme Corp       $2,500      —        —        —     $2,500
Beta LLC            —    $1,800      —        —     $1,800
Gamma Inc           —       —     $3,200      —     $3,200
Delta Co            —       —        —     $5,000   $5,000
────────────────────────────────────────────────────────
TOTALS          $2,500   $1,800   $3,200   $5,000  $12,500
% of Total       20.0%    14.4%    25.6%    40.0%    100%
═══════════════════════════════════════════════════════

Flag any client with invoices in the 90+ bucket.
Calculate weighted average days outstanding.
Recommend follow-up actions: send reminder (31-60), escalate (61-90), consider collections (90+).

Without Wilson

Export your invoice list from your invoicing tool (QuickBooks: Reports > Customers & Receivables > A/R Aging Summary; FreshBooks: Reports > Accounts Aging; Wave: Reports > Aged Receivables).
If no invoicing tool, create a spreadsheet with columns: Client, Invoice #, Amount, Invoice Date, Due Date, Paid Date, Paid Amount.
Calculate days outstanding: =IF(PaidDate="", TODAY()-DueDate, PaidDate-DueDate).
Assign buckets with: =IF(DaysOutstanding<=0,"Current",IF(DaysOutstanding<=30,"Current",IF(DaysOutstanding<=60,"31-60",IF(DaysOutstanding<=90,"61-90","90+")))).
Pivot table: Rows = Client, Columns = Bucket, Values = Sum of Amount.
For weighted average: =SUMPRODUCT(Amount,DaysOutstanding)/SUM(Amount).

Important Notes

Wilson tracks cash transactions, not invoices directly. This skill works best when you can provide a list of issued invoices to cross-reference against bank deposits.
Partial payments should be tracked. If an invoice is $5,000 and $3,000 was received, the remaining $2,000 is still outstanding.
Consider offering early payment discounts (e.g., 2/10 Net 30) for clients consistently in the 61-90+ buckets.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Gives 0 of the 12 instructions most finance skills give in 784 tokens

Counted across 469 of the 469 authors here whose files we hold, read 2026-08-07

Extract date vendor amount and descriptionin 15 of 469, across 3 files
Scan folder for invoice filesin 14 of 469, across 2 files
Rename files to standard formatin 14 of 469, across 2 files
Show organization plan before movingin 14 of 469, across 2 files
Generate summary CSVin 14 of 469, across 2 files
Organize files by categoryin 13 of 469, across 1 file
Preserve original filesin 13 of 469, across 1 file
Flag files missing critical infoin 13 of 469, across 1 file
Produce the requested output filein 9 of 469, across 4 files
Build best, base, and worst case scenariosin 9 of 469, across 5 files
Implement backoff if rate limit errors occurin 8 of 469, across 3 files
Determine the weighted average cost of capitalin 8 of 469, across 4 files

Said here and by no other author read

Request the list of outstanding invoices from the user
Search for all incoming client payments
Cross-reference received payments against known invoices
Sort unpaid invoices into aging buckets
Flag clients with invoices in the 90+ bucket
Calculate weighted average days outstanding

Grouped from the skills themselves: near-identical wordings counted once, and counted by distinct author, so one author publishing three of these counts once. Length counted with cl100k_base; the agent that loads this file may tokenize it differently.