Account projection
banana_projectionGet projected balances for accounts, groups, or balance classes using a start date, with optional period, frequency, and filter settings.
Instructions
Return the projection figure for an account, group or balance class. Requires projectionstart. Supports period, frequency and filter.
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": {
"account": "<account>",
"type": "<type>",
"projectionstart": "<projectionstart>"
},
"name": "banana_projection"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| doc | No | Accounting document name as opened in Banana (e.g. "accounting.ac2"). Append "_p1", "_p2" for previous years. Defaults to BANANA_DEFAULT_DOC if set. | |
| type | Yes | Amount type to return (opening, credit, debit, total, balance, *currency, rowcount). | |
| filter | No | JavaScript expression to filter transactions, e.g. filter=row.value("Date")==="2024-01-15". Available: row, rowNr, table. | |
| period | No | Period filter: an abbreviation like "Q1"/"3M"/"1Y" or a date range "2024-01-01/2024-03-31". | |
| account | Yes | Account/group/class selector: an account id ("1000"), group ("Gr=6"), balance class ("BClass=1"), or pipe-separated accounts ("1000|1010|1020"). | |
| frequency | No | Frequency: D=daily, W=weekly, M=monthly, Q=quarterly, S=semesterly, Y=yearly. | |
| projectionstart | Yes | Mandatory projection start: a period abbreviation ("Q1") or a date ("2024-07-01"). |