VAT balance
banana_vat_balanceGet the current VAT balance for any VAT code or group, supporting period, frequency, and custom transaction filters.
Instructions
Return the current VAT balance figure for a VAT code or VAT group. Supports period, frequency and filter.
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 | VAT amount type to return (taxable, amount, notdeductible, posted, 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". | |
| vat_code | Yes | VAT code ("V80"), group ("Gr=..."), or pipe-separated codes ("V0|V80"). | |
| frequency | No | Frequency: D=daily, W=weekly, M=monthly, Q=quarterly, S=semesterly, Y=yearly. |