Back to all templates

Invoice Aging Report

Group outstanding invoice balances into aging buckets, with separate totals for each currency.

Setup

  1. Download the workflow JSON from this page (or use workflow.json from the builder package), then choose n8n's Import from File command.
  2. Replace SampleData with invoiceId, customer, amount, paid, currency, and dueDate values. Use YYYY-MM-DD dates and the same optional asOf date on all rows; if omitted, the report uses the current UTC date. Inspect totalsByCurrency and invoices.
  3. Select Execute Workflow. The result is in ProcessData.

Behavior and limits

Uses two-decimal monetary amounts, excludes fully paid invoices, and never combines currencies or converts exchange rates. Intended for two-decimal currencies such as GBP, EUR, and USD. It produces a report; it does not send reminders or change accounting records.

The supplied example needs no credentials. Any additional integration you connect requires its own configuration and tests.

Verification

Imported and executed successfully in an isolated n8n 2.44.5 instance on 2026-10-22. The sample report produced separate GBP and USD balances and the expected aging buckets. An invalid calendar date was rejected.

Failures appear in the n8n execution view; this template does not send error alerts. Review the output before connecting downstream actions.

References

Consulted official documentation on 2026-10-22:

Origin

Original n8nfinity workflow. Sample records are fictitious.