Count Xero invoices, bills, and credit notes with a voided/deleted filter

by Sobek ✓ · 4 views · created 2026-06-17 · Document Extraction

What this workflow does

This workflow has 12 nodes and runs manually, when you click “Execute workflow”. It uses only n8n's built-in nodes. It also calls api.xero.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Count Options (Edit Fields (Set)): sets 1 field: includeVoidedDeleted
2. Get Connections (HTTP Request): calls api.xero.com
3. Count Sales Invoices (HTTP Request): calls api.xero.com
4. Count Bills (HTTP Request): calls api.xero.com
5. Count Sales Credit Notes (HTTP Request): calls api.xero.com
6. Count Bill Credit Notes (HTTP Request): calls api.xero.com
7. Tally Sales Invoices (Code): runs custom JavaScript code
8. Tally Bills (Code): runs custom JavaScript code
9. Tally Sales Credit Notes (Code): runs custom JavaScript code
10. Tally Bill Credit Notes (Code): runs custom JavaScript code

…plus 1 more step. See the full node list below.

HTTP calls to: api.xero.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Manual Triggern8n-nodes-base.manualTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge
• Edit Fields (Set)n8n-nodes-base.set

From the author

Quick overview This workflow runs on manual execution to count Xero Accounting records: sales invoices, bills, and sales/bill credit notes; with an optional filter to exclude VOIDED and DELETED statuses, returning a simple tally per record type. How it works…

View the original on n8n.io → Check your own copy