Balance sheet
get_balance_sheetThe balance sheet: what the company owns and owes as balances up to one date (date_until), as a nested tree of account groups and accounts. Sign convention in the raw values: assets are POSITIVE, liabilities and equity NEGATIVE — that is how the report is built, not an error, so talk about amounts held or owed instead of reading a minus sign out loud. The passive side also carries three synthetic rows, identified by a string id: 'yearly_result' (the provisional result of the open accounting year(s), negated like the rest of the passive side, so a profit shows as a negative value), 'currency_revaluation' (unbooked foreign-currency revaluation) and 'total_passive' (liabilities and equity including those results). Set compare_date to add the second period and the difference. The tree is PRE-SUMMED by the server: a group row's values already include every account under it, so read a total off the group row itself and never add child rows up yourself. Every amount is an integer in CENTS of the company's home currency — divide by 100 and present francs with two decimals, never the raw integer. Each row has values.period_1 (the main period), plus values.period_2 and values.difference (period_1 - period_2) only when compare dates were sent.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"date_until": "<date_until>",
"company_id": "<company_id>"
},
"name": "get_balance_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| company_id | Yes | The company to work on — one of list_my_companies' company_id values. | |
| date_until | Yes | Report date, YYYY-MM-DD: balances of all bookings up to and including it. | |
| compare_date | No | Second report date, YYYY-MM-DD — adds period_2 and difference to every row. | |
| show_all_accounts | No | Include accounts with no bookings (zero balances). Leave off unless the user asks about an account that is missing. |