Send a weekly cash position email from Xero (n8n)

Every Monday, email the bank balances and the totals of bills due this week.

n8nReportingIntermediateHuman check: Low

Tools
n8n: Xero, Gmail

Time saved
~1-2 hrs/month (estimate)

Difficulty
Intermediate

Steps

Schedule Trigger: Mondays.
HTTP Request with the Xero credential: GET /Reports/BankSummary.
Xero → Invoice → Get All, filtered to Type = ACCPAY with a due date in the next 7 days.
Code node to build an HTML table, then Gmail → Send.

Keep a human check here: Low risk

Compare the totals to the bank balance before you forward the email to leadership.

Node and module names match n8n's docs as of Oct 2026. Apps rename triggers and actions sometimes, so check yours in the editor. Try it with test data or a sandbox company first.

Build it

[AFFILIATE LINK PLACEHOLDER: not live]
Try n8n. We may earn a commission if you sign up, at no cost to you. Disclosure

Related recipes

Assemble a monthly board report packet (Make)

Put P&L and balance sheet figures into a Google Docs template and save the PDF to the board folder.

MakeReportingAdvancedHuman check: Medium

Saves ~3-5 hrs/month

Post a monthly KPI snapshot to Slack (Zapier)

When the KPI row for the month is marked final, post a short summary written by AI.

ZapierReportingBeginnerHuman check: Low

Saves ~1 hr/month