ActionXeroUpdated September 2026

How do I pull a Xero P&L report?

Short answer: You can get profit & loss in Xero by hand from its own interface, but it won’t repeat itself. On TinyCommand, add the Xero Get Profit & Loss action to a workflow, map its 3 inputs from any upstream app, and it runs automatically every time the trigger fires. No code, and a free tier to start.

Get Profit & Loss in Xero — start free All 3 Xero actions

Get Profit & Loss in Xero — start free

Inputs

The fields this action accepts.

Every field can be mapped from an upstream trigger, AI step, table row, or hard-coded literal.

Field	Type	Required	Description
Tenant ID tenant_id	string	Required	Tenant ID. Example: abc-123-def
From Date fromDate	string	Optional	From Date. e.g. "YYYY-MM-DD"
To Date toDate	string	Optional	To Date. e.g. "YYYY-MM-DD"

Sample request

{
  "tenant_id": "e.g. abc-123-def",
  "fromDate": "YYYY-MM-DD",
  "toDate": "YYYY-MM-DD"
}

Returns

{
  "Reports": [
    {
      "Rows": [
        {
          "Cells": [
            {
              "Value": "Account"
            },
            {
              "Value": "Amount"
            }
          ],
          "RowType": "Header"
        }
      ],
      "ReportName": "Profit and Loss"
    }
  ]
}

Use these fields in downstream nodes for routing, logging, or error handling.

Triggered by

Apps that pair well as the trigger for Get Profit & Loss.

Any of these apps can fire this action as part of a workflow.

2 Google Sheets triggers

HubSpot → Xero

18 HubSpot triggers

FAQ

Questions about Get Profit & Loss.

What does the Get Profit & Loss action do in Xero?

Retrieves the Profit and Loss report from Xero for a date range with tracking-category breakdowns. Use for monthly close packs, board updates, or finance dashboards.

What inputs does Get Profit & Loss require?

Required: Tenant ID. Every input accepts a static value or a variable from any upstream node in your workflow.

Can I use dynamic inputs from earlier workflow nodes?

Yes. Any field on this action can pull values from upstream nodes, whether that's a form response, a trigger payload, an AI output, or a lookup result.

What happens if Xero returns an error?

The run history shows the failed step with its input and the error message Xero returned, so you can fix the input and run the workflow again. Automatic retries are built into HTTP steps only, where you can also set your own retry count and delay.

Does Get Profit & Loss support batch operations?

Run Get Profit & Loss inside a loop to process each item in an array. TinyCommand does not throttle calls for you, so for large arrays add a Delay step if you need to stay within Xero's rate limits.

More actions

Other Xero actions.

Action

Create Invoice

Creates a new invoice in Xero (ACCREC for sales, ACCPAY for bills) with contact, line items, dates, and reference. Used to invoice on project completion or to mirror billable work from another system.

Action

List Contacts

Lists contacts in Xero (customers, suppliers, employees) with their addresses, balances, and tax numbers. Used for CRM sync or AR/AP reports.

Get Profit & Loss in Xero — start free