Xero: Profit And Loss Report

Description

• Each record represents a P&L line item at the month and account level.

Supported Data Sources

• Xero

Columns

Type	Name	Description
STRING	profit_and_loss_id	Unique identifier for each record in the profit and loss report model.
DATE	date_month	The month of activity.
STRING	account_id	The ID of the related account in Xero.
STRING	account_name	The name of the related account in Xero.
INTEGER	account_code	The code of the related account in Xero.
STRING	account_type	The type of the related account in Xero.
STRING	account_class	The class of account, e.g. ASSET, EQUITY, EXPENSE, LIABILITY, REVENUE
STRING	source_relation	The source where this data was pulled from. If you are making use of the union_schemas variable, this will be the source schema. If you are making use of the union_databases variable, this will be the source database. If you are not unioining together multiple sources, this will be an empty string.
DECIMAL	net_amount	The net movement amount.