Profit & Loss (Accrual) Report
Production
Production
GET
/api2/reports/accounts_profit_accrual
/owner/reports/accounts_profit_accrual./owner/reports/profit is the cash basis version and runs on a different engine entirely. The two are toggle buttons on the same screen and their figures are not expected to agree. This endpoint reports accrual only; report.basis says so in every response.Size ceilings
| Bound | Default | When |
|---|---|---|
| Periods (columns) | 120 | no cost_center_id |
| Periods (columns) | 36 | any cost_center_id -- that filter switches the engine to a slower per-row query |
| Cells | 250,000 | always |
Request
Query Params
Header Params
Responses
Request Request Example
Shell
JavaScript
Java
Swift
curl --location '/api2/reports/accounts_profit_accrual?date_from=2025-01-01&date_to=2025-03-31&group_by_date=monthly&max_level=3&cost_center_id=&fy_id=&journals_branch_id=&accounts_branch=' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer ' \
--header 'apikey: ' \
--header 'Content-Type: application/json'Response Response Example
200 - Example 1
{
"result": "successful",
"code": 200,
"data": {
"report": {
"key": "accounts_profit_accrual",
"title": "string",
"basis": "accrual",
"currency": "string"
},
"filters": {
"date_from": "2019-08-24",
"date_to": "2019-08-24",
"group_by_date": "monthly",
"max_level": 0,
"cost_center_id": [
0
],
"fy_id": [
0
],
"journals_branch_id": [
0
],
"accounts_branch": 0,
"currency": "string",
"exclude_financial_year_journals": true
},
"columns": [
{
"key": "string",
"label": "string",
"group_by": "monthly",
"year": 0,
"month": 0,
"quarter": 0
}
],
"income": [
{
"node_id": "string",
"id": 0,
"kind": "category",
"code": "string",
"name": "string",
"level": 0,
"multiplier": 1,
"shows_value": true,
"has_children": true,
"truncated_children": true,
"periods": {
"property1": 0,
"property2": 0
},
"total": 0,
"children": [
{}
],
"children_subtotal": {
"label": "string",
"level": 0,
"periods": {
"property1": 0,
"property2": 0
},
"total": 0
}
}
],
"income_subtotal": {
"label": "string",
"level": 0,
"periods": {
"property1": 0,
"property2": 0
},
"total": 0
},
"expenses": [
{
"node_id": "string",
"id": 0,
"kind": "category",
"code": "string",
"name": "string",
"level": 0,
"multiplier": 1,
"shows_value": true,
"has_children": true,
"truncated_children": true,
"periods": {
"property1": 0,
"property2": 0
},
"total": 0,
"children": [
{}
],
"children_subtotal": {
"label": "string",
"level": 0,
"periods": {
"property1": 0,
"property2": 0
},
"total": 0
}
}
],
"expenses_subtotal": {
"label": "string",
"level": 0,
"periods": {
"property1": 0,
"property2": 0
},
"total": 0
},
"totals": {
"income": {
"periods": {
"property1": 0,
"property2": 0
},
"total": 0
},
"expenses": {
"periods": {
"property1": 0,
"property2": 0
},
"total": 0
},
"profit": {
"periods": {
"property1": 0,
"property2": 0
},
"total": 0
},
"as_displayed": {
"income": {
"periods": {
"property1": 0,
"property2": 0
},
"total": 0,
"type_multiplier": 1
},
"expenses": {
"periods": {
"property1": 0,
"property2": 0
},
"total": 0,
"type_multiplier": 1
}
}
},
"meta": {
"node_count": 0,
"column_count": 0,
"income_root_count": 0,
"expenses_root_count": 0,
"income_total_source_id": 0,
"expenses_total_source_id": 0
}
}
}