Receivables aging

See which customers still owe you money: the unpaid and overdue invoices, how late each is, and the total.

npx skills add wellapp-ai/skills --skill accounts-receivable-aging
Wellapp
Who owes us money, and since when?

Ask anything or use / for commands...

How the skill answers

Every step of the run, in order, with the card each one returns. A step that hands its work to another skill says which one.

  1. You ask

    Who owes us money, and since when?

  2. Pin the workspaceSkill useddefine-workspace

    Workspaces

    Pick the workspaces to work in.

    Your workspaces
  3. Confirm the connections this answer needsSkill usedconnect-tools

    Connect a tool

    Pick a tool to connect it to Well.

    Available tools
    1 of 1
    QuickBooks avatar
    QuickBooks
    Connection
    —
    Category
    Accounting
    Data
    Accounting
    Status
    —
    Last sync
    —
    1 selected
  4. Verify the rows landed
  5. Resolve your own companySkill usedconfirm-my-company
  6. Read the receivables
  7. Separate what cannot be aged, before bucketing anything
  8. Age what remains
  9. Normalize currencySkill usednormalize-currency
  10. If any required step errors or returns unusable data
  11. You get

    Invoices

    Issuer
    Total amount
    Due date
    S
    Stripe
    €48,600.00
    M
    Mercury
    €32,480.00
    S
    Slack
    €4,920.00
    H
    HSBC
    €31,200.00
    Q
    Qonto
    €19,800.00
    X
    Xero
    €26,500.00
    A
    Asana
    €17,500.00
    S
    Sage
    €21,700.00
    Showing 8 of 9

    €214K outstanding across 9 invoices. €86K is current, €51K is 1-30 days late, €44K is 31-60, and €33K is over 90 days out with Sage and Agicap. Oldest is 112 days.

Frequently asked questions

How does it tell receivables from payables?

Well places the side of each invoice on the server, from the company records your workspace holds, and never asks you to pick a company in this answer. An invoice it cannot place is listed to check, with its issuer and its receiver named, and counted beside the total instead of being counted as owed to you.

Which aging bands does it use?

Current (not yet due), 1-30, 31-60, 61-90, and 90+ days past due, measured from the due date against a stated as-of date.

What happens to an invoice with no due date?

It gets its own line, listed with its amount and customer. It is in the outstanding total and in no band. A due date is optional on an invoice record, and no other date substitutes for one: aging a row from its issue date instead would read as a real overdue figure while resting on a guess.

What about an invoice whose payment status could not be worked out?

It is named, not summed. Well recomputes payment status from the payments allocated against an invoice, and that recompute halts on a few conditions, such as an invoice total that is missing or not positive, an allocation in a currency with no exchange rate available, or a locked period. A halted row keeps no fresh payment status or balance, so the skill lists those invoices separately instead of treating them as settled or as overdue.

Which payment status does it report?

The one Well recomputes from allocated payments, and it says so. Where a source system asserts an invoice is settled but no bank payment has been matched to it yet, the skill reports that state under its own heading rather than silently choosing between the two answers.

Does it convert everything into one currency?

Only with the rate and rate date shown. Currencies are never blended into a single figure. A currency with no rate available is reported on its own and named as excluded from the converted total.

Does it chase the payment for me?

No. The skill surfaces who is late and by how much, and drafts a reminder when you ask for one. Sending the follow-up stays with you.

Does it answer "does anyone owe me money"?

It answers the customer-invoice part: which customers still owe you, how much each owes and how late they are. The wider ask, where supplier refunds, credit notes and VAT possibilities sit beside the unpaid invoices, is `money-back`'s. That skill reads them and folds this receivables read into its single answer.

Ask your first question today

Connect your tools, then ask in plain language. Every answer traces back to the record behind it. Free to start.