Balance by third party
curl --request GET \
--url https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance \
--header 'X-API-Key: <api-key>'const options = {method: 'GET', headers: {'X-API-Key': '<api-key>'}};
fetch('https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance"
headers = {"X-API-Key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}{
"status": true,
"data": {
"title": "Saldo por tercero",
"date_from": "01/10/2026",
"date_to": "31/10/2026",
"as_of_date": "2026-10-31",
"rows": [
{
"third_party_type": "customer",
"third_party_id": "9d1c5a3e-4b7f-4e2a-9c1d-2f6b8a0e7c11",
"third_party_name": "Distribuidora Sol",
"account_code": "1103",
"account_name": "Clientes",
"opening": 100,
"debit": 0,
"credit": 30,
"balance": 70
}
],
"totals": {
"opening": 100,
"debit": 0,
"credit": 30,
"balance": 70
},
"generated_at": "31/10/2026 18:20:05"
}
}{
"status": false,
"message": "Invalid API Key."
}{
"status": false,
"message": "This integration does not have the 'hr.employees' permission.",
"required_scope": "hr.employees"
}{
"status": false,
"message": "Third party not found for this integration."
}{
"status": false,
"message": "Validation errors",
"errors": {
"start_date": [
"The start date field is required."
]
}
}{
"status": false,
"message": "Rate limit exceeded. Please try again later.",
"rate_limit": 100
}Balance by third party
Debit, credit and balance by third party and account. Only PROCESSED journal entries and lines with a third party. balance = opening + debit - credit (positive: debit balance; negative: credit balance). With start_date, everything before it accumulates as opening; without it, all movement up to end_date counts as debit and credit. With format=pdf or format=excel it downloads the file.
Required permission: accounting.reports
GET
/
accounting
/
reports
/
third-party-balance
Balance by third party
curl --request GET \
--url https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance \
--header 'X-API-Key: <api-key>'const options = {method: 'GET', headers: {'X-API-Key': '<api-key>'}};
fetch('https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance"
headers = {"X-API-Key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.filexpress.app/api/external/v1/accounting/reports/third-party-balance",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}{
"status": true,
"data": {
"title": "Saldo por tercero",
"date_from": "01/10/2026",
"date_to": "31/10/2026",
"as_of_date": "2026-10-31",
"rows": [
{
"third_party_type": "customer",
"third_party_id": "9d1c5a3e-4b7f-4e2a-9c1d-2f6b8a0e7c11",
"third_party_name": "Distribuidora Sol",
"account_code": "1103",
"account_name": "Clientes",
"opening": 100,
"debit": 0,
"credit": 30,
"balance": 70
}
],
"totals": {
"opening": 100,
"debit": 0,
"credit": 30,
"balance": 70
},
"generated_at": "31/10/2026 18:20:05"
}
}{
"status": false,
"message": "Invalid API Key."
}{
"status": false,
"message": "This integration does not have the 'hr.employees' permission.",
"required_scope": "hr.employees"
}{
"status": false,
"message": "Third party not found for this integration."
}{
"status": false,
"message": "Validation errors",
"errors": {
"start_date": [
"The start date field is required."
]
}
}{
"status": false,
"message": "Rate limit exceeded. Please try again later.",
"rate_limit": 100
}