Prepare an overdue invoice review

What this template does

Exclude explicitly paid invoices, retain overdue records and order them by days until due. An invoice due today is not included as overdue.

Prepare these inputs

An ID, due date and optional status from an authorized billing export, plus top-level as_of. The output contains no payment link and sends no collection message.

Field map: id, due, status; top-level as_of

From input to reviewable output.

Use the synthetic example or edit its JSON structure. This demo sends no input to an AI service or our server. Keep real personal data in your approved environment. Up to 1,000 records and 100 KB of JSON.

Ready. Run the sample to inspect the result.

Use the starter in n8n

1. Download the JSON and import it using n8n’s import-from-file option. Keep it unpublished.
2. Inspect the three nodes: Manual start → Sample input → Reviewable output. Run it manually with the synthetic example.
3. Compare records, rejected and the counts with the demo here. The output is one item containing an envelope; split the records array if a later node expects individual items.
4. Replace Sample input with an approved source only after mapping its data to the same single-item JSON structure shown above. Supply an explicit as_of where required.
5. Add a separate review or approval step before any external write. Test credentials and permissions in your own environment, then decide whether a schedule is appropriate.

The download has no live connector, schedule, credential or external request. Connecting a mailbox, CRM, spreadsheet or notification destination is a separate setup and test.

SHA-256: a184441a138af51fae236a492681a706c16daa4c37a2e3c2375a1a6237e7a4d6

Limits and review points

A missing paid status is not proof that money is owed. Reconcile payment events, disputes and grace periods before contacting anybody. No fees or interest are calculated.

Rejected rows are returned with their one-based input position and a reason. Review them before using the result; an empty output can be a valid outcome. Unknown or malformed top-level inputs produce an error instead of a guessed result. Keep an untouched input export for reconciliation.

Run costs and data handling

The browser step has no service fee, API call or account requirement. It uses no browser storage for your input. Ordinary website access logs still apply. Downloaded results are saved only when you request them. Your own n8n hosting, cloud plan and any later connected service may have charges; no paid AI model is required by this starter.