`get_profit_and_loss`

Pack: xero · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/get_profit_and_loss for the schema, then POST the same URL with its arguments for the data.

Get the Profit and Loss (income statement) financial report from a Xero accounting organisation for an optional date range. Returns the structured Xero report (report name, date, and row sections covering revenue, expenses, and net profit). Use for financial reporting and bookkeeping analysis.

Parameters

Name	Type	Required	Description
`tenant_id`	string	no	Optional Xero tenant (organisation) id to target. If omitted, the first connected organisation is used. Get ids from list_organisations.
`from_date`	string	no	Optional start date of the reporting period in YYYY-MM-DD format.
`to_date`	string	no	Optional end date of the reporting period in YYYY-MM-DD format.

Example call

Arguments

{
  "tenant_id": "12345678-1234-1234-1234-123456789012",
  "from_date": "2024-01-01",
  "to_date": "2024-12-31"
}

curl

curl -X POST https://gateway.pipeworx.io/xero/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"get_profit_and_loss","arguments":{"tenant_id":"12345678-1234-1234-1234-123456789012","from_date":"2024-01-01","to_date":"2024-12-31"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('get_profit_and_loss', {
  "tenant_id": "12345678-1234-1234-1234-123456789012",
  "from_date": "2024-01-01",
  "to_date": "2024-12-31"
});

More examples

{
  "from_date": "2024-01-01"
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the xero pack

{
  "mcpServers": {
    "xero": {
      "url": "https://gateway.pipeworx.io/xero/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

get_profit_and_loss