Export statements to Excel
export_statements_xlsxWrite the household's income and expenditure statement and balance sheet for a period to one Excel file with a sheet each, grouped by their chart of accounts, which they can download from the Truo portal. Returns a receipt, never the figures: ask for income_and_expenditure or balance_sheet when the answer belongs in the conversation, and this when the answer is "give me the file". The balance sheet sheet names what it cannot see before any number, the same as the tool does. The file also has a Loans sheet when the household has told Truo about loans, or when Truo could not read them, and then the receipt's note says so. When it lists loans, it holds each loan's details, every statement or balance with the lines read from the statement, the rate changes, and the history of changes. The receipt lists the sheets the file holds.
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": {
"from": "<from>",
"to": "<to>"
},
"name": "export_statements_xlsx"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | Inclusive end of the period, ISO date (e.g. 2026-06-30). | |
| from | Yes | Inclusive start of the period, ISO date (e.g. 2026-06-01). | |
| compare-to | No | Optional comparative period end. | |
| compare-from | No | Optional comparative period start. Supply both compare dates or neither. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| exported | No |