List Reports
/unified/accounting/reports
Query Parameters
Refer Specifying query parameters in Truto APIs
2 supported2 notes
The contact to filter the report by. Supported in aged_payable_detail (vendor only), aged_payable_summary, aged_receivable_detail (customer only), aged_receivable_summary (customer only), balance_sheet, cash_flow, customer_balance (customer only), customer_balance_detail (customer only), customer_income, general_ledger, general_ledger_fr, profit_and_loss, profit_and_loss_detail, sales_by_class (customer only), sales_by_customer (customer only), sales_by_department (customer only), sales_by_product (customer only), transaction_list, transaction_list_by_vendor (vendor only), transaction_list_by_customer (customer only), vendor_balance (vendor only), vendor_balance_detail (vendor only), vendor_expense
The contact to filter the report by. This field is required for aged_payable_by_contact and aged_receivable_by_contact.
The unique identifier for the contact
The type of the contact
customervendor
The end date of the report
1 supported2 notes
It should be given along with start_date. This field can be used in all reports except customer_balance and customer_balance_detail
The start date of the report
1 supported2 notes
It should be given along with end_date. This field can be used in all reports except customer_balance and customer_balance_detail
The type of the report
account_list_detailaged_payable_by_contactaged_payable_detailaged_payable_summaryaged_receivable_by_contactaged_receivable_detailaged_receivable_summarybalance_sheetbank_summarybudget_summarycash_flowcustomer_balancecustomer_balance_detailcustomer_incomeexecutive_summaryfec_reportgeneral_ledgergeneral_ledger_frinventory_valuation_summaryjournal_reportjournal_report_frprofit_and_lossprofit_and_loss_detailsales_by_classsales_by_customersales_by_departmentsales_by_producttax_summarytransaction_listtransaction_list_by_customertransaction_list_by_vendortransaction_list_with_splitstrial_balancetrial_balance_frvendor_balancevendor_balance_detailvendor_expense+ 25 more
2 supported2 required
profit_and_lossprofit_and_loss_detailaccount_list_detailaged_payable_detailaged_payable_summaryaged_receivable_detailaged_receivable_summarybalance_sheetcash_flowcustomer_balancecustomer_balance_detailcustomer_incomefec_reportgeneral_ledgergeneral_ledger_frinventory_valuation_summaryjournal_reportjournal_report_frsales_by_classsales_by_customersales_by_departmentsales_by_producttax_summarytransaction_listtransaction_list_by_vendortransaction_list_by_customertransaction_list_with_splitstrial_balancetrial_balance_frvendor_balancevendor_balance_detailvendor_expense+ 20 moreaged_payable_by_contactaged_receivable_by_contactbalance_sheetbank_summarybudget_summaryexecutive_summaryprofit_and_losstrial_balanceThe Tracking Category to filter the report. This can be fetched from the Unified Tracking Categories Resource. This is supported in the following report -- profit_and_loss (max 2 can be specified along with Tracking Category)
1 supported
Unique identifier for the Tracking Category.
The Tracking Category Options to filter the report. This can be fetched from the Unified Tracking Categories Resource. This is supported in the following reports -- balance_sheet (max 2 can be specified) and profit_and_loss (max 2 can be specified along with Tracking Category)
1 supported
Unique identifier for the Tracking Category Option.
Show Truto-specific parameters
The ID of the integrated account to use for the request.
62f44730-dd91-461e-bd6a-aedd9e0ad79dThe format of the response.
unifiedreturns the response with unified mappings applied.rawreturns the unprocessed, raw response from the remote API.normalizedapplies the unified mappings and returns the data in a normalized format.streamreturns the response as a stream, which is ideal for transmitting large datasets, files, or binary data. Using streaming mode helps to efficiently handle large payloads or real-time data flows without requiring the entire data to be buffered in memory.
Defaults to unified.
unifiedunifiedrawnormalizedstream
By default the result attribute is an array of objects. This parameter allows you to specify a field in each result objects to use as key, which transforms the result array into an object with the array items keyed by the field. This is useful for when you want to use the result as a lookup table.
idIgnores the limit query parameter.
Excludes the remote_data attribute from the response.
Array of fields to exclude from the response.
truto_exclude_fields[]=id&truto_exclude_fields[]=nameQuery parameters to pass to the underlying API without any transformations. Refer this guide to see how to structure the query parameters.
remote_query[foo]=barResponse Body
The cursor to use for the next page of results. Pass this value as next_cursor in the query parameter in the next request to get the next page of results.
List of Reports
The unique identifier for report
2 supported
This represents the date when the report was created
1 supported
The currency of the report
1 supported
The end date of the report
1 supported
The name of the report
2 supported
Raw data returned from the remote API call.
The data of the report
2 supported
2 properties
The columns of the report
The rows of the report
2 properties
The data of the row. The data is in the same order as the columns.
The sub-rows of the row. They have the same schema as the parent row.
The start date of the report
1 supported
curl -X GET 'https://api.truto.one/unified/accounting/reports?integrated_account_id=<integrated_account_id>' \
-H 'Authorization: Bearer <your_api_token>' \
-H 'Content-Type: application/json'const integratedAccountId = '<integrated_account_id>';
const response = await fetch(`https://api.truto.one/unified/accounting/reports?integrated_account_id=${integratedAccountId}`, {
method: 'GET',
headers: {
'Authorization': 'Bearer <your_api_token>',
'Content-Type': 'application/json',
},
});
const data = await response.json();
console.log(data);import requests
url = "https://api.truto.one/unified/accounting/reports"
headers = {
"Authorization": "Bearer <your_api_token>",
"Content-Type": "application/json",
}
params = {
"integrated_account_id": "<integrated_account_id>"
}
response = requests.get(url, headers=headers, params=params)
print(response.json())import Truto from '@truto/truto-ts-sdk';
const truto = new Truto({
token: '<your_api_token>',
});
const result = await truto.unifiedApi.list(
'accounting',
'reports',
{ integrated_account_id: '<integrated_account_id>' }
);
console.log(result);import asyncio
from truto_python_sdk import TrutoApi
truto_api = TrutoApi(token="<your_api_token>")
async def main():
async for item in truto_api.unified_api.list(
"accounting",
"reports",
{"integrated_account_id": "<integrated_account_id>"}
):
print(item)
asyncio.run(main())