Export a client's month-end pack (.xlsx)
month_end_packGenerates a client-specific Excel month-end pack with aged receivables, bank reconciliation, and P&L snapshot, saving to XERO_AGG_EXPORT_DIR and returning the path and totals.
Instructions
Writes an Excel workbook for ONE client with three sheets: Aged Receivables (per invoice, bucketed current/1-30/31-60/61-90/90+ with totals), Bank Reconciliation (closing balance, unreconciled count and amount per account) and P&L Snapshot (latest month and period total). Saved in XERO_AGG_EXPORT_DIR; returns the path and the totals written so you can quote them.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| org | Yes | Client org: tenant id or (part of) the organisation name, e.g. 'Northwind'. | |
| as_of | No | Report date (YYYY-MM-DD). Defaults to today (demo mode: 2026-09-30). |