Create Xero AR/AP Markdown snapshots with optional OpenAI GPT summaries

Quick overview This workflow runs on a schedule to pull outstanding customer invoices and supplier bills from Xero, ranks the top 5 by amount due, and generates a Markdown AR/AP snapshot (optionally adding an OpenAI-based narrative summary). How it works Runs on a scheduled trigger (weekly by default). Sets report metadata and Xero invoice filters for receivables (ACCREC) and payables (ACCPAY) with AmountDue > 0. Fetches all matching authorised customer invoices and supplier bills from Xero. Normalizes dates and amounts, calculates days outstanding, sorts by amount due, and keeps the top 5 items for each list. Merges both lists and builds a Markdown snapshot with two tables and reporting notes. Outputs the final snapshot data (and, if enabled, sends the Markdown to OpenAI via an AI Agent to prepend a short AI summary). Setup Add a Xero OAuth2 credential and select the correct Xero tenant/organization ID used by the Xero nodes. Update the tenant/organization value in the snapshot settings (replace YOUR_XERO_TENANT_ID) and adjust the cadence label if needed. Configure the Schedule Trigger interval (weekly/monthly/quarterly/annual) to match your reporting rhythm.

Tags