Budget interest
banana_budget_interestCalculate interest on budget transactions for an account, group, or class. Specify the interest rate, period, and frequency to get the computed amount.
Instructions
Return the calculated interest on an account/group/class for budget transactions.
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. | |
| rate | Yes | Interest rate in percent with a dot decimal separator, e.g. "2.5" or "-8.0". | |
| 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. |